1: PACKAGE BODY INV_CR_ASN_DETAILS AS
2: /* $Header: INVCRDIB.pls 120.3 2005/10/10 12:55:32 methomas noship $*/
3:
4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_CR_ASN_DETAILS';
1: PACKAGE BODY INV_CR_ASN_DETAILS AS
2: /* $Header: INVCRDIB.pls 120.3 2005/10/10 12:55:32 methomas noship $*/
3:
4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_CR_ASN_DETAILS';
6:
7: PROCEDURE print_debug(p_err_msg VARCHAR2,
8: p_level NUMBER)
9: IS
12:
13: IF (l_debug = 1) THEN
14: inv_mobile_helper_functions.tracelog
15: (p_err_msg => p_err_msg,
16: p_module => 'INV_CR_ASN_DETAILS',
17: p_level => p_level);
18: END IF;
19:
20: -- dbms_output.put_line(p_err_msg);
692: if nvl(p_rcpt_lot_qty_rec_tb(i).txn_quantity,0) = 0 then
693: -- Case for Receipt Transaction Because Lot_REC has 0 quantity , SO NEED TO GET IT FROM mo ORDER LINES.
694:
695: IF (l_debug = 1) THEN
696: print_debug('inv_cr_asn_details: organization_id '||l_create_asn_details_rec.organization_id , 1);
697: print_debug('inv_cr_asn_details: inventory_item_id '|| l_create_asn_details_rec.ITEM_ID, 1);
698: print_debug('inv_cr_asn_details: lot_number '|| l_create_asn_details_rec.LOT_NUMBER_ACTUAL, 1);
699: print_debug('inv_cr_asn_details: reference_type_code '|| '8', 1);
700: print_debug('inv_cr_asn_details: reference_id '|| 'SHIPMENT_LINE_ID' , 1);
693: -- Case for Receipt Transaction Because Lot_REC has 0 quantity , SO NEED TO GET IT FROM mo ORDER LINES.
694:
695: IF (l_debug = 1) THEN
696: print_debug('inv_cr_asn_details: organization_id '||l_create_asn_details_rec.organization_id , 1);
697: print_debug('inv_cr_asn_details: inventory_item_id '|| l_create_asn_details_rec.ITEM_ID, 1);
698: print_debug('inv_cr_asn_details: lot_number '|| l_create_asn_details_rec.LOT_NUMBER_ACTUAL, 1);
699: print_debug('inv_cr_asn_details: reference_type_code '|| '8', 1);
700: print_debug('inv_cr_asn_details: reference_id '|| 'SHIPMENT_LINE_ID' , 1);
701: print_debug('inv_cr_asn_details: interface_transaction_id ' || p_interface_transaction_id, 1);
694:
695: IF (l_debug = 1) THEN
696: print_debug('inv_cr_asn_details: organization_id '||l_create_asn_details_rec.organization_id , 1);
697: print_debug('inv_cr_asn_details: inventory_item_id '|| l_create_asn_details_rec.ITEM_ID, 1);
698: print_debug('inv_cr_asn_details: lot_number '|| l_create_asn_details_rec.LOT_NUMBER_ACTUAL, 1);
699: print_debug('inv_cr_asn_details: reference_type_code '|| '8', 1);
700: print_debug('inv_cr_asn_details: reference_id '|| 'SHIPMENT_LINE_ID' , 1);
701: print_debug('inv_cr_asn_details: interface_transaction_id ' || p_interface_transaction_id, 1);
702: print_debug('inv_cr_asn_details: lpn_id '|| c_lpn_actual.lpn_id , 1);
695: IF (l_debug = 1) THEN
696: print_debug('inv_cr_asn_details: organization_id '||l_create_asn_details_rec.organization_id , 1);
697: print_debug('inv_cr_asn_details: inventory_item_id '|| l_create_asn_details_rec.ITEM_ID, 1);
698: print_debug('inv_cr_asn_details: lot_number '|| l_create_asn_details_rec.LOT_NUMBER_ACTUAL, 1);
699: print_debug('inv_cr_asn_details: reference_type_code '|| '8', 1);
700: print_debug('inv_cr_asn_details: reference_id '|| 'SHIPMENT_LINE_ID' , 1);
701: print_debug('inv_cr_asn_details: interface_transaction_id ' || p_interface_transaction_id, 1);
702: print_debug('inv_cr_asn_details: lpn_id '|| c_lpn_actual.lpn_id , 1);
703: END IF;
696: print_debug('inv_cr_asn_details: organization_id '||l_create_asn_details_rec.organization_id , 1);
697: print_debug('inv_cr_asn_details: inventory_item_id '|| l_create_asn_details_rec.ITEM_ID, 1);
698: print_debug('inv_cr_asn_details: lot_number '|| l_create_asn_details_rec.LOT_NUMBER_ACTUAL, 1);
699: print_debug('inv_cr_asn_details: reference_type_code '|| '8', 1);
700: print_debug('inv_cr_asn_details: reference_id '|| 'SHIPMENT_LINE_ID' , 1);
701: print_debug('inv_cr_asn_details: interface_transaction_id ' || p_interface_transaction_id, 1);
702: print_debug('inv_cr_asn_details: lpn_id '|| c_lpn_actual.lpn_id , 1);
703: END IF;
704:
697: print_debug('inv_cr_asn_details: inventory_item_id '|| l_create_asn_details_rec.ITEM_ID, 1);
698: print_debug('inv_cr_asn_details: lot_number '|| l_create_asn_details_rec.LOT_NUMBER_ACTUAL, 1);
699: print_debug('inv_cr_asn_details: reference_type_code '|| '8', 1);
700: print_debug('inv_cr_asn_details: reference_id '|| 'SHIPMENT_LINE_ID' , 1);
701: print_debug('inv_cr_asn_details: interface_transaction_id ' || p_interface_transaction_id, 1);
702: print_debug('inv_cr_asn_details: lpn_id '|| c_lpn_actual.lpn_id , 1);
703: END IF;
704:
705: IF (l_debug = 1) THEN
698: print_debug('inv_cr_asn_details: lot_number '|| l_create_asn_details_rec.LOT_NUMBER_ACTUAL, 1);
699: print_debug('inv_cr_asn_details: reference_type_code '|| '8', 1);
700: print_debug('inv_cr_asn_details: reference_id '|| 'SHIPMENT_LINE_ID' , 1);
701: print_debug('inv_cr_asn_details: interface_transaction_id ' || p_interface_transaction_id, 1);
702: print_debug('inv_cr_asn_details: lpn_id '|| c_lpn_actual.lpn_id , 1);
703: END IF;
704:
705: IF (l_debug = 1) THEN
706: print_debug('Inside MO Qty Fetch ', 1);
868: END IF;
869: ROLLBACK TO crt_asn_details;
870: x_status := fnd_api.g_ret_sts_unexp_error ;
871: IF SQLCODE IS NOT NULL THEN
872: inv_mobile_helper_functions.sql_error('INV_CR_ASN_DETAILS.create_asn_details', l_progress, SQLCODE);
873: END IF;
874:
875: fnd_msg_pub.count_and_get
876: (p_encoded => FND_API.g_false,
1101: END IF;
1102: ROLLBACK TO crt_asn_details_interface;
1103: x_status := fnd_api.g_ret_sts_unexp_error ;
1104: IF SQLCODE IS NOT NULL THEN
1105: inv_mobile_helper_functions.sql_error('INV_CR_ASN_DETAILS.create_asn_details_from_intf', l_progress, SQLCODE);
1106: END IF;
1107:
1108: fnd_msg_pub.count_and_get
1109: (p_encoded => FND_API.g_false,
1218: END update_asn_item_details;
1219:
1220: /* End of fix for Bug 4551595*/
1221:
1222: END INV_CR_ASN_DETAILS;
1223: