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 122: OE_DEBUG_PUB.ADD('JL-Country Code is ' || l_country_code);

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

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

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

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

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

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

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

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

142: l_line_id := p_interface_line_rec.interface_line_attribute6;
143: l_inventory_item_id := p_interface_line_rec.inventory_item_id;
144:
145: OE_DEBUG_PUB.ADD('JL-Line Id '|| l_line_id);
146: OE_DEBUG_PUB.ADD('JL-Inventory Item Id '|| l_inventory_item_id);
147: OE_DEBUG_PUB.ADD('JL-Line Type '|| p_interface_line_rec.line_type);
148:
149: l_invoice_line_id := NULL;
150: l_order_line_id := NULL;

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

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

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

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

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

170:
171: END IF;
172:
173: OE_DEBUG_PUB.ADD('JL-Invoice Line Id '|| l_invoice_line_id);
174: OE_DEBUG_PUB.ADD('JL-Return Id '|| l_order_line_id);
175:
176: IF (l_invoice_line_id IS NULL AND
177: l_order_line_id IS NULL) THEN
178:

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

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

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

476: END IF; -- Country Code check
477:
478: EXCEPTION
479: WHEN OTHERS THEN
480: OE_DEBUG_PUB.ADD('JL-Exception Others');
481: x_error_buffer := SQLERRM;
482: x_return_code := 2;
483:
484: END copy_gdff;

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

561: l_country_code := SUBSTR(x_interface_line_rec.line_gdf_attr_category,4,2);
562:
563: l_jl := 'JL';
564: --
565: OE_DEBUG_PUB.ADD('JL-Country Code is ' || l_country_code);
566:
567: IF NVL(l_country_code,'$') IN ('BR','AR','CO') THEN
568:
569: l_org_id := mo_global.get_current_org_id;

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

567: IF NVL(l_country_code,'$') IN ('BR','AR','CO') THEN
568:
569: l_org_id := mo_global.get_current_org_id;
570: l_tax_method := JL_ZZ_AR_TX_LIB_PKG.get_tax_method(l_org_id);
571: OE_DEBUG_PUB.ADD('JL-Tax Method is ' || l_tax_method);
572:
573: l_so_organization_id:= to_number(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',l_org_id));
574: OE_DEBUG_PUB.ADD('JL-So Organization id is ' || l_so_organization_id);
575:

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

570: l_tax_method := JL_ZZ_AR_TX_LIB_PKG.get_tax_method(l_org_id);
571: OE_DEBUG_PUB.ADD('JL-Tax Method is ' || l_tax_method);
572:
573: l_so_organization_id:= to_number(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',l_org_id));
574: OE_DEBUG_PUB.ADD('JL-So Organization id is ' || l_so_organization_id);
575:
576: IF l_country_code = 'BR' THEN
577: l_header_attr_category := 'JL.BR.ARXTWMAI.Additional Info';
578: l_line_attr_category := 'JL.BR.ARXTWMAI.Additional Info';

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

585:
586: l_line_id := x_interface_line_rec.interface_line_attribute6;
587: l_inventory_item_id := x_interface_line_rec.inventory_item_id;
588:
589: OE_DEBUG_PUB.ADD('JL-Line Id '|| l_line_id);
590: OE_DEBUG_PUB.ADD('JL-Inventory Item Id '|| l_inventory_item_id);
591: OE_DEBUG_PUB.ADD('JL-Line Type '|| x_interface_line_rec.line_type);
592:
593: l_invoice_line_id := NULL;

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

586: l_line_id := x_interface_line_rec.interface_line_attribute6;
587: l_inventory_item_id := x_interface_line_rec.inventory_item_id;
588:
589: OE_DEBUG_PUB.ADD('JL-Line Id '|| l_line_id);
590: OE_DEBUG_PUB.ADD('JL-Inventory Item Id '|| l_inventory_item_id);
591: OE_DEBUG_PUB.ADD('JL-Line Type '|| x_interface_line_rec.line_type);
592:
593: l_invoice_line_id := NULL;
594: l_order_line_id := NULL;

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

587: l_inventory_item_id := x_interface_line_rec.inventory_item_id;
588:
589: OE_DEBUG_PUB.ADD('JL-Line Id '|| l_line_id);
590: OE_DEBUG_PUB.ADD('JL-Inventory Item Id '|| l_inventory_item_id);
591: OE_DEBUG_PUB.ADD('JL-Line Type '|| x_interface_line_rec.line_type);
592:
593: l_invoice_line_id := NULL;
594: l_order_line_id := NULL;
595: IF l_tax_method = 'LTE' THEN

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

613: END;
614:
615: END IF;
616:
617: OE_DEBUG_PUB.ADD('JL-Invoice Line Id '|| l_invoice_line_id);
618: OE_DEBUG_PUB.ADD('JL-Return Id '|| l_order_line_id);
619:
620: IF (l_invoice_line_id IS NULL AND
621: l_order_line_id IS NULL) THEN

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

614:
615: END IF;
616:
617: OE_DEBUG_PUB.ADD('JL-Invoice Line Id '|| l_invoice_line_id);
618: OE_DEBUG_PUB.ADD('JL-Return Id '|| l_order_line_id);
619:
620: IF (l_invoice_line_id IS NULL AND
621: l_order_line_id IS NULL) THEN
622:

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

641:
642: IF x_interface_line_rec.line_type = 'LINE' THEN
643:
644: BEGIN
645: OE_DEBUG_PUB.ADD('JL-Delivery Name '||
646: x_interface_line_rec.interface_line_attribute3);
647: SELECT del.gross_weight,
648: del.net_weight,
649: del.global_attribute3,

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

920: END IF; -- Country Code check
921:
922: EXCEPTION
923: WHEN OTHERS THEN
924: OE_DEBUG_PUB.ADD('JL-Exception Others');
925: x_error_buffer := SQLERRM;
926: x_return_code := 2;
927:
928: END copy_gdf;

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

1024: WHERE mtl.organization_id = l_inventory_org_id
1025: AND mtl.inventory_item_id = p_line_rec.inventory_item_id;
1026: EXCEPTION
1027: WHEN OTHERS THEN
1028: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Transaction Nature');
1029: l_tran_nat := NULL;
1030: END;
1031:
1032: --Bug#6019028: No transaction class for CO as org id is picked from ship_from_org_id

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

1040: WHERE mtl.organization_id = l_so_organization_id
1041: AND mtl.inventory_item_id = p_line_rec.inventory_item_id;
1042: EXCEPTION
1043: WHEN OTHERS THEN
1044: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Transaction Nature');
1045: l_tran_nat := NULL;
1046: END;
1047: END IF;
1048:

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

1073: AND enabled_flag = 'Y')
1074: AND ROWNUM =1;
1075: EXCEPTION
1076: WHEN OTHERS THEN
1077: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Fiscal Classification');
1078: l_fcc_code := NULL;
1079:
1080: END;
1081:

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

1108: AND enabled_flag = 'Y')
1109: AND ROWNUM =1;
1110: EXCEPTION
1111: WHEN OTHERS THEN
1112: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Fiscal Classification');
1113: l_fcc_code := NULL;
1114: END;
1115: END IF;
1116:

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

1115: END IF;
1116:
1117: END IF;
1118:
1119: OE_DEBUG_PUB.ADD('Org ID: '|| to_char(l_org_id));
1120: OE_DEBUG_PUB.ADD('Tax Method: '||l_tax_method);
1121: OE_DEBUG_PUB.ADD('Inventory Item Id : '|| to_char(p_line_rec.inventory_item_id));
1122: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||
1123: to_char(p_line_rec.ship_from_org_id));

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

1116:
1117: END IF;
1118:
1119: OE_DEBUG_PUB.ADD('Org ID: '|| to_char(l_org_id));
1120: OE_DEBUG_PUB.ADD('Tax Method: '||l_tax_method);
1121: OE_DEBUG_PUB.ADD('Inventory Item Id : '|| to_char(p_line_rec.inventory_item_id));
1122: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||
1123: to_char(p_line_rec.ship_from_org_id));
1124:

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

1117: END IF;
1118:
1119: OE_DEBUG_PUB.ADD('Org ID: '|| to_char(l_org_id));
1120: OE_DEBUG_PUB.ADD('Tax Method: '||l_tax_method);
1121: OE_DEBUG_PUB.ADD('Inventory Item Id : '|| to_char(p_line_rec.inventory_item_id));
1122: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||
1123: to_char(p_line_rec.ship_from_org_id));
1124:
1125: IF l_tax_method = 'LTE' THEN

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

1118:
1119: OE_DEBUG_PUB.ADD('Org ID: '|| to_char(l_org_id));
1120: OE_DEBUG_PUB.ADD('Tax Method: '||l_tax_method);
1121: OE_DEBUG_PUB.ADD('Inventory Item Id : '|| to_char(p_line_rec.inventory_item_id));
1122: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||
1123: to_char(p_line_rec.ship_from_org_id));
1124:
1125: IF l_tax_method = 'LTE' THEN
1126: OE_DEBUG_PUB.ADD('Before Defaulting');

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

1122: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||
1123: to_char(p_line_rec.ship_from_org_id));
1124:
1125: IF l_tax_method = 'LTE' THEN
1126: OE_DEBUG_PUB.ADD('Before Defaulting');
1127: OE_DEBUG_PUB.ADD('-----------------');
1128: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1129: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1130: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);

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

1123: to_char(p_line_rec.ship_from_org_id));
1124:
1125: IF l_tax_method = 'LTE' THEN
1126: OE_DEBUG_PUB.ADD('Before Defaulting');
1127: OE_DEBUG_PUB.ADD('-----------------');
1128: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1129: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1130: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1131: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);

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

1124:
1125: IF l_tax_method = 'LTE' THEN
1126: OE_DEBUG_PUB.ADD('Before Defaulting');
1127: OE_DEBUG_PUB.ADD('-----------------');
1128: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1129: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1130: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1131: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1132:

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

1125: IF l_tax_method = 'LTE' THEN
1126: OE_DEBUG_PUB.ADD('Before Defaulting');
1127: OE_DEBUG_PUB.ADD('-----------------');
1128: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1129: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1130: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1131: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1132:
1133: x_line_rec.global_attribute7 :=

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

1126: OE_DEBUG_PUB.ADD('Before Defaulting');
1127: OE_DEBUG_PUB.ADD('-----------------');
1128: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1129: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1130: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1131: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1132:
1133: x_line_rec.global_attribute7 :=
1134: nvl(x_line_rec.global_attribute7,l_fcc_code);

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

1127: OE_DEBUG_PUB.ADD('-----------------');
1128: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1129: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1130: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1131: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1132:
1133: x_line_rec.global_attribute7 :=
1134: nvl(x_line_rec.global_attribute7,l_fcc_code);
1135: x_line_rec.global_attribute8 :=

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

1140: nvl(x_line_rec.global_attribute6,l_tran_nat);
1141: x_line_rec.global_attribute_category :=
1142: nvl(x_line_rec.global_attribute_category,l_gdf_cat);
1143:
1144: OE_DEBUG_PUB.ADD('After Defaulting');
1145: OE_DEBUG_PUB.ADD('----------------');
1146: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||
1147: to_char(l_inventory_org_id));
1148: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);

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

1141: x_line_rec.global_attribute_category :=
1142: nvl(x_line_rec.global_attribute_category,l_gdf_cat);
1143:
1144: OE_DEBUG_PUB.ADD('After Defaulting');
1145: OE_DEBUG_PUB.ADD('----------------');
1146: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||
1147: to_char(l_inventory_org_id));
1148: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1149: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);

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

1142: nvl(x_line_rec.global_attribute_category,l_gdf_cat);
1143:
1144: OE_DEBUG_PUB.ADD('After Defaulting');
1145: OE_DEBUG_PUB.ADD('----------------');
1146: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||
1147: to_char(l_inventory_org_id));
1148: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1149: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1150: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);

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

1144: OE_DEBUG_PUB.ADD('After Defaulting');
1145: OE_DEBUG_PUB.ADD('----------------');
1146: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||
1147: to_char(l_inventory_org_id));
1148: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1149: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1150: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1151: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1152: END IF;

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

1145: OE_DEBUG_PUB.ADD('----------------');
1146: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||
1147: to_char(l_inventory_org_id));
1148: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1149: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1150: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1151: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1152: END IF;
1153:

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

1146: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||
1147: to_char(l_inventory_org_id));
1148: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1149: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1150: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1151: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1152: END IF;
1153:
1154: END IF;

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

1147: to_char(l_inventory_org_id));
1148: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1149: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1150: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1151: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1152: END IF;
1153:
1154: END IF;
1155:

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

1291: WHERE mtl.organization_id = l_inventory_org_id
1292: AND mtl.inventory_item_id = x_line_rec.inventory_item_id;
1293: EXCEPTION
1294: WHEN OTHERS THEN
1295: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Global Attributes');
1296: l_tran_nat := NULL;
1297: END;
1298: */
1299:

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

1336: WHERE mtl.organization_id = l_inventory_org_id
1337: AND mtl.inventory_item_id = x_line_rec.inventory_item_id;
1338: EXCEPTION
1339: WHEN OTHERS THEN
1340: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Global Attributes');
1341: l_tran_nat := NULL;
1342: END;
1343: END IF;
1344: --Bug#6019028: No transaction class for CO as org id is picked from ship_from_org_id

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

1352: WHERE mtl.organization_id = l_so_organization_id
1353: AND mtl.inventory_item_id = x_line_rec.inventory_item_id;
1354: EXCEPTION
1355: WHEN OTHERS THEN
1356: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Transaction Nature');
1357: l_tran_nat := NULL;
1358: END;
1359: END IF;
1360:

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

1386: AND org_id = l_org_id
1387: AND enabled_flag = 'Y');
1388: EXCEPTION
1389: WHEN OTHERS THEN
1390: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Fiscal Classification');
1391: l_fcc_code := NULL;
1392:
1393: END;
1394:

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

1420: AND enabled_flag = 'Y')
1421: AND ROWNUM =1;
1422: EXCEPTION
1423: WHEN OTHERS THEN
1424: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Fiscal Classification');
1425: l_fcc_code := NULL;
1426: END;
1427: END IF;
1428: */

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

1461: WHERE header_id = x_line_rec.header_id;
1462:
1463: EXCEPTION
1464: WHEN OTHERS THEN
1465: OE_DEBUG_PUB.ADD('EXCEPTION: No Value for Order type Id ');
1466: l_order_type_id := NULL;
1467: END;
1468:
1469: JL_ZZ_OE_LIBRARY_1_PKG.get_global_attribute3 ( l_order_type_id, l_def_value, 1, errcode1 );

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

1467: END;
1468:
1469: JL_ZZ_OE_LIBRARY_1_PKG.get_global_attribute3 ( l_order_type_id, l_def_value, 1, errcode1 );
1470:
1471: OE_DEBUG_PUB.ADD('Org ID: '|| to_char(l_org_id));
1472: OE_DEBUG_PUB.ADD('Country Code: '|| l_country_code);
1473: OE_DEBUG_PUB.ADD('Tax Method: '||l_tax_method);
1474: OE_DEBUG_PUB.ADD('Inventory Item Id : '|| to_char(x_line_rec.inventory_item_id));
1475: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||

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

1468:
1469: JL_ZZ_OE_LIBRARY_1_PKG.get_global_attribute3 ( l_order_type_id, l_def_value, 1, errcode1 );
1470:
1471: OE_DEBUG_PUB.ADD('Org ID: '|| to_char(l_org_id));
1472: OE_DEBUG_PUB.ADD('Country Code: '|| l_country_code);
1473: OE_DEBUG_PUB.ADD('Tax Method: '||l_tax_method);
1474: OE_DEBUG_PUB.ADD('Inventory Item Id : '|| to_char(x_line_rec.inventory_item_id));
1475: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||
1476: to_char(x_line_rec.ship_from_org_id));

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

1469: JL_ZZ_OE_LIBRARY_1_PKG.get_global_attribute3 ( l_order_type_id, l_def_value, 1, errcode1 );
1470:
1471: OE_DEBUG_PUB.ADD('Org ID: '|| to_char(l_org_id));
1472: OE_DEBUG_PUB.ADD('Country Code: '|| l_country_code);
1473: OE_DEBUG_PUB.ADD('Tax Method: '||l_tax_method);
1474: OE_DEBUG_PUB.ADD('Inventory Item Id : '|| to_char(x_line_rec.inventory_item_id));
1475: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||
1476: to_char(x_line_rec.ship_from_org_id));
1477:

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

1470:
1471: OE_DEBUG_PUB.ADD('Org ID: '|| to_char(l_org_id));
1472: OE_DEBUG_PUB.ADD('Country Code: '|| l_country_code);
1473: OE_DEBUG_PUB.ADD('Tax Method: '||l_tax_method);
1474: OE_DEBUG_PUB.ADD('Inventory Item Id : '|| to_char(x_line_rec.inventory_item_id));
1475: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||
1476: to_char(x_line_rec.ship_from_org_id));
1477:
1478: OE_DEBUG_PUB.ADD('Order Type Id : '|| l_order_type_id);

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

1471: OE_DEBUG_PUB.ADD('Org ID: '|| to_char(l_org_id));
1472: OE_DEBUG_PUB.ADD('Country Code: '|| l_country_code);
1473: OE_DEBUG_PUB.ADD('Tax Method: '||l_tax_method);
1474: OE_DEBUG_PUB.ADD('Inventory Item Id : '|| to_char(x_line_rec.inventory_item_id));
1475: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||
1476: to_char(x_line_rec.ship_from_org_id));
1477:
1478: OE_DEBUG_PUB.ADD('Order Type Id : '|| l_order_type_id);
1479: IF l_tax_method = 'LTE' THEN

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

1474: OE_DEBUG_PUB.ADD('Inventory Item Id : '|| to_char(x_line_rec.inventory_item_id));
1475: OE_DEBUG_PUB.ADD('Ship From Inventory Org : '||
1476: to_char(x_line_rec.ship_from_org_id));
1477:
1478: OE_DEBUG_PUB.ADD('Order Type Id : '|| l_order_type_id);
1479: IF l_tax_method = 'LTE' THEN
1480: OE_DEBUG_PUB.ADD('Before Defaulting');
1481: OE_DEBUG_PUB.ADD('-----------------');
1482: OE_DEBUG_PUB.ADD('GA1: '|| x_line_rec.global_attribute1);

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

1476: to_char(x_line_rec.ship_from_org_id));
1477:
1478: OE_DEBUG_PUB.ADD('Order Type Id : '|| l_order_type_id);
1479: IF l_tax_method = 'LTE' THEN
1480: OE_DEBUG_PUB.ADD('Before Defaulting');
1481: OE_DEBUG_PUB.ADD('-----------------');
1482: OE_DEBUG_PUB.ADD('GA1: '|| x_line_rec.global_attribute1);
1483: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1484: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);

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

1477:
1478: OE_DEBUG_PUB.ADD('Order Type Id : '|| l_order_type_id);
1479: IF l_tax_method = 'LTE' THEN
1480: OE_DEBUG_PUB.ADD('Before Defaulting');
1481: OE_DEBUG_PUB.ADD('-----------------');
1482: OE_DEBUG_PUB.ADD('GA1: '|| x_line_rec.global_attribute1);
1483: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1484: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1485: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);

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

1478: OE_DEBUG_PUB.ADD('Order Type Id : '|| l_order_type_id);
1479: IF l_tax_method = 'LTE' THEN
1480: OE_DEBUG_PUB.ADD('Before Defaulting');
1481: OE_DEBUG_PUB.ADD('-----------------');
1482: OE_DEBUG_PUB.ADD('GA1: '|| x_line_rec.global_attribute1);
1483: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1484: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1485: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1486: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);

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

1479: IF l_tax_method = 'LTE' THEN
1480: OE_DEBUG_PUB.ADD('Before Defaulting');
1481: OE_DEBUG_PUB.ADD('-----------------');
1482: OE_DEBUG_PUB.ADD('GA1: '|| x_line_rec.global_attribute1);
1483: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1484: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1485: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1486: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1487:

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

1480: OE_DEBUG_PUB.ADD('Before Defaulting');
1481: OE_DEBUG_PUB.ADD('-----------------');
1482: OE_DEBUG_PUB.ADD('GA1: '|| x_line_rec.global_attribute1);
1483: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1484: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1485: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1486: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1487:
1488: x_line_rec.global_attribute7 :=

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

1481: OE_DEBUG_PUB.ADD('-----------------');
1482: OE_DEBUG_PUB.ADD('GA1: '|| x_line_rec.global_attribute1);
1483: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1484: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1485: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1486: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1487:
1488: x_line_rec.global_attribute7 :=
1489: nvl(x_line_rec.global_attribute7,l_fcc_code);

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

1482: OE_DEBUG_PUB.ADD('GA1: '|| x_line_rec.global_attribute1);
1483: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1484: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1485: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1486: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1487:
1488: x_line_rec.global_attribute7 :=
1489: nvl(x_line_rec.global_attribute7,l_fcc_code);
1490: x_line_rec.global_attribute8 :=

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

1514:
1515: x_line_rec.global_attribute_category :=
1516: nvl(x_line_rec.global_attribute_category,l_gdf_cat);
1517:
1518: OE_DEBUG_PUB.ADD('After Defaulting');
1519: OE_DEBUG_PUB.ADD('----------------');
1520: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||
1521: to_char(l_inventory_org_id));
1522:

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

1515: x_line_rec.global_attribute_category :=
1516: nvl(x_line_rec.global_attribute_category,l_gdf_cat);
1517:
1518: OE_DEBUG_PUB.ADD('After Defaulting');
1519: OE_DEBUG_PUB.ADD('----------------');
1520: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||
1521: to_char(l_inventory_org_id));
1522:
1523: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);

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

1516: nvl(x_line_rec.global_attribute_category,l_gdf_cat);
1517:
1518: OE_DEBUG_PUB.ADD('After Defaulting');
1519: OE_DEBUG_PUB.ADD('----------------');
1520: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||
1521: to_char(l_inventory_org_id));
1522:
1523: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1524: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);

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

1519: OE_DEBUG_PUB.ADD('----------------');
1520: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||
1521: to_char(l_inventory_org_id));
1522:
1523: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1524: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1525: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1526: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1527: OE_DEBUG_PUB.ADD('GDF attribute Cat: '|| x_line_rec.global_attribute_category);

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

1520: OE_DEBUG_PUB.ADD('Default from Inventory Org' ||
1521: to_char(l_inventory_org_id));
1522:
1523: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1524: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1525: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1526: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1527: OE_DEBUG_PUB.ADD('GDF attribute Cat: '|| x_line_rec.global_attribute_category);
1528:

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

1521: to_char(l_inventory_org_id));
1522:
1523: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1524: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1525: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1526: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1527: OE_DEBUG_PUB.ADD('GDF attribute Cat: '|| x_line_rec.global_attribute_category);
1528:
1529: END IF;

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

1522:
1523: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1524: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1525: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1526: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1527: OE_DEBUG_PUB.ADD('GDF attribute Cat: '|| x_line_rec.global_attribute_category);
1528:
1529: END IF;
1530:

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

1523: OE_DEBUG_PUB.ADD('GA5: '|| x_line_rec.global_attribute5);
1524: OE_DEBUG_PUB.ADD('GA6: '|| x_line_rec.global_attribute6);
1525: OE_DEBUG_PUB.ADD('GA7: '|| x_line_rec.global_attribute7);
1526: OE_DEBUG_PUB.ADD('GA8: '|| x_line_rec.global_attribute8);
1527: OE_DEBUG_PUB.ADD('GDF attribute Cat: '|| x_line_rec.global_attribute_category);
1528:
1529: END IF;
1530:
1531: END IF;