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_TXT_OPERATOR_PROC dependencies on FND_MESSAGE

Line 579: fnd_message.SET_NAME( APPLICATION => 'JMF'

575: , x_EOF =>l_EOF
576: );
577:
578: IF l_EOF THEN
579: fnd_message.SET_NAME( APPLICATION => 'JMF'
580: , NAME => 'JMF_GTA_UNMATCHED_INV_DATA_FMT');
581: l_error_msg := G_import_error_prefix||fnd_message.GET
582: ||G_import_error_suffix;
583: put_line(l_error_msg);

Line 581: l_error_msg := G_import_error_prefix||fnd_message.GET

577:
578: IF l_EOF THEN
579: fnd_message.SET_NAME( APPLICATION => 'JMF'
580: , NAME => 'JMF_GTA_UNMATCHED_INV_DATA_FMT');
581: l_error_msg := G_import_error_prefix||fnd_message.GET
582: ||G_import_error_suffix;
583: put_line(l_error_msg);
584: l_conc_succ:=FND_CONCURRENT.SET_COMPLETION_STATUS( status => 'WARNING'
585: , message => NULL);

Line 591: fnd_message.SET_NAME( APPLICATION => 'JMF'

587: END IF;
588:
589: --Get the fixed Chinese text used in export flat file which identify
590: --the flat file is the flat file exported from GT system
591: fnd_message.SET_NAME( APPLICATION => 'JMF'
592: , NAME => 'JMF_GTA_INVOICE_IMPORT');
593: fnd_message.SET_TOKEN( TOKEN => 'MIDFIX'
594: , VALUE => g_export_delimiter
595: );

Line 593: fnd_message.SET_TOKEN( TOKEN => 'MIDFIX'

589: --Get the fixed Chinese text used in export flat file which identify
590: --the flat file is the flat file exported from GT system
591: fnd_message.SET_NAME( APPLICATION => 'JMF'
592: , NAME => 'JMF_GTA_INVOICE_IMPORT');
593: fnd_message.SET_TOKEN( TOKEN => 'MIDFIX'
594: , VALUE => g_export_delimiter
595: );
596:
597: l_fix_field:=fnd_message.GET;

Line 597: l_fix_field:=fnd_message.GET;

593: fnd_message.SET_TOKEN( TOKEN => 'MIDFIX'
594: , VALUE => g_export_delimiter
595: );
596:
597: l_fix_field:=fnd_message.GET;
598: l_str:=l_values(1)||g_export_delimiter||l_values(2);
599:
600: --verify the file format.
601: --If <1: no fixed Chinese text, give flat file format error

Line 605: fnd_message.SET_NAME('JMF','JMF_GTA_UNMATCHED_INV_DATA_FMT');

601: --If <1: no fixed Chinese text, give flat file format error
602: --IF instr(l_str,l_fix_field)<1
603: IF instr(l_fix_field,l_values(1))<1 or instr(l_fix_field,l_values(2))<1
604: THEN
605: fnd_message.SET_NAME('JMF','JMF_GTA_UNMATCHED_INV_DATA_FMT');
606: l_error_msg := G_import_error_prefix||fnd_message.GET
607: ||G_import_error_suffix;
608: put_line(l_error_msg);
609: l_conc_succ:=FND_CONCURRENT.SET_COMPLETION_STATUS( status => 'WARNING'

Line 606: l_error_msg := G_import_error_prefix||fnd_message.GET

602: --IF instr(l_str,l_fix_field)<1
603: IF instr(l_fix_field,l_values(1))<1 or instr(l_fix_field,l_values(2))<1
604: THEN
605: fnd_message.SET_NAME('JMF','JMF_GTA_UNMATCHED_INV_DATA_FMT');
606: l_error_msg := G_import_error_prefix||fnd_message.GET
607: ||G_import_error_suffix;
608: put_line(l_error_msg);
609: l_conc_succ:=FND_CONCURRENT.SET_COMPLETION_STATUS( status => 'WARNING'
610: , message => NULL);

Line 624: fnd_message.SET_NAME('JMF','JMF_GTA_UNMATCHED_INV_DATA_FMT');

620:
621: --it's an empty file
622: IF l_EOF
623: THEN
624: fnd_message.SET_NAME('JMF','JMF_GTA_UNMATCHED_INV_DATA_FMT');
625: l_error_msg := G_import_error_prefix||fnd_message.GET
626: ||G_import_error_suffix;
627: put_line(l_error_msg);
628: l_conc_succ:=FND_CONCURRENT.SET_COMPLETION_STATUS( status => 'WARNING'

Line 625: l_error_msg := G_import_error_prefix||fnd_message.GET

621: --it's an empty file
622: IF l_EOF
623: THEN
624: fnd_message.SET_NAME('JMF','JMF_GTA_UNMATCHED_INV_DATA_FMT');
625: l_error_msg := G_import_error_prefix||fnd_message.GET
626: ||G_import_error_suffix;
627: put_line(l_error_msg);
628: l_conc_succ:=FND_CONCURRENT.SET_COMPLETION_STATUS( status => 'WARNING'
629: , message => NULL);

Line 678: fnd_message.SET_NAME('JMF','JMF_GTA_UNMATCHED_INV_DATA_FMT');

674: l_num_of_lines := l_values(6); --get lines number
675:
676: EXCEPTION
677: WHEN OTHERS THEN
678: fnd_message.SET_NAME('JMF','JMF_GTA_UNMATCHED_INV_DATA_FMT');
679: l_error_msg := G_import_error_prefix||fnd_message.GET
680: ||G_import_error_suffix;
681: put_line(l_error_msg);
682: l_conc_succ:=FND_CONCURRENT.SET_COMPLETION_STATUS

Line 679: l_error_msg := G_import_error_prefix||fnd_message.GET

675:
676: EXCEPTION
677: WHEN OTHERS THEN
678: fnd_message.SET_NAME('JMF','JMF_GTA_UNMATCHED_INV_DATA_FMT');
679: l_error_msg := G_import_error_prefix||fnd_message.GET
680: ||G_import_error_suffix;
681: put_line(l_error_msg);
682: l_conc_succ:=FND_CONCURRENT.SET_COMPLETION_STATUS
683: ( status => 'WARNING'

Line 864: fnd_message.SET_NAME('JMF','JMF_GTA_UNMATCHED_INV_DATA_FMT');

860: EXCEPTION
861: WHEN OTHERS THEN
862:
863: l_failed:=TRUE;
864: fnd_message.SET_NAME('JMF','JMF_GTA_UNMATCHED_INV_DATA_FMT');
865: l_error_msg:=fnd_message.GET;
866:
867: IF(G_DEBUG_LEVEL >= l_dbg_level)
868: THEN

Line 865: l_error_msg:=fnd_message.GET;

861: WHEN OTHERS THEN
862:
863: l_failed:=TRUE;
864: fnd_message.SET_NAME('JMF','JMF_GTA_UNMATCHED_INV_DATA_FMT');
865: l_error_msg:=fnd_message.GET;
866:
867: IF(G_DEBUG_LEVEL >= l_dbg_level)
868: THEN
869: FND_LOG.string( G_DEBUG_LEVEL

Line 989: fnd_message.SET_NAME( 'JMF'

985: EXCEPTION
986: WHEN OTHERS THEN
987: l_failed:=TRUE;
988:
989: fnd_message.SET_NAME( 'JMF'
990: , 'JMF_GTA_UNMATCHED_INV_DATA_FMT');
991: l_error_msg:=fnd_message.GET;
992:
993: IF(G_DEBUG_LEVEL >= l_dbg_level)

Line 991: l_error_msg:=fnd_message.GET;

987: l_failed:=TRUE;
988:
989: fnd_message.SET_NAME( 'JMF'
990: , 'JMF_GTA_UNMATCHED_INV_DATA_FMT');
991: l_error_msg:=fnd_message.GET;
992:
993: IF(G_DEBUG_LEVEL >= l_dbg_level)
994: THEN
995: FND_LOG.string( G_DEBUG_LEVEL

Line 1055: fnd_message.SET_NAME('JMF'

1051: EXCEPTION
1052: WHEN OTHERS THEN
1053: l_failed:=TRUE;
1054:
1055: fnd_message.SET_NAME('JMF'
1056: ,'JMF_GTA_UNMATCHED_INV_DATA_FMT');
1057: l_error_msg:=fnd_message.GET;
1058:
1059: IF(G_DEBUG_LEVEL >= l_dbg_level)

Line 1057: l_error_msg:=fnd_message.GET;

1053: l_failed:=TRUE;
1054:
1055: fnd_message.SET_NAME('JMF'
1056: ,'JMF_GTA_UNMATCHED_INV_DATA_FMT');
1057: l_error_msg:=fnd_message.GET;
1058:
1059: IF(G_DEBUG_LEVEL >= l_dbg_level)
1060: THEN
1061: FND_LOG.string( G_DEBUG_LEVEL

Line 1092: fnd_message.SET_NAME('JMF'

1088: ELSIF (l_status='COMPLETED')--has exists VAT invoice from GT
1089: THEN
1090: l_failed:=TRUE;
1091:
1092: fnd_message.SET_NAME('JMF'
1093: ,'JMF_GTA_IMP_PRIEXIST_FAIL');
1094: fnd_message.SET_TOKEN( TOKEN => 'NUM'
1095: , VALUE => l_Invoice_Num
1096: );

Line 1094: fnd_message.SET_TOKEN( TOKEN => 'NUM'

1090: l_failed:=TRUE;
1091:
1092: fnd_message.SET_NAME('JMF'
1093: ,'JMF_GTA_IMP_PRIEXIST_FAIL');
1094: fnd_message.SET_TOKEN( TOKEN => 'NUM'
1095: , VALUE => l_Invoice_Num
1096: );
1097:
1098: l_error_msg:=fnd_message.GET;

Line 1098: l_error_msg:=fnd_message.GET;

1094: fnd_message.SET_TOKEN( TOKEN => 'NUM'
1095: , VALUE => l_Invoice_Num
1096: );
1097:
1098: l_error_msg:=fnd_message.GET;
1099:
1100: INSERT INTO JMF_GTA_IMPORT_REP_TEMP( SEQ
1101: , SUCCEEDED
1102: , Customer_Name

Line 1130: fnd_message.SET_NAME('JMF'

1126: ELSIF (l_status='CANCELLED')--the VAT invoice was cancelled in GTA
1127: THEN
1128: l_failed:=TRUE;
1129:
1130: fnd_message.SET_NAME('JMF'
1131: ,'JMF_GTA_IMP_CANCEL');
1132: fnd_message.SET_TOKEN( TOKEN => 'NUM'
1133: , VALUE => l_Invoice_Num
1134: );

Line 1132: fnd_message.SET_TOKEN( TOKEN => 'NUM'

1128: l_failed:=TRUE;
1129:
1130: fnd_message.SET_NAME('JMF'
1131: ,'JMF_GTA_IMP_CANCEL');
1132: fnd_message.SET_TOKEN( TOKEN => 'NUM'
1133: , VALUE => l_Invoice_Num
1134: );
1135:
1136: l_error_msg:=fnd_message.GET;

Line 1136: l_error_msg:=fnd_message.GET;

1132: fnd_message.SET_TOKEN( TOKEN => 'NUM'
1133: , VALUE => l_Invoice_Num
1134: );
1135:
1136: l_error_msg:=fnd_message.GET;
1137:
1138: INSERT INTO JMF_GTA_IMPORT_REP_TEMP( SEQ
1139: , SUCCEEDED
1140: , Customer_Name

Line 1166: fnd_message.SET_NAME('JMF','JMF_GTA_WRONG_INV_STATUS');

1162: END LOOP;
1163: --Jogen Jun-12 2006, bug
1164:
1165: ELSE --status error
1166: fnd_message.SET_NAME('JMF','JMF_GTA_WRONG_INV_STATUS');
1167: l_error_msg:=fnd_message.GET;
1168:
1169: INSERT INTO JMF_GTA_IMPORT_REP_TEMP( SEQ
1170: , SUCCEEDED

Line 1167: l_error_msg:=fnd_message.GET;

1163: --Jogen Jun-12 2006, bug
1164:
1165: ELSE --status error
1166: fnd_message.SET_NAME('JMF','JMF_GTA_WRONG_INV_STATUS');
1167: l_error_msg:=fnd_message.GET;
1168:
1169: INSERT INTO JMF_GTA_IMPORT_REP_TEMP( SEQ
1170: , SUCCEEDED
1171: , Customer_Name

Line 1197: /*fnd_message.SET_NAME('JMF','JMF_GTA_MOAC_FORBID');

1193: END LOOP;
1194: END IF;
1195: ELSE --MO_GLOBAL.Check_Access(l_org_id)<>'Y'
1196: --report JMF_GTA_MOAC_ERROR;
1197: /*fnd_message.SET_NAME('JMF','JMF_GTA_MOAC_FORBID');
1198: l_error_msg:=fnd_message.GET;
1199:
1200: INSERT INTO JMF_GTA_IMPORT_REP_TEMP( SEQ
1201: , SUCCEEDED

Line 1198: l_error_msg:=fnd_message.GET;

1194: END IF;
1195: ELSE --MO_GLOBAL.Check_Access(l_org_id)<>'Y'
1196: --report JMF_GTA_MOAC_ERROR;
1197: /*fnd_message.SET_NAME('JMF','JMF_GTA_MOAC_FORBID');
1198: l_error_msg:=fnd_message.GET;
1199:
1200: INSERT INTO JMF_GTA_IMPORT_REP_TEMP( SEQ
1201: , SUCCEEDED
1202: , Customer_Name

Line 1400: fnd_message.SET_NAME( APPLICATION => 'JMF'

1396: --reserve one line for header output
1397: x_output:=t_invoice_export_output(NULL,NULL);
1398:
1399: --Get the comments of a single invoice
1400: fnd_message.SET_NAME( APPLICATION => 'JMF'
1401: , NAME => 'JMF_GTA_INVOICE_EXPORT_COMMT'
1402: );
1403: fnd_message.SET_TOKEN( TOKEN => 'PREFIX'
1404: , VALUE => g_comment_delimiter

Line 1403: fnd_message.SET_TOKEN( TOKEN => 'PREFIX'

1399: --Get the comments of a single invoice
1400: fnd_message.SET_NAME( APPLICATION => 'JMF'
1401: , NAME => 'JMF_GTA_INVOICE_EXPORT_COMMT'
1402: );
1403: fnd_message.SET_TOKEN( TOKEN => 'PREFIX'
1404: , VALUE => g_comment_delimiter
1405: );
1406:
1407: --put to the temporary output

Line 1408: x_output(1):=fnd_message.get;

1404: , VALUE => g_comment_delimiter
1405: );
1406:
1407: --put to the temporary output
1408: x_output(1):=fnd_message.get;
1409:
1410: jmf_gta_trx_headers_all_pkg.query_row( p_header_id => p_invoice_header_id
1411: , x_trx_header_rec => l_invoice
1412: );

Line 1682: fnd_message.SET_NAME('JMF','JMF_GTA_BANKACCOUNT_MASKING');

1678: IF fnd_profile.VALUE('CE_MASK_INTERNAL_BANK_ACCT_NUM') IS NULL
1679: OR fnd_profile.VALUE('CE_MASK_INTERNAL_BANK_ACCT_NUM') <> 'NO MASK'
1680: THEN
1681: --report JMF_GTA_BANKACCOUNT_MASKING
1682: fnd_message.SET_NAME('JMF','JMF_GTA_BANKACCOUNT_MASKING');
1683: l_error_msg:=fnd_message.GET;
1684: put_line(l_error_msg);
1685: --set concurrent status to warning
1686: l_conc_succ:=FND_CONCURRENT.SET_COMPLETION_STATUS( status => 'WARNING'

Line 1683: l_error_msg:=fnd_message.GET;

1679: OR fnd_profile.VALUE('CE_MASK_INTERNAL_BANK_ACCT_NUM') <> 'NO MASK'
1680: THEN
1681: --report JMF_GTA_BANKACCOUNT_MASKING
1682: fnd_message.SET_NAME('JMF','JMF_GTA_BANKACCOUNT_MASKING');
1683: l_error_msg:=fnd_message.GET;
1684: put_line(l_error_msg);
1685: --set concurrent status to warning
1686: l_conc_succ:=FND_CONCURRENT.SET_COMPLETION_STATUS( status => 'WARNING'
1687: , message => NULL);

Line 1723: fnd_message.SET_NAME('JMF','JMF_GTA_FP_TAX_REG_NUMBER');

1719: EXIT WHEN P_cursor%NOTFOUND;
1720: /* IF l_first_Inv
1721: THEN
1722: l_first_Inv:=FALSE;
1723: fnd_message.SET_NAME('JMF','JMF_GTA_FP_TAX_REG_NUMBER');
1724: fnd_message.SET_TOKEN( TOKEN => 'NUMBER'
1725: , VALUE => l_header_rec_cur.fp_tax_registration_number
1726: );
1727: put_line(g_comment_delimiter||fnd_message.GET);

Line 1724: fnd_message.SET_TOKEN( TOKEN => 'NUMBER'

1720: /* IF l_first_Inv
1721: THEN
1722: l_first_Inv:=FALSE;
1723: fnd_message.SET_NAME('JMF','JMF_GTA_FP_TAX_REG_NUMBER');
1724: fnd_message.SET_TOKEN( TOKEN => 'NUMBER'
1725: , VALUE => l_header_rec_cur.fp_tax_registration_number
1726: );
1727: put_line(g_comment_delimiter||fnd_message.GET);
1728:

Line 1727: put_line(g_comment_delimiter||fnd_message.GET);

1723: fnd_message.SET_NAME('JMF','JMF_GTA_FP_TAX_REG_NUMBER');
1724: fnd_message.SET_TOKEN( TOKEN => 'NUMBER'
1725: , VALUE => l_header_rec_cur.fp_tax_registration_number
1726: );
1727: put_line(g_comment_delimiter||fnd_message.GET);
1728:
1729: END IF;*/
1730:
1731: l_gta_trx_header_id:=l_header_rec_cur.gta_trx_header_id;

Line 1765: fnd_message.SET_NAME('JMF','JMF_GTA_CRMEMO_PREFIX');

1761:
1762: IF ( (p_GTA_trx_header.invoice_type <> '2') AND
1763: ( lv_trx_type = 'CM'))
1764: THEN
1765: fnd_message.SET_NAME('JMF','JMF_GTA_CRMEMO_PREFIX');
1766: lv_crmemo_prefix_msg := fnd_message.GET;
1767: ln_pos := length(lv_crmemo_prefix_msg);
1768:
1769:

Line 1766: lv_crmemo_prefix_msg := fnd_message.GET;

1762: IF ( (p_GTA_trx_header.invoice_type <> '2') AND
1763: ( lv_trx_type = 'CM'))
1764: THEN
1765: fnd_message.SET_NAME('JMF','JMF_GTA_CRMEMO_PREFIX');
1766: lv_crmemo_prefix_msg := fnd_message.GET;
1767: ln_pos := length(lv_crmemo_prefix_msg);
1768:
1769:
1770: lv_trx_crmemo_prefix_msg := substr(p_GTA_trx_header.description

Line 1796: fnd_message.SET_NAME('JMF','JMF_GTA_CRMEMO_MISSING_PREFIX');

1792: IF (lv_trx_crmemo_prefix_msg <> lv_crmemo_prefix_msg
1793: OR lb_num_flag = FALSE)
1794: THEN
1795: gv_prefix_missing_flag := 'TRUE';
1796: fnd_message.SET_NAME('JMF','JMF_GTA_CRMEMO_MISSING_PREFIX');
1797: l_missing_prefix_output.EXTEND;
1798: l_missing_prefix_output(l_missing_prefix_output.LAST):= fnd_message.GET;
1799: END IF; --lv_trx_crmemo_prefix_msg <> lv_crmemo_prefix_msg
1800: -- END IF;

Line 1798: l_missing_prefix_output(l_missing_prefix_output.LAST):= fnd_message.GET;

1794: THEN
1795: gv_prefix_missing_flag := 'TRUE';
1796: fnd_message.SET_NAME('JMF','JMF_GTA_CRMEMO_MISSING_PREFIX');
1797: l_missing_prefix_output.EXTEND;
1798: l_missing_prefix_output(l_missing_prefix_output.LAST):= fnd_message.GET;
1799: END IF; --lv_trx_crmemo_prefix_msg <> lv_crmemo_prefix_msg
1800: -- END IF;
1801:
1802: /*

Line 1813: fnd_message.SET_NAME('JMF','JMF_GTA_CRMEMO_DUP_TITLE');

1809:
1810: IF gv_dup_title_flag = 'FALSE'
1811: THEN
1812: l_crmemo_dup_err_output.EXTEND;
1813: fnd_message.SET_NAME('JMF','JMF_GTA_CRMEMO_DUP_TITLE');
1814: l_crmemo_dup_err_output(l_crmemo_dup_err_output.LAST):= fnd_message.GET;
1815:
1816: gv_dup_title_flag := 'TRUE';
1817: END IF;

Line 1814: l_crmemo_dup_err_output(l_crmemo_dup_err_output.LAST):= fnd_message.GET;

1810: IF gv_dup_title_flag = 'FALSE'
1811: THEN
1812: l_crmemo_dup_err_output.EXTEND;
1813: fnd_message.SET_NAME('JMF','JMF_GTA_CRMEMO_DUP_TITLE');
1814: l_crmemo_dup_err_output(l_crmemo_dup_err_output.LAST):= fnd_message.GET;
1815:
1816: gv_dup_title_flag := 'TRUE';
1817: END IF;
1818:

Line 1859: fnd_message.SET_NAME('JMF','JMF_GTA_CRMEMO_DUP');

1855: FROM hr_operating_units hr
1856: WHERE hr.organization_id = p_GTA_trx_header.org_id;
1857: --AND MO_GLOBAL.Check_Access(hr.organization_id) = 'Y'
1858:
1859: fnd_message.SET_NAME('JMF','JMF_GTA_CRMEMO_DUP');
1860: fnd_message.SET_TOKEN( TOKEN => 'INVOICE_NUMBER1'
1861: , VALUE => p_GTA_trx_header.gta_trx_number
1862: );
1863: fnd_message.SET_TOKEN( TOKEN => 'ORG_NAME1'

Line 1860: fnd_message.SET_TOKEN( TOKEN => 'INVOICE_NUMBER1'

1856: WHERE hr.organization_id = p_GTA_trx_header.org_id;
1857: --AND MO_GLOBAL.Check_Access(hr.organization_id) = 'Y'
1858:
1859: fnd_message.SET_NAME('JMF','JMF_GTA_CRMEMO_DUP');
1860: fnd_message.SET_TOKEN( TOKEN => 'INVOICE_NUMBER1'
1861: , VALUE => p_GTA_trx_header.gta_trx_number
1862: );
1863: fnd_message.SET_TOKEN( TOKEN => 'ORG_NAME1'
1864: , VALUE => ln_dup_org_name1

Line 1863: fnd_message.SET_TOKEN( TOKEN => 'ORG_NAME1'

1859: fnd_message.SET_NAME('JMF','JMF_GTA_CRMEMO_DUP');
1860: fnd_message.SET_TOKEN( TOKEN => 'INVOICE_NUMBER1'
1861: , VALUE => p_GTA_trx_header.gta_trx_number
1862: );
1863: fnd_message.SET_TOKEN( TOKEN => 'ORG_NAME1'
1864: , VALUE => ln_dup_org_name1
1865: );
1866:
1867: SELECT hr.name

Line 1873: --fnd_message.SET_NAME('JMF','JMF_GTA_CRMEMO_DUP');

1869: FROM hr_operating_units hr
1870: WHERE hr.organization_id = ln_trx_org_id;
1871: --AND MO_GLOBAL.Check_Access(hr.organization_id) = 'Y'
1872:
1873: --fnd_message.SET_NAME('JMF','JMF_GTA_CRMEMO_DUP');
1874: fnd_message.SET_TOKEN( TOKEN => 'INVOICE_NUMBER2'
1875: , VALUE => ln_gta_trx_number
1876: );
1877: fnd_message.SET_TOKEN( TOKEN => 'ORG_NAME2'

Line 1874: fnd_message.SET_TOKEN( TOKEN => 'INVOICE_NUMBER2'

1870: WHERE hr.organization_id = ln_trx_org_id;
1871: --AND MO_GLOBAL.Check_Access(hr.organization_id) = 'Y'
1872:
1873: --fnd_message.SET_NAME('JMF','JMF_GTA_CRMEMO_DUP');
1874: fnd_message.SET_TOKEN( TOKEN => 'INVOICE_NUMBER2'
1875: , VALUE => ln_gta_trx_number
1876: );
1877: fnd_message.SET_TOKEN( TOKEN => 'ORG_NAME2'
1878: , VALUE => ln_dup_org_name2

Line 1877: fnd_message.SET_TOKEN( TOKEN => 'ORG_NAME2'

1873: --fnd_message.SET_NAME('JMF','JMF_GTA_CRMEMO_DUP');
1874: fnd_message.SET_TOKEN( TOKEN => 'INVOICE_NUMBER2'
1875: , VALUE => ln_gta_trx_number
1876: );
1877: fnd_message.SET_TOKEN( TOKEN => 'ORG_NAME2'
1878: , VALUE => ln_dup_org_name2
1879: );
1880:
1881: l_crmemo_dup_err_output.EXTEND;

Line 1882: l_crmemo_dup_err_output(l_crmemo_dup_err_output.LAST):= fnd_message.GET;

1878: , VALUE => ln_dup_org_name2
1879: );
1880:
1881: l_crmemo_dup_err_output.EXTEND;
1882: l_crmemo_dup_err_output(l_crmemo_dup_err_output.LAST):= fnd_message.GET;
1883:
1884: -------------------------------------------------------------------
1885: -- modified by Lv Xiao for bug#7644803 on 18-Dec-2008, end
1886:

Line 1970: fnd_message.SET_NAME('JMF','JMF_GTA_NO_DATA_FOUND');

1966: AND l_crmemo_dup_err_output.COUNT=0
1967: ------------------------------------------------------
1968: --add by Lv Xiao for bug#7626503 on 9-DEC-2008, end
1969: THEN
1970: fnd_message.SET_NAME('JMF','JMF_GTA_NO_DATA_FOUND');
1971: l_error_msg:=g_comment_delimiter||fnd_message.GET;
1972: put_line(l_error_msg||'..pls check the invoice type you selected');
1973: RETURN;
1974: END IF;

Line 1971: l_error_msg:=g_comment_delimiter||fnd_message.GET;

1967: ------------------------------------------------------
1968: --add by Lv Xiao for bug#7626503 on 9-DEC-2008, end
1969: THEN
1970: fnd_message.SET_NAME('JMF','JMF_GTA_NO_DATA_FOUND');
1971: l_error_msg:=g_comment_delimiter||fnd_message.GET;
1972: put_line(l_error_msg||'..pls check the invoice type you selected');
1973: RETURN;
1974: END IF;
1975: --write the output to flat file

Line 1978: fnd_message.SET_NAME( APPLICATION => 'JMF'

1974: END IF;
1975: --write the output to flat file
1976:
1977: -- Get the export identity of export flat file
1978: fnd_message.SET_NAME( APPLICATION => 'JMF'
1979: , NAME => 'JMF_GTA_INVOICE_EXPORT'
1980: );
1981: fnd_message.SET_TOKEN( TOKEN => 'MIDFIX'
1982: , VALUE => g_export_delimiter

Line 1981: fnd_message.SET_TOKEN( TOKEN => 'MIDFIX'

1977: -- Get the export identity of export flat file
1978: fnd_message.SET_NAME( APPLICATION => 'JMF'
1979: , NAME => 'JMF_GTA_INVOICE_EXPORT'
1980: );
1981: fnd_message.SET_TOKEN( TOKEN => 'MIDFIX'
1982: , VALUE => g_export_delimiter
1983: );
1984:
1985: l_str:=fnd_message.get;

Line 1985: l_str:=fnd_message.get;

1981: fnd_message.SET_TOKEN( TOKEN => 'MIDFIX'
1982: , VALUE => g_export_delimiter
1983: );
1984:
1985: l_str:=fnd_message.get;
1986:
1987: -- Put it out
1988: put_line(l_str);
1989:

Line 1991: fnd_message.SET_NAME('JMF','JMF_GTA_FP_TAX_REG_NUMBER');

1987: -- Put it out
1988: put_line(l_str);
1989:
1990: l_first_Inv:=FALSE;
1991: fnd_message.SET_NAME('JMF','JMF_GTA_FP_TAX_REG_NUMBER');
1992: fnd_message.SET_TOKEN( TOKEN => 'NUMBER'
1993: , VALUE => l_header_rec_cur.fp_tax_registration_number
1994: );
1995:

Line 1992: fnd_message.SET_TOKEN( TOKEN => 'NUMBER'

1988: put_line(l_str);
1989:
1990: l_first_Inv:=FALSE;
1991: fnd_message.SET_NAME('JMF','JMF_GTA_FP_TAX_REG_NUMBER');
1992: fnd_message.SET_TOKEN( TOKEN => 'NUMBER'
1993: , VALUE => l_header_rec_cur.fp_tax_registration_number
1994: );
1995:
1996: put_line(g_comment_delimiter||fnd_message.GET);

Line 1996: put_line(g_comment_delimiter||fnd_message.GET);

1992: fnd_message.SET_TOKEN( TOKEN => 'NUMBER'
1993: , VALUE => l_header_rec_cur.fp_tax_registration_number
1994: );
1995:
1996: put_line(g_comment_delimiter||fnd_message.GET);
1997:
1998: IF l_succ_output.COUNT > 0
1999: THEN
2000: i:=l_succ_output.FIRST;

Line 2011: fnd_message.SET_NAME('JMF','JMF_GTA_EXCEED_LENGTH');

2007:
2008:
2009: IF l_exceed_output.COUNT>0
2010: THEN
2011: fnd_message.SET_NAME('JMF','JMF_GTA_EXCEED_LENGTH');
2012: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2013: put_line(l_error_msg);
2014:
2015: i:=l_exceed_output.FIRST;

Line 2012: l_error_msg:=g_comment_delimiter||fnd_message.GET;

2008:
2009: IF l_exceed_output.COUNT>0
2010: THEN
2011: fnd_message.SET_NAME('JMF','JMF_GTA_EXCEED_LENGTH');
2012: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2013: put_line(l_error_msg);
2014:
2015: i:=l_exceed_output.FIRST;
2016: WHILE i IS NOT NULL

Line 2026: fnd_message.SET_NAME('JMF','JMF_GTA_INVALID_LENGTH');

2022:
2023:
2024: IF l_taxpayid_err_out.COUNT>0
2025: THEN
2026: fnd_message.SET_NAME('JMF','JMF_GTA_INVALID_LENGTH');
2027: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2028: put_line(l_error_msg);
2029:
2030:

Line 2027: l_error_msg:=g_comment_delimiter||fnd_message.GET;

2023:
2024: IF l_taxpayid_err_out.COUNT>0
2025: THEN
2026: fnd_message.SET_NAME('JMF','JMF_GTA_INVALID_LENGTH');
2027: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2028: put_line(l_error_msg);
2029:
2030:
2031: i:=l_taxpayid_err_out.FIRST;

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

2038:
2039:
2040: IF l_creddit_memo_err.COUNT>0
2041: THEN
2042: fnd_message.SET_NAME('JMF','JMF_GTA_CRMEMO_MISSING_GTINV');
2043: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2044: put_line(l_error_msg);
2045:
2046:

Line 2043: l_error_msg:=g_comment_delimiter||fnd_message.GET;

2039:
2040: IF l_creddit_memo_err.COUNT>0
2041: THEN
2042: fnd_message.SET_NAME('JMF','JMF_GTA_CRMEMO_MISSING_GTINV');
2043: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2044: put_line(l_error_msg);
2045:
2046:
2047: i:=l_creddit_memo_err.FIRST;

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

2154: FROM jmf_gta_system_parameters_all s
2155: WHERE s.org_id=P_ORG_ID;
2156: EXCEPTION
2157: WHEN NO_DATA_FOUND THEN
2158: fnd_message.SET_NAME('JMF','JMF_GTA_SYS_CONFIG_MISSING');
2159: fnd_message.set_token(TOKEN => 'TAX_REGIS_NUMBER'
2160: ,VALUE => NULL
2161: );
2162:

Line 2159: fnd_message.set_token(TOKEN => 'TAX_REGIS_NUMBER'

2155: WHERE s.org_id=P_ORG_ID;
2156: EXCEPTION
2157: WHEN NO_DATA_FOUND THEN
2158: fnd_message.SET_NAME('JMF','JMF_GTA_SYS_CONFIG_MISSING');
2159: fnd_message.set_token(TOKEN => 'TAX_REGIS_NUMBER'
2160: ,VALUE => NULL
2161: );
2162:
2163: l_error_msg:=g_comment_delimiter||fnd_message.GET;

Line 2163: l_error_msg:=g_comment_delimiter||fnd_message.GET;

2159: fnd_message.set_token(TOKEN => 'TAX_REGIS_NUMBER'
2160: ,VALUE => NULL
2161: );
2162:
2163: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2164: put_line(l_error_msg);
2165: x_succ:=FALSE;
2166: RETURN;
2167: END;

Line 2180: fnd_message.SET_NAME('JMF','JMF_GTA_BATCH_NUM_MISSING');

2176: END IF;
2177:
2178: ELSIF x_batch_number IS NULL --manually
2179: THEN
2180: fnd_message.SET_NAME('JMF','JMF_GTA_BATCH_NUM_MISSING');
2181: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2182: put_line(l_error_msg);
2183: x_succ:=FALSE;
2184: RETURN;

Line 2181: l_error_msg:=g_comment_delimiter||fnd_message.GET;

2177:
2178: ELSIF x_batch_number IS NULL --manually
2179: THEN
2180: fnd_message.SET_NAME('JMF','JMF_GTA_BATCH_NUM_MISSING');
2181: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2182: put_line(l_error_msg);
2183: x_succ:=FALSE;
2184: RETURN;
2185:

Line 2199: fnd_message.SET_NAME('JMF','JMF_GTA_DUP_BATCHNUM');

2195: WHERE gta_batch_number=x_batch_number;
2196:
2197: IF l_rows_same_batch > 0
2198: THEN
2199: fnd_message.SET_NAME('JMF','JMF_GTA_DUP_BATCHNUM');
2200: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2201: put_line(l_error_msg);
2202: x_succ:=FALSE;
2203: RETURN;

Line 2200: l_error_msg:=g_comment_delimiter||fnd_message.GET;

2196:
2197: IF l_rows_same_batch > 0
2198: THEN
2199: fnd_message.SET_NAME('JMF','JMF_GTA_DUP_BATCHNUM');
2200: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2201: put_line(l_error_msg);
2202: x_succ:=FALSE;
2203: RETURN;
2204: END IF;

Line 2347: fnd_message.SET_NAME('JMF','JMF_GTA_NO_DATA_FOUND');

2343: OR P_Customer_id_from_Number <>
2344: nvl(P_cust_id_from_Taxpayer,P_Customer_id_from_Number)
2345: )
2346: THEN
2347: fnd_message.SET_NAME('JMF','JMF_GTA_NO_DATA_FOUND');
2348: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2349: put_line(l_error_msg);
2350: RETURN;
2351:

Line 2348: l_error_msg:=g_comment_delimiter||fnd_message.GET;

2344: nvl(P_cust_id_from_Taxpayer,P_Customer_id_from_Number)
2345: )
2346: THEN
2347: fnd_message.SET_NAME('JMF','JMF_GTA_NO_DATA_FOUND');
2348: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2349: put_line(l_error_msg);
2350: RETURN;
2351:
2352: ELSIF P_Customer_id_from_Number IS NOT NULL

Line 2361: fnd_message.SET_NAME('JMF','JMF_GTA_NO_DATA_FOUND');

2357: ELSIF P_Customer_id_FROM_Name IS NOT NULL
2358: AND P_Customer_id_FROM_Name <>
2359: nvl(P_cust_id_from_Taxpayer,P_Customer_id_FROM_Name)
2360: THEN
2361: fnd_message.SET_NAME('JMF','JMF_GTA_NO_DATA_FOUND');
2362: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2363: put_line(l_error_msg);
2364: RETURN;
2365: ELSE-- P_Customer_id_FROM_Name is null

Line 2362: l_error_msg:=g_comment_delimiter||fnd_message.GET;

2358: AND P_Customer_id_FROM_Name <>
2359: nvl(P_cust_id_from_Taxpayer,P_Customer_id_FROM_Name)
2360: THEN
2361: fnd_message.SET_NAME('JMF','JMF_GTA_NO_DATA_FOUND');
2362: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2363: put_line(l_error_msg);
2364: RETURN;
2365: ELSE-- P_Customer_id_FROM_Name is null
2366: --or P_Customer_id_FROM_Name=

Line 3100: fnd_message.SET_NAME( APPLICATION => 'JMF'

3096: RETURN G_EXPORT_MISSING;
3097:
3098: END;
3099:
3100: fnd_message.SET_NAME( APPLICATION => 'JMF'
3101: , NAME => 'JMF_GTA_CREDMEMO_EXPORT_IV'
3102: );
3103: l_cm_delimiter1:=fnd_message.get;
3104:

Line 3103: l_cm_delimiter1:=fnd_message.get;

3099:
3100: fnd_message.SET_NAME( APPLICATION => 'JMF'
3101: , NAME => 'JMF_GTA_CREDMEMO_EXPORT_IV'
3102: );
3103: l_cm_delimiter1:=fnd_message.get;
3104:
3105: fnd_message.SET_NAME( APPLICATION => 'JMF'
3106: , NAME => 'JMF_GTA_CREDMEMO_EXPORT_NR'
3107: );

Line 3105: fnd_message.SET_NAME( APPLICATION => 'JMF'

3101: , NAME => 'JMF_GTA_CREDMEMO_EXPORT_IV'
3102: );
3103: l_cm_delimiter1:=fnd_message.get;
3104:
3105: fnd_message.SET_NAME( APPLICATION => 'JMF'
3106: , NAME => 'JMF_GTA_CREDMEMO_EXPORT_NR'
3107: );
3108: l_cm_delimiter2:=fnd_message.get;
3109:

Line 3108: l_cm_delimiter2:=fnd_message.get;

3104:
3105: fnd_message.SET_NAME( APPLICATION => 'JMF'
3106: , NAME => 'JMF_GTA_CREDMEMO_EXPORT_NR'
3107: );
3108: l_cm_delimiter2:=fnd_message.get;
3109:
3110: IF l_trx_class='CM'
3111: AND ( p_GTA_trx_header.DESCRIPTION IS NULL
3112: OR instr(p_GTA_trx_header.description,l_cm_delimiter1)<1

Line 3381: fnd_message.set_name('JMF', 'JMF_GTA_BANKACCOUNT_MASKING');

3377:
3378: -- check the profile for bank account mask
3379: IF fnd_profile.VALUE('CE_MASK_INTERNAL_BANK_ACCT_NUM') <> 'NO MASK'
3380: THEN
3381: fnd_message.set_name('JMF', 'JMF_GTA_BANKACCOUNT_MASKING');
3382:
3383: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());
3384:
3385: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 3383: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());

3379: IF fnd_profile.VALUE('CE_MASK_INTERNAL_BANK_ACCT_NUM') <> 'NO MASK'
3380: THEN
3381: fnd_message.set_name('JMF', 'JMF_GTA_BANKACCOUNT_MASKING');
3382:
3383: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());
3384:
3385: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3386: THEN
3387: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED

Line 3400: fnd_message.set_name('JMF', 'JMF_GTA_CUSTOMER_EXPORT_LNA');

3396: END IF;
3397:
3398: --output the title. by message and token
3399: -- message line 1
3400: fnd_message.set_name('JMF', 'JMF_GTA_CUSTOMER_EXPORT_LNA');
3401: fnd_message.set_token('PREFIX', '{');
3402: fnd_message.set_token('MIDFIX', '}[');
3403: fnd_message.set_token('SUFFIX', ']"~~"');
3404: fnd_file.put_line(fnd_file.output, fnd_message.get());

Line 3401: fnd_message.set_token('PREFIX', '{');

3397:
3398: --output the title. by message and token
3399: -- message line 1
3400: fnd_message.set_name('JMF', 'JMF_GTA_CUSTOMER_EXPORT_LNA');
3401: fnd_message.set_token('PREFIX', '{');
3402: fnd_message.set_token('MIDFIX', '}[');
3403: fnd_message.set_token('SUFFIX', ']"~~"');
3404: fnd_file.put_line(fnd_file.output, fnd_message.get());
3405:

Line 3402: fnd_message.set_token('MIDFIX', '}[');

3398: --output the title. by message and token
3399: -- message line 1
3400: fnd_message.set_name('JMF', 'JMF_GTA_CUSTOMER_EXPORT_LNA');
3401: fnd_message.set_token('PREFIX', '{');
3402: fnd_message.set_token('MIDFIX', '}[');
3403: fnd_message.set_token('SUFFIX', ']"~~"');
3404: fnd_file.put_line(fnd_file.output, fnd_message.get());
3405:
3406: -- message line 2

Line 3403: fnd_message.set_token('SUFFIX', ']"~~"');

3399: -- message line 1
3400: fnd_message.set_name('JMF', 'JMF_GTA_CUSTOMER_EXPORT_LNA');
3401: fnd_message.set_token('PREFIX', '{');
3402: fnd_message.set_token('MIDFIX', '}[');
3403: fnd_message.set_token('SUFFIX', ']"~~"');
3404: fnd_file.put_line(fnd_file.output, fnd_message.get());
3405:
3406: -- message line 2
3407: fnd_message.set_name('JMF', 'JMF_GTA_CUSTOMER_EXPORT_LNB');

Line 3404: fnd_file.put_line(fnd_file.output, fnd_message.get());

3400: fnd_message.set_name('JMF', 'JMF_GTA_CUSTOMER_EXPORT_LNA');
3401: fnd_message.set_token('PREFIX', '{');
3402: fnd_message.set_token('MIDFIX', '}[');
3403: fnd_message.set_token('SUFFIX', ']"~~"');
3404: fnd_file.put_line(fnd_file.output, fnd_message.get());
3405:
3406: -- message line 2
3407: fnd_message.set_name('JMF', 'JMF_GTA_CUSTOMER_EXPORT_LNB');
3408: fnd_message.set_token('PREFIX', '//');

Line 3407: fnd_message.set_name('JMF', 'JMF_GTA_CUSTOMER_EXPORT_LNB');

3403: fnd_message.set_token('SUFFIX', ']"~~"');
3404: fnd_file.put_line(fnd_file.output, fnd_message.get());
3405:
3406: -- message line 2
3407: fnd_message.set_name('JMF', 'JMF_GTA_CUSTOMER_EXPORT_LNB');
3408: fnd_message.set_token('PREFIX', '//');
3409: fnd_message.set_token('SUFFIX', ':');
3410: fnd_file.put_line(fnd_file.output, fnd_message.get());
3411:

Line 3408: fnd_message.set_token('PREFIX', '//');

3404: fnd_file.put_line(fnd_file.output, fnd_message.get());
3405:
3406: -- message line 2
3407: fnd_message.set_name('JMF', 'JMF_GTA_CUSTOMER_EXPORT_LNB');
3408: fnd_message.set_token('PREFIX', '//');
3409: fnd_message.set_token('SUFFIX', ':');
3410: fnd_file.put_line(fnd_file.output, fnd_message.get());
3411:
3412: -- message line 3

Line 3409: fnd_message.set_token('SUFFIX', ':');

3405:
3406: -- message line 2
3407: fnd_message.set_name('JMF', 'JMF_GTA_CUSTOMER_EXPORT_LNB');
3408: fnd_message.set_token('PREFIX', '//');
3409: fnd_message.set_token('SUFFIX', ':');
3410: fnd_file.put_line(fnd_file.output, fnd_message.get());
3411:
3412: -- message line 3
3413: fnd_message.set_name('JMF', 'JMF_GTA_CUSTOMER_EXPORT_LNC');

Line 3410: fnd_file.put_line(fnd_file.output, fnd_message.get());

3406: -- message line 2
3407: fnd_message.set_name('JMF', 'JMF_GTA_CUSTOMER_EXPORT_LNB');
3408: fnd_message.set_token('PREFIX', '//');
3409: fnd_message.set_token('SUFFIX', ':');
3410: fnd_file.put_line(fnd_file.output, fnd_message.get());
3411:
3412: -- message line 3
3413: fnd_message.set_name('JMF', 'JMF_GTA_CUSTOMER_EXPORT_LNC');
3414: fnd_message.set_token('PREFIX', '//');

Line 3413: fnd_message.set_name('JMF', 'JMF_GTA_CUSTOMER_EXPORT_LNC');

3409: fnd_message.set_token('SUFFIX', ':');
3410: fnd_file.put_line(fnd_file.output, fnd_message.get());
3411:
3412: -- message line 3
3413: fnd_message.set_name('JMF', 'JMF_GTA_CUSTOMER_EXPORT_LNC');
3414: fnd_message.set_token('PREFIX', '//');
3415: fnd_message.set_token('MIDFIX', '~~');
3416: fnd_file.put_line(fnd_file.output, fnd_message.get());
3417:

Line 3414: fnd_message.set_token('PREFIX', '//');

3410: fnd_file.put_line(fnd_file.output, fnd_message.get());
3411:
3412: -- message line 3
3413: fnd_message.set_name('JMF', 'JMF_GTA_CUSTOMER_EXPORT_LNC');
3414: fnd_message.set_token('PREFIX', '//');
3415: fnd_message.set_token('MIDFIX', '~~');
3416: fnd_file.put_line(fnd_file.output, fnd_message.get());
3417:
3418: l_customer_num_from :=nvl(p_customer_num_from,' ');

Line 3415: fnd_message.set_token('MIDFIX', '~~');

3411:
3412: -- message line 3
3413: fnd_message.set_name('JMF', 'JMF_GTA_CUSTOMER_EXPORT_LNC');
3414: fnd_message.set_token('PREFIX', '//');
3415: fnd_message.set_token('MIDFIX', '~~');
3416: fnd_file.put_line(fnd_file.output, fnd_message.get());
3417:
3418: l_customer_num_from :=nvl(p_customer_num_from,' ');
3419: l_customer_num_to :=nvl(p_customer_num_to,rpad('z',30,'z'));

Line 3416: fnd_file.put_line(fnd_file.output, fnd_message.get());

3412: -- message line 3
3413: fnd_message.set_name('JMF', 'JMF_GTA_CUSTOMER_EXPORT_LNC');
3414: fnd_message.set_token('PREFIX', '//');
3415: fnd_message.set_token('MIDFIX', '~~');
3416: fnd_file.put_line(fnd_file.output, fnd_message.get());
3417:
3418: l_customer_num_from :=nvl(p_customer_num_from,' ');
3419: l_customer_num_to :=nvl(p_customer_num_to,rpad('z',30,'z'));
3420: l_customer_name_from :=nvl(p_customer_name_from,' ');

Line 3444: fnd_message.set_name('JMF', 'JMF_GTA_NO_DATA_FOUND');

3440: AND cust_party.party_type = 'ORGANIZATION';
3441:
3442: IF l_count = 0
3443: THEN
3444: fnd_message.set_name('JMF', 'JMF_GTA_NO_DATA_FOUND');
3445: l_error_string := fnd_message.get();
3446: fnd_file.put_line(fnd_file.OUTPUT, l_comment||l_error_string);
3447: END IF;
3448:

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

3441:
3442: IF l_count = 0
3443: THEN
3444: fnd_message.set_name('JMF', 'JMF_GTA_NO_DATA_FOUND');
3445: l_error_string := fnd_message.get();
3446: fnd_file.put_line(fnd_file.OUTPUT, l_comment||l_error_string);
3447: END IF;
3448:
3449: OPEN c_customer(l_customer_num_from

Line 3755: fnd_message.SET_NAME('JMF', 'JMF_GTA_INVALID_LENGTH');

3751: /*
3752: IF l_taxpayer_tbl.COUNT > 0
3753: THEN
3754: -- output JMF_GTA_INVALID_LENGTH
3755: fnd_message.SET_NAME('JMF', 'JMF_GTA_INVALID_LENGTH');
3756: l_error_string := fnd_message.get;
3757:
3758: fnd_file.put_line(fnd_file.output, l_comment||l_error_bound);
3759: fnd_file.PUT_LINE(fnd_file.output, l_comment||l_error_string);

Line 3756: l_error_string := fnd_message.get;

3752: IF l_taxpayer_tbl.COUNT > 0
3753: THEN
3754: -- output JMF_GTA_INVALID_LENGTH
3755: fnd_message.SET_NAME('JMF', 'JMF_GTA_INVALID_LENGTH');
3756: l_error_string := fnd_message.get;
3757:
3758: fnd_file.put_line(fnd_file.output, l_comment||l_error_bound);
3759: fnd_file.PUT_LINE(fnd_file.output, l_comment||l_error_string);
3760: fnd_file.put_line(fnd_file.output, '');

Line 3776: fnd_message.set_name('JMF', 'JMF_GTA_EXCEED_LENGTH');

3772: */
3773: IF l_exceed_tbl.COUNT > 0
3774: THEN
3775: -- output JMF_GTA_EXCEEDL_LENGTH message
3776: fnd_message.set_name('JMF', 'JMF_GTA_EXCEED_LENGTH');
3777: l_error_string := fnd_message.GET;
3778: fnd_file.put_line(fnd_file.output, l_comment||l_error_bound);
3779: fnd_file.PUT_LINE(fnd_file.output, l_comment||l_error_string);
3780: fnd_file.put_line(fnd_file.output, '');

Line 3777: l_error_string := fnd_message.GET;

3773: IF l_exceed_tbl.COUNT > 0
3774: THEN
3775: -- output JMF_GTA_EXCEEDL_LENGTH message
3776: fnd_message.set_name('JMF', 'JMF_GTA_EXCEED_LENGTH');
3777: l_error_string := fnd_message.GET;
3778: fnd_file.put_line(fnd_file.output, l_comment||l_error_bound);
3779: fnd_file.PUT_LINE(fnd_file.output, l_comment||l_error_string);
3780: fnd_file.put_line(fnd_file.output, '');
3781:

Line 4015: FND_MESSAGE.Set_Name(application => 'JMF'

4011: THEN
4012:
4013: --export required header section of export file
4014: --Line 1
4015: FND_MESSAGE.Set_Name(application => 'JMF'
4016: ,name => 'JMF_GTA_ITEM_EXPORT_LNA'
4017: );
4018: FND_MESSAGE.Set_Token(TOKEN =>'PREFIX'
4019: ,VALUE => '{'

Line 4018: FND_MESSAGE.Set_Token(TOKEN =>'PREFIX'

4014: --Line 1
4015: FND_MESSAGE.Set_Name(application => 'JMF'
4016: ,name => 'JMF_GTA_ITEM_EXPORT_LNA'
4017: );
4018: FND_MESSAGE.Set_Token(TOKEN =>'PREFIX'
4019: ,VALUE => '{'
4020: );
4021: FND_MESSAGE.Set_Token(TOKEN =>'MIDFIX'
4022: ,VALUE => '}['

Line 4021: FND_MESSAGE.Set_Token(TOKEN =>'MIDFIX'

4017: );
4018: FND_MESSAGE.Set_Token(TOKEN =>'PREFIX'
4019: ,VALUE => '{'
4020: );
4021: FND_MESSAGE.Set_Token(TOKEN =>'MIDFIX'
4022: ,VALUE => '}['
4023: );
4024: FND_MESSAGE.Set_Token(TOKEN =>'SUFFIX'
4025: ,VALUE => ']"~~"'

Line 4024: FND_MESSAGE.Set_Token(TOKEN =>'SUFFIX'

4020: );
4021: FND_MESSAGE.Set_Token(TOKEN =>'MIDFIX'
4022: ,VALUE => '}['
4023: );
4024: FND_MESSAGE.Set_Token(TOKEN =>'SUFFIX'
4025: ,VALUE => ']"~~"'
4026: );
4027: FND_FILE.Put_Line(FND_FILE.Output,FND_MESSAGE.GET);
4028:

Line 4027: FND_FILE.Put_Line(FND_FILE.Output,FND_MESSAGE.GET);

4023: );
4024: FND_MESSAGE.Set_Token(TOKEN =>'SUFFIX'
4025: ,VALUE => ']"~~"'
4026: );
4027: FND_FILE.Put_Line(FND_FILE.Output,FND_MESSAGE.GET);
4028:
4029: --Line2
4030: FND_MESSAGE.Set_Name(application => 'JMF'
4031: ,name => 'JMF_GTA_CUSTOMER_EXPORT_LNB'

Line 4030: FND_MESSAGE.Set_Name(application => 'JMF'

4026: );
4027: FND_FILE.Put_Line(FND_FILE.Output,FND_MESSAGE.GET);
4028:
4029: --Line2
4030: FND_MESSAGE.Set_Name(application => 'JMF'
4031: ,name => 'JMF_GTA_CUSTOMER_EXPORT_LNB'
4032: );
4033: FND_MESSAGE.Set_Token(TOKEN =>'PREFIX'
4034: ,VALUE => '//'

Line 4033: FND_MESSAGE.Set_Token(TOKEN =>'PREFIX'

4029: --Line2
4030: FND_MESSAGE.Set_Name(application => 'JMF'
4031: ,name => 'JMF_GTA_CUSTOMER_EXPORT_LNB'
4032: );
4033: FND_MESSAGE.Set_Token(TOKEN =>'PREFIX'
4034: ,VALUE => '//'
4035: );
4036: FND_MESSAGE.Set_Token(TOKEN =>'SUFFIX'
4037: ,VALUE => ':'

Line 4036: FND_MESSAGE.Set_Token(TOKEN =>'SUFFIX'

4032: );
4033: FND_MESSAGE.Set_Token(TOKEN =>'PREFIX'
4034: ,VALUE => '//'
4035: );
4036: FND_MESSAGE.Set_Token(TOKEN =>'SUFFIX'
4037: ,VALUE => ':'
4038: );
4039: FND_FILE.Put_Line(FND_FILE.Output,FND_MESSAGE.GET);
4040:

Line 4039: FND_FILE.Put_Line(FND_FILE.Output,FND_MESSAGE.GET);

4035: );
4036: FND_MESSAGE.Set_Token(TOKEN =>'SUFFIX'
4037: ,VALUE => ':'
4038: );
4039: FND_FILE.Put_Line(FND_FILE.Output,FND_MESSAGE.GET);
4040:
4041: --Line3
4042: FND_MESSAGE.Set_Name(application => 'JMF'
4043: ,name => 'JMF_GTA_ITEM_EXPORT_LNB'

Line 4042: FND_MESSAGE.Set_Name(application => 'JMF'

4038: );
4039: FND_FILE.Put_Line(FND_FILE.Output,FND_MESSAGE.GET);
4040:
4041: --Line3
4042: FND_MESSAGE.Set_Name(application => 'JMF'
4043: ,name => 'JMF_GTA_ITEM_EXPORT_LNB'
4044: );
4045: FND_MESSAGE.Set_Token(TOKEN =>'PREFIX'
4046: ,VALUE => '//'

Line 4045: FND_MESSAGE.Set_Token(TOKEN =>'PREFIX'

4041: --Line3
4042: FND_MESSAGE.Set_Name(application => 'JMF'
4043: ,name => 'JMF_GTA_ITEM_EXPORT_LNB'
4044: );
4045: FND_MESSAGE.Set_Token(TOKEN =>'PREFIX'
4046: ,VALUE => '//'
4047: );
4048: FND_MESSAGE.Set_Token(TOKEN =>'MIDFIX'
4049: ,VALUE => '~~'

Line 4048: FND_MESSAGE.Set_Token(TOKEN =>'MIDFIX'

4044: );
4045: FND_MESSAGE.Set_Token(TOKEN =>'PREFIX'
4046: ,VALUE => '//'
4047: );
4048: FND_MESSAGE.Set_Token(TOKEN =>'MIDFIX'
4049: ,VALUE => '~~'
4050: );
4051: FND_FILE.Put_Line(FND_FILE.Output,FND_MESSAGE.GET);
4052:

Line 4051: FND_FILE.Put_Line(FND_FILE.Output,FND_MESSAGE.GET);

4047: );
4048: FND_MESSAGE.Set_Token(TOKEN =>'MIDFIX'
4049: ,VALUE => '~~'
4050: );
4051: FND_FILE.Put_Line(FND_FILE.Output,FND_MESSAGE.GET);
4052:
4053: l_idx:='';
4054: l_idx:=l_export_item.FIRST;
4055: WHILE l_idx IS NOT NULL

Line 4090: FND_MESSAGE.Set_Name('JMF','JMF_GTA_ITEM_MISSING_CROSS_REF');

4086: --export exception item records
4087: IF l_noreference.COUNT>0
4088: THEN --export items that don't define cross reference
4089: FND_FILE.Put_Line(FND_FILE.Output,'//******************************');
4090: FND_MESSAGE.Set_Name('JMF','JMF_GTA_ITEM_MISSING_CROSS_REF');
4091: FND_FILE.Put_Line(FND_FILE.Output,'//'||FND_MESSAGE.Get);
4092:
4093: l_idx:='';
4094: l_idx:=l_noreference.FIRST;

Line 4091: FND_FILE.Put_Line(FND_FILE.Output,'//'||FND_MESSAGE.Get);

4087: IF l_noreference.COUNT>0
4088: THEN --export items that don't define cross reference
4089: FND_FILE.Put_Line(FND_FILE.Output,'//******************************');
4090: FND_MESSAGE.Set_Name('JMF','JMF_GTA_ITEM_MISSING_CROSS_REF');
4091: FND_FILE.Put_Line(FND_FILE.Output,'//'||FND_MESSAGE.Get);
4092:
4093: l_idx:='';
4094: l_idx:=l_noreference.FIRST;
4095: WHILE l_idx IS NOT NULL

Line 4108: FND_MESSAGE.Set_Name('JMF','JMF_GTA_EXCEED_LENGTH');

4104:
4105: IF l_item_length_exp.COUNT>0
4106: THEN --export items that exceed length limitation
4107: FND_FILE.Put_Line(FND_FILE.Output,'//******************************');
4108: FND_MESSAGE.Set_Name('JMF','JMF_GTA_EXCEED_LENGTH');
4109: FND_FILE.Put_Line(FND_FILE.Output,'//'||FND_MESSAGE.Get);
4110:
4111: l_idx:='';
4112: l_idx:=l_item_length_exp.FIRST;

Line 4109: FND_FILE.Put_Line(FND_FILE.Output,'//'||FND_MESSAGE.Get);

4105: IF l_item_length_exp.COUNT>0
4106: THEN --export items that exceed length limitation
4107: FND_FILE.Put_Line(FND_FILE.Output,'//******************************');
4108: FND_MESSAGE.Set_Name('JMF','JMF_GTA_EXCEED_LENGTH');
4109: FND_FILE.Put_Line(FND_FILE.Output,'//'||FND_MESSAGE.Get);
4110:
4111: l_idx:='';
4112: l_idx:=l_item_length_exp.FIRST;
4113: WHILE l_idx IS NOT NULL

Line 4564: FND_MESSAGE.Set_Name('JMF','JMF_GTA_NO_DATA_FOUND');

4560:
4561: --Export item to flat file
4562: IF l_export_item_count=0
4563: THEN --no data found
4564: FND_MESSAGE.Set_Name('JMF','JMF_GTA_NO_DATA_FOUND');
4565: l_nodatafound_msg:='//'||FND_MESSAGE.Get;
4566: FND_FILE.Put_Line(FND_FILE.Output
4567: ,l_nodatafound_msg
4568: );

Line 4565: l_nodatafound_msg:='//'||FND_MESSAGE.Get;

4561: --Export item to flat file
4562: IF l_export_item_count=0
4563: THEN --no data found
4564: FND_MESSAGE.Set_Name('JMF','JMF_GTA_NO_DATA_FOUND');
4565: l_nodatafound_msg:='//'||FND_MESSAGE.Get;
4566: FND_FILE.Put_Line(FND_FILE.Output
4567: ,l_nodatafound_msg
4568: );
4569: ELSIF l_export_item_count>0