DBA Data[Home] [Help]

APPS.POS_EXCELASN_PVT dependencies on POS_ASN_CREATE_PVT

Line 542: POS_ASN_CREATE_PVT.ValidateLot(

538: l_n_attributes_tbl(9) := l_nattribute9;
539: l_n_attributes_tbl(10) := l_nattribute10;
540:
541:
542: POS_ASN_CREATE_PVT.ValidateLot(
543: p_api_version => 1
544: , x_return_status => l_lot_status
545: , p_validation_mode => inv_rcv_integration_apis.G_EXISTS_OR_CREATE
546: , x_is_new_lot => l_is_new_lot

Line 599: POS_ASN_CREATE_PVT.ValidateLpn(

595: end if;
596: end if;
597:
598: if(l_lpn is not null) then
599: POS_ASN_CREATE_PVT.ValidateLpn(
600: p_api_version => 1.0
601: , x_return_status => l_lpn_status
602: , p_lpn => l_lpn
603: , p_line_loc_id => l_po_line_loc_id

Line 644: POS_ASN_CREATE_PVT.ValidateSerialRange(

640: l_lpn,
641: l_po_line_loc_id,
642: l_lot_number;
643: exit when l_checkSerial_csr%NOTFOUND;
644: POS_ASN_CREATE_PVT.ValidateSerialRange(
645: p_api_version => 1.0
646: , x_return_status => l_ser_status
647: , p_fm_serial_number => l_fm_serial
648: , p_to_serial_number => l_to_serial

Line 673: POS_ASN_CREATE_PVT.ValidateLpn(

669: raise l_25errors;
670: end if;
671: end if;
672: if(l_lpn is not null) then
673: POS_ASN_CREATE_PVT.ValidateLpn(
674: p_api_version => 1.0
675: , x_return_status => l_lpn_status
676: , p_lpn => l_lpn
677: , p_line_loc_id => l_po_line_loc_id

Line 712: POS_ASN_CREATE_PVT.ValidateLpn(

708: l_lpn,
709: l_parent_lpn,
710: l_po_line_loc_id;
711: exit when l_checkLpn_csr%NOTFOUND;
712: POS_ASN_CREATE_PVT.ValidateLpn(
713: p_api_version => 1.0
714: , x_return_status => l_lpn_status
715: , p_lpn => l_lpn
716: , p_line_loc_id => l_po_line_loc_id

Line 740: POS_ASN_CREATE_PVT.ValidateLpn(

736: end if;
737: end if;
738:
739: if(l_parent_lpn is not null) then
740: POS_ASN_CREATE_PVT.ValidateLpn(
741: p_api_version => 1.0
742: , x_return_status => l_lpn_status
743: , p_lpn => l_parent_lpn
744: , p_line_loc_id => l_po_line_loc_id

Line 1291: MODULE =>'pos.plsql.pos_asn_create_pvt.ValidateLines',

1287: IF(l_vendor_id_not_secured = 'T') THEN
1288:
1289: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1290: FND_LOG.string( LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
1291: MODULE =>'pos.plsql.pos_asn_create_pvt.ValidateLines',
1292: MESSAGE => 'Line : ' || l_error_ln || 'Vendor Id: ' ||
1293: l_vendor_id||' is not secured');
1294: END IF;
1295:

Line 2584: pos_asn_create_pvt.insert_mtli(

2580: l_NATTRIBUTE9,
2581: l_NATTRIBUTE10;
2582: exit when l_allLots_csr%NOTFOUND;
2583:
2584: pos_asn_create_pvt.insert_mtli(
2585: p_api_version => 1.0
2586: , x_return_status => l_lot_status
2587: , x_msg_count => l_lot_msg_count
2588: , x_msg_data => l_lot_msg_data

Line 2677: pos_asn_create_pvt.insert_wlpni

2673: set TRANSACTION_INTERFACE_ID = l_txn_intf_id, serial_transaction_temp_id = l_serial_txn_temp_id
2674: where lot_id = l_lot_id;
2675:
2676: if(l_lpn is not null) then
2677: pos_asn_create_pvt.insert_wlpni
2678: ( p_api_version => 1.0
2679: , x_return_status => l_lpn_status
2680: , x_msg_count => l_lpn_msg_count
2681: , x_msg_data => l_lpn_msg_data

Line 2766: pos_asn_create_pvt.insert_msni (

2762: l_NATTRIBUTE10;
2763: exit when l_allSerials_csr%NOTFOUND;
2764:
2765:
2766: pos_asn_create_pvt.insert_msni (
2767: p_api_version => 1.0
2768: , x_return_status => l_ser_status
2769: , x_msg_count => l_ser_msg_count
2770: , x_msg_data => l_ser_msg_data

Line 2830: pos_asn_create_pvt.insert_wlpni

2826: end if;
2827: end if;
2828:
2829: if(l_lpn is not null) then
2830: pos_asn_create_pvt.insert_wlpni
2831: ( p_api_version => 1.0
2832: , x_return_status => l_lpn_status
2833: , x_msg_count => l_lpn_msg_count
2834: , x_msg_data => l_lpn_msg_data

Line 2859: pos_asn_create_pvt.insert_wlpni

2855: l_lpn_group_id,
2856: l_lpn_ln;
2857: exit when l_allLpns_csr%NOTFOUND;
2858:
2859: pos_asn_create_pvt.insert_wlpni
2860: ( p_api_version => 1.0
2861: , x_return_status => l_lpn_status
2862: , x_msg_count => l_lpn_msg_count
2863: , x_msg_data => l_lpn_msg_data

Line 4015: MODULE => 'pos.plsql.pos_asn_create_pvt.CheckSecuringAtt',

4011: l_index := l_index+1;
4012:
4013: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4014: FND_LOG.string( LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
4015: MODULE => 'pos.plsql.pos_asn_create_pvt.CheckSecuringAtt',
4016: MESSAGE => 'Retrieved Vendor Id ' || l_index || ':' ||
4017: l_user_vendor_id);
4018: END IF;
4019:

Line 4026: MODULE => 'pos.plsql.pos_asn_create_pvt.CheckSecuringAtt',

4022: EXCEPTION
4023: WHEN NO_DATA_FOUND THEN
4024: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4025: FND_LOG.string( LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
4026: MODULE => 'pos.plsql.pos_asn_create_pvt.CheckSecuringAtt',
4027: MESSAGE => 'No data found for cursor: l_vendorId_csr');
4028: END IF;
4029:
4030: fnd_message.set_name('POS','POS_EXASN_NOT_ORG_SEC');

Line 4307: POS_ASN_CREATE_PVT.validate_ship_from

4303:
4304: if (l_prev_header_id <> -1 AND l_prev_header_id <> l_header_id) THEN
4305: -- the first time they are not equal, we dont need to do validations
4306:
4307: POS_ASN_CREATE_PVT.validate_ship_from
4308: (p_api_version_number => 1.0,
4309: p_init_msg_list => 'T',
4310: x_return_status => l_return_status,
4311: p_ship_from_locationid=> l_ship_from_location_id,