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_TAX_INTEGRATION_PKG dependencies on APP_EXCEPTION

Line 103: app_exception.raise_exception;

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;
105:
106: l_global_attribute5 := p_global_attribute5;
107: l_global_attribute6 := p_global_attribute6;

Line 124: app_exception.raise_exception;

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:
127: IF l_global_attribute6 IS NULL THEN
128: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

Line 131: app_exception.raise_exception;

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
134: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Global Attribute5 : ' || l_global_attribute5);
135: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','-- Global Attribute6 : ' || l_global_attribute6);

Line 205: app_exception.raise_exception;

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
207: END; -- End fetch for order_type_id passed in line_type_id
208: END; -- End fetch for Order Level
209:

Line 215: app_exception.raise_exception;

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;
217:
218: IF (NVL(l_tax_calculation_flag,'N') <> 'Y') THEN
219: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 267: app_exception.raise_exception;

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:
269: WHEN OTHERS THEN
270: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
271: fnd_message.set_token('GENERIC_TEXT',

Line 274: app_exception.raise_exception;

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;
276:
277: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern9 := l_location_structure_id;
278: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern10 := l_location_segment_num;

Line 302: app_exception.raise_exception;

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:
304: WHEN OTHERS THEN
305: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
306: fnd_message.set_token('GENERIC_TEXT',

Line 309: app_exception.raise_exception;

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;
311:
312: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4 := l_location_id;
313: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10 := l_org_class;

Line 321: app_exception.raise_exception;

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;
323:
324: -- Fetch AR_VAT_TAX details
325: l_taxable_basis := NULL;

Line 360: app_exception.raise_exception;

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:
362: WHEN OTHERS THEN
363: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
364: fnd_message.set_token('GENERIC_TEXT',

Line 367: app_exception.raise_exception;

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;
369:
370: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis := l_taxable_basis;
371: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_calculation_plsql_block :=

Line 585: app_exception.raise_exception;

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;
587:
588: -- Populate Ship To Details
589: IF p_ship_to_site_use_id IS NOT NULL THEN

Line 638: app_exception.raise_exception;

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;
640: EXIT;
641: END LOOP;
642: END IF;

Line 1024: app_exception.raise_exception;

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:
1026: WHEN OTHERS THEN
1027: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1028: fnd_message.set_token('GENERIC_TEXT',

Line 1031: app_exception.raise_exception;

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;
1033:
1034: IF l_line_type <> 'LINE' THEN
1035: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

Line 1039: app_exception.raise_exception;

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;
1041: END IF;
1042:
1043: --

Line 1090: app_exception.raise_exception;

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;
1092:
1093: IF ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id IS NULL THEN
1094: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

Line 1098: app_exception.raise_exception;

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;
1100:
1101: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf1 IS NULL THEN
1102: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

Line 1106: app_exception.raise_exception;

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;
1108:
1109: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf6 IS NULL THEN
1110: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

Line 1114: app_exception.raise_exception;

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;
1116:
1117: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf9 IS NULL THEN
1118: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

Line 1122: app_exception.raise_exception;

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;
1124:
1125: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10 IS NULL THEN
1126: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

Line 1130: app_exception.raise_exception;

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;
1132:
1133: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern2 IS NULL THEN
1134: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

Line 1138: app_exception.raise_exception;

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;
1140:
1141: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern8 IS NULL THEN
1142: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

Line 1146: app_exception.raise_exception;

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;
1148:
1149: -- Check if Override Customer Site Profile is set to 'Y'
1150: IF NVL(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4,'N') = 'Y' THEN

Line 1210: app_exception.raise_exception;

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;
1212:
1213: FOR c_vat_tax_rec IN c_vat_tax(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).tax_code)
1214: LOOP

Line 1358: app_exception.raise_exception;

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;
1360:
1361: FOR c_vat_tax_rec IN c_vat_tax(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec_tbl(l_index).tax_code)
1362: LOOP

Line 1523: app_exception.raise_exception;

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:
1525: WHEN OTHERS THEN
1526: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1527: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','EXCEPTION(OTHERS): '

Line 1565: app_exception.raise_exception;

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:
1567: WHEN OTHERS THEN
1568: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1569: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','EXCEPTION(OTHERS): '

Line 1620: app_exception.raise_exception;

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:
1622: WHEN OTHERS THEN
1623: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1624: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','EXCEPTION(OTHERS): ' || 'Contributor Type');

Line 1638: app_exception.raise_exception;

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;
1640: ELSE
1641: -- If Tax Type is not TAX_GROUP
1642: -- bug#5112515