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

Line 36: G_CONC_REQ VARCHAR2(1) := FND_API.G_TRUE;

32: -- VARIABLES
33:
34: -- Description: Constant to distinguish CONCURRENT request from
35: -- ONLINE request
36: G_CONC_REQ VARCHAR2(1) := FND_API.G_TRUE;
37:
38:
39: -- Following globals are needed by online_release API to pass back to the Pick Release Form
40: G_ONLINE_PICK_RELEASE_PHASE VARCHAR2(30) := null;

Line 234: l_init_rules VARCHAR2(1) := FND_API.G_FALSE;

230: FROM MTL_PARAMETERS
231: WHERE ORGANIZATION_ID = c_org_id;
232:
233: l_default_pickconfirm VARCHAR2(1);
234: l_init_rules VARCHAR2(1) := FND_API.G_FALSE;
235: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
236: l_express_pick_profile VARCHAR2(1);
237:
238: l_debug_on BOOLEAN;

Line 427: IF (l_init_rules = FND_API.G_FALSE OR WSH_PR_CRITERIA.g_pick_grouping_rule_id IS NULL

423: WSH_PR_CRITERIA.g_honor_pick_from := NVL(FND_PROFILE.VALUE('WSH_HONOR_PICK_FROM'), 'Y');
424: END IF;
425:
426: -- 50. Check to see if rules need to be initialized for organization
427: IF (l_init_rules = FND_API.G_FALSE OR WSH_PR_CRITERIA.g_pick_grouping_rule_id IS NULL
428: OR WSH_PR_CRITERIA.g_pick_seq_rule_id IS NULL) THEN --{
429: IF l_debug_on THEN
430: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PR_CRITERIA.Init_Rules',WSH_DEBUG_SV.C_PROC_LEVEL);
431: END IF;

Line 877: l_commit VARCHAR2(1) := FND_API.G_FALSE;

873: l_date DATE;
874: l_api_version_number NUMBER := 1.0;
875: l_msg_count NUMBER;
876: l_msg_data VARCHAR2(2000);
877: l_commit VARCHAR2(1) := FND_API.G_FALSE;
878: l_return_status VARCHAR2(1);
879: l_request_id NUMBER;
880: l_item_name VARCHAR2(2000);
881: l_message VARCHAR2(2000);

Line 966: p_init_msg_list => fnd_api.g_false,

962: -- of delivery details new records will be added to p_wsh_release_table
963: --
964: WMS_Xdock_Pegging_Pub.Planned_Cross_Dock
965: (p_api_version => l_api_version_number,
966: p_init_msg_list => fnd_api.g_false,
967: p_commit => l_commit,
968: p_batch_id => p_batch_id,
969: p_wsh_release_table => wsh_pr_criteria.release_table,
970: p_trolin_delivery_ids => g_xdock_delivery_ids,

Line 1375: p_init_msg_list => FND_API.G_FALSE,

1371: END IF;
1372: Inv_Move_Order_Pub.Create_Move_Order_Lines
1373: (
1374: p_api_version_number => l_api_version_number,
1375: p_init_msg_list => FND_API.G_FALSE,
1376: p_return_values => FND_API.G_TRUE,
1377: p_commit => l_commit,
1378: p_trolin_tbl => g_trolin_tbl,
1379: p_trolin_val_tbl => l_trolin_val_tbl,

Line 1376: p_return_values => FND_API.G_TRUE,

1372: Inv_Move_Order_Pub.Create_Move_Order_Lines
1373: (
1374: p_api_version_number => l_api_version_number,
1375: p_init_msg_list => FND_API.G_FALSE,
1376: p_return_values => FND_API.G_TRUE,
1377: p_commit => l_commit,
1378: p_trolin_tbl => g_trolin_tbl,
1379: p_trolin_val_tbl => l_trolin_val_tbl,
1380: p_validation_flag => 'N', -- Inventory will skip most validations and assume Shipping validates them

Line 1462: p_init_msg_list => FND_API.G_TRUE,

1458: END IF;
1459: WSH_PICK_LIST.G_AUTO_PICK_CONFIRM := 'Y';
1460: Inv_Express_Pick_Pub.Pick_Release (
1461: p_api_version => l_api_version_number,
1462: p_init_msg_list => FND_API.G_TRUE,
1463: p_commit => l_commit,
1464: p_mo_line_tbl => g_trolin_tbl,
1465: p_grouping_rule_id => p_pick_slip_grouping_rule,
1466: p_reservations_tbl => l_dummy_rsv_tbl,

Line 1467: p_allow_partial_pick => FND_API.G_TRUE,

1463: p_commit => l_commit,
1464: p_mo_line_tbl => g_trolin_tbl,
1465: p_grouping_rule_id => p_pick_slip_grouping_rule,
1466: p_reservations_tbl => l_dummy_rsv_tbl,
1467: p_allow_partial_pick => FND_API.G_TRUE,
1468: p_pick_release_status_tbl=> g_exp_pick_release_stat,
1469: x_return_status => l_return_status,
1470: x_msg_count => l_msg_count,
1471: x_msg_data => l_msg_data);

Line 1852: p_init_msg_list => FND_API.G_FALSE,

1848: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1849: END IF;
1850: WSH_FTE_COMP_CONSTRAINT_PKG.validate_constraint_main (
1851: p_api_version_number => 1.0,
1852: p_init_msg_list => FND_API.G_FALSE,
1853: p_entity_type => 'L',
1854: p_target_id => null,
1855: p_action_code => 'AUTOCREATE-DEL',
1856: p_del_attr_tab => l_cc_del_attr_tab,

Line 1940: p_commit => FND_API.G_FALSE,

1936: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries (
1937: p_delivery_detail_tbl => l_id_tab_temp,
1938: p_append_flag => p_append_flag,
1939: p_group_by_header => p_use_header_flag,
1940: p_commit => FND_API.G_FALSE,
1941: p_lock_rows => FND_API.G_FALSE,
1942: p_check_fte_compatibility => FND_API.G_FALSE,
1943: x_appended_det_tbl => l_appended_det_tbl,
1944: x_unappended_det_tbl => l_unappended_det_tbl,

Line 1941: p_lock_rows => FND_API.G_FALSE,

1937: p_delivery_detail_tbl => l_id_tab_temp,
1938: p_append_flag => p_append_flag,
1939: p_group_by_header => p_use_header_flag,
1940: p_commit => FND_API.G_FALSE,
1941: p_lock_rows => FND_API.G_FALSE,
1942: p_check_fte_compatibility => FND_API.G_FALSE,
1943: x_appended_det_tbl => l_appended_det_tbl,
1944: x_unappended_det_tbl => l_unappended_det_tbl,
1945: x_appended_del_tbl => l_tmp_del_tbl,

Line 1942: p_check_fte_compatibility => FND_API.G_FALSE,

1938: p_append_flag => p_append_flag,
1939: p_group_by_header => p_use_header_flag,
1940: p_commit => FND_API.G_FALSE,
1941: p_lock_rows => FND_API.G_FALSE,
1942: p_check_fte_compatibility => FND_API.G_FALSE,
1943: x_appended_det_tbl => l_appended_det_tbl,
1944: x_unappended_det_tbl => l_unappended_det_tbl,
1945: x_appended_del_tbl => l_tmp_del_tbl,
1946: x_return_status => l_return_status );

Line 2107: p_commit => FND_API.G_FALSE,

2103: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries(
2104: p_delivery_detail_tbl => l_del_details_tbl,
2105: p_append_flag => p_append_flag,
2106: p_group_by_header => p_use_header_flag,
2107: p_commit => FND_API.G_FALSE,
2108: p_lock_rows => FND_API.G_FALSE,
2109: p_check_fte_compatibility => FND_API.G_FALSE,
2110: x_appended_det_tbl => l_appended_det_tbl,
2111: x_unappended_det_tbl => l_unappended_det_tbl,

Line 2108: p_lock_rows => FND_API.G_FALSE,

2104: p_delivery_detail_tbl => l_del_details_tbl,
2105: p_append_flag => p_append_flag,
2106: p_group_by_header => p_use_header_flag,
2107: p_commit => FND_API.G_FALSE,
2108: p_lock_rows => FND_API.G_FALSE,
2109: p_check_fte_compatibility => FND_API.G_FALSE,
2110: x_appended_det_tbl => l_appended_det_tbl,
2111: x_unappended_det_tbl => l_unappended_det_tbl,
2112: x_appended_del_tbl => l_appended_del_tbl,

Line 2109: p_check_fte_compatibility => FND_API.G_FALSE,

2105: p_append_flag => p_append_flag,
2106: p_group_by_header => p_use_header_flag,
2107: p_commit => FND_API.G_FALSE,
2108: p_lock_rows => FND_API.G_FALSE,
2109: p_check_fte_compatibility => FND_API.G_FALSE,
2110: x_appended_det_tbl => l_appended_det_tbl,
2111: x_unappended_det_tbl => l_unappended_det_tbl,
2112: x_appended_del_tbl => l_appended_del_tbl,
2113: x_return_status => l_return_status);

Line 2218: p_commit => FND_API.G_FALSE,

2214: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries(
2215: p_delivery_detail_tbl => l_del_details_tbl,
2216: p_append_flag => p_append_flag,
2217: p_group_by_header => p_use_header_flag,
2218: p_commit => FND_API.G_FALSE,
2219: p_lock_rows => FND_API.G_FALSE,
2220: p_check_fte_compatibility => FND_API.G_FALSE,
2221: x_appended_det_tbl => l_appended_det_tbl,
2222: x_unappended_det_tbl => l_unappended_det_tbl,

Line 2219: p_lock_rows => FND_API.G_FALSE,

2215: p_delivery_detail_tbl => l_del_details_tbl,
2216: p_append_flag => p_append_flag,
2217: p_group_by_header => p_use_header_flag,
2218: p_commit => FND_API.G_FALSE,
2219: p_lock_rows => FND_API.G_FALSE,
2220: p_check_fte_compatibility => FND_API.G_FALSE,
2221: x_appended_det_tbl => l_appended_det_tbl,
2222: x_unappended_det_tbl => l_unappended_det_tbl,
2223: x_appended_del_tbl => l_appended_del_tbl,

Line 2220: p_check_fte_compatibility => FND_API.G_FALSE,

2216: p_append_flag => p_append_flag,
2217: p_group_by_header => p_use_header_flag,
2218: p_commit => FND_API.G_FALSE,
2219: p_lock_rows => FND_API.G_FALSE,
2220: p_check_fte_compatibility => FND_API.G_FALSE,
2221: x_appended_det_tbl => l_appended_det_tbl,
2222: x_unappended_det_tbl => l_unappended_det_tbl,
2223: x_appended_del_tbl => l_appended_del_tbl,
2224: x_return_status => l_return_status);

Line 2365: l_commit VARCHAR2(1) := FND_API.G_FALSE;

2361: l_dummy VARCHAR2(1);
2362: l_rec_found BOOLEAN;
2363: l_msg_count NUMBER;
2364: l_msg_data VARCHAR2(2000);
2365: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2366: l_request_id NUMBER;
2367: l_item_name VARCHAR2(2000);
2368: l_api_version_number NUMBER := 1.0;
2369: l_message VARCHAR2(2000);

Line 2412: G_CONC_REQ := FND_API.G_TRUE;

2408: SAVEPOINT s_Release_Batch_Sub_sf;
2409:
2410: -- If this is a worker, then it is a concurrent request
2411: IF p_worker_id IS NOT NULL THEN
2412: G_CONC_REQ := FND_API.G_TRUE;
2413: END IF;
2414:
2415: IF G_CONC_REQ = FND_API.G_TRUE AND p_worker_id IS NOT NULL THEN
2416: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;

Line 2415: IF G_CONC_REQ = FND_API.G_TRUE AND p_worker_id IS NOT NULL THEN

2411: IF p_worker_id IS NOT NULL THEN
2412: G_CONC_REQ := FND_API.G_TRUE;
2413: END IF;
2414:
2415: IF G_CONC_REQ = FND_API.G_TRUE AND p_worker_id IS NOT NULL THEN
2416: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;
2417: IF p_log_level IS NOT NULL THEN -- log level fix
2418: WSH_UTIL_CORE.Set_Log_Level(p_log_level);
2419: WSH_UTIL_CORE.PrintMsg('p_log_level is ' || to_char(p_log_level));

Line 2525: l_done_flag := FND_API.G_FALSE;

2521: WSH_INV_INTEGRATION_GRP.G_ORGSUBTAB.delete ;
2522:
2523: -- Set count for release rows to 0
2524: l_curr_count := 0;
2525: l_done_flag := FND_API.G_FALSE;
2526: l_total_detailed_count := 0;
2527:
2528: -- Reset the Non-Reservable Item Flag as 'N'
2529: WSH_PR_CRITERIA.g_nonreservable_item := 'N';

Line 2562: WHILE (l_done_flag = FND_API.G_FALSE) LOOP

2558: END IF;
2559: --}
2560:
2561: -- 10.20.40 Get all lines for Organization-Item Combination and process them
2562: WHILE (l_done_flag = FND_API.G_FALSE) LOOP
2563: --{
2564: -- 10.20.40.10 Select a number of order lines at a time
2565: --{
2566: IF l_debug_on THEN

Line 2759: IF l_org_info.express_pick_flag = 'Y' AND ( G_CONC_REQ = FND_API.G_TRUE ) THEN --{

2755: END IF;
2756: --}
2757:
2758: -- Call FTE Load Tender and Issue Commit for Concurrent Express Pick Release
2759: IF l_org_info.express_pick_flag = 'Y' AND ( G_CONC_REQ = FND_API.G_TRUE ) THEN --{
2760: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2761: IF l_debug_on THEN
2762: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2763: END IF;

Line 2848: p_init_msg_list => fnd_api.g_true,

2844: -- to p_wsh_release_table
2845: --bug# 6689448 (replenishment project): added the parameter P_dynamic_replenishment_flag
2846: INV_Pick_Release_Pub.Pick_Release
2847: (p_api_version => l_api_version_number,
2848: p_init_msg_list => fnd_api.g_true,
2849: p_commit => l_commit,
2850: p_mo_line_tbl => g_trolin_tbl,
2851: p_auto_pick_confirm => l_auto_pick_confirm_num,
2852: p_plan_tasks => l_plan_tasks,

Line 2953: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN

2949: -- Printing Pick Slips in Immediate Mode
2950: IF l_org_info.express_pick_flag = 'N' AND (l_org_info.autodetail_flag = 'Y')
2951: AND (g_trolin_tbl.count > 0) THEN
2952: --{
2953: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN
2954: --{
2955: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2956: IF l_debug_on THEN
2957: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 3008: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN

3004: END IF;
3005: END LOOP;
3006: --}
3007: END IF;
3008: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN
3009: IF l_debug_on THEN
3010: WSH_DEBUG_SV.logmsg(l_module_name, 'Commiting...');
3011: END IF;
3012: COMMIT;

Line 3068: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN

3064: --}
3065: ELSIF l_org_info.express_pick_flag = 'N' AND (l_org_info.autodetail_flag = 'N') THEN
3066: -- Need to add this commit for scenarios where Auto Allocate is No and, if number of lines is
3067: -- greater than Pick Release Batch size
3068: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN
3069: IF l_debug_on THEN
3070: WSH_DEBUG_SV.logmsg(l_module_name, 'Commiting...');
3071: END IF;
3072: COMMIT;

Line 3095: p_init_msg_list => FND_API.G_TRUE,

3091: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_PICK_WAVE_PICK_CONFIRM_PUB.PICK_CONFIRM',WSH_DEBUG_SV.C_PROC_LEVEL);
3092: END IF;
3093: INV_Pick_Wave_Pick_Confirm_PUB.Pick_Confirm
3094: (p_api_version_number => l_api_version_number,
3095: p_init_msg_list => FND_API.G_TRUE,
3096: p_commit => l_commit,
3097: p_move_order_type => INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE,
3098: p_transaction_mode => 1,
3099: p_trolin_tbl => g_trolin_tbl,

Line 3126: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN

3122: fnd_msg_pub.delete_msg();
3123: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3124: WSH_UTIL_CORE.PrintMsg('Unexpected error. Exiting');
3125: --Bug 4906830
3126: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN
3127: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
3128: errbuf := 'Unexpected error. Exiting';
3129: retcode := '2';
3130: ELSE

Line 3145: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN

3141: WSH_DEBUG_SV.logmsg(l_module_name, 'PICK CONFIRM SUCESSFUL' );
3142: END IF;
3143: END IF;
3144:
3145: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN
3146: --{
3147: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
3148: IF l_debug_on THEN
3149: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 3227: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN

3223: END LOOP;
3224: END IF;
3225: --}
3226:
3227: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN
3228: IF l_debug_on THEN
3229: WSH_DEBUG_SV.logmsg(l_module_name, 'Commiting...');
3230: END IF;
3231: COMMIT;

Line 3423: IF G_CONC_REQ = FND_API.G_TRUE THEN

3419: G_ONLINE_PICK_RELEASE_RESULT := 'S';
3420: G_ONLINE_PICK_RELEASE_PHASE := 'SUCCESS';
3421: END IF;
3422:
3423: IF G_CONC_REQ = FND_API.G_TRUE THEN
3424: -- Set the completion status only in the case of Child Request
3425: -- If this is done as part of Parent Process, this setting will cause program to stop without doing
3426: -- any further processing
3427: IF p_worker_id is not null then

Line 3450: IF G_CONC_REQ = FND_API.G_TRUE THEN

3446: EXCEPTION
3447: WHEN e_return THEN
3448:
3449: --Bug 5355135
3450: IF G_CONC_REQ = FND_API.G_TRUE THEN
3451: ROLLBACK;
3452: ELSE
3453: ROLLBACK TO s_Release_Batch_Sub_sf;
3454: END IF;

Line 3458: IF G_CONC_REQ = FND_API.G_TRUE THEN

3454: END IF;
3455:
3456: WSH_UTIL_CORE.PrintMsg('SQLCODE: '||sqlcode||' SQLERRM: '||sqlerrm);
3457: WSH_UTIL_CORE.PrintMsg('Exception occurred in WSH_PICK_LIST.Release_Batch_Sub');
3458: IF G_CONC_REQ = FND_API.G_TRUE THEN
3459: -- Set the completion status only in the case of Child Request
3460: -- If this is done as part of Parent Process, this setting will cause program to stop without doing
3461: -- any further processing
3462: IF p_worker_id is not null then

Line 3474: IF G_CONC_REQ = FND_API.G_TRUE THEN

3470: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_RETURN');
3471: END IF;
3472: WHEN OTHERS THEN
3473: --Bug 5355135
3474: IF G_CONC_REQ = FND_API.G_TRUE THEN
3475: ROLLBACK;
3476: ELSE
3477: ROLLBACK TO s_Release_Batch_Sub_sf;
3478: END IF;

Line 3482: IF G_CONC_REQ = FND_API.G_TRUE THEN

3478: END IF;
3479:
3480: WSH_UTIL_CORE.PrintMsg('SQLCODE: '||sqlcode||' SQLERRM: '||sqlerrm);
3481: WSH_UTIL_CORE.PrintMsg('Exception occurred in WSH_PICK_LIST.Release_Batch_Sub');
3482: IF G_CONC_REQ = FND_API.G_TRUE THEN
3483: -- Set the completion status only in the case of Child Request
3484: -- If this is done as part of Parent Process, this setting will cause program to stop without doing
3485: -- any further processing
3486: IF p_worker_id is not null then

Line 3921: l_commit VARCHAR2(1) := FND_API.G_FALSE;

3917: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
3918: l_api_version_number NUMBER := 1.0;
3919: l_msg_count NUMBER;
3920: l_msg_data VARCHAR2(2000);
3921: l_commit VARCHAR2(1) := FND_API.G_FALSE;
3922: l_delivery_id NUMBER;
3923: l_trip_id NUMBER;
3924: l_trip_stop_id NUMBER;
3925: l_ship_from_loc_id NUMBER;

Line 3954: l_init_rules VARCHAR2(1) := FND_API.G_FALSE;

3950: l_rowid VARCHAR2(30);
3951: l_curr_count NUMBER;
3952: l_batch_name VARCHAR2(30);
3953: l_task_planning_flag WSH_PICKING_BATCHES.task_planning_flag%TYPE;
3954: l_init_rules VARCHAR2(1) := FND_API.G_FALSE;
3955: l_print_cursor_flag VARCHAR2(1);
3956: l_pr_worker_rec_count NUMBER := 0;
3957: l_counter NUMBER := 0;
3958: l_count NUMBER := 0;

Line 4087: IF G_CONC_REQ = FND_API.G_TRUE THEN

4083: WSH_DCP_PVT.G_CALL_DCP_CHECK := 'N';
4084: END IF;
4085:
4086: -- 30. Logging Settings
4087: IF G_CONC_REQ = FND_API.G_TRUE THEN
4088: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;
4089: IF p_log_level IS NOT NULL THEN
4090: WSH_UTIL_CORE.Set_Log_Level(p_log_level);
4091: WSH_UTIL_CORE.PrintMsg('p_log_level is ' || to_char(p_log_level));

Line 4496: p_init_msg_list => FND_API.G_FALSE,

4492:
4493: Inv_Move_Order_Pub.Create_Move_Order_Header
4494: (
4495: p_api_version_number => l_api_version_number,
4496: p_init_msg_list => FND_API.G_FALSE,
4497: p_return_values => FND_API.G_TRUE,
4498: p_commit => l_commit,
4499: p_trohdr_rec => l_trohdr_rec,
4500: p_trohdr_val_rec => l_trohdr_val_rec,

Line 4497: p_return_values => FND_API.G_TRUE,

4493: Inv_Move_Order_Pub.Create_Move_Order_Header
4494: (
4495: p_api_version_number => l_api_version_number,
4496: p_init_msg_list => FND_API.G_FALSE,
4497: p_return_values => FND_API.G_TRUE,
4498: p_commit => l_commit,
4499: p_trohdr_rec => l_trohdr_rec,
4500: p_trohdr_val_rec => l_trohdr_val_rec,
4501: x_trohdr_rec => l_trohdr_rec,

Line 4534: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN

4530:
4531: -- 90.8 Data should be committed only in case of a concurrent request.
4532: -- Data should not be commited if its ONLINE/From PUBLIC API.
4533: -- In case of Online data is committed from Pick Release form.
4534: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN
4535: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
4536: IF l_debug_on THEN
4537: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
4538: END IF;

Line 4911: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN

4907: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
4908: l_errors := l_errors + 1;
4909: END IF;
4910: l_detail_pfetch := c_get_backordered_details%ROWCOUNT;
4911: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN
4912: IF l_debug_on THEN
4913: WSH_DEBUG_SV.logmsg(l_module_name, 'Commiting...');
4914: END IF;
4915: COMMIT;

Line 5059: p_init_msg_list => FND_API.G_FALSE,

5055: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_INTEGRATION.Rate_Delivery',WSH_DEBUG_SV.C_PROC_LEVEL);
5056: END IF;
5057: WSH_FTE_INTEGRATION.Rate_Delivery (
5058: p_api_version => 1.0,
5059: p_init_msg_list => FND_API.G_FALSE,
5060: p_commit => FND_API.G_FALSE,
5061: p_in_param_rec => l_in_param_rec,
5062: x_out_param_rec => l_out_param_rec,
5063: x_return_status => l_return_status,

Line 5060: p_commit => FND_API.G_FALSE,

5056: END IF;
5057: WSH_FTE_INTEGRATION.Rate_Delivery (
5058: p_api_version => 1.0,
5059: p_init_msg_list => FND_API.G_FALSE,
5060: p_commit => FND_API.G_FALSE,
5061: p_in_param_rec => l_in_param_rec,
5062: x_out_param_rec => l_out_param_rec,
5063: x_return_status => l_return_status,
5064: x_msg_count => l_msg_count,

Line 5159: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN

5155: END IF;
5156: l_detail_pfetch := c_batch_unplanned_del%ROWCOUNT;
5157: END LOOP; --}
5158:
5159: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN
5160: IF l_debug_on THEN
5161: WSH_DEBUG_SV.logmsg(l_module_name, 'Commiting...');
5162: END IF;
5163: COMMIT;

Line 5263: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

5259: ,WSH_DEBUG_SV.C_PROC_LEVEL);
5260: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
5261: END IF;
5262: INV_MOVE_ORDER_PUB.Stamp_Cart_Id (
5263: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5264: p_carton_grouping_tbl => l_carton_grouping_tbl,
5265: p_move_order_line_tbl => l_mo_lines_tbl );
5266: IF l_debug_on THEN
5267: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);

Line 5279: p_init_msg_list => FND_API.G_FALSE,

5275: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
5276: END IF;
5277: INV_PICK_RELEASE_PUB.Call_Cartonization (
5278: p_api_version => 1.0,
5279: p_init_msg_list => FND_API.G_FALSE,
5280: p_commit => FND_API.G_FALSE,
5281: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5282: p_out_bound => 'Y',
5283: p_org_id => crec.organization_id,

Line 5280: p_commit => FND_API.G_FALSE,

5276: END IF;
5277: INV_PICK_RELEASE_PUB.Call_Cartonization (
5278: p_api_version => 1.0,
5279: p_init_msg_list => FND_API.G_FALSE,
5280: p_commit => FND_API.G_FALSE,
5281: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5282: p_out_bound => 'Y',
5283: p_org_id => crec.organization_id,
5284: p_move_order_header_id => crec.mo_header_id,

Line 5281: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

5277: INV_PICK_RELEASE_PUB.Call_Cartonization (
5278: p_api_version => 1.0,
5279: p_init_msg_list => FND_API.G_FALSE,
5280: p_commit => FND_API.G_FALSE,
5281: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5282: p_out_bound => 'Y',
5283: p_org_id => crec.organization_id,
5284: p_move_order_header_id => crec.mo_header_id,
5285: p_grouping_rule_id => l_org_info_tbl(crec.organization_id).pick_grouping_rule_id,

Line 5286: p_allow_partial_pick => FND_API.G_TRUE,

5282: p_out_bound => 'Y',
5283: p_org_id => crec.organization_id,
5284: p_move_order_header_id => crec.mo_header_id,
5285: p_grouping_rule_id => l_org_info_tbl(crec.organization_id).pick_grouping_rule_id,
5286: p_allow_partial_pick => FND_API.G_TRUE,
5287: x_return_status => l_return_status,
5288: x_msg_count => l_msg_count,
5289: x_msg_data => l_msg_data);
5290: IF l_debug_on THEN

Line 5375: p_init_msg_list => FND_API.G_FALSE,

5371: ,WSH_DEBUG_SV.C_PROC_LEVEL);
5372: END IF;
5373: Inv_Move_Order_Pub.Process_Move_Order (
5374: p_api_version_number => l_api_version_number,
5375: p_init_msg_list => FND_API.G_FALSE,
5376: p_return_values => FND_API.G_TRUE,
5377: p_commit => l_commit,
5378: p_trohdr_rec => l_trohdr_rec,
5379: x_trohdr_rec => l_trohdr_rec,

Line 5376: p_return_values => FND_API.G_TRUE,

5372: END IF;
5373: Inv_Move_Order_Pub.Process_Move_Order (
5374: p_api_version_number => l_api_version_number,
5375: p_init_msg_list => FND_API.G_FALSE,
5376: p_return_values => FND_API.G_TRUE,
5377: p_commit => l_commit,
5378: p_trohdr_rec => l_trohdr_rec,
5379: x_trohdr_rec => l_trohdr_rec,
5380: x_trohdr_val_rec => l_trohdr_val_rec,

Line 5525: IF G_CONC_REQ = FND_API.G_TRUE THEN

5521: G_ONLINE_PICK_RELEASE_RESULT := 'S';
5522: G_ONLINE_PICK_RELEASE_PHASE := 'SUCCESS';
5523: END IF;
5524:
5525: IF G_CONC_REQ = FND_API.G_TRUE THEN
5526: IF l_completion_status = 'NORMAL' THEN
5527: errbuf := 'Pick selection completed successfully';
5528: ELSIF l_completion_status = 'WARNING' THEN
5529: errbuf := 'Pick selection is completed with warning';

Line 5539: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN

5535: IF l_debug_on THEN
5536: WSH_DEBUG_SV.log(l_module_name,'l_completion_status',l_completion_status);
5537: END IF;
5538:
5539: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN
5540: IF l_debug_on THEN
5541: WSH_DEBUG_SV.logmsg(l_module_name, 'Commiting...');
5542: END IF;
5543: COMMIT;

Line 5549: IF ((G_CONC_REQ = FND_API.G_TRUE AND l_completion_status <> 'ERROR') OR

5545:
5546: END IF; --}
5547:
5548: -- If pick released successfully see if we want to autopack/shipconfirm
5549: IF ((G_CONC_REQ = FND_API.G_TRUE AND l_completion_status <> 'ERROR') OR
5550: G_ONLINE_PICK_RELEASE_RESULT IN ('S', 'W'))
5551: AND (WSH_PR_CRITERIA.g_autopack_flag = 'Y' OR WSH_PR_CRITERIA.g_non_picking_flag in ('P', 'S') OR
5552: WSH_PR_CRITERIA.g_auto_ship_confirm_rule_id IS NOT NULL)
5553: AND (l_mode IS NULL OR l_mode IN ('PICK-SS','PICK')) THEN

Line 5641: IF G_CONC_REQ = FND_API.G_TRUE THEN

5637: -- Autopack should be set only if Non Pick Flag as 'P' and AP Level is set
5638: IF WSH_PR_CRITERIA.g_non_picking_flag = 'P' AND NVL(l_ap_level,0) > 0 THEN
5639: l_act_ap_level := NVL(l_ap_level,0);
5640: ELSIF WSH_PR_CRITERIA.g_non_picking_flag = 'P' AND NVL(l_ap_level,0) = 0 THEN
5641: IF G_CONC_REQ = FND_API.G_TRUE THEN
5642: WSH_UTIL_CORE.PrintMsg('** Warning : Autopack Option is No for the organization - Packing action not performed **');
5643: END IF;
5644: l_act_ap_level := 0;
5645: ELSE

Line 5786: IF G_CONC_REQ = FND_API.G_TRUE THEN

5782: IF (WSH_PR_CRITERIA.g_autopack_flag = 'Y')
5783: OR (NVL(l_ap_level,0) > 0 AND WSH_PR_CRITERIA.g_non_picking_flag = 'P') THEN
5784: l_act_ap_level := NVL(l_ap_level,0);
5785: ELSIF WSH_PR_CRITERIA.g_non_picking_flag = 'P' AND NVL(l_ap_level,0) = 0 THEN
5786: IF G_CONC_REQ = FND_API.G_TRUE THEN
5787: WSH_UTIL_CORE.PrintMsg('** Warning : Autopack Option is No for the organization - Packing action not performed **');
5788: END IF;
5789: l_act_ap_level := 0;
5790: ELSE

Line 5930: IF ((G_CONC_REQ = FND_API.G_TRUE AND l_completion_status <> 'ERROR') OR

5926: END IF; -- Pack/Ship Grouping
5927:
5928: WSH_UTIL_CORE.PrintDateTime;
5929:
5930: IF ((G_CONC_REQ = FND_API.G_TRUE AND l_completion_status <> 'ERROR') OR
5931: G_ONLINE_PICK_RELEASE_RESULT IN ('S', 'W'))
5932: AND (WSH_PR_CRITERIA.g_autopack_flag = 'Y' OR WSH_PR_CRITERIA.g_non_picking_flag in ('P', 'S') OR
5933: WSH_PR_CRITERIA.g_auto_ship_confirm_rule_id IS NOT NULL) THEN --{
5934: -- Get all Trip Stops for setting Trip to In-Transit or Closed

Line 6194: IF G_CONC_REQ = FND_API.G_TRUE THEN

6190: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
6191: END IF;
6192: --}
6193:
6194: IF G_CONC_REQ = FND_API.G_TRUE THEN
6195: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
6196: IF l_completion_status = 'NORMAL' THEN
6197: retcode := '0';
6198: ELSIF l_completion_status = 'WARNING' THEN

Line 6246: IF G_CONC_REQ = FND_API.G_TRUE THEN

6242: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
6243: END IF;
6244: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
6245: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
6246: IF G_CONC_REQ = FND_API.G_TRUE THEN
6247: l_completion_status := 'ERROR';
6248: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
6249: errbuf := 'Pick selection is completed with error';
6250: retcode := '2';

Line 6258: IF G_CONC_REQ = FND_API.G_TRUE THEN

6254: ROLLBACK TO S_CALL_FTE_LOAD_TENDER_API_SP;
6255: END IF;
6256:
6257: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
6258: IF G_CONC_REQ = FND_API.G_TRUE THEN
6259: IF l_completion_status = 'NORMAL' THEN
6260: l_completion_status := 'WARNING';
6261: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
6262: errbuf := 'Pick selection is completed with warning';

Line 6291: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN

6287: --Bug 5355135
6288: -- Since we rollback to savepoint do not use this exception if
6289: -- a commit or rollback has happened for on-line mode
6290:
6291: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN
6292: ROLLBACK;
6293: ELSE
6294: ROLLBACK TO s_Release_Batch_sp;
6295: END IF;

Line 6365: IF G_CONC_REQ = FND_API.G_TRUE THEN

6361: END IF;
6362: IF c_requests%ISOPEN THEN
6363: CLOSE c_requests;
6364: END IF;
6365: IF G_CONC_REQ = FND_API.G_TRUE THEN
6366: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
6367: errbuf := 'Exception occurred in WSH_PICK_LIST';
6368: retcode := '2';
6369: END IF;

Line 6459: IF G_CONC_REQ = FND_API.G_TRUE THEN

6455: END IF;
6456: IF c_requests%ISOPEN THEN
6457: CLOSE c_requests;
6458: END IF;
6459: IF G_CONC_REQ = FND_API.G_TRUE THEN
6460: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
6461: errbuf := 'Exception occurred in WSH_PICK_LIST';
6462: retcode := '2';
6463: END IF;

Line 6510: p_log_level IN NUMBER, -- Commented as per GSCC Standards DEFAULT FND_API.G_MISS_NUM log level fix

6506: errbuf OUT NOCOPY VARCHAR2,
6507: retcode OUT NOCOPY VARCHAR2,
6508: p_rule_id IN NUMBER,
6509: p_batch_prefix IN VARCHAR2,
6510: p_log_level IN NUMBER, -- Commented as per GSCC Standards DEFAULT FND_API.G_MISS_NUM log level fix
6511: p_ship_confirm_rule_id IN NUMBER,
6512: p_actual_departure_date IN VARCHAR2,
6513: p_num_workers IN NUMBER
6514: ) IS

Line 6867: IF G_CONC_REQ = FND_API.G_TRUE THEN

6863: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6864: FND_MSG_PUB.Add_Exc_Msg( 'WSH_PICK_LIST', 'Release_Batch_SRS' );
6865: END IF;
6866: --
6867: IF G_CONC_REQ = FND_API.G_TRUE THEN
6868: l_ret_code := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
6869: errbuf := 'Exception occurred in Release_Batch_SRS';
6870: retcode := '2';
6871: END IF;

Line 6921: G_CONC_REQ := FND_API.G_FALSE;

6917: WSH_DEBUG_SV.push(l_module_name);
6918: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
6919: END IF;
6920: --
6921: G_CONC_REQ := FND_API.G_FALSE;
6922: Release_Batch(l_dummy1,l_dummy2,p_batch_id, p_num_workers => 1);
6923: p_pick_phase := G_ONLINE_PICK_RELEASE_PHASE ;
6924: p_pick_result := G_ONLINE_PICK_RELEASE_RESULT ;
6925: p_pick_skip := G_ONLINE_PICK_RELEASE_SKIP; /*2432800*/