APPS.POS_ASN_CREATE_PVT dependencies on INV_RCV_INTEGRATION_APIS

Line 126: inv_rcv_integration_apis.insert_msni (

122: and pla.po_line_id = plla.po_line_id;
123:
124: l_progress := '001'||p_po_line_loc_id;
125:
126: inv_rcv_integration_apis.insert_msni (
127: p_api_version => p_api_version
128: , x_return_status => x_return_status
129: , x_msg_count => x_msg_count
130: , x_msg_data => x_msg_data

Line 356: inv_rcv_integration_apis.insert_mtli(

352: to_quantity => l_primary_quantity );
353:
354:
355: l_progress := '001'||p_po_line_loc_id;
356: inv_rcv_integration_apis.insert_mtli(
357: p_api_version => p_api_version
358: , x_return_status => x_return_status
359: , x_msg_count => x_msg_count
360: , x_msg_data => x_msg_data

Line 503: inv_rcv_integration_apis.insert_wlpni(

499: close l_lpn_exist_csr;
500:
501: if(l_exist is null) then
502: --If LPN does not exist, insert
503: inv_rcv_integration_apis.insert_wlpni(
504: p_api_version => p_api_version,
505: x_return_status => x_return_status,
506: x_msg_count => x_msg_count,
507: x_msg_data => x_msg_data,

Line 525: inv_rcv_integration_apis.insert_wlpni(

521: close l_lpn_exist_csr;
522:
523: if(l_exist is null) then
524: --If LPN does not exist, insert
525: inv_rcv_integration_apis.insert_wlpni(
526: p_api_version => p_api_version,
527: x_return_status => x_return_status,
528: x_msg_count => x_msg_count,
529: x_msg_data => x_msg_data,

Line 554: inv_rcv_integration_apis.insert_wlpni(

550: fetch l_lpn_exist_csr into l_exist, l_parent_lpn;
551: close l_lpn_exist_csr;
552: if(l_exist is null) then
553: --Parent LPN as LPN does NOT exist ==> Insert
554: inv_rcv_integration_apis.insert_wlpni(
555: p_api_version => p_api_version,
556: x_return_status => x_return_status,
557: x_msg_count => x_msg_count,
558: x_msg_data => x_msg_data,

Line 603: decode(msi.serial_number_control_code,2,inv_rcv_integration_apis.G_EXISTS_ONLY,inv_rcv_integration_apis.G_EXISTS_OR_CREATE)

599: select
600: plla.ship_to_organization_id,
601: pla.item_id,
602: pla.item_revision,
603: decode(msi.serial_number_control_code,2,inv_rcv_integration_apis.G_EXISTS_ONLY,inv_rcv_integration_apis.G_EXISTS_OR_CREATE)
604: into
605: l_org_id,
606: l_item_id,
607: l_revision,

Line 618: l_valid_sr := inv_rcv_integration_apis.validate_serial_range (

614: and plla.ship_to_organization_id = msi.organization_id
615: and plla.line_location_id = p_line_loc_id
616: and plla.po_line_id = pla.po_line_id;
617:
618: l_valid_sr := inv_rcv_integration_apis.validate_serial_range (
619: p_api_version => 1.0
620: , x_return_status => l_ret_status
621: , x_msg_count => l_ret_count
622: , x_msg_data => l_ret_data

Line 631: , p_txn_type => inv_rcv_integration_apis.G_SHIP) ;

627: , p_revision => l_revision
628: , p_lot_number => p_lot_number
629: , p_fm_serial_number => p_fm_serial_number
630: , p_to_serial_number => l_to_serial_number
631: , p_txn_type => inv_rcv_integration_apis.G_SHIP) ;
632:
633: if(l_valid_sr = true) then
634: x_return_code := 'T';
635: else

Line 674: l_ans := inv_rcv_integration_apis.validate_lpn

670: from
671: po_line_locations_all plla
672: where plla.line_location_id = p_line_loc_id;
673:
674: l_ans := inv_rcv_integration_apis.validate_lpn
675: (p_api_version => 1.0
676: , x_return_status => l_return_status
677: , x_msg_count => l_msg_count
678: , x_msg_data => l_msg_data

Line 679: , p_validation_mode => inv_rcv_integration_apis.G_EXISTS_OR_CREATE

675: (p_api_version => 1.0
676: , x_return_status => l_return_status
677: , x_msg_count => l_msg_count
678: , x_msg_data => l_msg_data
679: , p_validation_mode => inv_rcv_integration_apis.G_EXISTS_OR_CREATE
680: , p_org_id => l_org_id
681: , p_lpn_id => l_lpn_id
682: , p_lpn => p_lpn);
683:

Line 834: l_ans := inv_rcv_integration_apis.validate_lot_number(

830: l_d_attributes_tbl(10) := p_d_attributes_tbl(10);
831:
832:
833:
834: l_ans := inv_rcv_integration_apis.validate_lot_number(
835: p_api_version => 1
836: , p_init_msg_lst => fnd_api.g_false
837: , x_return_status => l_return_status
838: , x_msg_count => l_msg_count

Line 846: , p_txn_type => inv_rcv_integration_apis.G_SHIP

842: , p_org_id => l_org_id
843: , p_inventory_item_id => l_item_id
844: , p_lot_number => p_lot_number
845: , p_expiration_date => l_exp_date
846: , p_txn_type => inv_rcv_integration_apis.G_SHIP
847:
848: , p_lot_attribute_category => p_lot_attribute_category
849: , p_c_attributes_tbl => l_c_attributes_tbl
850: , p_n_attributes_tbl => l_n_attributes_tbl