95: END IF;
96:
97: -- Validate Required Parameter
98: IF p_line_type_id IS NULL THEN
99: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
100: fnd_message.set_token('GENERIC_TEXT',
101: 'Required Parameter Missing: Transaction Type Id');
102: app_exception.raise_exception;
103: END IF;
96:
97: -- Validate Required Parameter
98: IF p_line_type_id IS NULL THEN
99: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
100: fnd_message.set_token('GENERIC_TEXT',
101: 'Required Parameter Missing: Transaction Type Id');
102: app_exception.raise_exception;
103: END IF;
104:
116: l_global_attribute5,
117: l_global_attribute6);
118:
119: IF l_global_attribute5 IS NULL THEN
120: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
121: fnd_message.set_token('GENERIC_TEXT',
122: 'Required Parameter Missing: Fiscal Classification');
123: app_exception.raise_exception;
124: END IF;
117: l_global_attribute6);
118:
119: IF l_global_attribute5 IS NULL THEN
120: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
121: fnd_message.set_token('GENERIC_TEXT',
122: 'Required Parameter Missing: Fiscal Classification');
123: app_exception.raise_exception;
124: END IF;
125:
123: app_exception.raise_exception;
124: END IF;
125:
126: IF l_global_attribute6 IS NULL THEN
127: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
128: fnd_message.set_token('GENERIC_TEXT',
129: 'Required Parameter Missing: Transaction Condition Class');
130: app_exception.raise_exception;
131: END IF;
124: END IF;
125:
126: IF l_global_attribute6 IS NULL THEN
127: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
128: fnd_message.set_token('GENERIC_TEXT',
129: 'Required Parameter Missing: Transaction Condition Class');
130: app_exception.raise_exception;
131: END IF;
132: IF (g_level_statement >= g_current_runtime_level ) THEN
196: WHERE INV_TYPE.CUST_TRX_TYPE_ID =
197: FND_PROFILE.VALUE('OE_INVOICE_TRANSACTION_TYPE_ID');
198: EXCEPTION
199: WHEN NO_DATA_FOUND THEN
200: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
201: fnd_message.set_token('GENERIC_TEXT',
202: 'EXCEPTION(NO_DATA_FOUND) : Customer Trx Type Id');
203: app_exception.raise_exception;
204: END; -- End fetch for Profile Level
197: FND_PROFILE.VALUE('OE_INVOICE_TRANSACTION_TYPE_ID');
198: EXCEPTION
199: WHEN NO_DATA_FOUND THEN
200: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
201: fnd_message.set_token('GENERIC_TEXT',
202: 'EXCEPTION(NO_DATA_FOUND) : Customer Trx Type Id');
203: app_exception.raise_exception;
204: END; -- End fetch for Profile Level
205: END; -- End fetch for order_type_id passed in line_type_id
205: END; -- End fetch for order_type_id passed in line_type_id
206: END; -- End fetch for Order Level
207:
208: WHEN OTHERS THEN
209: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
210: fnd_message.set_token('GENERIC_TEXT',
211: 'EXCEPTION(OTHERS) : Customer Trx Type Id : ' || sqlerrm);
212: app_exception.raise_exception;
213: END;
206: END; -- End fetch for Order Level
207:
208: WHEN OTHERS THEN
209: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
210: fnd_message.set_token('GENERIC_TEXT',
211: 'EXCEPTION(OTHERS) : Customer Trx Type Id : ' || sqlerrm);
212: app_exception.raise_exception;
213: END;
214:
256: WHERE nvl(sys.org_id,-99) = nvl(p_org_id,-99); --Bugfix 2367111;
257:
258: EXCEPTION
259: WHEN NO_DATA_FOUND THEN
260: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
261: fnd_message.set_token('GENERIC_TEXT',
262: 'EXCEPTION(NO_DATA_FOUND) : System Options');
263: app_exception.raise_exception;
264:
257:
258: EXCEPTION
259: WHEN NO_DATA_FOUND THEN
260: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
261: fnd_message.set_token('GENERIC_TEXT',
262: 'EXCEPTION(NO_DATA_FOUND) : System Options');
263: app_exception.raise_exception;
264:
265: WHEN OTHERS THEN
262: 'EXCEPTION(NO_DATA_FOUND) : System Options');
263: app_exception.raise_exception;
264:
265: WHEN OTHERS THEN
266: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
267: fnd_message.set_token('GENERIC_TEXT',
268: 'EXCEPTION(OTHERS) : System Options : ' || sqlerrm);
269: app_exception.raise_exception;
270: END;
263: app_exception.raise_exception;
264:
265: WHEN OTHERS THEN
266: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
267: fnd_message.set_token('GENERIC_TEXT',
268: 'EXCEPTION(OTHERS) : System Options : ' || sqlerrm);
269: app_exception.raise_exception;
270: END;
271:
289: NVL(p_invoice_to_org_id,
290: OE_PROFILE.VALUE('SO_ORGANIZATION_ID')));
291: EXCEPTION
292: WHEN NO_DATA_FOUND THEN
293: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
294: fnd_message.set_token('GENERIC_TEXT',
295: 'EXCEPTION(NO_DATA_FOUND) : Organization Class');
296: app_exception.raise_exception;
297:
290: OE_PROFILE.VALUE('SO_ORGANIZATION_ID')));
291: EXCEPTION
292: WHEN NO_DATA_FOUND THEN
293: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
294: fnd_message.set_token('GENERIC_TEXT',
295: 'EXCEPTION(NO_DATA_FOUND) : Organization Class');
296: app_exception.raise_exception;
297:
298: WHEN OTHERS THEN
295: 'EXCEPTION(NO_DATA_FOUND) : Organization Class');
296: app_exception.raise_exception;
297:
298: WHEN OTHERS THEN
299: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
300: fnd_message.set_token('GENERIC_TEXT',
301: 'EXCEPTION(OTHERS) : Organization Class : ' || sqlerrm);
302: app_exception.raise_exception;
303: END;
296: app_exception.raise_exception;
297:
298: WHEN OTHERS THEN
299: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
300: fnd_message.set_token('GENERIC_TEXT',
301: 'EXCEPTION(OTHERS) : Organization Class : ' || sqlerrm);
302: app_exception.raise_exception;
303: END;
304:
306: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10 := l_org_class;
307:
308: -- Validate Tax Code
309: IF p_tax_code IS NULL THEN
310: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
311: fnd_message.set_token('GENERIC_TEXT',
312: 'Required Parameter Missing: Tax Code');
313: app_exception.raise_exception;
314: END IF;
307:
308: -- Validate Tax Code
309: IF p_tax_code IS NULL THEN
310: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
311: fnd_message.set_token('GENERIC_TEXT',
312: 'Required Parameter Missing: Tax Code');
313: app_exception.raise_exception;
314: END IF;
315:
344: AND NVL(vat.tax_class,'O') = 'O'
345: AND NVL(vat.org_id,-99) = nvl(l_org_id,99); --Bugfix 2367111
346: EXCEPTION
347: WHEN NO_DATA_FOUND THEN
348: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
349: fnd_message.set_token('GENERIC_TEXT',
350: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
351: app_exception.raise_exception;
352:
345: AND NVL(vat.org_id,-99) = nvl(l_org_id,99); --Bugfix 2367111
346: EXCEPTION
347: WHEN NO_DATA_FOUND THEN
348: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
349: fnd_message.set_token('GENERIC_TEXT',
350: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
351: app_exception.raise_exception;
352:
353: WHEN OTHERS THEN
350: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
351: app_exception.raise_exception;
352:
353: WHEN OTHERS THEN
354: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
355: fnd_message.set_token('GENERIC_TEXT',
356: 'EXCEPTION(OTHERS) : Tax Code : ' || sqlerrm);
357: app_exception.raise_exception;
358: END;
351: app_exception.raise_exception;
352:
353: WHEN OTHERS THEN
354: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
355: fnd_message.set_token('GENERIC_TEXT',
356: 'EXCEPTION(OTHERS) : Tax Code : ' || sqlerrm);
357: app_exception.raise_exception;
358: END;
359:
567: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.populate_ship_bill2 ()+');
568: END IF;
569:
570: IF p_bill_to_site_use_id IS NULL THEN
571: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
572: fnd_message.set_token('GENERIC_TEXT',
573: 'Required Parameter Missing: Bill To Site Use Id');
574: app_exception.raise_exception;
575: END IF;
568: END IF;
569:
570: IF p_bill_to_site_use_id IS NULL THEN
571: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
572: fnd_message.set_token('GENERIC_TEXT',
573: 'Required Parameter Missing: Bill To Site Use Id');
574: app_exception.raise_exception;
575: END IF;
576:
619: bill_rec.tax_header_level_flag;
620: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule := bill_rec.tax_rounding_rule;
621:
622: IF bill_rec.customer_id IS NULL THEN
623: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
624: fnd_message.set_token('GENERIC_TEXT',
625: 'Required Parameter Missing: Bill To Customer Id');
626: app_exception.raise_exception;
627: END IF;
620: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule := bill_rec.tax_rounding_rule;
621:
622: IF bill_rec.customer_id IS NULL THEN
623: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
624: fnd_message.set_token('GENERIC_TEXT',
625: 'Required Parameter Missing: Bill To Customer Id');
626: app_exception.raise_exception;
627: END IF;
628: EXIT;
1000: WHERE ml.memo_line_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id
1001: AND nvl(ml.org_id,-99) = nvl(l_org_id,-99); --Bugfix 2367111
1002: EXCEPTION
1003: WHEN NO_DATA_FOUND THEN
1004: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1005: fnd_message.set_token('GENERIC_TEXT',
1006: 'EXCEPTION(NO_DATA_FOUND) : Memo Line');
1007: app_exception.raise_exception;
1008:
1001: AND nvl(ml.org_id,-99) = nvl(l_org_id,-99); --Bugfix 2367111
1002: EXCEPTION
1003: WHEN NO_DATA_FOUND THEN
1004: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1005: fnd_message.set_token('GENERIC_TEXT',
1006: 'EXCEPTION(NO_DATA_FOUND) : Memo Line');
1007: app_exception.raise_exception;
1008:
1009: WHEN OTHERS THEN
1006: 'EXCEPTION(NO_DATA_FOUND) : Memo Line');
1007: app_exception.raise_exception;
1008:
1009: WHEN OTHERS THEN
1010: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1011: fnd_message.set_token('GENERIC_TEXT',
1012: 'EXCEPTION(OTHERS) : Memo Line : ' || sqlerrm);
1013: app_exception.raise_exception;
1014: END;
1007: app_exception.raise_exception;
1008:
1009: WHEN OTHERS THEN
1010: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1011: fnd_message.set_token('GENERIC_TEXT',
1012: 'EXCEPTION(OTHERS) : Memo Line : ' || sqlerrm);
1013: app_exception.raise_exception;
1014: END;
1015:
1013: app_exception.raise_exception;
1014: END;
1015:
1016: IF l_line_type <> 'LINE' THEN
1017: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1018: fnd_message.set_token('GENERIC_TEXT',
1019: 'Memo Line Type is not LINE');
1020: app_exception.raise_exception;
1021: END IF;
1014: END;
1015:
1016: IF l_line_type <> 'LINE' THEN
1017: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1018: fnd_message.set_token('GENERIC_TEXT',
1019: 'Memo Line Type is not LINE');
1020: app_exception.raise_exception;
1021: END IF;
1022: END IF;
1063: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7 = 'TAX_GROUP' THEN
1064:
1065: -- Validate Required Parameters
1066: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date IS NULL THEN
1067: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1068: fnd_message.set_token('GENERIC_TEXT',
1069: 'Required Parameter Missing: Transaction Date');
1070: app_exception.raise_exception;
1071: END IF;
1064:
1065: -- Validate Required Parameters
1066: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date IS NULL THEN
1067: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1068: fnd_message.set_token('GENERIC_TEXT',
1069: 'Required Parameter Missing: Transaction Date');
1070: app_exception.raise_exception;
1071: END IF;
1072:
1070: app_exception.raise_exception;
1071: END IF;
1072:
1073: IF ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id IS NULL THEN
1074: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1075: fnd_message.set_token('GENERIC_TEXT',
1076: 'Required Parameter Missing: Set Of Books Id');
1077: app_exception.raise_exception;
1078: END IF;
1071: END IF;
1072:
1073: IF ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id IS NULL THEN
1074: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1075: fnd_message.set_token('GENERIC_TEXT',
1076: 'Required Parameter Missing: Set Of Books Id');
1077: app_exception.raise_exception;
1078: END IF;
1079:
1077: app_exception.raise_exception;
1078: END IF;
1079:
1080: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1 IS NULL THEN
1081: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1082: fnd_message.set_token('GENERIC_TEXT',
1083: 'Required Parameter Missing: Tax Rule Set');
1084: app_exception.raise_exception;
1085: END IF;
1078: END IF;
1079:
1080: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1 IS NULL THEN
1081: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1082: fnd_message.set_token('GENERIC_TEXT',
1083: 'Required Parameter Missing: Tax Rule Set');
1084: app_exception.raise_exception;
1085: END IF;
1086:
1084: app_exception.raise_exception;
1085: END IF;
1086:
1087: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 IS NULL THEN
1088: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1089: fnd_message.set_token('GENERIC_TEXT',
1090: 'Required Parameter Missing: Contributor Condition Class ');
1091: app_exception.raise_exception;
1092: END IF;
1085: END IF;
1086:
1087: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 IS NULL THEN
1088: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1089: fnd_message.set_token('GENERIC_TEXT',
1090: 'Required Parameter Missing: Contributor Condition Class ');
1091: app_exception.raise_exception;
1092: END IF;
1093:
1091: app_exception.raise_exception;
1092: END IF;
1093:
1094: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9 IS NULL THEN
1095: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1096: fnd_message.set_token('GENERIC_TEXT',
1097: 'Required Parameter Missing: Transaction Condition Class');
1098: app_exception.raise_exception;
1099: END IF;
1092: END IF;
1093:
1094: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9 IS NULL THEN
1095: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1096: fnd_message.set_token('GENERIC_TEXT',
1097: 'Required Parameter Missing: Transaction Condition Class');
1098: app_exception.raise_exception;
1099: END IF;
1100:
1098: app_exception.raise_exception;
1099: END IF;
1100:
1101: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10 IS NULL THEN
1102: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1103: fnd_message.set_token('GENERIC_TEXT',
1104: 'Required Parameter Missing: Organization Condition Class');
1105: app_exception.raise_exception;
1106: END IF;
1099: END IF;
1100:
1101: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10 IS NULL THEN
1102: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1103: fnd_message.set_token('GENERIC_TEXT',
1104: 'Required Parameter Missing: Organization Condition Class');
1105: app_exception.raise_exception;
1106: END IF;
1107:
1105: app_exception.raise_exception;
1106: END IF;
1107:
1108: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2 IS NULL THEN
1109: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1110: fnd_message.set_token('GENERIC_TEXT',
1111: 'Required Parameter Missing: Group Tax Id');
1112: app_exception.raise_exception;
1113: END IF;
1106: END IF;
1107:
1108: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2 IS NULL THEN
1109: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1110: fnd_message.set_token('GENERIC_TEXT',
1111: 'Required Parameter Missing: Group Tax Id');
1112: app_exception.raise_exception;
1113: END IF;
1114:
1112: app_exception.raise_exception;
1113: END IF;
1114:
1115: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8 IS NULL THEN
1116: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1117: fnd_message.set_token('GENERIC_TEXT',
1118: 'Required Parameter Missing: Customer Account Site Id');
1119: app_exception.raise_exception;
1120: END IF;
1113: END IF;
1114:
1115: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8 IS NULL THEN
1116: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1117: fnd_message.set_token('GENERIC_TEXT',
1118: 'Required Parameter Missing: Customer Account Site Id');
1119: app_exception.raise_exception;
1120: END IF;
1121:
1470: || ' does not match with values of Class Code: '
1471: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
1472: END IF;
1473:
1474: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_TC');
1475: fnd_message.set_token('CATEGORY',
1476: c_tax_categ_rec.tax_category);
1477: fnd_message.set_token('TC_CODE',
1478: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
1471: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
1472: END IF;
1473:
1474: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_TC');
1475: fnd_message.set_token('CATEGORY',
1476: c_tax_categ_rec.tax_category);
1477: fnd_message.set_token('TC_CODE',
1478: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
1479: fnd_message.set_token('GROUP',
1473:
1474: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_TC');
1475: fnd_message.set_token('CATEGORY',
1476: c_tax_categ_rec.tax_category);
1477: fnd_message.set_token('TC_CODE',
1478: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
1479: fnd_message.set_token('GROUP',
1480: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
1481:
1475: fnd_message.set_token('CATEGORY',
1476: c_tax_categ_rec.tax_category);
1477: fnd_message.set_token('TC_CODE',
1478: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
1479: fnd_message.set_token('GROUP',
1480: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
1481:
1482: ZX_API_PUB.add_msg(
1483: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1520: || c_tax_categ_rec.tax_category
1521: || ' does not match with values of Class Code: '
1522: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
1523: END IF;
1524: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_OC');
1525: fnd_message.set_token('CATEGORY',
1526: c_tax_categ_rec.tax_category);
1527: fnd_message.set_token('OC_CODE',
1528: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
1521: || ' does not match with values of Class Code: '
1522: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
1523: END IF;
1524: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_OC');
1525: fnd_message.set_token('CATEGORY',
1526: c_tax_categ_rec.tax_category);
1527: fnd_message.set_token('OC_CODE',
1528: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
1529: fnd_message.set_token('GROUP',
1523: END IF;
1524: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_OC');
1525: fnd_message.set_token('CATEGORY',
1526: c_tax_categ_rec.tax_category);
1527: fnd_message.set_token('OC_CODE',
1528: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
1529: fnd_message.set_token('GROUP',
1530: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
1531:
1525: fnd_message.set_token('CATEGORY',
1526: c_tax_categ_rec.tax_category);
1527: fnd_message.set_token('OC_CODE',
1528: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
1529: fnd_message.set_token('GROUP',
1530: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
1531:
1532: ZX_API_PUB.add_msg(
1533: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1583: || c_tax_categ_rec.tax_category
1584: || ' does not match with values of Class Code: '
1585: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
1586: END IF;
1587: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_CC');
1588: fnd_message.set_token('CATEGORY',
1589: c_tax_categ_rec.tax_category);
1590: fnd_message.set_token('CC_CODE',
1591: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
1584: || ' does not match with values of Class Code: '
1585: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
1586: END IF;
1587: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_CC');
1588: fnd_message.set_token('CATEGORY',
1589: c_tax_categ_rec.tax_category);
1590: fnd_message.set_token('CC_CODE',
1591: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
1592: fnd_message.set_token('GROUP',
1586: END IF;
1587: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_CC');
1588: fnd_message.set_token('CATEGORY',
1589: c_tax_categ_rec.tax_category);
1590: fnd_message.set_token('CC_CODE',
1591: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
1592: fnd_message.set_token('GROUP',
1593: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
1594:
1588: fnd_message.set_token('CATEGORY',
1589: c_tax_categ_rec.tax_category);
1590: fnd_message.set_token('CC_CODE',
1591: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
1592: fnd_message.set_token('GROUP',
1593: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
1594:
1595: ZX_API_PUB.add_msg(
1596: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1611: END;
1612: IF (g_level_statement >= g_current_runtime_level ) THEN
1613: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','expand_group_tax_code ()-');
1614: END IF;
1615: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1616: fnd_message.set_token('GENERIC_TEXT',
1617: 'Could not expand tax group successfully');
1618: app_exception.raise_exception;
1619: END IF;
1612: IF (g_level_statement >= g_current_runtime_level ) THEN
1613: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','expand_group_tax_code ()-');
1614: END IF;
1615: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1616: fnd_message.set_token('GENERIC_TEXT',
1617: 'Could not expand tax group successfully');
1618: app_exception.raise_exception;
1619: END IF;
1620: ELSE