eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_CR_ASN_DETAILS dependencies on INV_CR_ASN_DETAILS

Line 1: PACKAGE BODY INV_CR_ASN_DETAILS AS

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';

Line 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

Line 16: p_module => 'INV_CR_ASN_DETAILS',

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);

Line 696: print_debug('inv_cr_asn_details: organization_id '||l_create_asn_details_rec.organization_id , 1);

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);

Line 697: print_debug('inv_cr_asn_details: inventory_item_id '|| l_create_asn_details_rec.ITEM_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);

Line 698: print_debug('inv_cr_asn_details: lot_number '|| l_create_asn_details_rec.LOT_NUMBER_ACTUAL, 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);

Line 699: print_debug('inv_cr_asn_details: reference_type_code '|| '8', 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;

Line 700: print_debug('inv_cr_asn_details: reference_id '|| 'SHIPMENT_LINE_ID' , 1);

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:

Line 701: print_debug('inv_cr_asn_details: interface_transaction_id ' || p_interface_transaction_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:
705: IF (l_debug = 1) THEN

Line 702: print_debug('inv_cr_asn_details: lpn_id '|| c_lpn_actual.lpn_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
706: print_debug('Inside MO Qty Fetch ', 1);

Line 872: inv_mobile_helper_functions.sql_error('INV_CR_ASN_DETAILS.create_asn_details', l_progress, SQLCODE);

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,

Line 1105: inv_mobile_helper_functions.sql_error('INV_CR_ASN_DETAILS.create_asn_details_from_intf', l_progress, SQLCODE);

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,

Line 1222: END INV_CR_ASN_DETAILS;

1218: END update_asn_item_details;
1219:
1220: /* End of fix for Bug 4551595*/
1221:
1222: END INV_CR_ASN_DETAILS;
1223: