DBA Data[Home] [Help]

APPS.ZX_PRODUCT_INTEGRATION_PKG dependencies on FND_MESSAGE

Line 383: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');

379: IF (g_level_event >= g_current_runtime_level) THEN
380: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Error: application short name not found');
381: END IF;
382: x_return_status := FND_API.G_RET_STS_ERROR;
383: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
384: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Application ID is invalid, please fix and try again');
385: ZX_API_PUB.add_msg(
386: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
387:

Line 384: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Application ID is invalid, please fix and try again');

380: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Error: application short name not found');
381: END IF;
382: x_return_status := FND_API.G_RET_STS_ERROR;
383: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
384: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Application ID is invalid, please fix and try again');
385: ZX_API_PUB.add_msg(
386: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
387:
388: IF ( g_level_unexpected >= g_current_runtime_level) THEN

Line 927: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_SYSTEM_PARAMETERS');

923: exception when no_data_found then
924: IF (g_level_statement >= g_current_runtime_level) THEN
925: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','EXCEPTION: NO_DATA_FOUND IN SYSTEM PARAMETERS ' );
926: END IF;
927: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_SYSTEM_PARAMETERS');
928: APP_EXCEPTION.raise_exception;
929: RAISE;
930: end;
931:

Line 974: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_GL_SET_OF_BOOKS');

970: exception when no_data_found then
971: IF (g_level_statement >= g_current_runtime_level) THEN
972: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','EXCEPTION: NO_DATA_FOUND IN SET OF BOOKS ' );
973: END IF;
974: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_GL_SET_OF_BOOKS');
975: APP_EXCEPTION.raise_exception;
976: RAISE;
977: end;
978:

Line 983: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_FND_CURRENCIES');

979: -- Test 1 passed therefore currency must not be defined
980: IF (g_level_statement >= g_current_runtime_level) THEN
981: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','EXCEPTION: NO_DATA_FOUND IN CURRENCIES ' );
982: END IF;
983: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_FND_CURRENCIES');
984: APP_EXCEPTION.raise_exception;
985: RAISE; --end of WHEN NO DATA FOUND
986: END;
987:

Line 1043: -- Bug 2185315 - added fnd_message so error will reflect on the form

1039: FND_LOG.STRING(g_level_unexpected,
1040: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.initialize',
1041: 'Error Getting OE Profile information');
1042: END IF;
1043: -- Bug 2185315 - added fnd_message so error will reflect on the form
1044: FND_MESSAGE.set_name('AR','AR_NO_OM_MASTER_ORG'); -- Bug 3151551
1045: APP_EXCEPTION.raise_exception;
1046: End if;
1047:

Line 1044: FND_MESSAGE.set_name('AR','AR_NO_OM_MASTER_ORG'); -- Bug 3151551

1040: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.initialize',
1041: 'Error Getting OE Profile information');
1042: END IF;
1043: -- Bug 2185315 - added fnd_message so error will reflect on the form
1044: FND_MESSAGE.set_name('AR','AR_NO_OM_MASTER_ORG'); -- Bug 3151551
1045: APP_EXCEPTION.raise_exception;
1046: End if;
1047:
1048: profinfo.so_organization_id := l_master_org_id;

Line 1757: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');

1753:
1754: ELSE -- error out for other line level actions than CREATE and CREAT_WITH_TAX
1755:
1756: x_return_status := FND_API.G_RET_STS_ERROR;
1757: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
1758: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Transaction line level action is invalid.');
1759: ZX_API_PUB.add_msg(
1760: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1761:

Line 1758: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Transaction line level action is invalid.');

1754: ELSE -- error out for other line level actions than CREATE and CREAT_WITH_TAX
1755:
1756: x_return_status := FND_API.G_RET_STS_ERROR;
1757: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
1758: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Transaction line level action is invalid.');
1759: ZX_API_PUB.add_msg(
1760: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1761:
1762: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

2866: AND NVL(tax_class,'O') = 'O'
2867: AND ORG_ID = sysinfo.sysparam.org_id;
2868: EXCEPTION
2869: WHEN NO_DATA_FOUND THEN
2870: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
2871: fnd_message.set_token('GENERIC_TEXT',
2872: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
2873: app_exception.raise_exception;
2874: WHEN OTHERS THEN

Line 2871: fnd_message.set_token('GENERIC_TEXT',

2867: AND ORG_ID = sysinfo.sysparam.org_id;
2868: EXCEPTION
2869: WHEN NO_DATA_FOUND THEN
2870: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
2871: fnd_message.set_token('GENERIC_TEXT',
2872: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
2873: app_exception.raise_exception;
2874: WHEN OTHERS THEN
2875: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

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

2871: fnd_message.set_token('GENERIC_TEXT',
2872: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
2873: app_exception.raise_exception;
2874: WHEN OTHERS THEN
2875: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
2876: fnd_message.set_token('GENERIC_TEXT',
2877: 'EXCEPTION(OTHERS) : Tax Code : ' || sqlerrm);
2878: app_exception.raise_exception;
2879: END;

Line 2876: fnd_message.set_token('GENERIC_TEXT',

2872: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
2873: app_exception.raise_exception;
2874: WHEN OTHERS THEN
2875: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
2876: fnd_message.set_token('GENERIC_TEXT',
2877: 'EXCEPTION(OTHERS) : Tax Code : ' || sqlerrm);
2878: app_exception.raise_exception;
2879: END;
2880:

Line 3382: fnd_message.set_name('AR', 'AR_TAX_NO_AMOUNT');

3378: -- Check that the amount field has a value for lines other than Adjustments
3379: --
3380: IF ( tax_info_rec.extended_amount IS NULL AND
3381: nvl(tax_info_rec.trx_line_type, 'LINE') <> 'ADJ' ) THEN
3382: fnd_message.set_name('AR', 'AR_TAX_NO_AMOUNT');
3383: app_exception.raise_exception;
3384: END IF;
3385:
3386: --

Line 3390: fnd_message.set_name('AR', 'AR_TAX_NO_PRECISION');

3386: --
3387: -- Check that the precision field has a value
3388: --
3389: IF ( tax_info_rec.precision IS NULL ) THEN
3390: fnd_message.set_name('AR', 'AR_TAX_NO_PRECISION');
3391: app_exception.raise_exception;
3392: END IF;
3393:
3394: -- Copy the tax rate passed

Line 3487: fnd_message.set_name('AR', 'AR_TAX_NO_CODE');

3483: -- If tax method is VAT and if tax code or rate not found then display mesg
3484: -- and raise exception.
3485: --
3486: IF tax_info_rec.tax_code IS NULL THEN
3487: fnd_message.set_name('AR', 'AR_TAX_NO_CODE');
3488: JL_ZZ_TAX_INTEGRATION_PKG.g_jl_exception_type := 'E';
3489: app_exception.raise_exception;
3490: END IF;
3491:

Line 3560: fnd_message.set_name('AR','AR_TAX_RATE_INVALID');

3556: -- Don't use the tax rate passed, use the tax rate for the tax code.
3557: l_use_tax_rate_passed := FALSE;
3558: ELSE
3559: -- Raise error
3560: fnd_message.set_name('AR','AR_TAX_RATE_INVALID');
3561: fnd_message.set_token('TAX_CODE', tax_info_rec.tax_code);
3562: fnd_message.set_token('TRX_DATE', tax_info_rec.trx_date );
3563: JL_ZZ_TAX_INTEGRATION_PKG.g_jl_exception_type := 'E';
3564: app_exception.raise_exception;

Line 3561: fnd_message.set_token('TAX_CODE', tax_info_rec.tax_code);

3557: l_use_tax_rate_passed := FALSE;
3558: ELSE
3559: -- Raise error
3560: fnd_message.set_name('AR','AR_TAX_RATE_INVALID');
3561: fnd_message.set_token('TAX_CODE', tax_info_rec.tax_code);
3562: fnd_message.set_token('TRX_DATE', tax_info_rec.trx_date );
3563: JL_ZZ_TAX_INTEGRATION_PKG.g_jl_exception_type := 'E';
3564: app_exception.raise_exception;
3565: END IF;

Line 3562: fnd_message.set_token('TRX_DATE', tax_info_rec.trx_date );

3558: ELSE
3559: -- Raise error
3560: fnd_message.set_name('AR','AR_TAX_RATE_INVALID');
3561: fnd_message.set_token('TAX_CODE', tax_info_rec.tax_code);
3562: fnd_message.set_token('TRX_DATE', tax_info_rec.trx_date );
3563: JL_ZZ_TAX_INTEGRATION_PKG.g_jl_exception_type := 'E';
3564: app_exception.raise_exception;
3565: END IF;
3566:

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

3674: l_tax_vendor_return_code := tax_info_rec.tax_vendor_return_code;
3675:
3676: EXCEPTION
3677: WHEN OTHERS THEN
3678: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3679: fnd_message.set_token('GENERIC_TEXT', 'Latin Tax Engine raised error.'||
3680: SQLCODE||';'||SQLERRM);
3681: IF (g_level_unexpected >= g_current_runtime_level) THEN
3682: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Latin Tax Engine raised error: '||SQLCODE||';'||SQLERRM);

Line 3679: fnd_message.set_token('GENERIC_TEXT', 'Latin Tax Engine raised error.'||

3675:
3676: EXCEPTION
3677: WHEN OTHERS THEN
3678: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3679: fnd_message.set_token('GENERIC_TEXT', 'Latin Tax Engine raised error.'||
3680: SQLCODE||';'||SQLERRM);
3681: IF (g_level_unexpected >= g_current_runtime_level) THEN
3682: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Latin Tax Engine raised error: '||SQLCODE||';'||SQLERRM);
3683: END IF;

Line 3813: fnd_message.set_name('AR','AR_TAX_NO_RATE');

3809: -- display message and raise exception.
3810: --
3811: IF ( tax_info_rec.tax_control = 'E' ) THEN
3812:
3813: fnd_message.set_name('AR','AR_TAX_NO_RATE');
3814: JL_ZZ_TAX_INTEGRATION_PKG.g_jl_exception_type := 'E';
3815: app_exception.raise_exception;
3816:
3817: END IF; -- Tax control is Exempt?

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

3838: END IF;
3839:
3840: EXCEPTION
3841: WHEN OTHERS THEN
3842: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3843: fnd_message.set_token('GENERIC_TEXT', 'Latin Tax Engine raised error.'||
3844: SQLCODE||';'||SQLERRM);
3845: IF (g_level_unexpected >= g_current_runtime_level) THEN
3846: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Latin Tax Engine raised error: '||SQLCODE||';'||SQLERRM);

Line 3843: fnd_message.set_token('GENERIC_TEXT', 'Latin Tax Engine raised error.'||

3839:
3840: EXCEPTION
3841: WHEN OTHERS THEN
3842: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3843: fnd_message.set_token('GENERIC_TEXT', 'Latin Tax Engine raised error.'||
3844: SQLCODE||';'||SQLERRM);
3845: IF (g_level_unexpected >= g_current_runtime_level) THEN
3846: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Latin Tax Engine raised error: '||SQLCODE||';'||SQLERRM);
3847: END IF;

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

4176: -- LTE validate and default program.
4177:
4178:
4179: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.receivables_trx_type_id(p_index) IS NULL THEN
4180: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4181: fnd_message.set_token('GENERIC_TEXT',
4182: 'Required Parameter Missing: Transaction Type Id');
4183: JL_ZZ_TAX_INTEGRATION_PKG.g_jl_exception_type := 'E';
4184: app_exception.raise_exception;

Line 4181: fnd_message.set_token('GENERIC_TEXT',

4177:
4178:
4179: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.receivables_trx_type_id(p_index) IS NULL THEN
4180: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4181: fnd_message.set_token('GENERIC_TEXT',
4182: 'Required Parameter Missing: Transaction Type Id');
4183: JL_ZZ_TAX_INTEGRATION_PKG.g_jl_exception_type := 'E';
4184: app_exception.raise_exception;
4185: END IF;

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

4201: AND ORG_ID = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id(p_index);
4202:
4203: EXCEPTION
4204: WHEN NO_DATA_FOUND THEN
4205: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4206: fnd_message.set_token('GENERIC_TEXT',
4207: 'EXCEPTION(NO_DATA_FOUND) : Customer Trx Type Id');
4208: app_exception.raise_exception;
4209: WHEN OTHERS THEN

Line 4206: fnd_message.set_token('GENERIC_TEXT',

4202:
4203: EXCEPTION
4204: WHEN NO_DATA_FOUND THEN
4205: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4206: fnd_message.set_token('GENERIC_TEXT',
4207: 'EXCEPTION(NO_DATA_FOUND) : Customer Trx Type Id');
4208: app_exception.raise_exception;
4209: WHEN OTHERS THEN
4210: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

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

4206: fnd_message.set_token('GENERIC_TEXT',
4207: 'EXCEPTION(NO_DATA_FOUND) : Customer Trx Type Id');
4208: app_exception.raise_exception;
4209: WHEN OTHERS THEN
4210: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4211: fnd_message.set_token('GENERIC_TEXT',
4212: 'EXCEPTION(OTHERS) : Customer Trx Type Id : ' || sqlerrm);
4213: app_exception.raise_exception;
4214: END;

Line 4211: fnd_message.set_token('GENERIC_TEXT',

4207: 'EXCEPTION(NO_DATA_FOUND) : Customer Trx Type Id');
4208: app_exception.raise_exception;
4209: WHEN OTHERS THEN
4210: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4211: fnd_message.set_token('GENERIC_TEXT',
4212: 'EXCEPTION(OTHERS) : Customer Trx Type Id : ' || sqlerrm);
4213: app_exception.raise_exception;
4214: END;
4215:

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

4250: AND trx_level_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(p_index);
4251:
4252: EXCEPTION
4253: WHEN NO_DATA_FOUND THEN
4254: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4255: fnd_message.set_token('GENERIC_TEXT',
4256: 'EXCEPTION(NO_DATA_FOUND) : No Record found for Adjusted Doc.');
4257: app_exception.raise_exception;
4258: WHEN OTHERS THEN

Line 4255: fnd_message.set_token('GENERIC_TEXT',

4251:
4252: EXCEPTION
4253: WHEN NO_DATA_FOUND THEN
4254: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4255: fnd_message.set_token('GENERIC_TEXT',
4256: 'EXCEPTION(NO_DATA_FOUND) : No Record found for Adjusted Doc.');
4257: app_exception.raise_exception;
4258: WHEN OTHERS THEN
4259: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

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

4255: fnd_message.set_token('GENERIC_TEXT',
4256: 'EXCEPTION(NO_DATA_FOUND) : No Record found for Adjusted Doc.');
4257: app_exception.raise_exception;
4258: WHEN OTHERS THEN
4259: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4260: fnd_message.set_token('GENERIC_TEXT',
4261: 'EXCEPTION(OTHERS) : Record for Adjusted Doc : ' || sqlerrm);
4262: app_exception.raise_exception;
4263: END;

Line 4260: fnd_message.set_token('GENERIC_TEXT',

4256: 'EXCEPTION(NO_DATA_FOUND) : No Record found for Adjusted Doc.');
4257: app_exception.raise_exception;
4258: WHEN OTHERS THEN
4259: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4260: fnd_message.set_token('GENERIC_TEXT',
4261: 'EXCEPTION(OTHERS) : Record for Adjusted Doc : ' || sqlerrm);
4262: app_exception.raise_exception;
4263: END;
4264: END IF;

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

4315: IF (g_level_unexpected >= g_current_runtime_level) THEN
4316: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Could not derive global_attribute1 from hr_locations for org_id: '||
4317: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id(p_index));
4318: END IF;
4319: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4320: fnd_message.set_token('GENERIC_TEXT',
4321: 'EXCEPTION(NO_DATA_FOUND) : Organization Class');
4322: app_exception.raise_exception;
4323: WHEN OTHERS THEN

Line 4320: fnd_message.set_token('GENERIC_TEXT',

4316: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Could not derive global_attribute1 from hr_locations for org_id: '||
4317: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id(p_index));
4318: END IF;
4319: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4320: fnd_message.set_token('GENERIC_TEXT',
4321: 'EXCEPTION(NO_DATA_FOUND) : Organization Class');
4322: app_exception.raise_exception;
4323: WHEN OTHERS THEN
4324: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

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

4320: fnd_message.set_token('GENERIC_TEXT',
4321: 'EXCEPTION(NO_DATA_FOUND) : Organization Class');
4322: app_exception.raise_exception;
4323: WHEN OTHERS THEN
4324: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4325: fnd_message.set_token('GENERIC_TEXT',
4326: 'EXCEPTION(OTHERS) : Organization Class : ' || sqlcode||' , '||sqlerrm);
4327: app_exception.raise_exception;
4328: END;

Line 4325: fnd_message.set_token('GENERIC_TEXT',

4321: 'EXCEPTION(NO_DATA_FOUND) : Organization Class');
4322: app_exception.raise_exception;
4323: WHEN OTHERS THEN
4324: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4325: fnd_message.set_token('GENERIC_TEXT',
4326: 'EXCEPTION(OTHERS) : Organization Class : ' || sqlcode||' , '||sqlerrm);
4327: app_exception.raise_exception;
4328: END;
4329: */

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

4352: IF (g_level_unexpected >= g_current_runtime_level) THEN
4353: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Could not derive global_attribute1 from hr_locations for org_id: '||
4354: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id(p_index));
4355: END IF;
4356: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4357: fnd_message.set_token('GENERIC_TEXT','EXCEPTION(NO_DATA_FOUND) : Organization Class');
4358: app_exception.raise_exception;
4359: ELSE
4360: CLOSE get_org_class;

Line 4357: fnd_message.set_token('GENERIC_TEXT','EXCEPTION(NO_DATA_FOUND) : Organization Class');

4353: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Could not derive global_attribute1 from hr_locations for org_id: '||
4354: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id(p_index));
4355: END IF;
4356: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4357: fnd_message.set_token('GENERIC_TEXT','EXCEPTION(NO_DATA_FOUND) : Organization Class');
4358: app_exception.raise_exception;
4359: ELSE
4360: CLOSE get_org_class;
4361: END IF;

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

4417: AND NVL(tax_class,'O') = 'O'
4418: AND ORG_ID = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id(p_index) ;
4419: EXCEPTION
4420: WHEN NO_DATA_FOUND THEN
4421: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4422: fnd_message.set_token('GENERIC_TEXT',
4423: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
4424: app_exception.raise_exception;
4425: WHEN OTHERS THEN

Line 4422: fnd_message.set_token('GENERIC_TEXT',

4418: AND ORG_ID = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id(p_index) ;
4419: EXCEPTION
4420: WHEN NO_DATA_FOUND THEN
4421: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4422: fnd_message.set_token('GENERIC_TEXT',
4423: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
4424: app_exception.raise_exception;
4425: WHEN OTHERS THEN
4426: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

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

4422: fnd_message.set_token('GENERIC_TEXT',
4423: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
4424: app_exception.raise_exception;
4425: WHEN OTHERS THEN
4426: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4427: fnd_message.set_token('GENERIC_TEXT',
4428: 'EXCEPTION(OTHERS) : Tax Code : ' || sqlerrm);
4429: app_exception.raise_exception;
4430: END;

Line 4427: fnd_message.set_token('GENERIC_TEXT',

4423: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
4424: app_exception.raise_exception;
4425: WHEN OTHERS THEN
4426: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4427: fnd_message.set_token('GENERIC_TEXT',
4428: 'EXCEPTION(OTHERS) : Tax Code : ' || sqlerrm);
4429: app_exception.raise_exception;
4430: END;
4431: -- Bug 4028732 comment out END IF;