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_WAVE_PLANNING_PVT dependencies on FND_API

Line 761: RAISE fnd_api.g_exc_unexpected_error;

757: commit; -- Bug 12733479
758:
759: IF p_request_id = 0 then
760: print_debug('Request submission failed for Plan Wave.', l_debug);
761: RAISE fnd_api.g_exc_unexpected_error;
762: ELSE
763: -- Bug 12733479
764: l_dummy := FND_CONCURRENT.WAIT_FOR_REQUEST(request_id => plan_request_id,
765: interval => 5,

Line 833: RAISE fnd_api.g_exc_unexpected_error;

829: commit; -- Bug 12733479
830:
831: IF p_request_id = 0 then
832: print_debug('Request submission failed for Release Wave.', l_debug);
833: RAISE fnd_api.g_exc_unexpected_error;
834: ELSE
835: -- Bug 12733479
836: l_dummy := FND_CONCURRENT.WAIT_FOR_REQUEST(request_id => p_request_id,
837: interval => 5,

Line 893: RAISE fnd_api.g_exc_unexpected_error;

889: exception
890: WHEN wave_creation_exception then
891:
892: rollback to create_wave_lines_sp;
893: RAISE fnd_api.g_exc_unexpected_error;
894:
895: WHEN wave_line_exception then
896:
897: rollback to create_wave_lines_sp;

Line 900: RAISE fnd_api.g_exc_unexpected_error;

896:
897: rollback to create_wave_lines_sp;
898:
899: delete_wave_header(v_wave_header_id);
900: RAISE fnd_api.g_exc_unexpected_error;
901:
902: -- l_completion_status := 'ERROR';
903:
904: /* l_dummy := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,

Line 916: RAISE fnd_api.g_exc_unexpected_error;

912: /* l_dummy := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,
913:
914: '');*/
915:
916: RAISE fnd_api.g_exc_unexpected_error;
917: end launch_concurrent_CP;
918:
919: PROCEDURE Plan_Wave_CP(errbuf OUT NOCOPY VARCHAR2,
920: retcode OUT NOCOPY NUMBER,

Line 942: RAISE fnd_api.g_exc_unexpected_error;

938: plan_wave(p_wave_header_id, p_planning_criteria_id, x_return_Status);
939:
940: if x_return_Status <> 'S' then
941:
942: RAISE fnd_api.g_exc_unexpected_error;
943:
944: end if;
945:
946: end if;

Line 955: RAISE fnd_api.g_exc_unexpected_error;

951:
952: print_debug('Error in Plan Wave CP: ' || SQLCODE || ' : ' || SQLERRM,
953: l_debug);
954: rollback to plan_wave_concurrent_sp;
955: RAISE fnd_api.g_exc_unexpected_error;
956: end plan_wave_cp;
957:
958: procedure insert_wave_record(p_wave_header_id in OUT NOCOPY number) is
959: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

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

2288: p_planning_criteria_id in number)
2289:
2290: is
2291: l_api_version_number NUMBER := 1.0;
2292: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2293:
2294: -- X-dock, declare package level global variables
2295: g_allocation_method WSH_PICKING_BATCHES.ALLOCATION_METHOD%TYPE;
2296: g_xdock_delivery_ids WSH_UTIL_CORE.Id_Tab_Type; -- used for X-dock only

Line 2361: p_init_msg_list => fnd_api.g_false,

2357: end loop;
2358:
2359:
2360: WMS_Xdock_Pegging_Pub.Planned_Cross_Dock(p_api_version => l_api_version_number,
2361: p_init_msg_list => fnd_api.g_false,
2362: p_commit => l_commit,
2363: p_batch_id => null,
2364: p_wsh_release_table => xdock,
2365: p_trolin_delivery_ids => g_xdock_delivery_ids,

Line 2446: x_return_status := FND_API.G_RET_STS_SUCCESS;

2442: OPEN fetch_wdd(p_wave_id);
2443: fetch fetch_wdd bulk collect
2444: into g_troline_table;
2445:
2446: x_return_status := FND_API.G_RET_STS_SUCCESS;
2447:
2448: EXCEPTION
2449: WHEN No_Data_Found THEN
2450: print_debug('No Data Found Exception in initialize',l_debug);

Line 2451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2447:
2448: EXCEPTION
2449: WHEN No_Data_Found THEN
2450: print_debug('No Data Found Exception in initialize',l_debug);
2451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2452: WHEN OTHERS THEN
2453: print_debug('OTHER Exception in initialize',l_debug);
2454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2455:

Line 2454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2450: print_debug('No Data Found Exception in initialize',l_debug);
2451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2452: WHEN OTHERS THEN
2453: print_debug('OTHER Exception in initialize',l_debug);
2454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2455:
2456: END initialize;
2457:
2458:

Line 2515: --x_return_status := fnd_api.g_ret_sts_success;

2511: l_return_status varchar2(10);
2512: BEGIN
2513: print_debug('In Create Move Order', l_debug);
2514: SAVEPOINT create_move_order;
2515: --x_return_status := fnd_api.g_ret_sts_success;
2516:
2517: SELECT MTL_TXN_REQUEST_HEADERS_S.NEXTVAL
2518: into l_request_number
2519: FROM SYS.DUAL;

Line 2639: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2635: x_matched_entities => l_matched_entities,
2636: x_out_rec => l_out_rec,
2637: x_return_status => l_return_status);
2638:
2639: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2640: print_debug('Error status from Find_Matching_Groups: ' || l_return_status, l_debug);
2641: RAISE fnd_api.g_exc_unexpected_error;
2642: END IF;
2643:

Line 2641: RAISE fnd_api.g_exc_unexpected_error;

2637: x_return_status => l_return_status);
2638:
2639: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2640: print_debug('Error status from Find_Matching_Groups: ' || l_return_status, l_debug);
2641: RAISE fnd_api.g_exc_unexpected_error;
2642: END IF;
2643:
2644: for i in 1 .. l_attr_tab.count loop
2645:

Line 2985: RAISE fnd_api.g_exc_unexpected_error;

2981: print_debug( 'g_mtrl_tbl.Count is '||g_mtrl_tbl.Count, l_debug);
2982:
2983: IF l_wdd_count <> g_mtrl_tbl.Count THEN
2984: print_debug('Could not update all WDD lines', l_debug);
2985: RAISE fnd_api.g_exc_unexpected_error;
2986: ELSE
2987: g_update_wdd := 'Y';
2988: END IF;
2989:

Line 2994: x_return_status := FND_API.G_RET_STS_SUCCESS;

2990: x_mo_header_id := l_mo_header_id;
2991: x_request_number := l_request_number;
2992:
2993: COMMIT;
2994: x_return_status := FND_API.G_RET_STS_SUCCESS;
2995: print_debug('Exiting Create Move Order', l_debug);
2996:
2997: EXCEPTION
2998: WHEN OTHERS THEN

Line 3001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2997: EXCEPTION
2998: WHEN OTHERS THEN
2999: print_debug('Error in create_move_order',l_debug);
3000: ROLLBACK TO create_move_order;
3001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3002:
3003: END create_move_order;
3004:
3005:

Line 3692: x_return_status := FND_API.G_RET_STS_SUCCESS;

3688: FROM wms_wp_reservations_gtmp;
3689: END IF;
3690:
3691: COMMIT;
3692: x_return_status := FND_API.G_RET_STS_SUCCESS;
3693:
3694: EXCEPTION
3695:
3696: WHEN OTHERS THEN

Line 3698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3694: EXCEPTION
3695:
3696: WHEN OTHERS THEN
3697: print_debug('Error in process_reservation. Action is '||p_action, l_debug);
3698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3699:
3700: END process_reservations;
3701:
3702:

Line 3747: x_return_status := fnd_api.g_ret_sts_success;

3743: if l_request_data is NULL then
3744:
3745:
3746: PRINT_DEBUG('In spawn_workers ',l_debug);
3747: x_return_status := fnd_api.g_ret_sts_success;
3748:
3749: -- l_sub_request := TRUE;
3750: -- print_debug ('Sub request is TRUE.', l_debug);
3751:

Line 3771: RAISE fnd_api.g_exc_unexpected_error;

3767:
3768: COMMIT;
3769: IF l_request_id = 0 THEN
3770: print_debug( 'Request submission failed for worker ' || i, l_debug);
3771: RAISE fnd_api.g_exc_unexpected_error;
3772: ELSE
3773: print_debug( 'Request ' || l_request_id ||' submitted successfully' , l_debug);
3774: END IF;
3775: END LOOP; --}

Line 3795: x_return_status := fnd_api.g_ret_sts_unexp_error;

3791:
3792: EXCEPTION
3793: WHEN OTHERS THEN
3794: print_debug ('Other error: ' || SQLERRM, l_debug);
3795: x_return_status := fnd_api.g_ret_sts_unexp_error;
3796:
3797: END spawn_workers;
3798:
3799: PROCEDURE fetch_next_wpr_rec

Line 3822: x_return_status := fnd_api.g_ret_sts_success;

3818: record_locked_exc EXCEPTION;
3819: PRAGMA EXCEPTION_INIT (record_locked_exc, -54);
3820:
3821: BEGIN
3822: x_return_status := fnd_api.g_ret_sts_success;
3823:
3824: SAVEPOINT fetch_wpr_sp;
3825:
3826: print_debug( 'Entered fetch_next_wpr_rec with parameters: ' || g_newline ||

Line 3899: RAISE fnd_api.g_exc_unexpected_error;

3895: done := TRUE;
3896: WHEN OTHERS THEN
3897: print_debug ('Other error: ' || SQLERRM, l_debug);
3898: done := TRUE;
3899: RAISE fnd_api.g_exc_unexpected_error;
3900: END;
3901:
3902: END LOOP; --}
3903: ELSE

Line 3905: RAISE fnd_api.g_exc_unexpected_error;

3901:
3902: END LOOP; --}
3903: ELSE
3904: print_debug ('Invalid Mode ', l_debug);
3905: RAISE fnd_api.g_exc_unexpected_error;
3906:
3907: END IF;
3908:
3909: IF x_return_status = fnd_api.g_ret_sts_success THEN

Line 3909: IF x_return_status = fnd_api.g_ret_sts_success THEN

3905: RAISE fnd_api.g_exc_unexpected_error;
3906:
3907: END IF;
3908:
3909: IF x_return_status = fnd_api.g_ret_sts_success THEN
3910: x_inventory_item_id := l_inventory_item_id;
3911: END IF;
3912:
3913: EXCEPTION

Line 3916: x_return_status := fnd_api.g_ret_sts_unexp_error;

3912:
3913: EXCEPTION
3914: WHEN OTHERS THEN
3915: ROLLBACK TO fetch_wpr_sp;
3916: x_return_status := fnd_api.g_ret_sts_unexp_error;
3917: print_debug ('Other error: ' || SQLERRM, l_debug);
3918:
3919: END fetch_next_wpr_rec;
3920:

Line 3988: pick_methodology_id, container_item_id, carton_grouping_id, FND_API.G_MISS_CHAR, FND_API.G_MISS_CHAR,

3984: to_locator_id, to_subinventory_code, to_subinventory_id, transaction_header_id, transaction_type_id,
3985: txn_source_id, txn_source_line_id, txn_source_line_detail_id, transaction_source_type_id, primary_quantity,
3986: to_organization_id, pick_strategy_id, put_away_strategy_id, uom_code, unit_number,
3987: ship_to_location_id, from_cost_group_id, to_cost_group_id, lpn_id, to_lpn_id,
3988: pick_methodology_id, container_item_id, carton_grouping_id, FND_API.G_MISS_CHAR, FND_API.G_MISS_CHAR,
3989: FND_API.G_MISS_CHAR, inspection_status, wms_process_flag, pick_slip_number, pick_slip_date,
3990: ship_set_id, ship_model_id, model_quantity, required_quantity, secondary_quantity,
3991: secondary_uom_code, secondary_quantity_detailed, secondary_quantity_delivered, grade_code, secondary_required_quantity
3992: FROM mtl_txn_request_lines mtrl, wms_wp_rules_simulation wwr

Line 3989: FND_API.G_MISS_CHAR, inspection_status, wms_process_flag, pick_slip_number, pick_slip_date,

3985: txn_source_id, txn_source_line_id, txn_source_line_detail_id, transaction_source_type_id, primary_quantity,
3986: to_organization_id, pick_strategy_id, put_away_strategy_id, uom_code, unit_number,
3987: ship_to_location_id, from_cost_group_id, to_cost_group_id, lpn_id, to_lpn_id,
3988: pick_methodology_id, container_item_id, carton_grouping_id, FND_API.G_MISS_CHAR, FND_API.G_MISS_CHAR,
3989: FND_API.G_MISS_CHAR, inspection_status, wms_process_flag, pick_slip_number, pick_slip_date,
3990: ship_set_id, ship_model_id, model_quantity, required_quantity, secondary_quantity,
3991: secondary_uom_code, secondary_quantity_detailed, secondary_quantity_delivered, grade_code, secondary_required_quantity
3992: FROM mtl_txn_request_lines mtrl, wms_wp_rules_simulation wwr
3993: WHERE mtrl.TXN_SOURCE_LINE_DETAIL_ID = wwr.delivery_detail_id

Line 4014: mtrl.pick_methodology_id, mtrl.container_item_id, mtrl.carton_grouping_id, FND_API.G_MISS_CHAR, FND_API.G_MISS_CHAR,

4010: mtrl.to_locator_id, mtrl.to_subinventory_code, mtrl.to_subinventory_id, mtrl.transaction_header_id, mtrl.transaction_type_id,
4011: mtrl.txn_source_id, mtrl.txn_source_line_id, mtrl.txn_source_line_detail_id, mtrl.transaction_source_type_id, mtrl.primary_quantity,
4012: mtrl.to_organization_id, mtrl.pick_strategy_id, mtrl.put_away_strategy_id, mtrl.uom_code, mtrl.unit_number,
4013: mtrl.ship_to_location_id, mtrl.from_cost_group_id, mtrl.to_cost_group_id, mtrl.lpn_id, mtrl.to_lpn_id,
4014: mtrl.pick_methodology_id, mtrl.container_item_id, mtrl.carton_grouping_id, FND_API.G_MISS_CHAR, FND_API.G_MISS_CHAR,
4015: FND_API.G_MISS_CHAR, mtrl.inspection_status, mtrl.wms_process_flag, mtrl.pick_slip_number, mtrl.pick_slip_date,
4016: mtrl.ship_set_id, mtrl.ship_model_id, mtrl.model_quantity, mtrl.required_quantity, mtrl.secondary_quantity,
4017: mtrl.secondary_uom_code, mtrl.secondary_quantity_detailed, mtrl.secondary_quantity_delivered, mtrl.grade_code, mtrl.secondary_required_quantity
4018: FROM mtl_txn_request_lines mtrl, wms_wp_rules_simulation wwr, wsh_delivery_details wdd

Line 4015: FND_API.G_MISS_CHAR, mtrl.inspection_status, mtrl.wms_process_flag, mtrl.pick_slip_number, mtrl.pick_slip_date,

4011: mtrl.txn_source_id, mtrl.txn_source_line_id, mtrl.txn_source_line_detail_id, mtrl.transaction_source_type_id, mtrl.primary_quantity,
4012: mtrl.to_organization_id, mtrl.pick_strategy_id, mtrl.put_away_strategy_id, mtrl.uom_code, mtrl.unit_number,
4013: mtrl.ship_to_location_id, mtrl.from_cost_group_id, mtrl.to_cost_group_id, mtrl.lpn_id, mtrl.to_lpn_id,
4014: mtrl.pick_methodology_id, mtrl.container_item_id, mtrl.carton_grouping_id, FND_API.G_MISS_CHAR, FND_API.G_MISS_CHAR,
4015: FND_API.G_MISS_CHAR, mtrl.inspection_status, mtrl.wms_process_flag, mtrl.pick_slip_number, mtrl.pick_slip_date,
4016: mtrl.ship_set_id, mtrl.ship_model_id, mtrl.model_quantity, mtrl.required_quantity, mtrl.secondary_quantity,
4017: mtrl.secondary_uom_code, mtrl.secondary_quantity_detailed, mtrl.secondary_quantity_delivered, mtrl.grade_code, mtrl.secondary_required_quantity
4018: FROM mtl_txn_request_lines mtrl, wms_wp_rules_simulation wwr, wsh_delivery_details wdd
4019: WHERE mtrl.TXN_SOURCE_LINE_DETAIL_ID = wwr.delivery_detail_id

Line 4043: --x_return_status := fnd_api.g_ret_sts_success;

4039: 'p_mode => ' || TO_CHAR(p_mode) || g_newline ||
4040: 'p_worker_id => ' || TO_CHAR(p_worker_id)
4041: ,l_debug);
4042:
4043: --x_return_status := fnd_api.g_ret_sts_success;
4044:
4045: LOOP --{
4046: l_return_status := fnd_api.g_ret_sts_success;
4047: fetch_next_wpr_rec

Line 4046: l_return_status := fnd_api.g_ret_sts_success;

4042:
4043: --x_return_status := fnd_api.g_ret_sts_success;
4044:
4045: LOOP --{
4046: l_return_status := fnd_api.g_ret_sts_success;
4047: fetch_next_wpr_rec
4048: ( p_organization_id => p_organization_id
4049: , p_wave_id => p_wave_id
4050: , p_mo_header_id => p_mo_header_id

Line 4060: ELSIF l_return_status <> fnd_api.g_ret_sts_success THEN

4056: print_debug('Return status after fetch_next_wpr_rec '||l_return_status, l_debug);
4057: IF l_return_status = 'N' THEN
4058: print_debug ( 'No more records in WPR', l_debug );
4059: EXIT;
4060: ELSIF l_return_status <> fnd_api.g_ret_sts_success THEN
4061: print_debug('Error status from fetch_next_wpr_rec: ' || l_return_status, l_debug);
4062: RAISE fnd_api.g_exc_unexpected_error;
4063: END IF;
4064:

Line 4062: RAISE fnd_api.g_exc_unexpected_error;

4058: print_debug ( 'No more records in WPR', l_debug );
4059: EXIT;
4060: ELSIF l_return_status <> fnd_api.g_ret_sts_success THEN
4061: print_debug('Error status from fetch_next_wpr_rec: ' || l_return_status, l_debug);
4062: RAISE fnd_api.g_exc_unexpected_error;
4063: END IF;
4064:
4065: OPEN c1;
4066: FETCH c1 BULK COLLECT INTO l_mo_line_tbl;

Line 4115: raise fnd_api.g_exc_unexpected_error;

4111:
4112: l_return_value := INV_CACHE.set_item_rec(l_mo_line.organization_id, l_mo_line.inventory_item_id);
4113: IF NOT l_return_value THEN
4114: print_debug('Error setting item cache', 'Inv_Pick_Release_PVT.Process_Line');
4115: raise fnd_api.g_exc_unexpected_error;
4116: End If;
4117: l_reservable_type:= INV_CACHE.item_rec.reservable_type;
4118:
4119: IF l_reservable_type = 2 THEN

Line 4130: , p_init_msg_list => fnd_api.g_false

4126:
4127: ELSE
4128: INV_Pick_Release_PVT.Process_Line(
4129: p_api_version => 1.0
4130: , p_init_msg_list => fnd_api.g_false
4131: , p_commit => fnd_api.g_false
4132: , x_return_status => l_return_status
4133: , x_msg_count => l_msg_count
4134: , x_msg_data => l_msg_data

Line 4131: , p_commit => fnd_api.g_false

4127: ELSE
4128: INV_Pick_Release_PVT.Process_Line(
4129: p_api_version => 1.0
4130: , p_init_msg_list => fnd_api.g_false
4131: , p_commit => fnd_api.g_false
4132: , x_return_status => l_return_status
4133: , x_msg_count => l_msg_count
4134: , x_msg_data => l_msg_data
4135: , p_mo_line_rec => l_mo_line

Line 4144: /*IF l_return_status <> fnd_api.g_ret_sts_success THEN

4140: , p_plan_tasks => TRUE
4141: , p_wave_simulation_mode => 'Y'
4142: );
4143: print_debug('Allocation: return status after INV_Pick_Release_PVT.Process_Line for line_id '||l_mo_line.line_id||': '||l_return_status, l_debug);
4144: /*IF l_return_status <> fnd_api.g_ret_sts_success THEN
4145: ROLLBACK;
4146: END IF;
4147: */
4148: END IF;

Line 4181: secondary_quantity = decode(secondary_quantity, fnd_api.g_miss_num, NULL, 0),

4177: l_mo_line := l_mo_line_tbl(l_set_index);
4178: update mtl_txn_request_lines
4179: set quantity = 0,
4180: quantity_detailed = 0,
4181: secondary_quantity = decode(secondary_quantity, fnd_api.g_miss_num, NULL, 0),
4182: secondary_quantity_detailed = decode(secondary_quantity_detailed, fnd_api.g_miss_num, NULL, 0),
4183: line_status = 5,
4184: status_date = sysdate
4185: where line_id = l_mo_line.line_id;

Line 4182: secondary_quantity_detailed = decode(secondary_quantity_detailed, fnd_api.g_miss_num, NULL, 0),

4178: update mtl_txn_request_lines
4179: set quantity = 0,
4180: quantity_detailed = 0,
4181: secondary_quantity = decode(secondary_quantity, fnd_api.g_miss_num, NULL, 0),
4182: secondary_quantity_detailed = decode(secondary_quantity_detailed, fnd_api.g_miss_num, NULL, 0),
4183: line_status = 5,
4184: status_date = sysdate
4185: where line_id = l_mo_line.line_id;
4186:

Line 4219: RAISE fnd_api.g_exc_unexpected_error;

4215: EXCEPTION
4216: WHEN NO_DATA_FOUND then
4217: print_debug('No Order Line Quantity found', l_debug);
4218: ROLLBACK;
4219: RAISE fnd_api.g_exc_unexpected_error;
4220: END;
4221:
4222: BEGIN
4223: SELECT primary_uom_code

Line 4232: RAISE fnd_api.g_exc_unexpected_error;

4228: EXCEPTION
4229: WHEN no_data_found THEN
4230: ROLLBACK;
4231: print_debug('No Item Info found', l_debug);
4232: RAISE fnd_api.g_exc_unexpected_error;
4233: END;
4234:
4235: IF l_txn_source_line_uom <> l_primary_uom THEN
4236: l_cur_txn_source_req_qty := inv_convert.inv_um_convert(l_mo_line.inventory_item_id,

Line 4270: RAISE fnd_api.g_exc_unexpected_error;

4266: EXCEPTION
4267: WHEN NO_DATA_FOUND then
4268: print_debug('No Order Line Quantity found', l_debug);
4269: ROLLBACK;
4270: RAISE fnd_api.g_exc_unexpected_error;
4271: END;
4272:
4273: if l_txn_source_line_uom <> l_primary_uom then
4274: l_cur_txn_source_req_qty := inv_convert.inv_um_convert(l_mo_line.inventory_item_id,

Line 4299: RAISE fnd_api.g_exc_unexpected_error;

4295: print_debug('New line qty: ' || l_new_line_quantity, l_debug);
4296: l_return_value := INV_CACHE.set_wdd_rec(l_mo_line.line_id);
4297: If NOT l_return_value Then
4298: print_debug('Error setting cache for delivery line',l_debug);
4299: RAISE fnd_api.g_exc_unexpected_error;
4300: End If;
4301: END IF;
4302:
4303: l_set_new_req_qty := l_set_new_req_qty - l_new_line_quantity;

Line 4434: x_return_status := FND_API.G_RET_STS_SUCCESS;

4430:
4431: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4432: begin
4433: print_debug('In init_allocation',l_debug);
4434: x_return_status := FND_API.G_RET_STS_SUCCESS;
4435:
4436:
4437: IF g_enforce_ship_set_and_smc = 'N' THEN
4438: OPEN c1;

Line 4484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4480: AND processed_flag='N'
4481: AND transaction_batch_id IS NULL;
4482:
4483: IF l_tot_smc_records > 1 THEN
4484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4485: RETURN;
4486: ELSIF l_tot_smc_records = 1 THEN
4487: --SS/SMC batch, lock record and call allocation directly in parent thread
4488:

Line 4499: RAISE fnd_api.g_exc_unexpected_error;

4495: );
4496:
4497: print_debug('return status after init_allocation '|| l_retcode, l_debug);
4498: IF l_retcode <> 0 THEN
4499: RAISE fnd_api.g_exc_unexpected_error;
4500: END IF;
4501:
4502: END IF;
4503:

Line 4521: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4517: p_num_workers => l_num_workers,
4518: x_return_status => x_return_status);
4519:
4520: print_debug('return status after spawn_workers '||x_return_status, l_debug);
4521: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4522: RAISE fnd_api.g_exc_unexpected_error;
4523: END IF;
4524:
4525: -- COMMIT;

Line 4522: RAISE fnd_api.g_exc_unexpected_error;

4518: x_return_status => x_return_status);
4519:
4520: print_debug('return status after spawn_workers '||x_return_status, l_debug);
4521: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4522: RAISE fnd_api.g_exc_unexpected_error;
4523: END IF;
4524:
4525: -- COMMIT;
4526: EXCEPTION

Line 4529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4525: -- COMMIT;
4526: EXCEPTION
4527: WHEN OTHERS THEN
4528: print_debug ('Error in init_allocation '||SQLERRM, l_debug);
4529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4530:
4531: END init_allocation;
4532:
4533:

Line 4561: x_return_status := fnd_api.g_ret_sts_success;

4557:
4558:
4559: BEGIN
4560:
4561: x_return_status := fnd_api.g_ret_sts_success;
4562:
4563: l_request_id := FND_REQUEST.SUBMIT_REQUEST(application => 'WMS',
4564: program => 'WMSPALOC',
4565: description => 'WMS post-allocation processing',

Line 4616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4612: print_debug('l_phase '||l_phase||' l_status '||l_status||' l_dev_phase '||l_dev_phase||' l_dev_status '||l_dev_status,l_debug);
4613:
4614: IF l_dev_status = 'WARNING' THEN
4615: l_completion_status := 'WARNING';
4616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4617: ELSIF l_dev_status <> 'NORMAL' THEN
4618: l_completion_status := 'ERROR';
4619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4620: else

Line 4619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4615: l_completion_status := 'WARNING';
4616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4617: ELSIF l_dev_status <> 'NORMAL' THEN
4618: l_completion_status := 'ERROR';
4619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4620: else
4621: l_completion_status := 'NORMAL';
4622: l_dummy := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status, '');
4623: END IF;

Line 4628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4624:
4625: EXCEPTION
4626: WHEN OTHERS THEN
4627: print_debug('Error in post_allocation_processing', l_debug);
4628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4629: END post_allocation_processing;
4630:
4631:
4632: PROCEDURE fulfillment_labor_planning(p_planning_criteria_id in number,

Line 4669: x_return_status := fnd_api.g_ret_sts_success;

4665:
4666: BEGIN
4667:
4668: print_debug('In fulfillment_labor_planning ', l_debug);
4669: x_return_status := fnd_api.g_ret_sts_success;
4670:
4671: open c1;
4672:
4673: fetch c1 bulk collect

Line 4756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4752: EXCEPTION
4753: WHEN No_Data_Found THEN
4754: print_debug('No Data Found Exception in fulfillment_labor_planning',
4755: l_debug);
4756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4757:
4758: WHEN OTHERS THEN
4759: print_debug('Other Exception in fulfillment_labor_planning', l_debug);
4760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4757:
4758: WHEN OTHERS THEN
4759: print_debug('Other Exception in fulfillment_labor_planning', l_debug);
4760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4761:
4762: END fulfillment_labor_planning;
4763:
4764:

Line 4804: x_return_status := fnd_api.g_ret_sts_success;

4800: l_row_count NUMBER := 0;
4801:
4802:
4803: BEGIN
4804: x_return_status := fnd_api.g_ret_sts_success;
4805:
4806:
4807: BEGIN
4808: IF g_update_wdd = 'Y' THEN

Line 4917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4913:
4914: EXCEPTION
4915: WHEN OTHERS THEN
4916: print_debug('Error in clean_up', l_debug);
4917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4918:
4919: END clean_up;
4920:
4921:

Line 4946: l_return_status := FND_API.G_RET_STS_SUCCESS;

4942: cleanup_not_require_exception EXCEPTION;
4943:
4944: BEGIN
4945: print_debug('In Rule Based simulation ', l_debug);
4946: l_return_status := FND_API.G_RET_STS_SUCCESS;
4947:
4948: initialize(p_wave_id, p_organization_id, l_return_status);
4949: print_debug('return status after initialize ' ||
4950: l_return_status,

Line 4952: IF l_return_status <> fnd_api.g_ret_sts_success THEN

4948: initialize(p_wave_id, p_organization_id, l_return_status);
4949: print_debug('return status after initialize ' ||
4950: l_return_status,
4951: l_debug);
4952: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4953: RAISE cleanup_not_require_exception;
4954: END IF;
4955:
4956: print_debug('Rule Based simulation: calling create_move_order', l_debug);

Line 4961: IF l_return_status <> fnd_api.g_ret_sts_success THEN

4957: create_move_order(p_organization_id, p_wave_id, l_mo_header_id, l_request_number, l_return_status);
4958: print_debug('return status after create_move_order ' ||
4959: l_return_status,
4960: l_debug);
4961: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4962: RAISE cleanup_not_require_exception;
4963: END IF;
4964:
4965:

Line 4972: IF l_return_status <> fnd_api.g_ret_sts_success THEN

4968: x_return_status => l_return_status);
4969: print_debug('return status after process_reservations ' ||
4970: l_return_status,
4971: l_debug);
4972: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4973: RAISE fnd_api.g_exc_unexpected_error;
4974: END IF;
4975:
4976:

Line 4973: RAISE fnd_api.g_exc_unexpected_error;

4969: print_debug('return status after process_reservations ' ||
4970: l_return_status,
4971: l_debug);
4972: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4973: RAISE fnd_api.g_exc_unexpected_error;
4974: END IF;
4975:
4976:
4977: init_allocation(p_organization_id,

Line 4983: IF l_return_status <> fnd_api.g_ret_sts_success THEN

4979: l_mo_header_id,
4980: l_return_status);
4981:
4982: print_debug('return status after init_allocation '|| l_return_status, l_debug);
4983: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4984: RAISE fnd_api.g_exc_unexpected_error;
4985: END IF;
4986:
4987:

Line 4984: RAISE fnd_api.g_exc_unexpected_error;

4980: l_return_status);
4981:
4982: print_debug('return status after init_allocation '|| l_return_status, l_debug);
4983: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4984: RAISE fnd_api.g_exc_unexpected_error;
4985: END IF;
4986:
4987:
4988: print_debug('Rule Based simulation: calling post_allocation_processing',

Line 4999: IF l_return_status <> fnd_api.g_ret_sts_success THEN

4995: --post_allocation_processing(P_ORGANIZATION_ID, l_request_number);
4996: print_debug('Rule Based simulation: return status after post_allocation_processing ' ||
4997: l_return_status,
4998: l_debug);
4999: IF l_return_status <> fnd_api.g_ret_sts_success THEN
5000: RAISE fnd_api.g_exc_unexpected_error;
5001: END IF;
5002:
5003: BEGIN

Line 5000: RAISE fnd_api.g_exc_unexpected_error;

4996: print_debug('Rule Based simulation: return status after post_allocation_processing ' ||
4997: l_return_status,
4998: l_debug);
4999: IF l_return_status <> fnd_api.g_ret_sts_success THEN
5000: RAISE fnd_api.g_exc_unexpected_error;
5001: END IF;
5002:
5003: BEGIN
5004: print_debug('Update WDD', l_debug);

Line 5026: IF l_return_status <> fnd_api.g_ret_sts_success THEN

5022: l_return_status);
5023: print_debug('Rule Based simulation: return status after fulfillment_labor_planning ' ||
5024: l_return_status,
5025: l_debug);
5026: IF l_return_status <> fnd_api.g_ret_sts_success THEN
5027: RAISE fnd_api.g_exc_unexpected_error;
5028: END IF;
5029:
5030: print_debug('Rule Based simulation: calling clean up', l_debug);

Line 5027: RAISE fnd_api.g_exc_unexpected_error;

5023: print_debug('Rule Based simulation: return status after fulfillment_labor_planning ' ||
5024: l_return_status,
5025: l_debug);
5026: IF l_return_status <> fnd_api.g_ret_sts_success THEN
5027: RAISE fnd_api.g_exc_unexpected_error;
5028: END IF;
5029:
5030: print_debug('Rule Based simulation: calling clean up', l_debug);
5031: clean_up(p_organization_id, p_wave_id, l_mo_header_id, l_return_status);

Line 5035: IF l_return_status <> fnd_api.g_ret_sts_success THEN

5031: clean_up(p_organization_id, p_wave_id, l_mo_header_id, l_return_status);
5032: print_debug('Rule Based simulation: return status after clean_up ' ||
5033: l_return_status,
5034: l_debug);
5035: IF l_return_status <> fnd_api.g_ret_sts_success THEN
5036: RAISE fnd_api.g_exc_unexpected_error;
5037: END IF;
5038:
5039: print_debug('Rule Based simulation: exiting', l_debug);

Line 5036: RAISE fnd_api.g_exc_unexpected_error;

5032: print_debug('Rule Based simulation: return status after clean_up ' ||
5033: l_return_status,
5034: l_debug);
5035: IF l_return_status <> fnd_api.g_ret_sts_success THEN
5036: RAISE fnd_api.g_exc_unexpected_error;
5037: END IF;
5038:
5039: print_debug('Rule Based simulation: exiting', l_debug);
5040:

Line 5044: RAISE fnd_api.g_exc_unexpected_error;

5040:
5041: EXCEPTION
5042: WHEN cleanup_not_require_exception THEN
5043: print_debug('Error in rule_based_simulation, No need to call clean_up', l_debug);
5044: RAISE fnd_api.g_exc_unexpected_error;
5045:
5046: WHEN OTHERS THEN
5047: print_debug('Error in rule_based_simulation. Need to call clean_up', l_debug);
5048: clean_up(p_organization_id, p_wave_id, l_mo_header_id, l_return_status);

Line 5049: RAISE fnd_api.g_exc_unexpected_error;

5045:
5046: WHEN OTHERS THEN
5047: print_debug('Error in rule_based_simulation. Need to call clean_up', l_debug);
5048: clean_up(p_organization_id, p_wave_id, l_mo_header_id, l_return_status);
5049: RAISE fnd_api.g_exc_unexpected_error;
5050: END rule_based_simulation;
5051:
5052:
5053:

Line 5186: l_return_status VARCHAR2(3) := fnd_api.g_ret_sts_success;

5182: l_qs NUMBER;
5183: l_atr NUMBER;
5184: l_att NUMBER;
5185:
5186: l_return_status VARCHAR2(3) := fnd_api.g_ret_sts_success;
5187: j number := 0;
5188: k number := 0;
5189: v_backorder_flag varchar2(1);
5190: v_reject_line_flag varchar2(1);

Line 5533: p_init_msg_lst => fnd_api.g_false,

5529: RAISE no_data_found;
5530: END IF;
5531:
5532: inv_quantity_tree_pub.query_quantities(p_api_version_number => 1.0,
5533: p_init_msg_lst => fnd_api.g_false,
5534: x_return_status => l_return_status,
5535: x_msg_count => l_msg_count,
5536: x_msg_data => l_msg_data,
5537: p_organization_id => l_org_id,

Line 5719: p_init_msg_lst => fnd_api.g_false,

5715: RAISE no_data_found;
5716: END IF;
5717:
5718: inv_quantity_tree_pub.query_quantities(p_api_version_number => 1.0,
5719: p_init_msg_lst => fnd_api.g_false,
5720: x_return_status => l_return_status,
5721: x_msg_count => l_msg_count,
5722: x_msg_data => l_msg_data,
5723: p_organization_id => l_org_id,

Line 6020: l_return_status := fnd_api.g_ret_sts_success;

6016: .demand_source_header_id;
6017: l_rsv_temp_rec.DEMAND_SOURCE_LINE_ID := X_SUFFICIENT_QTY_LINES_TBL(j)
6018: .source_line_id;
6019:
6020: l_return_status := fnd_api.g_ret_sts_success;
6021: inv_reservation_pub.query_reservation(p_api_version_number => 1.0,
6022: x_return_status => l_return_status,
6023: x_msg_count => l_msg_count,
6024: x_msg_data => l_msg_data,

Line 6030: IF l_RETURN_status = fnd_api.g_ret_sts_success THEN

6026: x_mtl_reservation_tbl => l_rsv_tbl_tmp,
6027: x_mtl_reservation_tbl_count => l_mtl_reservation_count,
6028: x_error_code => l_error_code);
6029:
6030: IF l_RETURN_status = fnd_api.g_ret_sts_success THEN
6031:
6032: PRINT_DEBUG('Number of reservations found: ' ||
6033: l_mtl_reservation_count,
6034: l_debug);

Line 6143: p_init_msg_lst => fnd_api.g_false,

6139: print_debug('Call the create_reservation API to create the replenishemnt reservation',
6140: l_debug);
6141:
6142: INV_RESERVATION_PVT.create_reservation(p_api_version_number => 1.0,
6143: p_init_msg_lst => fnd_api.g_false,
6144: x_return_status => l_return_status,
6145: x_msg_count => l_msg_count,
6146: x_msg_data => l_msg_data,
6147: p_rsv_rec => l_rsv_rec,

Line 6150: p_partial_reservation_flag => fnd_api.g_false,

6146: x_msg_data => l_msg_data,
6147: p_rsv_rec => l_rsv_rec,
6148: p_serial_number => l_serial_number,
6149: x_serial_number => l_to_serial_number,
6150: p_partial_reservation_flag => fnd_api.g_false,
6151: p_force_reservation_flag => fnd_api.g_false,
6152: p_validation_flag => fnd_api.g_true,
6153: x_quantity_reserved => l_quantity_reserved,
6154: x_secondary_quantity_reserved => l_quantity_reserved2,

Line 6151: p_force_reservation_flag => fnd_api.g_false,

6147: p_rsv_rec => l_rsv_rec,
6148: p_serial_number => l_serial_number,
6149: x_serial_number => l_to_serial_number,
6150: p_partial_reservation_flag => fnd_api.g_false,
6151: p_force_reservation_flag => fnd_api.g_false,
6152: p_validation_flag => fnd_api.g_true,
6153: x_quantity_reserved => l_quantity_reserved,
6154: x_secondary_quantity_reserved => l_quantity_reserved2,
6155: x_reservation_id => l_rsv_id);

Line 6152: p_validation_flag => fnd_api.g_true,

6148: p_serial_number => l_serial_number,
6149: x_serial_number => l_to_serial_number,
6150: p_partial_reservation_flag => fnd_api.g_false,
6151: p_force_reservation_flag => fnd_api.g_false,
6152: p_validation_flag => fnd_api.g_true,
6153: x_quantity_reserved => l_quantity_reserved,
6154: x_secondary_quantity_reserved => l_quantity_reserved2,
6155: x_reservation_id => l_rsv_id);
6156:

Line 6159: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

6155: x_reservation_id => l_rsv_id);
6156:
6157: END IF;
6158:
6159: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6160:
6161: print_debug('Error returned from INV create_reservation API: ' ||
6162: l_return_status,
6163: l_debug);

Line 6166: RAISE FND_API.G_EXC_ERROR;

6162: l_return_status,
6163: l_debug);
6164:
6165: -- Raise an exception. The caller will do the rollback, cleanups,
6166: RAISE FND_API.G_EXC_ERROR;
6167:
6168: END IF;
6169:
6170: ELSE

Line 6178: l_return_status := fnd_api.g_ret_sts_error;

6174: END IF;
6175:
6176: EXCEPTION
6177: WHEN OTHERS THEN
6178: l_return_status := fnd_api.g_ret_sts_error;
6179: fnd_msg_pub.count_and_get(p_count => l_msg_count,
6180: p_data => l_msg_data);
6181:
6182: print_debug('Exiting Create_RSV - Execution error: ' ||

Line 6307: if l_return_status = 'S' and l_hold_result = FND_API.G_TRUE then

6303: x_msg_count => l_msg_count,
6304: x_msg_data => l_msg_data,
6305: x_return_status => l_return_status);
6306:
6307: if l_return_status = 'S' and l_hold_result = FND_API.G_TRUE then
6308: print_debug('Credit Check is on hold for Wave Line Id ' ||
6309: l_credit_check.wave_line_id || ' in Wave header id ' ||
6310: p_wave_header_id,
6311: l_debug);

Line 6318: IF l_return_status <> fnd_api.g_ret_sts_success THEN

6314: l_hold_index := l_hold_index + 1;
6315:
6316: end if;
6317:
6318: IF l_return_status <> fnd_api.g_ret_sts_success THEN
6319: RAISE fnd_api.g_exc_unexpected_error;
6320: END IF;
6321:
6322: end loop;

Line 6319: RAISE fnd_api.g_exc_unexpected_error;

6315:
6316: end if;
6317:
6318: IF l_return_status <> fnd_api.g_ret_sts_success THEN
6319: RAISE fnd_api.g_exc_unexpected_error;
6320: END IF;
6321:
6322: end loop;
6323:

Line 6375: IF l_return_status <> fnd_api.g_ret_sts_success THEN

6371: print_debug('After call to Backorder API Return Status :' ||
6372: l_return_status,
6373: l_debug);
6374:
6375: IF l_return_status <> fnd_api.g_ret_sts_success THEN
6376: RAISE fnd_api.g_exc_unexpected_error;
6377:
6378: END IF;
6379:

Line 6376: RAISE fnd_api.g_exc_unexpected_error;

6372: l_return_status,
6373: l_debug);
6374:
6375: IF l_return_status <> fnd_api.g_ret_sts_success THEN
6376: RAISE fnd_api.g_exc_unexpected_error;
6377:
6378: END IF;
6379:
6380: --Delete all entries in the pl/sql table

Line 6397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6393: --Delete all entries in the pl/sql table
6394: G_backorder_deliv_tab.DELETE;
6395: G_backorder_qty_tab.DELETE;
6396: G_dummy_table.DELETE;
6397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6398: END;
6399:
6400: end if;
6401:

Line 6525: p_init_msg_list => FND_API.G_FALSE,

6521:
6522: WSH_DELIVERY_DETAILS_PUB.Autocreate_Deliveries(
6523: -- Standard parameters
6524: p_api_version_number => 1.0,
6525: p_init_msg_list => FND_API.G_FALSE,
6526: p_commit => FND_API.G_FALSE,
6527: x_return_status => l_return_status,
6528: x_msg_count => l_msg_count,
6529: x_msg_data => l_msg_data,

Line 6526: p_commit => FND_API.G_FALSE,

6522: WSH_DELIVERY_DETAILS_PUB.Autocreate_Deliveries(
6523: -- Standard parameters
6524: p_api_version_number => 1.0,
6525: p_init_msg_list => FND_API.G_FALSE,
6526: p_commit => FND_API.G_FALSE,
6527: x_return_status => l_return_status,
6528: x_msg_count => l_msg_count,
6529: x_msg_data => l_msg_data,
6530: p_line_rows => l_TabOfDelDets,

Line 6533: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

6529: x_msg_data => l_msg_data,
6530: p_line_rows => l_TabOfDelDets,
6531: x_del_rows => l_del_rows);
6532:
6533: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6534:
6535: print_debug('Error returned from Auto Create Deliveries API: ' ||
6536: l_return_status,
6537: l_debug);

Line 6540: RAISE FND_API.G_EXC_ERROR;

6536: l_return_status,
6537: l_debug);
6538:
6539: -- Raise an exception. The caller will do the rollback, cleanups,
6540: RAISE FND_API.G_EXC_ERROR;
6541: END IF;
6542: exception
6543: when others then
6544:

Line 6670: x_return_status := FND_API.G_RET_STS_ERROR;

6666: print_debug('Error in Plan Wave API: ' || SQLCODE || ' : ' || SQLERRM,
6667: l_debug);
6668: delete from wms_wp_rules_simulation where wave_header_id=p_wave_header_id;
6669: commit;
6670: x_return_status := FND_API.G_RET_STS_ERROR;
6671:
6672: end Plan_Wave;
6673:
6674:

Line 7619: l_return_status VARCHAR2(3) := fnd_api.g_ret_sts_success;

7615: L_DEMAND_QTY NUMBER;
7616:
7617: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7618:
7619: l_return_status VARCHAR2(3) := fnd_api.g_ret_sts_success;
7620:
7621: v_total_labor_time number := 0;
7622:
7623: travel_time_idx number;

Line 8589: l_return_status VARCHAR2(3) := fnd_api.g_ret_sts_success;

8585: l_qs NUMBER;
8586: l_atr NUMBER;
8587: l_att NUMBER;
8588: l_msg_count number;
8589: l_return_status VARCHAR2(3) := fnd_api.g_ret_sts_success;
8590: l_msg_data varchar2(100);
8591: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'),
8592: 0);
8593: begin

Line 8622: p_init_msg_lst => fnd_api.g_false,

8618: END IF;
8619: print_debug('In Get ATT for subinventory API', l_debug);
8620:
8621: inv_quantity_tree_pub.query_quantities(p_api_version_number => 1.0,
8622: p_init_msg_lst => fnd_api.g_false,
8623: x_return_status => l_return_status,
8624: x_msg_count => l_msg_count,
8625: x_msg_data => l_msg_data,
8626: p_organization_id => p_org_id,

Line 8651: IF l_return_status <> fnd_api.g_ret_sts_success THEN

8647:
8648: print_debug('ATR for Item ' || p_item_id || 'in subinventory ' ||
8649: p_sub || ' is :' || l_atr,
8650: l_debug);
8651: IF l_return_status <> fnd_api.g_ret_sts_success THEN
8652: l_atr := 0;
8653: END IF;
8654:
8655: RETURN l_atr;

Line 9714: l_commit VARCHAR2(1) := FND_API.G_TRUE;

9710: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
9711: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
9712: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
9713: l_x_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
9714: l_commit VARCHAR2(1) := FND_API.G_TRUE;
9715:
9716: TYPE group_match_seq_rec_type IS RECORD(
9717: delivery_detail_id NUMBER,
9718: match_group_id NUMBER,

Line 9779: -- x_return_status := fnd_api.g_ret_sts_success;

9775: CLOSE c_saved_queries;
9776: print_DEBUG('No data found for query name = ' || p_query_name,
9777: l_debug);
9778: --x_rowcount := 0;
9779: -- x_return_status := fnd_api.g_ret_sts_success;
9780: -- x_return_message:= 'No data found for query name = ' || p_query_name ;
9781:
9782: RETURN;
9783: END IF;

Line 9809: IF l_return_status = fnd_api.g_ret_sts_error OR

9805: print_DEBUG('SET_QUERY_TASKS_PARAMETERS return message = ' ||
9806: l_return_message,
9807: l_debug);
9808:
9809: IF l_return_status = fnd_api.g_ret_sts_error OR
9810: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
9811: print_DEBUG(' Error in SET_QUERY_TASKS_PARAMETERS ', l_debug);
9812: return;
9813: END IF;

Line 9810: l_return_status = fnd_api.g_ret_sts_unexp_error THEN

9806: l_return_message,
9807: l_debug);
9808:
9809: IF l_return_status = fnd_api.g_ret_sts_error OR
9810: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
9811: print_DEBUG(' Error in SET_QUERY_TASKS_PARAMETERS ', l_debug);
9812: return;
9813: END IF;
9814:

Line 10005: IF l_return_status = fnd_api.g_ret_sts_error THEN

10001: print_DEBUG('WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS x_record_count => ' ||
10002: l_record_count,
10003: l_debug);
10004:
10005: IF l_return_status = fnd_api.g_ret_sts_error THEN
10006: print_DEBUG(' Error in WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS ', l_debug);
10007: --return;
10008: RAISE fnd_api.g_exc_error;
10009: END IF;

Line 10008: RAISE fnd_api.g_exc_error;

10004:
10005: IF l_return_status = fnd_api.g_ret_sts_error THEN
10006: print_DEBUG(' Error in WMS_WAVEPLAN_TASKS_PVT.QUERY_TASKS ', l_debug);
10007: --return;
10008: RAISE fnd_api.g_exc_error;
10009: END IF;
10010:
10011: open c_mmtt;
10012:

Line 10046: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

10042: x_return_status => l_return_status,
10043: x_msg_count => l_msg_count,
10044: x_msg_data => l_msg_data);
10045:
10046: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
10047: print_debug('Error returned from task_release_cust in Task_Release_CP ',
10048: l_debug);
10049: RAISE FND_API.G_EXC_ERROR;
10050: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 10049: RAISE FND_API.G_EXC_ERROR;

10045:
10046: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
10047: print_debug('Error returned from task_release_cust in Task_Release_CP ',
10048: l_debug);
10049: RAISE FND_API.G_EXC_ERROR;
10050: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
10051: print_debug('Unexpected errror from task_release_cust in Task_Release_CP ',
10052: l_debug);
10053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 10050: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

10046: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
10047: print_debug('Error returned from task_release_cust in Task_Release_CP ',
10048: l_debug);
10049: RAISE FND_API.G_EXC_ERROR;
10050: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
10051: print_debug('Unexpected errror from task_release_cust in Task_Release_CP ',
10052: l_debug);
10053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10054: END IF;

Line 10053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10049: RAISE FND_API.G_EXC_ERROR;
10050: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
10051: print_debug('Unexpected errror from task_release_cust in Task_Release_CP ',
10052: l_debug);
10053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10054: END IF;
10055:
10056: x_return_status := l_return_status;
10057:

Line 10130: RAISE fnd_api.g_exc_error;

10126: print_debug('Error in Task Planning Minimum Fill Capacity: ' ||
10127: SQLCODE || ' : ' || SQLERRM,
10128: l_debug);
10129:
10130: RAISE fnd_api.g_exc_error;
10131: end;
10132:
10133: end if;
10134:

Line 10260: RAISE fnd_api.g_exc_error;

10256: WHEN OTHERS THEN
10257: print_debug('Error in Task Release Reverse Trip Stop: ' ||
10258: SQLCODE || ' : ' || SQLERRM,
10259: l_debug);
10260: RAISE fnd_api.g_exc_error;
10261: end;
10262:
10263: end if;
10264:

Line 10446: RAISE fnd_api.g_exc_error;

10442: WHEN OTHERS THEN
10443: print_debug('Error in Task Release Consolidation Locator : ' ||
10444: SQLCODE || ' : ' || SQLERRM,
10445: l_debug);
10446: RAISE fnd_api.g_exc_error;
10447: end;
10448:
10449: end if;
10450:

Line 10766: RAISE fnd_api.g_exc_error;

10762: WHEN OTHERS THEN
10763: print_debug('Error in Task Planning Replenishment Complete part: ' ||
10764: SQLCODE || ' : ' || SQLERRM,
10765: l_debug);
10766: RAISE fnd_api.g_exc_error;
10767:
10768: end;
10769:
10770: end if;

Line 10792: l_trohdr_rec.db_flag := FND_API.G_TRUE;

10788: l_trohdr_rec.status_date := sysdate;
10789: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE;
10790: l_trohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_STGXFR;
10791: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
10792: l_trohdr_rec.db_flag := FND_API.G_TRUE;
10793:
10794: print_debug('CALLING INV_Move_Order_PUB.Create_Move_Order_Header',
10795: l_debug);
10796:

Line 10798: p_init_msg_list => FND_API.G_FALSE,

10794: print_debug('CALLING INV_Move_Order_PUB.Create_Move_Order_Header',
10795: l_debug);
10796:
10797: INV_Move_Order_PUB.Create_Move_Order_Header(p_api_version_number => 1.0,
10798: p_init_msg_list => FND_API.G_FALSE,
10799: p_return_values => FND_API.G_TRUE,
10800: p_commit => l_commit,
10801: x_return_status => x_return_status,
10802: x_msg_count => l_msg_count,

Line 10799: p_return_values => FND_API.G_TRUE,

10795: l_debug);
10796:
10797: INV_Move_Order_PUB.Create_Move_Order_Header(p_api_version_number => 1.0,
10798: p_init_msg_list => FND_API.G_FALSE,
10799: p_return_values => FND_API.G_TRUE,
10800: p_commit => l_commit,
10801: x_return_status => x_return_status,
10802: x_msg_count => l_msg_count,
10803: x_msg_data => l_msg_data,

Line 10810: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

10806: x_trohdr_rec => l_x_trohdr_rec,
10807: x_trohdr_val_rec => l_x_trohdr_val_rec,
10808: p_validation_flag => inv_move_order_pub.g_validation_yes);
10809:
10810: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
10811:
10812: print_debug('Creating MO Header failed with unexpected error returning message: ' ||
10813: l_msg_data,
10814: l_debug);

Line 10816: RAISE fnd_api.g_exc_unexpected_error;

10812: print_debug('Creating MO Header failed with unexpected error returning message: ' ||
10813: l_msg_data,
10814: l_debug);
10815:
10816: RAISE fnd_api.g_exc_unexpected_error;
10817: -- If cant create a common MOH, do no repl stuff
10818: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10819:
10820: print_debug('Creating MO Header failed with expected error returning message: ' ||

Line 10818: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

10814: l_debug);
10815:
10816: RAISE fnd_api.g_exc_unexpected_error;
10817: -- If cant create a common MOH, do no repl stuff
10818: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10819:
10820: print_debug('Creating MO Header failed with expected error returning message: ' ||
10821: l_msg_data,
10822: l_debug);

Line 10823: -- RAISE fnd_api.g_exc_error;

10819:
10820: print_debug('Creating MO Header failed with expected error returning message: ' ||
10821: l_msg_data,
10822: l_debug);
10823: -- RAISE fnd_api.g_exc_error;
10824: -- If cant create a common MOH, do not cartonize
10825: ELSE
10826:
10827: print_debug('Creating MO Header returned success with MO Header Id: ' ||

Line 10949: RAISE fnd_api.g_exc_unexpected_error;

10945: print_debug('Error in Task Release CP: ' || SQLCODE || ' : ' ||
10946: SQLERRM,
10947: l_debug);
10948:
10949: RAISE fnd_api.g_exc_unexpected_error;
10950: end Task_Release_CP;
10951:
10952: PROCEDURE SET_QUERY_TASKS_PARAMETERS(p_field_name_table IN wms_wave_planning_pvt.field_name_table_type,
10953: p_field_value_table IN wms_wave_planning_pvt.field_value_table_type,

Line 11258: x_return_status := FND_API.G_RET_STS_SUCCESS;

11254: ELSE
11255: l_temp_query := FALSE;
11256: END IF;
11257:
11258: x_return_status := FND_API.G_RET_STS_SUCCESS;
11259:
11260: --DEBUG( 'Exiting SET_QUERY_TASKS_PARAMETERS');
11261:
11262: EXCEPTION

Line 11264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11260: --DEBUG( 'Exiting SET_QUERY_TASKS_PARAMETERS');
11261:
11262: EXCEPTION
11263: WHEN OTHERS THEN
11264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11265: x_return_message := 'Unexpected error has occured in WMS_TASK_ACTION_PVT.SET_QUERY_TASKS_PARAMETERS. ' ||
11266: 'Oracle error message is ' || SQLERRM;
11267: --DEBUG( 'Unexpected error has occured. Oracle error message is '
11268: -- || SQLERRM, 'WMS_TASK_ACTION_PVT.SET_QUERY_TASKS_PARAMETERS - other error');

Line 11392: x_return_status := FND_API.G_RET_STS_SUCCESS;

11388: ELSE
11389: l_temp_action := FALSE;
11390: END IF;
11391:
11392: x_return_status := FND_API.G_RET_STS_SUCCESS;
11393:
11394: print_DEBUG('Exiting SET_ACTION_TASKS_PARAMETERS', l_debug);
11395:
11396: EXCEPTION

Line 11398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11394: print_DEBUG('Exiting SET_ACTION_TASKS_PARAMETERS', l_debug);
11395:
11396: EXCEPTION
11397: WHEN OTHERS THEN
11398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11399: x_return_message := 'Unexpected error has occured in WMS_TASK_ACTION_PVT.SET_ACTION_TASKS_PARAMETERS. ' ||
11400: 'Oracle error message is ' || SQLERRM;
11401: print_DEBUG('Unexpected error has occured. Oracle error message is ' ||
11402: SQLERRM ||

Line 11991: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;

11987: IF pick_seq_rule%NOTFOUND THEN
11988: print_debug('Pick sequence rule ID ' || to_char(g_pick_seq_rule_id) ||
11989: ' does not exist.',
11990: l_debug);
11991: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;
11992: RETURN;
11993: END IF;
11994: IF pick_seq_rule%ISOPEN THEN
11995: CLOSE pick_seq_rule;

Line 12077: x_api_status := fnd_api.g_ret_sts_success;

12073: IF order_ps_group%ISOPEN THEN
12074: CLOSE order_ps_group;
12075: END IF;
12076: */
12077: x_api_status := fnd_api.g_ret_sts_success;
12078:
12079: EXCEPTION
12080: -- handle other errors
12081: WHEN OTHERS THEN

Line 12089: x_api_status := FND_API.G_RET_STS_ERROR;

12085: IF order_ps_group%ISOPEN THEN
12086: CLOSE order_ps_group;
12087: END IF;
12088: print_debug('Unexpected error in Init_Rules', l_debug);
12089: x_api_status := FND_API.G_RET_STS_ERROR;
12090: END Init_Rules;
12091:
12092: procedure launch_online(x_return_status OUT nocopy VARCHAR2,
12093: p_wave_header_id IN NUMBER,

Line 12138: RAISE fnd_api.g_exc_unexpected_error;

12134: else
12135:
12136: if p_Add_lines = 'Y' then
12137: rollback to create_wave_lines_online_sp;
12138: RAISE fnd_api.g_exc_unexpected_error;
12139: else
12140: raise wave_line_exception;
12141: end if;
12142: end if;

Line 12222: RAISE fnd_api.g_exc_unexpected_error;

12218:
12219:
12220: else
12221: rollback to release_wave_lines_sp;
12222: RAISE fnd_api.g_exc_unexpected_error;
12223: end if;
12224: end if;
12225:
12226: end if;

Line 12236: RAISE fnd_api.g_exc_unexpected_error;

12232:
12233: rollback to create_wave_lines_online_sp;
12234:
12235: delete_wave_header(p_wave_header_id);
12236: RAISE fnd_api.g_exc_unexpected_error;
12237:
12238: WHEN OTHERS THEN
12239: print_debug('Error in Launch Online : ' || SQLCODE || ' : ' ||
12240: SQLERRM,

Line 12336: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

12332: l_return_status);
12333:
12334: print_debug('init cursor status ' || l_return_status, l_debug);
12335:
12336: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
12337: print_debug('Error occurred in Init_Cursor', l_debug);
12338: x_return_status := 'E';
12339: -- RETURN;
12340: elsif l_return_status = FND_API.G_RET_STS_SUCCESS then

Line 12340: elsif l_return_status = FND_API.G_RET_STS_SUCCESS then

12336: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
12337: print_debug('Error occurred in Init_Cursor', l_debug);
12338: x_return_status := 'E';
12339: -- RETURN;
12340: elsif l_return_status = FND_API.G_RET_STS_SUCCESS then
12341: print_Debug('before get Lines ' || l_return_status, l_Debug);
12342:
12343: --12371394 put the get_lines call and the insert to wwl inside a loop
12344: l_done_flag := FND_API.G_FALSE;

Line 12344: l_done_flag := FND_API.G_FALSE;

12340: elsif l_return_status = FND_API.G_RET_STS_SUCCESS then
12341: print_Debug('before get Lines ' || l_return_status, l_Debug);
12342:
12343: --12371394 put the get_lines call and the insert to wwl inside a loop
12344: l_done_flag := FND_API.G_FALSE;
12345: LOOP
12346: EXIT WHEN l_done_flag = FND_API.G_TRUE;
12347: WMS_WAVE_PLANNING_PVT.Get_Lines(l_done_flag, l_return_status);
12348:

Line 12346: EXIT WHEN l_done_flag = FND_API.G_TRUE;

12342:
12343: --12371394 put the get_lines call and the insert to wwl inside a loop
12344: l_done_flag := FND_API.G_FALSE;
12345: LOOP
12346: EXIT WHEN l_done_flag = FND_API.G_TRUE;
12347: WMS_WAVE_PLANNING_PVT.Get_Lines(l_done_flag, l_return_status);
12348:
12349: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12350: print_debug('Error occurred in Get Lines', l_debug);

Line 12349: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

12345: LOOP
12346: EXIT WHEN l_done_flag = FND_API.G_TRUE;
12347: WMS_WAVE_PLANNING_PVT.Get_Lines(l_done_flag, l_return_status);
12348:
12349: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12350: print_debug('Error occurred in Get Lines', l_debug);
12351: -- RETURN;
12352: l_done_flag := FND_API.G_TRUE; --12371394
12353: x_return_status := 'E';

Line 12352: l_done_flag := FND_API.G_TRUE; --12371394

12348:
12349: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12350: print_debug('Error occurred in Get Lines', l_debug);
12351: -- RETURN;
12352: l_done_flag := FND_API.G_TRUE; --12371394
12353: x_return_status := 'E';
12354: else
12355: FORALL i IN 1 .. release_table.Count
12356: insert into wms_wp_wave_lines

Line 12912: l_return_status = fnd_api.g_ret_sts_success THEN

12908: x_msg_count => l_msg_count,
12909: x_msg_data => l_msg_data);
12910:
12911: IF l_api_is_implemented AND
12912: l_return_status = fnd_api.g_ret_sts_success THEN
12913: print_debug('Custom API Implemented for create wave lines ',
12914: l_debug);
12915: l_tbl_count := l_custom_line_tbl.count;
12916:

Line 13557: x_api_status := fnd_api.g_ret_sts_success;

13553: v_ignore := DBMS_SQL.Execute(v_CursorID);
13554: IF DBMS_SQL.Is_Open(v_cursorID) THEN
13555: print_debug('The DBMS SQL is_open after the execute with rows for v_cursorID ' , l_debug);
13556: END IF;
13557: x_api_status := fnd_api.g_ret_sts_success;
13558: EXCEPTION
13559: WHEN OTHERS THEN
13560: print_debug('Error : ' || SQLCODE || ' : ' || SQLERRM, l_debug);
13561: x_api_status := FND_API.G_RET_STS_ERROR;

Line 13561: x_api_status := FND_API.G_RET_STS_ERROR;

13557: x_api_status := fnd_api.g_ret_sts_success;
13558: EXCEPTION
13559: WHEN OTHERS THEN
13560: print_debug('Error : ' || SQLCODE || ' : ' || SQLERRM, l_debug);
13561: x_api_status := FND_API.G_RET_STS_ERROR;
13562: END Init_Cursor;
13563:
13564: --
13565: -- Name

Line 13579: -- x_api_status - FND_API.G_RET_STS_SUCCESS or

13575: -- more lines to be retrieved.
13576: --
13577: -- Output Parameters
13578: -- x_done_flag - whether all lines have been fetched
13579: -- x_api_status - FND_API.G_RET_STS_SUCCESS or
13580: -- FND_API.G_RET_STS_ERROR or
13581: -- FND_API.G_RET_STS_ERROR
13582: --
13583: PROCEDURE Get_Lines(x_done_flag OUT NOCOPY VARCHAR2,

Line 13580: -- FND_API.G_RET_STS_ERROR or

13576: --
13577: -- Output Parameters
13578: -- x_done_flag - whether all lines have been fetched
13579: -- x_api_status - FND_API.G_RET_STS_SUCCESS or
13580: -- FND_API.G_RET_STS_ERROR or
13581: -- FND_API.G_RET_STS_ERROR
13582: --
13583: PROCEDURE Get_Lines(x_done_flag OUT NOCOPY VARCHAR2,
13584: x_api_status OUT NOCOPY VARCHAR2) IS

Line 13581: -- FND_API.G_RET_STS_ERROR

13577: -- Output Parameters
13578: -- x_done_flag - whether all lines have been fetched
13579: -- x_api_status - FND_API.G_RET_STS_SUCCESS or
13580: -- FND_API.G_RET_STS_ERROR or
13581: -- FND_API.G_RET_STS_ERROR
13582: --
13583: PROCEDURE Get_Lines(x_done_flag OUT NOCOPY VARCHAR2,
13584: x_api_status OUT NOCOPY VARCHAR2) IS
13585: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 13592: x_api_status := FND_API.G_RET_STS_ERROR;

13588: -- handle uninitialized package errors here
13589: /*
13590: IF g_initialized = FALSE THEN
13591: print_debug('The package must be initialized before use',l_debug);
13592: x_api_status := FND_API.G_RET_STS_ERROR;
13593: RETURN;
13594: END IF;
13595: */
13596: g_rel_current_line := 1;

Line 13623: x_done_flag := FND_API.G_FALSE;

13619:
13620: END IF;
13621: -- Set flag to indicate that fetching is not completed for
13622: -- an organization
13623: x_done_flag := FND_API.G_FALSE;
13624: -- If called after the first time, place the last row fetched in previous
13625: -- call as the first row, since it was not returned in the previous call
13626: print_debug('Fetching Customer specified lines', l_debug);
13627: MAX_LINES := 1000;

Line 13637: x_done_flag := FND_API.G_TRUE;

13633: LOOP
13634: IF g_rel_current_line < MAX_LINES THEN
13635: IF DBMS_SQL.Fetch_Rows(v_cursorID) = 0 THEN
13636: print_debug('Fetched all lines for organization', l_debug);
13637: x_done_flag := FND_API.G_TRUE;
13638: DBMS_SQL.Close_Cursor(v_cursorID);
13639: -- Reinitialize the first line marker since we have
13640: -- fetched all rows
13641: first_line.source_header_id := -1;

Line 13652: IF (g_return_status = FND_API.G_RET_STS_ERROR) OR

13648: l_debug);
13649: -- Save fetched record into release table
13650: Insert_RL_Row(g_return_status);
13651:
13652: IF (g_return_status = FND_API.G_RET_STS_ERROR) OR
13653: (g_return_status = FND_API.G_RET_STS_ERROR) THEN
13654: print_debug('Error occurred in Insert_RL_Row', l_debug);
13655: x_api_status := g_return_status;
13656: RETURN;

Line 13653: (g_return_status = FND_API.G_RET_STS_ERROR) THEN

13649: -- Save fetched record into release table
13650: Insert_RL_Row(g_return_status);
13651:
13652: IF (g_return_status = FND_API.G_RET_STS_ERROR) OR
13653: (g_return_status = FND_API.G_RET_STS_ERROR) THEN
13654: print_debug('Error occurred in Insert_RL_Row', l_debug);
13655: x_api_status := g_return_status;
13656: RETURN;
13657: END IF;

Line 13669: x_done_flag := FND_API.G_FALSE;

13665: l_debug);
13666: g_rel_current_line := g_rel_current_line + 1;
13667: END IF;
13668: ELSE
13669: x_done_flag := FND_API.G_FALSE;
13670: EXIT;
13671: END IF;
13672: END LOOP;
13673: x_api_status := fnd_api.g_ret_sts_success;

Line 13673: x_api_status := fnd_api.g_ret_sts_success;

13669: x_done_flag := FND_API.G_FALSE;
13670: EXIT;
13671: END IF;
13672: END LOOP;
13673: x_api_status := fnd_api.g_ret_sts_success;
13674: EXCEPTION
13675: WHEN OTHERS THEN
13676:
13677: print_debug('Unexpected error occurred in Get_Lines', l_debug);

Line 13686: x_done_flag := FND_API.G_RET_STS_ERROR;

13682: END IF;
13683: IF DBMS_SQL.Is_Open(v_cursorID) THEN
13684: DBMS_SQL.Close_Cursor(v_cursorID);
13685: END IF;
13686: x_done_flag := FND_API.G_RET_STS_ERROR;
13687: x_api_status := FND_API.G_RET_STS_ERROR;
13688: END Get_Lines;
13689:
13690: PROCEDURE Insert_RL_Row(x_api_status OUT NOCOPY VARCHAR2) IS

Line 13687: x_api_status := FND_API.G_RET_STS_ERROR;

13683: IF DBMS_SQL.Is_Open(v_cursorID) THEN
13684: DBMS_SQL.Close_Cursor(v_cursorID);
13685: END IF;
13686: x_done_flag := FND_API.G_RET_STS_ERROR;
13687: x_api_status := FND_API.G_RET_STS_ERROR;
13688: END Get_Lines;
13689:
13690: PROCEDURE Insert_RL_Row(x_api_status OUT NOCOPY VARCHAR2) IS
13691: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 13793: x_api_status := fnd_api.g_ret_sts_success;

13789: l_net_weight_tb(g_rel_current_line) := v_net_weight;
13790: l_volume_tb(g_rel_current_line) := v_volume;
13791: -- l_net_value(g_rel_current_line);
13792:
13793: x_api_status := fnd_api.g_ret_sts_success;
13794: EXCEPTION
13795: WHEN OTHERS THEN
13796: print_debug('Unexpected error in Insert_RL_Row', l_debug);
13797: print_debug('Error : ' || SQLCODE || ' : ' || SQLERRM, l_debug);

Line 13798: x_api_status := FND_API.G_RET_STS_ERROR;

13794: EXCEPTION
13795: WHEN OTHERS THEN
13796: print_debug('Unexpected error in Insert_RL_Row', l_debug);
13797: print_debug('Error : ' || SQLCODE || ' : ' || SQLERRM, l_debug);
13798: x_api_status := FND_API.G_RET_STS_ERROR;
13799: END Insert_RL_Row;
13800:
13801: --Procedure to Calculate the Planned Fill Rate
13802: procedure get_line_fill_rate(x_return_status OUT NOCOPY varchar2,

Line 13910: p_init_msg_lst => fnd_api.g_false,

13906: RAISE no_data_found;
13907: END IF;
13908:
13909: inv_quantity_tree_pub.query_quantities(p_api_version_number => 1.0,
13910: p_init_msg_lst => fnd_api.g_false,
13911: x_return_status => x_return_status,
13912: x_msg_count => l_msg_count,
13913: x_msg_data => l_msg_data,
13914: p_organization_id => l_org_id,

Line 14043: x_return_status := fnd_api.g_ret_sts_success;

14039: m := m + 1;
14040: END LOOP;
14041:
14042: end loop;
14043: x_return_status := fnd_api.g_ret_sts_success;
14044: -- commit;
14045: exception
14046:
14047: when others then

Line 14051: x_return_status := FND_API.G_RET_STS_ERROR;

14047: when others then
14048: print_debug('Error in Planned Fill Rate: ' || SQLCODE || ' : ' ||
14049: SQLERRM,
14050: l_debug);
14051: x_return_status := FND_API.G_RET_STS_ERROR;
14052:
14053: end get_line_fill_rate;
14054:
14055: --bug11775489 restructure to call update_line_actual_fill_rate for each line

Line 14068: x_return_status := fnd_api.g_ret_sts_success;

14064: and nvl(remove_from_wave_flag, 'N') <> 'Y'; --11775489 added filter
14065: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
14066:
14067: begin
14068: x_return_status := fnd_api.g_ret_sts_success;
14069: for l_line in c_lines loop
14070: update_line_actual_fill_rate(l_line.wave_line_id);
14071: end loop;
14072: x_return_status := fnd_api.g_ret_sts_success;

Line 14072: x_return_status := fnd_api.g_ret_sts_success;

14068: x_return_status := fnd_api.g_ret_sts_success;
14069: for l_line in c_lines loop
14070: update_line_actual_fill_rate(l_line.wave_line_id);
14071: end loop;
14072: x_return_status := fnd_api.g_ret_sts_success;
14073: -- commit;
14074: exception
14075: when others then
14076: print_debug('Error in Actual Fill Rate: ' || SQLCODE || ' : ' ||

Line 14079: x_return_status := FND_API.G_RET_STS_ERROR;

14075: when others then
14076: print_debug('Error in Actual Fill Rate: ' || SQLCODE || ' : ' ||
14077: SQLERRM,
14078: l_debug);
14079: x_return_status := FND_API.G_RET_STS_ERROR;
14080:
14081: end get_actual_fill_rate;
14082:
14083: function get_order_weight(p_source_header_id in number,

Line 14300: x_return_status := FND_API.G_RET_STS_ERROR;

14296: when OTHERS then
14297: print_debug('Error in Update Wave Header Status: ' || SQLCODE ||
14298: ' : ' || SQLERRM,
14299: l_debug);
14300: x_return_status := FND_API.G_RET_STS_ERROR;
14301: end update_wave_header_status;
14302:
14303: PROCEDURE update_task(p_transaction_temp_id IN WMS_WAVE_PLANNING_PVT.transaction_temp_table_type,
14304: p_task_type_id IN WMS_WAVE_PLANNING_PVT.task_type_id_table_type,

Line 15312: RAISE fnd_api.g_exc_error;

15308:
15309: wms_wave_planning_pvt.Check_wave_closed_status(x_return_status);
15310: else
15311:
15312: RAISE fnd_api.g_exc_error;
15313:
15314: end if;
15315:
15316: if x_return_Status <> 'S' then

Line 15318: RAISE fnd_api.g_exc_error;

15314: end if;
15315:
15316: if x_return_Status <> 'S' then
15317:
15318: RAISE fnd_api.g_exc_error;
15319:
15320: end if;
15321:
15322: commit;

Line 15334: RAISE fnd_api.g_exc_unexpected_error;

15330: l_debug);
15331:
15332: rollback to check_completed_status_sp;
15333:
15334: RAISE fnd_api.g_exc_unexpected_error;
15335: end Update_Completion_Status_CP;
15336:
15337: procedure Check_wave_closed_status(x_return_status OUT NOCOPY varchar2)
15338:

Line 15428: x_return_status := FND_API.G_RET_STS_ERROR;

15424: x_return_status := 'S';
15425: EXCEPTION
15426: WHEN OTHERS THEN
15427: print_debug('Error : ' || SQLCODE || ' : ' || SQLERRM, l_debug);
15428: x_return_status := FND_API.G_RET_STS_ERROR;
15429:
15430: end get_pick_fill_rate;
15431:
15432: function get_loaded_status(p_Delivery_Detail_id in number) return number

Line 15695: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

15691: x_return_status => l_return_status,
15692: x_msg_count => l_msg_count,
15693: x_msg_data => l_msg_data);
15694:
15695: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
15696: print_debug('Error returned from Get_wave_exceptions_cust in api catch_wave_exceptions_cp ',
15697: l_debug);
15698: RAISE FND_API.G_EXC_ERROR;
15699: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 15698: RAISE FND_API.G_EXC_ERROR;

15694:
15695: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
15696: print_debug('Error returned from Get_wave_exceptions_cust in api catch_wave_exceptions_cp ',
15697: l_debug);
15698: RAISE FND_API.G_EXC_ERROR;
15699: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
15700: print_debug('Unexpected errror from Get_wave_exceptions_cust api in catch_wave_exceptions_cp ',
15701: l_debug);
15702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 15699: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

15695: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
15696: print_debug('Error returned from Get_wave_exceptions_cust in api catch_wave_exceptions_cp ',
15697: l_debug);
15698: RAISE FND_API.G_EXC_ERROR;
15699: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
15700: print_debug('Unexpected errror from Get_wave_exceptions_cust api in catch_wave_exceptions_cp ',
15701: l_debug);
15702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
15703: END IF;

Line 15702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

15698: RAISE FND_API.G_EXC_ERROR;
15699: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
15700: print_debug('Unexpected errror from Get_wave_exceptions_cust api in catch_wave_exceptions_cp ',
15701: l_debug);
15702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
15703: END IF;
15704:
15705: IF l_api_is_implemented THEN
15706: print_debug('Custom API Implemented for create exceptions ', l_debug);

Line 16187: RAISE fnd_api.g_exc_unexpected_error;

16183: WHEN others THEN
16184: print_debug('Unknown exception in Exceptions CP ' || SQLCODE || ':' ||
16185: sqlerrm,
16186: l_debug);
16187: RAISE fnd_api.g_exc_unexpected_error;
16188: END catch_wave_exceptions_cp;
16189:
16190: PROCEDURE insert_purge_exceptions(p_exception_name VARCHAR2,
16191: p_exception_entity VARCHAR2,

Line 16331: x_return_status := fnd_api.g_ret_sts_error;

16327: WHEN others THEN
16328: print_debug('Exception in insert_purge_exceptions' || SQLCODE || ':' ||
16329: sqlerrm,
16330: l_debug);
16331: x_return_status := fnd_api.g_ret_sts_error;
16332: END insert_purge_exceptions;
16333:
16334: PROCEDURE check_so(p_current_order NUMBER,
16335: p_current_delivery NUMBER,

Line 16833: RAISE fnd_api.g_exc_unexpected_error;

16829:
16830: IF (x_return_status <> 'S') THEN
16831: print_debug('Error returned from insert_purge_exceptions ',
16832: l_debug);
16833: RAISE fnd_api.g_exc_unexpected_error;
16834: END IF;
16835:
16836: IF (p_entity = 'Order') THEN
16837: p_previous_order_id := p_current_order_id;

Line 17020: x_return_status := fnd_api.g_ret_sts_success;

17016:
17017: print_DEBUG('No data found for action name. ' || p_action_name,
17018: l_debug);
17019: --x_rowcount := 0;
17020: x_return_status := fnd_api.g_ret_sts_success;
17021: --x_return_message:= 'No data found for action name. ' || p_action_name;
17022:
17023: FOR rec_query_type IN c_query_type(p_action_name) LOOP
17024: IF rec_query_type.query_type = 'TEMP_TASK_ACTION' THEN

Line 17055: IF l_return_status = fnd_api.g_ret_sts_error OR

17051: l_msg_data,
17052: l_debug);
17053:
17054: -- If set_action_tasks_parameters returns error then log message and return.
17055: IF l_return_status = fnd_api.g_ret_sts_error OR
17056: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
17057: print_DEBUG(' Error in SET_ACTION_TASKS_PARAMETERS ', l_debug);
17058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17059: return;

Line 17056: l_return_status = fnd_api.g_ret_sts_unexp_error THEN

17052: l_debug);
17053:
17054: -- If set_action_tasks_parameters returns error then log message and return.
17055: IF l_return_status = fnd_api.g_ret_sts_error OR
17056: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
17057: print_DEBUG(' Error in SET_ACTION_TASKS_PARAMETERS ', l_debug);
17058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17059: return;
17060: END IF;

Line 17058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

17054: -- If set_action_tasks_parameters returns error then log message and return.
17055: IF l_return_status = fnd_api.g_ret_sts_error OR
17056: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
17057: print_DEBUG(' Error in SET_ACTION_TASKS_PARAMETERS ', l_debug);
17058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17059: return;
17060: END IF;
17061:
17062: -------------------------------------------------------------------------------------------------------------

Line 17293: IF l_return_status = fnd_api.g_ret_sts_error OR

17289:
17290: print_DEBUG('update_task l_return_status ' || l_return_status,
17291: l_debug);
17292:
17293: IF l_return_status = fnd_api.g_ret_sts_error OR
17294: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
17295: print_DEBUG('Error in update_task ', l_debug);
17296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17297: return;

Line 17294: l_return_status = fnd_api.g_ret_sts_unexp_error THEN

17290: print_DEBUG('update_task l_return_status ' || l_return_status,
17291: l_debug);
17292:
17293: IF l_return_status = fnd_api.g_ret_sts_error OR
17294: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
17295: print_DEBUG('Error in update_task ', l_debug);
17296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17297: return;
17298: END IF;

Line 17296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

17292:
17293: IF l_return_status = fnd_api.g_ret_sts_error OR
17294: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
17295: print_DEBUG('Error in update_task ', l_debug);
17296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17297: return;
17298: END IF;
17299:
17300: print_DEBUG('Records Updated by update_task ' ||

Line 17334: IF l_return_status = fnd_api.g_ret_sts_error OR

17330: print_DEBUG('SAVE_TASKS l_save_count = ' || l_save_count, l_debug);
17331: print_DEBUG('SAVE_TASKS l_msg_data = ' || l_msg_data, l_debug);
17332: print_DEBUG('SAVE_TASKS l_msg_count = ' || l_msg_count, l_debug);
17333:
17334: IF l_return_status = fnd_api.g_ret_sts_error OR
17335: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
17336: print_DEBUG('Error in save_task ', l_debug);
17337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17338: return;

Line 17335: l_return_status = fnd_api.g_ret_sts_unexp_error THEN

17331: print_DEBUG('SAVE_TASKS l_msg_data = ' || l_msg_data, l_debug);
17332: print_DEBUG('SAVE_TASKS l_msg_count = ' || l_msg_count, l_debug);
17333:
17334: IF l_return_status = fnd_api.g_ret_sts_error OR
17335: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
17336: print_DEBUG('Error in save_task ', l_debug);
17337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17338: return;
17339: END IF;

Line 17337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

17333:
17334: IF l_return_status = fnd_api.g_ret_sts_error OR
17335: l_return_status = fnd_api.g_ret_sts_unexp_error THEN
17336: print_DEBUG('Error in save_task ', l_debug);
17337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17338: return;
17339: END IF;
17340: END IF;
17341:

Line 17545: IF x_return_status = fnd_api.g_ret_sts_error OR

17541: p_entity_value => p_entity_value,
17542: p_action_name => p_action_name,
17543: x_return_status => x_return_status);
17544:
17545: IF x_return_status = fnd_api.g_ret_sts_error OR
17546: x_return_status = fnd_api.g_ret_sts_unexp_error THEN
17547: print_DEBUG('Error in apply_saved_action ', l_debug);
17548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17549: return;

Line 17546: x_return_status = fnd_api.g_ret_sts_unexp_error THEN

17542: p_action_name => p_action_name,
17543: x_return_status => x_return_status);
17544:
17545: IF x_return_status = fnd_api.g_ret_sts_error OR
17546: x_return_status = fnd_api.g_ret_sts_unexp_error THEN
17547: print_DEBUG('Error in apply_saved_action ', l_debug);
17548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17549: return;
17550: END IF;

Line 17548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

17544:
17545: IF x_return_status = fnd_api.g_ret_sts_error OR
17546: x_return_status = fnd_api.g_ret_sts_unexp_error THEN
17547: print_DEBUG('Error in apply_saved_action ', l_debug);
17548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17549: return;
17550: END IF;
17551:
17552: END IF;

Line 17851: x_return_status := fnd_api.g_ret_sts_success;

17847: print_debug('Inside the call to update_wave_lines_tbl at place 2',l_debug);
17848: END IF;
17849:
17850: print_debug('Before returning from update_wave_lines_tbl at place 3',l_debug);
17851: x_return_status := fnd_api.g_ret_sts_success;
17852:
17853: EXCEPTION -- 14781148
17854: WHEN OTHERS THEN
17855: print_debug('Error in update_wave_lines_tbl',l_debug);

Line 17858: x_return_status := fnd_api.G_RET_STS_ERROR;

17854: WHEN OTHERS THEN
17855: print_debug('Error in update_wave_lines_tbl',l_debug);
17856: print_debug('SQLCODE == '||SQLCODE,l_debug);
17857: print_debug('SQLERRM == '||SQLERRM,l_debug);
17858: x_return_status := fnd_api.G_RET_STS_ERROR;
17859: END update_wave_lines_tbl;
17860:
17861: -- cancel task changes end
17862: