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.JMF_GTA_ARTRX_PROC dependencies on FND_MESSAGE

Line 89: --| the token value by "fnd_message.set_token

85: --| procedure Retrieve_AR_TRXs for bug 5224923
86: --| 12/06/2006 Shujuan Yan Modify the procedure
87: --| Retrieve_AR_TRXs, Get line_number from
88: --| ra_customer_trx_lines_all, Change Change
89: --| the token value by "fnd_message.set_token
90: --| ('NUM', l_customer_trx_line_number)"
91: --| instead of "fnd_message.set_token('NUM',
92: --| l_customer_trx_line_id)" for bug 5230712
93: --| 12/06/2006 Shujuan Yan Modify the procedure Retrieve

Line 91: --| instead of "fnd_message.set_token('NUM',

87: --| Retrieve_AR_TRXs, Get line_number from
88: --| ra_customer_trx_lines_all, Change Change
89: --| the token value by "fnd_message.set_token
90: --| ('NUM', l_customer_trx_line_number)"
91: --| instead of "fnd_message.set_token('NUM',
92: --| l_customer_trx_line_id)" for bug 5230712
93: --| 12/06/2006 Shujuan Yan Modify the procedure Retrieve
94: --| _AR_TRXs, Change the token value by
95: --| "fnd_message.set_token('ITEM', l_inventory

Line 95: --| "fnd_message.set_token('ITEM', l_inventory

91: --| instead of "fnd_message.set_token('NUM',
92: --| l_customer_trx_line_id)" for bug 5230712
93: --| 12/06/2006 Shujuan Yan Modify the procedure Retrieve
94: --| _AR_TRXs, Change the token value by
95: --| "fnd_message.set_token('ITEM', l_inventory
96: --| _item_name )" instead of "fnd_message.set
97: --| _token('ITEM', l_inventory_item_id)" for
98: -- bug 5230712
99: --| 29/06/2006 Shujuan Yan Modify the procedure Retrieve

Line 96: --| _item_name )" instead of "fnd_message.set

92: --| l_customer_trx_line_id)" for bug 5230712
93: --| 12/06/2006 Shujuan Yan Modify the procedure Retrieve
94: --| _AR_TRXs, Change the token value by
95: --| "fnd_message.set_token('ITEM', l_inventory
96: --| _item_name )" instead of "fnd_message.set
97: --| _token('ITEM', l_inventory_item_id)" for
98: -- bug 5230712
99: --| 29/06/2006 Shujuan Yan Modify the procedure Retrieve
100: --| _AR_TRXs,Add if l_ctt_class = 'CM' clause,

Line 107: --| "fnd_message.set_token('NUM', l_customer_

103: --| corresponding invoice for bug 5263131
104: --| 29/06/2006 Shujuan Yan Modify the procedure Retrieve
105: --| _AR_TRXs, Get line_number from ra_customer
106: --| _trx_lines_all, Change the token value by
107: --| "fnd_message.set_token('NUM', l_customer_
108: --| trx_line_number)" instead of "fnd_message
109: --| .set_token('NUM', l_customer_trx_line_id)"
110: --| for bug 5258522
111: --| 29/06/2006 Shujuan Yan Modify Retrieve_AR_TRXs, get l_

Line 108: --| trx_line_number)" instead of "fnd_message

104: --| 29/06/2006 Shujuan Yan Modify the procedure Retrieve
105: --| _AR_TRXs, Get line_number from ra_customer
106: --| _trx_lines_all, Change the token value by
107: --| "fnd_message.set_token('NUM', l_customer_
108: --| trx_line_number)" instead of "fnd_message
109: --| .set_token('NUM', l_customer_trx_line_id)"
110: --| for bug 5258522
111: --| 29/06/2006 Shujuan Yan Modify Retrieve_AR_TRXs, get l_
112: --| tax_curr_unit_price from procedure Get_Info

Line 1131: fnd_message.SET_NAME('JMF', 'JMF_GTA_RULE_MISSING_ERROR');

1127:
1128: /* EXCEPTION
1129: -- no data found , raise a data error
1130: WHEN no_data_found THEN
1131: fnd_message.SET_NAME('JMF', 'JMF_GTA_RULE_MISSING_ERROR');
1132: l_error_string := fnd_message.get();
1133: -- output error
1134: fnd_file.put_line(fnd_file.output, '
1135:

Line 1132: l_error_string := fnd_message.get();

1128: /* EXCEPTION
1129: -- no data found , raise a data error
1130: WHEN no_data_found THEN
1131: fnd_message.SET_NAME('JMF', 'JMF_GTA_RULE_MISSING_ERROR');
1132: l_error_string := fnd_message.get();
1133: -- output error
1134: fnd_file.put_line(fnd_file.output, '
1135:
1136: Y

Line 1173: fnd_message.SET_NAME('JMF', 'JMF_GTA_TRX_TYP_MAP_MISSING');

1169: EXCEPTION
1170:
1171: -- no data found, raise a data error
1172: WHEN no_data_found THEN
1173: fnd_message.SET_NAME('JMF', 'JMF_GTA_TRX_TYP_MAP_MISSING');
1174: l_error_string := fnd_message.get();
1175: -- output error
1176: fnd_file.put_line(fnd_file.output,
1177: '

Line 1174: l_error_string := fnd_message.get();

1170:
1171: -- no data found, raise a data error
1172: WHEN no_data_found THEN
1173: fnd_message.SET_NAME('JMF', 'JMF_GTA_TRX_TYP_MAP_MISSING');
1174: l_error_string := fnd_message.get();
1175: -- output error
1176: fnd_file.put_line(fnd_file.output,
1177: '
1178:

Line 1808: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_ERROR');

1804: WHERE rule.rule_header_id = p_transfer_id;
1805: EXCEPTION
1806: -- no data found , raise a data error
1807: WHEN no_data_found THEN
1808: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_ERROR');
1809: l_error_string := fnd_message.get();
1810:
1811: -- output error
1812: fnd_file.put_line(fnd_file.output,

Line 1809: l_error_string := fnd_message.get();

1805: EXCEPTION
1806: -- no data found , raise a data error
1807: WHEN no_data_found THEN
1808: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_ERROR');
1809: l_error_string := fnd_message.get();
1810:
1811: -- output error
1812: fnd_file.put_line(fnd_file.output,
1813: '

Line 1839: fnd_message.SET_NAME('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');

1835: WHERE op.org_id = p_ORG_ID;
1836: EXCEPTION
1837: -- no data found , raise a data error
1838: WHEN no_data_found THEN
1839: fnd_message.SET_NAME('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');
1840: fnd_message.set_token('Tax_Regis_Number', ' ');
1841: l_error_string := fnd_message.get();
1842:
1843: -- output error

Line 1840: fnd_message.set_token('Tax_Regis_Number', ' ');

1836: EXCEPTION
1837: -- no data found , raise a data error
1838: WHEN no_data_found THEN
1839: fnd_message.SET_NAME('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');
1840: fnd_message.set_token('Tax_Regis_Number', ' ');
1841: l_error_string := fnd_message.get();
1842:
1843: -- output error
1844: fnd_file.put_line(fnd_file.output,

Line 1841: l_error_string := fnd_message.get();

1837: -- no data found , raise a data error
1838: WHEN no_data_found THEN
1839: fnd_message.SET_NAME('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');
1840: fnd_message.set_token('Tax_Regis_Number', ' ');
1841: l_error_string := fnd_message.get();
1842:
1843: -- output error
1844: fnd_file.put_line(fnd_file.output,
1845: '

Line 2175: fnd_message.set_name('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');

2171:
2172: EXCEPTION
2173: WHEN no_data_found THEN
2174: --report JMF_GTA_MISSING_ERROR
2175: fnd_message.set_name('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');
2176: fnd_message.set_token('Tax_Regis_Number', ' ');
2177: l_error_string := fnd_message.get();
2178: -- output this error
2179: fnd_file.put_line(fnd_file.output,

Line 2176: fnd_message.set_token('Tax_Regis_Number', ' ');

2172: EXCEPTION
2173: WHEN no_data_found THEN
2174: --report JMF_GTA_MISSING_ERROR
2175: fnd_message.set_name('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');
2176: fnd_message.set_token('Tax_Regis_Number', ' ');
2177: l_error_string := fnd_message.get();
2178: -- output this error
2179: fnd_file.put_line(fnd_file.output,
2180: '

Line 2177: l_error_string := fnd_message.get();

2173: WHEN no_data_found THEN
2174: --report JMF_GTA_MISSING_ERROR
2175: fnd_message.set_name('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');
2176: fnd_message.set_token('Tax_Regis_Number', ' ');
2177: l_error_string := fnd_message.get();
2178: -- output this error
2179: fnd_file.put_line(fnd_file.output,
2180: '
2181:

Line 2207: fnd_message.SET_NAME('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');

2203: WHERE jmf_gta_rule_headers_all.rule_header_id = p_transfer_id;
2204: EXCEPTION
2205: -- no data found , raise a data error
2206: WHEN no_data_found THEN
2207: fnd_message.SET_NAME('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');
2208: fnd_message.set_token('Tax_Regis_Number', ' ');
2209: l_error_string := fnd_message.get();
2210: -- output error
2211: fnd_file.put_line(fnd_file.output,

Line 2208: fnd_message.set_token('Tax_Regis_Number', ' ');

2204: EXCEPTION
2205: -- no data found , raise a data error
2206: WHEN no_data_found THEN
2207: fnd_message.SET_NAME('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');
2208: fnd_message.set_token('Tax_Regis_Number', ' ');
2209: l_error_string := fnd_message.get();
2210: -- output error
2211: fnd_file.put_line(fnd_file.output,
2212: '

Line 2209: l_error_string := fnd_message.get();

2205: -- no data found , raise a data error
2206: WHEN no_data_found THEN
2207: fnd_message.SET_NAME('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');
2208: fnd_message.set_token('Tax_Regis_Number', ' ');
2209: l_error_string := fnd_message.get();
2210: -- output error
2211: fnd_file.put_line(fnd_file.output,
2212: '
2213:

Line 2753: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_FIELD');

2749: IF l_uom_code IS NULL
2750: OR (l_quantity_invoiced IS NULL AND l_quantity_credited IS NULL)
2751: THEN
2752:
2753: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_FIELD');
2754: --fnd_message.set_token('NUM', l_customer_trx_line_id);
2755: l_error_string := fnd_message.GET();
2756:
2757: -- begin log

Line 2754: --fnd_message.set_token('NUM', l_customer_trx_line_id);

2750: OR (l_quantity_invoiced IS NULL AND l_quantity_credited IS NULL)
2751: THEN
2752:
2753: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_FIELD');
2754: --fnd_message.set_token('NUM', l_customer_trx_line_id);
2755: l_error_string := fnd_message.GET();
2756:
2757: -- begin log
2758: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 2755: l_error_string := fnd_message.GET();

2751: THEN
2752:
2753: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_FIELD');
2754: --fnd_message.set_token('NUM', l_customer_trx_line_id);
2755: l_error_string := fnd_message.GET();
2756:
2757: -- begin log
2758: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2759: THEN

Line 2941: fnd_message.SET_NAME('JMF', 'JMF_GTA_CREDMEMO_EXPORT_IV');

2937: INTO l_gt_invoice_number,l_gt_invoice_class
2938: FROM Jmf_Gta_Trx_Headers_All
2939: WHERE ra_trx_id = l_pre_cus_trxid
2940: AND source='GT';
2941: fnd_message.SET_NAME('JMF', 'JMF_GTA_CREDMEMO_EXPORT_IV');
2942: l_cm_desc1:=fnd_message.GET();
2943: fnd_message.SET_NAME('JMF', 'JMF_GTA_CREDMEMO_EXPORT_NR');
2944: l_cm_desc2:=fnd_message.GET();
2945: l_trx_header.description :=l_cm_desc1||l_gt_invoice_class||' '||l_cm_desc2||l_gt_invoice_number;

Line 2942: l_cm_desc1:=fnd_message.GET();

2938: FROM Jmf_Gta_Trx_Headers_All
2939: WHERE ra_trx_id = l_pre_cus_trxid
2940: AND source='GT';
2941: fnd_message.SET_NAME('JMF', 'JMF_GTA_CREDMEMO_EXPORT_IV');
2942: l_cm_desc1:=fnd_message.GET();
2943: fnd_message.SET_NAME('JMF', 'JMF_GTA_CREDMEMO_EXPORT_NR');
2944: l_cm_desc2:=fnd_message.GET();
2945: l_trx_header.description :=l_cm_desc1||l_gt_invoice_class||' '||l_cm_desc2||l_gt_invoice_number;
2946: --Yao Zhang add end for bug 7685610--

Line 2943: fnd_message.SET_NAME('JMF', 'JMF_GTA_CREDMEMO_EXPORT_NR');

2939: WHERE ra_trx_id = l_pre_cus_trxid
2940: AND source='GT';
2941: fnd_message.SET_NAME('JMF', 'JMF_GTA_CREDMEMO_EXPORT_IV');
2942: l_cm_desc1:=fnd_message.GET();
2943: fnd_message.SET_NAME('JMF', 'JMF_GTA_CREDMEMO_EXPORT_NR');
2944: l_cm_desc2:=fnd_message.GET();
2945: l_trx_header.description :=l_cm_desc1||l_gt_invoice_class||' '||l_cm_desc2||l_gt_invoice_number;
2946: --Yao Zhang add end for bug 7685610--
2947: END IF; --/*l_gt_invoice_count = 0 */

Line 2944: l_cm_desc2:=fnd_message.GET();

2940: AND source='GT';
2941: fnd_message.SET_NAME('JMF', 'JMF_GTA_CREDMEMO_EXPORT_IV');
2942: l_cm_desc1:=fnd_message.GET();
2943: fnd_message.SET_NAME('JMF', 'JMF_GTA_CREDMEMO_EXPORT_NR');
2944: l_cm_desc2:=fnd_message.GET();
2945: l_trx_header.description :=l_cm_desc1||l_gt_invoice_class||' '||l_cm_desc2||l_gt_invoice_number;
2946: --Yao Zhang add end for bug 7685610--
2947: END IF; --/*l_gt_invoice_count = 0 */
2948: END IF; --/* l_ar_invoice_count =0*/

Line 2957: fnd_message.SET_NAME('JMF', 'JMF_GTA_CRMEMO_DES_NULL');

2953:
2954: IF (l_cm_warn = true) THEN
2955: --if credit memo not associated with any AR inv or associated with multi AR inv
2956:
2957: fnd_message.SET_NAME('JMF', 'JMF_GTA_CRMEMO_DES_NULL');
2958: l_error_string := fnd_message.GET();
2959: IF (FND_LOG.LEVEL_UNEXPECTED >=
2960: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2961: log(FND_LOG.LEVEL_PROCEDURE,

Line 2958: l_error_string := fnd_message.GET();

2954: IF (l_cm_warn = true) THEN
2955: --if credit memo not associated with any AR inv or associated with multi AR inv
2956:
2957: fnd_message.SET_NAME('JMF', 'JMF_GTA_CRMEMO_DES_NULL');
2958: l_error_string := fnd_message.GET();
2959: IF (FND_LOG.LEVEL_UNEXPECTED >=
2960: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2961: log(FND_LOG.LEVEL_PROCEDURE,
2962: G_MODULE_PREFIX || l_procedure_name,

Line 3009: fnd_message.SET_NAME('JMF', 'JMF_GTA_CRMEMO_MISSING_GTINV');

3005:
3006: IF (l_gt_inv_excep = true or l_ar_inv_excep = true) THEN
3007: --if credit memo associated with AR and in GTA but not VAT generated for non-common VAT
3008: --rasie correspoding AR transation not in GT warning.
3009: fnd_message.SET_NAME('JMF', 'JMF_GTA_CRMEMO_MISSING_GTINV');
3010: l_error_string := fnd_message.GET();
3011: IF (FND_LOG.LEVEL_UNEXPECTED >=
3012: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3013: log(FND_LOG.LEVEL_PROCEDURE,

Line 3010: l_error_string := fnd_message.GET();

3006: IF (l_gt_inv_excep = true or l_ar_inv_excep = true) THEN
3007: --if credit memo associated with AR and in GTA but not VAT generated for non-common VAT
3008: --rasie correspoding AR transation not in GT warning.
3009: fnd_message.SET_NAME('JMF', 'JMF_GTA_CRMEMO_MISSING_GTINV');
3010: l_error_string := fnd_message.GET();
3011: IF (FND_LOG.LEVEL_UNEXPECTED >=
3012: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3013: log(FND_LOG.LEVEL_PROCEDURE,
3014: G_MODULE_PREFIX || l_procedure_name,

Line 3132: fnd_message.SET_NAME('JMF', l_proce_error_buffer);

3128: AND rct.org_id = rctt.org_id(+)
3129: AND rct.customer_trx_id = l_customer_trx_id
3130: AND rct.org_id = p_org_id;
3131:
3132: fnd_message.SET_NAME('JMF', l_proce_error_buffer);
3133: fnd_message.set_token('TRX_TYP', l_trx_typ);
3134: fnd_message.set_token('TAX_REG_NUM',
3135: l_fp_registration_number);
3136: l_error_string := fnd_message.GET();

Line 3133: fnd_message.set_token('TRX_TYP', l_trx_typ);

3129: AND rct.customer_trx_id = l_customer_trx_id
3130: AND rct.org_id = p_org_id;
3131:
3132: fnd_message.SET_NAME('JMF', l_proce_error_buffer);
3133: fnd_message.set_token('TRX_TYP', l_trx_typ);
3134: fnd_message.set_token('TAX_REG_NUM',
3135: l_fp_registration_number);
3136: l_error_string := fnd_message.GET();
3137:

Line 3134: fnd_message.set_token('TAX_REG_NUM',

3130: AND rct.org_id = p_org_id;
3131:
3132: fnd_message.SET_NAME('JMF', l_proce_error_buffer);
3133: fnd_message.set_token('TRX_TYP', l_trx_typ);
3134: fnd_message.set_token('TAX_REG_NUM',
3135: l_fp_registration_number);
3136: l_error_string := fnd_message.GET();
3137:
3138: -- begin log

Line 3136: l_error_string := fnd_message.GET();

3132: fnd_message.SET_NAME('JMF', l_proce_error_buffer);
3133: fnd_message.set_token('TRX_TYP', l_trx_typ);
3134: fnd_message.set_token('TAX_REG_NUM',
3135: l_fp_registration_number);
3136: l_error_string := fnd_message.GET();
3137:
3138: -- begin log
3139: IF (FND_LOG.LEVEL_PROCEDURE >=
3140: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3150: fnd_message.SET_NAME('JMF', l_proce_error_buffer);

3146: -- end log
3147:
3148: ELSIF l_proce_error_buffer = 'JMF_GTA_TAX_ERROR_RECYCLE' THEN
3149:
3150: fnd_message.SET_NAME('JMF', l_proce_error_buffer);
3151: l_error_string := fnd_message.GET();
3152:
3153: -- begin log
3154: IF (FND_LOG.LEVEL_PROCEDURE >=

Line 3151: l_error_string := fnd_message.GET();

3147:
3148: ELSIF l_proce_error_buffer = 'JMF_GTA_TAX_ERROR_RECYCLE' THEN
3149:
3150: fnd_message.SET_NAME('JMF', l_proce_error_buffer);
3151: l_error_string := fnd_message.GET();
3152:
3153: -- begin log
3154: IF (FND_LOG.LEVEL_PROCEDURE >=
3155: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3164: fnd_message.SET_NAME('JMF', l_proce_error_buffer);

3160: END IF;
3161: -- end log
3162: ELSE
3163:
3164: fnd_message.SET_NAME('JMF', l_proce_error_buffer);
3165: fnd_message.set_token('NUM', l_customer_trx_line_number);
3166: fnd_message.set_token('TAXTYPE', l_vat_tax_type);
3167: l_error_string := fnd_message.GET();
3168:

Line 3165: fnd_message.set_token('NUM', l_customer_trx_line_number);

3161: -- end log
3162: ELSE
3163:
3164: fnd_message.SET_NAME('JMF', l_proce_error_buffer);
3165: fnd_message.set_token('NUM', l_customer_trx_line_number);
3166: fnd_message.set_token('TAXTYPE', l_vat_tax_type);
3167: l_error_string := fnd_message.GET();
3168:
3169: -- begin log

Line 3166: fnd_message.set_token('TAXTYPE', l_vat_tax_type);

3162: ELSE
3163:
3164: fnd_message.SET_NAME('JMF', l_proce_error_buffer);
3165: fnd_message.set_token('NUM', l_customer_trx_line_number);
3166: fnd_message.set_token('TAXTYPE', l_vat_tax_type);
3167: l_error_string := fnd_message.GET();
3168:
3169: -- begin log
3170: IF (FND_LOG.LEVEL_PROCEDURE >=

Line 3167: l_error_string := fnd_message.GET();

3163:
3164: fnd_message.SET_NAME('JMF', l_proce_error_buffer);
3165: fnd_message.set_token('NUM', l_customer_trx_line_number);
3166: fnd_message.set_token('TAXTYPE', l_vat_tax_type);
3167: l_error_string := fnd_message.GET();
3168:
3169: -- begin log
3170: IF (FND_LOG.LEVEL_PROCEDURE >=
3171: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3189: fnd_message.SET_NAME('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');

3185: END IF;
3186: CLOSE l_ra_lines;
3187: RAISE l_normal_exception;
3188: ELSIF l_status = 2 THEN
3189: fnd_message.SET_NAME('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');
3190: fnd_message.set_token('Tax_Regis_Number',
3191: l_fp_registration_number);
3192: l_error_string := fnd_message.get();
3193:

Line 3190: fnd_message.set_token('Tax_Regis_Number',

3186: CLOSE l_ra_lines;
3187: RAISE l_normal_exception;
3188: ELSIF l_status = 2 THEN
3189: fnd_message.SET_NAME('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');
3190: fnd_message.set_token('Tax_Regis_Number',
3191: l_fp_registration_number);
3192: l_error_string := fnd_message.get();
3193:
3194: -- begin log

Line 3192: l_error_string := fnd_message.get();

3188: ELSIF l_status = 2 THEN
3189: fnd_message.SET_NAME('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');
3190: fnd_message.set_token('Tax_Regis_Number',
3191: l_fp_registration_number);
3192: l_error_string := fnd_message.get();
3193:
3194: -- begin log
3195: IF (FND_LOG.LEVEL_PROCEDURE >=
3196: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3236: fnd_message.SET_NAME('JMF', 'JMF_GTA_UNITPRICE_EXCEED');

3232: -- Since the currency of tax unit price is same with
3233: -- the currency of max amount of GTA
3234: IF p_tax_curr_unit_price > l_max_amount THEN
3235:
3236: fnd_message.SET_NAME('JMF', 'JMF_GTA_UNITPRICE_EXCEED');
3237: fnd_message.set_token('NUM', l_customer_trx_line_number);
3238: l_error_string := fnd_message.GET();
3239:
3240: -- begin log

Line 3237: fnd_message.set_token('NUM', l_customer_trx_line_number);

3233: -- the currency of max amount of GTA
3234: IF p_tax_curr_unit_price > l_max_amount THEN
3235:
3236: fnd_message.SET_NAME('JMF', 'JMF_GTA_UNITPRICE_EXCEED');
3237: fnd_message.set_token('NUM', l_customer_trx_line_number);
3238: l_error_string := fnd_message.GET();
3239:
3240: -- begin log
3241: IF (FND_LOG.LEVEL_PROCEDURE >=

Line 3238: l_error_string := fnd_message.GET();

3234: IF p_tax_curr_unit_price > l_max_amount THEN
3235:
3236: fnd_message.SET_NAME('JMF', 'JMF_GTA_UNITPRICE_EXCEED');
3237: fnd_message.set_token('NUM', l_customer_trx_line_number);
3238: l_error_string := fnd_message.GET();
3239:
3240: -- begin log
3241: IF (FND_LOG.LEVEL_PROCEDURE >=
3242: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3266: fnd_message.set_name('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');

3262: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
3263: G_MODULE_PREFIX || l_procedure_name,
3264: 'no data found');
3265: END IF;
3266: fnd_message.set_name('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');
3267:
3268: IF (FND_LOG.LEVEL_UNEXPECTED >=
3269: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3270: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,

Line 3272: fnd_message.get());

3268: IF (FND_LOG.LEVEL_UNEXPECTED >=
3269: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3270: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
3271: G_MODULE_PREFIX || l_procedure_name,
3272: fnd_message.get());
3273:
3274: END IF;
3275: RAISE;
3276: RETURN;

Line 3287: fnd_message.set_name('JMF', 'JMF_GTA_MISSING_FIELD');

3283: IF (l_item_name_source_flag = 'R') THEN
3284: -- if the description of AR is null then report a error
3285: IF (l_description IS NULL) THEN
3286: --report JMF_GTA_AR_DESC_MISS
3287: fnd_message.set_name('JMF', 'JMF_GTA_MISSING_FIELD');
3288: fnd_message.set_token('NUM', l_customer_trx_line_number);
3289: fnd_message.set_token('TrxNum',
3290: l_trx_header.gta_trx_header_id);
3291: l_error_string := fnd_message.get();

Line 3288: fnd_message.set_token('NUM', l_customer_trx_line_number);

3284: -- if the description of AR is null then report a error
3285: IF (l_description IS NULL) THEN
3286: --report JMF_GTA_AR_DESC_MISS
3287: fnd_message.set_name('JMF', 'JMF_GTA_MISSING_FIELD');
3288: fnd_message.set_token('NUM', l_customer_trx_line_number);
3289: fnd_message.set_token('TrxNum',
3290: l_trx_header.gta_trx_header_id);
3291: l_error_string := fnd_message.get();
3292:

Line 3289: fnd_message.set_token('TrxNum',

3285: IF (l_description IS NULL) THEN
3286: --report JMF_GTA_AR_DESC_MISS
3287: fnd_message.set_name('JMF', 'JMF_GTA_MISSING_FIELD');
3288: fnd_message.set_token('NUM', l_customer_trx_line_number);
3289: fnd_message.set_token('TrxNum',
3290: l_trx_header.gta_trx_header_id);
3291: l_error_string := fnd_message.get();
3292:
3293: -- begin log

Line 3291: l_error_string := fnd_message.get();

3287: fnd_message.set_name('JMF', 'JMF_GTA_MISSING_FIELD');
3288: fnd_message.set_token('NUM', l_customer_trx_line_number);
3289: fnd_message.set_token('TrxNum',
3290: l_trx_header.gta_trx_header_id);
3291: l_error_string := fnd_message.get();
3292:
3293: -- begin log
3294: IF (FND_LOG.LEVEL_PROCEDURE >=
3295: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3333: fnd_message.set_name('JMF', 'JMF_GTA_MISSING_CROSS_REF');

3329: where org_id = p_org_id
3330: and parameter_code = 'MASTER_ORGANIZATION_ID';
3331: EXCEPTION
3332: WHEN no_data_found THEN
3333: fnd_message.set_name('JMF', 'JMF_GTA_MISSING_CROSS_REF');
3334: fnd_message.set_token('NUM', l_customer_trx_line_number);
3335: l_error_string := fnd_message.get();
3336:
3337: -- log

Line 3334: fnd_message.set_token('NUM', l_customer_trx_line_number);

3330: and parameter_code = 'MASTER_ORGANIZATION_ID';
3331: EXCEPTION
3332: WHEN no_data_found THEN
3333: fnd_message.set_name('JMF', 'JMF_GTA_MISSING_CROSS_REF');
3334: fnd_message.set_token('NUM', l_customer_trx_line_number);
3335: l_error_string := fnd_message.get();
3336:
3337: -- log
3338: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3335: l_error_string := fnd_message.get();

3331: EXCEPTION
3332: WHEN no_data_found THEN
3333: fnd_message.set_name('JMF', 'JMF_GTA_MISSING_CROSS_REF');
3334: fnd_message.set_token('NUM', l_customer_trx_line_number);
3335: l_error_string := fnd_message.get();
3336:
3337: -- log
3338: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3339: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,

Line 3389: fnd_message.set_name('JMF',

3385: AND inventory_item_id = l_inventory_item_id;
3386:
3387: EXCEPTION
3388: WHEN no_data_found THEN
3389: fnd_message.set_name('JMF',
3390: 'JMF_GTA_MISSING_CROSS_REF');
3391: fnd_message.set_token('NUM',
3392: l_customer_trx_line_number);
3393: l_error_string := fnd_message.get();

Line 3391: fnd_message.set_token('NUM',

3387: EXCEPTION
3388: WHEN no_data_found THEN
3389: fnd_message.set_name('JMF',
3390: 'JMF_GTA_MISSING_CROSS_REF');
3391: fnd_message.set_token('NUM',
3392: l_customer_trx_line_number);
3393: l_error_string := fnd_message.get();
3394:
3395: -- log

Line 3393: l_error_string := fnd_message.get();

3389: fnd_message.set_name('JMF',
3390: 'JMF_GTA_MISSING_CROSS_REF');
3391: fnd_message.set_token('NUM',
3392: l_customer_trx_line_number);
3393: l_error_string := fnd_message.get();
3394:
3395: -- log
3396: IF (FND_LOG.LEVEL_EXCEPTION >=
3397: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3409: fnd_message.SET_NAME('JMF', 'JMF_GTA_MULTIPLE_REF');

3405: END;
3406: --multi-lines cross reference and setup not allow it
3407: IF (l_latest_ref_default_flag = 'N' AND l_cross_rows > 1) THEN
3408: --report JMF_GTA_MISSING_CROSS_REF
3409: fnd_message.SET_NAME('JMF', 'JMF_GTA_MULTIPLE_REF');
3410: fnd_message.SET_TOKEN('NUM', l_customer_trx_line_number);
3411: l_error_string := fnd_message.get();
3412:
3413: -- log

Line 3410: fnd_message.SET_TOKEN('NUM', l_customer_trx_line_number);

3406: --multi-lines cross reference and setup not allow it
3407: IF (l_latest_ref_default_flag = 'N' AND l_cross_rows > 1) THEN
3408: --report JMF_GTA_MISSING_CROSS_REF
3409: fnd_message.SET_NAME('JMF', 'JMF_GTA_MULTIPLE_REF');
3410: fnd_message.SET_TOKEN('NUM', l_customer_trx_line_number);
3411: l_error_string := fnd_message.get();
3412:
3413: -- log
3414: IF (FND_LOG.LEVEL_EXCEPTION >=

Line 3411: l_error_string := fnd_message.get();

3407: IF (l_latest_ref_default_flag = 'N' AND l_cross_rows > 1) THEN
3408: --report JMF_GTA_MISSING_CROSS_REF
3409: fnd_message.SET_NAME('JMF', 'JMF_GTA_MULTIPLE_REF');
3410: fnd_message.SET_TOKEN('NUM', l_customer_trx_line_number);
3411: l_error_string := fnd_message.get();
3412:
3413: -- log
3414: IF (FND_LOG.LEVEL_EXCEPTION >=
3415: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3433: fnd_message.SET_NAME('JMF',

3429: l_trx_line.item_description := l_inventory_item_name;
3430:
3431: ELSE
3432: /*(l_MASTER_ITEM_DEFAULT_FLAG = 'Y') */
3433: fnd_message.SET_NAME('JMF',
3434: 'JMF_GTA_MISSING_CROSS_REF');
3435: fnd_message.SET_TOKEN('NUM',
3436: l_customer_trx_line_number);
3437: l_error_string := fnd_message.get();

Line 3435: fnd_message.SET_TOKEN('NUM',

3431: ELSE
3432: /*(l_MASTER_ITEM_DEFAULT_FLAG = 'Y') */
3433: fnd_message.SET_NAME('JMF',
3434: 'JMF_GTA_MISSING_CROSS_REF');
3435: fnd_message.SET_TOKEN('NUM',
3436: l_customer_trx_line_number);
3437: l_error_string := fnd_message.get();
3438:
3439: -- log

Line 3437: l_error_string := fnd_message.get();

3433: fnd_message.SET_NAME('JMF',
3434: 'JMF_GTA_MISSING_CROSS_REF');
3435: fnd_message.SET_TOKEN('NUM',
3436: l_customer_trx_line_number);
3437: l_error_string := fnd_message.get();
3438:
3439: -- log
3440: IF (FND_LOG.LEVEL_EXCEPTION >=
3441: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3461: /* fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_CROSS_REF');

3457: -- should be assigned the value of AR transaction line description.
3458: l_trx_line.item_description := l_description;
3459: --11/06/2006 deleted by Shujuan Yan for bug 5224923
3460: /* ELSE /*l_inventory_item_id IS NOT NULL*/
3461: /* fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_CROSS_REF');
3462: fnd_message.set_token('NUM', l_customer_trx_line_number);
3463: l_error_string := fnd_message.get;
3464:
3465: -- log

Line 3462: fnd_message.set_token('NUM', l_customer_trx_line_number);

3458: l_trx_line.item_description := l_description;
3459: --11/06/2006 deleted by Shujuan Yan for bug 5224923
3460: /* ELSE /*l_inventory_item_id IS NOT NULL*/
3461: /* fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_CROSS_REF');
3462: fnd_message.set_token('NUM', l_customer_trx_line_number);
3463: l_error_string := fnd_message.get;
3464:
3465: -- log
3466: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 3463: l_error_string := fnd_message.get;

3459: --11/06/2006 deleted by Shujuan Yan for bug 5224923
3460: /* ELSE /*l_inventory_item_id IS NOT NULL*/
3461: /* fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_CROSS_REF');
3462: fnd_message.set_token('NUM', l_customer_trx_line_number);
3463: l_error_string := fnd_message.get;
3464:
3465: -- log
3466: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3467: THEN

Line 3488: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_MODEL');

3484: IF l_interface_line_context <> l_ra_line_context_code OR
3485: l_interface_line_context IS NULL THEN
3486: IF l_inventory_attribute_category <> l_inv_item_context_code THEN
3487: --report JMF_GTA_ARTRX_FLEX_MISSING
3488: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_MODEL');
3489: fnd_message.set_token('NUM', l_customer_trx_line_number);
3490: fnd_message.set_token('ITEM', l_inventory_item_name);
3491: l_error_string := fnd_message.get();
3492:

Line 3489: fnd_message.set_token('NUM', l_customer_trx_line_number);

3485: l_interface_line_context IS NULL THEN
3486: IF l_inventory_attribute_category <> l_inv_item_context_code THEN
3487: --report JMF_GTA_ARTRX_FLEX_MISSING
3488: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_MODEL');
3489: fnd_message.set_token('NUM', l_customer_trx_line_number);
3490: fnd_message.set_token('ITEM', l_inventory_item_name);
3491: l_error_string := fnd_message.get();
3492:
3493: -- log

Line 3490: fnd_message.set_token('ITEM', l_inventory_item_name);

3486: IF l_inventory_attribute_category <> l_inv_item_context_code THEN
3487: --report JMF_GTA_ARTRX_FLEX_MISSING
3488: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_MODEL');
3489: fnd_message.set_token('NUM', l_customer_trx_line_number);
3490: fnd_message.set_token('ITEM', l_inventory_item_name);
3491: l_error_string := fnd_message.get();
3492:
3493: -- log
3494: IF (FND_LOG.LEVEL_EXCEPTION >=

Line 3491: l_error_string := fnd_message.get();

3487: --report JMF_GTA_ARTRX_FLEX_MISSING
3488: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_MODEL');
3489: fnd_message.set_token('NUM', l_customer_trx_line_number);
3490: fnd_message.set_token('ITEM', l_inventory_item_name);
3491: l_error_string := fnd_message.get();
3492:
3493: -- log
3494: IF (FND_LOG.LEVEL_EXCEPTION >=
3495: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3506: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_MODEL');

3502: RAISE l_normal_exception;
3503: ELSE
3504: /*l_interface_line_context <> l_inv_item_context_code*/
3505: IF l_inv_model_attribute_column IS NULL THEN
3506: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_MODEL');
3507: fnd_message.set_token('NUM', l_customer_trx_line_number);
3508: fnd_message.set_token('ITEM', l_inventory_item_name);
3509: l_error_string := fnd_message.get;
3510:

Line 3507: fnd_message.set_token('NUM', l_customer_trx_line_number);

3503: ELSE
3504: /*l_interface_line_context <> l_inv_item_context_code*/
3505: IF l_inv_model_attribute_column IS NULL THEN
3506: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_MODEL');
3507: fnd_message.set_token('NUM', l_customer_trx_line_number);
3508: fnd_message.set_token('ITEM', l_inventory_item_name);
3509: l_error_string := fnd_message.get;
3510:
3511: -- log

Line 3508: fnd_message.set_token('ITEM', l_inventory_item_name);

3504: /*l_interface_line_context <> l_inv_item_context_code*/
3505: IF l_inv_model_attribute_column IS NULL THEN
3506: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_MODEL');
3507: fnd_message.set_token('NUM', l_customer_trx_line_number);
3508: fnd_message.set_token('ITEM', l_inventory_item_name);
3509: l_error_string := fnd_message.get;
3510:
3511: -- log
3512: IF (FND_LOG.LEVEL_EXCEPTION >=

Line 3509: l_error_string := fnd_message.get;

3505: IF l_inv_model_attribute_column IS NULL THEN
3506: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_MODEL');
3507: fnd_message.set_token('NUM', l_customer_trx_line_number);
3508: fnd_message.set_token('ITEM', l_inventory_item_name);
3509: l_error_string := fnd_message.get;
3510:
3511: -- log
3512: IF (FND_LOG.LEVEL_EXCEPTION >=
3513: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3531: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_TAX_DENOM');

3527:
3528: END IF; /*l_inv_model_attribute_column IS NULL*/
3529:
3530: IF l_inv_tax_attribute_column IS NULL THEN
3531: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_TAX_DENOM');
3532: fnd_message.set_token('NUM', l_customer_trx_line_number);
3533: fnd_message.set_token('ITEM', l_inventory_item_name);
3534: l_error_string := fnd_message.get();
3535: -- log

Line 3532: fnd_message.set_token('NUM', l_customer_trx_line_number);

3528: END IF; /*l_inv_model_attribute_column IS NULL*/
3529:
3530: IF l_inv_tax_attribute_column IS NULL THEN
3531: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_TAX_DENOM');
3532: fnd_message.set_token('NUM', l_customer_trx_line_number);
3533: fnd_message.set_token('ITEM', l_inventory_item_name);
3534: l_error_string := fnd_message.get();
3535: -- log
3536: IF (FND_LOG.LEVEL_PROCEDURE >=

Line 3533: fnd_message.set_token('ITEM', l_inventory_item_name);

3529:
3530: IF l_inv_tax_attribute_column IS NULL THEN
3531: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_TAX_DENOM');
3532: fnd_message.set_token('NUM', l_customer_trx_line_number);
3533: fnd_message.set_token('ITEM', l_inventory_item_name);
3534: l_error_string := fnd_message.get();
3535: -- log
3536: IF (FND_LOG.LEVEL_PROCEDURE >=
3537: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3534: l_error_string := fnd_message.get();

3530: IF l_inv_tax_attribute_column IS NULL THEN
3531: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_TAX_DENOM');
3532: fnd_message.set_token('NUM', l_customer_trx_line_number);
3533: fnd_message.set_token('ITEM', l_inventory_item_name);
3534: l_error_string := fnd_message.get();
3535: -- log
3536: IF (FND_LOG.LEVEL_PROCEDURE >=
3537: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3538: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

Line 3573: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_MODEL');

3569:
3570: IF l_trx_line.item_model IS NULL THEN
3571: IF l_inventory_attribute_category <>
3572: l_inv_item_context_code THEN
3573: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_MODEL');
3574: fnd_message.set_token('NUM', l_customer_trx_line_number);
3575: fnd_message.set_token('ITEM', l_inventory_item_name);
3576: l_error_string := fnd_message.get();
3577:

Line 3574: fnd_message.set_token('NUM', l_customer_trx_line_number);

3570: IF l_trx_line.item_model IS NULL THEN
3571: IF l_inventory_attribute_category <>
3572: l_inv_item_context_code THEN
3573: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_MODEL');
3574: fnd_message.set_token('NUM', l_customer_trx_line_number);
3575: fnd_message.set_token('ITEM', l_inventory_item_name);
3576: l_error_string := fnd_message.get();
3577:
3578: -- log

Line 3575: fnd_message.set_token('ITEM', l_inventory_item_name);

3571: IF l_inventory_attribute_category <>
3572: l_inv_item_context_code THEN
3573: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_MODEL');
3574: fnd_message.set_token('NUM', l_customer_trx_line_number);
3575: fnd_message.set_token('ITEM', l_inventory_item_name);
3576: l_error_string := fnd_message.get();
3577:
3578: -- log
3579: IF (FND_LOG.LEVEL_EXCEPTION >=

Line 3576: l_error_string := fnd_message.get();

3572: l_inv_item_context_code THEN
3573: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_MODEL');
3574: fnd_message.set_token('NUM', l_customer_trx_line_number);
3575: fnd_message.set_token('ITEM', l_inventory_item_name);
3576: l_error_string := fnd_message.get();
3577:
3578: -- log
3579: IF (FND_LOG.LEVEL_EXCEPTION >=
3580: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3618: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_TAX_DENOM');

3614: --Should display line number and item name instead of line id and item id.
3615: IF l_trx_line.item_tax_denomination IS NULL THEN
3616: IF l_inventory_attribute_category <>
3617: l_inv_item_context_code THEN
3618: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_TAX_DENOM');
3619: fnd_message.set_token('NUM', l_customer_trx_line_number);
3620: fnd_message.set_token('ITEM', l_inventory_item_name);
3621:
3622: l_error_string := fnd_message.get();

Line 3619: fnd_message.set_token('NUM', l_customer_trx_line_number);

3615: IF l_trx_line.item_tax_denomination IS NULL THEN
3616: IF l_inventory_attribute_category <>
3617: l_inv_item_context_code THEN
3618: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_TAX_DENOM');
3619: fnd_message.set_token('NUM', l_customer_trx_line_number);
3620: fnd_message.set_token('ITEM', l_inventory_item_name);
3621:
3622: l_error_string := fnd_message.get();
3623:

Line 3620: fnd_message.set_token('ITEM', l_inventory_item_name);

3616: IF l_inventory_attribute_category <>
3617: l_inv_item_context_code THEN
3618: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_TAX_DENOM');
3619: fnd_message.set_token('NUM', l_customer_trx_line_number);
3620: fnd_message.set_token('ITEM', l_inventory_item_name);
3621:
3622: l_error_string := fnd_message.get();
3623:
3624: -- log

Line 3622: l_error_string := fnd_message.get();

3618: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_TAX_DENOM');
3619: fnd_message.set_token('NUM', l_customer_trx_line_number);
3620: fnd_message.set_token('ITEM', l_inventory_item_name);
3621:
3622: l_error_string := fnd_message.get();
3623:
3624: -- log
3625: IF (FND_LOG.LEVEL_EXCEPTION >=
3626: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3651: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_TAX_DENOM');

3647: -- message or JMF_GTA_MISSING_CROSS_REF message.
3648: -- 12/06/2006 Updated by Shujuan Yan for bug 5230712
3649: -- Should display line number and item name instead of line id and item id.
3650: IF l_trx_line.item_tax_denomination IS NULL THEN
3651: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_TAX_DENOM');
3652: fnd_message.set_token('NUM', l_customer_trx_line_number);
3653: fnd_message.set_token('ITEM', l_inventory_item_name);
3654: l_error_string := fnd_message.get();
3655: -- log

Line 3652: fnd_message.set_token('NUM', l_customer_trx_line_number);

3648: -- 12/06/2006 Updated by Shujuan Yan for bug 5230712
3649: -- Should display line number and item name instead of line id and item id.
3650: IF l_trx_line.item_tax_denomination IS NULL THEN
3651: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_TAX_DENOM');
3652: fnd_message.set_token('NUM', l_customer_trx_line_number);
3653: fnd_message.set_token('ITEM', l_inventory_item_name);
3654: l_error_string := fnd_message.get();
3655: -- log
3656: IF (FND_LOG.LEVEL_UNEXPECTED >=

Line 3653: fnd_message.set_token('ITEM', l_inventory_item_name);

3649: -- Should display line number and item name instead of line id and item id.
3650: IF l_trx_line.item_tax_denomination IS NULL THEN
3651: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_TAX_DENOM');
3652: fnd_message.set_token('NUM', l_customer_trx_line_number);
3653: fnd_message.set_token('ITEM', l_inventory_item_name);
3654: l_error_string := fnd_message.get();
3655: -- log
3656: IF (FND_LOG.LEVEL_UNEXPECTED >=
3657: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3654: l_error_string := fnd_message.get();

3650: IF l_trx_line.item_tax_denomination IS NULL THEN
3651: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_TAX_DENOM');
3652: fnd_message.set_token('NUM', l_customer_trx_line_number);
3653: fnd_message.set_token('ITEM', l_inventory_item_name);
3654: l_error_string := fnd_message.get();
3655: -- log
3656: IF (FND_LOG.LEVEL_UNEXPECTED >=
3657: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3658: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,

Line 3668: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_CROSS_REF');

3664:
3665: END IF; /*l_trx_lline.itme_tax_denomination IS NULL*/
3666:
3667: IF l_trx_line.item_description IS NULL THEN
3668: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_CROSS_REF');
3669: fnd_message.set_token('NUM', l_customer_trx_line_number);
3670: l_error_string := fnd_message.get();
3671: -- log
3672: IF (FND_LOG.LEVEL_UNEXPECTED >=

Line 3669: fnd_message.set_token('NUM', l_customer_trx_line_number);

3665: END IF; /*l_trx_lline.itme_tax_denomination IS NULL*/
3666:
3667: IF l_trx_line.item_description IS NULL THEN
3668: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_CROSS_REF');
3669: fnd_message.set_token('NUM', l_customer_trx_line_number);
3670: l_error_string := fnd_message.get();
3671: -- log
3672: IF (FND_LOG.LEVEL_UNEXPECTED >=
3673: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3670: l_error_string := fnd_message.get();

3666:
3667: IF l_trx_line.item_description IS NULL THEN
3668: fnd_message.SET_NAME('JMF', 'JMF_GTA_MISSING_CROSS_REF');
3669: fnd_message.set_token('NUM', l_customer_trx_line_number);
3670: l_error_string := fnd_message.get();
3671: -- log
3672: IF (FND_LOG.LEVEL_UNEXPECTED >=
3673: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3674: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,

Line 3788: fnd_message.SET_NAME('JMF', 'JMF_GTA_MULTI_TP_TAXREG');

3784: WHILE l_trx_line_index IS NOT NULL LOOP
3785: l_tp_regi_number := l_trx_lines(l_trx_line_index)
3786: .tp_tax_registration_number;
3787: IF l_tp_regi_number <> l_tp_regi_number_first THEN
3788: fnd_message.SET_NAME('JMF', 'JMF_GTA_MULTI_TP_TAXREG');
3789: l_error_string := fnd_message.get;
3790: RAISE l_normal_exception;
3791: END IF; /*l_tp_regi_number <> l_tp_regi_number_first*/
3792:

Line 3789: l_error_string := fnd_message.get;

3785: l_tp_regi_number := l_trx_lines(l_trx_line_index)
3786: .tp_tax_registration_number;
3787: IF l_tp_regi_number <> l_tp_regi_number_first THEN
3788: fnd_message.SET_NAME('JMF', 'JMF_GTA_MULTI_TP_TAXREG');
3789: l_error_string := fnd_message.get;
3790: RAISE l_normal_exception;
3791: END IF; /*l_tp_regi_number <> l_tp_regi_number_first*/
3792:
3793: l_trx_line_index := l_trx_lines.NEXT(l_trx_line_index);