DBA Data[Home] [Help]

APPS.JL_ZZ_TAX_INTEGRATION_PKG dependencies on FND_MESSAGE

Line 99: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

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: g_jl_exception_type := 'E';
103: app_exception.raise_exception;

Line 100: fnd_message.set_token('GENERIC_TEXT',

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: g_jl_exception_type := 'E';
103: app_exception.raise_exception;
104: END IF;

Line 121: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

117: l_global_attribute5,
118: l_global_attribute6);
119:
120: IF l_global_attribute5 IS NULL THEN
121: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
122: fnd_message.set_token('GENERIC_TEXT',
123: 'Required Parameter Missing: Fiscal Classification');
124: app_exception.raise_exception;
125: END IF;

Line 122: fnd_message.set_token('GENERIC_TEXT',

118: l_global_attribute6);
119:
120: IF l_global_attribute5 IS NULL THEN
121: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
122: fnd_message.set_token('GENERIC_TEXT',
123: 'Required Parameter Missing: Fiscal Classification');
124: app_exception.raise_exception;
125: END IF;
126:

Line 128: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

124: app_exception.raise_exception;
125: END IF;
126:
127: IF l_global_attribute6 IS NULL THEN
128: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
129: fnd_message.set_token('GENERIC_TEXT',
130: 'Required Parameter Missing: Transaction Condition Class');
131: app_exception.raise_exception;
132: END IF;

Line 129: fnd_message.set_token('GENERIC_TEXT',

125: END IF;
126:
127: IF l_global_attribute6 IS NULL THEN
128: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
129: fnd_message.set_token('GENERIC_TEXT',
130: 'Required Parameter Missing: Transaction Condition Class');
131: app_exception.raise_exception;
132: END IF;
133: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 201: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

197: WHERE INV_TYPE.CUST_TRX_TYPE_ID =
198: FND_PROFILE.VALUE('OE_INVOICE_TRANSACTION_TYPE_ID');
199: EXCEPTION
200: WHEN NO_DATA_FOUND THEN
201: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
202: fnd_message.set_token('GENERIC_TEXT',
203: 'EXCEPTION(NO_DATA_FOUND) : Customer Trx Type Id');
204: g_jl_exception_type := 'E';
205: app_exception.raise_exception;

Line 202: fnd_message.set_token('GENERIC_TEXT',

198: FND_PROFILE.VALUE('OE_INVOICE_TRANSACTION_TYPE_ID');
199: EXCEPTION
200: WHEN NO_DATA_FOUND THEN
201: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
202: fnd_message.set_token('GENERIC_TEXT',
203: 'EXCEPTION(NO_DATA_FOUND) : Customer Trx Type Id');
204: g_jl_exception_type := 'E';
205: app_exception.raise_exception;
206: END; -- End fetch for Profile Level

Line 211: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

207: END; -- End fetch for order_type_id passed in line_type_id
208: END; -- End fetch for Order Level
209:
210: WHEN OTHERS THEN
211: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
212: fnd_message.set_token('GENERIC_TEXT',
213: 'EXCEPTION(OTHERS) : Customer Trx Type Id : ' || sqlerrm);
214: g_jl_exception_type := 'E';
215: app_exception.raise_exception;

Line 212: fnd_message.set_token('GENERIC_TEXT',

208: END; -- End fetch for Order Level
209:
210: WHEN OTHERS THEN
211: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
212: fnd_message.set_token('GENERIC_TEXT',
213: 'EXCEPTION(OTHERS) : Customer Trx Type Id : ' || sqlerrm);
214: g_jl_exception_type := 'E';
215: app_exception.raise_exception;
216: END;

Line 263: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

259: WHERE nvl(sys.org_id,-99) = nvl(p_org_id,-99); --Bugfix 2367111;
260:
261: EXCEPTION
262: WHEN NO_DATA_FOUND THEN
263: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
264: fnd_message.set_token('GENERIC_TEXT',
265: 'EXCEPTION(NO_DATA_FOUND) : System Options');
266: g_jl_exception_type := 'E';
267: app_exception.raise_exception;

Line 264: fnd_message.set_token('GENERIC_TEXT',

260:
261: EXCEPTION
262: WHEN NO_DATA_FOUND THEN
263: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
264: fnd_message.set_token('GENERIC_TEXT',
265: 'EXCEPTION(NO_DATA_FOUND) : System Options');
266: g_jl_exception_type := 'E';
267: app_exception.raise_exception;
268:

Line 270: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

266: g_jl_exception_type := 'E';
267: app_exception.raise_exception;
268:
269: WHEN OTHERS THEN
270: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
271: fnd_message.set_token('GENERIC_TEXT',
272: 'EXCEPTION(OTHERS) : System Options : ' || sqlerrm);
273: g_jl_exception_type := 'E';
274: app_exception.raise_exception;

Line 271: fnd_message.set_token('GENERIC_TEXT',

267: app_exception.raise_exception;
268:
269: WHEN OTHERS THEN
270: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
271: fnd_message.set_token('GENERIC_TEXT',
272: 'EXCEPTION(OTHERS) : System Options : ' || sqlerrm);
273: g_jl_exception_type := 'E';
274: app_exception.raise_exception;
275: END;

Line 298: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

294: NVL(p_invoice_to_org_id,
295: OE_PROFILE.VALUE('SO_ORGANIZATION_ID')));
296: EXCEPTION
297: WHEN NO_DATA_FOUND THEN
298: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
299: fnd_message.set_token('GENERIC_TEXT',
300: 'EXCEPTION(NO_DATA_FOUND) : Organization Class');
301: g_jl_exception_type := 'E';
302: app_exception.raise_exception;

Line 299: fnd_message.set_token('GENERIC_TEXT',

295: OE_PROFILE.VALUE('SO_ORGANIZATION_ID')));
296: EXCEPTION
297: WHEN NO_DATA_FOUND THEN
298: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
299: fnd_message.set_token('GENERIC_TEXT',
300: 'EXCEPTION(NO_DATA_FOUND) : Organization Class');
301: g_jl_exception_type := 'E';
302: app_exception.raise_exception;
303:

Line 305: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

301: g_jl_exception_type := 'E';
302: app_exception.raise_exception;
303:
304: WHEN OTHERS THEN
305: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
306: fnd_message.set_token('GENERIC_TEXT',
307: 'EXCEPTION(OTHERS) : Organization Class : ' || sqlerrm);
308: g_jl_exception_type := 'E';
309: app_exception.raise_exception;

Line 306: fnd_message.set_token('GENERIC_TEXT',

302: app_exception.raise_exception;
303:
304: WHEN OTHERS THEN
305: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
306: fnd_message.set_token('GENERIC_TEXT',
307: 'EXCEPTION(OTHERS) : Organization Class : ' || sqlerrm);
308: g_jl_exception_type := 'E';
309: app_exception.raise_exception;
310: END;

Line 317: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

313: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10 := l_org_class;
314:
315: -- Validate Tax Code
316: IF p_tax_code IS NULL THEN
317: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
318: fnd_message.set_token('GENERIC_TEXT',
319: 'Required Parameter Missing: Tax Code');
320: g_jl_exception_type := 'E';
321: app_exception.raise_exception;

Line 318: fnd_message.set_token('GENERIC_TEXT',

314:
315: -- Validate Tax Code
316: IF p_tax_code IS NULL THEN
317: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
318: fnd_message.set_token('GENERIC_TEXT',
319: 'Required Parameter Missing: Tax Code');
320: g_jl_exception_type := 'E';
321: app_exception.raise_exception;
322: END IF;

Line 356: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

352: AND NVL(vat.tax_class,'O') = 'O'
353: AND NVL(vat.org_id,-99) = nvl(l_org_id,99); --Bugfix 2367111
354: EXCEPTION
355: WHEN NO_DATA_FOUND THEN
356: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
357: fnd_message.set_token('GENERIC_TEXT',
358: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
359: g_jl_exception_type := 'E';
360: app_exception.raise_exception;

Line 357: fnd_message.set_token('GENERIC_TEXT',

353: AND NVL(vat.org_id,-99) = nvl(l_org_id,99); --Bugfix 2367111
354: EXCEPTION
355: WHEN NO_DATA_FOUND THEN
356: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
357: fnd_message.set_token('GENERIC_TEXT',
358: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
359: g_jl_exception_type := 'E';
360: app_exception.raise_exception;
361:

Line 363: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

359: g_jl_exception_type := 'E';
360: app_exception.raise_exception;
361:
362: WHEN OTHERS THEN
363: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
364: fnd_message.set_token('GENERIC_TEXT',
365: 'EXCEPTION(OTHERS) : Tax Code : ' || sqlerrm);
366: g_jl_exception_type := 'E';
367: app_exception.raise_exception;

Line 364: fnd_message.set_token('GENERIC_TEXT',

360: app_exception.raise_exception;
361:
362: WHEN OTHERS THEN
363: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
364: fnd_message.set_token('GENERIC_TEXT',
365: 'EXCEPTION(OTHERS) : Tax Code : ' || sqlerrm);
366: g_jl_exception_type := 'E';
367: app_exception.raise_exception;
368: END;

Line 581: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

577: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','JL_ZZ_TAX_INTEGRATION_PKG.populate_ship_bill2 ()+');
578: END IF;
579:
580: IF p_bill_to_site_use_id IS NULL THEN
581: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
582: fnd_message.set_token('GENERIC_TEXT',
583: 'Required Parameter Missing: Bill To Site Use Id');
584: g_jl_exception_type := 'E';
585: app_exception.raise_exception;

Line 582: fnd_message.set_token('GENERIC_TEXT',

578: END IF;
579:
580: IF p_bill_to_site_use_id IS NULL THEN
581: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
582: fnd_message.set_token('GENERIC_TEXT',
583: 'Required Parameter Missing: Bill To Site Use Id');
584: g_jl_exception_type := 'E';
585: app_exception.raise_exception;
586: END IF;

Line 634: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

630: bill_rec.tax_header_level_flag;
631: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule := bill_rec.tax_rounding_rule;
632:
633: IF bill_rec.customer_id IS NULL THEN
634: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
635: fnd_message.set_token('GENERIC_TEXT',
636: 'Required Parameter Missing: Bill To Customer Id');
637: g_jl_exception_type := 'E';
638: app_exception.raise_exception;

Line 635: fnd_message.set_token('GENERIC_TEXT',

631: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_rounding_rule := bill_rec.tax_rounding_rule;
632:
633: IF bill_rec.customer_id IS NULL THEN
634: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
635: fnd_message.set_token('GENERIC_TEXT',
636: 'Required Parameter Missing: Bill To Customer Id');
637: g_jl_exception_type := 'E';
638: app_exception.raise_exception;
639: END IF;

Line 1020: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

1016: WHERE ml.memo_line_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.memo_line_id
1017: AND nvl(ml.org_id,-99) = nvl(l_org_id,-99); --Bugfix 2367111
1018: EXCEPTION
1019: WHEN NO_DATA_FOUND THEN
1020: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1021: fnd_message.set_token('GENERIC_TEXT',
1022: 'EXCEPTION(NO_DATA_FOUND) : Memo Line');
1023: g_jl_exception_type := 'E';
1024: app_exception.raise_exception;

Line 1021: fnd_message.set_token('GENERIC_TEXT',

1017: AND nvl(ml.org_id,-99) = nvl(l_org_id,-99); --Bugfix 2367111
1018: EXCEPTION
1019: WHEN NO_DATA_FOUND THEN
1020: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1021: fnd_message.set_token('GENERIC_TEXT',
1022: 'EXCEPTION(NO_DATA_FOUND) : Memo Line');
1023: g_jl_exception_type := 'E';
1024: app_exception.raise_exception;
1025:

Line 1027: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

1023: g_jl_exception_type := 'E';
1024: app_exception.raise_exception;
1025:
1026: WHEN OTHERS THEN
1027: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1028: fnd_message.set_token('GENERIC_TEXT',
1029: 'EXCEPTION(OTHERS) : Memo Line : ' || sqlerrm);
1030: g_jl_exception_type := 'E';
1031: app_exception.raise_exception;

Line 1028: fnd_message.set_token('GENERIC_TEXT',

1024: app_exception.raise_exception;
1025:
1026: WHEN OTHERS THEN
1027: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1028: fnd_message.set_token('GENERIC_TEXT',
1029: 'EXCEPTION(OTHERS) : Memo Line : ' || sqlerrm);
1030: g_jl_exception_type := 'E';
1031: app_exception.raise_exception;
1032: END;

Line 1035: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

1031: app_exception.raise_exception;
1032: END;
1033:
1034: IF l_line_type <> 'LINE' THEN
1035: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1036: fnd_message.set_token('GENERIC_TEXT',
1037: 'Memo Line Type is not LINE');
1038: g_jl_exception_type := 'E';
1039: app_exception.raise_exception;

Line 1036: fnd_message.set_token('GENERIC_TEXT',

1032: END;
1033:
1034: IF l_line_type <> 'LINE' THEN
1035: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1036: fnd_message.set_token('GENERIC_TEXT',
1037: 'Memo Line Type is not LINE');
1038: g_jl_exception_type := 'E';
1039: app_exception.raise_exception;
1040: END IF;

Line 1086: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

1082: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf7 = 'TAX_GROUP' THEN
1083:
1084: -- Validate Required Parameters
1085: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date IS NULL THEN
1086: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1087: fnd_message.set_token('GENERIC_TEXT',
1088: 'Required Parameter Missing: Transaction Date');
1089: g_jl_exception_type := 'E';
1090: app_exception.raise_exception;

Line 1087: fnd_message.set_token('GENERIC_TEXT',

1083:
1084: -- Validate Required Parameters
1085: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.trx_date IS NULL THEN
1086: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1087: fnd_message.set_token('GENERIC_TEXT',
1088: 'Required Parameter Missing: Transaction Date');
1089: g_jl_exception_type := 'E';
1090: app_exception.raise_exception;
1091: END IF;

Line 1094: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

1090: app_exception.raise_exception;
1091: END IF;
1092:
1093: IF ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id IS NULL THEN
1094: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1095: fnd_message.set_token('GENERIC_TEXT',
1096: 'Required Parameter Missing: Set Of Books Id');
1097: g_jl_exception_type := 'E';
1098: app_exception.raise_exception;

Line 1095: fnd_message.set_token('GENERIC_TEXT',

1091: END IF;
1092:
1093: IF ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id IS NULL THEN
1094: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1095: fnd_message.set_token('GENERIC_TEXT',
1096: 'Required Parameter Missing: Set Of Books Id');
1097: g_jl_exception_type := 'E';
1098: app_exception.raise_exception;
1099: END IF;

Line 1102: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

1098: app_exception.raise_exception;
1099: END IF;
1100:
1101: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1 IS NULL THEN
1102: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1103: fnd_message.set_token('GENERIC_TEXT',
1104: 'Required Parameter Missing: Tax Rule Set');
1105: g_jl_exception_type := 'E';
1106: app_exception.raise_exception;

Line 1103: fnd_message.set_token('GENERIC_TEXT',

1099: END IF;
1100:
1101: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1 IS NULL THEN
1102: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1103: fnd_message.set_token('GENERIC_TEXT',
1104: 'Required Parameter Missing: Tax Rule Set');
1105: g_jl_exception_type := 'E';
1106: app_exception.raise_exception;
1107: END IF;

Line 1110: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

1106: app_exception.raise_exception;
1107: END IF;
1108:
1109: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 IS NULL THEN
1110: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1111: fnd_message.set_token('GENERIC_TEXT',
1112: 'Required Parameter Missing: Contributor Condition Class ');
1113: g_jl_exception_type := 'E';
1114: app_exception.raise_exception;

Line 1111: fnd_message.set_token('GENERIC_TEXT',

1107: END IF;
1108:
1109: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 IS NULL THEN
1110: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1111: fnd_message.set_token('GENERIC_TEXT',
1112: 'Required Parameter Missing: Contributor Condition Class ');
1113: g_jl_exception_type := 'E';
1114: app_exception.raise_exception;
1115: END IF;

Line 1118: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

1114: app_exception.raise_exception;
1115: END IF;
1116:
1117: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9 IS NULL THEN
1118: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1119: fnd_message.set_token('GENERIC_TEXT',
1120: 'Required Parameter Missing: Transaction Condition Class');
1121: g_jl_exception_type := 'E';
1122: app_exception.raise_exception;

Line 1119: fnd_message.set_token('GENERIC_TEXT',

1115: END IF;
1116:
1117: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9 IS NULL THEN
1118: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1119: fnd_message.set_token('GENERIC_TEXT',
1120: 'Required Parameter Missing: Transaction Condition Class');
1121: g_jl_exception_type := 'E';
1122: app_exception.raise_exception;
1123: END IF;

Line 1126: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

1122: app_exception.raise_exception;
1123: END IF;
1124:
1125: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10 IS NULL THEN
1126: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1127: fnd_message.set_token('GENERIC_TEXT',
1128: 'Required Parameter Missing: Organization Condition Class');
1129: g_jl_exception_type := 'E';
1130: app_exception.raise_exception;

Line 1127: fnd_message.set_token('GENERIC_TEXT',

1123: END IF;
1124:
1125: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10 IS NULL THEN
1126: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1127: fnd_message.set_token('GENERIC_TEXT',
1128: 'Required Parameter Missing: Organization Condition Class');
1129: g_jl_exception_type := 'E';
1130: app_exception.raise_exception;
1131: END IF;

Line 1134: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

1130: app_exception.raise_exception;
1131: END IF;
1132:
1133: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2 IS NULL THEN
1134: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1135: fnd_message.set_token('GENERIC_TEXT',
1136: 'Required Parameter Missing: Group Tax Id');
1137: g_jl_exception_type := 'E';
1138: app_exception.raise_exception;

Line 1135: fnd_message.set_token('GENERIC_TEXT',

1131: END IF;
1132:
1133: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2 IS NULL THEN
1134: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1135: fnd_message.set_token('GENERIC_TEXT',
1136: 'Required Parameter Missing: Group Tax Id');
1137: g_jl_exception_type := 'E';
1138: app_exception.raise_exception;
1139: END IF;

Line 1142: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

1138: app_exception.raise_exception;
1139: END IF;
1140:
1141: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8 IS NULL THEN
1142: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1143: fnd_message.set_token('GENERIC_TEXT',
1144: 'Required Parameter Missing: Customer Account Site Id');
1145: g_jl_exception_type := 'E';
1146: app_exception.raise_exception;

Line 1143: fnd_message.set_token('GENERIC_TEXT',

1139: END IF;
1140:
1141: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8 IS NULL THEN
1142: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1143: fnd_message.set_token('GENERIC_TEXT',
1144: 'Required Parameter Missing: Customer Account Site Id');
1145: g_jl_exception_type := 'E';
1146: app_exception.raise_exception;
1147: END IF;

Line 1206: FND_MESSAGE.SET_NAME('AR','GENERIC_MESSAGE');

1202: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).tax_code);
1203: END IF;
1204:
1205: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).tax_code = 'NO_VALID_TAX_CODE' THEN
1206: FND_MESSAGE.SET_NAME('AR','GENERIC_MESSAGE');
1207: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','No Tax Code associated to RATE level rule for Tax Category '||
1208: c_grp_code_cus_rec.tax_category ||' and Contributor Type '||c_grp_code_cus_rec.attribute8);
1209: g_jl_exception_type := 'E';
1210: app_exception.raise_exception;

Line 1207: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','No Tax Code associated to RATE level rule for Tax Category '||

1203: END IF;
1204:
1205: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).tax_code = 'NO_VALID_TAX_CODE' THEN
1206: FND_MESSAGE.SET_NAME('AR','GENERIC_MESSAGE');
1207: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','No Tax Code associated to RATE level rule for Tax Category '||
1208: c_grp_code_cus_rec.tax_category ||' and Contributor Type '||c_grp_code_cus_rec.attribute8);
1209: g_jl_exception_type := 'E';
1210: app_exception.raise_exception;
1211: END IF;

Line 1354: FND_MESSAGE.SET_NAME('AR','GENERIC_MESSAGE');

1350: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).tax_code);
1351: END IF;
1352:
1353: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).tax_code = 'NO_VALID_TAX_CODE' THEN
1354: FND_MESSAGE.SET_NAME('AR','GENERIC_MESSAGE');
1355: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','No Tax Code associated to RATE level rule for Tax Category '||
1356: c_grp_code_att_rec.tax_category ||' and Contributor Type '||c_grp_code_att_rec.attribute8);
1357: g_jl_exception_type := 'E';
1358: app_exception.raise_exception;

Line 1355: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','No Tax Code associated to RATE level rule for Tax Category '||

1351: END IF;
1352:
1353: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).tax_code = 'NO_VALID_TAX_CODE' THEN
1354: FND_MESSAGE.SET_NAME('AR','GENERIC_MESSAGE');
1355: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','No Tax Code associated to RATE level rule for Tax Category '||
1356: c_grp_code_att_rec.tax_category ||' and Contributor Type '||c_grp_code_att_rec.attribute8);
1357: g_jl_exception_type := 'E';
1358: app_exception.raise_exception;
1359: END IF;

Line 1517: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_TC');

1513: || ' does not match with values of Class Code: '
1514: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
1515: END IF;
1516:
1517: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_TC');
1518: fnd_message.set_token('CATEGORY', c_tax_categ_rec.tax_category);
1519: fnd_message.set_token('TC_CODE', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
1520: fnd_message.set_token('GROUP', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
1521: -- Bug#6936808: set error to expected error

Line 1518: fnd_message.set_token('CATEGORY', c_tax_categ_rec.tax_category);

1514: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
1515: END IF;
1516:
1517: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_TC');
1518: fnd_message.set_token('CATEGORY', c_tax_categ_rec.tax_category);
1519: fnd_message.set_token('TC_CODE', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
1520: fnd_message.set_token('GROUP', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
1521: -- Bug#6936808: set error to expected error
1522: g_jl_exception_type := 'E';

Line 1519: fnd_message.set_token('TC_CODE', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);

1515: END IF;
1516:
1517: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_TC');
1518: fnd_message.set_token('CATEGORY', c_tax_categ_rec.tax_category);
1519: fnd_message.set_token('TC_CODE', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
1520: fnd_message.set_token('GROUP', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
1521: -- Bug#6936808: set error to expected error
1522: g_jl_exception_type := 'E';
1523: app_exception.raise_exception;

Line 1520: fnd_message.set_token('GROUP', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);

1516:
1517: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_TC');
1518: fnd_message.set_token('CATEGORY', c_tax_categ_rec.tax_category);
1519: fnd_message.set_token('TC_CODE', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9);
1520: fnd_message.set_token('GROUP', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
1521: -- Bug#6936808: set error to expected error
1522: g_jl_exception_type := 'E';
1523: app_exception.raise_exception;
1524:

Line 1559: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_OC');

1555: || c_tax_categ_rec.tax_category
1556: || ' does not match with values of Class Code: '
1557: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
1558: END IF;
1559: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_OC');
1560: fnd_message.set_token('CATEGORY', c_tax_categ_rec.tax_category);
1561: fnd_message.set_token('OC_CODE', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
1562: fnd_message.set_token('GROUP', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
1563: -- Bug#6936808: set error to expected error

Line 1560: fnd_message.set_token('CATEGORY', c_tax_categ_rec.tax_category);

1556: || ' does not match with values of Class Code: '
1557: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
1558: END IF;
1559: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_OC');
1560: fnd_message.set_token('CATEGORY', c_tax_categ_rec.tax_category);
1561: fnd_message.set_token('OC_CODE', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
1562: fnd_message.set_token('GROUP', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
1563: -- Bug#6936808: set error to expected error
1564: g_jl_exception_type := 'E';

Line 1561: fnd_message.set_token('OC_CODE', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);

1557: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
1558: END IF;
1559: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_OC');
1560: fnd_message.set_token('CATEGORY', c_tax_categ_rec.tax_category);
1561: fnd_message.set_token('OC_CODE', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
1562: fnd_message.set_token('GROUP', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
1563: -- Bug#6936808: set error to expected error
1564: g_jl_exception_type := 'E';
1565: app_exception.raise_exception;

Line 1562: fnd_message.set_token('GROUP', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);

1558: END IF;
1559: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_OC');
1560: fnd_message.set_token('CATEGORY', c_tax_categ_rec.tax_category);
1561: fnd_message.set_token('OC_CODE', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10);
1562: fnd_message.set_token('GROUP', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
1563: -- Bug#6936808: set error to expected error
1564: g_jl_exception_type := 'E';
1565: app_exception.raise_exception;
1566:

Line 1614: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_CC');

1610: || c_tax_categ_rec.tax_category
1611: || ' does not match with values of Class Code: '
1612: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
1613: END IF;
1614: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_CC');
1615: fnd_message.set_token('CATEGORY', c_tax_categ_rec.tax_category);
1616: fnd_message.set_token('CC_CODE', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
1617: fnd_message.set_token('GROUP', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
1618: -- Bug#6936808: set error to expected error

Line 1615: fnd_message.set_token('CATEGORY', c_tax_categ_rec.tax_category);

1611: || ' does not match with values of Class Code: '
1612: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
1613: END IF;
1614: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_CC');
1615: fnd_message.set_token('CATEGORY', c_tax_categ_rec.tax_category);
1616: fnd_message.set_token('CC_CODE', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
1617: fnd_message.set_token('GROUP', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
1618: -- Bug#6936808: set error to expected error
1619: g_jl_exception_type := 'E';

Line 1616: fnd_message.set_token('CC_CODE', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);

1612: || ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
1613: END IF;
1614: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_CC');
1615: fnd_message.set_token('CATEGORY', c_tax_categ_rec.tax_category);
1616: fnd_message.set_token('CC_CODE', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
1617: fnd_message.set_token('GROUP', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
1618: -- Bug#6936808: set error to expected error
1619: g_jl_exception_type := 'E';
1620: app_exception.raise_exception;

Line 1617: fnd_message.set_token('GROUP', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);

1613: END IF;
1614: fnd_message.set_name('JL','JL_ZZ_AR_TX_EXPAND_GROUP_CC');
1615: fnd_message.set_token('CATEGORY', c_tax_categ_rec.tax_category);
1616: fnd_message.set_token('CC_CODE', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6);
1617: fnd_message.set_token('GROUP', ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code);
1618: -- Bug#6936808: set error to expected error
1619: g_jl_exception_type := 'E';
1620: app_exception.raise_exception;
1621:

Line 1634: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

1630: END;
1631: IF (g_level_statement >= g_current_runtime_level ) THEN
1632: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','expand_group_tax_code ()-');
1633: END IF;
1634: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1635: fnd_message.set_token('GENERIC_TEXT',
1636: 'Could not expand tax group successfully');
1637: g_jl_exception_type := 'E';
1638: app_exception.raise_exception;

Line 1635: fnd_message.set_token('GENERIC_TEXT',

1631: IF (g_level_statement >= g_current_runtime_level ) THEN
1632: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','expand_group_tax_code ()-');
1633: END IF;
1634: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1635: fnd_message.set_token('GENERIC_TEXT',
1636: 'Could not expand tax group successfully');
1637: g_jl_exception_type := 'E';
1638: app_exception.raise_exception;
1639: END IF;