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.PO_DOCUMENT_CANCEL_PVT dependencies on FND_MSG_PUB

Line 85: FND_MSG_PUB.initialize;

81:
82: BEGIN
83: -- Start standard API initialization
84: IF FND_API.to_boolean(p_init_msg_list) THEN
85: FND_MSG_PUB.initialize;
86: END IF;
87:
88: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
89: d_api_name, g_pkg_name) THEN

Line 199: FND_MSG_PUB.initialize;

195:
196: BEGIN
197: -- Start standard API initialization
198: IF FND_API.to_boolean(p_init_msg_list) THEN
199: FND_MSG_PUB.initialize;
200: END IF;
201:
202: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
203: d_api_name, g_pkg_name) THEN

Line 277: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

273: PO_DEBUG.debug_stmt(d_module, l_progress, 'Set l_partial_rcv_bld = 0');
274: END IF ;
275: WHEN OTHERS THEN
276: IF g_debug_stmt THEN
277: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
278: PO_DEBUG.debug_stmt(d_module, l_progress, 'Exception in isPartialRcvBilled check');
279: END IF ;
280: END ;
281:

Line 362: FND_MSG_PUB.initialize;

358:
359: BEGIN
360: -- Start standard API initialization
361: IF FND_API.to_boolean(p_init_msg_list) THEN
362: FND_MSG_PUB.initialize;
363: END IF;
364:
365: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
366: d_api_name, g_pkg_name) THEN

Line 476: x_msg_data := FND_MSG_PUB.GET(

472: END LOOP;
473:
474: EXCEPTION
475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
476: x_msg_data := FND_MSG_PUB.GET(
477: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
478: P_ENCODED => 'F');
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 477: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

473:
474: EXCEPTION
475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
476: x_msg_data := FND_MSG_PUB.GET(
477: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
478: P_ENCODED => 'F');
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
481:

Line 480: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

476: x_msg_data := FND_MSG_PUB.GET(
477: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
478: P_ENCODED => 'F');
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
481:
482: WHEN FND_API.G_EXC_ERROR THEN
483: x_msg_data := FND_MSG_PUB.GET(
484: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

Line 483: x_msg_data := FND_MSG_PUB.GET(

479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
481:
482: WHEN FND_API.G_EXC_ERROR THEN
483: x_msg_data := FND_MSG_PUB.GET(
484: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
485: P_ENCODED => 'F');
486: x_return_status := FND_API.G_RET_STS_ERROR;
487: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 484: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

480: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
481:
482: WHEN FND_API.G_EXC_ERROR THEN
483: x_msg_data := FND_MSG_PUB.GET(
484: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
485: P_ENCODED => 'F');
486: x_return_status := FND_API.G_RET_STS_ERROR;
487: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
488:

Line 487: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

483: x_msg_data := FND_MSG_PUB.GET(
484: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
485: P_ENCODED => 'F');
486: x_return_status := FND_API.G_RET_STS_ERROR;
487: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
488:
489: WHEN OTHERS THEN
490: IF (G_DEBUG_UNEXP) THEN
491: FND_LOG.STRING(

Line 496: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

492: FND_LOG.LEVEL_UNEXPECTED,
493: d_module || '.OTHERS_EXCEPTION',
494: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
495: END IF;
496: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
497:
498: x_msg_data := FND_MSG_PUB.GET(
499: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
500: P_ENCODED => 'F');

Line 498: x_msg_data := FND_MSG_PUB.GET(

494: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
495: END IF;
496: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
497:
498: x_msg_data := FND_MSG_PUB.GET(
499: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
500: P_ENCODED => 'F');
501: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
502:

Line 499: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

495: END IF;
496: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
497:
498: x_msg_data := FND_MSG_PUB.GET(
499: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
500: P_ENCODED => 'F');
501: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
502:
503: END init_recreate_demand_flag;

Line 549: FND_MSG_PUB.initialize;

545:
546: BEGIN
547: -- Start standard API initialization
548: IF FND_API.to_boolean(p_init_msg_list) THEN
549: FND_MSG_PUB.initialize;
550: END IF;
551:
552: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
553: d_api_name, g_pkg_name) THEN

Line 647: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

643: END IF;
644:
645: EXCEPTION
646: WHEN FND_API.g_exc_error THEN
647: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
648: x_return_status := FND_API.g_ret_sts_error;
649: WHEN FND_API.g_exc_unexpected_error THEN
650: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
651: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 650: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

646: WHEN FND_API.g_exc_error THEN
647: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
648: x_return_status := FND_API.g_ret_sts_error;
649: WHEN FND_API.g_exc_unexpected_error THEN
650: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
651: x_return_status := FND_API.g_ret_sts_unexp_error;
652: WHEN OTHERS THEN
653: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
654: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 653: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

649: WHEN FND_API.g_exc_unexpected_error THEN
650: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
651: x_return_status := FND_API.g_ret_sts_unexp_error;
652: WHEN OTHERS THEN
653: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
654: x_return_status := FND_API.g_ret_sts_unexp_error;
655: END denormPlannedPOQty;
656:
657: --------------------------------------------------------------------------------

Line 728: FND_MSG_PUB.initialize;

724:
725: BEGIN
726: -- Start standard API initialization
727: IF FND_API.to_boolean(p_init_msg_list) THEN
728: FND_MSG_PUB.initialize;
729: END IF;
730:
731: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
732: d_api_name, g_pkg_name) THEN

Line 847: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

843: EXCEPTION
844:
845: WHEN FND_API.g_exc_error THEN
846: x_return_status := FND_API.g_ret_sts_error;
847: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
848: WHEN FND_API.g_exc_unexpected_error THEN
849: x_return_status := FND_API.g_ret_sts_unexp_error;
850: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
851: WHEN OTHERS THEN

Line 850: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

846: x_return_status := FND_API.g_ret_sts_error;
847: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
848: WHEN FND_API.g_exc_unexpected_error THEN
849: x_return_status := FND_API.g_ret_sts_unexp_error;
850: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
851: WHEN OTHERS THEN
852: x_return_status := FND_API.g_ret_sts_unexp_error;
853: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
854: END update_dist_cancel;

Line 853: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

849: x_return_status := FND_API.g_ret_sts_unexp_error;
850: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
851: WHEN OTHERS THEN
852: x_return_status := FND_API.g_ret_sts_unexp_error;
853: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
854: END update_dist_cancel;
855:
856:
857: --------------------------------------------------------------------------------

Line 935: FND_MSG_PUB.initialize;

931:
932: BEGIN
933: -- Start standard API initialization
934: IF FND_API.to_boolean(p_init_msg_list) THEN
935: FND_MSG_PUB.initialize;
936: END IF;
937:
938: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
939: d_api_name, g_pkg_name) THEN

Line 1059: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

1055:
1056: EXCEPTION
1057: WHEN FND_API.g_exc_error THEN
1058: x_return_status := FND_API.g_ret_sts_error;
1059: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1060: WHEN FND_API.g_exc_unexpected_error THEN
1061: x_return_status := FND_API.g_ret_sts_unexp_error;
1062: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1063: WHEN OTHERS THEN

Line 1062: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

1058: x_return_status := FND_API.g_ret_sts_error;
1059: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1060: WHEN FND_API.g_exc_unexpected_error THEN
1061: x_return_status := FND_API.g_ret_sts_unexp_error;
1062: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1063: WHEN OTHERS THEN
1064: x_return_status := FND_API.g_ret_sts_unexp_error;
1065: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1066:

Line 1065: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

1061: x_return_status := FND_API.g_ret_sts_unexp_error;
1062: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1063: WHEN OTHERS THEN
1064: x_return_status := FND_API.g_ret_sts_unexp_error;
1065: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1066:
1067: END update_ship_cancel;
1068:
1069:

Line 1112: FND_MSG_PUB.initialize;

1108:
1109: BEGIN
1110: -- Start standard API initialization
1111: IF FND_API.to_boolean(p_init_msg_list) THEN
1112: FND_MSG_PUB.initialize;
1113: END IF;
1114:
1115: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
1116: d_api_name, g_pkg_name) THEN

Line 1221: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

1217:
1218: EXCEPTION
1219: WHEN FND_API.g_exc_error THEN
1220: x_return_status := FND_API.g_ret_sts_error;
1221: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1222: WHEN FND_API.g_exc_unexpected_error THEN
1223: x_return_status := FND_API.g_ret_sts_unexp_error;
1224: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1225: WHEN OTHERS THEN

Line 1224: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

1220: x_return_status := FND_API.g_ret_sts_error;
1221: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1222: WHEN FND_API.g_exc_unexpected_error THEN
1223: x_return_status := FND_API.g_ret_sts_unexp_error;
1224: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1225: WHEN OTHERS THEN
1226: x_return_status := FND_API.g_ret_sts_unexp_error;
1227: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1228:

Line 1227: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

1223: x_return_status := FND_API.g_ret_sts_unexp_error;
1224: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1225: WHEN OTHERS THEN
1226: x_return_status := FND_API.g_ret_sts_unexp_error;
1227: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1228:
1229: END update_line_qty_price_amt;
1230:
1231:

Line 1305: FND_MSG_PUB.initialize;

1301:
1302: BEGIN
1303: -- Start standard API initialization
1304: IF FND_API.to_boolean(p_init_msg_list) THEN
1305: FND_MSG_PUB.initialize;
1306: END IF;
1307:
1308: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
1309: d_api_name, g_pkg_name) THEN

Line 1418: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

1414:
1415: EXCEPTION
1416: WHEN FND_API.g_exc_error THEN
1417: x_return_status := FND_API.g_ret_sts_error;
1418: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1419: WHEN FND_API.g_exc_unexpected_error THEN
1420: x_return_status := FND_API.g_ret_sts_unexp_error;
1421: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1422: WHEN OTHERS THEN

Line 1421: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

1417: x_return_status := FND_API.g_ret_sts_error;
1418: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1419: WHEN FND_API.g_exc_unexpected_error THEN
1420: x_return_status := FND_API.g_ret_sts_unexp_error;
1421: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1422: WHEN OTHERS THEN
1423: x_return_status := FND_API.g_ret_sts_unexp_error;
1424: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1425:

Line 1424: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

1420: x_return_status := FND_API.g_ret_sts_unexp_error;
1421: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1422: WHEN OTHERS THEN
1423: x_return_status := FND_API.g_ret_sts_unexp_error;
1424: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1425:
1426: END update_line_cancel;
1427:
1428: --------------------------------------------------------------------------------

Line 1495: FND_MSG_PUB.initialize;

1491:
1492: BEGIN
1493: -- Start standard API initialization
1494: IF FND_API.to_boolean(p_init_msg_list) THEN
1495: FND_MSG_PUB.initialize;
1496: END IF;
1497:
1498: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
1499: d_api_name, g_pkg_name) THEN

Line 1561: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

1557:
1558: EXCEPTION
1559: WHEN FND_API.g_exc_error THEN
1560: x_return_status := FND_API.g_ret_sts_error;
1561: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1562: WHEN FND_API.g_exc_unexpected_error THEN
1563: x_return_status := FND_API.g_ret_sts_unexp_error;
1564: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1565: WHEN OTHERS THEN

Line 1564: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

1560: x_return_status := FND_API.g_ret_sts_error;
1561: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1562: WHEN FND_API.g_exc_unexpected_error THEN
1563: x_return_status := FND_API.g_ret_sts_unexp_error;
1564: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1565: WHEN OTHERS THEN
1566: x_return_status := FND_API.g_ret_sts_unexp_error;
1567: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1568:

Line 1567: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

1563: x_return_status := FND_API.g_ret_sts_unexp_error;
1564: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1565: WHEN OTHERS THEN
1566: x_return_status := FND_API.g_ret_sts_unexp_error;
1567: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1568:
1569: END update_po_header_cancel;
1570:
1571:

Line 1641: FND_MSG_PUB.initialize;

1637:
1638: BEGIN
1639: -- Start standard API initialization
1640: IF FND_API.to_boolean(p_init_msg_list) THEN
1641: FND_MSG_PUB.initialize;
1642: END IF;
1643:
1644: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
1645: d_api_name, g_pkg_name) THEN

Line 1709: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

1705: EXCEPTION
1706:
1707: WHEN FND_API.g_exc_error THEN
1708: x_return_status := FND_API.g_ret_sts_error;
1709: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1710: WHEN FND_API.g_exc_unexpected_error THEN
1711: x_return_status := FND_API.g_ret_sts_unexp_error;
1712: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1713: WHEN OTHERS THEN

Line 1712: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

1708: x_return_status := FND_API.g_ret_sts_error;
1709: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1710: WHEN FND_API.g_exc_unexpected_error THEN
1711: x_return_status := FND_API.g_ret_sts_unexp_error;
1712: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1713: WHEN OTHERS THEN
1714: x_return_status := FND_API.g_ret_sts_unexp_error;
1715: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1716:

Line 1715: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

1711: x_return_status := FND_API.g_ret_sts_unexp_error;
1712: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1713: WHEN OTHERS THEN
1714: x_return_status := FND_API.g_ret_sts_unexp_error;
1715: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
1716:
1717:
1718: END update_rel_header_cancel;
1719:

Line 1802: FND_MSG_PUB.initialize;

1798:
1799: BEGIN
1800: -- Start standard API initialization
1801: IF FND_API.to_boolean(p_init_msg_list) THEN
1802: FND_MSG_PUB.initialize;
1803: END IF;
1804:
1805: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
1806: d_api_name, g_pkg_name) THEN

Line 1997: x_msg_data := FND_MSG_PUB.GET(

1993:
1994:
1995: EXCEPTION
1996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1997: x_msg_data := FND_MSG_PUB.GET(
1998: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
1999: P_ENCODED => 'F');
2000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2001: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 1998: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

1994:
1995: EXCEPTION
1996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1997: x_msg_data := FND_MSG_PUB.GET(
1998: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
1999: P_ENCODED => 'F');
2000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2001: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2002:

Line 2001: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

1997: x_msg_data := FND_MSG_PUB.GET(
1998: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
1999: P_ENCODED => 'F');
2000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2001: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2002:
2003: WHEN FND_API.G_EXC_ERROR THEN
2004: x_msg_data := FND_MSG_PUB.GET(
2005: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

Line 2004: x_msg_data := FND_MSG_PUB.GET(

2000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2001: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2002:
2003: WHEN FND_API.G_EXC_ERROR THEN
2004: x_msg_data := FND_MSG_PUB.GET(
2005: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2006: P_ENCODED => 'F');
2007: x_return_status := FND_API.G_RET_STS_ERROR;
2008: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 2005: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

2001: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2002:
2003: WHEN FND_API.G_EXC_ERROR THEN
2004: x_msg_data := FND_MSG_PUB.GET(
2005: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2006: P_ENCODED => 'F');
2007: x_return_status := FND_API.G_RET_STS_ERROR;
2008: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2009:

Line 2008: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

2004: x_msg_data := FND_MSG_PUB.GET(
2005: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2006: P_ENCODED => 'F');
2007: x_return_status := FND_API.G_RET_STS_ERROR;
2008: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2009:
2010: WHEN OTHERS THEN
2011: IF (G_DEBUG_UNEXP) THEN
2012: FND_LOG.STRING(

Line 2018: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

2014: d_module || '.OTHERS_EXCEPTION',
2015: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
2016: END IF;
2017:
2018: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2019: x_msg_data := FND_MSG_PUB.GET(
2020: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2021: P_ENCODED => 'F');
2022: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 2019: x_msg_data := FND_MSG_PUB.GET(

2015: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
2016: END IF;
2017:
2018: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2019: x_msg_data := FND_MSG_PUB.GET(
2020: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2021: P_ENCODED => 'F');
2022: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2023:

Line 2020: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

2016: END IF;
2017:
2018: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2019: x_msg_data := FND_MSG_PUB.GET(
2020: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2021: P_ENCODED => 'F');
2022: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2023:
2024: END update_document;

Line 2085: FND_MSG_PUB.initialize;

2081:
2082: BEGIN
2083: -- Start standard API initialization
2084: IF FND_API.to_boolean(p_init_msg_list) THEN
2085: FND_MSG_PUB.initialize;
2086: END IF;
2087:
2088: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
2089: d_api_name, g_pkg_name) THEN

Line 2202: x_msg_data := FND_MSG_PUB.GET(

2198:
2199:
2200: EXCEPTION
2201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2202: x_msg_data := FND_MSG_PUB.GET(
2203: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2204: P_ENCODED => 'F');
2205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2206: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 2203: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

2199:
2200: EXCEPTION
2201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2202: x_msg_data := FND_MSG_PUB.GET(
2203: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2204: P_ENCODED => 'F');
2205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2206: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2207:

Line 2206: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

2202: x_msg_data := FND_MSG_PUB.GET(
2203: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2204: P_ENCODED => 'F');
2205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2206: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2207:
2208: WHEN FND_API.G_EXC_ERROR THEN
2209: x_msg_data := FND_MSG_PUB.GET(
2210: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

Line 2209: x_msg_data := FND_MSG_PUB.GET(

2205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2206: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2207:
2208: WHEN FND_API.G_EXC_ERROR THEN
2209: x_msg_data := FND_MSG_PUB.GET(
2210: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2211: P_ENCODED => 'F');
2212: x_return_status := FND_API.G_RET_STS_ERROR;
2213: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 2210: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

2206: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2207:
2208: WHEN FND_API.G_EXC_ERROR THEN
2209: x_msg_data := FND_MSG_PUB.GET(
2210: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2211: P_ENCODED => 'F');
2212: x_return_status := FND_API.G_RET_STS_ERROR;
2213: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2214:

Line 2213: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

2209: x_msg_data := FND_MSG_PUB.GET(
2210: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2211: P_ENCODED => 'F');
2212: x_return_status := FND_API.G_RET_STS_ERROR;
2213: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2214:
2215: WHEN OTHERS THEN
2216: IF (G_DEBUG_UNEXP) THEN
2217: FND_LOG.STRING(

Line 2223: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

2219: d_module || '.OTHERS_EXCEPTION',
2220: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
2221: END IF;
2222:
2223: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2224: x_msg_data := FND_MSG_PUB.GET(
2225: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2226: P_ENCODED => 'F');
2227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2224: x_msg_data := FND_MSG_PUB.GET(

2220: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
2221: END IF;
2222:
2223: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2224: x_msg_data := FND_MSG_PUB.GET(
2225: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2226: P_ENCODED => 'F');
2227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2228:

Line 2225: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

2221: END IF;
2222:
2223: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2224: x_msg_data := FND_MSG_PUB.GET(
2225: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2226: P_ENCODED => 'F');
2227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2228:
2229:

Line 2287: FND_MSG_PUB.initialize;

2283:
2284: BEGIN
2285: -- Start standard API initialization
2286: IF FND_API.to_boolean(p_init_msg_list) THEN
2287: FND_MSG_PUB.initialize;
2288: END IF;
2289:
2290: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
2291: d_api_name, g_pkg_name) THEN

Line 2337: x_msg_data := FND_MSG_PUB.GET(

2333: END IF;
2334:
2335: EXCEPTION
2336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2337: x_msg_data := FND_MSG_PUB.GET(
2338: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2339: P_ENCODED => 'F');
2340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2341: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 2338: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

2334:
2335: EXCEPTION
2336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2337: x_msg_data := FND_MSG_PUB.GET(
2338: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2339: P_ENCODED => 'F');
2340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2341: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2342: IF (g_debug_unexp) THEN

Line 2341: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

2337: x_msg_data := FND_MSG_PUB.GET(
2338: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2339: P_ENCODED => 'F');
2340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2341: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2342: IF (g_debug_unexp) THEN
2343: FND_LOG.string(FND_LOG.level_unexpected,d_module ||'---at '||l_progress || 'UnExpected Error', SQLERRM);
2344: END IF;
2345:

Line 2348: x_msg_data := FND_MSG_PUB.GET(

2344: END IF;
2345:
2346:
2347: WHEN FND_API.G_EXC_ERROR THEN
2348: x_msg_data := FND_MSG_PUB.GET(
2349: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2350: P_ENCODED => 'F');
2351: x_return_status := FND_API.G_RET_STS_ERROR;
2352: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 2349: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

2345:
2346:
2347: WHEN FND_API.G_EXC_ERROR THEN
2348: x_msg_data := FND_MSG_PUB.GET(
2349: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2350: P_ENCODED => 'F');
2351: x_return_status := FND_API.G_RET_STS_ERROR;
2352: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2353: IF (g_debug_unexp) THEN

Line 2352: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

2348: x_msg_data := FND_MSG_PUB.GET(
2349: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2350: P_ENCODED => 'F');
2351: x_return_status := FND_API.G_RET_STS_ERROR;
2352: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2353: IF (g_debug_unexp) THEN
2354: FND_LOG.string(FND_LOG.level_unexpected,d_module ||'---at '||l_progress || 'UnExpected Error', SQLERRM);
2355: END IF;
2356:

Line 2365: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

2361: FND_LOG.LEVEL_UNEXPECTED,
2362: d_module || '.OTHERS_EXCEPTION',
2363: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
2364: END IF;
2365: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2366: x_msg_data := FND_MSG_PUB.GET(
2367: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2368: P_ENCODED => 'F');
2369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2366: x_msg_data := FND_MSG_PUB.GET(

2362: d_module || '.OTHERS_EXCEPTION',
2363: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
2364: END IF;
2365: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2366: x_msg_data := FND_MSG_PUB.GET(
2367: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2368: P_ENCODED => 'F');
2369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2370:

Line 2367: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

2363: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
2364: END IF;
2365: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2366: x_msg_data := FND_MSG_PUB.GET(
2367: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2368: P_ENCODED => 'F');
2369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2370:
2371: END cancel_tax_lines;

Line 2434: FND_MSG_PUB.initialize;

2430:
2431: BEGIN
2432: -- Start standard API initialization
2433: IF FND_API.to_boolean(p_init_msg_list) THEN
2434: FND_MSG_PUB.initialize;
2435: END IF;
2436:
2437: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
2438: d_api_name, g_pkg_name) THEN

Line 2569: x_msg_data := FND_MSG_PUB.GET(

2565:
2566:
2567: EXCEPTION
2568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2569: x_msg_data := FND_MSG_PUB.GET(
2570: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2571: P_ENCODED => 'F');
2572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2573: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 2570: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

2566:
2567: EXCEPTION
2568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2569: x_msg_data := FND_MSG_PUB.GET(
2570: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2571: P_ENCODED => 'F');
2572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2573: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2574:

Line 2573: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

2569: x_msg_data := FND_MSG_PUB.GET(
2570: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2571: P_ENCODED => 'F');
2572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2573: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2574:
2575: WHEN FND_API.G_EXC_ERROR THEN
2576: x_msg_data := FND_MSG_PUB.GET(
2577: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

Line 2576: x_msg_data := FND_MSG_PUB.GET(

2572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2573: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2574:
2575: WHEN FND_API.G_EXC_ERROR THEN
2576: x_msg_data := FND_MSG_PUB.GET(
2577: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2578: P_ENCODED => 'F');
2579: x_return_status := FND_API.G_RET_STS_ERROR;
2580: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 2577: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

2573: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2574:
2575: WHEN FND_API.G_EXC_ERROR THEN
2576: x_msg_data := FND_MSG_PUB.GET(
2577: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2578: P_ENCODED => 'F');
2579: x_return_status := FND_API.G_RET_STS_ERROR;
2580: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2581:

Line 2580: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

2576: x_msg_data := FND_MSG_PUB.GET(
2577: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2578: P_ENCODED => 'F');
2579: x_return_status := FND_API.G_RET_STS_ERROR;
2580: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2581:
2582: WHEN OTHERS THEN
2583: IF (G_DEBUG_UNEXP) THEN
2584: FND_LOG.STRING(

Line 2589: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

2585: FND_LOG.LEVEL_UNEXPECTED,
2586: d_module || '.OTHERS_EXCEPTION',
2587: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
2588: END IF;
2589: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2590: x_msg_data := FND_MSG_PUB.GET(
2591: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2592: P_ENCODED => 'F');
2593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2590: x_msg_data := FND_MSG_PUB.GET(

2586: d_module || '.OTHERS_EXCEPTION',
2587: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
2588: END IF;
2589: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2590: x_msg_data := FND_MSG_PUB.GET(
2591: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2592: P_ENCODED => 'F');
2593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2594:

Line 2591: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

2587: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
2588: END IF;
2589: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2590: x_msg_data := FND_MSG_PUB.GET(
2591: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
2592: P_ENCODED => 'F');
2593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2594:
2595: END cancel_pending_change_request;

Line 2700: FND_MSG_PUB.initialize;

2696:
2697: BEGIN
2698: -- Start standard API initialization
2699: IF FND_API.to_boolean(p_init_msg_list) THEN
2700: FND_MSG_PUB.initialize;
2701: END IF;
2702:
2703: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
2704: d_api_name, g_pkg_name) THEN

Line 2758: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

2754:
2755: EXCEPTION
2756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2758: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2759: IF(G_DEBUG_UNEXP) THEN
2760: FND_LOG.STRING(
2761: FND_LOG.LEVEL_UNEXPECTED,
2762: d_module || '.UNEXPECTED',

Line 2769: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

2765:
2766:
2767: WHEN FND_API.G_EXC_ERROR THEN
2768: x_return_status := FND_API.G_RET_STS_ERROR;
2769: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2770: IF (G_DEBUG_UNEXP) THEN
2771: FND_LOG.STRING(
2772: FND_LOG.LEVEL_UNEXPECTED,
2773: d_module || '.ERROR ERROR',

Line 2784: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

2780: FND_LOG.LEVEL_UNEXPECTED,
2781: d_module || '.OTHERS_EXCEPTION',
2782: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE|| ' SQL ERRM IS '||SQLERRM);
2783: END IF;
2784: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2786:
2787: END fetch_req_lines;
2788:

Line 2828: FND_MSG_PUB.initialize;

2824:
2825: BEGIN
2826: -- Start standard API initialization
2827: IF FND_API.to_boolean(p_init_msg_list) THEN
2828: FND_MSG_PUB.initialize;
2829: END IF;
2830:
2831: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
2832: d_api_name, g_pkg_name) THEN

Line 2885: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

2881: IF g_debug_stmt THEN
2882: PO_DEBUG.debug_stmt(d_module, l_progress,'Set l_uom_conv = 0');
2883: END IF ;
2884: WHEN OTHERS THEN
2885: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2886: IF g_debug_stmt THEN
2887: PO_DEBUG.debug_stmt(d_module, l_progress,'Exception in calc_uom_conv check');
2888: END IF ;
2889:

Line 2928: FND_MSG_PUB.initialize;

2924:
2925: BEGIN
2926: -- Start standard API initialization
2927: IF FND_API.to_boolean(p_init_msg_list) THEN
2928: FND_MSG_PUB.initialize;
2929: END IF;
2930:
2931: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
2932: d_api_name, g_pkg_name) THEN

Line 2981: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

2977: IF g_debug_stmt THEN
2978: PO_DEBUG.debug_stmt(d_module, l_progress, 'Set p_qty_cancelled = 0');
2979: END IF ;
2980: WHEN OTHERS THEN
2981: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2982: IF g_debug_stmt THEN
2983: PO_DEBUG.debug_stmt(d_module, l_progress, 'Exception in calc_qty_canceled check');
2984: END IF ;
2985:

Line 3048: FND_MSG_PUB.initialize;

3044:
3045: BEGIN
3046: -- Start standard API initialization
3047: IF FND_API.to_boolean(p_init_msg_list) THEN
3048: FND_MSG_PUB.initialize;
3049: END IF;
3050:
3051: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
3052: d_api_name, g_pkg_name) THEN

Line 3350: x_msg_data := FND_MSG_PUB.GET(

3346: END IF;
3347:
3348: EXCEPTION
3349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3350: x_msg_data := FND_MSG_PUB.GET(
3351: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
3352: P_ENCODED => 'F');
3353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3354: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 3351: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

3347:
3348: EXCEPTION
3349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3350: x_msg_data := FND_MSG_PUB.GET(
3351: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
3352: P_ENCODED => 'F');
3353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3354: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
3355:

Line 3354: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

3350: x_msg_data := FND_MSG_PUB.GET(
3351: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
3352: P_ENCODED => 'F');
3353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3354: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
3355:
3356: WHEN FND_API.G_EXC_ERROR THEN
3357: x_msg_data := FND_MSG_PUB.GET(
3358: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

Line 3357: x_msg_data := FND_MSG_PUB.GET(

3353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3354: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
3355:
3356: WHEN FND_API.G_EXC_ERROR THEN
3357: x_msg_data := FND_MSG_PUB.GET(
3358: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
3359: P_ENCODED => 'F');
3360: x_return_status := FND_API.G_RET_STS_ERROR;
3361: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 3358: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

3354: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
3355:
3356: WHEN FND_API.G_EXC_ERROR THEN
3357: x_msg_data := FND_MSG_PUB.GET(
3358: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
3359: P_ENCODED => 'F');
3360: x_return_status := FND_API.G_RET_STS_ERROR;
3361: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
3362:

Line 3361: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

3357: x_msg_data := FND_MSG_PUB.GET(
3358: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
3359: P_ENCODED => 'F');
3360: x_return_status := FND_API.G_RET_STS_ERROR;
3361: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
3362:
3363: WHEN OTHERS THEN
3364: IF (G_DEBUG_UNEXP) THEN
3365: FND_LOG.STRING(

Line 3371: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

3367: d_module || '.OTHERS_EXCEPTION',
3368: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
3369: END IF;
3370:
3371: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
3372: x_msg_data := FND_MSG_PUB.GET(
3373: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
3374: P_ENCODED => 'F');
3375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3372: x_msg_data := FND_MSG_PUB.GET(

3368: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
3369: END IF;
3370:
3371: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
3372: x_msg_data := FND_MSG_PUB.GET(
3373: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
3374: P_ENCODED => 'F');
3375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3376:

Line 3373: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

3369: END IF;
3370:
3371: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
3372: x_msg_data := FND_MSG_PUB.GET(
3373: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
3374: P_ENCODED => 'F');
3375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3376:
3377:

Line 3422: FND_MSG_PUB.initialize;

3418:
3419: BEGIN
3420: -- Start standard API initialization
3421: IF FND_API.to_boolean(p_init_msg_list) THEN
3422: FND_MSG_PUB.initialize;
3423: END IF;
3424:
3425: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
3426: d_api_name, g_pkg_name) THEN

Line 3530: FND_MSG_PUB.initialize;

3526:
3527: BEGIN
3528: -- Start standard API initialization
3529: IF FND_API.to_boolean(p_init_msg_list) THEN
3530: FND_MSG_PUB.initialize;
3531: END IF;
3532:
3533: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
3534: d_api_name, g_pkg_name) THEN

Line 3802: x_msg_data := FND_MSG_PUB.GET(

3798:
3799:
3800: EXCEPTION
3801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3802: x_msg_data := FND_MSG_PUB.GET(
3803: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
3804: P_ENCODED => 'F');
3805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3806: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 3803: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

3799:
3800: EXCEPTION
3801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3802: x_msg_data := FND_MSG_PUB.GET(
3803: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
3804: P_ENCODED => 'F');
3805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3806: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
3807: WHEN FND_API.G_EXC_ERROR THEN

Line 3806: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

3802: x_msg_data := FND_MSG_PUB.GET(
3803: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
3804: P_ENCODED => 'F');
3805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3806: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
3807: WHEN FND_API.G_EXC_ERROR THEN
3808: x_msg_data := FND_MSG_PUB.GET(
3809: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
3810: P_ENCODED => 'F');

Line 3808: x_msg_data := FND_MSG_PUB.GET(

3804: P_ENCODED => 'F');
3805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3806: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
3807: WHEN FND_API.G_EXC_ERROR THEN
3808: x_msg_data := FND_MSG_PUB.GET(
3809: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
3810: P_ENCODED => 'F');
3811: x_return_status := FND_API.G_RET_STS_ERROR;
3812: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 3809: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

3805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3806: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
3807: WHEN FND_API.G_EXC_ERROR THEN
3808: x_msg_data := FND_MSG_PUB.GET(
3809: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
3810: P_ENCODED => 'F');
3811: x_return_status := FND_API.G_RET_STS_ERROR;
3812: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
3813: WHEN OTHERS THEN

Line 3812: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

3808: x_msg_data := FND_MSG_PUB.GET(
3809: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
3810: P_ENCODED => 'F');
3811: x_return_status := FND_API.G_RET_STS_ERROR;
3812: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
3813: WHEN OTHERS THEN
3814: IF (G_DEBUG_UNEXP) THEN
3815: FND_LOG.STRING(
3816: FND_LOG.LEVEL_UNEXPECTED,

Line 3820: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

3816: FND_LOG.LEVEL_UNEXPECTED,
3817: d_module || '.OTHERS_EXCEPTION',
3818: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
3819: END IF;
3820: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
3821: x_msg_data := FND_MSG_PUB.GET(
3822: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
3823: P_ENCODED => 'F');
3824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3821: x_msg_data := FND_MSG_PUB.GET(

3817: d_module || '.OTHERS_EXCEPTION',
3818: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
3819: END IF;
3820: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
3821: x_msg_data := FND_MSG_PUB.GET(
3822: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
3823: P_ENCODED => 'F');
3824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3825:

Line 3822: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

3818: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
3819: END IF;
3820: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
3821: x_msg_data := FND_MSG_PUB.GET(
3822: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
3823: P_ENCODED => 'F');
3824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3825:
3826: END create_req_line;

Line 3882: FND_MSG_PUB.initialize;

3878:
3879: BEGIN
3880: -- Start standard API initialization
3881: IF FND_API.to_boolean(p_init_msg_list) THEN
3882: FND_MSG_PUB.initialize;
3883: END IF;
3884:
3885: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
3886: d_api_name, g_pkg_name) THEN

Line 4067: x_msg_data := FND_MSG_PUB.GET(

4063: > 0) ;
4064:
4065: EXCEPTION
4066: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4067: x_msg_data := FND_MSG_PUB.GET(
4068: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4069: P_ENCODED => 'F');
4070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4071: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 4068: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

4064:
4065: EXCEPTION
4066: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4067: x_msg_data := FND_MSG_PUB.GET(
4068: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4069: P_ENCODED => 'F');
4070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4071: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4072: WHEN FND_API.G_EXC_ERROR THEN

Line 4071: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

4067: x_msg_data := FND_MSG_PUB.GET(
4068: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4069: P_ENCODED => 'F');
4070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4071: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4072: WHEN FND_API.G_EXC_ERROR THEN
4073: x_msg_data := FND_MSG_PUB.GET(
4074: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4075: P_ENCODED => 'F');

Line 4073: x_msg_data := FND_MSG_PUB.GET(

4069: P_ENCODED => 'F');
4070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4071: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4072: WHEN FND_API.G_EXC_ERROR THEN
4073: x_msg_data := FND_MSG_PUB.GET(
4074: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4075: P_ENCODED => 'F');
4076: x_return_status := FND_API.G_RET_STS_ERROR;
4077: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 4074: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

4070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4071: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4072: WHEN FND_API.G_EXC_ERROR THEN
4073: x_msg_data := FND_MSG_PUB.GET(
4074: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4075: P_ENCODED => 'F');
4076: x_return_status := FND_API.G_RET_STS_ERROR;
4077: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4078: WHEN OTHERS THEN

Line 4077: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

4073: x_msg_data := FND_MSG_PUB.GET(
4074: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4075: P_ENCODED => 'F');
4076: x_return_status := FND_API.G_RET_STS_ERROR;
4077: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4078: WHEN OTHERS THEN
4079: IF (G_DEBUG_UNEXP) THEN
4080: FND_LOG.STRING(
4081: FND_LOG.LEVEL_UNEXPECTED,

Line 4086: x_msg_data := FND_MSG_PUB.GET(

4082: d_module || '.OTHERS_EXCEPTION',
4083: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
4084: END IF;
4085:
4086: x_msg_data := FND_MSG_PUB.GET(
4087: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4088: P_ENCODED => 'F');
4089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4090: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 4087: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

4083: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
4084: END IF;
4085:
4086: x_msg_data := FND_MSG_PUB.GET(
4087: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4088: P_ENCODED => 'F');
4089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4090: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4091:

Line 4090: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

4086: x_msg_data := FND_MSG_PUB.GET(
4087: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4088: P_ENCODED => 'F');
4089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4090: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4091:
4092: END create_req_dist;
4093:
4094: --------------------------------------------------------------------------------

Line 4195: FND_MSG_PUB.initialize;

4191:
4192: BEGIN
4193: -- Start standard API initialization
4194: IF FND_API.to_boolean(p_init_msg_list) THEN
4195: FND_MSG_PUB.initialize;
4196: END IF;
4197:
4198: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
4199: d_api_name, g_pkg_name) THEN

Line 4618: x_msg_data := FND_MSG_PUB.GET(

4614: END LOOP;
4615:
4616: EXCEPTION
4617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4618: x_msg_data := FND_MSG_PUB.GET(
4619: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4620: P_ENCODED => 'F');
4621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4622: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 4619: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

4615:
4616: EXCEPTION
4617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4618: x_msg_data := FND_MSG_PUB.GET(
4619: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4620: P_ENCODED => 'F');
4621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4622: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4623: IF (g_debug_unexp) THEN

Line 4622: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

4618: x_msg_data := FND_MSG_PUB.GET(
4619: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4620: P_ENCODED => 'F');
4621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4622: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4623: IF (g_debug_unexp) THEN
4624: FND_LOG.STRING(
4625: FND_LOG.LEVEL_UNEXPECTED,
4626: d_module || '.Error',

Line 4632: x_msg_data := FND_MSG_PUB.GET(

4628: END IF;
4629:
4630:
4631: WHEN FND_API.G_EXC_ERROR THEN
4632: x_msg_data := FND_MSG_PUB.GET(
4633: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4634: P_ENCODED => 'F');
4635: x_return_status := FND_API.G_RET_STS_ERROR;
4636: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 4633: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

4629:
4630:
4631: WHEN FND_API.G_EXC_ERROR THEN
4632: x_msg_data := FND_MSG_PUB.GET(
4633: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4634: P_ENCODED => 'F');
4635: x_return_status := FND_API.G_RET_STS_ERROR;
4636: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4637: IF (g_debug_unexp) THEN

Line 4636: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

4632: x_msg_data := FND_MSG_PUB.GET(
4633: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4634: P_ENCODED => 'F');
4635: x_return_status := FND_API.G_RET_STS_ERROR;
4636: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4637: IF (g_debug_unexp) THEN
4638: FND_LOG.STRING(
4639: FND_LOG.LEVEL_UNEXPECTED,
4640: d_module || '.UnExpected',

Line 4651: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

4647: FND_LOG.LEVEL_UNEXPECTED,
4648: d_module || '.OTHERS',
4649: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
4650: END IF;
4651: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4652: x_msg_data := FND_MSG_PUB.GET(
4653: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4654: P_ENCODED => 'F');
4655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4652: x_msg_data := FND_MSG_PUB.GET(

4648: d_module || '.OTHERS',
4649: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
4650: END IF;
4651: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4652: x_msg_data := FND_MSG_PUB.GET(
4653: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4654: P_ENCODED => 'F');
4655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4656:

Line 4653: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

4649: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
4650: END IF;
4651: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4652: x_msg_data := FND_MSG_PUB.GET(
4653: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4654: P_ENCODED => 'F');
4655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4656:
4657:

Line 4728: FND_MSG_PUB.initialize;

4724:
4725: BEGIN
4726: -- Start standard API initialization
4727: IF FND_API.to_boolean(p_init_msg_list) THEN
4728: FND_MSG_PUB.initialize;
4729: END IF;
4730:
4731: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
4732: d_api_name, g_pkg_name) THEN

Line 4883: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

4879: END IF;
4880:
4881: EXCEPTION
4882: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4883: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4884: P_ENCODED => 'F');
4885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4886: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4887:

Line 4886: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

4882: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4883: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4884: P_ENCODED => 'F');
4885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4886: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4887:
4888: WHEN FND_API.G_EXC_ERROR THEN
4889: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4890: P_ENCODED => 'F');

Line 4889: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

4885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4886: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4887:
4888: WHEN FND_API.G_EXC_ERROR THEN
4889: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4890: P_ENCODED => 'F');
4891: x_return_status := FND_API.G_RET_STS_ERROR;
4892: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4893:

Line 4892: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

4888: WHEN FND_API.G_EXC_ERROR THEN
4889: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4890: P_ENCODED => 'F');
4891: x_return_status := FND_API.G_RET_STS_ERROR;
4892: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4893:
4894:
4895: WHEN OTHERS THEN
4896: IF (G_DEBUG_UNEXP) THEN

Line 4899: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

4895: WHEN OTHERS THEN
4896: IF (G_DEBUG_UNEXP) THEN
4897: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
4898: END IF;
4899: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4900: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4901: P_ENCODED => 'F');
4902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4903:

Line 4900: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

4896: IF (G_DEBUG_UNEXP) THEN
4897: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
4898: END IF;
4899: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4900: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4901: P_ENCODED => 'F');
4902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4903:
4904:

Line 4973: FND_MSG_PUB.initialize;

4969:
4970: BEGIN
4971: -- Start standard API initialization
4972: IF FND_API.to_boolean(p_init_msg_list) THEN
4973: FND_MSG_PUB.initialize;
4974: END IF;
4975:
4976: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
4977: d_api_name, g_pkg_name) THEN

Line 5057: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

5053: END IF;
5054:
5055: EXCEPTION
5056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5057: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5058: P_ENCODED => 'F');
5059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5060: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5061:

Line 5060: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

5056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5057: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5058: P_ENCODED => 'F');
5059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5060: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5061:
5062: WHEN FND_API.G_EXC_ERROR THEN
5063: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5064: P_ENCODED => 'F');

Line 5063: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

5059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5060: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5061:
5062: WHEN FND_API.G_EXC_ERROR THEN
5063: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5064: P_ENCODED => 'F');
5065: x_return_status := FND_API.G_RET_STS_ERROR;
5066: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5067:

Line 5066: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

5062: WHEN FND_API.G_EXC_ERROR THEN
5063: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5064: P_ENCODED => 'F');
5065: x_return_status := FND_API.G_RET_STS_ERROR;
5066: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5067:
5068: WHEN OTHERS THEN
5069: IF (G_DEBUG_UNEXP) THEN
5070: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);

Line 5073: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

5069: IF (G_DEBUG_UNEXP) THEN
5070: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
5071: END IF;
5072:
5073: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5074: P_ENCODED => 'F');
5075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5076: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5077:

Line 5076: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

5072:
5073: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5074: P_ENCODED => 'F');
5075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5076: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5077:
5078:
5079: END update_req_po_before_fc;
5080:

Line 5137: FND_MSG_PUB.initialize;

5133:
5134: BEGIN
5135: -- Start standard API initialization
5136: IF FND_API.to_boolean(p_init_msg_list) THEN
5137: FND_MSG_PUB.initialize;
5138: END IF;
5139:
5140: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
5141: d_api_name, g_pkg_name) THEN

Line 5215: x_msg_data := FND_MSG_PUB.GET(

5211: END IF;
5212:
5213: EXCEPTION
5214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5215: x_msg_data := FND_MSG_PUB.GET(
5216: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5217: P_ENCODED => 'F');
5218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5219: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 5216: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

5212:
5213: EXCEPTION
5214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5215: x_msg_data := FND_MSG_PUB.GET(
5216: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5217: P_ENCODED => 'F');
5218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5219: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5220:

Line 5219: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

5215: x_msg_data := FND_MSG_PUB.GET(
5216: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5217: P_ENCODED => 'F');
5218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5219: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5220:
5221:
5222: WHEN FND_API.G_EXC_ERROR THEN
5223: x_msg_data := FND_MSG_PUB.GET(

Line 5223: x_msg_data := FND_MSG_PUB.GET(

5219: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5220:
5221:
5222: WHEN FND_API.G_EXC_ERROR THEN
5223: x_msg_data := FND_MSG_PUB.GET(
5224: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5225: P_ENCODED => 'F');
5226: x_return_status := FND_API.G_RET_STS_ERROR;
5227: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 5224: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

5220:
5221:
5222: WHEN FND_API.G_EXC_ERROR THEN
5223: x_msg_data := FND_MSG_PUB.GET(
5224: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5225: P_ENCODED => 'F');
5226: x_return_status := FND_API.G_RET_STS_ERROR;
5227: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5228:

Line 5227: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

5223: x_msg_data := FND_MSG_PUB.GET(
5224: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5225: P_ENCODED => 'F');
5226: x_return_status := FND_API.G_RET_STS_ERROR;
5227: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5228:
5229: WHEN OTHERS THEN
5230: IF (g_debug_unexp) THEN
5231: FND_LOG.STRING(

Line 5236: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

5232: FND_LOG.LEVEL_UNEXPECTED,
5233: d_module || '.OTHERS',
5234: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
5235: END IF;
5236: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5237: x_msg_data := FND_MSG_PUB.GET(
5238: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5239: P_ENCODED => 'F');
5240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5237: x_msg_data := FND_MSG_PUB.GET(

5233: d_module || '.OTHERS',
5234: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
5235: END IF;
5236: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5237: x_msg_data := FND_MSG_PUB.GET(
5238: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5239: P_ENCODED => 'F');
5240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5241:

Line 5238: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

5234: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
5235: END IF;
5236: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5237: x_msg_data := FND_MSG_PUB.GET(
5238: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5239: P_ENCODED => 'F');
5240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5241:
5242:

Line 5323: FND_MSG_PUB.initialize;

5319:
5320: BEGIN
5321: -- Start standard API initialization
5322: IF FND_API.to_boolean(p_init_msg_list) THEN
5323: FND_MSG_PUB.initialize;
5324: END IF;
5325:
5326: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
5327: d_api_name, g_pkg_name) THEN

Line 5580: x_msg_data := FND_MSG_PUB.GET(

5576: END IF; -- IF p_entity_level = c_entity_level_HEADER
5577:
5578: EXCEPTION
5579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5580: x_msg_data := FND_MSG_PUB.GET(
5581: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5582: P_ENCODED => 'F');
5583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5584: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 5581: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

5577:
5578: EXCEPTION
5579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5580: x_msg_data := FND_MSG_PUB.GET(
5581: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5582: P_ENCODED => 'F');
5583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5584: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5585:

Line 5584: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

5580: x_msg_data := FND_MSG_PUB.GET(
5581: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5582: P_ENCODED => 'F');
5583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5584: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5585:
5586: WHEN FND_API.G_EXC_ERROR THEN
5587: x_msg_data := FND_MSG_PUB.GET(
5588: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

Line 5587: x_msg_data := FND_MSG_PUB.GET(

5583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5584: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5585:
5586: WHEN FND_API.G_EXC_ERROR THEN
5587: x_msg_data := FND_MSG_PUB.GET(
5588: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5589: P_ENCODED => 'F');
5590: x_return_status := FND_API.G_RET_STS_ERROR;
5591: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 5588: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

5584: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5585:
5586: WHEN FND_API.G_EXC_ERROR THEN
5587: x_msg_data := FND_MSG_PUB.GET(
5588: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5589: P_ENCODED => 'F');
5590: x_return_status := FND_API.G_RET_STS_ERROR;
5591: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5592: WHEN OTHERS THEN

Line 5591: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

5587: x_msg_data := FND_MSG_PUB.GET(
5588: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5589: P_ENCODED => 'F');
5590: x_return_status := FND_API.G_RET_STS_ERROR;
5591: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5592: WHEN OTHERS THEN
5593: IF (g_debug_unexp) THEN
5594: FND_LOG.STRING(
5595: FND_LOG.LEVEL_UNEXPECTED,

Line 5599: x_msg_data := FND_MSG_PUB.GET(

5595: FND_LOG.LEVEL_UNEXPECTED,
5596: d_module || '.OTHERS',
5597: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
5598: END IF;
5599: x_msg_data := FND_MSG_PUB.GET(
5600: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5601: P_ENCODED => 'F');
5602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5603: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 5600: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

5596: d_module || '.OTHERS',
5597: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
5598: END IF;
5599: x_msg_data := FND_MSG_PUB.GET(
5600: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5601: P_ENCODED => 'F');
5602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5603: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5604:

Line 5603: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

5599: x_msg_data := FND_MSG_PUB.GET(
5600: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5601: P_ENCODED => 'F');
5602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5603: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5604:
5605: END update_po_rev_archive;
5606:
5607: --------------------------------------------------------------------------------

Line 5667: FND_MSG_PUB.initialize;

5663:
5664: BEGIN
5665: -- Start standard API initialization
5666: IF FND_API.to_boolean(p_init_msg_list) THEN
5667: FND_MSG_PUB.initialize;
5668: END IF;
5669:
5670: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
5671: d_api_name, g_pkg_name) THEN

Line 5726: x_msg_data := FND_MSG_PUB.GET(

5722:
5723:
5724: EXCEPTION
5725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5726: x_msg_data := FND_MSG_PUB.GET(
5727: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5728: P_ENCODED => 'F');
5729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5730:

Line 5727: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

5723:
5724: EXCEPTION
5725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5726: x_msg_data := FND_MSG_PUB.GET(
5727: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5728: P_ENCODED => 'F');
5729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5730:
5731: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 5731: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

5727: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5728: P_ENCODED => 'F');
5729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5730:
5731: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5732:
5733: WHEN FND_API.G_EXC_ERROR THEN
5734: x_msg_data := FND_MSG_PUB.GET(
5735: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

Line 5734: x_msg_data := FND_MSG_PUB.GET(

5730:
5731: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5732:
5733: WHEN FND_API.G_EXC_ERROR THEN
5734: x_msg_data := FND_MSG_PUB.GET(
5735: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5736: P_ENCODED => 'F');
5737: x_return_status := FND_API.G_RET_STS_ERROR;
5738: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 5735: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

5731: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5732:
5733: WHEN FND_API.G_EXC_ERROR THEN
5734: x_msg_data := FND_MSG_PUB.GET(
5735: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5736: P_ENCODED => 'F');
5737: x_return_status := FND_API.G_RET_STS_ERROR;
5738: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5739:

Line 5738: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

5734: x_msg_data := FND_MSG_PUB.GET(
5735: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5736: P_ENCODED => 'F');
5737: x_return_status := FND_API.G_RET_STS_ERROR;
5738: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5739:
5740:
5741: WHEN OTHERS THEN
5742: IF (g_debug_unexp) THEN

Line 5748: x_msg_data := FND_MSG_PUB.GET(

5744: FND_LOG.LEVEL_UNEXPECTED,
5745: d_module || '.OTHERS',
5746: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
5747: END IF;
5748: x_msg_data := FND_MSG_PUB.GET(
5749: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5750: P_ENCODED => 'F');
5751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5752: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 5749: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

5745: d_module || '.OTHERS',
5746: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
5747: END IF;
5748: x_msg_data := FND_MSG_PUB.GET(
5749: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5750: P_ENCODED => 'F');
5751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5752: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5753: END update_closed_code;

Line 5752: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

5748: x_msg_data := FND_MSG_PUB.GET(
5749: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5750: P_ENCODED => 'F');
5751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5752: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5753: END update_closed_code;
5754:
5755: --------------------------------------------------------------------------------
5756: --Start of Comments

Line 5810: FND_MSG_PUB.initialize;

5806:
5807: BEGIN
5808: -- Start standard API initialization
5809: IF FND_API.to_boolean(p_init_msg_list) THEN
5810: FND_MSG_PUB.initialize;
5811: END IF;
5812:
5813: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
5814: d_api_name, g_pkg_name) THEN

Line 6121: x_msg_data := FND_MSG_PUB.GET(

6117:
6118:
6119: EXCEPTION
6120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6121: x_msg_data := FND_MSG_PUB.GET(
6122: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6123: P_ENCODED => 'F');
6124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6125: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 6122: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

6118:
6119: EXCEPTION
6120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6121: x_msg_data := FND_MSG_PUB.GET(
6122: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6123: P_ENCODED => 'F');
6124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6125: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6126: WHEN FND_API.G_EXC_ERROR THEN

Line 6125: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

6121: x_msg_data := FND_MSG_PUB.GET(
6122: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6123: P_ENCODED => 'F');
6124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6125: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6126: WHEN FND_API.G_EXC_ERROR THEN
6127: x_msg_data := FND_MSG_PUB.GET(
6128: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6129: P_ENCODED => 'F');

Line 6127: x_msg_data := FND_MSG_PUB.GET(

6123: P_ENCODED => 'F');
6124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6125: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6126: WHEN FND_API.G_EXC_ERROR THEN
6127: x_msg_data := FND_MSG_PUB.GET(
6128: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6129: P_ENCODED => 'F');
6130: x_return_status := FND_API.G_RET_STS_ERROR;
6131: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 6128: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

6124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6125: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6126: WHEN FND_API.G_EXC_ERROR THEN
6127: x_msg_data := FND_MSG_PUB.GET(
6128: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6129: P_ENCODED => 'F');
6130: x_return_status := FND_API.G_RET_STS_ERROR;
6131: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6132: WHEN OTHERS THEN

Line 6131: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

6127: x_msg_data := FND_MSG_PUB.GET(
6128: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6129: P_ENCODED => 'F');
6130: x_return_status := FND_API.G_RET_STS_ERROR;
6131: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6132: WHEN OTHERS THEN
6133: IF (g_debug_unexp) THEN
6134: FND_LOG.STRING(
6135: FND_LOG.LEVEL_UNEXPECTED,

Line 6139: x_msg_data := FND_MSG_PUB.GET(

6135: FND_LOG.LEVEL_UNEXPECTED,
6136: d_module || '.OTHERS',
6137: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
6138: END IF;
6139: x_msg_data := FND_MSG_PUB.GET(
6140: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6141: P_ENCODED => 'F');
6142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6143: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 6140: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

6136: d_module || '.OTHERS',
6137: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
6138: END IF;
6139: x_msg_data := FND_MSG_PUB.GET(
6140: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6141: P_ENCODED => 'F');
6142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6143: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6144:

Line 6143: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

6139: x_msg_data := FND_MSG_PUB.GET(
6140: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6141: P_ENCODED => 'F');
6142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6143: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6144:
6145: END process_cancel_action;
6146:
6147: --------------------------------------------------------------------------------

Line 6195: FND_MSG_PUB.initialize;

6191:
6192: BEGIN
6193: -- Start standard API initialization
6194: IF FND_API.to_boolean(p_init_msg_list) THEN
6195: FND_MSG_PUB.initialize;
6196: END IF;
6197:
6198: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
6199: d_api_name, g_pkg_name) THEN

Line 6244: x_msg_data := FND_MSG_PUB.GET(

6240:
6241: END LOOP;
6242: EXCEPTION
6243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6244: x_msg_data := FND_MSG_PUB.GET(
6245: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6246: P_ENCODED => 'F');
6247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6248: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 6245: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

6241: END LOOP;
6242: EXCEPTION
6243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6244: x_msg_data := FND_MSG_PUB.GET(
6245: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6246: P_ENCODED => 'F');
6247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6248: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6249:

Line 6248: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

6244: x_msg_data := FND_MSG_PUB.GET(
6245: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6246: P_ENCODED => 'F');
6247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6248: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6249:
6250: WHEN FND_API.G_EXC_ERROR THEN
6251: x_msg_data := FND_MSG_PUB.GET(
6252: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

Line 6251: x_msg_data := FND_MSG_PUB.GET(

6247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6248: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6249:
6250: WHEN FND_API.G_EXC_ERROR THEN
6251: x_msg_data := FND_MSG_PUB.GET(
6252: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6253: P_ENCODED => 'F');
6254: x_return_status := FND_API.G_RET_STS_ERROR;
6255: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 6252: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

6248: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6249:
6250: WHEN FND_API.G_EXC_ERROR THEN
6251: x_msg_data := FND_MSG_PUB.GET(
6252: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6253: P_ENCODED => 'F');
6254: x_return_status := FND_API.G_RET_STS_ERROR;
6255: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6256:

Line 6255: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

6251: x_msg_data := FND_MSG_PUB.GET(
6252: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6253: P_ENCODED => 'F');
6254: x_return_status := FND_API.G_RET_STS_ERROR;
6255: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6256:
6257: WHEN OTHERS THEN
6258: IF (G_DEBUG_UNEXP) THEN
6259: FND_LOG.STRING(

Line 6264: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

6260: FND_LOG.LEVEL_UNEXPECTED,
6261: d_module || '.OTHERS_EXCEPTION',
6262: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
6263: END IF;
6264: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6265: x_msg_data := FND_MSG_PUB.GET(
6266: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6267: P_ENCODED => 'F');
6268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6265: x_msg_data := FND_MSG_PUB.GET(

6261: d_module || '.OTHERS_EXCEPTION',
6262: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
6263: END IF;
6264: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6265: x_msg_data := FND_MSG_PUB.GET(
6266: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6267: P_ENCODED => 'F');
6268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6269:

Line 6266: P_MSG_INDEX => FND_MSG_PUB.G_LAST,

6262: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
6263: END IF;
6264: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6265: x_msg_data := FND_MSG_PUB.GET(
6266: P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6267: P_ENCODED => 'F');
6268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6269:
6270: END insrtEntityRecInSessiongt;

Line 6335: FND_MSG_PUB.initialize;

6331: BEGIN
6332:
6333: -- Start standard API initialization
6334: IF FND_API.to_boolean(p_init_msg_list) THEN
6335: FND_MSG_PUB.initialize;
6336: END IF;
6337:
6338: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
6339: d_api_name, g_pkg_name) THEN

Line 6494: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_api_name||':'||l_progress);

6490:
6491: EXCEPTION
6492: WHEN FND_API.g_exc_error THEN
6493: x_return_status := FND_API.g_ret_sts_error;
6494: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_api_name||':'||l_progress);
6495: ROLLBACK TO cancel_document_PVT;
6496: IF (g_debug_unexp) THEN
6497: FND_LOG.STRING(
6498: FND_LOG.LEVEL_UNEXPECTED,

Line 6504: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_api_name||':'||l_progress);

6500: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
6501: END IF;
6502: WHEN FND_API.g_exc_unexpected_error THEN
6503: x_return_status := FND_API.g_ret_sts_unexp_error;
6504: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_api_name||':'||l_progress);
6505: ROLLBACK TO cancel_document_PVT;
6506:
6507: IF (g_debug_unexp) THEN
6508: FND_LOG.STRING(

Line 6517: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_api_name||':'||l_progress);

6513:
6514:
6515: WHEN OTHERS THEN
6516: x_return_status := FND_API.g_ret_sts_unexp_error;
6517: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_api_name||':'||l_progress);
6518: ROLLBACK TO cancel_document_PVT;
6519:
6520: IF (g_debug_unexp) THEN
6521: FND_LOG.STRING(

Line 6622: FND_MSG_PUB.initialize;

6618: p_doc_id => p_doc_id)
6619: THEN
6620: -- Start standard API initialization
6621: IF FND_API.to_boolean(p_init_msg_list) THEN
6622: FND_MSG_PUB.initialize;
6623: END IF;
6624: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
6625: l_api_name, g_pkg_name)
6626: THEN

Line 6685: FND_MSG_PUB.add;

6681: FND_LOG.message(FND_LOG.level_error, g_module_prefix || l_api_name
6682: || '.cancel_req_disallowed', FALSE);
6683: END IF;
6684: END IF;
6685: FND_MSG_PUB.add;
6686: WHEN FND_API.g_exc_unexpected_error THEN
6687: x_return_status := FND_API.g_ret_sts_unexp_error;
6688: WHEN OTHERS THEN
6689: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 6690: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

6686: WHEN FND_API.g_exc_unexpected_error THEN
6687: x_return_status := FND_API.g_ret_sts_unexp_error;
6688: WHEN OTHERS THEN
6689: x_return_status := FND_API.g_ret_sts_unexp_error;
6690: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6691: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6692: IF (g_fnd_debug = 'Y') THEN
6693: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
6694: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

Line 6691: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

6687: x_return_status := FND_API.g_ret_sts_unexp_error;
6688: WHEN OTHERS THEN
6689: x_return_status := FND_API.g_ret_sts_unexp_error;
6690: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6691: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6692: IF (g_fnd_debug = 'Y') THEN
6693: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
6694: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
6695: l_api_name || '.others_exception', 'Exception');

Line 6799: FND_MSG_PUB.initialize;

6795:
6796: BEGIN
6797: -- Start standard API initialization
6798: IF FND_API.to_boolean(p_init_msg_list) THEN
6799: FND_MSG_PUB.initialize;
6800: END IF;
6801:
6802: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
6803: d_api_name, g_pkg_name) THEN

Line 6946: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

6942: EXCEPTION
6943:
6944: WHEN FND_API.g_exc_error THEN
6945: x_return_status := FND_API.g_ret_sts_error;
6946: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6947: WHEN FND_API.g_exc_unexpected_error THEN
6948: x_return_status := FND_API.g_ret_sts_unexp_error;
6949: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6950: WHEN OTHERS THEN

Line 6949: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

6945: x_return_status := FND_API.g_ret_sts_error;
6946: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6947: WHEN FND_API.g_exc_unexpected_error THEN
6948: x_return_status := FND_API.g_ret_sts_unexp_error;
6949: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6950: WHEN OTHERS THEN
6951: x_return_status := FND_API.g_ret_sts_unexp_error;
6952: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6953:

Line 6952: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

6948: x_return_status := FND_API.g_ret_sts_unexp_error;
6949: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6950: WHEN OTHERS THEN
6951: x_return_status := FND_API.g_ret_sts_unexp_error;
6952: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6953:
6954: END calculate_qty_cancel;
6955:
6956: