[Home] [Help]
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
353: to_quantity => l_primary_quantity );
354:
355:
356: l_progress := '001'||p_po_line_loc_id;
357: inv_rcv_integration_apis.insert_mtli(
358: p_api_version => p_api_version
359: , x_return_status => x_return_status
360: , x_msg_count => x_msg_count
361: , x_msg_data => x_msg_data
500: close l_lpn_exist_csr;
501:
502: if(l_exist is null) then
503: --If LPN does not exist, insert
504: inv_rcv_integration_apis.insert_wlpni(
505: p_api_version => p_api_version,
506: x_return_status => x_return_status,
507: x_msg_count => x_msg_count,
508: x_msg_data => x_msg_data,
522: close l_lpn_exist_csr;
523:
524: if(l_exist is null) then
525: --If LPN does not exist, insert
526: inv_rcv_integration_apis.insert_wlpni(
527: p_api_version => p_api_version,
528: x_return_status => x_return_status,
529: x_msg_count => x_msg_count,
530: x_msg_data => x_msg_data,
551: fetch l_lpn_exist_csr into l_exist, l_parent_lpn;
552: close l_lpn_exist_csr;
553: if(l_exist is null) then
554: --Parent LPN as LPN does NOT exist ==> Insert
555: inv_rcv_integration_apis.insert_wlpni(
556: p_api_version => p_api_version,
557: x_return_status => x_return_status,
558: x_msg_count => x_msg_count,
559: x_msg_data => x_msg_data,
600: select
601: plla.ship_to_organization_id,
602: pla.item_id,
603: pla.item_revision,
604: decode(msi.serial_number_control_code,2,inv_rcv_integration_apis.G_EXISTS_ONLY,inv_rcv_integration_apis.G_EXISTS_OR_CREATE)
605: into
606: l_org_id,
607: l_item_id,
608: l_revision,
615: and plla.ship_to_organization_id = msi.organization_id
616: and plla.line_location_id = p_line_loc_id
617: and plla.po_line_id = pla.po_line_id;
618:
619: l_valid_sr := inv_rcv_integration_apis.validate_serial_range (
620: p_api_version => 1.0
621: , x_return_status => l_ret_status
622: , x_msg_count => l_ret_count
623: , x_msg_data => l_ret_data
628: , p_revision => l_revision
629: , p_lot_number => p_lot_number
630: , p_fm_serial_number => p_fm_serial_number
631: , p_to_serial_number => l_to_serial_number
632: , p_txn_type => inv_rcv_integration_apis.G_SHIP) ;
633:
634: if(l_valid_sr = true) then
635: x_return_code := 'T';
636: else
671: from
672: po_line_locations_all plla
673: where plla.line_location_id = p_line_loc_id;
674:
675: l_ans := inv_rcv_integration_apis.validate_lpn
676: (p_api_version => 1.0
677: , x_return_status => l_return_status
678: , x_msg_count => l_msg_count
679: , x_msg_data => l_msg_data
676: (p_api_version => 1.0
677: , x_return_status => l_return_status
678: , x_msg_count => l_msg_count
679: , x_msg_data => l_msg_data
680: , p_validation_mode => inv_rcv_integration_apis.G_EXISTS_OR_CREATE
681: , p_org_id => l_org_id
682: , p_lpn_id => l_lpn_id
683: , p_lpn => p_lpn);
684:
831: l_d_attributes_tbl(10) := p_d_attributes_tbl(10);
832:
833:
834:
835: l_ans := inv_rcv_integration_apis.validate_lot_number(
836: p_api_version => 1
837: , p_init_msg_lst => fnd_api.g_false
838: , x_return_status => l_return_status
839: , x_msg_count => l_msg_count
843: , p_org_id => l_org_id
844: , p_inventory_item_id => l_item_id
845: , p_lot_number => p_lot_number
846: , p_expiration_date => p_lot_exp_dt --Added for bug 8404937
847: , p_txn_type => inv_rcv_integration_apis.G_SHIP
848:
849: , p_lot_attribute_category => p_lot_attribute_category
850: , p_c_attributes_tbl => l_c_attributes_tbl
851: , p_n_attributes_tbl => l_n_attributes_tbl