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

Line 623: fnd_message.SET_NAME( APPLICATION => 'AR'

619: , x_EOF =>l_EOF
620: );
621:
622: IF l_EOF THEN
623: fnd_message.SET_NAME( APPLICATION => 'AR'
624: , NAME => 'AR_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);

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

621:
622: IF l_EOF THEN
623: fnd_message.SET_NAME( APPLICATION => 'AR'
624: , NAME => 'AR_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 635: fnd_message.SET_NAME( APPLICATION => 'AR'

631: END IF;
632:
633: --Get the fixed Chinese text used in export flat file which identify
634: --the flat file is the flat file exported from GT system
635: fnd_message.SET_NAME( APPLICATION => 'AR'
636: , NAME => 'AR_GTA_INVOICE_IMPORT');
637: fnd_message.SET_TOKEN( TOKEN => 'MIDFIX'
638: , VALUE => g_export_delimiter
639: );

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

633: --Get the fixed Chinese text used in export flat file which identify
634: --the flat file is the flat file exported from GT system
635: fnd_message.SET_NAME( APPLICATION => 'AR'
636: , NAME => 'AR_GTA_INVOICE_IMPORT');
637: fnd_message.SET_TOKEN( TOKEN => 'MIDFIX'
638: , VALUE => g_export_delimiter
639: );
640:
641: l_fix_field:=fnd_message.GET;

Line 641: l_fix_field:=fnd_message.GET;

637: fnd_message.SET_TOKEN( TOKEN => 'MIDFIX'
638: , VALUE => g_export_delimiter
639: );
640:
641: l_fix_field:=fnd_message.GET;
642: l_str:=l_values(1)||g_export_delimiter||l_values(2);
643:
644: --verify the file format.
645: --If <1: no fixed Chinese text, give flat file format error

Line 649: fnd_message.SET_NAME('AR','AR_GTA_UNMATCHED_INV_DATA_FMT');

645: --If <1: no fixed Chinese text, give flat file format error
646: --IF instr(l_str,l_fix_field)<1
647: IF instr(l_fix_field,l_values(1))<1 or instr(l_fix_field,l_values(2))<1
648: THEN
649: fnd_message.SET_NAME('AR','AR_GTA_UNMATCHED_INV_DATA_FMT');
650: l_error_msg := G_import_error_prefix||fnd_message.GET
651: ||G_import_error_suffix;
652: put_line(l_error_msg);
653: l_conc_succ:=FND_CONCURRENT.SET_COMPLETION_STATUS( status => 'WARNING'

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

646: --IF instr(l_str,l_fix_field)<1
647: IF instr(l_fix_field,l_values(1))<1 or instr(l_fix_field,l_values(2))<1
648: THEN
649: fnd_message.SET_NAME('AR','AR_GTA_UNMATCHED_INV_DATA_FMT');
650: l_error_msg := G_import_error_prefix||fnd_message.GET
651: ||G_import_error_suffix;
652: put_line(l_error_msg);
653: l_conc_succ:=FND_CONCURRENT.SET_COMPLETION_STATUS( status => 'WARNING'
654: , message => NULL);

Line 668: fnd_message.SET_NAME('AR','AR_GTA_UNMATCHED_INV_DATA_FMT');

664:
665: --it's an empty file
666: IF l_EOF
667: THEN
668: fnd_message.SET_NAME('AR','AR_GTA_UNMATCHED_INV_DATA_FMT');
669: l_error_msg := G_import_error_prefix||fnd_message.GET
670: ||G_import_error_suffix;
671: put_line(l_error_msg);
672: l_conc_succ:=FND_CONCURRENT.SET_COMPLETION_STATUS( status => 'WARNING'

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

665: --it's an empty file
666: IF l_EOF
667: THEN
668: fnd_message.SET_NAME('AR','AR_GTA_UNMATCHED_INV_DATA_FMT');
669: l_error_msg := G_import_error_prefix||fnd_message.GET
670: ||G_import_error_suffix;
671: put_line(l_error_msg);
672: l_conc_succ:=FND_CONCURRENT.SET_COMPLETION_STATUS( status => 'WARNING'
673: , message => NULL);

Line 725: fnd_message.SET_NAME('AR','AR_GTA_UNMATCHED_INV_DATA_FMT');

721: l_num_of_lines := l_values(6); --get lines number
722:
723: EXCEPTION
724: WHEN OTHERS THEN
725: fnd_message.SET_NAME('AR','AR_GTA_UNMATCHED_INV_DATA_FMT');
726: l_error_msg := G_import_error_prefix||fnd_message.GET
727: ||G_import_error_suffix;
728: put_line(l_error_msg);
729: l_conc_succ:=FND_CONCURRENT.SET_COMPLETION_STATUS

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

722:
723: EXCEPTION
724: WHEN OTHERS THEN
725: fnd_message.SET_NAME('AR','AR_GTA_UNMATCHED_INV_DATA_FMT');
726: l_error_msg := G_import_error_prefix||fnd_message.GET
727: ||G_import_error_suffix;
728: put_line(l_error_msg);
729: l_conc_succ:=FND_CONCURRENT.SET_COMPLETION_STATUS
730: ( status => 'WARNING'

Line 973: fnd_message.SET_NAME('AR','AR_GTA_UNMATCHED_INV_DATA_FMT');

969: EXCEPTION
970: WHEN OTHERS THEN
971:
972: l_failed:=TRUE;
973: fnd_message.SET_NAME('AR','AR_GTA_UNMATCHED_INV_DATA_FMT');
974: l_error_msg:=fnd_message.GET;
975:
976: IF(G_DEBUG_LEVEL >= l_dbg_level)
977: THEN

Line 974: l_error_msg:=fnd_message.GET;

970: WHEN OTHERS THEN
971:
972: l_failed:=TRUE;
973: fnd_message.SET_NAME('AR','AR_GTA_UNMATCHED_INV_DATA_FMT');
974: l_error_msg:=fnd_message.GET;
975:
976: IF(G_DEBUG_LEVEL >= l_dbg_level)
977: THEN
978: FND_LOG.string( G_DEBUG_LEVEL

Line 1098: fnd_message.SET_NAME( 'AR'

1094: EXCEPTION
1095: WHEN OTHERS THEN
1096: l_failed:=TRUE;
1097:
1098: fnd_message.SET_NAME( 'AR'
1099: , 'AR_GTA_UNMATCHED_INV_DATA_FMT');
1100: l_error_msg:=fnd_message.GET;
1101:
1102: IF(G_DEBUG_LEVEL >= l_dbg_level)

Line 1100: l_error_msg:=fnd_message.GET;

1096: l_failed:=TRUE;
1097:
1098: fnd_message.SET_NAME( 'AR'
1099: , 'AR_GTA_UNMATCHED_INV_DATA_FMT');
1100: l_error_msg:=fnd_message.GET;
1101:
1102: IF(G_DEBUG_LEVEL >= l_dbg_level)
1103: THEN
1104: FND_LOG.string( G_DEBUG_LEVEL

Line 1164: fnd_message.SET_NAME('AR'

1160: EXCEPTION
1161: WHEN OTHERS THEN
1162: l_failed:=TRUE;
1163:
1164: fnd_message.SET_NAME('AR'
1165: ,'AR_GTA_UNMATCHED_INV_DATA_FMT');
1166: l_error_msg:=fnd_message.GET;
1167:
1168: IF(G_DEBUG_LEVEL >= l_dbg_level)

Line 1166: l_error_msg:=fnd_message.GET;

1162: l_failed:=TRUE;
1163:
1164: fnd_message.SET_NAME('AR'
1165: ,'AR_GTA_UNMATCHED_INV_DATA_FMT');
1166: l_error_msg:=fnd_message.GET;
1167:
1168: IF(G_DEBUG_LEVEL >= l_dbg_level)
1169: THEN
1170: FND_LOG.string( G_DEBUG_LEVEL

Line 1236: fnd_message.SET_NAME('AR'

1232: ELSIF (l_status='COMPLETED')--has exists VAT invoice from GT
1233: THEN
1234: l_failed:=TRUE;
1235:
1236: fnd_message.SET_NAME('AR'
1237: ,'AR_GTA_IMP_PRIEXIST_FAIL');
1238: fnd_message.SET_TOKEN( TOKEN => 'NUM'
1239: , VALUE => l_Invoice_Num
1240: );

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

1234: l_failed:=TRUE;
1235:
1236: fnd_message.SET_NAME('AR'
1237: ,'AR_GTA_IMP_PRIEXIST_FAIL');
1238: fnd_message.SET_TOKEN( TOKEN => 'NUM'
1239: , VALUE => l_Invoice_Num
1240: );
1241:
1242: l_error_msg:=fnd_message.GET;

Line 1242: l_error_msg:=fnd_message.GET;

1238: fnd_message.SET_TOKEN( TOKEN => 'NUM'
1239: , VALUE => l_Invoice_Num
1240: );
1241:
1242: l_error_msg:=fnd_message.GET;
1243:
1244: INSERT INTO AR_GTA_IMPORT_REP_TEMP( SEQ
1245: , SUCCEEDED
1246: , Customer_Name

Line 1274: fnd_message.SET_NAME('AR'

1270: /*ELSIF (l_status='CANCELLED')--the VAT invoice was cancelled in GTA
1271: THEN
1272: l_failed:=TRUE;
1273:
1274: fnd_message.SET_NAME('AR'
1275: ,'AR_GTA_IMP_CANCEL');
1276: fnd_message.SET_TOKEN( TOKEN => 'NUM'
1277: , VALUE => l_Invoice_Num
1278: );

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

1272: l_failed:=TRUE;
1273:
1274: fnd_message.SET_NAME('AR'
1275: ,'AR_GTA_IMP_CANCEL');
1276: fnd_message.SET_TOKEN( TOKEN => 'NUM'
1277: , VALUE => l_Invoice_Num
1278: );
1279:
1280: l_error_msg:=fnd_message.GET;

Line 1280: l_error_msg:=fnd_message.GET;

1276: fnd_message.SET_TOKEN( TOKEN => 'NUM'
1277: , VALUE => l_Invoice_Num
1278: );
1279:
1280: l_error_msg:=fnd_message.GET;
1281:
1282: INSERT INTO AR_GTA_IMPORT_REP_TEMP( SEQ
1283: , SUCCEEDED
1284: , Customer_Name

Line 1310: fnd_message.SET_NAME('AR','AR_GTA_WRONG_INV_STATUS');

1306: END LOOP;
1307: --Jogen Jun-12 2006, bug*/
1308: --Delete by Sabrina for ER#14830536 End
1309: ELSE --status error
1310: fnd_message.SET_NAME('AR','AR_GTA_WRONG_INV_STATUS');
1311: l_error_msg:=fnd_message.GET;
1312:
1313: INSERT INTO AR_GTA_IMPORT_REP_TEMP( SEQ
1314: , SUCCEEDED

Line 1311: l_error_msg:=fnd_message.GET;

1307: --Jogen Jun-12 2006, bug*/
1308: --Delete by Sabrina for ER#14830536 End
1309: ELSE --status error
1310: fnd_message.SET_NAME('AR','AR_GTA_WRONG_INV_STATUS');
1311: l_error_msg:=fnd_message.GET;
1312:
1313: INSERT INTO AR_GTA_IMPORT_REP_TEMP( SEQ
1314: , SUCCEEDED
1315: , Customer_Name

Line 1341: /*fnd_message.SET_NAME('AR','AR_GTA_MOAC_FORBID');

1337: END LOOP;
1338: END IF;
1339: ELSE --MO_GLOBAL.Check_Access(l_org_id)<>'Y'
1340: --report AR_GTA_MOAC_ERROR;
1341: /*fnd_message.SET_NAME('AR','AR_GTA_MOAC_FORBID');
1342: l_error_msg:=fnd_message.GET;
1343:
1344: INSERT INTO AR_GTA_IMPORT_REP_TEMP( SEQ
1345: , SUCCEEDED

Line 1342: l_error_msg:=fnd_message.GET;

1338: END IF;
1339: ELSE --MO_GLOBAL.Check_Access(l_org_id)<>'Y'
1340: --report AR_GTA_MOAC_ERROR;
1341: /*fnd_message.SET_NAME('AR','AR_GTA_MOAC_FORBID');
1342: l_error_msg:=fnd_message.GET;
1343:
1344: INSERT INTO AR_GTA_IMPORT_REP_TEMP( SEQ
1345: , SUCCEEDED
1346: , Customer_Name

Line 1564: fnd_message.SET_NAME( APPLICATION => 'AR'

1560: --reserve one line for header output
1561: x_output:=t_invoice_export_output(NULL,NULL);
1562:
1563: --Get the comments of a single invoice
1564: fnd_message.SET_NAME( APPLICATION => 'AR'
1565: , NAME => 'AR_GTA_INVOICE_EXPORT_COMMT'
1566: );
1567: fnd_message.SET_TOKEN( TOKEN => 'PREFIX'
1568: , VALUE => g_comment_delimiter

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

1563: --Get the comments of a single invoice
1564: fnd_message.SET_NAME( APPLICATION => 'AR'
1565: , NAME => 'AR_GTA_INVOICE_EXPORT_COMMT'
1566: );
1567: fnd_message.SET_TOKEN( TOKEN => 'PREFIX'
1568: , VALUE => g_comment_delimiter
1569: );
1570:
1571: --put to the temporary output

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

1568: , VALUE => g_comment_delimiter
1569: );
1570:
1571: --put to the temporary output
1572: x_output(1):=fnd_message.get;
1573:
1574: ar_gta_trx_headers_all_pkg.query_row( p_header_id => p_invoice_header_id
1575: , x_trx_header_rec => l_invoice
1576: );

Line 1867: fnd_message.SET_NAME('AR','AR_GTA_BANKACCOUNT_MASKING');

1863: IF fnd_profile.VALUE('CE_MASK_INTERNAL_BANK_ACCT_NUM') IS NULL
1864: OR fnd_profile.VALUE('CE_MASK_INTERNAL_BANK_ACCT_NUM') <> 'NO MASK'
1865: THEN
1866: --report AR_GTA_BANKACCOUNT_MASKING
1867: fnd_message.SET_NAME('AR','AR_GTA_BANKACCOUNT_MASKING');
1868: l_error_msg:=fnd_message.GET;
1869: put_line(l_error_msg);
1870: --set concurrent status to warning
1871: l_conc_succ:=FND_CONCURRENT.SET_COMPLETION_STATUS( status => 'WARNING'

Line 1868: l_error_msg:=fnd_message.GET;

1864: OR fnd_profile.VALUE('CE_MASK_INTERNAL_BANK_ACCT_NUM') <> 'NO MASK'
1865: THEN
1866: --report AR_GTA_BANKACCOUNT_MASKING
1867: fnd_message.SET_NAME('AR','AR_GTA_BANKACCOUNT_MASKING');
1868: l_error_msg:=fnd_message.GET;
1869: put_line(l_error_msg);
1870: --set concurrent status to warning
1871: l_conc_succ:=FND_CONCURRENT.SET_COMPLETION_STATUS( status => 'WARNING'
1872: , message => NULL);

Line 1908: fnd_message.SET_NAME('AR','AR_GTA_FP_TAX_REG_NUMBER');

1904: EXIT WHEN P_cursor%NOTFOUND;
1905: /* IF l_first_Inv
1906: THEN
1907: l_first_Inv:=FALSE;
1908: fnd_message.SET_NAME('AR','AR_GTA_FP_TAX_REG_NUMBER');
1909: fnd_message.SET_TOKEN( TOKEN => 'NUMBER'
1910: , VALUE => l_header_rec_cur.fp_tax_registration_number
1911: );
1912: put_line(g_comment_delimiter||fnd_message.GET);

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

1905: /* IF l_first_Inv
1906: THEN
1907: l_first_Inv:=FALSE;
1908: fnd_message.SET_NAME('AR','AR_GTA_FP_TAX_REG_NUMBER');
1909: fnd_message.SET_TOKEN( TOKEN => 'NUMBER'
1910: , VALUE => l_header_rec_cur.fp_tax_registration_number
1911: );
1912: put_line(g_comment_delimiter||fnd_message.GET);
1913:

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

1908: fnd_message.SET_NAME('AR','AR_GTA_FP_TAX_REG_NUMBER');
1909: fnd_message.SET_TOKEN( TOKEN => 'NUMBER'
1910: , VALUE => l_header_rec_cur.fp_tax_registration_number
1911: );
1912: put_line(g_comment_delimiter||fnd_message.GET);
1913:
1914: END IF;*/
1915:
1916: l_gta_trx_header_id:=l_header_rec_cur.gta_trx_header_id;

Line 1966: fnd_message.SET_NAME('AR','AR_GTA_CRMEMO_PREFIX');

1962:
1963: IF ( (p_GTA_trx_header.invoice_type <> '2') AND
1964: ( lv_trx_type = 'CM'))
1965: THEN
1966: fnd_message.SET_NAME('AR','AR_GTA_CRMEMO_PREFIX');
1967: lv_crmemo_prefix_msg := fnd_message.GET;
1968: ln_pos := length(lv_crmemo_prefix_msg);
1969:
1970:

Line 1967: lv_crmemo_prefix_msg := fnd_message.GET;

1963: IF ( (p_GTA_trx_header.invoice_type <> '2') AND
1964: ( lv_trx_type = 'CM'))
1965: THEN
1966: fnd_message.SET_NAME('AR','AR_GTA_CRMEMO_PREFIX');
1967: lv_crmemo_prefix_msg := fnd_message.GET;
1968: ln_pos := length(lv_crmemo_prefix_msg);
1969:
1970:
1971: lv_trx_crmemo_prefix_msg := substr(p_GTA_trx_header.description

Line 1998: fnd_message.SET_NAME('AR','AR_GTA_CRMEMO_MISSING_PREFIX');

1994: OR lb_num_flag = FALSE)
1995: THEN
1996: gv_prefix_missing_flag := 'TRUE';
1997: /* commented by Allen Yang for bug 8981199 28-Sep-2009
1998: fnd_message.SET_NAME('AR','AR_GTA_CRMEMO_MISSING_PREFIX');
1999: l_missing_prefix_output.EXTEND;
2000: l_missing_prefix_output(l_missing_prefix_output.LAST):= fnd_message.GET;
2001: */
2002: END IF; --lv_trx_crmemo_prefix_msg <> lv_crmemo_prefix_msg

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

1996: gv_prefix_missing_flag := 'TRUE';
1997: /* commented by Allen Yang for bug 8981199 28-Sep-2009
1998: fnd_message.SET_NAME('AR','AR_GTA_CRMEMO_MISSING_PREFIX');
1999: l_missing_prefix_output.EXTEND;
2000: l_missing_prefix_output(l_missing_prefix_output.LAST):= fnd_message.GET;
2001: */
2002: END IF; --lv_trx_crmemo_prefix_msg <> lv_crmemo_prefix_msg
2003: -- END IF;
2004:

Line 2016: fnd_message.SET_NAME('AR','AR_GTA_CRMEMO_DUP_TITLE');

2012:
2013: IF gv_dup_title_flag = 'FALSE'
2014: THEN
2015: l_crmemo_dup_err_output.EXTEND;
2016: fnd_message.SET_NAME('AR','AR_GTA_CRMEMO_DUP_TITLE');
2017: l_crmemo_dup_err_output(l_crmemo_dup_err_output.LAST):= fnd_message.GET;
2018:
2019: gv_dup_title_flag := 'TRUE';
2020: END IF;

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

2013: IF gv_dup_title_flag = 'FALSE'
2014: THEN
2015: l_crmemo_dup_err_output.EXTEND;
2016: fnd_message.SET_NAME('AR','AR_GTA_CRMEMO_DUP_TITLE');
2017: l_crmemo_dup_err_output(l_crmemo_dup_err_output.LAST):= fnd_message.GET;
2018:
2019: gv_dup_title_flag := 'TRUE';
2020: END IF;
2021:

Line 2062: fnd_message.SET_NAME('AR','AR_GTA_CRMEMO_DUP');

2058: FROM hr_operating_units hr
2059: WHERE hr.organization_id = p_GTA_trx_header.org_id;
2060: --AND MO_GLOBAL.Check_Access(hr.organization_id) = 'Y'
2061:
2062: fnd_message.SET_NAME('AR','AR_GTA_CRMEMO_DUP');
2063: fnd_message.SET_TOKEN( TOKEN => 'INVOICE_NUMBER1'
2064: , VALUE => p_GTA_trx_header.gta_trx_number
2065: );
2066: fnd_message.SET_TOKEN( TOKEN => 'ORG_NAME1'

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

2059: WHERE hr.organization_id = p_GTA_trx_header.org_id;
2060: --AND MO_GLOBAL.Check_Access(hr.organization_id) = 'Y'
2061:
2062: fnd_message.SET_NAME('AR','AR_GTA_CRMEMO_DUP');
2063: fnd_message.SET_TOKEN( TOKEN => 'INVOICE_NUMBER1'
2064: , VALUE => p_GTA_trx_header.gta_trx_number
2065: );
2066: fnd_message.SET_TOKEN( TOKEN => 'ORG_NAME1'
2067: , VALUE => ln_dup_org_name1

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

2062: fnd_message.SET_NAME('AR','AR_GTA_CRMEMO_DUP');
2063: fnd_message.SET_TOKEN( TOKEN => 'INVOICE_NUMBER1'
2064: , VALUE => p_GTA_trx_header.gta_trx_number
2065: );
2066: fnd_message.SET_TOKEN( TOKEN => 'ORG_NAME1'
2067: , VALUE => ln_dup_org_name1
2068: );
2069:
2070: SELECT hr.name

Line 2076: --fnd_message.SET_NAME('AR','AR_GTA_CRMEMO_DUP');

2072: FROM hr_operating_units hr
2073: WHERE hr.organization_id = ln_trx_org_id;
2074: --AND MO_GLOBAL.Check_Access(hr.organization_id) = 'Y'
2075:
2076: --fnd_message.SET_NAME('AR','AR_GTA_CRMEMO_DUP');
2077: fnd_message.SET_TOKEN( TOKEN => 'INVOICE_NUMBER2'
2078: , VALUE => ln_gta_trx_number
2079: );
2080: fnd_message.SET_TOKEN( TOKEN => 'ORG_NAME2'

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

2073: WHERE hr.organization_id = ln_trx_org_id;
2074: --AND MO_GLOBAL.Check_Access(hr.organization_id) = 'Y'
2075:
2076: --fnd_message.SET_NAME('AR','AR_GTA_CRMEMO_DUP');
2077: fnd_message.SET_TOKEN( TOKEN => 'INVOICE_NUMBER2'
2078: , VALUE => ln_gta_trx_number
2079: );
2080: fnd_message.SET_TOKEN( TOKEN => 'ORG_NAME2'
2081: , VALUE => ln_dup_org_name2

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

2076: --fnd_message.SET_NAME('AR','AR_GTA_CRMEMO_DUP');
2077: fnd_message.SET_TOKEN( TOKEN => 'INVOICE_NUMBER2'
2078: , VALUE => ln_gta_trx_number
2079: );
2080: fnd_message.SET_TOKEN( TOKEN => 'ORG_NAME2'
2081: , VALUE => ln_dup_org_name2
2082: );
2083:
2084: l_crmemo_dup_err_output.EXTEND;

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

2081: , VALUE => ln_dup_org_name2
2082: );
2083:
2084: l_crmemo_dup_err_output.EXTEND;
2085: l_crmemo_dup_err_output(l_crmemo_dup_err_output.LAST):= fnd_message.GET;
2086:
2087: -------------------------------------------------------------------
2088: -- modified by Lv Xiao for bug#7644803 on 18-Dec-2008, end
2089:

Line 2156: fnd_message.SET_NAME('AR','AR_GTA_CRMEMO_MISSING_PREFIX');

2152: WHEN G_EXPORT_MISSING_PREFIX_ERROR THEN --MISSING_PREFIX_ERROR error section
2153: -- Modified by Allen Yang 28-Sep-2009 for bug 8981199
2154: ---------------------------------------------------------
2155: --NULL;
2156: fnd_message.SET_NAME('AR','AR_GTA_CRMEMO_MISSING_PREFIX');
2157: l_missing_prefix_output.EXTEND;
2158: l_missing_prefix_output(l_missing_prefix_output.LAST):= g_comment_delimiter||fnd_message.GET;
2159: i:=l_current_output.FIRST;
2160: WHILE i IS NOT NULL

Line 2158: l_missing_prefix_output(l_missing_prefix_output.LAST):= g_comment_delimiter||fnd_message.GET;

2154: ---------------------------------------------------------
2155: --NULL;
2156: fnd_message.SET_NAME('AR','AR_GTA_CRMEMO_MISSING_PREFIX');
2157: l_missing_prefix_output.EXTEND;
2158: l_missing_prefix_output(l_missing_prefix_output.LAST):= g_comment_delimiter||fnd_message.GET;
2159: i:=l_current_output.FIRST;
2160: WHILE i IS NOT NULL
2161: LOOP
2162: l_missing_prefix_output.EXTEND;

Line 2187: fnd_message.SET_NAME('AR','AR_GTA_NO_DATA_FOUND');

2183: AND l_crmemo_dup_err_output.COUNT=0
2184: ------------------------------------------------------
2185: --add by Lv Xiao for bug#7626503 on 9-DEC-2008, end
2186: THEN
2187: fnd_message.SET_NAME('AR','AR_GTA_NO_DATA_FOUND');
2188: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2189: put_line(l_error_msg);--Yao add for bug#8882568
2190: --put_line(l_error_msg||'..pls check the invoice type you selected');--Yao commented for bug#8882568
2191: RETURN;

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

2184: ------------------------------------------------------
2185: --add by Lv Xiao for bug#7626503 on 9-DEC-2008, end
2186: THEN
2187: fnd_message.SET_NAME('AR','AR_GTA_NO_DATA_FOUND');
2188: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2189: put_line(l_error_msg);--Yao add for bug#8882568
2190: --put_line(l_error_msg||'..pls check the invoice type you selected');--Yao commented for bug#8882568
2191: RETURN;
2192: END IF;

Line 2196: fnd_message.SET_NAME( APPLICATION => 'AR'

2192: END IF;
2193: --write the output to flat file
2194:
2195: -- Get the export identity of export flat file
2196: fnd_message.SET_NAME( APPLICATION => 'AR'
2197: , NAME => 'AR_GTA_INVOICE_EXPORT'
2198: );
2199: fnd_message.SET_TOKEN( TOKEN => 'MIDFIX'
2200: , VALUE => g_export_delimiter

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

2195: -- Get the export identity of export flat file
2196: fnd_message.SET_NAME( APPLICATION => 'AR'
2197: , NAME => 'AR_GTA_INVOICE_EXPORT'
2198: );
2199: fnd_message.SET_TOKEN( TOKEN => 'MIDFIX'
2200: , VALUE => g_export_delimiter
2201: );
2202:
2203: l_str:=fnd_message.get;

Line 2203: l_str:=fnd_message.get;

2199: fnd_message.SET_TOKEN( TOKEN => 'MIDFIX'
2200: , VALUE => g_export_delimiter
2201: );
2202:
2203: l_str:=fnd_message.get;
2204:
2205: -- Put it out
2206: put_line(l_str);
2207:

Line 2209: fnd_message.SET_NAME('AR','AR_GTA_FP_TAX_REG_NUMBER');

2205: -- Put it out
2206: put_line(l_str);
2207:
2208: l_first_Inv:=FALSE;
2209: fnd_message.SET_NAME('AR','AR_GTA_FP_TAX_REG_NUMBER');
2210: fnd_message.SET_TOKEN( TOKEN => 'NUMBER'
2211: , VALUE => l_header_rec_cur.fp_tax_registration_number
2212: );
2213:

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

2206: put_line(l_str);
2207:
2208: l_first_Inv:=FALSE;
2209: fnd_message.SET_NAME('AR','AR_GTA_FP_TAX_REG_NUMBER');
2210: fnd_message.SET_TOKEN( TOKEN => 'NUMBER'
2211: , VALUE => l_header_rec_cur.fp_tax_registration_number
2212: );
2213:
2214: put_line(g_comment_delimiter||fnd_message.GET);

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

2210: fnd_message.SET_TOKEN( TOKEN => 'NUMBER'
2211: , VALUE => l_header_rec_cur.fp_tax_registration_number
2212: );
2213:
2214: put_line(g_comment_delimiter||fnd_message.GET);
2215:
2216: IF l_succ_output.COUNT > 0
2217: THEN
2218: i:=l_succ_output.FIRST;

Line 2229: fnd_message.SET_NAME('AR','AR_GTA_EXCEED_LENGTH');

2225:
2226:
2227: IF l_exceed_output.COUNT>0
2228: THEN
2229: fnd_message.SET_NAME('AR','AR_GTA_EXCEED_LENGTH');
2230: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2231: put_line(l_error_msg);
2232:
2233: i:=l_exceed_output.FIRST;

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

2226:
2227: IF l_exceed_output.COUNT>0
2228: THEN
2229: fnd_message.SET_NAME('AR','AR_GTA_EXCEED_LENGTH');
2230: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2231: put_line(l_error_msg);
2232:
2233: i:=l_exceed_output.FIRST;
2234: WHILE i IS NOT NULL

Line 2244: fnd_message.SET_NAME('AR','AR_GTA_INVALID_LENGTH');

2240:
2241:
2242: IF l_taxpayid_err_out.COUNT>0
2243: THEN
2244: fnd_message.SET_NAME('AR','AR_GTA_INVALID_LENGTH');
2245: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2246: put_line(l_error_msg);
2247:
2248:

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

2241:
2242: IF l_taxpayid_err_out.COUNT>0
2243: THEN
2244: fnd_message.SET_NAME('AR','AR_GTA_INVALID_LENGTH');
2245: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2246: put_line(l_error_msg);
2247:
2248:
2249: i:=l_taxpayid_err_out.FIRST;

Line 2260: fnd_message.SET_NAME('AR','AR_GTA_CRMEMO_MISSING_GTINV');

2256:
2257:
2258: IF l_creddit_memo_err.COUNT>0
2259: THEN
2260: fnd_message.SET_NAME('AR','AR_GTA_CRMEMO_MISSING_GTINV');
2261: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2262: put_line(l_error_msg);
2263:
2264:

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

2257:
2258: IF l_creddit_memo_err.COUNT>0
2259: THEN
2260: fnd_message.SET_NAME('AR','AR_GTA_CRMEMO_MISSING_GTINV');
2261: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2262: put_line(l_error_msg);
2263:
2264:
2265: i:=l_creddit_memo_err.FIRST;

Line 2380: fnd_message.SET_NAME('AR','AR_GTA_SYS_CONFIG_MISSING');

2376: FROM ar_gta_system_parameters_all s
2377: WHERE s.org_id=P_ORG_ID;
2378: EXCEPTION
2379: WHEN NO_DATA_FOUND THEN
2380: fnd_message.SET_NAME('AR','AR_GTA_SYS_CONFIG_MISSING');
2381: fnd_message.set_token(TOKEN => 'TAX_REGIS_NUMBER'
2382: ,VALUE => NULL
2383: );
2384:

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

2377: WHERE s.org_id=P_ORG_ID;
2378: EXCEPTION
2379: WHEN NO_DATA_FOUND THEN
2380: fnd_message.SET_NAME('AR','AR_GTA_SYS_CONFIG_MISSING');
2381: fnd_message.set_token(TOKEN => 'TAX_REGIS_NUMBER'
2382: ,VALUE => NULL
2383: );
2384:
2385: l_error_msg:=g_comment_delimiter||fnd_message.GET;

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

2381: fnd_message.set_token(TOKEN => 'TAX_REGIS_NUMBER'
2382: ,VALUE => NULL
2383: );
2384:
2385: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2386: put_line(l_error_msg);
2387: x_succ:=FALSE;
2388: RETURN;
2389: END;

Line 2402: fnd_message.SET_NAME('AR','AR_GTA_BATCH_NUM_MISSING');

2398: END IF;
2399:
2400: ELSIF x_batch_number IS NULL --manually
2401: THEN
2402: fnd_message.SET_NAME('AR','AR_GTA_BATCH_NUM_MISSING');
2403: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2404: put_line(l_error_msg);
2405: x_succ:=FALSE;
2406: RETURN;

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

2399:
2400: ELSIF x_batch_number IS NULL --manually
2401: THEN
2402: fnd_message.SET_NAME('AR','AR_GTA_BATCH_NUM_MISSING');
2403: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2404: put_line(l_error_msg);
2405: x_succ:=FALSE;
2406: RETURN;
2407:

Line 2421: fnd_message.SET_NAME('AR','AR_GTA_DUP_BATCHNUM');

2417: WHERE gta_batch_number=x_batch_number;
2418:
2419: IF l_rows_same_batch > 0
2420: THEN
2421: fnd_message.SET_NAME('AR','AR_GTA_DUP_BATCHNUM');
2422: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2423: put_line(l_error_msg);
2424: x_succ:=FALSE;
2425: RETURN;

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

2418:
2419: IF l_rows_same_batch > 0
2420: THEN
2421: fnd_message.SET_NAME('AR','AR_GTA_DUP_BATCHNUM');
2422: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2423: put_line(l_error_msg);
2424: x_succ:=FALSE;
2425: RETURN;
2426: END IF;

Line 2569: fnd_message.SET_NAME('AR','AR_GTA_NO_DATA_FOUND');

2565: OR P_Customer_id_from_Number <>
2566: nvl(P_cust_id_from_Taxpayer,P_Customer_id_from_Number)
2567: )
2568: THEN
2569: fnd_message.SET_NAME('AR','AR_GTA_NO_DATA_FOUND');
2570: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2571: put_line(l_error_msg);
2572: RETURN;
2573:

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

2566: nvl(P_cust_id_from_Taxpayer,P_Customer_id_from_Number)
2567: )
2568: THEN
2569: fnd_message.SET_NAME('AR','AR_GTA_NO_DATA_FOUND');
2570: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2571: put_line(l_error_msg);
2572: RETURN;
2573:
2574: ELSIF P_Customer_id_from_Number IS NOT NULL

Line 2583: fnd_message.SET_NAME('AR','AR_GTA_NO_DATA_FOUND');

2579: ELSIF P_Customer_id_FROM_Name IS NOT NULL
2580: AND P_Customer_id_FROM_Name <>
2581: nvl(P_cust_id_from_Taxpayer,P_Customer_id_FROM_Name)
2582: THEN
2583: fnd_message.SET_NAME('AR','AR_GTA_NO_DATA_FOUND');
2584: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2585: put_line(l_error_msg);
2586: RETURN;
2587: ELSE-- P_Customer_id_FROM_Name is null

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

2580: AND P_Customer_id_FROM_Name <>
2581: nvl(P_cust_id_from_Taxpayer,P_Customer_id_FROM_Name)
2582: THEN
2583: fnd_message.SET_NAME('AR','AR_GTA_NO_DATA_FOUND');
2584: l_error_msg:=g_comment_delimiter||fnd_message.GET;
2585: put_line(l_error_msg);
2586: RETURN;
2587: ELSE-- P_Customer_id_FROM_Name is null
2588: --or P_Customer_id_FROM_Name=

Line 3340: fnd_message.SET_NAME( APPLICATION => 'AR'

3336: RETURN G_EXPORT_MISSING;
3337:
3338: END;
3339: END IF;
3340: fnd_message.SET_NAME( APPLICATION => 'AR'
3341: , NAME => 'AR_GTA_CREDMEMO_EXPORT_IV'
3342: );
3343: l_cm_delimiter1:=fnd_message.get;
3344:

Line 3343: l_cm_delimiter1:=fnd_message.get;

3339: END IF;
3340: fnd_message.SET_NAME( APPLICATION => 'AR'
3341: , NAME => 'AR_GTA_CREDMEMO_EXPORT_IV'
3342: );
3343: l_cm_delimiter1:=fnd_message.get;
3344:
3345: fnd_message.SET_NAME( APPLICATION => 'AR'
3346: , NAME => 'AR_GTA_CREDMEMO_EXPORT_NR'
3347: );

Line 3345: fnd_message.SET_NAME( APPLICATION => 'AR'

3341: , NAME => 'AR_GTA_CREDMEMO_EXPORT_IV'
3342: );
3343: l_cm_delimiter1:=fnd_message.get;
3344:
3345: fnd_message.SET_NAME( APPLICATION => 'AR'
3346: , NAME => 'AR_GTA_CREDMEMO_EXPORT_NR'
3347: );
3348: l_cm_delimiter2:=fnd_message.get;
3349:

Line 3348: l_cm_delimiter2:=fnd_message.get;

3344:
3345: fnd_message.SET_NAME( APPLICATION => 'AR'
3346: , NAME => 'AR_GTA_CREDMEMO_EXPORT_NR'
3347: );
3348: l_cm_delimiter2:=fnd_message.get;
3349:
3350: IF l_trx_class='CM'
3351: AND ( p_GTA_trx_header.DESCRIPTION IS NULL
3352: OR instr(p_GTA_trx_header.description,l_cm_delimiter1)<1

Line 3755: fnd_message.set_name('AR', 'AR_GTA_BANKACCOUNT_MASKING');

3751:
3752: -- check the profile for bank account mask
3753: IF fnd_profile.VALUE('CE_MASK_INTERNAL_BANK_ACCT_NUM') <> 'NO MASK'
3754: THEN
3755: fnd_message.set_name('AR', 'AR_GTA_BANKACCOUNT_MASKING');
3756:
3757: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());
3758:
3759: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

3753: IF fnd_profile.VALUE('CE_MASK_INTERNAL_BANK_ACCT_NUM') <> 'NO MASK'
3754: THEN
3755: fnd_message.set_name('AR', 'AR_GTA_BANKACCOUNT_MASKING');
3756:
3757: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());
3758:
3759: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3760: THEN
3761: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED

Line 3774: fnd_message.set_name('AR', 'AR_GTA_CUSTOMER_EXPORT_LNA');

3770: END IF;
3771:
3772: --output the title. by message and token
3773: -- message line 1
3774: fnd_message.set_name('AR', 'AR_GTA_CUSTOMER_EXPORT_LNA');
3775: fnd_message.set_token('PREFIX', '{');
3776: fnd_message.set_token('MIDFIX', '}[');
3777: fnd_message.set_token('SUFFIX', ']"~~"');
3778: fnd_file.put_line(fnd_file.output, fnd_message.get());

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

3771:
3772: --output the title. by message and token
3773: -- message line 1
3774: fnd_message.set_name('AR', 'AR_GTA_CUSTOMER_EXPORT_LNA');
3775: fnd_message.set_token('PREFIX', '{');
3776: fnd_message.set_token('MIDFIX', '}[');
3777: fnd_message.set_token('SUFFIX', ']"~~"');
3778: fnd_file.put_line(fnd_file.output, fnd_message.get());
3779:

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

3772: --output the title. by message and token
3773: -- message line 1
3774: fnd_message.set_name('AR', 'AR_GTA_CUSTOMER_EXPORT_LNA');
3775: fnd_message.set_token('PREFIX', '{');
3776: fnd_message.set_token('MIDFIX', '}[');
3777: fnd_message.set_token('SUFFIX', ']"~~"');
3778: fnd_file.put_line(fnd_file.output, fnd_message.get());
3779:
3780: -- message line 2

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

3773: -- message line 1
3774: fnd_message.set_name('AR', 'AR_GTA_CUSTOMER_EXPORT_LNA');
3775: fnd_message.set_token('PREFIX', '{');
3776: fnd_message.set_token('MIDFIX', '}[');
3777: fnd_message.set_token('SUFFIX', ']"~~"');
3778: fnd_file.put_line(fnd_file.output, fnd_message.get());
3779:
3780: -- message line 2
3781: fnd_message.set_name('AR', 'AR_GTA_CUSTOMER_EXPORT_LNB');

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

3774: fnd_message.set_name('AR', 'AR_GTA_CUSTOMER_EXPORT_LNA');
3775: fnd_message.set_token('PREFIX', '{');
3776: fnd_message.set_token('MIDFIX', '}[');
3777: fnd_message.set_token('SUFFIX', ']"~~"');
3778: fnd_file.put_line(fnd_file.output, fnd_message.get());
3779:
3780: -- message line 2
3781: fnd_message.set_name('AR', 'AR_GTA_CUSTOMER_EXPORT_LNB');
3782: fnd_message.set_token('PREFIX', '//');

Line 3781: fnd_message.set_name('AR', 'AR_GTA_CUSTOMER_EXPORT_LNB');

3777: fnd_message.set_token('SUFFIX', ']"~~"');
3778: fnd_file.put_line(fnd_file.output, fnd_message.get());
3779:
3780: -- message line 2
3781: fnd_message.set_name('AR', 'AR_GTA_CUSTOMER_EXPORT_LNB');
3782: fnd_message.set_token('PREFIX', '//');
3783: fnd_message.set_token('SUFFIX', ':');
3784: fnd_file.put_line(fnd_file.output, fnd_message.get());
3785:

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

3778: fnd_file.put_line(fnd_file.output, fnd_message.get());
3779:
3780: -- message line 2
3781: fnd_message.set_name('AR', 'AR_GTA_CUSTOMER_EXPORT_LNB');
3782: fnd_message.set_token('PREFIX', '//');
3783: fnd_message.set_token('SUFFIX', ':');
3784: fnd_file.put_line(fnd_file.output, fnd_message.get());
3785:
3786: -- message line 3

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

3779:
3780: -- message line 2
3781: fnd_message.set_name('AR', 'AR_GTA_CUSTOMER_EXPORT_LNB');
3782: fnd_message.set_token('PREFIX', '//');
3783: fnd_message.set_token('SUFFIX', ':');
3784: fnd_file.put_line(fnd_file.output, fnd_message.get());
3785:
3786: -- message line 3
3787: fnd_message.set_name('AR', 'AR_GTA_CUSTOMER_EXPORT_LNC');

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

3780: -- message line 2
3781: fnd_message.set_name('AR', 'AR_GTA_CUSTOMER_EXPORT_LNB');
3782: fnd_message.set_token('PREFIX', '//');
3783: fnd_message.set_token('SUFFIX', ':');
3784: fnd_file.put_line(fnd_file.output, fnd_message.get());
3785:
3786: -- message line 3
3787: fnd_message.set_name('AR', 'AR_GTA_CUSTOMER_EXPORT_LNC');
3788: fnd_message.set_token('PREFIX', '//');

Line 3787: fnd_message.set_name('AR', 'AR_GTA_CUSTOMER_EXPORT_LNC');

3783: fnd_message.set_token('SUFFIX', ':');
3784: fnd_file.put_line(fnd_file.output, fnd_message.get());
3785:
3786: -- message line 3
3787: fnd_message.set_name('AR', 'AR_GTA_CUSTOMER_EXPORT_LNC');
3788: fnd_message.set_token('PREFIX', '//');
3789: fnd_message.set_token('MIDFIX', '~~');
3790: fnd_file.put_line(fnd_file.output, fnd_message.get());
3791:

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

3784: fnd_file.put_line(fnd_file.output, fnd_message.get());
3785:
3786: -- message line 3
3787: fnd_message.set_name('AR', 'AR_GTA_CUSTOMER_EXPORT_LNC');
3788: fnd_message.set_token('PREFIX', '//');
3789: fnd_message.set_token('MIDFIX', '~~');
3790: fnd_file.put_line(fnd_file.output, fnd_message.get());
3791:
3792: l_customer_num_from :=nvl(p_customer_num_from,' ');

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

3785:
3786: -- message line 3
3787: fnd_message.set_name('AR', 'AR_GTA_CUSTOMER_EXPORT_LNC');
3788: fnd_message.set_token('PREFIX', '//');
3789: fnd_message.set_token('MIDFIX', '~~');
3790: fnd_file.put_line(fnd_file.output, fnd_message.get());
3791:
3792: l_customer_num_from :=nvl(p_customer_num_from,' ');
3793: l_customer_num_to :=nvl(p_customer_num_to,rpad('z',30,'z'));

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

3786: -- message line 3
3787: fnd_message.set_name('AR', 'AR_GTA_CUSTOMER_EXPORT_LNC');
3788: fnd_message.set_token('PREFIX', '//');
3789: fnd_message.set_token('MIDFIX', '~~');
3790: fnd_file.put_line(fnd_file.output, fnd_message.get());
3791:
3792: l_customer_num_from :=nvl(p_customer_num_from,' ');
3793: l_customer_num_to :=nvl(p_customer_num_to,rpad('z',30,'z'));
3794: l_customer_name_from :=nvl(p_customer_name_from,' ');

Line 3821: fnd_message.set_name('AR', 'AR_GTA_NO_DATA_FOUND');

3817: AND cust_party.party_type = 'ORGANIZATION';
3818:
3819: IF l_count = 0
3820: THEN
3821: fnd_message.set_name('AR', 'AR_GTA_NO_DATA_FOUND');
3822: l_error_string := fnd_message.get();
3823: fnd_file.put_line(fnd_file.OUTPUT, l_comment||l_error_string);
3824: END IF;
3825:

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

3818:
3819: IF l_count = 0
3820: THEN
3821: fnd_message.set_name('AR', 'AR_GTA_NO_DATA_FOUND');
3822: l_error_string := fnd_message.get();
3823: fnd_file.put_line(fnd_file.OUTPUT, l_comment||l_error_string);
3824: END IF;
3825:
3826: OPEN c_customer(l_customer_num_from

Line 4215: fnd_message.set_name('AR', 'AR_GTA_MUL_BANK_ON_CUSTOMER');

4211: string within max length, and display a message to say the bank
4212: accounts are not fully exported.
4213: */
4214: /*
4215: fnd_message.set_name('AR', 'AR_GTA_MUL_BANK_ON_CUSTOMER');
4216: l_error_string := fnd_message.GET;
4217: fnd_file.PUT_LINE(fnd_file.OUTPUT, l_comment||l_error_string);
4218: fnd_file.PUT_LINE(fnd_file.OUTPUT, l_comment||l_error_bound);
4219: fnd_file.PUT_LINE(fnd_file.OUTPUT, l_customer_number

Line 4216: l_error_string := fnd_message.GET;

4212: accounts are not fully exported.
4213: */
4214: /*
4215: fnd_message.set_name('AR', 'AR_GTA_MUL_BANK_ON_CUSTOMER');
4216: l_error_string := fnd_message.GET;
4217: fnd_file.PUT_LINE(fnd_file.OUTPUT, l_comment||l_error_string);
4218: fnd_file.PUT_LINE(fnd_file.OUTPUT, l_comment||l_error_bound);
4219: fnd_file.PUT_LINE(fnd_file.OUTPUT, l_customer_number
4220: ||l_bound

Line 4270: fnd_message.SET_NAME('AR', 'AR_GTA_INVALID_LENGTH');

4266: /*
4267: IF l_taxpayer_tbl.COUNT > 0
4268: THEN
4269: -- output AR_GTA_INVALID_LENGTH
4270: fnd_message.SET_NAME('AR', 'AR_GTA_INVALID_LENGTH');
4271: l_error_string := fnd_message.get;
4272:
4273: fnd_file.put_line(fnd_file.output, l_comment||l_error_bound);
4274: fnd_file.PUT_LINE(fnd_file.output, l_comment||l_error_string);

Line 4271: l_error_string := fnd_message.get;

4267: IF l_taxpayer_tbl.COUNT > 0
4268: THEN
4269: -- output AR_GTA_INVALID_LENGTH
4270: fnd_message.SET_NAME('AR', 'AR_GTA_INVALID_LENGTH');
4271: l_error_string := fnd_message.get;
4272:
4273: fnd_file.put_line(fnd_file.output, l_comment||l_error_bound);
4274: fnd_file.PUT_LINE(fnd_file.output, l_comment||l_error_string);
4275: fnd_file.put_line(fnd_file.output, '');

Line 4295: fnd_message.set_name('AR', 'AR_GTA_MUL_BANK_ON_CUSTOMER');

4291: -----------------------------------------------------------------
4292: IF l_bank_exceed_tbl.COUNT > 0
4293: THEN
4294: -- output AR_GTA_MUL_BANK_ON_CUSTOMER message
4295: fnd_message.set_name('AR', 'AR_GTA_MUL_BANK_ON_CUSTOMER');
4296: fnd_message.set_token(TOKEN => 'NUMBER'
4297: ,VALUE => l_bank_exceed_tbl.COUNT);
4298: l_error_string := fnd_message.GET;
4299: fnd_file.put_line(fnd_file.output, l_comment||l_error_bound);

Line 4296: fnd_message.set_token(TOKEN => 'NUMBER'

4292: IF l_bank_exceed_tbl.COUNT > 0
4293: THEN
4294: -- output AR_GTA_MUL_BANK_ON_CUSTOMER message
4295: fnd_message.set_name('AR', 'AR_GTA_MUL_BANK_ON_CUSTOMER');
4296: fnd_message.set_token(TOKEN => 'NUMBER'
4297: ,VALUE => l_bank_exceed_tbl.COUNT);
4298: l_error_string := fnd_message.GET;
4299: fnd_file.put_line(fnd_file.output, l_comment||l_error_bound);
4300: fnd_file.PUT_LINE(fnd_file.output, l_comment||l_error_string);

Line 4298: l_error_string := fnd_message.GET;

4294: -- output AR_GTA_MUL_BANK_ON_CUSTOMER message
4295: fnd_message.set_name('AR', 'AR_GTA_MUL_BANK_ON_CUSTOMER');
4296: fnd_message.set_token(TOKEN => 'NUMBER'
4297: ,VALUE => l_bank_exceed_tbl.COUNT);
4298: l_error_string := fnd_message.GET;
4299: fnd_file.put_line(fnd_file.output, l_comment||l_error_bound);
4300: fnd_file.PUT_LINE(fnd_file.output, l_comment||l_error_string);
4301: fnd_file.put_line(fnd_file.output, '');
4302:

Line 4316: fnd_message.set_name('AR', 'AR_GTA_EXCEED_LENGTH');

4312: -----------------------------------------------------------------
4313: IF l_exceed_tbl.COUNT > 0
4314: THEN
4315: -- output AR_GTA_EXCEEDL_LENGTH message
4316: fnd_message.set_name('AR', 'AR_GTA_EXCEED_LENGTH');
4317: l_error_string := fnd_message.GET;
4318: fnd_file.put_line(fnd_file.output, l_comment||l_error_bound);
4319: fnd_file.PUT_LINE(fnd_file.output, l_comment||l_error_string);
4320: fnd_file.put_line(fnd_file.output, '');

Line 4317: l_error_string := fnd_message.GET;

4313: IF l_exceed_tbl.COUNT > 0
4314: THEN
4315: -- output AR_GTA_EXCEEDL_LENGTH message
4316: fnd_message.set_name('AR', 'AR_GTA_EXCEED_LENGTH');
4317: l_error_string := fnd_message.GET;
4318: fnd_file.put_line(fnd_file.output, l_comment||l_error_bound);
4319: fnd_file.PUT_LINE(fnd_file.output, l_comment||l_error_string);
4320: fnd_file.put_line(fnd_file.output, '');
4321:

Line 4555: FND_MESSAGE.Set_Name(application => 'AR'

4551: THEN
4552:
4553: --export required header section of export file
4554: --Line 1
4555: FND_MESSAGE.Set_Name(application => 'AR'
4556: ,name => 'AR_GTA_ITEM_EXPORT_LNA'
4557: );
4558: FND_MESSAGE.Set_Token(TOKEN =>'PREFIX'
4559: ,VALUE => '{'

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

4554: --Line 1
4555: FND_MESSAGE.Set_Name(application => 'AR'
4556: ,name => 'AR_GTA_ITEM_EXPORT_LNA'
4557: );
4558: FND_MESSAGE.Set_Token(TOKEN =>'PREFIX'
4559: ,VALUE => '{'
4560: );
4561: FND_MESSAGE.Set_Token(TOKEN =>'MIDFIX'
4562: ,VALUE => '}['

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

4557: );
4558: FND_MESSAGE.Set_Token(TOKEN =>'PREFIX'
4559: ,VALUE => '{'
4560: );
4561: FND_MESSAGE.Set_Token(TOKEN =>'MIDFIX'
4562: ,VALUE => '}['
4563: );
4564: FND_MESSAGE.Set_Token(TOKEN =>'SUFFIX'
4565: ,VALUE => ']"~~"'

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

4560: );
4561: FND_MESSAGE.Set_Token(TOKEN =>'MIDFIX'
4562: ,VALUE => '}['
4563: );
4564: FND_MESSAGE.Set_Token(TOKEN =>'SUFFIX'
4565: ,VALUE => ']"~~"'
4566: );
4567: FND_FILE.Put_Line(FND_FILE.Output,FND_MESSAGE.GET);
4568:

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

4563: );
4564: FND_MESSAGE.Set_Token(TOKEN =>'SUFFIX'
4565: ,VALUE => ']"~~"'
4566: );
4567: FND_FILE.Put_Line(FND_FILE.Output,FND_MESSAGE.GET);
4568:
4569: --Line2
4570: FND_MESSAGE.Set_Name(application => 'AR'
4571: ,name => 'AR_GTA_CUSTOMER_EXPORT_LNB'

Line 4570: FND_MESSAGE.Set_Name(application => 'AR'

4566: );
4567: FND_FILE.Put_Line(FND_FILE.Output,FND_MESSAGE.GET);
4568:
4569: --Line2
4570: FND_MESSAGE.Set_Name(application => 'AR'
4571: ,name => 'AR_GTA_CUSTOMER_EXPORT_LNB'
4572: );
4573: FND_MESSAGE.Set_Token(TOKEN =>'PREFIX'
4574: ,VALUE => '//'

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

4569: --Line2
4570: FND_MESSAGE.Set_Name(application => 'AR'
4571: ,name => 'AR_GTA_CUSTOMER_EXPORT_LNB'
4572: );
4573: FND_MESSAGE.Set_Token(TOKEN =>'PREFIX'
4574: ,VALUE => '//'
4575: );
4576: FND_MESSAGE.Set_Token(TOKEN =>'SUFFIX'
4577: ,VALUE => ':'

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

4572: );
4573: FND_MESSAGE.Set_Token(TOKEN =>'PREFIX'
4574: ,VALUE => '//'
4575: );
4576: FND_MESSAGE.Set_Token(TOKEN =>'SUFFIX'
4577: ,VALUE => ':'
4578: );
4579: FND_FILE.Put_Line(FND_FILE.Output,FND_MESSAGE.GET);
4580:

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

4575: );
4576: FND_MESSAGE.Set_Token(TOKEN =>'SUFFIX'
4577: ,VALUE => ':'
4578: );
4579: FND_FILE.Put_Line(FND_FILE.Output,FND_MESSAGE.GET);
4580:
4581: --Line3
4582: FND_MESSAGE.Set_Name(application => 'AR'
4583: ,name => 'AR_GTA_ITEM_EXPORT_LNB'

Line 4582: FND_MESSAGE.Set_Name(application => 'AR'

4578: );
4579: FND_FILE.Put_Line(FND_FILE.Output,FND_MESSAGE.GET);
4580:
4581: --Line3
4582: FND_MESSAGE.Set_Name(application => 'AR'
4583: ,name => 'AR_GTA_ITEM_EXPORT_LNB'
4584: );
4585: FND_MESSAGE.Set_Token(TOKEN =>'PREFIX'
4586: ,VALUE => '//'

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

4581: --Line3
4582: FND_MESSAGE.Set_Name(application => 'AR'
4583: ,name => 'AR_GTA_ITEM_EXPORT_LNB'
4584: );
4585: FND_MESSAGE.Set_Token(TOKEN =>'PREFIX'
4586: ,VALUE => '//'
4587: );
4588: FND_MESSAGE.Set_Token(TOKEN =>'MIDFIX'
4589: ,VALUE => '~~'

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

4584: );
4585: FND_MESSAGE.Set_Token(TOKEN =>'PREFIX'
4586: ,VALUE => '//'
4587: );
4588: FND_MESSAGE.Set_Token(TOKEN =>'MIDFIX'
4589: ,VALUE => '~~'
4590: );
4591: FND_FILE.Put_Line(FND_FILE.Output,FND_MESSAGE.GET);
4592:

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

4587: );
4588: FND_MESSAGE.Set_Token(TOKEN =>'MIDFIX'
4589: ,VALUE => '~~'
4590: );
4591: FND_FILE.Put_Line(FND_FILE.Output,FND_MESSAGE.GET);
4592:
4593: l_idx:='';
4594: l_idx:=l_export_item.FIRST;
4595: WHILE l_idx IS NOT NULL

Line 4630: FND_MESSAGE.Set_Name('AR','AR_GTA_ITEM_MISSING_CROSS_REF');

4626: --export exception item records
4627: IF l_noreference.COUNT>0
4628: THEN --export items that don't define cross reference
4629: FND_FILE.Put_Line(FND_FILE.Output,'//******************************');
4630: FND_MESSAGE.Set_Name('AR','AR_GTA_ITEM_MISSING_CROSS_REF');
4631: FND_FILE.Put_Line(FND_FILE.Output,'//'||FND_MESSAGE.Get);
4632:
4633: l_idx:='';
4634: l_idx:=l_noreference.FIRST;

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

4627: IF l_noreference.COUNT>0
4628: THEN --export items that don't define cross reference
4629: FND_FILE.Put_Line(FND_FILE.Output,'//******************************');
4630: FND_MESSAGE.Set_Name('AR','AR_GTA_ITEM_MISSING_CROSS_REF');
4631: FND_FILE.Put_Line(FND_FILE.Output,'//'||FND_MESSAGE.Get);
4632:
4633: l_idx:='';
4634: l_idx:=l_noreference.FIRST;
4635: WHILE l_idx IS NOT NULL

Line 4648: FND_MESSAGE.Set_Name('AR','AR_GTA_EXCEED_LENGTH');

4644:
4645: IF l_item_length_exp.COUNT>0
4646: THEN --export items that exceed length limitation
4647: FND_FILE.Put_Line(FND_FILE.Output,'//******************************');
4648: FND_MESSAGE.Set_Name('AR','AR_GTA_EXCEED_LENGTH');
4649: FND_FILE.Put_Line(FND_FILE.Output,'//'||FND_MESSAGE.Get);
4650:
4651: l_idx:='';
4652: l_idx:=l_item_length_exp.FIRST;

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

4645: IF l_item_length_exp.COUNT>0
4646: THEN --export items that exceed length limitation
4647: FND_FILE.Put_Line(FND_FILE.Output,'//******************************');
4648: FND_MESSAGE.Set_Name('AR','AR_GTA_EXCEED_LENGTH');
4649: FND_FILE.Put_Line(FND_FILE.Output,'//'||FND_MESSAGE.Get);
4650:
4651: l_idx:='';
4652: l_idx:=l_item_length_exp.FIRST;
4653: WHILE l_idx IS NOT NULL

Line 5176: FND_MESSAGE.Set_Name('AR','AR_GTA_NO_DATA_FOUND');

5172:
5173: --Export item to flat file
5174: IF l_export_item_count=0
5175: THEN --no data found
5176: FND_MESSAGE.Set_Name('AR','AR_GTA_NO_DATA_FOUND');
5177: l_nodatafound_msg:='//'||FND_MESSAGE.Get;
5178: FND_FILE.Put_Line(FND_FILE.Output
5179: ,l_nodatafound_msg
5180: );

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

5173: --Export item to flat file
5174: IF l_export_item_count=0
5175: THEN --no data found
5176: FND_MESSAGE.Set_Name('AR','AR_GTA_NO_DATA_FOUND');
5177: l_nodatafound_msg:='//'||FND_MESSAGE.Get;
5178: FND_FILE.Put_Line(FND_FILE.Output
5179: ,l_nodatafound_msg
5180: );
5181: ELSIF l_export_item_count>0