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.JL_ZZ_RECEIV_INTERFACE dependencies on OE_DEBUG_PUB

Line 118: OE_DEBUG_PUB.ADD('JL-Country Code is ' || l_country_code);

114: l_country_code := SUBSTR(x_interface_line_rec.line_gdf_attr_category,4,2);
115:
116: l_jl := 'JL';
117: --
118: OE_DEBUG_PUB.ADD('JL-Country Code is ' || l_country_code);
119:
120: IF NVL(l_country_code,'$') IN ('BR','AR','CO') THEN
121:
122: l_tax_method := JL_ZZ_AR_TX_LIB_PKG.get_tax_method(l_org_id);

Line 123: OE_DEBUG_PUB.ADD('JL-Tax Method is ' || l_tax_method);

119:
120: IF NVL(l_country_code,'$') IN ('BR','AR','CO') THEN
121:
122: l_tax_method := JL_ZZ_AR_TX_LIB_PKG.get_tax_method(l_org_id);
123: OE_DEBUG_PUB.ADD('JL-Tax Method is ' || l_tax_method);
124:
125: l_so_organization_id:= to_number(oe_profile.value('SO_ORGANIZATION_ID'));
126: OE_DEBUG_PUB.ADD('JL-So Organization id is ' || l_so_organization_id);
127:

Line 126: OE_DEBUG_PUB.ADD('JL-So Organization id is ' || l_so_organization_id);

122: l_tax_method := JL_ZZ_AR_TX_LIB_PKG.get_tax_method(l_org_id);
123: OE_DEBUG_PUB.ADD('JL-Tax Method is ' || l_tax_method);
124:
125: l_so_organization_id:= to_number(oe_profile.value('SO_ORGANIZATION_ID'));
126: OE_DEBUG_PUB.ADD('JL-So Organization id is ' || l_so_organization_id);
127:
128: IF l_country_code = 'BR' THEN
129: l_header_attr_category := 'JL.BR.ARXTWMAI.Additional Info';
130: l_line_attr_category := 'JL.BR.ARXTWMAI.Additional Info';

Line 141: OE_DEBUG_PUB.ADD('JL-Line Id '|| l_line_id);

137:
138: l_line_id := p_interface_line_rec.interface_line_attribute6;
139: l_inventory_item_id := p_interface_line_rec.inventory_item_id;
140:
141: OE_DEBUG_PUB.ADD('JL-Line Id '|| l_line_id);
142: OE_DEBUG_PUB.ADD('JL-Inventory Item Id '|| l_inventory_item_id);
143: OE_DEBUG_PUB.ADD('JL-Line Type '|| p_interface_line_rec.line_type);
144:
145: l_invoice_line_id := NULL;

Line 142: OE_DEBUG_PUB.ADD('JL-Inventory Item Id '|| l_inventory_item_id);

138: l_line_id := p_interface_line_rec.interface_line_attribute6;
139: l_inventory_item_id := p_interface_line_rec.inventory_item_id;
140:
141: OE_DEBUG_PUB.ADD('JL-Line Id '|| l_line_id);
142: OE_DEBUG_PUB.ADD('JL-Inventory Item Id '|| l_inventory_item_id);
143: OE_DEBUG_PUB.ADD('JL-Line Type '|| p_interface_line_rec.line_type);
144:
145: l_invoice_line_id := NULL;
146: l_order_line_id := NULL;

Line 143: OE_DEBUG_PUB.ADD('JL-Line Type '|| p_interface_line_rec.line_type);

139: l_inventory_item_id := p_interface_line_rec.inventory_item_id;
140:
141: OE_DEBUG_PUB.ADD('JL-Line Id '|| l_line_id);
142: OE_DEBUG_PUB.ADD('JL-Inventory Item Id '|| l_inventory_item_id);
143: OE_DEBUG_PUB.ADD('JL-Line Type '|| p_interface_line_rec.line_type);
144:
145: l_invoice_line_id := NULL;
146: l_order_line_id := NULL;
147: IF l_tax_method = 'LTE' THEN

Line 169: OE_DEBUG_PUB.ADD('JL-Invoice Line Id '|| l_invoice_line_id);

165: END;
166:
167: END IF;
168:
169: OE_DEBUG_PUB.ADD('JL-Invoice Line Id '|| l_invoice_line_id);
170: OE_DEBUG_PUB.ADD('JL-Return Id '|| l_order_line_id);
171:
172: IF (l_invoice_line_id IS NULL AND
173: l_order_line_id IS NULL) THEN

Line 170: OE_DEBUG_PUB.ADD('JL-Return Id '|| l_order_line_id);

166:
167: END IF;
168:
169: OE_DEBUG_PUB.ADD('JL-Invoice Line Id '|| l_invoice_line_id);
170: OE_DEBUG_PUB.ADD('JL-Return Id '|| l_order_line_id);
171:
172: IF (l_invoice_line_id IS NULL AND
173: l_order_line_id IS NULL) THEN
174:

Line 197: OE_DEBUG_PUB.ADD('JL-Delivery Name '||

193:
194: IF p_interface_line_rec.line_type = 'LINE' THEN
195:
196: BEGIN
197: OE_DEBUG_PUB.ADD('JL-Delivery Name '||
198: p_interface_line_rec.interface_line_attribute3);
199: SELECT del.gross_weight,
200: del.net_weight,
201: del.global_attribute3,

Line 466: OE_DEBUG_PUB.ADD('JL-Exception Others');

462: END IF; -- Country Code check
463:
464: EXCEPTION
465: WHEN OTHERS THEN
466: OE_DEBUG_PUB.ADD('JL-Exception Others');
467: x_error_buffer := SQLERRM;
468: x_return_code := 2;
469:
470: END copy_gdff;

Line 548: OE_DEBUG_PUB.ADD('JL-Country Code is ' || l_country_code);

544: l_country_code := SUBSTR(x_interface_line_rec.line_gdf_attr_category,4,2);
545:
546: l_jl := 'JL';
547: --
548: OE_DEBUG_PUB.ADD('JL-Country Code is ' || l_country_code);
549:
550: IF NVL(l_country_code,'$') IN ('BR','AR','CO') THEN
551:
552: l_org_id := mo_global.get_current_org_id;

Line 554: OE_DEBUG_PUB.ADD('JL-Tax Method is ' || l_tax_method);

550: IF NVL(l_country_code,'$') IN ('BR','AR','CO') THEN
551:
552: l_org_id := mo_global.get_current_org_id;
553: l_tax_method := JL_ZZ_AR_TX_LIB_PKG.get_tax_method(l_org_id);
554: OE_DEBUG_PUB.ADD('JL-Tax Method is ' || l_tax_method);
555:
556: l_so_organization_id:= to_number(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',l_org_id));
557: OE_DEBUG_PUB.ADD('JL-So Organization id is ' || l_so_organization_id);
558:

Line 557: OE_DEBUG_PUB.ADD('JL-So Organization id is ' || l_so_organization_id);

553: l_tax_method := JL_ZZ_AR_TX_LIB_PKG.get_tax_method(l_org_id);
554: OE_DEBUG_PUB.ADD('JL-Tax Method is ' || l_tax_method);
555:
556: l_so_organization_id:= to_number(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',l_org_id));
557: OE_DEBUG_PUB.ADD('JL-So Organization id is ' || l_so_organization_id);
558:
559: IF l_country_code = 'BR' THEN
560: l_header_attr_category := 'JL.BR.ARXTWMAI.Additional Info';
561: l_line_attr_category := 'JL.BR.ARXTWMAI.Additional Info';

Line 572: OE_DEBUG_PUB.ADD('JL-Line Id '|| l_line_id);

568:
569: l_line_id := x_interface_line_rec.interface_line_attribute6;
570: l_inventory_item_id := x_interface_line_rec.inventory_item_id;
571:
572: OE_DEBUG_PUB.ADD('JL-Line Id '|| l_line_id);
573: OE_DEBUG_PUB.ADD('JL-Inventory Item Id '|| l_inventory_item_id);
574: OE_DEBUG_PUB.ADD('JL-Line Type '|| x_interface_line_rec.line_type);
575:
576: l_invoice_line_id := NULL;

Line 573: OE_DEBUG_PUB.ADD('JL-Inventory Item Id '|| l_inventory_item_id);

569: l_line_id := x_interface_line_rec.interface_line_attribute6;
570: l_inventory_item_id := x_interface_line_rec.inventory_item_id;
571:
572: OE_DEBUG_PUB.ADD('JL-Line Id '|| l_line_id);
573: OE_DEBUG_PUB.ADD('JL-Inventory Item Id '|| l_inventory_item_id);
574: OE_DEBUG_PUB.ADD('JL-Line Type '|| x_interface_line_rec.line_type);
575:
576: l_invoice_line_id := NULL;
577: l_order_line_id := NULL;

Line 574: OE_DEBUG_PUB.ADD('JL-Line Type '|| x_interface_line_rec.line_type);

570: l_inventory_item_id := x_interface_line_rec.inventory_item_id;
571:
572: OE_DEBUG_PUB.ADD('JL-Line Id '|| l_line_id);
573: OE_DEBUG_PUB.ADD('JL-Inventory Item Id '|| l_inventory_item_id);
574: OE_DEBUG_PUB.ADD('JL-Line Type '|| x_interface_line_rec.line_type);
575:
576: l_invoice_line_id := NULL;
577: l_order_line_id := NULL;
578: IF l_tax_method = 'LTE' THEN

Line 600: OE_DEBUG_PUB.ADD('JL-Invoice Line Id '|| l_invoice_line_id);

596: END;
597:
598: END IF;
599:
600: OE_DEBUG_PUB.ADD('JL-Invoice Line Id '|| l_invoice_line_id);
601: OE_DEBUG_PUB.ADD('JL-Return Id '|| l_order_line_id);
602:
603: IF (l_invoice_line_id IS NULL AND
604: l_order_line_id IS NULL) THEN

Line 601: OE_DEBUG_PUB.ADD('JL-Return Id '|| l_order_line_id);

597:
598: END IF;
599:
600: OE_DEBUG_PUB.ADD('JL-Invoice Line Id '|| l_invoice_line_id);
601: OE_DEBUG_PUB.ADD('JL-Return Id '|| l_order_line_id);
602:
603: IF (l_invoice_line_id IS NULL AND
604: l_order_line_id IS NULL) THEN
605:

Line 628: OE_DEBUG_PUB.ADD('JL-Delivery Name '||

624:
625: IF x_interface_line_rec.line_type = 'LINE' THEN
626:
627: BEGIN
628: OE_DEBUG_PUB.ADD('JL-Delivery Name '||
629: x_interface_line_rec.interface_line_attribute3);
630: SELECT del.gross_weight,
631: del.net_weight,
632: del.global_attribute3,

Line 898: OE_DEBUG_PUB.ADD('JL-Exception Others');

894: END IF; -- Country Code check
895:
896: EXCEPTION
897: WHEN OTHERS THEN
898: OE_DEBUG_PUB.ADD('JL-Exception Others');
899: x_error_buffer := SQLERRM;
900: x_return_code := 2;
901:
902: END copy_gdf;

Line 1002: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Transaction Nature');

998: WHERE mtl.organization_id = l_inventory_org_id
999: AND mtl.inventory_item_id = p_line_rec.inventory_item_id;
1000: EXCEPTION
1001: WHEN OTHERS THEN
1002: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Transaction Nature');
1003: l_tran_nat := NULL;
1004: END;
1005:
1006: --Bug#6019028: No transaction class for CO as org id is picked from ship_from_org_id

Line 1018: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Transaction Nature');

1014: WHERE mtl.organization_id = l_so_organization_id
1015: AND mtl.inventory_item_id = p_line_rec.inventory_item_id;
1016: EXCEPTION
1017: WHEN OTHERS THEN
1018: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Transaction Nature');
1019: l_tran_nat := NULL;
1020: END;
1021: END IF;
1022:

Line 1051: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Fiscal Classification');

1047: AND enabled_flag = 'Y')
1048: AND ROWNUM =1;
1049: EXCEPTION
1050: WHEN OTHERS THEN
1051: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Fiscal Classification');
1052: l_fcc_code := NULL;
1053:
1054: END;
1055:

Line 1086: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Fiscal Classification');

1082: AND enabled_flag = 'Y')
1083: AND ROWNUM =1;
1084: EXCEPTION
1085: WHEN OTHERS THEN
1086: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Fiscal Classification');
1087: l_fcc_code := NULL;
1088: END;
1089: END IF;
1090:

Line 1093: OE_DEBUG_PUB.ADD('Org ID: '|| to_char(l_org_id));

1089: END IF;
1090:
1091: END IF;
1092:
1093: OE_DEBUG_PUB.ADD('Org ID: '|| to_char(l_org_id));
1094: OE_DEBUG_PUB.ADD('Tax Method: '||l_tax_method);
1095: OE_DEBUG_PUB.ADD('Inventory Item Id : '|| to_char(p_line_rec.inventory_item_id));
1096: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||
1097: to_char(p_line_rec.ship_from_org_id));

Line 1094: OE_DEBUG_PUB.ADD('Tax Method: '||l_tax_method);

1090:
1091: END IF;
1092:
1093: OE_DEBUG_PUB.ADD('Org ID: '|| to_char(l_org_id));
1094: OE_DEBUG_PUB.ADD('Tax Method: '||l_tax_method);
1095: OE_DEBUG_PUB.ADD('Inventory Item Id : '|| to_char(p_line_rec.inventory_item_id));
1096: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||
1097: to_char(p_line_rec.ship_from_org_id));
1098:

Line 1095: OE_DEBUG_PUB.ADD('Inventory Item Id : '|| to_char(p_line_rec.inventory_item_id));

1091: END IF;
1092:
1093: OE_DEBUG_PUB.ADD('Org ID: '|| to_char(l_org_id));
1094: OE_DEBUG_PUB.ADD('Tax Method: '||l_tax_method);
1095: OE_DEBUG_PUB.ADD('Inventory Item Id : '|| to_char(p_line_rec.inventory_item_id));
1096: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||
1097: to_char(p_line_rec.ship_from_org_id));
1098:
1099: IF l_tax_method = 'LTE' THEN

Line 1096: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||

1092:
1093: OE_DEBUG_PUB.ADD('Org ID: '|| to_char(l_org_id));
1094: OE_DEBUG_PUB.ADD('Tax Method: '||l_tax_method);
1095: OE_DEBUG_PUB.ADD('Inventory Item Id : '|| to_char(p_line_rec.inventory_item_id));
1096: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||
1097: to_char(p_line_rec.ship_from_org_id));
1098:
1099: IF l_tax_method = 'LTE' THEN
1100: OE_DEBUG_PUB.ADD('Before Defaulting');

Line 1100: OE_DEBUG_PUB.ADD('Before Defaulting');

1096: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||
1097: to_char(p_line_rec.ship_from_org_id));
1098:
1099: IF l_tax_method = 'LTE' THEN
1100: OE_DEBUG_PUB.ADD('Before Defaulting');
1101: OE_DEBUG_PUB.ADD('-----------------');
1102: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1103: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1104: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);

Line 1101: OE_DEBUG_PUB.ADD('-----------------');

1097: to_char(p_line_rec.ship_from_org_id));
1098:
1099: IF l_tax_method = 'LTE' THEN
1100: OE_DEBUG_PUB.ADD('Before Defaulting');
1101: OE_DEBUG_PUB.ADD('-----------------');
1102: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1103: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1104: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1105: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);

Line 1102: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);

1098:
1099: IF l_tax_method = 'LTE' THEN
1100: OE_DEBUG_PUB.ADD('Before Defaulting');
1101: OE_DEBUG_PUB.ADD('-----------------');
1102: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1103: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1104: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1105: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1106:

Line 1103: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);

1099: IF l_tax_method = 'LTE' THEN
1100: OE_DEBUG_PUB.ADD('Before Defaulting');
1101: OE_DEBUG_PUB.ADD('-----------------');
1102: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1103: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1104: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1105: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1106:
1107: x_line_rec.global_attribute7 :=

Line 1104: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);

1100: OE_DEBUG_PUB.ADD('Before Defaulting');
1101: OE_DEBUG_PUB.ADD('-----------------');
1102: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1103: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1104: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1105: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1106:
1107: x_line_rec.global_attribute7 :=
1108: nvl(x_line_rec.global_attribute7,l_fcc_code);

Line 1105: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);

1101: OE_DEBUG_PUB.ADD('-----------------');
1102: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1103: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1104: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1105: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1106:
1107: x_line_rec.global_attribute7 :=
1108: nvl(x_line_rec.global_attribute7,l_fcc_code);
1109: x_line_rec.global_attribute8 :=

Line 1118: OE_DEBUG_PUB.ADD('After Defaulting');

1114: nvl(x_line_rec.global_attribute6,l_tran_nat);
1115: x_line_rec.global_attribute_category :=
1116: nvl(x_line_rec.global_attribute_category,l_gdf_cat);
1117:
1118: OE_DEBUG_PUB.ADD('After Defaulting');
1119: OE_DEBUG_PUB.ADD('----------------');
1120: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||
1121: to_char(l_inventory_org_id));
1122: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);

Line 1119: OE_DEBUG_PUB.ADD('----------------');

1115: x_line_rec.global_attribute_category :=
1116: nvl(x_line_rec.global_attribute_category,l_gdf_cat);
1117:
1118: OE_DEBUG_PUB.ADD('After Defaulting');
1119: OE_DEBUG_PUB.ADD('----------------');
1120: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||
1121: to_char(l_inventory_org_id));
1122: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1123: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);

Line 1120: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||

1116: nvl(x_line_rec.global_attribute_category,l_gdf_cat);
1117:
1118: OE_DEBUG_PUB.ADD('After Defaulting');
1119: OE_DEBUG_PUB.ADD('----------------');
1120: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||
1121: to_char(l_inventory_org_id));
1122: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1123: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1124: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);

Line 1122: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);

1118: OE_DEBUG_PUB.ADD('After Defaulting');
1119: OE_DEBUG_PUB.ADD('----------------');
1120: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||
1121: to_char(l_inventory_org_id));
1122: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1123: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1124: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1125: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1126: END IF;

Line 1123: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);

1119: OE_DEBUG_PUB.ADD('----------------');
1120: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||
1121: to_char(l_inventory_org_id));
1122: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1123: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1124: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1125: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1126: END IF;
1127:

Line 1124: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);

1120: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||
1121: to_char(l_inventory_org_id));
1122: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1123: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1124: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1125: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1126: END IF;
1127:
1128: END IF;

Line 1125: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);

1121: to_char(l_inventory_org_id));
1122: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1123: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1124: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1125: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1126: END IF;
1127:
1128: END IF;
1129:

Line 1228: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Global Attributes');

1224: WHERE mtl.organization_id = l_inventory_org_id
1225: AND mtl.inventory_item_id = x_line_rec.inventory_item_id;
1226: EXCEPTION
1227: WHEN OTHERS THEN
1228: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Global Attributes');
1229: l_tran_nat := NULL;
1230: END;
1231: ELSE
1232:

Line 1243: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Global Attributes');

1239: WHERE mtl.organization_id = l_inventory_org_id
1240: AND mtl.inventory_item_id = x_line_rec.inventory_item_id;
1241: EXCEPTION
1242: WHEN OTHERS THEN
1243: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Global Attributes');
1244: l_tran_nat := NULL;
1245: END;
1246: END IF;
1247: --Bug#6019028: No transaction class for CO as org id is picked from ship_from_org_id

Line 1259: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Transaction Nature');

1255: WHERE mtl.organization_id = l_so_organization_id
1256: AND mtl.inventory_item_id = x_line_rec.inventory_item_id;
1257: EXCEPTION
1258: WHEN OTHERS THEN
1259: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Transaction Nature');
1260: l_tran_nat := NULL;
1261: END;
1262: END IF;
1263:

Line 1292: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Fiscal Classification');

1288: AND org_id = l_org_id
1289: AND enabled_flag = 'Y');
1290: EXCEPTION
1291: WHEN OTHERS THEN
1292: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Fiscal Classification');
1293: l_fcc_code := NULL;
1294:
1295: END;
1296:

Line 1327: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Fiscal Classification');

1323: AND enabled_flag = 'Y')
1324: AND ROWNUM =1;
1325: EXCEPTION
1326: WHEN OTHERS THEN
1327: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Fiscal Classification');
1328: l_fcc_code := NULL;
1329: END;
1330: END IF;
1331:

Line 1344: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Order type Id ');

1340: WHERE header_id = x_line_rec.header_id;
1341:
1342: EXCEPTION
1343: WHEN OTHERS THEN
1344: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Order type Id ');
1345: l_order_type_id := NULL;
1346: END;
1347:
1348: JL_ZZ_OE_LIBRARY_1_PKG.get_global_attribute3 ( l_order_type_id, l_def_value, 1, errcode1 );

Line 1350: OE_DEBUG_PUB.ADD('Org ID: '|| to_char(l_org_id));

1346: END;
1347:
1348: JL_ZZ_OE_LIBRARY_1_PKG.get_global_attribute3 ( l_order_type_id, l_def_value, 1, errcode1 );
1349:
1350: OE_DEBUG_PUB.ADD('Org ID: '|| to_char(l_org_id));
1351: OE_DEBUG_PUB.ADD('Country Code: '|| l_country_code);
1352: OE_DEBUG_PUB.ADD('Tax Method: '||l_tax_method);
1353: OE_DEBUG_PUB.ADD('Inventory Item Id : '|| to_char(x_line_rec.inventory_item_id));
1354: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||

Line 1351: OE_DEBUG_PUB.ADD('Country Code: '|| l_country_code);

1347:
1348: JL_ZZ_OE_LIBRARY_1_PKG.get_global_attribute3 ( l_order_type_id, l_def_value, 1, errcode1 );
1349:
1350: OE_DEBUG_PUB.ADD('Org ID: '|| to_char(l_org_id));
1351: OE_DEBUG_PUB.ADD('Country Code: '|| l_country_code);
1352: OE_DEBUG_PUB.ADD('Tax Method: '||l_tax_method);
1353: OE_DEBUG_PUB.ADD('Inventory Item Id : '|| to_char(x_line_rec.inventory_item_id));
1354: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||
1355: to_char(x_line_rec.ship_from_org_id));

Line 1352: OE_DEBUG_PUB.ADD('Tax Method: '||l_tax_method);

1348: JL_ZZ_OE_LIBRARY_1_PKG.get_global_attribute3 ( l_order_type_id, l_def_value, 1, errcode1 );
1349:
1350: OE_DEBUG_PUB.ADD('Org ID: '|| to_char(l_org_id));
1351: OE_DEBUG_PUB.ADD('Country Code: '|| l_country_code);
1352: OE_DEBUG_PUB.ADD('Tax Method: '||l_tax_method);
1353: OE_DEBUG_PUB.ADD('Inventory Item Id : '|| to_char(x_line_rec.inventory_item_id));
1354: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||
1355: to_char(x_line_rec.ship_from_org_id));
1356:

Line 1353: OE_DEBUG_PUB.ADD('Inventory Item Id : '|| to_char(x_line_rec.inventory_item_id));

1349:
1350: OE_DEBUG_PUB.ADD('Org ID: '|| to_char(l_org_id));
1351: OE_DEBUG_PUB.ADD('Country Code: '|| l_country_code);
1352: OE_DEBUG_PUB.ADD('Tax Method: '||l_tax_method);
1353: OE_DEBUG_PUB.ADD('Inventory Item Id : '|| to_char(x_line_rec.inventory_item_id));
1354: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||
1355: to_char(x_line_rec.ship_from_org_id));
1356:
1357: OE_DEBUG_PUB.ADD('Order Type Id : '|| l_order_type_id);

Line 1354: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||

1350: OE_DEBUG_PUB.ADD('Org ID: '|| to_char(l_org_id));
1351: OE_DEBUG_PUB.ADD('Country Code: '|| l_country_code);
1352: OE_DEBUG_PUB.ADD('Tax Method: '||l_tax_method);
1353: OE_DEBUG_PUB.ADD('Inventory Item Id : '|| to_char(x_line_rec.inventory_item_id));
1354: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||
1355: to_char(x_line_rec.ship_from_org_id));
1356:
1357: OE_DEBUG_PUB.ADD('Order Type Id : '|| l_order_type_id);
1358: IF l_tax_method = 'LTE' THEN

Line 1357: OE_DEBUG_PUB.ADD('Order Type Id : '|| l_order_type_id);

1353: OE_DEBUG_PUB.ADD('Inventory Item Id : '|| to_char(x_line_rec.inventory_item_id));
1354: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||
1355: to_char(x_line_rec.ship_from_org_id));
1356:
1357: OE_DEBUG_PUB.ADD('Order Type Id : '|| l_order_type_id);
1358: IF l_tax_method = 'LTE' THEN
1359: OE_DEBUG_PUB.ADD('Before Defaulting');
1360: OE_DEBUG_PUB.ADD('-----------------');
1361: OE_DEBUG_PUB.ADD('GA1: '|| x_line_rec.global_attribute1);

Line 1359: OE_DEBUG_PUB.ADD('Before Defaulting');

1355: to_char(x_line_rec.ship_from_org_id));
1356:
1357: OE_DEBUG_PUB.ADD('Order Type Id : '|| l_order_type_id);
1358: IF l_tax_method = 'LTE' THEN
1359: OE_DEBUG_PUB.ADD('Before Defaulting');
1360: OE_DEBUG_PUB.ADD('-----------------');
1361: OE_DEBUG_PUB.ADD('GA1: '|| x_line_rec.global_attribute1);
1362: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1363: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);

Line 1360: OE_DEBUG_PUB.ADD('-----------------');

1356:
1357: OE_DEBUG_PUB.ADD('Order Type Id : '|| l_order_type_id);
1358: IF l_tax_method = 'LTE' THEN
1359: OE_DEBUG_PUB.ADD('Before Defaulting');
1360: OE_DEBUG_PUB.ADD('-----------------');
1361: OE_DEBUG_PUB.ADD('GA1: '|| x_line_rec.global_attribute1);
1362: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1363: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1364: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);

Line 1361: OE_DEBUG_PUB.ADD('GA1: '|| x_line_rec.global_attribute1);

1357: OE_DEBUG_PUB.ADD('Order Type Id : '|| l_order_type_id);
1358: IF l_tax_method = 'LTE' THEN
1359: OE_DEBUG_PUB.ADD('Before Defaulting');
1360: OE_DEBUG_PUB.ADD('-----------------');
1361: OE_DEBUG_PUB.ADD('GA1: '|| x_line_rec.global_attribute1);
1362: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1363: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1364: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1365: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);

Line 1362: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);

1358: IF l_tax_method = 'LTE' THEN
1359: OE_DEBUG_PUB.ADD('Before Defaulting');
1360: OE_DEBUG_PUB.ADD('-----------------');
1361: OE_DEBUG_PUB.ADD('GA1: '|| x_line_rec.global_attribute1);
1362: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1363: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1364: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1365: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1366:

Line 1363: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);

1359: OE_DEBUG_PUB.ADD('Before Defaulting');
1360: OE_DEBUG_PUB.ADD('-----------------');
1361: OE_DEBUG_PUB.ADD('GA1: '|| x_line_rec.global_attribute1);
1362: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1363: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1364: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1365: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1366:
1367: x_line_rec.global_attribute7 :=

Line 1364: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);

1360: OE_DEBUG_PUB.ADD('-----------------');
1361: OE_DEBUG_PUB.ADD('GA1: '|| x_line_rec.global_attribute1);
1362: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1363: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1364: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1365: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1366:
1367: x_line_rec.global_attribute7 :=
1368: nvl(x_line_rec.global_attribute7,l_fcc_code);

Line 1365: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);

1361: OE_DEBUG_PUB.ADD('GA1: '|| x_line_rec.global_attribute1);
1362: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1363: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1364: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1365: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1366:
1367: x_line_rec.global_attribute7 :=
1368: nvl(x_line_rec.global_attribute7,l_fcc_code);
1369: x_line_rec.global_attribute8 :=

Line 1397: OE_DEBUG_PUB.ADD('After Defaulting');

1393:
1394: x_line_rec.global_attribute_category :=
1395: nvl(x_line_rec.global_attribute_category,l_gdf_cat);
1396:
1397: OE_DEBUG_PUB.ADD('After Defaulting');
1398: OE_DEBUG_PUB.ADD('----------------');
1399: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||
1400: to_char(l_inventory_org_id));
1401:

Line 1398: OE_DEBUG_PUB.ADD('----------------');

1394: x_line_rec.global_attribute_category :=
1395: nvl(x_line_rec.global_attribute_category,l_gdf_cat);
1396:
1397: OE_DEBUG_PUB.ADD('After Defaulting');
1398: OE_DEBUG_PUB.ADD('----------------');
1399: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||
1400: to_char(l_inventory_org_id));
1401:
1402: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);

Line 1399: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||

1395: nvl(x_line_rec.global_attribute_category,l_gdf_cat);
1396:
1397: OE_DEBUG_PUB.ADD('After Defaulting');
1398: OE_DEBUG_PUB.ADD('----------------');
1399: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||
1400: to_char(l_inventory_org_id));
1401:
1402: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1403: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);

Line 1402: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);

1398: OE_DEBUG_PUB.ADD('----------------');
1399: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||
1400: to_char(l_inventory_org_id));
1401:
1402: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1403: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1404: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1405: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1406: OE_DEBUG_PUB.ADD('GDF attribute Cat: '|| x_line_rec.global_attribute_category);

Line 1403: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);

1399: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||
1400: to_char(l_inventory_org_id));
1401:
1402: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1403: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1404: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1405: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1406: OE_DEBUG_PUB.ADD('GDF attribute Cat: '|| x_line_rec.global_attribute_category);
1407:

Line 1404: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);

1400: to_char(l_inventory_org_id));
1401:
1402: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1403: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1404: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1405: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1406: OE_DEBUG_PUB.ADD('GDF attribute Cat: '|| x_line_rec.global_attribute_category);
1407:
1408: END IF;

Line 1405: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);

1401:
1402: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1403: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1404: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1405: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1406: OE_DEBUG_PUB.ADD('GDF attribute Cat: '|| x_line_rec.global_attribute_category);
1407:
1408: END IF;
1409:

Line 1406: OE_DEBUG_PUB.ADD('GDF attribute Cat: '|| x_line_rec.global_attribute_category);

1402: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1403: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1404: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1405: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1406: OE_DEBUG_PUB.ADD('GDF attribute Cat: '|| x_line_rec.global_attribute_category);
1407:
1408: END IF;
1409:
1410: END IF;