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

Line 25: g_msg_lvl_unexp_error NUMBER := fnd_msg_pub.g_msg_lvl_unexp_error;

21: g_op_drop_lpn_optional NUMBER := wms_globals.g_op_drop_lpn_optional;
22: g_ret_sts_success VARCHAR2(1) := fnd_api.g_ret_sts_success;
23: g_ret_sts_unexp_error VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
24: g_ret_sts_error VARCHAR2(1) := fnd_api.g_ret_sts_error;
25: g_msg_lvl_unexp_error NUMBER := fnd_msg_pub.g_msg_lvl_unexp_error;
26: g_msg_lvl_error NUMBER := fnd_msg_pub.g_msg_lvl_error;
27: g_version_printed BOOLEAN := FALSE;
28: g_pkg_name VARCHAR2(30) := 'WMS_ATF_RUNTIME_PUB_APIS';
29:

Line 26: g_msg_lvl_error NUMBER := fnd_msg_pub.g_msg_lvl_error;

22: g_ret_sts_success VARCHAR2(1) := fnd_api.g_ret_sts_success;
23: g_ret_sts_unexp_error VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
24: g_ret_sts_error VARCHAR2(1) := fnd_api.g_ret_sts_error;
25: g_msg_lvl_unexp_error NUMBER := fnd_msg_pub.g_msg_lvl_unexp_error;
26: g_msg_lvl_error NUMBER := fnd_msg_pub.g_msg_lvl_error;
27: g_version_printed BOOLEAN := FALSE;
28: g_pkg_name VARCHAR2(30) := 'WMS_ATF_RUNTIME_PUB_APIS';
29:
30: G_OP_TYPE_LOAD CONSTANT NUMBER := wms_globals.g_op_type_load;

Line 675: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN

671: WHEN OTHERS THEN
672:
673: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
674:
675: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
676: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
677: END IF; /* fnd_msg.... */
678:
679: fnd_msg_pub.count_and_get(

Line 676: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);

672:
673: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
674:
675: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
676: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
677: END IF; /* fnd_msg.... */
678:
679: fnd_msg_pub.count_and_get(
680: p_count => x_msg_count,

Line 679: fnd_msg_pub.count_and_get(

675: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
676: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
677: END IF; /* fnd_msg.... */
678:
679: fnd_msg_pub.count_and_get(
680: p_count => x_msg_count,
681: p_data => x_msg_data
682: );
683:

Line 987: -- fnd_msg_pub.ADD;

983: IF (l_debug = 1) THEN
984: print_debug('wms_atf_dest_locator.get_dest_locator failed: l_return_status = '|| l_return_status, l_module_name, 1);
985: END IF;
986: -- fnd_message.set_name('WMS', 'WMS_ATF_LOC_DETERM_FAILED');
987: -- fnd_msg_pub.ADD;
988:
989: SELECT wopv.operation_plan_name
990: INTO l_operation_plan_name
991: FROM wms_op_plans_vl wopv,

Line 998: fnd_msg_pub.ADD;

994: AND mmtt.operation_plan_id = wopv.operation_plan_id;
995:
996: fnd_message.set_name('WMS', 'DERIVE_DEST_SUGGESTIONS_FAILED');
997: fnd_message.set_token('OPERATION_PLAN_NAME', l_operation_plan_name);
998: fnd_msg_pub.ADD;
999:
1000: RAISE FND_API.G_EXC_ERROR;
1001:
1002: END IF;

Line 1010: -- fnd_msg_pub.ADD;

1006: IF (l_debug = 1) THEN
1007: print_debug('wms_atf_dest_locator.get_dest_locator returns NULL locator. ', l_module_name, 1);
1008: END IF;
1009: -- fnd_message.set_name('WMS', 'WMS_ATF_LOC_DETERM_FAILED');
1010: -- fnd_msg_pub.ADD;
1011:
1012: SELECT wopv.operation_plan_name
1013: INTO l_operation_plan_name
1014: FROM wms_op_plans_vl wopv,

Line 1021: fnd_msg_pub.ADD;

1017: AND mmtt.operation_plan_id = wopv.operation_plan_id;
1018:
1019: fnd_message.set_name('WMS', 'DERIVE_DEST_SUGGESTIONS_FAILED');
1020: fnd_message.set_token('OPERATION_PLAN_NAME', l_operation_plan_name);
1021: fnd_msg_pub.ADD;
1022:
1023: RAISE FND_API.G_EXC_ERROR;
1024:
1025: END IF;

Line 1351: fnd_msg_pub.ADD;

1347: print_debug('Suggested Sub does not satisfy Item Sub relationship',l_module_name,9);
1348: END IF;
1349:
1350: fnd_message.set_name('WMS','WMS_ATF_ITEM_SUBLOC_FAIL');
1351: fnd_msg_pub.ADD;
1352:
1353: CLOSE c_item_sub;
1354:
1355: RAISE fnd_api.g_exc_error;

Line 1381: fnd_msg_pub.ADD;

1377: print_debug('The suggested locator fails the Items locator validatation',l_module_name,9);
1378: END IF;
1379:
1380: fnd_message.set_name('WMS','WMS_ATF_ITEM_SUBLOC_FAIL');
1381: fnd_msg_pub.ADD;
1382:
1383: RAISE fnd_api.g_exc_error;
1384:
1385: END IF;

Line 1576: fnd_msg_pub.count_and_get(

1572: --When x_return_status = 'W', x_msg_data is already
1573: --set to the translated string, so you do not want
1574: --to override it here
1575: IF (x_return_status <> 'W') THEN
1576: fnd_msg_pub.count_and_get(
1577: p_count => x_msg_count,
1578: p_data => x_msg_data
1579: );
1580: END IF;

Line 1591: IF fnd_msg_pub.check_msg_level(g_msg_lvl_error) THEN

1587:
1588: WHEN FND_API.G_EXC_ERROR THEN
1589: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
1590:
1591: IF fnd_msg_pub.check_msg_level(g_msg_lvl_error) THEN
1592: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
1593: END IF; /* fnd_msg.... */
1594:
1595: IF (l_debug = 1) THEN

Line 1592: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);

1588: WHEN FND_API.G_EXC_ERROR THEN
1589: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
1590:
1591: IF fnd_msg_pub.check_msg_level(g_msg_lvl_error) THEN
1592: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
1593: END IF; /* fnd_msg.... */
1594:
1595: IF (l_debug = 1) THEN
1596: print_debug('Expected exception ', l_module_name, 1);

Line 1598: fnd_msg_pub.count_and_get(

1594:
1595: IF (l_debug = 1) THEN
1596: print_debug('Expected exception ', l_module_name, 1);
1597: END IF;
1598: fnd_msg_pub.count_and_get(
1599: p_count => x_msg_count,
1600: p_data => x_msg_data
1601: );
1602: x_error_code := SQLCODE;

Line 1634: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN

1630: WHEN OTHERS THEN
1631:
1632: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
1633:
1634: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
1635: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
1636: END IF; /* fnd_msg.... */
1637:
1638: IF (l_debug = 1) THEN

Line 1635: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);

1631:
1632: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
1633:
1634: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
1635: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
1636: END IF; /* fnd_msg.... */
1637:
1638: IF (l_debug = 1) THEN
1639: print_debug('Other exceptions ', l_module_name, 1);

Line 1642: fnd_msg_pub.count_and_get(

1638: IF (l_debug = 1) THEN
1639: print_debug('Other exceptions ', l_module_name, 1);
1640: END IF;
1641:
1642: fnd_msg_pub.count_and_get(
1643: p_count => x_msg_count,
1644: p_data => x_msg_data
1645: );
1646: x_error_code := SQLCODE;

Line 2451: IF fnd_msg_pub.check_msg_level(g_msg_lvl_error) THEN

2447: IF (l_debug=1) THEN
2448: print_debug('Expected Error at '||l_progress, l_module_name,1);
2449: END IF;
2450:
2451: IF fnd_msg_pub.check_msg_level(g_msg_lvl_error) THEN
2452: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
2453: END IF; /* fnd_msg.... */
2454:
2455: fnd_msg_pub.count_and_get(

Line 2452: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);

2448: print_debug('Expected Error at '||l_progress, l_module_name,1);
2449: END IF;
2450:
2451: IF fnd_msg_pub.check_msg_level(g_msg_lvl_error) THEN
2452: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
2453: END IF; /* fnd_msg.... */
2454:
2455: fnd_msg_pub.count_and_get(
2456: p_count => x_msg_count,

Line 2455: fnd_msg_pub.count_and_get(

2451: IF fnd_msg_pub.check_msg_level(g_msg_lvl_error) THEN
2452: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
2453: END IF; /* fnd_msg.... */
2454:
2455: fnd_msg_pub.count_and_get(
2456: p_count => x_msg_count,
2457: p_data => x_msg_data
2458: );
2459: --x_error_code := SQLCODE;

Line 2490: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN

2486: print_debug('Unexpected error at'||l_progress||' '||SQLERRM, l_module_name,1);
2487: END IF;
2488:
2489:
2490: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
2491: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
2492: END IF; /* fnd_msg.... */
2493:
2494: fnd_msg_pub.count_and_get(

Line 2491: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);

2487: END IF;
2488:
2489:
2490: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
2491: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
2492: END IF; /* fnd_msg.... */
2493:
2494: fnd_msg_pub.count_and_get(
2495: p_count => x_msg_count,

Line 2494: fnd_msg_pub.count_and_get(

2490: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
2491: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
2492: END IF; /* fnd_msg.... */
2493:
2494: fnd_msg_pub.count_and_get(
2495: p_count => x_msg_count,
2496: p_data => x_msg_data
2497: );
2498: --x_error_code := SQLCODE;

Line 2772: fnd_msg_pub.ADD;

2768: IF (l_debug = 1) THEN
2769: print_debug('Operation instance record does not exist for this task.',l_module_name,4);
2770: END IF;
2771: fnd_message.set_name('WMS', 'WMS_ATF_NO_ACTIVE_PLAN');
2772: fnd_msg_pub.ADD;
2773: RAISE FND_API.G_EXC_ERROR;
2774: END IF;
2775:
2776: CLOSE c_wooi_data_rec;

Line 2842: fnd_msg_pub.ADD;

2838: IF (l_debug=1) THEN
2839: print_debug('Invalid WDT status.' ,l_module_name,4);
2840: END IF;
2841: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
2842: fnd_msg_pub.ADD;
2843: RAISE FND_API.G_EXC_ERROR;
2844: END IF; -- IF l_wdt_status NOT IN (g_task_status_loaded, g_task_status_dispatched)
2845:
2846: END IF; -- IF p_activity_id = g_op_activity_inbound

Line 2912: fnd_msg_pub.ADD;

2908: IF (l_debug=1) THEN
2909: print_debug('wms_op_runtime_pvt_apis.archive_dispatched_tasks finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2910: END IF;
2911: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');
2912: fnd_msg_pub.ADD;
2913: RAISE FND_API.G_EXC_ERROR;
2914: END IF;
2915:
2916: ELSIF p_operation_type_id IS NULL OR p_operation_type_id = g_op_type_load THEN

Line 2946: fnd_msg_pub.ADD;

2942: IF (l_debug=1) THEN
2943: print_debug('Current operation ('|| p_operation_type_id ||') is not compatible with WDT status of dispatched.' ,l_module_name,4);
2944: END IF;
2945: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
2946: fnd_msg_pub.ADD;
2947: RAISE FND_API.G_EXC_ERROR;
2948:
2949: END IF; -- IF p_operation_type_id = g_op_type_inspect
2950:

Line 3001: fnd_msg_pub.ADD;

2997: IF (l_debug=1) THEN
2998: print_debug('Drop - wms_op_runtime_pvt_apis.archive_dispatched_tasks finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2999: END IF;
3000: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');
3001: fnd_msg_pub.ADD;
3002: RAISE FND_API.G_EXC_ERROR;
3003: END IF;
3004:
3005: ELSE -- l_wdt_status = g_task_status_dispatched (not dispatched or loaded)

Line 3011: fnd_msg_pub.ADD;

3007: IF (l_debug=1) THEN
3008: print_debug('Invalid WDT status.' ,l_module_name,4);
3009: END IF;
3010: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
3011: fnd_msg_pub.ADD;
3012: RAISE FND_API.G_EXC_ERROR;
3013:
3014:
3015: END IF; -- IF l_wdt_status = g_task_status_dispatched

Line 3085: fnd_msg_pub.ADD;

3081: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3082: END IF;
3083:
3084: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3085: fnd_msg_pub.ADD;
3086: RAISE fnd_api.g_exc_unexpected_error;
3087: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3088: IF (l_debug = 1) THEN
3089: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);

Line 3093: fnd_msg_pub.ADD;

3089: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3090: END IF;
3091:
3092: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3093: fnd_msg_pub.ADD;
3094: RAISE fnd_api.g_exc_error;
3095: END IF;
3096: --bug 6924639
3097: /*

Line 3129: fnd_msg_pub.ADD;

3125: IF (l_debug = 1) THEN
3126: print_debug('Operation type on operation instance : '||l_wooi_data_rec.operation_type_id||' does not match that passed in by user : '||l_operation_type_id, l_module_name,4);
3127: END IF;
3128: fnd_message.set_name('WMS', 'WMS_ATF_OPERATION_MISMATCH');
3129: fnd_msg_pub.ADD;
3130: RAISE FND_API.G_EXC_ERROR;
3131: END IF;
3132:
3133: IF (l_debug=1) THEN

Line 3311: fnd_msg_pub.ADD;

3307: IF (l_debug=1) THEN
3308: print_debug('Invalid locator determination method.',l_module_name,4);
3309: END IF;
3310: fnd_message.set_name('WMS', 'WMS_ATF_LOC_DET_NOT_DEFINED');
3311: fnd_msg_pub.ADD;
3312: RAISE FND_API.G_EXC_ERROR;
3313:
3314: END IF; -- IF NVL(l_loc_sel_criteria_id, 0) = wms_globals.G_OP_DEST_PRE_SPECIFIED
3315:

Line 3399: fnd_msg_pub.ADD;

3395: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3396: END IF;
3397:
3398: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3399: fnd_msg_pub.ADD;
3400: RAISE fnd_api.g_exc_unexpected_error;
3401: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3402: IF (l_debug = 1) THEN
3403: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);

Line 3407: fnd_msg_pub.ADD;

3403: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3404: END IF;
3405:
3406: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3407: fnd_msg_pub.ADD;
3408: RAISE fnd_api.g_exc_error;
3409: END IF;
3410: --bug 6924639
3411: /*

Line 3551: fnd_msg_pub.ADD;

3547: IF (l_debug=1) THEN
3548: print_debug('Last operation: archive parent MMTT - wms_op_runtime_pvt_apis.archive_dispatched_tasks finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3549: END IF;
3550: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');
3551: fnd_msg_pub.ADD;
3552: RAISE FND_API.G_EXC_ERROR;
3553: END IF;
3554:
3555: IF (l_debug=1) THEN

Line 3642: fnd_msg_pub.ADD;

3638: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3639: END IF;
3640:
3641: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3642: fnd_msg_pub.ADD;
3643: RAISE fnd_api.g_exc_unexpected_error;
3644: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3645: IF (l_debug = 1) THEN
3646: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);

Line 3650: fnd_msg_pub.ADD;

3646: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3647: END IF;
3648:
3649: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3650: fnd_msg_pub.ADD;
3651: RAISE fnd_api.g_exc_error;
3652: END IF;
3653: --bug 6924639
3654: /*

Line 3681: fnd_msg_pub.ADD;

3677: print_debug('Current operation does not have a next operation.' ,l_module_name,4);
3678: END IF;
3679:
3680: fnd_message.set_name('WMS', 'WMS_ATF_NO_NEXT_OPERATION');
3681: fnd_msg_pub.ADD;
3682:
3683: RAISE FND_API.G_EXC_ERROR;
3684:
3685: END IF;

Line 3787: fnd_msg_pub.ADD;

3783: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3784: END IF;
3785:
3786: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3787: fnd_msg_pub.ADD;
3788: RAISE fnd_api.g_exc_unexpected_error;
3789: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3790: IF (l_debug = 1) THEN
3791: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);

Line 3795: fnd_msg_pub.ADD;

3791: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3792: END IF;
3793:
3794: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3795: fnd_msg_pub.ADD;
3796: RAISE fnd_api.g_exc_error;
3797: END IF;
3798:
3799:

Line 3854: fnd_msg_pub.ADD;

3850: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
3851: END IF;
3852: x_return_status:=FND_API.G_RET_STS_ERROR;
3853: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');
3854: fnd_msg_pub.ADD;
3855: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3856: ROLLBACK TO sp_complete_oprtn_instance;
3857:
3858: IF (SQLCODE<-20000) THEN

Line 3855: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3851: END IF;
3852: x_return_status:=FND_API.G_RET_STS_ERROR;
3853: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');
3854: fnd_msg_pub.ADD;
3855: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3856: ROLLBACK TO sp_complete_oprtn_instance;
3857:
3858: IF (SQLCODE<-20000) THEN
3859: IF (l_debug=1) THEN

Line 3886: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3882: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3883: IF (l_debug=1) THEN
3884: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
3885: END IF;
3886: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3887: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
3888: END IF;
3889: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3890: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');

Line 3887: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);

3883: IF (l_debug=1) THEN
3884: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
3885: END IF;
3886: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3887: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
3888: END IF;
3889: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3890: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');
3891: fnd_msg_pub.ADD;

Line 3889: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3885: END IF;
3886: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3887: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
3888: END IF;
3889: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3890: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');
3891: fnd_msg_pub.ADD;
3892:
3893: IF (SQLCODE<-20000) THEN

Line 3891: fnd_msg_pub.ADD;

3887: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
3888: END IF;
3889: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3890: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');
3891: fnd_msg_pub.ADD;
3892:
3893: IF (SQLCODE<-20000) THEN
3894: IF (l_debug=1) THEN
3895: print_debug('This is a user defined exception',l_module_name,1);

Line 3934: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3930:
3931: x_error_code:=-(SQLCODE+20000);
3932: END IF;
3933:
3934: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3935: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
3936: END IF;
3937: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3938: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');

Line 3935: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);

3931: x_error_code:=-(SQLCODE+20000);
3932: END IF;
3933:
3934: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3935: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
3936: END IF;
3937: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3938: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');
3939: fnd_msg_pub.ADD;

Line 3937: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3933:
3934: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3935: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
3936: END IF;
3937: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3938: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');
3939: fnd_msg_pub.ADD;
3940:
3941: ROLLBACK TO sp_complete_oprtn_instance;

Line 3939: fnd_msg_pub.ADD;

3935: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
3936: END IF;
3937: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3938: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');
3939: fnd_msg_pub.ADD;
3940:
3941: ROLLBACK TO sp_complete_oprtn_instance;
3942:
3943: IF c_inbound_document_details%isopen THEN

Line 6392: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN

6388:
6389: WHEN OTHERS THEN
6390: print_debug(SQLERRM, l_module_name, 1);
6391:
6392: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
6393: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
6394: END IF; /* fnd_msg.... */
6395:
6396: fnd_msg_pub.count_and_get(

Line 6393: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);

6389: WHEN OTHERS THEN
6390: print_debug(SQLERRM, l_module_name, 1);
6391:
6392: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
6393: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
6394: END IF; /* fnd_msg.... */
6395:
6396: fnd_msg_pub.count_and_get(
6397: p_count => x_msg_count,

Line 6396: fnd_msg_pub.count_and_get(

6392: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
6393: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
6394: END IF; /* fnd_msg.... */
6395:
6396: fnd_msg_pub.count_and_get(
6397: p_count => x_msg_count,
6398: p_data => x_msg_data
6399: );
6400:

Line 6552: fnd_msg_pub.ADD;

6548: IF (l_debug=1) THEN
6549: print_debug('Invalid WDT status.' ,l_module_name,4);
6550: END IF;
6551: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
6552: fnd_msg_pub.ADD;
6553: RAISE FND_API.G_EXC_ERROR;
6554: END IF; -- IF l_wdt_status NOT IN (g_task_status_loaded, g_task_status_dispatched)
6555:
6556:

Line 6674: fnd_msg_pub.ADD;

6670: IF (l_debug = 1) THEN
6671: print_debug('Active operation instance record does not exist for this task.',l_module_name,4);
6672: END IF;
6673: fnd_message.set_name('WMS', 'WMS_ATF_NO_ACTIVE_PLAN');
6674: fnd_msg_pub.ADD;
6675: RAISE FND_API.G_EXC_ERROR;
6676: END IF;
6677:
6678: CLOSE c_wooi_data_rec;

Line 6865: fnd_msg_pub.ADD;

6861: IF c_wooi_data_rec%isopen THEN
6862: CLOSE c_wooi_data_rec;
6863: END IF;
6864: fnd_message.set_name('WMS', 'WMS_ATF_CLEANUP_FAILURE');
6865: fnd_msg_pub.ADD;
6866:
6867: WHEN fnd_api.g_exc_unexpected_error THEN
6868:
6869: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

Line 6884: fnd_msg_pub.ADD;

6880: CLOSE c_wooi_data_rec;
6881: END IF;
6882:
6883: fnd_message.set_name('WMS', 'WMS_ATF_CLEANUP_FAILURE');
6884: fnd_msg_pub.ADD;
6885:
6886: WHEN OTHERS THEN
6887:
6888: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

Line 6905: fnd_msg_pub.ADD;

6901: IF c_wooi_data_rec%isopen THEN
6902: CLOSE c_wooi_data_rec;
6903: END IF;
6904: fnd_message.set_name('WMS', 'WMS_ATF_CLEANUP_FAILURE');
6905: fnd_msg_pub.ADD;
6906:
6907: END Cleanup_Operation_instance;
6908:
6909:

Line 7319: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN

7315: IF (l_debug=1) THEN
7316: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
7317: END IF;
7318:
7319: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
7320: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
7321: END IF; /* fnd_msg.... */
7322:
7323: fnd_msg_pub.count_and_get(

Line 7320: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);

7316: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
7317: END IF;
7318:
7319: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
7320: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
7321: END IF; /* fnd_msg.... */
7322:
7323: fnd_msg_pub.count_and_get(
7324: p_count => x_msg_count,

Line 7323: fnd_msg_pub.count_and_get(

7319: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
7320: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
7321: END IF; /* fnd_msg.... */
7322:
7323: fnd_msg_pub.count_and_get(
7324: p_count => x_msg_count,
7325: p_data => x_msg_data
7326: );
7327:

Line 7903: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN

7899: IF (l_debug=1) THEN
7900: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
7901: END IF;
7902:
7903: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
7904: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
7905: END IF; /* fnd_msg.... */
7906:
7907: fnd_msg_pub.count_and_get(

Line 7904: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);

7900: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
7901: END IF;
7902:
7903: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
7904: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
7905: END IF; /* fnd_msg.... */
7906:
7907: fnd_msg_pub.count_and_get(
7908: p_count => x_msg_count,

Line 7907: fnd_msg_pub.count_and_get(

7903: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
7904: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
7905: END IF; /* fnd_msg.... */
7906:
7907: fnd_msg_pub.count_and_get(
7908: p_count => x_msg_count,
7909: p_data => x_msg_data
7910: );
7911:

Line 8483: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN

8479: IF (l_debug=1) THEN
8480: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
8481: END IF;
8482:
8483: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
8484: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
8485: END IF; /* fnd_msg.... */
8486:
8487: fnd_msg_pub.count_and_get(

Line 8484: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);

8480: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
8481: END IF;
8482:
8483: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
8484: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
8485: END IF; /* fnd_msg.... */
8486:
8487: fnd_msg_pub.count_and_get(
8488: p_count => x_msg_count,

Line 8487: fnd_msg_pub.count_and_get(

8483: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
8484: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
8485: END IF; /* fnd_msg.... */
8486:
8487: fnd_msg_pub.count_and_get(
8488: p_count => x_msg_count,
8489: p_data => x_msg_data
8490: );
8491:

Line 8703: fnd_msg_pub.count_and_get(

8699: <>
8700:
8701: x_return_status := g_ret_sts_success;
8702: x_plan_status := l_status;
8703: fnd_msg_pub.count_and_get(
8704: p_count => x_msg_count,
8705: p_data => x_msg_data
8706: );
8707:

Line 8713: IF fnd_msg_pub.check_msg_level(g_msg_lvl_error) THEN

8709:
8710: /*WHEN FND_API.G_EXC_ERROR THEN
8711: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
8712:
8713: IF fnd_msg_pub.check_msg_level(g_msg_lvl_error) THEN
8714: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
8715: END IF; /* fnd_msg.... */
8716:
8717: /*fnd_msg_pub.count_and_get(

Line 8714: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);

8710: /*WHEN FND_API.G_EXC_ERROR THEN
8711: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
8712:
8713: IF fnd_msg_pub.check_msg_level(g_msg_lvl_error) THEN
8714: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
8715: END IF; /* fnd_msg.... */
8716:
8717: /*fnd_msg_pub.count_and_get(
8718: p_count => x_msg_count,

Line 8717: /*fnd_msg_pub.count_and_get(

8713: IF fnd_msg_pub.check_msg_level(g_msg_lvl_error) THEN
8714: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
8715: END IF; /* fnd_msg.... */
8716:
8717: /*fnd_msg_pub.count_and_get(
8718: p_count => x_msg_count,
8719: p_data => x_msg_data
8720: );
8721: x_error_code := SQLCODE;

Line 8728: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN

8724: WHEN OTHERS THEN
8725:
8726: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
8727:
8728: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
8729: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
8730: END IF; /* fnd_msg.... */
8731:
8732: fnd_msg_pub.count_and_get(

Line 8729: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);

8725:
8726: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
8727:
8728: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
8729: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
8730: END IF; /* fnd_msg.... */
8731:
8732: fnd_msg_pub.count_and_get(
8733: p_count => x_msg_count,

Line 8732: fnd_msg_pub.count_and_get(

8728: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
8729: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
8730: END IF; /* fnd_msg.... */
8731:
8732: fnd_msg_pub.count_and_get(
8733: p_count => x_msg_count,
8734: p_data => x_msg_data
8735: );
8736: IF (SQLCODE<-20000) THEN