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 433: IF (l_init_rules = FND_API.G_FALSE OR WSH_PR_CRITERIA.g_pick_grouping_rule_id IS NULL

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

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

888: l_date DATE;
889: l_api_version_number NUMBER := 1.0;
890: l_msg_count NUMBER;
891: l_msg_data VARCHAR2(2000);
892: l_commit VARCHAR2(1) := FND_API.G_FALSE;
893: l_return_status VARCHAR2(1);
894: l_request_id NUMBER;
895: l_item_name VARCHAR2(2000);
896: l_message VARCHAR2(2000);

Line 986: p_init_msg_list => fnd_api.g_false,

982: -- of delivery details new records will be added to p_wsh_release_table
983: --
984: WMS_Xdock_Pegging_Pub.Planned_Cross_Dock
985: (p_api_version => l_api_version_number,
986: p_init_msg_list => fnd_api.g_false,
987: p_commit => l_commit,
988: p_batch_id => p_batch_id,
989: p_wsh_release_table => wsh_pr_criteria.release_table,
990: p_trolin_delivery_ids => g_xdock_delivery_ids,

Line 1436: p_init_msg_list => FND_API.G_FALSE,

1432: END IF;
1433: Inv_Move_Order_Pub.Create_Move_Order_Lines
1434: (
1435: p_api_version_number => l_api_version_number,
1436: p_init_msg_list => FND_API.G_FALSE,
1437: p_return_values => FND_API.G_TRUE,
1438: p_commit => l_commit,
1439: p_trolin_tbl => g_trolin_tbl,
1440: p_trolin_val_tbl => l_trolin_val_tbl,

Line 1437: p_return_values => FND_API.G_TRUE,

1433: Inv_Move_Order_Pub.Create_Move_Order_Lines
1434: (
1435: p_api_version_number => l_api_version_number,
1436: p_init_msg_list => FND_API.G_FALSE,
1437: p_return_values => FND_API.G_TRUE,
1438: p_commit => l_commit,
1439: p_trolin_tbl => g_trolin_tbl,
1440: p_trolin_val_tbl => l_trolin_val_tbl,
1441: p_validation_flag => 'N', -- Inventory will skip most validations and assume Shipping validates them

Line 1523: p_init_msg_list => FND_API.G_TRUE,

1519: END IF;
1520: WSH_PICK_LIST.G_AUTO_PICK_CONFIRM := 'Y';
1521: Inv_Express_Pick_Pub.Pick_Release (
1522: p_api_version => l_api_version_number,
1523: p_init_msg_list => FND_API.G_TRUE,
1524: p_commit => l_commit,
1525: p_mo_line_tbl => g_trolin_tbl,
1526: p_grouping_rule_id => p_pick_slip_grouping_rule,
1527: p_reservations_tbl => l_dummy_rsv_tbl,

Line 1528: p_allow_partial_pick => FND_API.G_TRUE,

1524: p_commit => l_commit,
1525: p_mo_line_tbl => g_trolin_tbl,
1526: p_grouping_rule_id => p_pick_slip_grouping_rule,
1527: p_reservations_tbl => l_dummy_rsv_tbl,
1528: p_allow_partial_pick => FND_API.G_TRUE,
1529: p_pick_release_status_tbl=> g_exp_pick_release_stat,
1530: x_return_status => l_return_status,
1531: x_msg_count => l_msg_count,
1532: x_msg_data => l_msg_data);

Line 1913: p_init_msg_list => FND_API.G_FALSE,

1909: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1910: END IF;
1911: WSH_FTE_COMP_CONSTRAINT_PKG.validate_constraint_main (
1912: p_api_version_number => 1.0,
1913: p_init_msg_list => FND_API.G_FALSE,
1914: p_entity_type => 'L',
1915: p_target_id => null,
1916: p_action_code => 'AUTOCREATE-DEL',
1917: p_del_attr_tab => l_cc_del_attr_tab,

Line 2001: p_commit => FND_API.G_FALSE,

1997: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries (
1998: p_delivery_detail_tbl => l_id_tab_temp,
1999: p_append_flag => p_append_flag,
2000: p_group_by_header => p_use_header_flag,
2001: p_commit => FND_API.G_FALSE,
2002: p_lock_rows => FND_API.G_FALSE,
2003: p_check_fte_compatibility => FND_API.G_FALSE,
2004: x_appended_det_tbl => l_appended_det_tbl,
2005: x_unappended_det_tbl => l_unappended_det_tbl,

Line 2002: p_lock_rows => FND_API.G_FALSE,

1998: p_delivery_detail_tbl => l_id_tab_temp,
1999: p_append_flag => p_append_flag,
2000: p_group_by_header => p_use_header_flag,
2001: p_commit => FND_API.G_FALSE,
2002: p_lock_rows => FND_API.G_FALSE,
2003: p_check_fte_compatibility => FND_API.G_FALSE,
2004: x_appended_det_tbl => l_appended_det_tbl,
2005: x_unappended_det_tbl => l_unappended_det_tbl,
2006: x_appended_del_tbl => l_tmp_del_tbl,

Line 2003: p_check_fte_compatibility => FND_API.G_FALSE,

1999: p_append_flag => p_append_flag,
2000: p_group_by_header => p_use_header_flag,
2001: p_commit => FND_API.G_FALSE,
2002: p_lock_rows => FND_API.G_FALSE,
2003: p_check_fte_compatibility => FND_API.G_FALSE,
2004: x_appended_det_tbl => l_appended_det_tbl,
2005: x_unappended_det_tbl => l_unappended_det_tbl,
2006: x_appended_del_tbl => l_tmp_del_tbl,
2007: x_return_status => l_return_status );

Line 2168: p_commit => FND_API.G_FALSE,

2164: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries(
2165: p_delivery_detail_tbl => l_del_details_tbl,
2166: p_append_flag => p_append_flag,
2167: p_group_by_header => p_use_header_flag,
2168: p_commit => FND_API.G_FALSE,
2169: p_lock_rows => FND_API.G_FALSE,
2170: p_check_fte_compatibility => FND_API.G_FALSE,
2171: x_appended_det_tbl => l_appended_det_tbl,
2172: x_unappended_det_tbl => l_unappended_det_tbl,

Line 2169: p_lock_rows => FND_API.G_FALSE,

2165: p_delivery_detail_tbl => l_del_details_tbl,
2166: p_append_flag => p_append_flag,
2167: p_group_by_header => p_use_header_flag,
2168: p_commit => FND_API.G_FALSE,
2169: p_lock_rows => FND_API.G_FALSE,
2170: p_check_fte_compatibility => FND_API.G_FALSE,
2171: x_appended_det_tbl => l_appended_det_tbl,
2172: x_unappended_det_tbl => l_unappended_det_tbl,
2173: x_appended_del_tbl => l_appended_del_tbl,

Line 2170: p_check_fte_compatibility => FND_API.G_FALSE,

2166: p_append_flag => p_append_flag,
2167: p_group_by_header => p_use_header_flag,
2168: p_commit => FND_API.G_FALSE,
2169: p_lock_rows => FND_API.G_FALSE,
2170: p_check_fte_compatibility => FND_API.G_FALSE,
2171: x_appended_det_tbl => l_appended_det_tbl,
2172: x_unappended_det_tbl => l_unappended_det_tbl,
2173: x_appended_del_tbl => l_appended_del_tbl,
2174: x_return_status => l_return_status);

Line 2279: p_commit => FND_API.G_FALSE,

2275: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries(
2276: p_delivery_detail_tbl => l_del_details_tbl,
2277: p_append_flag => p_append_flag,
2278: p_group_by_header => p_use_header_flag,
2279: p_commit => FND_API.G_FALSE,
2280: p_lock_rows => FND_API.G_FALSE,
2281: p_check_fte_compatibility => FND_API.G_FALSE,
2282: x_appended_det_tbl => l_appended_det_tbl,
2283: x_unappended_det_tbl => l_unappended_det_tbl,

Line 2280: p_lock_rows => FND_API.G_FALSE,

2276: p_delivery_detail_tbl => l_del_details_tbl,
2277: p_append_flag => p_append_flag,
2278: p_group_by_header => p_use_header_flag,
2279: p_commit => FND_API.G_FALSE,
2280: p_lock_rows => FND_API.G_FALSE,
2281: p_check_fte_compatibility => FND_API.G_FALSE,
2282: x_appended_det_tbl => l_appended_det_tbl,
2283: x_unappended_det_tbl => l_unappended_det_tbl,
2284: x_appended_del_tbl => l_appended_del_tbl,

Line 2281: p_check_fte_compatibility => FND_API.G_FALSE,

2277: p_append_flag => p_append_flag,
2278: p_group_by_header => p_use_header_flag,
2279: p_commit => FND_API.G_FALSE,
2280: p_lock_rows => FND_API.G_FALSE,
2281: p_check_fte_compatibility => FND_API.G_FALSE,
2282: x_appended_det_tbl => l_appended_det_tbl,
2283: x_unappended_det_tbl => l_unappended_det_tbl,
2284: x_appended_del_tbl => l_appended_del_tbl,
2285: x_return_status => l_return_status);

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

2422: l_dummy VARCHAR2(1);
2423: l_rec_found BOOLEAN;
2424: l_msg_count NUMBER;
2425: l_msg_data VARCHAR2(2000);
2426: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2427: l_request_id NUMBER;
2428: l_item_name VARCHAR2(2000);
2429: l_api_version_number NUMBER := 1.0;
2430: l_message VARCHAR2(2000);

Line 2474: G_CONC_REQ := FND_API.G_TRUE;

2470: SAVEPOINT s_Release_Batch_Sub_sf;
2471:
2472: -- If this is a worker, then it is a concurrent request
2473: IF p_worker_id IS NOT NULL THEN
2474: G_CONC_REQ := FND_API.G_TRUE;
2475: END IF;
2476:
2477: IF G_CONC_REQ = FND_API.G_TRUE AND p_worker_id IS NOT NULL THEN
2478: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;

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

2473: IF p_worker_id IS NOT NULL THEN
2474: G_CONC_REQ := FND_API.G_TRUE;
2475: END IF;
2476:
2477: IF G_CONC_REQ = FND_API.G_TRUE AND p_worker_id IS NOT NULL THEN
2478: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;
2479: IF p_log_level IS NOT NULL THEN -- log level fix
2480: WSH_UTIL_CORE.Set_Log_Level(p_log_level);
2481: WSH_UTIL_CORE.PrintMsg('p_log_level is ' || to_char(p_log_level));

Line 2587: l_done_flag := FND_API.G_FALSE;

2583: WSH_INV_INTEGRATION_GRP.G_ORGSUBTAB.delete ;
2584:
2585: -- Set count for release rows to 0
2586: l_curr_count := 0;
2587: l_done_flag := FND_API.G_FALSE;
2588: l_total_detailed_count := 0;
2589:
2590: -- Reset the Non-Reservable Item Flag as 'N'
2591: WSH_PR_CRITERIA.g_nonreservable_item := 'N';

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

2620: END IF;
2621: --}
2622: l_continue_create_del := 'Y'; -- bug # 8915460 :
2623: -- 10.20.40 Get all lines for Organization-Item Combination and process them
2624: WHILE (l_done_flag = FND_API.G_FALSE) LOOP
2625: --{
2626: -- 10.20.40.10 Select a number of order lines at a time
2627: --{
2628: IF l_debug_on THEN

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

2829: END IF;
2830: --}
2831:
2832: -- Call FTE Load Tender and Issue Commit for Concurrent Express Pick Release
2833: IF l_org_info.express_pick_flag = 'Y' AND ( G_CONC_REQ = FND_API.G_TRUE ) THEN --{
2834: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2835: IF l_debug_on THEN
2836: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2837: END IF;

Line 2922: p_init_msg_list => fnd_api.g_true,

2918: -- to p_wsh_release_table
2919: --bug# 6689448 (replenishment project): added the parameter P_dynamic_replenishment_flag
2920: INV_Pick_Release_Pub.Pick_Release
2921: (p_api_version => l_api_version_number,
2922: p_init_msg_list => fnd_api.g_true,
2923: p_commit => l_commit,
2924: p_mo_line_tbl => g_trolin_tbl,
2925: p_auto_pick_confirm => l_auto_pick_confirm_num,
2926: p_plan_tasks => l_plan_tasks,

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

3023: -- Printing Pick Slips in Immediate Mode
3024: IF l_org_info.express_pick_flag = 'N' AND (l_org_info.autodetail_flag = 'Y')
3025: AND (g_trolin_tbl.count > 0) THEN
3026: --{
3027: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN
3028: --{
3029: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
3030: IF l_debug_on THEN
3031: 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 3082: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN

3078: END IF;
3079: END LOOP;
3080: --}
3081: END IF;
3082: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN
3083: IF l_debug_on THEN
3084: WSH_DEBUG_SV.logmsg(l_module_name, 'Commiting...');
3085: END IF;
3086: COMMIT;

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

3138: --}
3139: ELSIF l_org_info.express_pick_flag = 'N' AND (l_org_info.autodetail_flag = 'N') THEN
3140: -- Need to add this commit for scenarios where Auto Allocate is No and, if number of lines is
3141: -- greater than Pick Release Batch size
3142: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN
3143: IF l_debug_on THEN
3144: WSH_DEBUG_SV.logmsg(l_module_name, 'Commiting...');
3145: END IF;
3146: COMMIT;

Line 3169: p_init_msg_list => FND_API.G_TRUE,

3165: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_PICK_WAVE_PICK_CONFIRM_PUB.PICK_CONFIRM',WSH_DEBUG_SV.C_PROC_LEVEL);
3166: END IF;
3167: INV_Pick_Wave_Pick_Confirm_PUB.Pick_Confirm
3168: (p_api_version_number => l_api_version_number,
3169: p_init_msg_list => FND_API.G_TRUE,
3170: p_commit => l_commit,
3171: p_move_order_type => INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE,
3172: p_transaction_mode => 1,
3173: p_trolin_tbl => g_trolin_tbl,

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

3196: fnd_msg_pub.delete_msg();
3197: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3198: WSH_UTIL_CORE.PrintMsg('Unexpected error. Exiting');
3199: --Bug 4906830
3200: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN
3201: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
3202: errbuf := 'Unexpected error. Exiting';
3203: retcode := '2';
3204: ELSE

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

3215: WSH_DEBUG_SV.logmsg(l_module_name, 'PICK CONFIRM SUCESSFUL' );
3216: END IF;
3217: END IF;
3218:
3219: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN
3220: --{
3221: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
3222: IF l_debug_on THEN
3223: 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 3316: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN

3312: END LOOP;
3313: END IF;
3314: --}
3315:
3316: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN
3317: IF l_debug_on THEN
3318: WSH_DEBUG_SV.logmsg(l_module_name, 'Commiting...');
3319: END IF;
3320: COMMIT;

Line 3507: IF G_CONC_REQ = FND_API.G_TRUE THEN

3503: G_ONLINE_PICK_RELEASE_RESULT := 'S';
3504: G_ONLINE_PICK_RELEASE_PHASE := 'SUCCESS';
3505: END IF;
3506:
3507: IF G_CONC_REQ = FND_API.G_TRUE THEN
3508: -- Set the completion status only in the case of Child Request
3509: -- If this is done as part of Parent Process, this setting will cause program to stop without doing
3510: -- any further processing
3511: IF p_worker_id is not null then

Line 3534: IF G_CONC_REQ = FND_API.G_TRUE THEN

3530: EXCEPTION
3531: WHEN e_return THEN
3532:
3533: --Bug 5355135
3534: IF G_CONC_REQ = FND_API.G_TRUE THEN
3535: ROLLBACK;
3536: ELSE
3537: ROLLBACK TO s_Release_Batch_Sub_sf;
3538: END IF;

Line 3542: IF G_CONC_REQ = FND_API.G_TRUE THEN

3538: END IF;
3539:
3540: WSH_UTIL_CORE.PrintMsg('SQLCODE: '||sqlcode||' SQLERRM: '||sqlerrm);
3541: WSH_UTIL_CORE.PrintMsg('Exception occurred in WSH_PICK_LIST.Release_Batch_Sub');
3542: IF G_CONC_REQ = FND_API.G_TRUE THEN
3543: -- Set the completion status only in the case of Child Request
3544: -- If this is done as part of Parent Process, this setting will cause program to stop without doing
3545: -- any further processing
3546: IF p_worker_id is not null then

Line 3558: IF G_CONC_REQ = FND_API.G_TRUE THEN

3554: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_RETURN');
3555: END IF;
3556: WHEN OTHERS THEN
3557: --Bug 5355135
3558: IF G_CONC_REQ = FND_API.G_TRUE THEN
3559: ROLLBACK;
3560: ELSE
3561: ROLLBACK TO s_Release_Batch_Sub_sf;
3562: END IF;

Line 3566: IF G_CONC_REQ = FND_API.G_TRUE THEN

3562: END IF;
3563:
3564: WSH_UTIL_CORE.PrintMsg('SQLCODE: '||sqlcode||' SQLERRM: '||sqlerrm);
3565: WSH_UTIL_CORE.PrintMsg('Exception occurred in WSH_PICK_LIST.Release_Batch_Sub');
3566: IF G_CONC_REQ = FND_API.G_TRUE THEN
3567: -- Set the completion status only in the case of Child Request
3568: -- If this is done as part of Parent Process, this setting will cause program to stop without doing
3569: -- any further processing
3570: IF p_worker_id is not null then

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

4007: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
4008: l_api_version_number NUMBER := 1.0;
4009: l_msg_count NUMBER;
4010: l_msg_data VARCHAR2(2000);
4011: l_commit VARCHAR2(1) := FND_API.G_FALSE;
4012: l_delivery_id NUMBER;
4013: l_trip_id NUMBER;
4014: l_trip_stop_id NUMBER;
4015: l_ship_from_loc_id NUMBER;

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

4040: l_rowid VARCHAR2(30);
4041: l_curr_count NUMBER;
4042: l_batch_name VARCHAR2(30);
4043: l_task_planning_flag WSH_PICKING_BATCHES.task_planning_flag%TYPE;
4044: l_init_rules VARCHAR2(1) := FND_API.G_FALSE;
4045: l_print_cursor_flag VARCHAR2(1);
4046: l_pr_worker_rec_count NUMBER := 0;
4047: l_counter NUMBER := 0;
4048: l_count NUMBER := 0;

Line 4179: IF G_CONC_REQ = FND_API.G_TRUE THEN

4175: WSH_DCP_PVT.G_CALL_DCP_CHECK := 'N';
4176: END IF;
4177:
4178: -- 30. Logging Settings
4179: IF G_CONC_REQ = FND_API.G_TRUE THEN
4180: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;
4181: IF p_log_level IS NOT NULL THEN
4182: WSH_UTIL_CORE.Set_Log_Level(p_log_level);
4183: WSH_UTIL_CORE.PrintMsg('p_log_level is ' || to_char(p_log_level));

Line 4591: p_init_msg_list => FND_API.G_FALSE,

4587:
4588: Inv_Move_Order_Pub.Create_Move_Order_Header
4589: (
4590: p_api_version_number => l_api_version_number,
4591: p_init_msg_list => FND_API.G_FALSE,
4592: p_return_values => FND_API.G_TRUE,
4593: p_commit => l_commit,
4594: p_trohdr_rec => l_trohdr_rec,
4595: p_trohdr_val_rec => l_trohdr_val_rec,

Line 4592: p_return_values => FND_API.G_TRUE,

4588: Inv_Move_Order_Pub.Create_Move_Order_Header
4589: (
4590: p_api_version_number => l_api_version_number,
4591: p_init_msg_list => FND_API.G_FALSE,
4592: p_return_values => FND_API.G_TRUE,
4593: p_commit => l_commit,
4594: p_trohdr_rec => l_trohdr_rec,
4595: p_trohdr_val_rec => l_trohdr_val_rec,
4596: x_trohdr_rec => l_trohdr_rec,

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

4625:
4626: -- 90.8 Data should be committed only in case of a concurrent request.
4627: -- Data should not be commited if its ONLINE/From PUBLIC API.
4628: -- In case of Online data is committed from Pick Release form.
4629: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN
4630: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
4631: IF l_debug_on THEN
4632: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
4633: END IF;

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

5002: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
5003: l_errors := l_errors + 1;
5004: END IF;
5005: l_detail_pfetch := c_get_backordered_details%ROWCOUNT;
5006: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN
5007: IF l_debug_on THEN
5008: WSH_DEBUG_SV.logmsg(l_module_name, 'Commiting...');
5009: END IF;
5010: COMMIT;

Line 5161: p_init_msg_list => FND_API.G_FALSE,

5157: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_INTEGRATION.Rate_Delivery',WSH_DEBUG_SV.C_PROC_LEVEL);
5158: END IF;
5159: WSH_FTE_INTEGRATION.Rate_Delivery (
5160: p_api_version => 1.0,
5161: p_init_msg_list => FND_API.G_FALSE,
5162: p_commit => FND_API.G_FALSE,
5163: p_in_param_rec => l_in_param_rec,
5164: x_out_param_rec => l_out_param_rec,
5165: x_return_status => l_return_status,

Line 5162: p_commit => FND_API.G_FALSE,

5158: END IF;
5159: WSH_FTE_INTEGRATION.Rate_Delivery (
5160: p_api_version => 1.0,
5161: p_init_msg_list => FND_API.G_FALSE,
5162: p_commit => FND_API.G_FALSE,
5163: p_in_param_rec => l_in_param_rec,
5164: x_out_param_rec => l_out_param_rec,
5165: x_return_status => l_return_status,
5166: x_msg_count => l_msg_count,

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

5260: l_detail_pfetch := c_batch_unplanned_del%ROWCOUNT;
5261: END LOOP; --}
5262: END IF; --} --WMS High Vol Support
5263:
5264: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN
5265: IF l_debug_on THEN
5266: WSH_DEBUG_SV.logmsg(l_module_name, 'Commiting...');
5267: END IF;
5268: COMMIT;

Line 5372: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

5368: ,WSH_DEBUG_SV.C_PROC_LEVEL);
5369: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
5370: END IF;
5371: INV_MOVE_ORDER_PUB.Stamp_Cart_Id (
5372: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5373: p_carton_grouping_tbl => l_carton_grouping_tbl,
5374: p_move_order_line_tbl => l_mo_lines_tbl );
5375: IF l_debug_on THEN
5376: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);

Line 5417: p_allow_partial_pick => FND_API.G_TRUE,

5413: p_auto_pick_confirm => l_org_info_tbl(v_wms_org_rec.organization_id).auto_pick_confirm,
5414: p_wsh_status => NVL(l_retcode,0), -- Current Request Status
5415: p_wsh_mode => l_mode,
5416: p_grouping_rule_id => l_org_info_tbl(v_wms_org_rec.organization_id).pick_grouping_rule_id,
5417: p_allow_partial_pick => FND_API.G_TRUE,
5418: p_plan_tasks => l_org_info_tbl(l_organization_id).task_planning_flag,
5419: x_return_status => l_return_status,
5420: x_org_complete => l_org_complete);
5421: IF l_debug_on THEN

Line 5509: p_init_msg_list => FND_API.G_FALSE,

5505: ,WSH_DEBUG_SV.C_PROC_LEVEL);
5506: END IF;
5507: Inv_Move_Order_Pub.Process_Move_Order (
5508: p_api_version_number => l_api_version_number,
5509: p_init_msg_list => FND_API.G_FALSE,
5510: p_return_values => FND_API.G_TRUE,
5511: p_commit => l_commit,
5512: p_trohdr_rec => l_trohdr_rec,
5513: x_trohdr_rec => l_trohdr_rec,

Line 5510: p_return_values => FND_API.G_TRUE,

5506: END IF;
5507: Inv_Move_Order_Pub.Process_Move_Order (
5508: p_api_version_number => l_api_version_number,
5509: p_init_msg_list => FND_API.G_FALSE,
5510: p_return_values => FND_API.G_TRUE,
5511: p_commit => l_commit,
5512: p_trohdr_rec => l_trohdr_rec,
5513: x_trohdr_rec => l_trohdr_rec,
5514: x_trohdr_val_rec => l_trohdr_val_rec,

Line 5659: IF G_CONC_REQ = FND_API.G_TRUE THEN

5655: G_ONLINE_PICK_RELEASE_RESULT := 'S';
5656: G_ONLINE_PICK_RELEASE_PHASE := 'SUCCESS';
5657: END IF;
5658:
5659: IF G_CONC_REQ = FND_API.G_TRUE THEN
5660: IF l_completion_status = 'NORMAL' THEN
5661: errbuf := 'Pick selection completed successfully';
5662: ELSIF l_completion_status = 'WARNING' THEN
5663: errbuf := 'Pick selection is completed with warning';

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

5669: IF l_debug_on THEN
5670: WSH_DEBUG_SV.log(l_module_name,'l_completion_status',l_completion_status);
5671: END IF;
5672:
5673: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN
5674: IF l_debug_on THEN
5675: WSH_DEBUG_SV.logmsg(l_module_name, 'Commiting...');
5676: END IF;
5677: COMMIT;

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

5679:
5680: END IF; --}
5681:
5682: -- If pick released successfully see if we want to autopack/shipconfirm
5683: IF ((G_CONC_REQ = FND_API.G_TRUE AND l_completion_status <> 'ERROR') OR
5684: G_ONLINE_PICK_RELEASE_RESULT IN ('S', 'W'))
5685: AND (WSH_PR_CRITERIA.g_autopack_flag = 'Y' OR WSH_PR_CRITERIA.g_non_picking_flag in ('P', 'S') OR
5686: WSH_PR_CRITERIA.g_auto_ship_confirm_rule_id IS NOT NULL)
5687: AND (l_mode IS NULL OR l_mode IN ('PICK-SS','PICK')) THEN

Line 5775: IF G_CONC_REQ = FND_API.G_TRUE THEN

5771: -- Autopack should be set only if Non Pick Flag as 'P' and AP Level is set
5772: IF WSH_PR_CRITERIA.g_non_picking_flag = 'P' AND NVL(l_ap_level,0) > 0 THEN
5773: l_act_ap_level := NVL(l_ap_level,0);
5774: ELSIF WSH_PR_CRITERIA.g_non_picking_flag = 'P' AND NVL(l_ap_level,0) = 0 THEN
5775: IF G_CONC_REQ = FND_API.G_TRUE THEN
5776: WSH_UTIL_CORE.PrintMsg('** Warning : Autopack Option is No for the organization - Packing action not performed **');
5777: END IF;
5778: l_act_ap_level := 0;
5779: ELSE

Line 5921: IF G_CONC_REQ = FND_API.G_TRUE THEN

5917: IF (WSH_PR_CRITERIA.g_autopack_flag = 'Y')
5918: OR (NVL(l_ap_level,0) > 0 AND WSH_PR_CRITERIA.g_non_picking_flag = 'P') THEN
5919: l_act_ap_level := NVL(l_ap_level,0);
5920: ELSIF WSH_PR_CRITERIA.g_non_picking_flag = 'P' AND NVL(l_ap_level,0) = 0 THEN
5921: IF G_CONC_REQ = FND_API.G_TRUE THEN
5922: WSH_UTIL_CORE.PrintMsg('** Warning : Autopack Option is No for the organization - Packing action not performed **');
5923: END IF;
5924: l_act_ap_level := 0;
5925: ELSE

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

6061: END IF; -- Pack/Ship Grouping
6062:
6063: WSH_UTIL_CORE.PrintDateTime;
6064:
6065: IF ((G_CONC_REQ = FND_API.G_TRUE AND l_completion_status <> 'ERROR') OR
6066: G_ONLINE_PICK_RELEASE_RESULT IN ('S', 'W'))
6067: AND (WSH_PR_CRITERIA.g_autopack_flag = 'Y' OR WSH_PR_CRITERIA.g_non_picking_flag in ('P', 'S') OR
6068: WSH_PR_CRITERIA.g_auto_ship_confirm_rule_id IS NOT NULL) THEN --{
6069: -- Get all Trip Stops for setting Trip to In-Transit or Closed

Line 6329: IF G_CONC_REQ = FND_API.G_TRUE THEN

6325: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
6326: END IF;
6327: --}
6328:
6329: IF G_CONC_REQ = FND_API.G_TRUE THEN
6330: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
6331: IF l_completion_status = 'NORMAL' THEN
6332: retcode := '0';
6333: ELSIF l_completion_status = 'WARNING' THEN

Line 6381: IF G_CONC_REQ = FND_API.G_TRUE THEN

6377: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
6378: END IF;
6379: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
6380: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
6381: IF G_CONC_REQ = FND_API.G_TRUE THEN
6382: l_completion_status := 'ERROR';
6383: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
6384: errbuf := 'Pick selection is completed with error';
6385: retcode := '2';

Line 6393: IF G_CONC_REQ = FND_API.G_TRUE THEN

6389: ROLLBACK TO S_CALL_FTE_LOAD_TENDER_API_SP;
6390: END IF;
6391:
6392: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
6393: IF G_CONC_REQ = FND_API.G_TRUE THEN
6394: IF l_completion_status = 'NORMAL' THEN
6395: l_completion_status := 'WARNING';
6396: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
6397: errbuf := 'Pick selection is completed with warning';

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

6422: --Bug 5355135
6423: -- Since we rollback to savepoint do not use this exception if
6424: -- a commit or rollback has happened for on-line mode
6425:
6426: IF ( G_CONC_REQ = FND_API.G_TRUE ) THEN
6427: ROLLBACK;
6428: ELSE
6429: ROLLBACK TO s_Release_Batch_sp;
6430: END IF;

Line 6500: IF G_CONC_REQ = FND_API.G_TRUE THEN

6496: END IF;
6497: IF c_requests%ISOPEN THEN
6498: CLOSE c_requests;
6499: END IF;
6500: IF G_CONC_REQ = FND_API.G_TRUE THEN
6501: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
6502: errbuf := 'Exception occurred in WSH_PICK_LIST';
6503: retcode := '2';
6504: END IF;

Line 6594: IF G_CONC_REQ = FND_API.G_TRUE THEN

6590: END IF;
6591: IF c_requests%ISOPEN THEN
6592: CLOSE c_requests;
6593: END IF;
6594: IF G_CONC_REQ = FND_API.G_TRUE THEN
6595: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
6596: errbuf := 'Exception occurred in WSH_PICK_LIST';
6597: retcode := '2';
6598: END IF;

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

6641: errbuf OUT NOCOPY VARCHAR2,
6642: retcode OUT NOCOPY VARCHAR2,
6643: p_rule_id IN NUMBER,
6644: p_batch_prefix IN VARCHAR2,
6645: p_log_level IN NUMBER, -- Commented as per GSCC Standards DEFAULT FND_API.G_MISS_NUM log level fix
6646: p_ship_confirm_rule_id IN NUMBER,
6647: p_actual_departure_date IN VARCHAR2,
6648: p_num_workers IN NUMBER
6649: ) IS

Line 7009: IF G_CONC_REQ = FND_API.G_TRUE THEN

7005: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7006: FND_MSG_PUB.Add_Exc_Msg( 'WSH_PICK_LIST', 'Release_Batch_SRS' );
7007: END IF;
7008: --
7009: IF G_CONC_REQ = FND_API.G_TRUE THEN
7010: l_ret_code := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
7011: errbuf := 'Exception occurred in Release_Batch_SRS';
7012: retcode := '2';
7013: END IF;

Line 7063: G_CONC_REQ := FND_API.G_FALSE;

7059: WSH_DEBUG_SV.push(l_module_name);
7060: WSH_DEBUG_SV.log(l_module_name,'P_BATCH_ID',P_BATCH_ID);
7061: END IF;
7062: --
7063: G_CONC_REQ := FND_API.G_FALSE;
7064: Release_Batch(l_dummy1,l_dummy2,p_batch_id, p_num_workers => 1);
7065: p_pick_phase := G_ONLINE_PICK_RELEASE_PHASE ;
7066: p_pick_result := G_ONLINE_PICK_RELEASE_RESULT ;
7067: p_pick_skip := G_ONLINE_PICK_RELEASE_SKIP; /*2432800*/