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.CST_SLA_UPDATE_PKG dependencies on FND_API

Line 142: IF NOT FND_API.Compatible_API_Call (

138: raise CST_UPGRADE_RUNNING;
139: end if;
140:
141: -- Standard call to check for call compatibility
142: IF NOT FND_API.Compatible_API_Call (
143: l_api_version,
144: X_api_version,
145: l_api_name,
146: G_PKG_NAME ) THEN

Line 147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

143: l_api_version,
144: X_api_version,
145: l_api_name,
146: G_PKG_NAME ) THEN
147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
148: END IF;
149:
150: req_data := fnd_conc_global.request_data;
151:

Line 161: IF FND_API.to_Boolean(X_init_msg_list) THEN

157:
158: if (submit_req = TRUE) then
159:
160: -- Initialize message list if X_init_msg_list is set to TRUE
161: IF FND_API.to_Boolean(X_init_msg_list) THEN
162: FND_MSG_PUB.initialize;
163: END IF;
164:
165:

Line 166: x_retcode := FND_API.G_RET_STS_SUCCESS;

162: FND_MSG_PUB.initialize;
163: END IF;
164:
165:
166: x_retcode := FND_API.G_RET_STS_SUCCESS;
167:
168: l_stmt_num :=10;
169: l_inv_req_id := FND_REQUEST.submit_request(
170: application => 'BOM',

Line 224: x_retcode := FND_API.G_RET_STS_SUCCESS;

220:
221: l_sub_reqtab := fnd_concurrent.get_sub_requests(
222: fnd_global.conc_request_id);
223:
224: x_retcode := FND_API.G_RET_STS_SUCCESS;
225:
226: for i IN 1..l_sub_reqtab.COUNT()
227: loop
228:

Line 230: X_retcode := FND_API.g_ret_sts_unexp_error;

226: for i IN 1..l_sub_reqtab.COUNT()
227: loop
228:
229: if (l_sub_reqtab(i).dev_status <> 'NORMAL') then
230: X_retcode := FND_API.g_ret_sts_unexp_error;
231: end if;
232:
233: end loop;
234:

Line 235: if (X_retcode = FND_API.G_RET_STS_SUCCESS) then

231: end if;
232:
233: end loop;
234:
235: if (X_retcode = FND_API.G_RET_STS_SUCCESS) then
236:
237: begin
238: l_ret_code := XLA_UPGRADE_PUB.set_migration_status_code(
239: p_application_id =>401,

Line 259: raise fnd_api.g_exc_unexpected_error;

255: when no_data_found then
256: null;
257: end;
258: else
259: raise fnd_api.g_exc_unexpected_error;
260: end if;
261:
262: commit;
263: end if;

Line 281: X_retcode := FND_API.g_ret_sts_unexp_error;

277:
278: EXCEPTION
279:
280: WHEN CST_UPGRADE_RUNNING THEN
281: X_retcode := FND_API.g_ret_sts_unexp_error;
282: IF l_exceptionlog THEN
283: fnd_msg_pub.add_exc_msg(
284: p_pkg_name => 'CST_SLA_UPDATE_PKG',
285: p_procedure_name => 'Update_Proc_MGR',

Line 298: X_retcode := FND_API.g_ret_sts_unexp_error;

294: X_errbuf:=l_module||'.'||l_stmt_num||': Another Costing Upgrade Manager is running.';
295: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
296:
297: WHEN submit_conc_failed THEN
298: X_retcode := FND_API.g_ret_sts_unexp_error;
299: IF l_exceptionlog THEN
300: fnd_msg_pub.add_exc_msg(
301: p_pkg_name => 'CST_SLA_UPDATE_PKG',
302: p_procedure_name => 'Update_Proc_MGR',

Line 314: WHEN fnd_api.g_exc_unexpected_error THEN

310: END IF;
311: X_errbuf:=l_module||'.'||l_stmt_num||': Submit concurrent request failed.';
312: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
313:
314: WHEN fnd_api.g_exc_unexpected_error THEN
315: X_retcode := FND_API.g_ret_sts_unexp_error;
316: IF l_exceptionlog THEN
317: fnd_msg_pub.add_exc_msg(
318: p_pkg_name => 'CST_SLA_UPDATE_PKG',

Line 315: X_retcode := FND_API.g_ret_sts_unexp_error;

311: X_errbuf:=l_module||'.'||l_stmt_num||': Submit concurrent request failed.';
312: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
313:
314: WHEN fnd_api.g_exc_unexpected_error THEN
315: X_retcode := FND_API.g_ret_sts_unexp_error;
316: IF l_exceptionlog THEN
317: fnd_msg_pub.add_exc_msg(
318: p_pkg_name => 'CST_SLA_UPDATE_PKG',
319: p_procedure_name => 'Update_Proc_MGR',

Line 331: WHEN fnd_api.g_exc_error THEN

327: END IF;
328: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
329: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
330:
331: WHEN fnd_api.g_exc_error THEN
332: X_retcode := FND_API.g_ret_sts_error;
333: IF l_errorLog THEN
334: fnd_message.set_name('BOM','CST_ERROR');
335: fnd_message.set_token('SQLERRM',SQLERRM);

Line 332: X_retcode := FND_API.g_ret_sts_error;

328: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
329: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
330:
331: WHEN fnd_api.g_exc_error THEN
332: X_retcode := FND_API.g_ret_sts_error;
333: IF l_errorLog THEN
334: fnd_message.set_name('BOM','CST_ERROR');
335: fnd_message.set_token('SQLERRM',SQLERRM);
336: fnd_msg_pub.add;

Line 347: X_retcode := FND_API.g_ret_sts_unexp_error;

343: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
344: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
345:
346: WHEN OTHERS THEN
347: X_retcode := FND_API.g_ret_sts_unexp_error;
348: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
349: fnd_message.set_name('BOM','CST_UNEXPECTED');
350: fnd_message.set_token('SQLERRM',SQLERRM);
351: fnd_msg_pub.add;

Line 449: IF NOT FND_API.Compatible_API_Call (

445: raise_application_error(-20001, 'SUBMIT_SUBREQUESTS() must be called from a concurrent request');
446: end if;
447:
448: -- Standard call to check for call compatibility
449: IF NOT FND_API.Compatible_API_Call (
450: l_api_version,
451: X_api_version,
452: l_api_name,
453: G_PKG_NAME ) THEN

Line 454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

450: l_api_version,
451: X_api_version,
452: l_api_name,
453: G_PKG_NAME ) THEN
454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
455: END IF;
456:
457: -- Initialize message list if X_init_msg_list is set to TRUE
458: IF FND_API.to_Boolean(X_init_msg_list) THEN

Line 458: IF FND_API.to_Boolean(X_init_msg_list) THEN

454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
455: END IF;
456:
457: -- Initialize message list if X_init_msg_list is set to TRUE
458: IF FND_API.to_Boolean(X_init_msg_list) THEN
459: FND_MSG_PUB.initialize;
460: END IF;
461:
462: x_retcode := FND_API.G_RET_STS_SUCCESS;

Line 462: x_retcode := FND_API.G_RET_STS_SUCCESS;

458: IF FND_API.to_Boolean(X_init_msg_list) THEN
459: FND_MSG_PUB.initialize;
460: END IF;
461:
462: x_retcode := FND_API.G_RET_STS_SUCCESS;
463:
464: --
465: -- get schema name of the table for ID range processing
466: --

Line 537: WHEN fnd_api.g_exc_unexpected_error THEN

533: END IF;
534:
535: EXCEPTION
536:
537: WHEN fnd_api.g_exc_unexpected_error THEN
538: X_retcode := FND_API.g_ret_sts_unexp_error;
539: IF l_exceptionlog THEN
540: fnd_msg_pub.add_exc_msg(
541: p_pkg_name => 'CST_SLA_UPDATE_PKG',

Line 538: X_retcode := FND_API.g_ret_sts_unexp_error;

534:
535: EXCEPTION
536:
537: WHEN fnd_api.g_exc_unexpected_error THEN
538: X_retcode := FND_API.g_ret_sts_unexp_error;
539: IF l_exceptionlog THEN
540: fnd_msg_pub.add_exc_msg(
541: p_pkg_name => 'CST_SLA_UPDATE_PKG',
542: p_procedure_name => 'Update_Proc_INV_MGR',

Line 554: WHEN fnd_api.g_exc_error THEN

550: END IF;
551: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
552: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
553:
554: WHEN fnd_api.g_exc_error THEN
555: X_retcode := FND_API.g_ret_sts_error;
556: IF l_errorLog THEN
557: fnd_message.set_name('BOM','CST_ERROR');
558: fnd_message.set_token('SQLERRM',SQLERRM);

Line 555: X_retcode := FND_API.g_ret_sts_error;

551: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
552: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
553:
554: WHEN fnd_api.g_exc_error THEN
555: X_retcode := FND_API.g_ret_sts_error;
556: IF l_errorLog THEN
557: fnd_message.set_name('BOM','CST_ERROR');
558: fnd_message.set_token('SQLERRM',SQLERRM);
559: fnd_msg_pub.add;

Line 570: X_retcode := FND_API.g_ret_sts_unexp_error;

566: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
567: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
568:
569: WHEN OTHERS THEN
570: X_retcode := FND_API.g_ret_sts_unexp_error;
571: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
572: fnd_message.set_name('BOM','CST_UNEXPECTED');
573: fnd_message.set_token('SQLERRM',SQLERRM);
574: fnd_msg_pub.add;

Line 672: IF NOT FND_API.Compatible_API_Call (

668: raise_application_error(-20001, 'SUBMIT_SUBREQUESTS() must be called from a concurrent request');
669: end if;
670:
671: -- Standard call to check for call compatibility
672: IF NOT FND_API.Compatible_API_Call (
673: l_api_version,
674: X_api_version,
675: l_api_name,
676: G_PKG_NAME ) THEN

Line 677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

673: l_api_version,
674: X_api_version,
675: l_api_name,
676: G_PKG_NAME ) THEN
677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
678: END IF;
679:
680: -- Initialize message list if X_init_msg_list is set to TRUE
681: IF FND_API.to_Boolean(X_init_msg_list) THEN

Line 681: IF FND_API.to_Boolean(X_init_msg_list) THEN

677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
678: END IF;
679:
680: -- Initialize message list if X_init_msg_list is set to TRUE
681: IF FND_API.to_Boolean(X_init_msg_list) THEN
682: FND_MSG_PUB.initialize;
683: END IF;
684:
685: x_retcode := FND_API.G_RET_STS_SUCCESS;

Line 685: x_retcode := FND_API.G_RET_STS_SUCCESS;

681: IF FND_API.to_Boolean(X_init_msg_list) THEN
682: FND_MSG_PUB.initialize;
683: END IF;
684:
685: x_retcode := FND_API.G_RET_STS_SUCCESS;
686:
687: --
688: -- get schema name of the table for ID range processing
689: --

Line 759: WHEN fnd_api.g_exc_unexpected_error THEN

755: END IF;
756:
757: EXCEPTION
758:
759: WHEN fnd_api.g_exc_unexpected_error THEN
760: X_retcode := FND_API.g_ret_sts_unexp_error;
761: IF l_exceptionlog THEN
762: fnd_msg_pub.add_exc_msg(
763: p_pkg_name => 'CST_SLA_UPDATE_PKG',

Line 760: X_retcode := FND_API.g_ret_sts_unexp_error;

756:
757: EXCEPTION
758:
759: WHEN fnd_api.g_exc_unexpected_error THEN
760: X_retcode := FND_API.g_ret_sts_unexp_error;
761: IF l_exceptionlog THEN
762: fnd_msg_pub.add_exc_msg(
763: p_pkg_name => 'CST_SLA_UPDATE_PKG',
764: p_procedure_name => 'Update_Proc_WIP_MGR',

Line 776: WHEN fnd_api.g_exc_error THEN

772: END IF;
773: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
774: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
775:
776: WHEN fnd_api.g_exc_error THEN
777: X_retcode := FND_API.g_ret_sts_error;
778: IF l_errorLog THEN
779: fnd_message.set_name('BOM','CST_ERROR');
780: fnd_message.set_token('SQLERRM',SQLERRM);

Line 777: X_retcode := FND_API.g_ret_sts_error;

773: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
774: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
775:
776: WHEN fnd_api.g_exc_error THEN
777: X_retcode := FND_API.g_ret_sts_error;
778: IF l_errorLog THEN
779: fnd_message.set_name('BOM','CST_ERROR');
780: fnd_message.set_token('SQLERRM',SQLERRM);
781: fnd_msg_pub.add;

Line 792: X_retcode := FND_API.g_ret_sts_unexp_error;

788: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
789: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
790:
791: WHEN OTHERS THEN
792: X_retcode := FND_API.g_ret_sts_unexp_error;
793: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
794: fnd_message.set_name('BOM','CST_UNEXPECTED');
795: fnd_message.set_token('SQLERRM',SQLERRM);
796: fnd_msg_pub.add;

Line 894: IF NOT FND_API.Compatible_API_Call (

890: raise_application_error(-20001, 'SUBMIT_SUBREQUESTS() must be called from a concurrent request');
891: end if;
892:
893: -- Standard call to check for call compatibility
894: IF NOT FND_API.Compatible_API_Call (
895: l_api_version,
896: X_api_version,
897: l_api_name,
898: G_PKG_NAME ) THEN

Line 899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

895: l_api_version,
896: X_api_version,
897: l_api_name,
898: G_PKG_NAME ) THEN
899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
900: END IF;
901:
902: -- Initialize message list if X_init_msg_list is set to TRUE
903: IF FND_API.to_Boolean(X_init_msg_list) THEN

Line 903: IF FND_API.to_Boolean(X_init_msg_list) THEN

899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
900: END IF;
901:
902: -- Initialize message list if X_init_msg_list is set to TRUE
903: IF FND_API.to_Boolean(X_init_msg_list) THEN
904: FND_MSG_PUB.initialize;
905: END IF;
906:
907: x_retcode := FND_API.G_RET_STS_SUCCESS;

Line 907: x_retcode := FND_API.G_RET_STS_SUCCESS;

903: IF FND_API.to_Boolean(X_init_msg_list) THEN
904: FND_MSG_PUB.initialize;
905: END IF;
906:
907: x_retcode := FND_API.G_RET_STS_SUCCESS;
908:
909: --
910: -- get schema name of the table for ID range processing
911: --

Line 980: WHEN fnd_api.g_exc_unexpected_error THEN

976: END IF;
977:
978: EXCEPTION
979:
980: WHEN fnd_api.g_exc_unexpected_error THEN
981: X_retcode := FND_API.g_ret_sts_unexp_error;
982: IF l_exceptionlog THEN
983: fnd_msg_pub.add_exc_msg(
984: p_pkg_name => 'CST_SLA_UPDATE_PKG',

Line 981: X_retcode := FND_API.g_ret_sts_unexp_error;

977:
978: EXCEPTION
979:
980: WHEN fnd_api.g_exc_unexpected_error THEN
981: X_retcode := FND_API.g_ret_sts_unexp_error;
982: IF l_exceptionlog THEN
983: fnd_msg_pub.add_exc_msg(
984: p_pkg_name => 'CST_SLA_UPDATE_PKG',
985: p_procedure_name => 'Update_Proc_RCV_MGR',

Line 997: WHEN fnd_api.g_exc_error THEN

993: END IF;
994: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
995: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
996:
997: WHEN fnd_api.g_exc_error THEN
998: X_retcode := FND_API.g_ret_sts_error;
999: IF l_errorLog THEN
1000: fnd_message.set_name('BOM','CST_ERROR');
1001: fnd_message.set_token('SQLERRM',SQLERRM);

Line 998: X_retcode := FND_API.g_ret_sts_error;

994: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
995: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
996:
997: WHEN fnd_api.g_exc_error THEN
998: X_retcode := FND_API.g_ret_sts_error;
999: IF l_errorLog THEN
1000: fnd_message.set_name('BOM','CST_ERROR');
1001: fnd_message.set_token('SQLERRM',SQLERRM);
1002: fnd_msg_pub.add;

Line 1013: X_retcode := FND_API.g_ret_sts_unexp_error;

1009: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
1010: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1011:
1012: WHEN OTHERS THEN
1013: X_retcode := FND_API.g_ret_sts_unexp_error;
1014: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
1015: fnd_message.set_name('BOM','CST_UNEXPECTED');
1016: fnd_message.set_token('SQLERRM',SQLERRM);
1017: fnd_msg_pub.add;

Line 1169: if (X_retcode <>FND_API.G_RET_STS_SUCCESS) then

1165: X_errbuf=>X_errbuf,
1166: X_retcode=>X_retcode,
1167: X_min_id=>l_start_id,
1168: X_max_id=>l_end_id);
1169: if (X_retcode <>FND_API.G_RET_STS_SUCCESS) then
1170: raise update_subledger_exception;
1171: end if;
1172:
1173: /*l_rows_processed := SQL%ROWCOUNT;*/

Line 1230: WHEN fnd_api.g_exc_unexpected_error THEN

1226: END IF;
1227: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
1228: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1229:
1230: WHEN fnd_api.g_exc_unexpected_error THEN
1231: ROLLBACK;
1232: X_retcode := FND_API.g_ret_sts_unexp_error;
1233: IF l_exceptionlog THEN
1234: fnd_msg_pub.add_exc_msg(

Line 1232: X_retcode := FND_API.g_ret_sts_unexp_error;

1228: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1229:
1230: WHEN fnd_api.g_exc_unexpected_error THEN
1231: ROLLBACK;
1232: X_retcode := FND_API.g_ret_sts_unexp_error;
1233: IF l_exceptionlog THEN
1234: fnd_msg_pub.add_exc_msg(
1235: p_pkg_name => 'CST_SLA_UPDATE_PKG',
1236: p_procedure_name => 'Update_Proc_INV_WKR',

Line 1248: WHEN fnd_api.g_exc_error THEN

1244: END IF;
1245: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
1246: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1247:
1248: WHEN fnd_api.g_exc_error THEN
1249: ROLLBACK;
1250: X_retcode := FND_API.g_ret_sts_error;
1251: IF l_errorLog THEN
1252: fnd_message.set_name('BOM','CST_ERROR');

Line 1250: X_retcode := FND_API.g_ret_sts_error;

1246: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1247:
1248: WHEN fnd_api.g_exc_error THEN
1249: ROLLBACK;
1250: X_retcode := FND_API.g_ret_sts_error;
1251: IF l_errorLog THEN
1252: fnd_message.set_name('BOM','CST_ERROR');
1253: fnd_message.set_token('SQLERRM',SQLERRM);
1254: fnd_msg_pub.add;

Line 1266: X_retcode := FND_API.g_ret_sts_unexp_error;

1262: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1263:
1264: WHEN OTHERS THEN
1265: ROLLBACK;
1266: X_retcode := FND_API.g_ret_sts_unexp_error;
1267: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
1268: fnd_message.set_name('BOM','CST_UNEXPECTED');
1269: fnd_message.set_token('SQLERRM',SQLERRM);
1270: fnd_msg_pub.add;

Line 1420: if (X_retcode <>FND_API.G_RET_STS_SUCCESS) then

1416: X_errbuf=>X_errbuf,
1417: X_retcode=>X_retcode,
1418: X_min_id=>l_start_id,
1419: X_max_id=>l_end_id);
1420: if (X_retcode <>FND_API.G_RET_STS_SUCCESS) then
1421: raise update_subledger_exception;
1422: end if;
1423:
1424: /*l_rows_processed := SQL%ROWCOUNT;*/

Line 1480: WHEN fnd_api.g_exc_unexpected_error THEN

1476: END IF;
1477: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
1478: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1479:
1480: WHEN fnd_api.g_exc_unexpected_error THEN
1481: ROLLBACK;
1482: X_retcode := FND_API.g_ret_sts_unexp_error;
1483: IF l_exceptionlog THEN
1484: fnd_msg_pub.add_exc_msg(

Line 1482: X_retcode := FND_API.g_ret_sts_unexp_error;

1478: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1479:
1480: WHEN fnd_api.g_exc_unexpected_error THEN
1481: ROLLBACK;
1482: X_retcode := FND_API.g_ret_sts_unexp_error;
1483: IF l_exceptionlog THEN
1484: fnd_msg_pub.add_exc_msg(
1485: p_pkg_name => 'CST_SLA_UPDATE_PKG',
1486: p_procedure_name => 'Update_Proc_WIP_WKR',

Line 1498: WHEN fnd_api.g_exc_error THEN

1494: END IF;
1495: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
1496: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1497:
1498: WHEN fnd_api.g_exc_error THEN
1499: ROLLBACK;
1500: X_retcode := FND_API.g_ret_sts_error;
1501: IF l_errorLog THEN
1502: fnd_message.set_name('BOM','CST_ERROR');

Line 1500: X_retcode := FND_API.g_ret_sts_error;

1496: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1497:
1498: WHEN fnd_api.g_exc_error THEN
1499: ROLLBACK;
1500: X_retcode := FND_API.g_ret_sts_error;
1501: IF l_errorLog THEN
1502: fnd_message.set_name('BOM','CST_ERROR');
1503: fnd_message.set_token('SQLERRM',SQLERRM);
1504: fnd_msg_pub.add;

Line 1516: X_retcode := FND_API.g_ret_sts_unexp_error;

1512: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1513:
1514: WHEN OTHERS THEN
1515: ROLLBACK;
1516: X_retcode := FND_API.g_ret_sts_unexp_error;
1517: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
1518: fnd_message.set_name('BOM','CST_UNEXPECTED');
1519: fnd_message.set_token('SQLERRM',SQLERRM);
1520: fnd_msg_pub.add;

Line 1693: if (X_retcode <>FND_API.G_RET_STS_SUCCESS) then

1689: X_errbuf=>X_errbuf,
1690: X_retcode=>X_retcode,
1691: X_min_id=>l_start_id,
1692: X_max_id=>l_end_id);
1693: if (X_retcode <>FND_API.G_RET_STS_SUCCESS) then
1694: raise update_subledger_exception;
1695: end if;
1696:
1697: /*l_rows_processed := SQL%ROWCOUNT;*/

Line 1753: WHEN fnd_api.g_exc_unexpected_error THEN

1749: END IF;
1750: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
1751: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1752:
1753: WHEN fnd_api.g_exc_unexpected_error THEN
1754: ROLLBACK;
1755: X_retcode := FND_API.g_ret_sts_unexp_error;
1756: IF l_exceptionlog THEN
1757: fnd_msg_pub.add_exc_msg(

Line 1755: X_retcode := FND_API.g_ret_sts_unexp_error;

1751: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1752:
1753: WHEN fnd_api.g_exc_unexpected_error THEN
1754: ROLLBACK;
1755: X_retcode := FND_API.g_ret_sts_unexp_error;
1756: IF l_exceptionlog THEN
1757: fnd_msg_pub.add_exc_msg(
1758: p_pkg_name => 'CST_SLA_UPDATE_PKG',
1759: p_procedure_name => 'Update_Proc_RCV_WKR',

Line 1771: WHEN fnd_api.g_exc_error THEN

1767: END IF;
1768: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
1769: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1770:
1771: WHEN fnd_api.g_exc_error THEN
1772: ROLLBACK;
1773: X_retcode := FND_API.g_ret_sts_error;
1774: IF l_errorLog THEN
1775: fnd_message.set_name('BOM','CST_ERROR');

Line 1773: X_retcode := FND_API.g_ret_sts_error;

1769: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1770:
1771: WHEN fnd_api.g_exc_error THEN
1772: ROLLBACK;
1773: X_retcode := FND_API.g_ret_sts_error;
1774: IF l_errorLog THEN
1775: fnd_message.set_name('BOM','CST_ERROR');
1776: fnd_message.set_token('SQLERRM',SQLERRM);
1777: fnd_msg_pub.add;

Line 1787: X_retcode := FND_API.g_ret_sts_unexp_error;

1783: END IF;
1784: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
1785: WHEN OTHERS THEN
1786: ROLLBACK;
1787: X_retcode := FND_API.g_ret_sts_unexp_error;
1788: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
1789: fnd_message.set_name('BOM','CST_UNEXPECTED');
1790: fnd_message.set_token('SQLERRM',SQLERRM);
1791: fnd_msg_pub.add;

Line 1870: x_retcode := FND_API.G_RET_STS_SUCCESS;

1866: header_id NUMBER,
1867: legal_entity number,
1868: org_id number) ON COMMIT DELETE ROWS';*/
1869:
1870: x_retcode := FND_API.G_RET_STS_SUCCESS;
1871:
1872: /* one (txn_id,org_id,txn_src_type_id) -> one entity_id -> one event_id -> one header_id */
1873: /* one mta line -> one xla_ae_line -> one xla_distribution_link */
1874:

Line 2576: WHEN fnd_api.g_exc_unexpected_error THEN

2572: END IF;
2573:
2574: EXCEPTION
2575:
2576: WHEN fnd_api.g_exc_unexpected_error THEN
2577: ROLLBACK;
2578: X_retcode := FND_API.g_ret_sts_unexp_error;
2579: IF l_exceptionlog THEN
2580: fnd_msg_pub.add_exc_msg(

Line 2578: X_retcode := FND_API.g_ret_sts_unexp_error;

2574: EXCEPTION
2575:
2576: WHEN fnd_api.g_exc_unexpected_error THEN
2577: ROLLBACK;
2578: X_retcode := FND_API.g_ret_sts_unexp_error;
2579: IF l_exceptionlog THEN
2580: fnd_msg_pub.add_exc_msg(
2581: p_pkg_name => 'CST_SLA_UPDATE_PKG',
2582: p_procedure_name => 'Update_Inventory_Subledger',

Line 2592: WHEN fnd_api.g_exc_error THEN

2588: 'An exception has occurred.'
2589: );
2590: END IF;
2591: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
2592: WHEN fnd_api.g_exc_error THEN
2593: ROLLBACK;
2594: X_retcode := FND_API.g_ret_sts_error;
2595: IF l_errorLog THEN
2596: fnd_message.set_name('BOM','CST_ERROR');

Line 2594: X_retcode := FND_API.g_ret_sts_error;

2590: END IF;
2591: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
2592: WHEN fnd_api.g_exc_error THEN
2593: ROLLBACK;
2594: X_retcode := FND_API.g_ret_sts_error;
2595: IF l_errorLog THEN
2596: fnd_message.set_name('BOM','CST_ERROR');
2597: fnd_message.set_token('SQLERRM',SQLERRM);
2598: fnd_msg_pub.add;

Line 2608: X_retcode := FND_API.g_ret_sts_unexp_error;

2604: END IF;
2605: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
2606: WHEN OTHERS THEN
2607: ROLLBACK;
2608: X_retcode := FND_API.g_ret_sts_unexp_error;
2609: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
2610: fnd_message.set_name('BOM','CST_UNEXPECTED');
2611: fnd_message.set_token('SQLERRM',SQLERRM);
2612: fnd_msg_pub.add;

Line 2676: x_retcode := FND_API.G_RET_STS_SUCCESS;

2672: select XLA_UPG_BATCHES_S.nextval into l_upg_batch_id from dual;
2673:
2674: l_je_category_name := 'WIP';
2675:
2676: x_retcode := FND_API.G_RET_STS_SUCCESS;
2677:
2678: /* one (txn_id,org_id,txn_src_type_id) -> one entity_id -> one event_id -> one header_id */
2679: /* one wta line -> one xla_ae_line -> one xla_distribution_link */
2680:

Line 3126: WHEN fnd_api.g_exc_unexpected_error THEN

3122: END IF;
3123:
3124: EXCEPTION
3125:
3126: WHEN fnd_api.g_exc_unexpected_error THEN
3127: ROLLBACK;
3128: X_retcode := FND_API.g_ret_sts_unexp_error;
3129: IF l_exceptionlog THEN
3130: fnd_msg_pub.add_exc_msg(

Line 3128: X_retcode := FND_API.g_ret_sts_unexp_error;

3124: EXCEPTION
3125:
3126: WHEN fnd_api.g_exc_unexpected_error THEN
3127: ROLLBACK;
3128: X_retcode := FND_API.g_ret_sts_unexp_error;
3129: IF l_exceptionlog THEN
3130: fnd_msg_pub.add_exc_msg(
3131: p_pkg_name => 'CST_SLA_UPDATE_PKG',
3132: p_procedure_name => 'Update_WIP_Subledger',

Line 3142: WHEN fnd_api.g_exc_error THEN

3138: 'An exception has occurred.'
3139: );
3140: END IF;
3141: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
3142: WHEN fnd_api.g_exc_error THEN
3143: ROLLBACK;
3144: X_retcode := FND_API.g_ret_sts_error;
3145: IF l_errorLog THEN
3146: fnd_message.set_name('BOM','CST_ERROR');

Line 3144: X_retcode := FND_API.g_ret_sts_error;

3140: END IF;
3141: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
3142: WHEN fnd_api.g_exc_error THEN
3143: ROLLBACK;
3144: X_retcode := FND_API.g_ret_sts_error;
3145: IF l_errorLog THEN
3146: fnd_message.set_name('BOM','CST_ERROR');
3147: fnd_message.set_token('SQLERRM',SQLERRM);
3148: fnd_msg_pub.add;

Line 3158: X_retcode := FND_API.g_ret_sts_unexp_error;

3154: END IF;
3155: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
3156: WHEN OTHERS THEN
3157: ROLLBACK;
3158: X_retcode := FND_API.g_ret_sts_unexp_error;
3159: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
3160: fnd_message.set_name('BOM','CST_UNEXPECTED');
3161: fnd_message.set_token('SQLERRM',SQLERRM);
3162: fnd_msg_pub.add;

Line 3231: x_retcode := FND_API.G_RET_STS_SUCCESS;

3227: select XLA_UPG_BATCHES_S.nextval into l_upg_batch_id from dual;
3228:
3229: l_je_category_name :='Receiving';
3230:
3231: x_retcode := FND_API.G_RET_STS_SUCCESS;
3232:
3233: SELECT MULTI_ORG_FLAG
3234: INTO l_multi_org_flag
3235: FROM FND_PRODUCT_GROUPS;

Line 3656: if (X_retcode <> FND_API.G_RET_STS_SUCCESS) then

3652: RCV_SLA_MRC_UPDATE_PKG.Update_Receiving_MRC_Subledger(X_errbuf => X_errbuf,
3653: X_retcode => X_retcode,
3654: X_upg_batch_id => l_upg_batch_id,
3655: X_je_category_name => l_je_category_name);
3656: if (X_retcode <> FND_API.G_RET_STS_SUCCESS) then
3657: raise CST_RCV_MRC_UPG_EXCEPTION;
3658: end if;
3659: end if;
3660:

Line 3677: X_retcode := FND_API.g_ret_sts_unexp_error;

3673: EXCEPTION
3674:
3675: WHEN CST_RCV_MRC_UPG_EXCEPTION THEN
3676: ROLLBACK;
3677: X_retcode := FND_API.g_ret_sts_unexp_error;
3678: IF l_exceptionlog THEN
3679: fnd_msg_pub.add_exc_msg(
3680: p_pkg_name => 'CST_SLA_UPDATE_PKG',
3681: p_procedure_name => 'Update_Receiving_Subledger',

Line 3692: WHEN fnd_api.g_exc_unexpected_error THEN

3688: );
3689: END IF;
3690: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred in upgrade of receiving MRC table..';
3691:
3692: WHEN fnd_api.g_exc_unexpected_error THEN
3693: ROLLBACK;
3694: X_retcode := FND_API.g_ret_sts_unexp_error;
3695: IF l_exceptionlog THEN
3696: fnd_msg_pub.add_exc_msg(

Line 3694: X_retcode := FND_API.g_ret_sts_unexp_error;

3690: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred in upgrade of receiving MRC table..';
3691:
3692: WHEN fnd_api.g_exc_unexpected_error THEN
3693: ROLLBACK;
3694: X_retcode := FND_API.g_ret_sts_unexp_error;
3695: IF l_exceptionlog THEN
3696: fnd_msg_pub.add_exc_msg(
3697: p_pkg_name => 'CST_SLA_UPDATE_PKG',
3698: p_procedure_name => 'Update_Receiving_Subledger',

Line 3708: WHEN fnd_api.g_exc_error THEN

3704: 'An exception has occurred.'
3705: );
3706: END IF;
3707: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
3708: WHEN fnd_api.g_exc_error THEN
3709: ROLLBACK;
3710: X_retcode := FND_API.g_ret_sts_error;
3711: IF l_errorLog THEN
3712: fnd_message.set_name('BOM','CST_ERROR');

Line 3710: X_retcode := FND_API.g_ret_sts_error;

3706: END IF;
3707: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
3708: WHEN fnd_api.g_exc_error THEN
3709: ROLLBACK;
3710: X_retcode := FND_API.g_ret_sts_error;
3711: IF l_errorLog THEN
3712: fnd_message.set_name('BOM','CST_ERROR');
3713: fnd_message.set_token('SQLERRM',SQLERRM);
3714: fnd_msg_pub.add;

Line 3724: X_retcode := FND_API.g_ret_sts_unexp_error;

3720: END IF;
3721: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
3722: WHEN OTHERS THEN
3723: ROLLBACK;
3724: X_retcode := FND_API.g_ret_sts_unexp_error;
3725: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
3726: fnd_message.set_name('BOM','CST_UNEXPECTED');
3727: fnd_message.set_token('SQLERRM',SQLERRM);
3728: fnd_msg_pub.add;