DBA Data[Home] [Help]

APPS.JL_ZZ_TAX_INTEGRATION_PKG dependencies on APP_EXCEPTION

Line 102: app_exception.raise_exception;

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

Line 123: app_exception.raise_exception;

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

Line 130: app_exception.raise_exception;

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

Line 203: app_exception.raise_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
206: END; -- End fetch for Order Level
207:

Line 212: app_exception.raise_exception;

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:
215: IF (NVL(l_tax_calculation_flag,'N') <> 'Y') THEN
216: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 263: app_exception.raise_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
266: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
267: fnd_message.set_token('GENERIC_TEXT',

Line 269: app_exception.raise_exception;

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:
272: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern9 := l_location_structure_id;
273: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern10 := l_location_segment_num;

Line 296: app_exception.raise_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
299: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
300: fnd_message.set_token('GENERIC_TEXT',

Line 302: app_exception.raise_exception;

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:
305: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4 := l_location_id;
306: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf10 := l_org_class;

Line 313: app_exception.raise_exception;

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:
316: -- Fetch AR_VAT_TAX details
317: l_taxable_basis := NULL;

Line 351: app_exception.raise_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
354: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
355: fnd_message.set_token('GENERIC_TEXT',

Line 357: app_exception.raise_exception;

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:
360: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.taxable_basis := l_taxable_basis;
361: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_calculation_plsql_block :=

Line 574: app_exception.raise_exception;

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:
577: -- Populate Ship To Details
578: IF p_ship_to_site_use_id IS NOT NULL THEN

Line 626: app_exception.raise_exception;

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;
629: END LOOP;
630: END IF;

Line 1007: app_exception.raise_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
1010: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1011: fnd_message.set_token('GENERIC_TEXT',

Line 1013: app_exception.raise_exception;

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

Line 1020: app_exception.raise_exception;

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;
1023:
1024: --

Line 1070: app_exception.raise_exception;

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

Line 1077: app_exception.raise_exception;

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

Line 1084: app_exception.raise_exception;

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

Line 1091: app_exception.raise_exception;

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

Line 1098: app_exception.raise_exception;

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

Line 1105: app_exception.raise_exception;

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

Line 1112: app_exception.raise_exception;

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

Line 1119: app_exception.raise_exception;

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

Line 1488: app_exception.raise_exception;

1484:
1485: -- Bug#6936808: set error to expected error
1486: g_jl_exception_type := 'E';
1487:
1488: app_exception.raise_exception;
1489:
1490: WHEN OTHERS THEN
1491: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1492: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','EXCEPTION(OTHERS): '

Line 1538: app_exception.raise_exception;

1534:
1535: -- Bug#6936808: set error to expected error
1536: g_jl_exception_type := 'E';
1537:
1538: app_exception.raise_exception;
1539:
1540: WHEN OTHERS THEN
1541: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1542: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','EXCEPTION(OTHERS): '

Line 1601: app_exception.raise_exception;

1597:
1598: -- Bug#6936808: set error to expected error
1599: g_jl_exception_type := 'E';
1600:
1601: app_exception.raise_exception;
1602:
1603: WHEN OTHERS THEN
1604: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1605: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX_INTEGRATION_PKG','EXCEPTION(OTHERS): ' || 'Contributor Type');

Line 1618: app_exception.raise_exception;

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
1621: -- If Tax Type is not TAX_GROUP
1622: