DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on FND_MESSAGE

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

869: END IF;
870:
871: EXCEPTION
872: WHEN TOO_MANY_ROWS THEN
873: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
874: fnd_message.set_token('GENERIC_TEXT',
875: 'EXCEPTION(TOO_MANY_ROWS): jl_zz_tax.get_rule_info');
876: IF (g_level_unexpected >= g_current_runtime_level) THEN
877: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(TOO_MANY_ROWS): jl_zz_tax.get_rule_info');

Line 874: fnd_message.set_token('GENERIC_TEXT',

870:
871: EXCEPTION
872: WHEN TOO_MANY_ROWS THEN
873: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
874: fnd_message.set_token('GENERIC_TEXT',
875: 'EXCEPTION(TOO_MANY_ROWS): jl_zz_tax.get_rule_info');
876: IF (g_level_unexpected >= g_current_runtime_level) THEN
877: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(TOO_MANY_ROWS): jl_zz_tax.get_rule_info');
878: END IF;

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

1342: END IF;
1343:
1344: EXCEPTION
1345: WHEN NO_DATA_FOUND THEN
1346: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1347: fnd_message.set_token('GENERIC_TEXT',
1348: 'No valid tax code found: jl_zz_tax.get_category_tax_rule');
1349: IF (g_level_unexpected >= g_current_runtime_level) THEN
1350: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(NO_DATA_FOUND): jl_zz_tax.get_category_tax_rule');

Line 1347: fnd_message.set_token('GENERIC_TEXT',

1343:
1344: EXCEPTION
1345: WHEN NO_DATA_FOUND THEN
1346: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1347: fnd_message.set_token('GENERIC_TEXT',
1348: 'No valid tax code found: jl_zz_tax.get_category_tax_rule');
1349: IF (g_level_unexpected >= g_current_runtime_level) THEN
1350: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(NO_DATA_FOUND): jl_zz_tax.get_category_tax_rule');
1351: END IF;

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

2971: AND p_trx_date >= vt.start_date
2972: AND p_trx_date <= nvl(vt.end_date,p_trx_date)
2973: AND rownum = 1;
2974:
2975: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
2976: fnd_message.set_token('GENERIC_TEXT', 'Could not expand tax group successfully');
2977: app_exception.raise_exception;
2978: EXCEPTION
2979: WHEN NO_DATA_FOUND THEN

Line 2976: fnd_message.set_token('GENERIC_TEXT', 'Could not expand tax group successfully');

2972: AND p_trx_date <= nvl(vt.end_date,p_trx_date)
2973: AND rownum = 1;
2974:
2975: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
2976: fnd_message.set_token('GENERIC_TEXT', 'Could not expand tax group successfully');
2977: app_exception.raise_exception;
2978: EXCEPTION
2979: WHEN NO_DATA_FOUND THEN
2980: p_taxable_basis := 'QUANTITY';

Line 3280: FND_MESSAGE.SET_NAME('JL','JL_ZZ_AR_TX_INVALID_TAX_GROUP');

3276: END IF;
3277:
3278: EXCEPTION
3279: WHEN ERROR_FROM_FUNCTION THEN
3280: FND_MESSAGE.SET_NAME('JL','JL_ZZ_AR_TX_INVALID_TAX_GROUP');
3281: p_latin_return_code := FND_MESSAGE.GET;
3282: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
3283: p_customer_trx_line_id;
3284:

Line 3281: p_latin_return_code := FND_MESSAGE.GET;

3277:
3278: EXCEPTION
3279: WHEN ERROR_FROM_FUNCTION THEN
3280: FND_MESSAGE.SET_NAME('JL','JL_ZZ_AR_TX_INVALID_TAX_GROUP');
3281: p_latin_return_code := FND_MESSAGE.GET;
3282: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
3283: p_customer_trx_line_id;
3284:
3285: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=

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

3863: IF (g_level_statement >= g_current_runtime_level) THEN
3864: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','calculate_latin_tax: ' || 'EXCEPTION(ERROR_FROM_FUNCTION): '||
3865: 'jl_zz_tax.calculate_latin_tax ' ||v_calculate_return_code);
3866: END IF;
3867: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3868: fnd_message.set_token('GENERIC_TEXT',
3869: 'EXCEPTION(ERROR_FROM_FUNCTION): jl_zz_tax.calculate_latin_tax '||
3870: v_calculate_return_code);
3871: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;

Line 3868: fnd_message.set_token('GENERIC_TEXT',

3864: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','calculate_latin_tax: ' || 'EXCEPTION(ERROR_FROM_FUNCTION): '||
3865: 'jl_zz_tax.calculate_latin_tax ' ||v_calculate_return_code);
3866: END IF;
3867: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3868: fnd_message.set_token('GENERIC_TEXT',
3869: 'EXCEPTION(ERROR_FROM_FUNCTION): jl_zz_tax.calculate_latin_tax '||
3870: v_calculate_return_code);
3871: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
3872: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=

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

3880:
3881:
3882:
3883: WHEN ERROR_FROM_FUNCTION THEN
3884: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3885: fnd_message.set_token('GENERIC_TEXT',
3886: 'EXCEPTION(ERROR_FROM_FUNCTION): jl_zz_tax.calculate_latin_tax');
3887: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
3888: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=

Line 3885: fnd_message.set_token('GENERIC_TEXT',

3881:
3882:
3883: WHEN ERROR_FROM_FUNCTION THEN
3884: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3885: fnd_message.set_token('GENERIC_TEXT',
3886: 'EXCEPTION(ERROR_FROM_FUNCTION): jl_zz_tax.calculate_latin_tax');
3887: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
3888: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
3889: p_customer_trx_line_id;

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

3899: 'jl_zz_tax.calculate_latin_tax');
3900: END IF;
3901:
3902: WHEN NO_DATA_FOUND THEN
3903: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3904: fnd_message.set_token('GENERIC_TEXT',
3905: 'EXCEPTION(NO_DATA_FOUND): jl_zz_tax.calculate_latin_tax');
3906: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
3907: IF (g_level_statement >= g_current_runtime_level) THEN

Line 3904: fnd_message.set_token('GENERIC_TEXT',

3900: END IF;
3901:
3902: WHEN NO_DATA_FOUND THEN
3903: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3904: fnd_message.set_token('GENERIC_TEXT',
3905: 'EXCEPTION(NO_DATA_FOUND): jl_zz_tax.calculate_latin_tax');
3906: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
3907: IF (g_level_statement >= g_current_runtime_level) THEN
3908: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','calculate_latin_tax: ' || 'EXCEPTION(NO_DATA_FOUND): '||

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

3909: 'jl_zz_tax.calculate_latin_tax');
3910: END IF;
3911:
3912: WHEN TOO_MANY_ROWS THEN
3913: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3914: fnd_message.set_token('GENERIC_TEXT',
3915: 'EXCEPTION(TOO_MANY_ROWS): jl_zz_tax.calculate_latin_tax');
3916: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
3917: IF (g_level_statement >= g_current_runtime_level) THEN

Line 3914: fnd_message.set_token('GENERIC_TEXT',

3910: END IF;
3911:
3912: WHEN TOO_MANY_ROWS THEN
3913: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3914: fnd_message.set_token('GENERIC_TEXT',
3915: 'EXCEPTION(TOO_MANY_ROWS): jl_zz_tax.calculate_latin_tax');
3916: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
3917: IF (g_level_statement >= g_current_runtime_level) THEN
3918: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','calculate_latin_tax: ' || 'EXCEPTION(TOO_MANY_ROWS): '||

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

3921:
3922: WHEN OTHERS THEN
3923: err_num := SQLCODE;
3924: err_msg := SUBSTR(SQLERRM,1,100);
3925: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3926: fnd_message.set_token('GENERIC_TEXT',
3927: 'EXCEPTION(OTHERS): jl_zz_tax.calculate_latin_tax '||
3928: to_char(err_num)||' '||err_msg);
3929: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;

Line 3926: fnd_message.set_token('GENERIC_TEXT',

3922: WHEN OTHERS THEN
3923: err_num := SQLCODE;
3924: err_msg := SUBSTR(SQLERRM,1,100);
3925: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
3926: fnd_message.set_token('GENERIC_TEXT',
3927: 'EXCEPTION(OTHERS): jl_zz_tax.calculate_latin_tax '||
3928: to_char(err_num)||' '||err_msg);
3929: o_latin_return_code := ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR;
3930: IF (g_level_statement >= g_current_runtime_level) THEN

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

4112: ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag <> 'N' THEN
4113: IF (g_level_statement >= g_current_runtime_level) THEN
4114: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Amount Includes flag should be N');
4115: END IF;
4116: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4117: fnd_message.set_token('GENERIC_TEXT',
4118: 'Amount Includes flag should be N');
4119: app_exception.raise_exception;
4120: END IF;

Line 4117: fnd_message.set_token('GENERIC_TEXT',

4113: IF (g_level_statement >= g_current_runtime_level) THEN
4114: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Amount Includes flag should be N');
4115: END IF;
4116: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4117: fnd_message.set_token('GENERIC_TEXT',
4118: 'Amount Includes flag should be N');
4119: app_exception.raise_exception;
4120: END IF;
4121: */

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

4482: RETURN (v_latin_tax_return_code);
4483:
4484: EXCEPTION
4485: WHEN ERROR_FROM_FUNCTION THEN
4486: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4487: fnd_message.set_token('GENERIC_TEXT',
4488: 'EXCEPTION(ERROR_FROM_FUNCTION): jl_zz_tax.calculate');
4489: IF (g_level_unexpected >= g_current_runtime_level) THEN
4490: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(ERROR_FROM_FUNCTION): jl_zz_tax.calculate');

Line 4487: fnd_message.set_token('GENERIC_TEXT',

4483:
4484: EXCEPTION
4485: WHEN ERROR_FROM_FUNCTION THEN
4486: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4487: fnd_message.set_token('GENERIC_TEXT',
4488: 'EXCEPTION(ERROR_FROM_FUNCTION): jl_zz_tax.calculate');
4489: IF (g_level_unexpected >= g_current_runtime_level) THEN
4490: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(ERROR_FROM_FUNCTION): jl_zz_tax.calculate');
4491: END IF;

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

4501:
4502: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);
4503:
4504: WHEN NO_DATA_FOUND THEN
4505: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4506: fnd_message.set_token('GENERIC_TEXT',
4507: 'EXCEPTION(NO_DATA_FOUND): jl_zz_tax.calculate');
4508: IF (g_level_unexpected >= g_current_runtime_level) THEN
4509: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(NO_DATA_FOUND): jl_zz_tax.calculate');

Line 4506: fnd_message.set_token('GENERIC_TEXT',

4502: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);
4503:
4504: WHEN NO_DATA_FOUND THEN
4505: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4506: fnd_message.set_token('GENERIC_TEXT',
4507: 'EXCEPTION(NO_DATA_FOUND): jl_zz_tax.calculate');
4508: IF (g_level_unexpected >= g_current_runtime_level) THEN
4509: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(NO_DATA_FOUND): jl_zz_tax.calculate');
4510: END IF;

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

4510: END IF;
4511: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);
4512:
4513: WHEN TOO_MANY_ROWS THEN
4514: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4515: fnd_message.set_token('GENERIC_TEXT',
4516: 'EXCEPTION(TOO_MANY_ROWS): jl_zz_tax.calculate');
4517: IF (g_level_unexpected >= g_current_runtime_level) THEN
4518: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(TOO_MANY_ROWS): jl_zz_tax.calculate');

Line 4515: fnd_message.set_token('GENERIC_TEXT',

4511: RETURN (ZX_PRODUCT_INTEGRATION_PKG.TAX_RC_OERR);
4512:
4513: WHEN TOO_MANY_ROWS THEN
4514: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4515: fnd_message.set_token('GENERIC_TEXT',
4516: 'EXCEPTION(TOO_MANY_ROWS): jl_zz_tax.calculate');
4517: IF (g_level_unexpected >= g_current_runtime_level) THEN
4518: FND_LOG.STRING(g_level_unexpected,'ZX.PLSQL.JL_ZZ_TAX','EXCEPTION(TOO_MANY_ROWS): jl_zz_tax.calculate');
4519: END IF;

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

4521:
4522: WHEN OTHERS THEN
4523: err_num := SQLCODE;
4524: err_msg := SUBSTR(SQLERRM,1,100);
4525: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4526: fnd_message.set_token('GENERIC_TEXT',
4527: 'EXCEPTION(OTHERS): jl_zz_tax.calculate '||
4528: to_char(err_num)||' '
4529: ||err_msg);

Line 4526: fnd_message.set_token('GENERIC_TEXT',

4522: WHEN OTHERS THEN
4523: err_num := SQLCODE;
4524: err_msg := SUBSTR(SQLERRM,1,100);
4525: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
4526: fnd_message.set_token('GENERIC_TEXT',
4527: 'EXCEPTION(OTHERS): jl_zz_tax.calculate '||
4528: to_char(err_num)||' '
4529: ||err_msg);
4530: IF (g_level_unexpected >= g_current_runtime_level) THEN

Line 4612: fnd_message.set_name('JL', 'JL_LEGAL_MESSAGE_NOT_FOUND');

4608: RETURN(v_message_text);
4609:
4610: EXCEPTION
4611: WHEN NO_DATA_FOUND THEN
4612: fnd_message.set_name('JL', 'JL_LEGAL_MESSAGE_NOT_FOUND');
4613: fnd_message.set_token('RULE_CODE',v_rule);
4614: fnd_message.set_token('EXCEPTION_CODE',p_legal_message_exception);
4615: RETURN ('ERROR');
4616:

Line 4613: fnd_message.set_token('RULE_CODE',v_rule);

4609:
4610: EXCEPTION
4611: WHEN NO_DATA_FOUND THEN
4612: fnd_message.set_name('JL', 'JL_LEGAL_MESSAGE_NOT_FOUND');
4613: fnd_message.set_token('RULE_CODE',v_rule);
4614: fnd_message.set_token('EXCEPTION_CODE',p_legal_message_exception);
4615: RETURN ('ERROR');
4616:
4617: END get_legal_message;

Line 4614: fnd_message.set_token('EXCEPTION_CODE',p_legal_message_exception);

4610: EXCEPTION
4611: WHEN NO_DATA_FOUND THEN
4612: fnd_message.set_name('JL', 'JL_LEGAL_MESSAGE_NOT_FOUND');
4613: fnd_message.set_token('RULE_CODE',v_rule);
4614: fnd_message.set_token('EXCEPTION_CODE',p_legal_message_exception);
4615: RETURN ('ERROR');
4616:
4617: END get_legal_message;
4618: