eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_DSP_HIERARCHY_QUERY_PVT dependencies on FND_MESSAGE

Line 175: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

171: p_data => x_msg_data,
172: p_encoded => 'F');
173:
174: WHEN OTHERS THEN
175: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
176: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
177: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
178: FND_MESSAGE.Set_Token('REASON', SQLERRM);
179: FND_MSG_PUB.Add;

Line 176: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

172: p_encoded => 'F');
173:
174: WHEN OTHERS THEN
175: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
176: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
177: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
178: FND_MESSAGE.Set_Token('REASON', SQLERRM);
179: FND_MSG_PUB.Add;
180:

Line 177: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

173:
174: WHEN OTHERS THEN
175: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
176: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
177: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
178: FND_MESSAGE.Set_Token('REASON', SQLERRM);
179: FND_MSG_PUB.Add;
180:
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 178: FND_MESSAGE.Set_Token('REASON', SQLERRM);

174: WHEN OTHERS THEN
175: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
176: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
177: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
178: FND_MESSAGE.Set_Token('REASON', SQLERRM);
179: FND_MSG_PUB.Add;
180:
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182:

Line 250: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

246: p_data => x_msg_data,
247: p_encoded => 'F');
248:
249: WHEN OTHERS THEN
250: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
251: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
252: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
253: FND_MESSAGE.Set_Token('REASON', SQLERRM);
254: FND_MSG_PUB.Add;

Line 251: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

247: p_encoded => 'F');
248:
249: WHEN OTHERS THEN
250: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
251: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
252: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
253: FND_MESSAGE.Set_Token('REASON', SQLERRM);
254: FND_MSG_PUB.Add;
255:

Line 252: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

248:
249: WHEN OTHERS THEN
250: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
251: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
252: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
253: FND_MESSAGE.Set_Token('REASON', SQLERRM);
254: FND_MSG_PUB.Add;
255:
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 253: FND_MESSAGE.Set_Token('REASON', SQLERRM);

249: WHEN OTHERS THEN
250: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
251: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
252: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
253: FND_MESSAGE.Set_Token('REASON', SQLERRM);
254: FND_MSG_PUB.Add;
255:
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257:

Line 370: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

366: p_data => x_msg_data,
367: p_encoded => 'F');
368:
369: WHEN OTHERS THEN
370: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
371: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
372: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
373: FND_MESSAGE.Set_Token('REASON', SQLERRM);
374: FND_MSG_PUB.Add;

Line 371: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

367: p_encoded => 'F');
368:
369: WHEN OTHERS THEN
370: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
371: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
372: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
373: FND_MESSAGE.Set_Token('REASON', SQLERRM);
374: FND_MSG_PUB.Add;
375:

Line 372: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

368:
369: WHEN OTHERS THEN
370: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
371: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
372: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
373: FND_MESSAGE.Set_Token('REASON', SQLERRM);
374: FND_MSG_PUB.Add;
375:
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 373: FND_MESSAGE.Set_Token('REASON', SQLERRM);

369: WHEN OTHERS THEN
370: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
371: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
372: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
373: FND_MESSAGE.Set_Token('REASON', SQLERRM);
374: FND_MSG_PUB.Add;
375:
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377:

Line 479: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_LOAD_CHILD_ITM_FOR_SCT');

475:
476: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
479: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_LOAD_CHILD_ITM_FOR_SCT');
480: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
481: FND_MSG_PUB.Add;
482: RAISE FND_API.G_EXC_ERROR;
483: END IF;

Line 480: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);

476: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
479: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_LOAD_CHILD_ITM_FOR_SCT');
480: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
481: FND_MSG_PUB.Add;
482: RAISE FND_API.G_EXC_ERROR;
483: END IF;
484:

Line 505: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_LOAD_CHILD_SCT_FOR_SCT');

501:
502: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
504: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
505: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_LOAD_CHILD_SCT_FOR_SCT');
506: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
507: FND_MSG_PUB.Add;
508: RAISE FND_API.G_EXC_ERROR;
509: END IF;

Line 506: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);

502: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
504: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
505: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_LOAD_CHILD_SCT_FOR_SCT');
506: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
507: FND_MSG_PUB.Add;
508: RAISE FND_API.G_EXC_ERROR;
509: END IF;
510:

Line 531: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

527: p_data => x_msg_data,
528: p_encoded => 'F');
529:
530: WHEN OTHERS THEN
531: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
532: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
533: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
534: FND_MESSAGE.Set_Token('REASON', SQLERRM);
535: FND_MSG_PUB.Add;

Line 532: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

528: p_encoded => 'F');
529:
530: WHEN OTHERS THEN
531: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
532: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
533: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
534: FND_MESSAGE.Set_Token('REASON', SQLERRM);
535: FND_MSG_PUB.Add;
536:

Line 533: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

529:
530: WHEN OTHERS THEN
531: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
532: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
533: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
534: FND_MESSAGE.Set_Token('REASON', SQLERRM);
535: FND_MSG_PUB.Add;
536:
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 534: FND_MESSAGE.Set_Token('REASON', SQLERRM);

530: WHEN OTHERS THEN
531: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
532: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
533: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
534: FND_MESSAGE.Set_Token('REASON', SQLERRM);
535: FND_MSG_PUB.Add;
536:
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538:

Line 638: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

634: p_data => x_msg_data,
635: p_encoded => 'F');
636:
637: WHEN OTHERS THEN
638: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
639: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
640: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
641: FND_MESSAGE.Set_Token('REASON', SQLERRM);
642: FND_MSG_PUB.Add;

Line 639: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

635: p_encoded => 'F');
636:
637: WHEN OTHERS THEN
638: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
639: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
640: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
641: FND_MESSAGE.Set_Token('REASON', SQLERRM);
642: FND_MSG_PUB.Add;
643:

Line 640: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

636:
637: WHEN OTHERS THEN
638: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
639: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
640: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
641: FND_MESSAGE.Set_Token('REASON', SQLERRM);
642: FND_MSG_PUB.Add;
643:
644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 641: FND_MESSAGE.Set_Token('REASON', SQLERRM);

637: WHEN OTHERS THEN
638: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
639: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
640: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
641: FND_MESSAGE.Set_Token('REASON', SQLERRM);
642: FND_MSG_PUB.Add;
643:
644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
645:

Line 742: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

738: p_data => x_msg_data,
739: p_encoded => 'F');
740:
741: WHEN OTHERS THEN
742: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
743: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
744: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
745: FND_MESSAGE.Set_Token('REASON', SQLERRM);
746: FND_MSG_PUB.Add;

Line 743: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

739: p_encoded => 'F');
740:
741: WHEN OTHERS THEN
742: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
743: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
744: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
745: FND_MESSAGE.Set_Token('REASON', SQLERRM);
746: FND_MSG_PUB.Add;
747:

Line 744: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

740:
741: WHEN OTHERS THEN
742: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
743: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
744: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
745: FND_MESSAGE.Set_Token('REASON', SQLERRM);
746: FND_MSG_PUB.Add;
747:
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 745: FND_MESSAGE.Set_Token('REASON', SQLERRM);

741: WHEN OTHERS THEN
742: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
743: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
744: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
745: FND_MESSAGE.Set_Token('REASON', SQLERRM);
746: FND_MSG_PUB.Add;
747:
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
749:

Line 926: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

922: p_data => x_msg_data,
923: p_encoded => 'F');
924:
925: WHEN OTHERS THEN
926: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
927: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
928: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
929: FND_MESSAGE.Set_Token('REASON', SQLERRM);
930: FND_MSG_PUB.Add;

Line 927: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

923: p_encoded => 'F');
924:
925: WHEN OTHERS THEN
926: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
927: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
928: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
929: FND_MESSAGE.Set_Token('REASON', SQLERRM);
930: FND_MSG_PUB.Add;
931:

Line 928: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

924:
925: WHEN OTHERS THEN
926: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
927: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
928: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
929: FND_MESSAGE.Set_Token('REASON', SQLERRM);
930: FND_MSG_PUB.Add;
931:
932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 929: FND_MESSAGE.Set_Token('REASON', SQLERRM);

925: WHEN OTHERS THEN
926: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
927: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
928: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
929: FND_MESSAGE.Set_Token('REASON', SQLERRM);
930: FND_MSG_PUB.Add;
931:
932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
933:

Line 1001: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

997: p_data => x_msg_data,
998: p_encoded => 'F');
999:
1000: WHEN OTHERS THEN
1001: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1002: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1003: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1004: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1005: FND_MSG_PUB.Add;

Line 1002: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

998: p_encoded => 'F');
999:
1000: WHEN OTHERS THEN
1001: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1002: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1003: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1004: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1005: FND_MSG_PUB.Add;
1006:

Line 1003: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

999:
1000: WHEN OTHERS THEN
1001: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1002: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1003: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1004: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1005: FND_MSG_PUB.Add;
1006:
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1004: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1000: WHEN OTHERS THEN
1001: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1002: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1003: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1004: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1005: FND_MSG_PUB.Add;
1006:
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008:

Line 1146: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

1142: p_data => x_msg_data,
1143: p_encoded => 'F');
1144:
1145: WHEN OTHERS THEN
1146: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1147: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1148: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1149: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1150: FND_MSG_PUB.Add;

Line 1147: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

1143: p_encoded => 'F');
1144:
1145: WHEN OTHERS THEN
1146: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1147: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1148: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1149: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1150: FND_MSG_PUB.Add;
1151:

Line 1148: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

1144:
1145: WHEN OTHERS THEN
1146: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1147: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1148: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1149: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1150: FND_MSG_PUB.Add;
1151:
1152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1149: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1145: WHEN OTHERS THEN
1146: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1147: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1148: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1149: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1150: FND_MSG_PUB.Add;
1151:
1152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1153:

Line 1379: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

1375: p_data => x_msg_data,
1376: p_encoded => 'F');
1377:
1378: WHEN OTHERS THEN
1379: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1380: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1381: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1382: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1383: FND_MSG_PUB.Add;

Line 1380: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

1376: p_encoded => 'F');
1377:
1378: WHEN OTHERS THEN
1379: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1380: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1381: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1382: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1383: FND_MSG_PUB.Add;
1384:

Line 1381: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

1377:
1378: WHEN OTHERS THEN
1379: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1380: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1381: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1382: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1383: FND_MSG_PUB.Add;
1384:
1385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1382: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1378: WHEN OTHERS THEN
1379: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1380: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1381: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1382: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1383: FND_MSG_PUB.Add;
1384:
1385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1386: