DBA Data[Home] [Help]

APPS.INV_RESERVATION_PVT dependencies on CTO_WORKFLOW_API_PK

Line 8378: cto_workflow_api_pk.inventory_reservation_check(p_order_line_id => l_rsv_rec.demand_source_line_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);

8374: --
8375: -- Pre Insert CTO Validation
8376: IF l_rsv_rec.demand_source_type_id IN (inv_reservation_global.g_source_type_oe, inv_reservation_global.g_source_type_internal_ord, inv_reservation_global.g_source_type_rma) THEN
8377: --
8378: cto_workflow_api_pk.inventory_reservation_check(p_order_line_id => l_rsv_rec.demand_source_line_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);
8379:
8380: IF (l_debug = 1) THEN
8381: debug_print('After CTO validation ' || l_return_status);
8382: END IF;

Line 9079: cto_workflow_api_pk.wf_update_after_inv_reserv(p_order_line_id => l_rsv_rec.demand_source_line_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);

9075: --
9076: -- Post Insert CTO Validation
9077: IF l_rsv_rec.demand_source_type_id IN (inv_reservation_global.g_source_type_oe, inv_reservation_global.g_source_type_internal_ord, inv_reservation_global.g_source_type_rma) THEN
9078: --
9079: cto_workflow_api_pk.wf_update_after_inv_reserv(p_order_line_id => l_rsv_rec.demand_source_line_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);
9080:
9081: IF (l_debug = 1) THEN
9082: debug_print('After post CTO validation ' || l_return_status);
9083: END IF;

Line 10363: cto_workflow_api_pk.inventory_unreservation_check

10359: debug_print('Pre Update CTO validation');
10360: END IF;
10361:
10362: IF l_orig_rsv_tbl(1).primary_reservation_quantity > l_to_rsv_rec.primary_reservation_quantity THEN
10363: cto_workflow_api_pk.inventory_unreservation_check
10364: (
10365: p_order_line_id => l_orig_rsv_tbl(1).demand_source_line_id
10366: , p_rsv_quantity => l_orig_rsv_tbl(1).primary_reservation_quantity - l_to_rsv_rec.primary_reservation_quantity
10367: , x_return_status => l_return_status

Line 10373: cto_workflow_api_pk.inventory_reservation_check

10369: , x_msg_data => x_msg_data
10370: );
10371:
10372: ELSE --Else Condition Added for Bug#2467387.
10373: cto_workflow_api_pk.inventory_reservation_check
10374: (
10375: p_order_line_id => l_orig_rsv_tbl(1).demand_source_line_id
10376: ,x_return_status => l_return_status
10377: ,x_msg_count => x_msg_count

Line 10917: debug_print('Calling cto_workflow_api_pk.wf_update_after_inv_unreserv');

10913: IF l_to_rsv_rec.demand_source_type_id IN (inv_reservation_global.g_source_type_oe, inv_reservation_global.g_source_type_internal_ord, inv_reservation_global.g_source_type_rma) THEN
10914: --
10915: IF l_orig_rsv_tbl(1).primary_reservation_quantity > l_to_rsv_rec.primary_reservation_quantity THEN
10916: IF (l_debug = 1) THEN
10917: debug_print('Calling cto_workflow_api_pk.wf_update_after_inv_unreserv');
10918: END IF;
10919: cto_workflow_api_pk.wf_update_after_inv_unreserv
10920: (
10921: p_order_line_id => l_to_rsv_rec.demand_source_line_id

Line 10919: cto_workflow_api_pk.wf_update_after_inv_unreserv

10915: IF l_orig_rsv_tbl(1).primary_reservation_quantity > l_to_rsv_rec.primary_reservation_quantity THEN
10916: IF (l_debug = 1) THEN
10917: debug_print('Calling cto_workflow_api_pk.wf_update_after_inv_unreserv');
10918: END IF;
10919: cto_workflow_api_pk.wf_update_after_inv_unreserv
10920: (
10921: p_order_line_id => l_to_rsv_rec.demand_source_line_id
10922: , x_return_status => l_return_status
10923: , x_msg_count => x_msg_count

Line 10928: debug_print('Calling cto_workflow_api_pk.wf_update_after_inv_reserv');

10924: , x_msg_data => x_msg_data
10925: );
10926: ELSE --Else Condition Added for Bug#2467387.
10927: IF (l_debug = 1) THEN
10928: debug_print('Calling cto_workflow_api_pk.wf_update_after_inv_reserv');
10929: END IF;
10930: cto_workflow_api_pk.wf_update_after_inv_reserv
10931: (
10932: p_order_line_id => l_to_rsv_rec.demand_source_line_id

Line 10930: cto_workflow_api_pk.wf_update_after_inv_reserv

10926: ELSE --Else Condition Added for Bug#2467387.
10927: IF (l_debug = 1) THEN
10928: debug_print('Calling cto_workflow_api_pk.wf_update_after_inv_reserv');
10929: END IF;
10930: cto_workflow_api_pk.wf_update_after_inv_reserv
10931: (
10932: p_order_line_id => l_to_rsv_rec.demand_source_line_id
10933: ,x_return_status => l_return_status
10934: ,x_msg_count => x_msg_count

Line 12077: cto_workflow_api_pk.inventory_unreservation_check(

12073:
12074: -- Pre Delete CTO Validation
12075: IF l_tmp_rsv_tbl(1).demand_source_type_id IN (inv_reservation_global.g_source_type_oe, inv_reservation_global.g_source_type_internal_ord, inv_reservation_global.g_source_type_rma) THEN
12076: --
12077: cto_workflow_api_pk.inventory_unreservation_check(
12078: p_order_line_id => l_tmp_rsv_tbl(1).demand_source_line_id
12079: , p_rsv_quantity => l_tmp_rsv_tbl(1).primary_reservation_quantity
12080: , x_return_status => l_return_status
12081: , x_msg_count => x_msg_count

Line 12140: cto_workflow_api_pk.wf_update_after_inv_unreserv(

12136:
12137: -- Post Delete CTO Validation
12138: IF l_tmp_rsv_tbl(1).demand_source_type_id IN (inv_reservation_global.g_source_type_oe, inv_reservation_global.g_source_type_internal_ord, inv_reservation_global.g_source_type_rma) THEN
12139: --
12140: cto_workflow_api_pk.wf_update_after_inv_unreserv(
12141: p_order_line_id => l_tmp_rsv_tbl(1).demand_source_line_id
12142: , x_return_status => l_return_status
12143: , x_msg_count => x_msg_count
12144: , x_msg_data => x_msg_data

Line 13229: cto_workflow_api_pk.inventory_unreservation_check(

13225: --
13226: IF (l_debug = 1) THEN
13227: debug_print('Before calling cto work flow unresv check');
13228: END IF;
13229: cto_workflow_api_pk.inventory_unreservation_check(
13230: p_order_line_id => l_orig_rsv_tbl(1).demand_source_line_id
13231: , p_rsv_quantity => l_to_rsv_rec.primary_reservation_quantity
13232: , x_return_status => l_return_status
13233: , x_msg_count => x_msg_count

Line 13426: * cto_workflow_api_pk.wf_update_after_inv_unreserv(

13422: * inv_reservation_global.g_source_type_oe
13423: * ,inv_reservation_global.g_source_type_internal_ord
13424: * ,inv_reservation_global.g_source_type_rma) THEN
13425: * --
13426: * cto_workflow_api_pk.wf_update_after_inv_unreserv(
13427: * p_order_line_id => l_orig_rsv_tbl(1).demand_source_line_id
13428: * , x_return_status => l_return_status
13429: * , x_msg_count => x_msg_count
13430: * , x_msg_data => x_msg_data

Line 13450: cto_workflow_api_pk.inventory_unreservation_check(

13446: END IF;
13447: -- Pre Delete CTO Validation
13448: IF l_orig_rsv_tbl(1).demand_source_type_id IN (inv_reservation_global.g_source_type_oe, inv_reservation_global.g_source_type_internal_ord, inv_reservation_global.g_source_type_rma) THEN
13449: --
13450: cto_workflow_api_pk.inventory_unreservation_check(
13451: p_order_line_id => l_orig_rsv_tbl(1).demand_source_line_id
13452: , p_rsv_quantity => l_to_rsv_rec.primary_reservation_quantity
13453: , x_return_status => l_return_status
13454: , x_msg_count => x_msg_count

Line 13498: * cto_workflow_api_pk.wf_update_after_inv_unreserv(

13494: * inv_reservation_global.g_source_type_oe
13495: * ,inv_reservation_global.g_source_type_internal_ord
13496: * ,inv_reservation_global.g_source_type_rma) THEN
13497: * --
13498: * cto_workflow_api_pk.wf_update_after_inv_unreserv(
13499: * p_order_line_id => l_orig_rsv_tbl(1).demand_source_line_id
13500: * , x_return_status => l_return_status
13501: * , x_msg_count => x_msg_count
13502: * , x_msg_data => x_msg_data

Line 13522: cto_workflow_api_pk.inventory_unreservation_check(

13518: END IF;
13519: -- Pre Update CTO Validation
13520: IF l_orig_rsv_tbl(1).demand_source_type_id IN (inv_reservation_global.g_source_type_oe, inv_reservation_global.g_source_type_internal_ord, inv_reservation_global.g_source_type_rma) THEN
13521: --
13522: cto_workflow_api_pk.inventory_unreservation_check(
13523: p_order_line_id => l_orig_rsv_tbl(1).demand_source_line_id
13524: , p_rsv_quantity => l_orig_rsv_tbl(1).primary_reservation_quantity
13525: , x_return_status => l_return_status
13526: , x_msg_count => x_msg_count

Line 13550: cto_workflow_api_pk.inventory_reservation_check(

13546: inv_reservation_global.g_source_type_internal_ord,
13547: inv_reservation_global.g_source_type_rma) THEN
13548:
13549: --
13550: cto_workflow_api_pk.inventory_reservation_check(
13551: p_order_line_id => l_to_rsv_rec.demand_source_line_id
13552: , x_return_status => l_return_status
13553: , x_msg_count => x_msg_count
13554: , x_msg_data => x_msg_data

Line 13725: cto_workflow_api_pk.wf_update_after_inv_unreserv(

13721:
13722: IF l_orig_rsv_tbl(1).demand_source_type_id = 2 -- Bug 6195783 : Begin
13723: AND l_to_rsv_rec.demand_source_type_id = 9
13724: AND l_orig_rsv_tbl(1).primary_reservation_quantity = l_to_rsv_rec.primary_reservation_quantity THEN
13725: cto_workflow_api_pk.wf_update_after_inv_unreserv(
13726: p_order_line_id => l_orig_rsv_tbl(1).demand_source_line_id
13727: , x_return_status => l_return_status
13728: , x_msg_count => x_msg_count
13729: , x_msg_data => x_msg_data

Line 13745: * cto_workflow_api_pk.wf_update_after_inv_unreserv(

13741: * inv_reservation_global.g_source_type_oe
13742: * ,inv_reservation_global.g_source_type_internal_ord
13743: * ,inv_reservation_global.g_source_type_rma) THEN
13744: * --
13745: * cto_workflow_api_pk.wf_update_after_inv_unreserv(
13746: * p_order_line_id => l_orig_rsv_tbl(1).demand_source_line_id
13747: * , x_return_status => l_return_status
13748: * , x_msg_count => x_msg_count
13749: * , x_msg_data => x_msg_data

Line 13776: cto_workflow_api_pk.inventory_unreservation_check(

13772: issue has been reported in bug 2458523
13773: -- Pre Update CTO Validation
13774: IF l_to_rsv_rec.demand_source_type_id IN (inv_reservation_global.g_source_type_oe, inv_reservation_global.g_source_type_internal_ord, inv_reservation_global.g_source_type_rma) THEN
13775: --
13776: cto_workflow_api_pk.inventory_unreservation_check(
13777: p_order_line_id => l_to_rsv_rec.demand_source_line_id
13778: , p_rsv_quantity => l_to_rsv_rec.primary_reservation_quantity
13779: , x_return_status => l_return_status
13780: , x_msg_count => x_msg_count

Line 13805: cto_workflow_api_pk.inventory_reservation_check(

13801: inv_reservation_global.g_source_type_internal_ord,
13802: inv_reservation_global.g_source_type_rma) THEN
13803:
13804: --
13805: cto_workflow_api_pk.inventory_reservation_check(
13806: p_order_line_id => l_to_rsv_rec.demand_source_line_id
13807: , x_return_status => l_return_status
13808: , x_msg_count => x_msg_count
13809: , x_msg_data => x_msg_data

Line 13918: * cto_workflow_api_pk.wf_update_after_inv_unreserv(

13914: * inv_reservation_global.g_source_type_oe
13915: * ,inv_reservation_global.g_source_type_internal_ord
13916: * ,inv_reservation_global.g_source_type_rma) THEN
13917: * --
13918: * cto_workflow_api_pk.wf_update_after_inv_unreserv(
13919: * p_order_line_id => l_to_rsv_rec.demand_source_line_id
13920: * , x_return_status => l_return_status
13921: * , x_msg_count => x_msg_count
13922: * , x_msg_data => x_msg_data

Line 13942: cto_workflow_api_pk.inventory_reservation_check(

13938: END IF;
13939: -- Pre Insert CTO Validation
13940: IF l_to_rsv_rec.demand_source_type_id IN (inv_reservation_global.g_source_type_oe, inv_reservation_global.g_source_type_internal_ord, inv_reservation_global.g_source_type_rma) THEN
13941: --
13942: cto_workflow_api_pk.inventory_reservation_check(
13943: p_order_line_id => l_to_rsv_rec.demand_source_line_id
13944: , x_return_status => l_return_status
13945: , x_msg_count => x_msg_count
13946: , x_msg_data => x_msg_data

Line 14161: cto_workflow_api_pk.wf_update_after_inv_reserv(p_order_line_id => l_to_rsv_rec.demand_source_line_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);

14157: -- transfer_reservation is called
14158: -- Post Insert CTO Validation
14159: IF l_to_rsv_rec.demand_source_type_id IN (inv_reservation_global.g_source_type_oe, inv_reservation_global.g_source_type_internal_ord, inv_reservation_global.g_source_type_rma) THEN
14160: --
14161: cto_workflow_api_pk.wf_update_after_inv_reserv(p_order_line_id => l_to_rsv_rec.demand_source_line_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);
14162:
14163: debug_print(' After CTO API' || l_return_status);
14164: --
14165: IF l_return_status = fnd_api.g_ret_sts_error THEN