DBA Data[Home] [Help]

APPS.ZX_PRODUCT_INTEGRATION_PKG dependencies on FND_MESSAGE

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

342: IF (g_level_event >= g_current_runtime_level) THEN
343: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Error: application short name not found');
344: END IF;
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
347: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Application ID is invalid, please fix and try again');
348: ZX_API_PUB.add_msg(
349: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
350:

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

343: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Error: application short name not found');
344: END IF;
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
347: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Application ID is invalid, please fix and try again');
348: ZX_API_PUB.add_msg(
349: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
350:
351: IF ( g_level_unexpected >= g_current_runtime_level) THEN

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

886: exception when no_data_found then
887: IF (g_level_statement >= g_current_runtime_level) THEN
888: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','EXCEPTION: NO_DATA_FOUND IN SYSTEM PARAMETERS ' );
889: END IF;
890: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_SYSTEM_PARAMETERS');
891: APP_EXCEPTION.raise_exception;
892: RAISE;
893: end;
894:

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

933: exception when no_data_found then
934: IF (g_level_statement >= g_current_runtime_level) THEN
935: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','EXCEPTION: NO_DATA_FOUND IN SET OF BOOKS ' );
936: END IF;
937: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_GL_SET_OF_BOOKS');
938: APP_EXCEPTION.raise_exception;
939: RAISE;
940: end;
941:

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

942: -- Test 1 passed therefore currency must not be defined
943: IF (g_level_statement >= g_current_runtime_level) THEN
944: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','EXCEPTION: NO_DATA_FOUND IN CURRENCIES ' );
945: END IF;
946: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_FND_CURRENCIES');
947: APP_EXCEPTION.raise_exception;
948: RAISE; --end of WHEN NO DATA FOUND
949: END;
950:

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

1002: FND_LOG.STRING(g_level_unexpected,
1003: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.initialize',
1004: 'Error Getting OE Profile information');
1005: END IF;
1006: -- Bug 2185315 - added fnd_message so error will reflect on the form
1007: FND_MESSAGE.set_name('AR','AR_NO_OM_MASTER_ORG'); -- Bug 3151551
1008: APP_EXCEPTION.raise_exception;
1009: End if;
1010:

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

1003: 'ZX.PLSQL.ZX_AR_TAX_CLASSIFICATN_DEF_PKG.initialize',
1004: 'Error Getting OE Profile information');
1005: END IF;
1006: -- Bug 2185315 - added fnd_message so error will reflect on the form
1007: FND_MESSAGE.set_name('AR','AR_NO_OM_MASTER_ORG'); -- Bug 3151551
1008: APP_EXCEPTION.raise_exception;
1009: End if;
1010:
1011: profinfo.so_organization_id := l_master_org_id;

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

1443:
1444: ELSE -- error out for other line level actions than CREATE and CREAT_WITH_TAX
1445:
1446: x_return_status := FND_API.G_RET_STS_ERROR;
1447: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
1448: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Transaction line level action is invalid.');
1449: ZX_API_PUB.add_msg(
1450: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1451:

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

1444: ELSE -- error out for other line level actions than CREATE and CREAT_WITH_TAX
1445:
1446: x_return_status := FND_API.G_RET_STS_ERROR;
1447: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
1448: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Transaction line level action is invalid.');
1449: ZX_API_PUB.add_msg(
1450: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1451:
1452: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

2548: AND NVL(tax_class,'O') = 'O'
2549: AND ORG_ID = sysinfo.sysparam.org_id;
2550: EXCEPTION
2551: WHEN NO_DATA_FOUND THEN
2552: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
2553: fnd_message.set_token('GENERIC_TEXT',
2554: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
2555: app_exception.raise_exception;
2556: WHEN OTHERS THEN

Line 2553: fnd_message.set_token('GENERIC_TEXT',

2549: AND ORG_ID = sysinfo.sysparam.org_id;
2550: EXCEPTION
2551: WHEN NO_DATA_FOUND THEN
2552: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
2553: fnd_message.set_token('GENERIC_TEXT',
2554: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
2555: app_exception.raise_exception;
2556: WHEN OTHERS THEN
2557: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

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

2553: fnd_message.set_token('GENERIC_TEXT',
2554: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
2555: app_exception.raise_exception;
2556: WHEN OTHERS THEN
2557: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
2558: fnd_message.set_token('GENERIC_TEXT',
2559: 'EXCEPTION(OTHERS) : Tax Code : ' || sqlerrm);
2560: app_exception.raise_exception;
2561: END;

Line 2558: fnd_message.set_token('GENERIC_TEXT',

2554: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
2555: app_exception.raise_exception;
2556: WHEN OTHERS THEN
2557: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
2558: fnd_message.set_token('GENERIC_TEXT',
2559: 'EXCEPTION(OTHERS) : Tax Code : ' || sqlerrm);
2560: app_exception.raise_exception;
2561: END;
2562:

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

3060: -- Check that the amount field has a value for lines other than Adjustments
3061: --
3062: IF ( tax_info_rec.extended_amount IS NULL AND
3063: nvl(tax_info_rec.trx_line_type, 'LINE') <> 'ADJ' ) THEN
3064: fnd_message.set_name('AR', 'AR_TAX_NO_AMOUNT');
3065: app_exception.raise_exception;
3066: END IF;
3067:
3068: --

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

3068: --
3069: -- Check that the precision field has a value
3070: --
3071: IF ( tax_info_rec.precision IS NULL ) THEN
3072: fnd_message.set_name('AR', 'AR_TAX_NO_PRECISION');
3073: app_exception.raise_exception;
3074: END IF;
3075:
3076: -- Copy the tax rate passed

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

3165: -- If tax method is VAT and if tax code or rate not found then display mesg
3166: -- and raise exception.
3167: --
3168: IF tax_info_rec.tax_code IS NULL THEN
3169: fnd_message.set_name('AR', 'AR_TAX_NO_CODE');
3170: app_exception.raise_exception;
3171:
3172: END IF;
3173:

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

3238: -- Don't use the tax rate passed, use the tax rate for the tax code.
3239: l_use_tax_rate_passed := FALSE;
3240: ELSE
3241: -- Raise error
3242: fnd_message.set_name('AR','AR_TAX_RATE_INVALID');
3243: fnd_message.set_token('TAX_CODE', tax_info_rec.tax_code);
3244: fnd_message.set_token('TRX_DATE', tax_info_rec.trx_date );
3245: app_exception.raise_exception;
3246: END IF;

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

3239: l_use_tax_rate_passed := FALSE;
3240: ELSE
3241: -- Raise error
3242: fnd_message.set_name('AR','AR_TAX_RATE_INVALID');
3243: fnd_message.set_token('TAX_CODE', tax_info_rec.tax_code);
3244: fnd_message.set_token('TRX_DATE', tax_info_rec.trx_date );
3245: app_exception.raise_exception;
3246: END IF;
3247:

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

3240: ELSE
3241: -- Raise error
3242: fnd_message.set_name('AR','AR_TAX_RATE_INVALID');
3243: fnd_message.set_token('TAX_CODE', tax_info_rec.tax_code);
3244: fnd_message.set_token('TRX_DATE', tax_info_rec.trx_date );
3245: app_exception.raise_exception;
3246: END IF;
3247:
3248: ELSE -- Adhoc Tax Code

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

3353: END IF;
3354:
3355: EXCEPTION
3356: WHEN OTHERS THEN
3357: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3358: fnd_message.set_token('GENERIC_TEXT', 'Latin Tax Engine raised error.'||
3359: SQLCODE||';'||SQLERRM);
3360: IF (g_level_unexpected >= g_current_runtime_level) THEN
3361: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Latin Tax Engine raised error: '||SQLCODE||';'||SQLERRM);

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

3354:
3355: EXCEPTION
3356: WHEN OTHERS THEN
3357: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3358: fnd_message.set_token('GENERIC_TEXT', 'Latin Tax Engine raised error.'||
3359: SQLCODE||';'||SQLERRM);
3360: IF (g_level_unexpected >= g_current_runtime_level) THEN
3361: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Latin Tax Engine raised error: '||SQLCODE||';'||SQLERRM);
3362: END IF;

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

3488: -- display message and raise exception.
3489: --
3490: IF ( tax_info_rec.tax_control = 'E' ) THEN
3491:
3492: fnd_message.set_name('AR','AR_TAX_NO_RATE');
3493: app_exception.raise_exception;
3494:
3495: END IF; -- Tax control is Exempt?
3496: END;

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

3516: END IF;
3517:
3518: EXCEPTION
3519: WHEN OTHERS THEN
3520: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3521: fnd_message.set_token('GENERIC_TEXT', 'Latin Tax Engine raised error.'||
3522: SQLCODE||';'||SQLERRM);
3523: IF (g_level_unexpected >= g_current_runtime_level) THEN
3524: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Latin Tax Engine raised error: '||SQLCODE||';'||SQLERRM);

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

3517:
3518: EXCEPTION
3519: WHEN OTHERS THEN
3520: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3521: fnd_message.set_token('GENERIC_TEXT', 'Latin Tax Engine raised error.'||
3522: SQLCODE||';'||SQLERRM);
3523: IF (g_level_unexpected >= g_current_runtime_level) THEN
3524: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Latin Tax Engine raised error: '||SQLCODE||';'||SQLERRM);
3525: END IF;

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

3846: -- LTE validate and default program.
3847:
3848:
3849: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.receivables_trx_type_id(p_index) IS NULL THEN
3850: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3851: fnd_message.set_token('GENERIC_TEXT',
3852: 'Required Parameter Missing: Transaction Type Id');
3853: app_exception.raise_exception;
3854: END IF;

Line 3851: fnd_message.set_token('GENERIC_TEXT',

3847:
3848:
3849: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.receivables_trx_type_id(p_index) IS NULL THEN
3850: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3851: fnd_message.set_token('GENERIC_TEXT',
3852: 'Required Parameter Missing: Transaction Type Id');
3853: app_exception.raise_exception;
3854: END IF;
3855:

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

3870: AND ORG_ID = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id(p_index);
3871:
3872: EXCEPTION
3873: WHEN NO_DATA_FOUND THEN
3874: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3875: fnd_message.set_token('GENERIC_TEXT',
3876: 'EXCEPTION(NO_DATA_FOUND) : Customer Trx Type Id');
3877: app_exception.raise_exception;
3878:

Line 3875: fnd_message.set_token('GENERIC_TEXT',

3871:
3872: EXCEPTION
3873: WHEN NO_DATA_FOUND THEN
3874: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3875: fnd_message.set_token('GENERIC_TEXT',
3876: 'EXCEPTION(NO_DATA_FOUND) : Customer Trx Type Id');
3877: app_exception.raise_exception;
3878:
3879: WHEN OTHERS THEN

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

3876: 'EXCEPTION(NO_DATA_FOUND) : Customer Trx Type Id');
3877: app_exception.raise_exception;
3878:
3879: WHEN OTHERS THEN
3880: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3881: fnd_message.set_token('GENERIC_TEXT',
3882: 'EXCEPTION(OTHERS) : Customer Trx Type Id : ' || sqlerrm);
3883: app_exception.raise_exception;
3884: END;

Line 3881: fnd_message.set_token('GENERIC_TEXT',

3877: app_exception.raise_exception;
3878:
3879: WHEN OTHERS THEN
3880: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3881: fnd_message.set_token('GENERIC_TEXT',
3882: 'EXCEPTION(OTHERS) : Customer Trx Type Id : ' || sqlerrm);
3883: app_exception.raise_exception;
3884: END;
3885:

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

3938: IF (g_level_unexpected >= g_current_runtime_level) THEN
3939: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Could not derive global_attribute1 from hr_locations for org_id: '||
3940: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id(p_index));
3941: END IF;
3942: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3943: fnd_message.set_token('GENERIC_TEXT',
3944: 'EXCEPTION(NO_DATA_FOUND) : Organization Class');
3945: app_exception.raise_exception;
3946: WHEN OTHERS THEN

Line 3943: fnd_message.set_token('GENERIC_TEXT',

3939: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Could not derive global_attribute1 from hr_locations for org_id: '||
3940: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id(p_index));
3941: END IF;
3942: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3943: fnd_message.set_token('GENERIC_TEXT',
3944: 'EXCEPTION(NO_DATA_FOUND) : Organization Class');
3945: app_exception.raise_exception;
3946: WHEN OTHERS THEN
3947: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

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

3943: fnd_message.set_token('GENERIC_TEXT',
3944: 'EXCEPTION(NO_DATA_FOUND) : Organization Class');
3945: app_exception.raise_exception;
3946: WHEN OTHERS THEN
3947: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3948: fnd_message.set_token('GENERIC_TEXT',
3949: 'EXCEPTION(OTHERS) : Organization Class : ' || sqlcode||' , '||sqlerrm);
3950: app_exception.raise_exception;
3951: END;

Line 3948: fnd_message.set_token('GENERIC_TEXT',

3944: 'EXCEPTION(NO_DATA_FOUND) : Organization Class');
3945: app_exception.raise_exception;
3946: WHEN OTHERS THEN
3947: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3948: fnd_message.set_token('GENERIC_TEXT',
3949: 'EXCEPTION(OTHERS) : Organization Class : ' || sqlcode||' , '||sqlerrm);
3950: app_exception.raise_exception;
3951: END;
3952: tax_info_rec.usern4 := l_location_id;

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

4001: AND NVL(tax_class,'O') = 'O'
4002: AND ORG_ID = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id(p_index) ;
4003: EXCEPTION
4004: WHEN NO_DATA_FOUND THEN
4005: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4006: fnd_message.set_token('GENERIC_TEXT',
4007: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
4008: app_exception.raise_exception;
4009: WHEN OTHERS THEN

Line 4006: fnd_message.set_token('GENERIC_TEXT',

4002: AND ORG_ID = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id(p_index) ;
4003: EXCEPTION
4004: WHEN NO_DATA_FOUND THEN
4005: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4006: fnd_message.set_token('GENERIC_TEXT',
4007: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
4008: app_exception.raise_exception;
4009: WHEN OTHERS THEN
4010: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

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

4006: fnd_message.set_token('GENERIC_TEXT',
4007: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
4008: app_exception.raise_exception;
4009: WHEN OTHERS THEN
4010: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4011: fnd_message.set_token('GENERIC_TEXT',
4012: 'EXCEPTION(OTHERS) : Tax Code : ' || sqlerrm);
4013: app_exception.raise_exception;
4014: END;

Line 4011: fnd_message.set_token('GENERIC_TEXT',

4007: 'EXCEPTION(NO_DATA_FOUND) : Tax Code');
4008: app_exception.raise_exception;
4009: WHEN OTHERS THEN
4010: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4011: fnd_message.set_token('GENERIC_TEXT',
4012: 'EXCEPTION(OTHERS) : Tax Code : ' || sqlerrm);
4013: app_exception.raise_exception;
4014: END;
4015: -- Bug 4028732 comment out END IF;