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 2416: IF fnd_msg_pub.check_msg_level(g_msg_lvl_error) THEN

2412: IF (l_debug=1) THEN
2413: print_debug('Expected Error at '||l_progress, l_module_name,1);
2414: END IF;
2415:
2416: IF fnd_msg_pub.check_msg_level(g_msg_lvl_error) THEN
2417: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
2418: END IF; /* fnd_msg.... */
2419:
2420: fnd_msg_pub.count_and_get(

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

2413: print_debug('Expected Error at '||l_progress, l_module_name,1);
2414: END IF;
2415:
2416: IF fnd_msg_pub.check_msg_level(g_msg_lvl_error) THEN
2417: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
2418: END IF; /* fnd_msg.... */
2419:
2420: fnd_msg_pub.count_and_get(
2421: p_count => x_msg_count,

Line 2420: fnd_msg_pub.count_and_get(

2416: IF fnd_msg_pub.check_msg_level(g_msg_lvl_error) THEN
2417: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
2418: END IF; /* fnd_msg.... */
2419:
2420: fnd_msg_pub.count_and_get(
2421: p_count => x_msg_count,
2422: p_data => x_msg_data
2423: );
2424: --x_error_code := SQLCODE;

Line 2455: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN

2451: print_debug('Unexpected error at'||l_progress||' '||SQLERRM, l_module_name,1);
2452: END IF;
2453:
2454:
2455: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
2456: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
2457: END IF; /* fnd_msg.... */
2458:
2459: fnd_msg_pub.count_and_get(

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

2452: END IF;
2453:
2454:
2455: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
2456: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
2457: END IF; /* fnd_msg.... */
2458:
2459: fnd_msg_pub.count_and_get(
2460: p_count => x_msg_count,

Line 2459: fnd_msg_pub.count_and_get(

2455: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
2456: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
2457: END IF; /* fnd_msg.... */
2458:
2459: fnd_msg_pub.count_and_get(
2460: p_count => x_msg_count,
2461: p_data => x_msg_data
2462: );
2463: --x_error_code := SQLCODE;

Line 2732: fnd_msg_pub.ADD;

2728: IF (l_debug = 1) THEN
2729: print_debug('Operation instance record does not exist for this task.',l_module_name,4);
2730: END IF;
2731: fnd_message.set_name('WMS', 'WMS_ATF_NO_ACTIVE_PLAN');
2732: fnd_msg_pub.ADD;
2733: RAISE FND_API.G_EXC_ERROR;
2734: END IF;
2735:
2736: CLOSE c_wooi_data_rec;

Line 2802: fnd_msg_pub.ADD;

2798: IF (l_debug=1) THEN
2799: print_debug('Invalid WDT status.' ,l_module_name,4);
2800: END IF;
2801: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
2802: fnd_msg_pub.ADD;
2803: RAISE FND_API.G_EXC_ERROR;
2804: END IF; -- IF l_wdt_status NOT IN (g_task_status_loaded, g_task_status_dispatched)
2805:
2806: END IF; -- IF p_activity_id = g_op_activity_inbound

Line 2872: fnd_msg_pub.ADD;

2868: IF (l_debug=1) THEN
2869: print_debug('wms_op_runtime_pvt_apis.archive_dispatched_tasks finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2870: END IF;
2871: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');
2872: fnd_msg_pub.ADD;
2873: RAISE FND_API.G_EXC_ERROR;
2874: END IF;
2875:
2876: ELSIF p_operation_type_id IS NULL OR p_operation_type_id = g_op_type_load THEN

Line 2906: fnd_msg_pub.ADD;

2902: IF (l_debug=1) THEN
2903: print_debug('Current operation ('|| p_operation_type_id ||') is not compatible with WDT status of dispatched.' ,l_module_name,4);
2904: END IF;
2905: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
2906: fnd_msg_pub.ADD;
2907: RAISE FND_API.G_EXC_ERROR;
2908:
2909: END IF; -- IF p_operation_type_id = g_op_type_inspect
2910:

Line 2961: fnd_msg_pub.ADD;

2957: IF (l_debug=1) THEN
2958: print_debug('Drop - wms_op_runtime_pvt_apis.archive_dispatched_tasks finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2959: END IF;
2960: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');
2961: fnd_msg_pub.ADD;
2962: RAISE FND_API.G_EXC_ERROR;
2963: END IF;
2964:
2965: ELSE -- l_wdt_status = g_task_status_dispatched (not dispatched or loaded)

Line 2971: fnd_msg_pub.ADD;

2967: IF (l_debug=1) THEN
2968: print_debug('Invalid WDT status.' ,l_module_name,4);
2969: END IF;
2970: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
2971: fnd_msg_pub.ADD;
2972: RAISE FND_API.G_EXC_ERROR;
2973:
2974:
2975: END IF; -- IF l_wdt_status = g_task_status_dispatched

Line 3045: fnd_msg_pub.ADD;

3041: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3042: END IF;
3043:
3044: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3045: fnd_msg_pub.ADD;
3046: RAISE fnd_api.g_exc_unexpected_error;
3047: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3048: IF (l_debug = 1) THEN
3049: 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 3053: fnd_msg_pub.ADD;

3049: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3050: END IF;
3051:
3052: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3053: fnd_msg_pub.ADD;
3054: RAISE fnd_api.g_exc_error;
3055: END IF;
3056: --bug 6924639
3057: /*

Line 3089: fnd_msg_pub.ADD;

3085: IF (l_debug = 1) THEN
3086: 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);
3087: END IF;
3088: fnd_message.set_name('WMS', 'WMS_ATF_OPERATION_MISMATCH');
3089: fnd_msg_pub.ADD;
3090: RAISE FND_API.G_EXC_ERROR;
3091: END IF;
3092:
3093: IF (l_debug=1) THEN

Line 3271: fnd_msg_pub.ADD;

3267: IF (l_debug=1) THEN
3268: print_debug('Invalid locator determination method.',l_module_name,4);
3269: END IF;
3270: fnd_message.set_name('WMS', 'WMS_ATF_LOC_DET_NOT_DEFINED');
3271: fnd_msg_pub.ADD;
3272: RAISE FND_API.G_EXC_ERROR;
3273:
3274: END IF; -- IF NVL(l_loc_sel_criteria_id, 0) = wms_globals.G_OP_DEST_PRE_SPECIFIED
3275:

Line 3359: fnd_msg_pub.ADD;

3355: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3356: END IF;
3357:
3358: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3359: fnd_msg_pub.ADD;
3360: RAISE fnd_api.g_exc_unexpected_error;
3361: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3362: IF (l_debug = 1) THEN
3363: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);

Line 3367: fnd_msg_pub.ADD;

3363: print_debug('Unforgivable Error - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3364: END IF;
3365:
3366: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3367: fnd_msg_pub.ADD;
3368: RAISE fnd_api.g_exc_error;
3369: END IF;
3370: --bug 6924639
3371: /*

Line 3511: fnd_msg_pub.ADD;

3507: IF (l_debug=1) THEN
3508: 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);
3509: END IF;
3510: fnd_message.set_name('WMS', 'WMS_ATF_ARCHIVE_TASK_FAILURE');
3511: fnd_msg_pub.ADD;
3512: RAISE FND_API.G_EXC_ERROR;
3513: END IF;
3514:
3515: IF (l_debug=1) THEN

Line 3602: fnd_msg_pub.ADD;

3598: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3599: END IF;
3600:
3601: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3602: fnd_msg_pub.ADD;
3603: RAISE fnd_api.g_exc_unexpected_error;
3604: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3605: IF (l_debug = 1) THEN
3606: 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 3610: fnd_msg_pub.ADD;

3606: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3607: END IF;
3608:
3609: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3610: fnd_msg_pub.ADD;
3611: RAISE fnd_api.g_exc_error;
3612: END IF;
3613: --bug 6924639
3614: /*

Line 3641: fnd_msg_pub.ADD;

3637: print_debug('Current operation does not have a next operation.' ,l_module_name,4);
3638: END IF;
3639:
3640: fnd_message.set_name('WMS', 'WMS_ATF_NO_NEXT_OPERATION');
3641: fnd_msg_pub.ADD;
3642:
3643: RAISE FND_API.G_EXC_ERROR;
3644:
3645: END IF;

Line 3747: fnd_msg_pub.ADD;

3743: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3744: END IF;
3745:
3746: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3747: fnd_msg_pub.ADD;
3748: RAISE fnd_api.g_exc_unexpected_error;
3749: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3750: IF (l_debug = 1) THEN
3751: 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 3755: fnd_msg_pub.ADD;

3751: print_debug('Inbound op plan null - wms_op_inbound_pvt.complete finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3752: END IF;
3753:
3754: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
3755: fnd_msg_pub.ADD;
3756: RAISE fnd_api.g_exc_error;
3757: END IF;
3758:
3759:

Line 3814: fnd_msg_pub.ADD;

3810: print_debug('Error (fnd_api.g_exc_error) occured at'||l_progress,l_module_name,1);
3811: END IF;
3812: x_return_status:=FND_API.G_RET_STS_ERROR;
3813: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');
3814: fnd_msg_pub.ADD;
3815: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3816: ROLLBACK TO sp_complete_oprtn_instance;
3817:
3818: IF (SQLCODE<-20000) THEN

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

3811: END IF;
3812: x_return_status:=FND_API.G_RET_STS_ERROR;
3813: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');
3814: fnd_msg_pub.ADD;
3815: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3816: ROLLBACK TO sp_complete_oprtn_instance;
3817:
3818: IF (SQLCODE<-20000) THEN
3819: IF (l_debug=1) THEN

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

3842: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3843: IF (l_debug=1) THEN
3844: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
3845: END IF;
3846: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3847: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
3848: END IF;
3849: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3850: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');

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

3843: IF (l_debug=1) THEN
3844: print_debug('Unexpected Error (fnd_api.g_exc_unexpected_error) occured at '||l_progress,l_module_name,3);
3845: END IF;
3846: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3847: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
3848: END IF;
3849: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3850: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');
3851: fnd_msg_pub.ADD;

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

3845: END IF;
3846: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3847: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
3848: END IF;
3849: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3850: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');
3851: fnd_msg_pub.ADD;
3852:
3853: IF (SQLCODE<-20000) THEN

Line 3851: fnd_msg_pub.ADD;

3847: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
3848: END IF;
3849: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3850: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');
3851: fnd_msg_pub.ADD;
3852:
3853: IF (SQLCODE<-20000) THEN
3854: IF (l_debug=1) THEN
3855: print_debug('This is a user defined exception',l_module_name,1);

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

3890:
3891: x_error_code:=-(SQLCODE+20000);
3892: END IF;
3893:
3894: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3895: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
3896: END IF;
3897: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3898: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');

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

3891: x_error_code:=-(SQLCODE+20000);
3892: END IF;
3893:
3894: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3895: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
3896: END IF;
3897: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3898: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');
3899: fnd_msg_pub.ADD;

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

3893:
3894: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3895: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
3896: END IF;
3897: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3898: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');
3899: fnd_msg_pub.ADD;
3900:
3901: ROLLBACK TO sp_complete_oprtn_instance;

Line 3899: fnd_msg_pub.ADD;

3895: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
3896: END IF;
3897: -- fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3898: fnd_message.set_name('WMS', 'WMS_ATF_COMPLETE_OP_FAILURE');
3899: fnd_msg_pub.ADD;
3900:
3901: ROLLBACK TO sp_complete_oprtn_instance;
3902:
3903: IF c_inbound_document_details%isopen THEN

Line 6262: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN

6258:
6259: WHEN OTHERS THEN
6260: print_debug(SQLERRM, l_module_name, 1);
6261:
6262: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
6263: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
6264: END IF; /* fnd_msg.... */
6265:
6266: fnd_msg_pub.count_and_get(

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

6259: WHEN OTHERS THEN
6260: print_debug(SQLERRM, l_module_name, 1);
6261:
6262: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
6263: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
6264: END IF; /* fnd_msg.... */
6265:
6266: fnd_msg_pub.count_and_get(
6267: p_count => x_msg_count,

Line 6266: fnd_msg_pub.count_and_get(

6262: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
6263: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
6264: END IF; /* fnd_msg.... */
6265:
6266: fnd_msg_pub.count_and_get(
6267: p_count => x_msg_count,
6268: p_data => x_msg_data
6269: );
6270:

Line 6422: fnd_msg_pub.ADD;

6418: IF (l_debug=1) THEN
6419: print_debug('Invalid WDT status.' ,l_module_name,4);
6420: END IF;
6421: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
6422: fnd_msg_pub.ADD;
6423: RAISE FND_API.G_EXC_ERROR;
6424: END IF; -- IF l_wdt_status NOT IN (g_task_status_loaded, g_task_status_dispatched)
6425:
6426:

Line 6544: fnd_msg_pub.ADD;

6540: IF (l_debug = 1) THEN
6541: print_debug('Active operation instance record does not exist for this task.',l_module_name,4);
6542: END IF;
6543: fnd_message.set_name('WMS', 'WMS_ATF_NO_ACTIVE_PLAN');
6544: fnd_msg_pub.ADD;
6545: RAISE FND_API.G_EXC_ERROR;
6546: END IF;
6547:
6548: CLOSE c_wooi_data_rec;

Line 6735: fnd_msg_pub.ADD;

6731: IF c_wooi_data_rec%isopen THEN
6732: CLOSE c_wooi_data_rec;
6733: END IF;
6734: fnd_message.set_name('WMS', 'WMS_ATF_CLEANUP_FAILURE');
6735: fnd_msg_pub.ADD;
6736:
6737: WHEN fnd_api.g_exc_unexpected_error THEN
6738:
6739: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

Line 6754: fnd_msg_pub.ADD;

6750: CLOSE c_wooi_data_rec;
6751: END IF;
6752:
6753: fnd_message.set_name('WMS', 'WMS_ATF_CLEANUP_FAILURE');
6754: fnd_msg_pub.ADD;
6755:
6756: WHEN OTHERS THEN
6757:
6758: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

Line 6775: fnd_msg_pub.ADD;

6771: IF c_wooi_data_rec%isopen THEN
6772: CLOSE c_wooi_data_rec;
6773: END IF;
6774: fnd_message.set_name('WMS', 'WMS_ATF_CLEANUP_FAILURE');
6775: fnd_msg_pub.ADD;
6776:
6777: END Cleanup_Operation_instance;
6778:
6779:

Line 7189: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN

7185: IF (l_debug=1) THEN
7186: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
7187: END IF;
7188:
7189: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
7190: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
7191: END IF; /* fnd_msg.... */
7192:
7193: fnd_msg_pub.count_and_get(

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

7186: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
7187: END IF;
7188:
7189: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
7190: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
7191: END IF; /* fnd_msg.... */
7192:
7193: fnd_msg_pub.count_and_get(
7194: p_count => x_msg_count,

Line 7193: fnd_msg_pub.count_and_get(

7189: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
7190: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
7191: END IF; /* fnd_msg.... */
7192:
7193: fnd_msg_pub.count_and_get(
7194: p_count => x_msg_count,
7195: p_data => x_msg_data
7196: );
7197:

Line 7773: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN

7769: IF (l_debug=1) THEN
7770: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
7771: END IF;
7772:
7773: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
7774: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
7775: END IF; /* fnd_msg.... */
7776:
7777: fnd_msg_pub.count_and_get(

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

7770: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
7771: END IF;
7772:
7773: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
7774: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
7775: END IF; /* fnd_msg.... */
7776:
7777: fnd_msg_pub.count_and_get(
7778: p_count => x_msg_count,

Line 7777: fnd_msg_pub.count_and_get(

7773: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
7774: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
7775: END IF; /* fnd_msg.... */
7776:
7777: fnd_msg_pub.count_and_get(
7778: p_count => x_msg_count,
7779: p_data => x_msg_data
7780: );
7781:

Line 8353: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN

8349: IF (l_debug=1) THEN
8350: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
8351: END IF;
8352:
8353: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
8354: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
8355: END IF; /* fnd_msg.... */
8356:
8357: fnd_msg_pub.count_and_get(

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

8350: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
8351: END IF;
8352:
8353: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
8354: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
8355: END IF; /* fnd_msg.... */
8356:
8357: fnd_msg_pub.count_and_get(
8358: p_count => x_msg_count,

Line 8357: fnd_msg_pub.count_and_get(

8353: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
8354: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
8355: END IF; /* fnd_msg.... */
8356:
8357: fnd_msg_pub.count_and_get(
8358: p_count => x_msg_count,
8359: p_data => x_msg_data
8360: );
8361:

Line 8573: fnd_msg_pub.count_and_get(

8569: <>
8570:
8571: x_return_status := g_ret_sts_success;
8572: x_plan_status := l_status;
8573: fnd_msg_pub.count_and_get(
8574: p_count => x_msg_count,
8575: p_data => x_msg_data
8576: );
8577:

Line 8583: IF fnd_msg_pub.check_msg_level(g_msg_lvl_error) THEN

8579:
8580: /*WHEN FND_API.G_EXC_ERROR THEN
8581: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
8582:
8583: IF fnd_msg_pub.check_msg_level(g_msg_lvl_error) THEN
8584: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
8585: END IF; /* fnd_msg.... */
8586:
8587: /*fnd_msg_pub.count_and_get(

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

8580: /*WHEN FND_API.G_EXC_ERROR THEN
8581: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
8582:
8583: IF fnd_msg_pub.check_msg_level(g_msg_lvl_error) THEN
8584: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
8585: END IF; /* fnd_msg.... */
8586:
8587: /*fnd_msg_pub.count_and_get(
8588: p_count => x_msg_count,

Line 8587: /*fnd_msg_pub.count_and_get(

8583: IF fnd_msg_pub.check_msg_level(g_msg_lvl_error) THEN
8584: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
8585: END IF; /* fnd_msg.... */
8586:
8587: /*fnd_msg_pub.count_and_get(
8588: p_count => x_msg_count,
8589: p_data => x_msg_data
8590: );
8591: x_error_code := SQLCODE;

Line 8598: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN

8594: WHEN OTHERS THEN
8595:
8596: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
8597:
8598: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
8599: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
8600: END IF; /* fnd_msg.... */
8601:
8602: fnd_msg_pub.count_and_get(

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

8595:
8596: print_debug(l_progress||' '||SQLERRM, l_module_name,1);
8597:
8598: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
8599: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
8600: END IF; /* fnd_msg.... */
8601:
8602: fnd_msg_pub.count_and_get(
8603: p_count => x_msg_count,

Line 8602: fnd_msg_pub.count_and_get(

8598: IF fnd_msg_pub.check_msg_level(g_msg_lvl_unexp_error) THEN
8599: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name, SQLERRM);
8600: END IF; /* fnd_msg.... */
8601:
8602: fnd_msg_pub.count_and_get(
8603: p_count => x_msg_count,
8604: p_data => x_msg_data
8605: );
8606: IF (SQLCODE<-20000) THEN