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.AMW_IMPORT_STMNTS_ACCS_PKG dependencies on FND_FILE

Line 38: fnd_file.put_line(fnd_file.LOG,'AMW_FIN_IMPORT_FROM_FSG Profile Value' || m_fsg_or_not );

34: g_login_id := fnd_global.conc_login_id;
35:
36: select fnd_profile.value('AMW_FIN_IMPORT_FROM_FSG') into m_fsg_or_not from dual;
37:
38: fnd_file.put_line(fnd_file.LOG,'AMW_FIN_IMPORT_FROM_FSG Profile Value' || m_fsg_or_not );
39:
40: if (m_fsg_or_not is null or upper(trim(m_fsg_or_not)) = 'Y' or upper(trim(m_fsg_or_not)) = 'YES') then
41: IF check_account_value_set THEN
42: AMW_IMPORT_STMNTS_ACCS_PKG.get_acc_from_oracle_apps;

Line 58: fnd_file.put_line(fnd_file.LOG,g_errbuf );

54: -- RAISE ;
55: -- RETURN;
56: errbuf := g_errbuf ;
57: retcode := g_retcode;
58: fnd_file.put_line(fnd_file.LOG,g_errbuf );
59:
60:
61: END import_accounts;
62: ------------------------ ************************************* --------------------------

Line 78: fnd_file.put_line(fnd_file.LOG,'AMW_FIN_IMPORT_FROM_FSG Profile Value' || m_fsg_or_not );

74: g_login_id := fnd_global.conc_login_id;
75:
76:
77: select fnd_profile.value('AMW_FIN_IMPORT_FROM_FSG') into m_fsg_or_not from dual;
78: fnd_file.put_line(fnd_file.LOG,'AMW_FIN_IMPORT_FROM_FSG Profile Value' || m_fsg_or_not );
79:
80: if (m_fsg_or_not is null or upper(trim(m_fsg_or_not)) = 'Y' or upper(trim(m_fsg_or_not)) = 'YES') then
81:
82: if check_key_accounts_exists then

Line 99: fnd_file.put_line(fnd_file.LOG,g_errbuf );

95: END IF;
96: end;
97: errbuf := g_errbuf ;
98: retcode := g_retcode;
99: fnd_file.put_line(fnd_file.LOG,g_errbuf );
100:
101:
102:
103: END import_statements;

Line 276: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);

272:
273: M_FINANCIAL_STATEMENT_ID := statements_b_record.FINANCIAL_STATEMENT_ID;
274:
275:
276: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
277: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
278:
279: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_STMNT_ROW (
280: X_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID,

Line 277: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );

273: M_FINANCIAL_STATEMENT_ID := statements_b_record.FINANCIAL_STATEMENT_ID;
274:
275:
276: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
277: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
278:
279: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_STMNT_ROW (
280: X_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID,
281: X_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID ,

Line 318: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);

314: M_NAME := statement_tl_record.NAME;
315: M_LANGUAGE := statement_tl_record.LANGUAGE ;
316: M_SOURCE_LANGUAGE := statement_tl_record.SOURCE_LANGUAGE ;
317:
318: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
319: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
320: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_STATEMENT_NAME =' || M_NAME );
321: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for LANGUAGE =' || M_LANGUAGE );
322:

Line 319: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );

315: M_LANGUAGE := statement_tl_record.LANGUAGE ;
316: M_SOURCE_LANGUAGE := statement_tl_record.SOURCE_LANGUAGE ;
317:
318: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
319: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
320: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_STATEMENT_NAME =' || M_NAME );
321: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for LANGUAGE =' || M_LANGUAGE );
322:
323:

Line 320: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_STATEMENT_NAME =' || M_NAME );

316: M_SOURCE_LANGUAGE := statement_tl_record.SOURCE_LANGUAGE ;
317:
318: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
319: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
320: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_STATEMENT_NAME =' || M_NAME );
321: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for LANGUAGE =' || M_LANGUAGE );
322:
323:
324: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_STMNT_ROW_TL(

Line 321: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for LANGUAGE =' || M_LANGUAGE );

317:
318: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
319: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
320: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_STATEMENT_NAME =' || M_NAME );
321: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for LANGUAGE =' || M_LANGUAGE );
322:
323:
324: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_STMNT_ROW_TL(
325: X_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID,

Line 351: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);

347: M_FINANCIAL_ITEM_ID := statement_item_b_record.FINANCIAL_ITEM_ID;
348: M_PARENT_FINANCIAL_ITEM_ID := statement_item_b_record.PARENT_FINANCIAL_ITEM_ID ;
349: M_SEQUENCE_NUMBER := statement_item_b_record.SEQUENCE_NUMBER;
350:
351: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
352: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
353: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
354: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_FINANCIAL_ITEM_ID =' || M_PARENT_FINANCIAL_ITEM_ID );
355:

Line 352: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );

348: M_PARENT_FINANCIAL_ITEM_ID := statement_item_b_record.PARENT_FINANCIAL_ITEM_ID ;
349: M_SEQUENCE_NUMBER := statement_item_b_record.SEQUENCE_NUMBER;
350:
351: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
352: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
353: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
354: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_FINANCIAL_ITEM_ID =' || M_PARENT_FINANCIAL_ITEM_ID );
355:
356:

Line 353: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );

349: M_SEQUENCE_NUMBER := statement_item_b_record.SEQUENCE_NUMBER;
350:
351: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
352: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
353: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
354: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_FINANCIAL_ITEM_ID =' || M_PARENT_FINANCIAL_ITEM_ID );
355:
356:
357:

Line 354: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_FINANCIAL_ITEM_ID =' || M_PARENT_FINANCIAL_ITEM_ID );

350:
351: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
352: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
353: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
354: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_FINANCIAL_ITEM_ID =' || M_PARENT_FINANCIAL_ITEM_ID );
355:
356:
357:
358: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_FINITEM_ROW(

Line 401: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);

397: M_NAME := finitem_tl_record.NAME;
398: M_LANGUAGE := finitem_tl_record.LANGUAGE ;
399: M_SOURCE_LANGUAGE := finitem_tl_record.SOURCE_LANGUAGE ;
400:
401: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
402: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
403: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
404: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_ITEM_NAME =' || M_NAME );
405: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for LANGUAGE =' || M_LANGUAGE );

Line 402: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );

398: M_LANGUAGE := finitem_tl_record.LANGUAGE ;
399: M_SOURCE_LANGUAGE := finitem_tl_record.SOURCE_LANGUAGE ;
400:
401: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
402: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
403: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
404: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_ITEM_NAME =' || M_NAME );
405: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for LANGUAGE =' || M_LANGUAGE );
406:

Line 403: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );

399: M_SOURCE_LANGUAGE := finitem_tl_record.SOURCE_LANGUAGE ;
400:
401: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
402: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
403: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
404: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_ITEM_NAME =' || M_NAME );
405: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for LANGUAGE =' || M_LANGUAGE );
406:
407:

Line 404: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_ITEM_NAME =' || M_NAME );

400:
401: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
402: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
403: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
404: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_ITEM_NAME =' || M_NAME );
405: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for LANGUAGE =' || M_LANGUAGE );
406:
407:
408: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_FINITEM_ROW_TL(

Line 405: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for LANGUAGE =' || M_LANGUAGE );

401: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
402: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
403: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
404: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_ITEM_NAME =' || M_NAME );
405: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for LANGUAGE =' || M_LANGUAGE );
406:
407:
408: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_FINITEM_ROW_TL(
409: X_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID,

Line 443: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);

439: exit when Get_acc_values_from_icm%notfound;
440: M_ACCOUNT_GROUP_ID := get_account_id.ACCOUNT_GROUP_ID;
441: end loop;
442:
443: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
444: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
445: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
446: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
447: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);

Line 444: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );

440: M_ACCOUNT_GROUP_ID := get_account_id.ACCOUNT_GROUP_ID;
441: end loop;
442:
443: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
444: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
445: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
446: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
447: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
448:

Line 445: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );

441: end loop;
442:
443: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
444: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
445: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
446: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
447: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
448:
449:

Line 446: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);

442:
443: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
444: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
445: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
446: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
447: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
448:
449:
450: if (M_ACCOUNT_GROUP_ID is not null) then

Line 447: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);

443: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
444: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
445: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
446: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
447: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
448:
449:
450: if (M_ACCOUNT_GROUP_ID is not null) then
451: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_FINITEM_ACC_MAP(

Line 493: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

489:
490: commit;
491: end;
492: EXCEPTION WHEN OTHERS THEN
493: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
494: -- dbms_output.put_line(SQLERRM);
495: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
496: g_retcode := '2';
497:

Line 588: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID = ' || M_STATEMENT_GROUP_ID);

584:
585: exit when Get_statements_from_ora_gl%notfound;
586: M_FINANCIAL_STATEMENT_ID := statements.FINANCIAL_STATEMENT_ID;
587:
588: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID = ' || M_STATEMENT_GROUP_ID);
589: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID = ' || M_FINANCIAL_STATEMENT_ID);
590:
591:
592: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_STMNT_ROW (

Line 589: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID = ' || M_FINANCIAL_STATEMENT_ID);

585: exit when Get_statements_from_ora_gl%notfound;
586: M_FINANCIAL_STATEMENT_ID := statements.FINANCIAL_STATEMENT_ID;
587:
588: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID = ' || M_STATEMENT_GROUP_ID);
589: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID = ' || M_FINANCIAL_STATEMENT_ID);
590:
591:
592: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_STMNT_ROW (
593: X_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID,

Line 623: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for STATEMENT_GROUP_ID = ' || M_STATEMENT_GROUP_ID);

619:
620: M_NAME := statements.NAME;
621: M_SOURCE_LANGUAGE := userenv('LANG');
622:
623: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for STATEMENT_GROUP_ID = ' || M_STATEMENT_GROUP_ID);
624: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_STATEMENT_ID = ' || M_FINANCIAL_STATEMENT_ID);
625: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_STATEMENT_NAME = ' || M_NAME);
626:
627: for lang in Get_lang

Line 624: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_STATEMENT_ID = ' || M_FINANCIAL_STATEMENT_ID);

620: M_NAME := statements.NAME;
621: M_SOURCE_LANGUAGE := userenv('LANG');
622:
623: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for STATEMENT_GROUP_ID = ' || M_STATEMENT_GROUP_ID);
624: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_STATEMENT_ID = ' || M_FINANCIAL_STATEMENT_ID);
625: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_STATEMENT_NAME = ' || M_NAME);
626:
627: for lang in Get_lang
628: loop

Line 625: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_STATEMENT_NAME = ' || M_NAME);

621: M_SOURCE_LANGUAGE := userenv('LANG');
622:
623: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for STATEMENT_GROUP_ID = ' || M_STATEMENT_GROUP_ID);
624: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_STATEMENT_ID = ' || M_FINANCIAL_STATEMENT_ID);
625: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_STATEMENT_NAME = ' || M_NAME);
626:
627: for lang in Get_lang
628: loop
629: exit when Get_lang%notfound;

Line 631: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for LANGUAGE = ' || M_LANGUAGE);

627: for lang in Get_lang
628: loop
629: exit when Get_lang%notfound;
630: M_LANGUAGE := lang.LANGUAGE_CODE;
631: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for LANGUAGE = ' || M_LANGUAGE);
632:
633: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_STMNT_ROW_TL(
634: X_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID,
635: X_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID,

Line 661: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID = ' || M_STATEMENT_GROUP_ID);

657: M_FINANCIAL_STATEMENT_ID := fin_items.FINANCIAL_STATEMENT_ID;
658: M_FINANCIAL_ITEM_ID := fin_items.FINANCIAL_ITEM_ID;
659: M_PARENT_FINANCIAL_ITEM_ID := fin_items.PARENT_FINANCIAL_ITEM_ID ;
660:
661: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID = ' || M_STATEMENT_GROUP_ID);
662: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID = ' || M_FINANCIAL_STATEMENT_ID);
663: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID = ' || M_FINANCIAL_ITEM_ID);
664: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_FINANCIAL_ITEM_ID = ' || M_PARENT_FINANCIAL_ITEM_ID);
665:

Line 662: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID = ' || M_FINANCIAL_STATEMENT_ID);

658: M_FINANCIAL_ITEM_ID := fin_items.FINANCIAL_ITEM_ID;
659: M_PARENT_FINANCIAL_ITEM_ID := fin_items.PARENT_FINANCIAL_ITEM_ID ;
660:
661: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID = ' || M_STATEMENT_GROUP_ID);
662: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID = ' || M_FINANCIAL_STATEMENT_ID);
663: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID = ' || M_FINANCIAL_ITEM_ID);
664: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_FINANCIAL_ITEM_ID = ' || M_PARENT_FINANCIAL_ITEM_ID);
665:
666: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_FINITEM_ROW(

Line 663: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID = ' || M_FINANCIAL_ITEM_ID);

659: M_PARENT_FINANCIAL_ITEM_ID := fin_items.PARENT_FINANCIAL_ITEM_ID ;
660:
661: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID = ' || M_STATEMENT_GROUP_ID);
662: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID = ' || M_FINANCIAL_STATEMENT_ID);
663: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID = ' || M_FINANCIAL_ITEM_ID);
664: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_FINANCIAL_ITEM_ID = ' || M_PARENT_FINANCIAL_ITEM_ID);
665:
666: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_FINITEM_ROW(
667: X_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID,

Line 664: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_FINANCIAL_ITEM_ID = ' || M_PARENT_FINANCIAL_ITEM_ID);

660:
661: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID = ' || M_STATEMENT_GROUP_ID);
662: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID = ' || M_FINANCIAL_STATEMENT_ID);
663: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID = ' || M_FINANCIAL_ITEM_ID);
664: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_FINANCIAL_ITEM_ID = ' || M_PARENT_FINANCIAL_ITEM_ID);
665:
666: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_FINITEM_ROW(
667: X_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID,
668: X_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID ,

Line 699: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID = ' || M_STATEMENT_GROUP_ID);

695:
696: M_NAME := fin_items.DESCRIPTION;
697: M_SOURCE_LANGUAGE := userenv('LANG');
698:
699: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID = ' || M_STATEMENT_GROUP_ID);
700: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID = ' || M_FINANCIAL_STATEMENT_ID);
701: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID = ' || M_FINANCIAL_ITEM_ID);
702: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_ITEM_NAME = ' || M_NAME);
703:

Line 700: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID = ' || M_FINANCIAL_STATEMENT_ID);

696: M_NAME := fin_items.DESCRIPTION;
697: M_SOURCE_LANGUAGE := userenv('LANG');
698:
699: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID = ' || M_STATEMENT_GROUP_ID);
700: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID = ' || M_FINANCIAL_STATEMENT_ID);
701: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID = ' || M_FINANCIAL_ITEM_ID);
702: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_ITEM_NAME = ' || M_NAME);
703:
704: for lang in Get_lang

Line 701: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID = ' || M_FINANCIAL_ITEM_ID);

697: M_SOURCE_LANGUAGE := userenv('LANG');
698:
699: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID = ' || M_STATEMENT_GROUP_ID);
700: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID = ' || M_FINANCIAL_STATEMENT_ID);
701: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID = ' || M_FINANCIAL_ITEM_ID);
702: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_ITEM_NAME = ' || M_NAME);
703:
704: for lang in Get_lang
705: loop

Line 702: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_ITEM_NAME = ' || M_NAME);

698:
699: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID = ' || M_STATEMENT_GROUP_ID);
700: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID = ' || M_FINANCIAL_STATEMENT_ID);
701: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID = ' || M_FINANCIAL_ITEM_ID);
702: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for FINANCIAL_ITEM_NAME = ' || M_NAME);
703:
704: for lang in Get_lang
705: loop
706: exit when Get_lang%notfound;

Line 708: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for LANGUAGE = ' || M_LANGUAGE);

704: for lang in Get_lang
705: loop
706: exit when Get_lang%notfound;
707: M_LANGUAGE := lang.LANGUAGE_CODE;
708: fnd_file.put_line(fnd_file.LOG, 'Processing TL Definition for LANGUAGE = ' || M_LANGUAGE);
709:
710: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_FINITEM_ROW_TL(
711: X_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID,
712: X_FINANCIAL_STATEMENT_ID => M_FINANCIAL_STATEMENT_ID,

Line 742: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

738: commit;
739: end;
740:
741: EXCEPTION WHEN OTHERS THEN
742: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
743: -- dbms_output.put_line(SQLERRM);
744: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
745: g_retcode := '2';
746: RAISE ;

Line 939: fnd_file.put_line(fnd_file.LOG, 'Profile value AMW_NATRL_ACCT_VALUE_SET =' || default_value_set_id );

935:
936: begin
937: select fnd_profile.value('AMW_NATRL_ACCT_VALUE_SET') into default_value_set_id from dual ;
938:
939: fnd_file.put_line(fnd_file.LOG, 'Profile value AMW_NATRL_ACCT_VALUE_SET =' || default_value_set_id );
940:
941: select fnd_profile.value('GL_SET_OF_BKS_ID') into M_DEFAULT_SETOFBOOKS_ID from dual ;
942: fnd_file.put_line(fnd_file.LOG, 'Profile value GL_SET_OF_BKS_ID (Default Set of Books)=' || M_DEFAULT_SETOFBOOKS_ID );
943:

Line 942: fnd_file.put_line(fnd_file.LOG, 'Profile value GL_SET_OF_BKS_ID (Default Set of Books)=' || M_DEFAULT_SETOFBOOKS_ID );

938:
939: fnd_file.put_line(fnd_file.LOG, 'Profile value AMW_NATRL_ACCT_VALUE_SET =' || default_value_set_id );
940:
941: select fnd_profile.value('GL_SET_OF_BKS_ID') into M_DEFAULT_SETOFBOOKS_ID from dual ;
942: fnd_file.put_line(fnd_file.LOG, 'Profile value GL_SET_OF_BKS_ID (Default Set of Books)=' || M_DEFAULT_SETOFBOOKS_ID );
943:
944:
945:
946: for acc_range in Get_acc_range_from_ora_gl

Line 957: fnd_file.put_line(fnd_file.LOG, 'This Ros import will be using Default Set of Books Profile value GL_SET_OF_BKS_ID as the set of books in account range - row set definition is blank');

953: M_SET_OF_BOOKS_ID := acc_range.SET_OF_BOOKS_ID;
954:
955: if trim(M_SET_OF_BOOKS_ID) is null then
956: M_SET_OF_BOOKS_ID := M_DEFAULT_SETOFBOOKS_ID;
957: fnd_file.put_line(fnd_file.LOG, 'This Ros import will be using Default Set of Books Profile value GL_SET_OF_BKS_ID as the set of books in account range - row set definition is blank');
958:
959: end if;
960:
961: fnd_file.put_line(fnd_file.LOG, '---------------------------------------------------------------------');

Line 961: fnd_file.put_line(fnd_file.LOG, '---------------------------------------------------------------------');

957: fnd_file.put_line(fnd_file.LOG, 'This Ros import will be using Default Set of Books Profile value GL_SET_OF_BKS_ID as the set of books in account range - row set definition is blank');
958:
959: end if;
960:
961: fnd_file.put_line(fnd_file.LOG, '---------------------------------------------------------------------');
962: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
963: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
964: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
965: fnd_file.put_line(fnd_file.LOG, 'Processing SET_OF_BOOKS_ID =' || M_SET_OF_BOOKS_ID );

Line 962: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);

958:
959: end if;
960:
961: fnd_file.put_line(fnd_file.LOG, '---------------------------------------------------------------------');
962: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
963: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
964: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
965: fnd_file.put_line(fnd_file.LOG, 'Processing SET_OF_BOOKS_ID =' || M_SET_OF_BOOKS_ID );
966:

Line 963: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );

959: end if;
960:
961: fnd_file.put_line(fnd_file.LOG, '---------------------------------------------------------------------');
962: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
963: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
964: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
965: fnd_file.put_line(fnd_file.LOG, 'Processing SET_OF_BOOKS_ID =' || M_SET_OF_BOOKS_ID );
966:
967: for chart_of_acc in Get_set_of_books_ora_gl(M_SET_OF_BOOKS_ID)

Line 964: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );

960:
961: fnd_file.put_line(fnd_file.LOG, '---------------------------------------------------------------------');
962: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
963: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
964: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
965: fnd_file.put_line(fnd_file.LOG, 'Processing SET_OF_BOOKS_ID =' || M_SET_OF_BOOKS_ID );
966:
967: for chart_of_acc in Get_set_of_books_ora_gl(M_SET_OF_BOOKS_ID)
968: loop

Line 965: fnd_file.put_line(fnd_file.LOG, 'Processing SET_OF_BOOKS_ID =' || M_SET_OF_BOOKS_ID );

961: fnd_file.put_line(fnd_file.LOG, '---------------------------------------------------------------------');
962: fnd_file.put_line(fnd_file.LOG, 'Processing STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
963: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
964: fnd_file.put_line(fnd_file.LOG, 'Processing FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
965: fnd_file.put_line(fnd_file.LOG, 'Processing SET_OF_BOOKS_ID =' || M_SET_OF_BOOKS_ID );
966:
967: for chart_of_acc in Get_set_of_books_ora_gl(M_SET_OF_BOOKS_ID)
968: loop
969: exit when Get_set_of_books_ora_gl%notfound;

Line 973: fnd_file.put_line(fnd_file.LOG, 'Processing M_CHART_OF_ACCOUNTS_ID =' || M_CHART_OF_ACCOUNTS_ID);

969: exit when Get_set_of_books_ora_gl%notfound;
970:
971: M_CHART_OF_ACCOUNTS_ID := chart_of_acc.CHART_OF_ACCOUNTS_ID;
972:
973: fnd_file.put_line(fnd_file.LOG, 'Processing M_CHART_OF_ACCOUNTS_ID =' || M_CHART_OF_ACCOUNTS_ID);
974:
975:
976:
977: for acc_segment in Get_acc_range_column_ora_gl(M_CHART_OF_ACCOUNTS_ID)

Line 990: fnd_file.put_line(fnd_file.LOG,'---------------------------!!!!!!!!!!!!---------------------------------');

986: g_errbuf := FND_MESSAGE.GET_STRING('AMW', 'AMW_STMNTS_NOT_IN_ACC_VAL_SET');
987: --m_errMsg := FND_MESSAGE.GET_STRING('AMW', 'AMW_STMNTS_NOT_IN_ACC_VAL_SET');
988: g_retcode :='0';
989:
990: fnd_file.put_line(fnd_file.LOG,'---------------------------!!!!!!!!!!!!---------------------------------');
991:
992:
993: fnd_file.put_line(fnd_file.LOG,g_errbuf );
994:

Line 993: fnd_file.put_line(fnd_file.LOG,g_errbuf );

989:
990: fnd_file.put_line(fnd_file.LOG,'---------------------------!!!!!!!!!!!!---------------------------------');
991:
992:
993: fnd_file.put_line(fnd_file.LOG,g_errbuf );
994:
995: fnd_file.put_line(fnd_file.LOG, 'WARNING: The Record with FINANCIAL_STATEMENT_ID (Row Set) =' || M_FINANCIAL_STATEMENT_ID );
996: fnd_file.put_line(fnd_file.LOG, ' FINANCIAL_ITEM_ID (ROW ID) =' || M_FINANCIAL_ITEM_ID );
997: fnd_file.put_line(fnd_file.LOG, ' SET_OF_BOOKS_ID =' || M_SET_OF_BOOKS_ID );

Line 995: fnd_file.put_line(fnd_file.LOG, 'WARNING: The Record with FINANCIAL_STATEMENT_ID (Row Set) =' || M_FINANCIAL_STATEMENT_ID );

991:
992:
993: fnd_file.put_line(fnd_file.LOG,g_errbuf );
994:
995: fnd_file.put_line(fnd_file.LOG, 'WARNING: The Record with FINANCIAL_STATEMENT_ID (Row Set) =' || M_FINANCIAL_STATEMENT_ID );
996: fnd_file.put_line(fnd_file.LOG, ' FINANCIAL_ITEM_ID (ROW ID) =' || M_FINANCIAL_ITEM_ID );
997: fnd_file.put_line(fnd_file.LOG, ' SET_OF_BOOKS_ID =' || M_SET_OF_BOOKS_ID );
998: fnd_file.put_line(fnd_file.LOG, ' M_CHART_OF_ACCOUNTS_ID = ' || M_CHART_OF_ACCOUNTS_ID );
999: fnd_file.put_line(fnd_file.LOG, ' has a Natural Value Set Id of ' || m_flex_value_set_id || ' which is different from ' || 'default_value_set_id');

Line 996: fnd_file.put_line(fnd_file.LOG, ' FINANCIAL_ITEM_ID (ROW ID) =' || M_FINANCIAL_ITEM_ID );

992:
993: fnd_file.put_line(fnd_file.LOG,g_errbuf );
994:
995: fnd_file.put_line(fnd_file.LOG, 'WARNING: The Record with FINANCIAL_STATEMENT_ID (Row Set) =' || M_FINANCIAL_STATEMENT_ID );
996: fnd_file.put_line(fnd_file.LOG, ' FINANCIAL_ITEM_ID (ROW ID) =' || M_FINANCIAL_ITEM_ID );
997: fnd_file.put_line(fnd_file.LOG, ' SET_OF_BOOKS_ID =' || M_SET_OF_BOOKS_ID );
998: fnd_file.put_line(fnd_file.LOG, ' M_CHART_OF_ACCOUNTS_ID = ' || M_CHART_OF_ACCOUNTS_ID );
999: fnd_file.put_line(fnd_file.LOG, ' has a Natural Value Set Id of ' || m_flex_value_set_id || ' which is different from ' || 'default_value_set_id');
1000: fnd_file.put_line(fnd_file.LOG,'------------------------!!!!!!!!!!!!!!!!!!!!------------------------------------');

Line 997: fnd_file.put_line(fnd_file.LOG, ' SET_OF_BOOKS_ID =' || M_SET_OF_BOOKS_ID );

993: fnd_file.put_line(fnd_file.LOG,g_errbuf );
994:
995: fnd_file.put_line(fnd_file.LOG, 'WARNING: The Record with FINANCIAL_STATEMENT_ID (Row Set) =' || M_FINANCIAL_STATEMENT_ID );
996: fnd_file.put_line(fnd_file.LOG, ' FINANCIAL_ITEM_ID (ROW ID) =' || M_FINANCIAL_ITEM_ID );
997: fnd_file.put_line(fnd_file.LOG, ' SET_OF_BOOKS_ID =' || M_SET_OF_BOOKS_ID );
998: fnd_file.put_line(fnd_file.LOG, ' M_CHART_OF_ACCOUNTS_ID = ' || M_CHART_OF_ACCOUNTS_ID );
999: fnd_file.put_line(fnd_file.LOG, ' has a Natural Value Set Id of ' || m_flex_value_set_id || ' which is different from ' || 'default_value_set_id');
1000: fnd_file.put_line(fnd_file.LOG,'------------------------!!!!!!!!!!!!!!!!!!!!------------------------------------');
1001:

Line 998: fnd_file.put_line(fnd_file.LOG, ' M_CHART_OF_ACCOUNTS_ID = ' || M_CHART_OF_ACCOUNTS_ID );

994:
995: fnd_file.put_line(fnd_file.LOG, 'WARNING: The Record with FINANCIAL_STATEMENT_ID (Row Set) =' || M_FINANCIAL_STATEMENT_ID );
996: fnd_file.put_line(fnd_file.LOG, ' FINANCIAL_ITEM_ID (ROW ID) =' || M_FINANCIAL_ITEM_ID );
997: fnd_file.put_line(fnd_file.LOG, ' SET_OF_BOOKS_ID =' || M_SET_OF_BOOKS_ID );
998: fnd_file.put_line(fnd_file.LOG, ' M_CHART_OF_ACCOUNTS_ID = ' || M_CHART_OF_ACCOUNTS_ID );
999: fnd_file.put_line(fnd_file.LOG, ' has a Natural Value Set Id of ' || m_flex_value_set_id || ' which is different from ' || 'default_value_set_id');
1000: fnd_file.put_line(fnd_file.LOG,'------------------------!!!!!!!!!!!!!!!!!!!!------------------------------------');
1001:
1002:

Line 999: fnd_file.put_line(fnd_file.LOG, ' has a Natural Value Set Id of ' || m_flex_value_set_id || ' which is different from ' || 'default_value_set_id');

995: fnd_file.put_line(fnd_file.LOG, 'WARNING: The Record with FINANCIAL_STATEMENT_ID (Row Set) =' || M_FINANCIAL_STATEMENT_ID );
996: fnd_file.put_line(fnd_file.LOG, ' FINANCIAL_ITEM_ID (ROW ID) =' || M_FINANCIAL_ITEM_ID );
997: fnd_file.put_line(fnd_file.LOG, ' SET_OF_BOOKS_ID =' || M_SET_OF_BOOKS_ID );
998: fnd_file.put_line(fnd_file.LOG, ' M_CHART_OF_ACCOUNTS_ID = ' || M_CHART_OF_ACCOUNTS_ID );
999: fnd_file.put_line(fnd_file.LOG, ' has a Natural Value Set Id of ' || m_flex_value_set_id || ' which is different from ' || 'default_value_set_id');
1000: fnd_file.put_line(fnd_file.LOG,'------------------------!!!!!!!!!!!!!!!!!!!!------------------------------------');
1001:
1002:
1003:

Line 1000: fnd_file.put_line(fnd_file.LOG,'------------------------!!!!!!!!!!!!!!!!!!!!------------------------------------');

996: fnd_file.put_line(fnd_file.LOG, ' FINANCIAL_ITEM_ID (ROW ID) =' || M_FINANCIAL_ITEM_ID );
997: fnd_file.put_line(fnd_file.LOG, ' SET_OF_BOOKS_ID =' || M_SET_OF_BOOKS_ID );
998: fnd_file.put_line(fnd_file.LOG, ' M_CHART_OF_ACCOUNTS_ID = ' || M_CHART_OF_ACCOUNTS_ID );
999: fnd_file.put_line(fnd_file.LOG, ' has a Natural Value Set Id of ' || m_flex_value_set_id || ' which is different from ' || 'default_value_set_id');
1000: fnd_file.put_line(fnd_file.LOG,'------------------------!!!!!!!!!!!!!!!!!!!!------------------------------------');
1001:
1002:
1003:
1004: elsif m_flex_value_set_id = default_value_set_id then

Line 1007: fnd_file.put_line(fnd_file.LOG, 'Natural Account Value Segment Column =' || acc_segment.APPLICATION_COLUMN_NAME );

1003:
1004: elsif m_flex_value_set_id = default_value_set_id then
1005:
1006:
1007: fnd_file.put_line(fnd_file.LOG, 'Natural Account Value Segment Column =' || acc_segment.APPLICATION_COLUMN_NAME );
1008:
1009:
1010: if acc_segment.APPLICATION_COLUMN_NAME = 'SEGMENT1' then
1011: M_Low_Value := acc_range.SEGMENT1_LOW ;

Line 1106: fnd_file.put_line(fnd_file.LOG, 'Processing Account Range Low Val=' || M_Low_Value );

1102:
1103: -- M_Low_Value := acc_segment.APPLICATION_COLUMN_NAME || '_LOW';
1104: --M_High_Value := acc_segment.APPLICATION_COLUMN_NAME || '_HIGH';
1105:
1106: fnd_file.put_line(fnd_file.LOG, 'Processing Account Range Low Val=' || M_Low_Value );
1107: fnd_file.put_line(fnd_file.LOG, 'Processing Account Range High Val=' || M_High_Value);
1108:
1109:
1110: for get_acc_values in Get_acc_values_from_ora_gl(M_Low_Value , M_High_Value)

Line 1107: fnd_file.put_line(fnd_file.LOG, 'Processing Account Range High Val=' || M_High_Value);

1103: -- M_Low_Value := acc_segment.APPLICATION_COLUMN_NAME || '_LOW';
1104: --M_High_Value := acc_segment.APPLICATION_COLUMN_NAME || '_HIGH';
1105:
1106: fnd_file.put_line(fnd_file.LOG, 'Processing Account Range Low Val=' || M_Low_Value );
1107: fnd_file.put_line(fnd_file.LOG, 'Processing Account Range High Val=' || M_High_Value);
1108:
1109:
1110: for get_acc_values in Get_acc_values_from_ora_gl(M_Low_Value , M_High_Value)
1111: loop

Line 1116: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);

1112: exit when Get_acc_values_from_ora_gl%notfound;
1113: M_ACCOUNT_GROUP_ID := get_acc_values.ACCOUNT_GROUP_ID;
1114: M_NATURAL_ACCOUNT_ID := get_acc_values.NATURAL_ACCOUNT_ID;
1115:
1116: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
1117: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
1118: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
1119: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
1120: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);

Line 1117: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );

1113: M_ACCOUNT_GROUP_ID := get_acc_values.ACCOUNT_GROUP_ID;
1114: M_NATURAL_ACCOUNT_ID := get_acc_values.NATURAL_ACCOUNT_ID;
1115:
1116: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
1117: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
1118: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
1119: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
1120: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
1121:

Line 1118: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );

1114: M_NATURAL_ACCOUNT_ID := get_acc_values.NATURAL_ACCOUNT_ID;
1115:
1116: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
1117: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
1118: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
1119: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
1120: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
1121:
1122:

Line 1119: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);

1115:
1116: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
1117: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
1118: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
1119: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
1120: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
1121:
1122:
1123: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_FINITEM_ACC_MAP(

Line 1120: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);

1116: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR STATEMENT_GROUP_ID =' || M_STATEMENT_GROUP_ID);
1117: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_STATEMENT_ID =' || M_FINANCIAL_STATEMENT_ID );
1118: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR FINANCIAL_ITEM_ID =' || M_FINANCIAL_ITEM_ID );
1119: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
1120: fnd_file.put_line(fnd_file.LOG, 'CALLING INSERT FINITEM_ACC_MAP FOR NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
1121:
1122:
1123: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_FINITEM_ACC_MAP(
1124: X_STATEMENT_GROUP_ID => M_STATEMENT_GROUP_ID,

Line 1168: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

1164:
1165: end;
1166:
1167: EXCEPTION WHEN OTHERS THEN
1168: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
1169: -- dbms_output.put_line(SQLERRM);
1170: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
1171: g_retcode := '2';
1172:

Line 1186: fnd_file.put_line(fnd_file.LOG, 'End Dating and Deleting Statements Imported previously and is also part of this import after Importing For Run ID=' || P_RUNID);

1182: begin
1183: -- NOTE :- first update the end date if the statement structure is being re-imported and then if the end dated
1184: -- statements and associated records in other tables are not being used in any certifications delete them
1185:
1186: fnd_file.put_line(fnd_file.LOG, 'End Dating and Deleting Statements Imported previously and is also part of this import after Importing For Run ID=' || P_RUNID);
1187:
1188:
1189: update AMW_FIN_STMNT_B set end_date = sysdate
1190: where STATEMENT_GROUP_ID <> P_STATEMENT_GROUP_ID and

Line 1237: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

1233: end;
1234:
1235: /* EXCEPTION WHEN OTHERS THEN
1236:
1237: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
1238: -- dbms_output.put_line(SQLERRM);
1239: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
1240: g_retcode := '2';
1241: RAISE ;

Line 1350: fnd_file.put_line(fnd_file.LOG, '------------------get_acc_from_oracle_apps-------------');

1346: M_NATURAL_ACCOUNT_ID := accounts.FLEX_VALUE_ID;
1347: M_NATURAL_ACCOUNT_VALUE := accounts.FLEX_VALUE ;
1348: M_PARENT_NATURAL_ACCOUNT_ID := NULL;
1349:
1350: fnd_file.put_line(fnd_file.LOG, '------------------get_acc_from_oracle_apps-------------');
1351: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
1352: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
1353:
1354:

Line 1351: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);

1347: M_NATURAL_ACCOUNT_VALUE := accounts.FLEX_VALUE ;
1348: M_PARENT_NATURAL_ACCOUNT_ID := NULL;
1349:
1350: fnd_file.put_line(fnd_file.LOG, '------------------get_acc_from_oracle_apps-------------');
1351: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
1352: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
1353:
1354:
1355:

Line 1352: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);

1348: M_PARENT_NATURAL_ACCOUNT_ID := NULL;
1349:
1350: fnd_file.put_line(fnd_file.LOG, '------------------get_acc_from_oracle_apps-------------');
1351: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
1352: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
1353:
1354:
1355:
1356: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_ROW(

Line 1402: fnd_file.put_line(fnd_file.LOG, '------------------ Processing Account - Parent Child Relationship -------------');

1398: C_NATURAL_ACCOUNT_ID := sub_accounts_id.FLEX_VALUE_ID;
1399: end loop;
1400:
1401:
1402: fnd_file.put_line(fnd_file.LOG, '------------------ Processing Account - Parent Child Relationship -------------');
1403: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
1404: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
1405: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_NATURAL_ACCOUNT_ID=' || M_PARENT_NATURAL_ACCOUNT_ID);
1406:

Line 1403: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);

1399: end loop;
1400:
1401:
1402: fnd_file.put_line(fnd_file.LOG, '------------------ Processing Account - Parent Child Relationship -------------');
1403: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
1404: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
1405: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_NATURAL_ACCOUNT_ID=' || M_PARENT_NATURAL_ACCOUNT_ID);
1406:
1407:

Line 1404: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);

1400:
1401:
1402: fnd_file.put_line(fnd_file.LOG, '------------------ Processing Account - Parent Child Relationship -------------');
1403: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
1404: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
1405: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_NATURAL_ACCOUNT_ID=' || M_PARENT_NATURAL_ACCOUNT_ID);
1406:
1407:
1408:

Line 1405: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_NATURAL_ACCOUNT_ID=' || M_PARENT_NATURAL_ACCOUNT_ID);

1401:
1402: fnd_file.put_line(fnd_file.LOG, '------------------ Processing Account - Parent Child Relationship -------------');
1403: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
1404: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
1405: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_NATURAL_ACCOUNT_ID=' || M_PARENT_NATURAL_ACCOUNT_ID);
1406:
1407:
1408:
1409: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_ROW(

Line 1451: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

1447:
1448: commit;
1449: END;
1450: EXCEPTION WHEN OTHERS THEN
1451: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
1452: -- dbms_output.put_line(SQLERRM);
1453: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
1454: g_retcode := '2';
1455:

Line 1507: fnd_file.put_line(fnd_file.LOG, '------------------ Get_acc_names_from_oraapps_gl -------------');

1503: M_NAME := accounts_tl.DESCRIPTION;
1504: M_SOURCE_LANGUAGE := accounts_tl.SOURCE_LANG;
1505: M_SECURITY_GROUP_ID := null ; -- commented as prd environments did not have this field accounts_tl.SECURITY_GROUP_ID;
1506:
1507: fnd_file.put_line(fnd_file.LOG, '------------------ Get_acc_names_from_oraapps_gl -------------');
1508: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || P_ACCOUNT_GROUP_ID);
1509: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || P_NATURAL_ACCOUNT_ID);
1510: fnd_file.put_line(fnd_file.LOG, 'Processing LANGUAGE=' || M_LANGUAGE);
1511: fnd_file.put_line(fnd_file.LOG, 'Processing NAME=' || M_NAME);

Line 1508: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || P_ACCOUNT_GROUP_ID);

1504: M_SOURCE_LANGUAGE := accounts_tl.SOURCE_LANG;
1505: M_SECURITY_GROUP_ID := null ; -- commented as prd environments did not have this field accounts_tl.SECURITY_GROUP_ID;
1506:
1507: fnd_file.put_line(fnd_file.LOG, '------------------ Get_acc_names_from_oraapps_gl -------------');
1508: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || P_ACCOUNT_GROUP_ID);
1509: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || P_NATURAL_ACCOUNT_ID);
1510: fnd_file.put_line(fnd_file.LOG, 'Processing LANGUAGE=' || M_LANGUAGE);
1511: fnd_file.put_line(fnd_file.LOG, 'Processing NAME=' || M_NAME);
1512:

Line 1509: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || P_NATURAL_ACCOUNT_ID);

1505: M_SECURITY_GROUP_ID := null ; -- commented as prd environments did not have this field accounts_tl.SECURITY_GROUP_ID;
1506:
1507: fnd_file.put_line(fnd_file.LOG, '------------------ Get_acc_names_from_oraapps_gl -------------');
1508: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || P_ACCOUNT_GROUP_ID);
1509: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || P_NATURAL_ACCOUNT_ID);
1510: fnd_file.put_line(fnd_file.LOG, 'Processing LANGUAGE=' || M_LANGUAGE);
1511: fnd_file.put_line(fnd_file.LOG, 'Processing NAME=' || M_NAME);
1512:
1513:

Line 1510: fnd_file.put_line(fnd_file.LOG, 'Processing LANGUAGE=' || M_LANGUAGE);

1506:
1507: fnd_file.put_line(fnd_file.LOG, '------------------ Get_acc_names_from_oraapps_gl -------------');
1508: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || P_ACCOUNT_GROUP_ID);
1509: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || P_NATURAL_ACCOUNT_ID);
1510: fnd_file.put_line(fnd_file.LOG, 'Processing LANGUAGE=' || M_LANGUAGE);
1511: fnd_file.put_line(fnd_file.LOG, 'Processing NAME=' || M_NAME);
1512:
1513:
1514: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_ROW_TL(

Line 1511: fnd_file.put_line(fnd_file.LOG, 'Processing NAME=' || M_NAME);

1507: fnd_file.put_line(fnd_file.LOG, '------------------ Get_acc_names_from_oraapps_gl -------------');
1508: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || P_ACCOUNT_GROUP_ID);
1509: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || P_NATURAL_ACCOUNT_ID);
1510: fnd_file.put_line(fnd_file.LOG, 'Processing LANGUAGE=' || M_LANGUAGE);
1511: fnd_file.put_line(fnd_file.LOG, 'Processing NAME=' || M_NAME);
1512:
1513:
1514: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_ROW_TL(
1515: X_ACCOUNT_GROUP_ID => P_ACCOUNT_GROUP_ID,

Line 1534: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

1530:
1531:
1532: END;
1533: EXCEPTION WHEN OTHERS THEN
1534: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
1535: -- dbms_output.put_line(SQLERRM);
1536: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
1537: g_retcode := '2';
1538:

Line 1688: fnd_file.put_line(fnd_file.LOG, '------------------ Get_acc_from_external_apps -------------');

1684: M_NATURAL_ACCOUNT_ID:= accounts_b_record.NATURAL_ACCOUNT_ID;
1685: M_NATURAL_ACCOUNT_VALUE := accounts_b_record.NATURAL_ACCOUNT_VALUE;
1686: M_PARENT_NATURAL_ACCOUNT_ID := accounts_b_record.PARENT_NATURAL_ACCOUNT_ID;
1687:
1688: fnd_file.put_line(fnd_file.LOG, '------------------ Get_acc_from_external_apps -------------');
1689: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
1690: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
1691: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_NATURAL_ACCOUNT_ID=' || M_PARENT_NATURAL_ACCOUNT_ID);
1692:

Line 1689: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);

1685: M_NATURAL_ACCOUNT_VALUE := accounts_b_record.NATURAL_ACCOUNT_VALUE;
1686: M_PARENT_NATURAL_ACCOUNT_ID := accounts_b_record.PARENT_NATURAL_ACCOUNT_ID;
1687:
1688: fnd_file.put_line(fnd_file.LOG, '------------------ Get_acc_from_external_apps -------------');
1689: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
1690: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
1691: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_NATURAL_ACCOUNT_ID=' || M_PARENT_NATURAL_ACCOUNT_ID);
1692:
1693:

Line 1690: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);

1686: M_PARENT_NATURAL_ACCOUNT_ID := accounts_b_record.PARENT_NATURAL_ACCOUNT_ID;
1687:
1688: fnd_file.put_line(fnd_file.LOG, '------------------ Get_acc_from_external_apps -------------');
1689: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
1690: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
1691: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_NATURAL_ACCOUNT_ID=' || M_PARENT_NATURAL_ACCOUNT_ID);
1692:
1693:
1694: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_ROW(

Line 1691: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_NATURAL_ACCOUNT_ID=' || M_PARENT_NATURAL_ACCOUNT_ID);

1687:
1688: fnd_file.put_line(fnd_file.LOG, '------------------ Get_acc_from_external_apps -------------');
1689: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
1690: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
1691: fnd_file.put_line(fnd_file.LOG, 'Processing PARENT_NATURAL_ACCOUNT_ID=' || M_PARENT_NATURAL_ACCOUNT_ID);
1692:
1693:
1694: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_ROW(
1695: X_ACCOUNT_GROUP_ID => M_ACCOUNT_GROUP_ID,

Line 1734: fnd_file.put_line(fnd_file.LOG, '------------------ Get_acc_names_external_apps -------------');

1730: M_NAME := accounts_tl_record.NAME;
1731: M_LANGUAGE := accounts_tl_record.LANGUAGE;
1732: M_SOURCE_LANGUAGE := accounts_tl_record.SOURCE_LANGUAGE;
1733:
1734: fnd_file.put_line(fnd_file.LOG, '------------------ Get_acc_names_external_apps -------------');
1735: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
1736: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
1737: fnd_file.put_line(fnd_file.LOG, 'Processing LANGUAGE=' || M_LANGUAGE);
1738: fnd_file.put_line(fnd_file.LOG, 'Processing NAME=' || M_NAME);

Line 1735: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);

1731: M_LANGUAGE := accounts_tl_record.LANGUAGE;
1732: M_SOURCE_LANGUAGE := accounts_tl_record.SOURCE_LANGUAGE;
1733:
1734: fnd_file.put_line(fnd_file.LOG, '------------------ Get_acc_names_external_apps -------------');
1735: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
1736: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
1737: fnd_file.put_line(fnd_file.LOG, 'Processing LANGUAGE=' || M_LANGUAGE);
1738: fnd_file.put_line(fnd_file.LOG, 'Processing NAME=' || M_NAME);
1739:

Line 1736: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);

1732: M_SOURCE_LANGUAGE := accounts_tl_record.SOURCE_LANGUAGE;
1733:
1734: fnd_file.put_line(fnd_file.LOG, '------------------ Get_acc_names_external_apps -------------');
1735: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
1736: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
1737: fnd_file.put_line(fnd_file.LOG, 'Processing LANGUAGE=' || M_LANGUAGE);
1738: fnd_file.put_line(fnd_file.LOG, 'Processing NAME=' || M_NAME);
1739:
1740:

Line 1737: fnd_file.put_line(fnd_file.LOG, 'Processing LANGUAGE=' || M_LANGUAGE);

1733:
1734: fnd_file.put_line(fnd_file.LOG, '------------------ Get_acc_names_external_apps -------------');
1735: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
1736: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
1737: fnd_file.put_line(fnd_file.LOG, 'Processing LANGUAGE=' || M_LANGUAGE);
1738: fnd_file.put_line(fnd_file.LOG, 'Processing NAME=' || M_NAME);
1739:
1740:
1741:

Line 1738: fnd_file.put_line(fnd_file.LOG, 'Processing NAME=' || M_NAME);

1734: fnd_file.put_line(fnd_file.LOG, '------------------ Get_acc_names_external_apps -------------');
1735: fnd_file.put_line(fnd_file.LOG, 'Processing ACCOUNT_GROUP_ID=' || M_ACCOUNT_GROUP_ID);
1736: fnd_file.put_line(fnd_file.LOG, 'Processing NATURAL_ACCOUNT_ID=' || M_NATURAL_ACCOUNT_ID);
1737: fnd_file.put_line(fnd_file.LOG, 'Processing LANGUAGE=' || M_LANGUAGE);
1738: fnd_file.put_line(fnd_file.LOG, 'Processing NAME=' || M_NAME);
1739:
1740:
1741:
1742: AMW_IMPORT_STMNTS_ACCS_PKG.INSERT_ROW_TL(

Line 1770: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

1766: commit;
1767: END;
1768:
1769: EXCEPTION WHEN OTHERS THEN
1770: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
1771: -- dbms_output.put_line(SQLERRM);
1772: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
1773: g_retcode := '2';
1774:

Line 1889: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

1885: end if;
1886: close c;
1887: */
1888: WHEN OTHERS THEN
1889: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
1890: -- dbms_output.put_line(SQLERRM);
1891: fnd_file.put_line(fnd_file.LOG, 'ACCOUNT_GROUP_ID' || X_ACCOUNT_GROUP_ID );
1892: fnd_file.put_line(fnd_file.LOG, 'NATURAL_ACCOUNT_ID ' || X_NATURAL_ACCOUNT_ID );
1893: fnd_file.put_line(fnd_file.LOG, 'PARENT_NATURAL_ACCOUNT_ID' || X_PARENT_NATURAL_ACCOUNT_ID );

Line 1891: fnd_file.put_line(fnd_file.LOG, 'ACCOUNT_GROUP_ID' || X_ACCOUNT_GROUP_ID );

1887: */
1888: WHEN OTHERS THEN
1889: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
1890: -- dbms_output.put_line(SQLERRM);
1891: fnd_file.put_line(fnd_file.LOG, 'ACCOUNT_GROUP_ID' || X_ACCOUNT_GROUP_ID );
1892: fnd_file.put_line(fnd_file.LOG, 'NATURAL_ACCOUNT_ID ' || X_NATURAL_ACCOUNT_ID );
1893: fnd_file.put_line(fnd_file.LOG, 'PARENT_NATURAL_ACCOUNT_ID' || X_PARENT_NATURAL_ACCOUNT_ID );
1894:
1895: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;

Line 1892: fnd_file.put_line(fnd_file.LOG, 'NATURAL_ACCOUNT_ID ' || X_NATURAL_ACCOUNT_ID );

1888: WHEN OTHERS THEN
1889: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
1890: -- dbms_output.put_line(SQLERRM);
1891: fnd_file.put_line(fnd_file.LOG, 'ACCOUNT_GROUP_ID' || X_ACCOUNT_GROUP_ID );
1892: fnd_file.put_line(fnd_file.LOG, 'NATURAL_ACCOUNT_ID ' || X_NATURAL_ACCOUNT_ID );
1893: fnd_file.put_line(fnd_file.LOG, 'PARENT_NATURAL_ACCOUNT_ID' || X_PARENT_NATURAL_ACCOUNT_ID );
1894:
1895: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
1896: g_retcode := '2';

Line 1893: fnd_file.put_line(fnd_file.LOG, 'PARENT_NATURAL_ACCOUNT_ID' || X_PARENT_NATURAL_ACCOUNT_ID );

1889: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
1890: -- dbms_output.put_line(SQLERRM);
1891: fnd_file.put_line(fnd_file.LOG, 'ACCOUNT_GROUP_ID' || X_ACCOUNT_GROUP_ID );
1892: fnd_file.put_line(fnd_file.LOG, 'NATURAL_ACCOUNT_ID ' || X_NATURAL_ACCOUNT_ID );
1893: fnd_file.put_line(fnd_file.LOG, 'PARENT_NATURAL_ACCOUNT_ID' || X_PARENT_NATURAL_ACCOUNT_ID );
1894:
1895: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
1896: g_retcode := '2';
1897:

Line 1977: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

1973: end if;
1974: close c;
1975: */
1976: WHEN OTHERS THEN
1977: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
1978: -- dbms_output.put_line(SQLERRM);
1979: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
1980: g_retcode := '2';
1981: fnd_file.put_line(fnd_file.LOG, 'ACCOUNT_GROUP_ID=' || X_ACCOUNT_GROUP_ID );

Line 1981: fnd_file.put_line(fnd_file.LOG, 'ACCOUNT_GROUP_ID=' || X_ACCOUNT_GROUP_ID );

1977: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
1978: -- dbms_output.put_line(SQLERRM);
1979: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
1980: g_retcode := '2';
1981: fnd_file.put_line(fnd_file.LOG, 'ACCOUNT_GROUP_ID=' || X_ACCOUNT_GROUP_ID );
1982: fnd_file.put_line(fnd_file.LOG, 'NATURAL_ACCOUNT_ID=' || X_NATURAL_ACCOUNT_ID );
1983: fnd_file.put_line(fnd_file.LOG, 'LANGUAGE=' || X_LANGUAGE);
1984:
1985:

Line 1982: fnd_file.put_line(fnd_file.LOG, 'NATURAL_ACCOUNT_ID=' || X_NATURAL_ACCOUNT_ID );

1978: -- dbms_output.put_line(SQLERRM);
1979: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
1980: g_retcode := '2';
1981: fnd_file.put_line(fnd_file.LOG, 'ACCOUNT_GROUP_ID=' || X_ACCOUNT_GROUP_ID );
1982: fnd_file.put_line(fnd_file.LOG, 'NATURAL_ACCOUNT_ID=' || X_NATURAL_ACCOUNT_ID );
1983: fnd_file.put_line(fnd_file.LOG, 'LANGUAGE=' || X_LANGUAGE);
1984:
1985:
1986: RAISE ;

Line 1983: fnd_file.put_line(fnd_file.LOG, 'LANGUAGE=' || X_LANGUAGE);

1979: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
1980: g_retcode := '2';
1981: fnd_file.put_line(fnd_file.LOG, 'ACCOUNT_GROUP_ID=' || X_ACCOUNT_GROUP_ID );
1982: fnd_file.put_line(fnd_file.LOG, 'NATURAL_ACCOUNT_ID=' || X_NATURAL_ACCOUNT_ID );
1983: fnd_file.put_line(fnd_file.LOG, 'LANGUAGE=' || X_LANGUAGE);
1984:
1985:
1986: RAISE ;
1987: RETURN;

Line 2089: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

2085: X_SECURITY_GROUP_ID ,
2086: X_OBJECT_VERSION_NUMBER );
2087:
2088: WHEN OTHERS THEN
2089: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2090: -- dbms_output.put_line(SQLERRM);
2091: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
2092: g_retcode := '2';
2093: fnd_file.put_line(fnd_file.LOG, 'STATEMENT_GROUP_ID =' || X_STATEMENT_GROUP_ID );

Line 2093: fnd_file.put_line(fnd_file.LOG, 'STATEMENT_GROUP_ID =' || X_STATEMENT_GROUP_ID );

2089: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2090: -- dbms_output.put_line(SQLERRM);
2091: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
2092: g_retcode := '2';
2093: fnd_file.put_line(fnd_file.LOG, 'STATEMENT_GROUP_ID =' || X_STATEMENT_GROUP_ID );
2094: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_STATEMENT_ID =' || X_FINANCIAL_STATEMENT_ID);
2095:
2096: RAISE ;
2097: RETURN;

Line 2094: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_STATEMENT_ID =' || X_FINANCIAL_STATEMENT_ID);

2090: -- dbms_output.put_line(SQLERRM);
2091: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
2092: g_retcode := '2';
2093: fnd_file.put_line(fnd_file.LOG, 'STATEMENT_GROUP_ID =' || X_STATEMENT_GROUP_ID );
2094: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_STATEMENT_ID =' || X_FINANCIAL_STATEMENT_ID);
2095:
2096: RAISE ;
2097: RETURN;
2098:

Line 2171: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

2167: end if;
2168: close c;
2169: */
2170: WHEN OTHERS THEN
2171: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2172: -- dbms_output.put_line(SQLERRM);
2173: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
2174: g_retcode := '2';
2175: fnd_file.put_line(fnd_file.LOG, 'STATEMENT_GROUP_ID =' || X_STATEMENT_GROUP_ID );

Line 2175: fnd_file.put_line(fnd_file.LOG, 'STATEMENT_GROUP_ID =' || X_STATEMENT_GROUP_ID );

2171: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2172: -- dbms_output.put_line(SQLERRM);
2173: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
2174: g_retcode := '2';
2175: fnd_file.put_line(fnd_file.LOG, 'STATEMENT_GROUP_ID =' || X_STATEMENT_GROUP_ID );
2176: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_STATEMENT_ID =' || X_FINANCIAL_STATEMENT_ID);
2177: fnd_file.put_line(fnd_file.LOG, 'LANGUAGE=' || X_LANGUAGE);
2178:
2179:

Line 2176: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_STATEMENT_ID =' || X_FINANCIAL_STATEMENT_ID);

2172: -- dbms_output.put_line(SQLERRM);
2173: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
2174: g_retcode := '2';
2175: fnd_file.put_line(fnd_file.LOG, 'STATEMENT_GROUP_ID =' || X_STATEMENT_GROUP_ID );
2176: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_STATEMENT_ID =' || X_FINANCIAL_STATEMENT_ID);
2177: fnd_file.put_line(fnd_file.LOG, 'LANGUAGE=' || X_LANGUAGE);
2178:
2179:
2180: RAISE ;

Line 2177: fnd_file.put_line(fnd_file.LOG, 'LANGUAGE=' || X_LANGUAGE);

2173: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
2174: g_retcode := '2';
2175: fnd_file.put_line(fnd_file.LOG, 'STATEMENT_GROUP_ID =' || X_STATEMENT_GROUP_ID );
2176: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_STATEMENT_ID =' || X_FINANCIAL_STATEMENT_ID);
2177: fnd_file.put_line(fnd_file.LOG, 'LANGUAGE=' || X_LANGUAGE);
2178:
2179:
2180: RAISE ;
2181: RETURN;

Line 2291: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

2287: X_SECURITY_GROUP_ID ,
2288: X_OBJECT_VERSION_NUMBER );
2289:
2290: WHEN OTHERS THEN
2291: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2292: -- dbms_output.put_line(SQLERRM);
2293: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
2294: g_retcode := '2';
2295: fnd_file.put_line(fnd_file.LOG, 'STATEMENT_GROUP_ID =' || X_STATEMENT_GROUP_ID );

Line 2295: fnd_file.put_line(fnd_file.LOG, 'STATEMENT_GROUP_ID =' || X_STATEMENT_GROUP_ID );

2291: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2292: -- dbms_output.put_line(SQLERRM);
2293: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
2294: g_retcode := '2';
2295: fnd_file.put_line(fnd_file.LOG, 'STATEMENT_GROUP_ID =' || X_STATEMENT_GROUP_ID );
2296: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_STATEMENT_ID =' || X_FINANCIAL_STATEMENT_ID);
2297: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_ITEM_ID=' || X_FINANCIAL_ITEM_ID);
2298: fnd_file.put_line(fnd_file.LOG, 'PARENT_FINANCIAL_ITEM_ID =' || X_PARENT_FINANCIAL_ITEM_ID );
2299:

Line 2296: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_STATEMENT_ID =' || X_FINANCIAL_STATEMENT_ID);

2292: -- dbms_output.put_line(SQLERRM);
2293: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
2294: g_retcode := '2';
2295: fnd_file.put_line(fnd_file.LOG, 'STATEMENT_GROUP_ID =' || X_STATEMENT_GROUP_ID );
2296: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_STATEMENT_ID =' || X_FINANCIAL_STATEMENT_ID);
2297: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_ITEM_ID=' || X_FINANCIAL_ITEM_ID);
2298: fnd_file.put_line(fnd_file.LOG, 'PARENT_FINANCIAL_ITEM_ID =' || X_PARENT_FINANCIAL_ITEM_ID );
2299:
2300:

Line 2297: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_ITEM_ID=' || X_FINANCIAL_ITEM_ID);

2293: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
2294: g_retcode := '2';
2295: fnd_file.put_line(fnd_file.LOG, 'STATEMENT_GROUP_ID =' || X_STATEMENT_GROUP_ID );
2296: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_STATEMENT_ID =' || X_FINANCIAL_STATEMENT_ID);
2297: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_ITEM_ID=' || X_FINANCIAL_ITEM_ID);
2298: fnd_file.put_line(fnd_file.LOG, 'PARENT_FINANCIAL_ITEM_ID =' || X_PARENT_FINANCIAL_ITEM_ID );
2299:
2300:
2301: RAISE ;

Line 2298: fnd_file.put_line(fnd_file.LOG, 'PARENT_FINANCIAL_ITEM_ID =' || X_PARENT_FINANCIAL_ITEM_ID );

2294: g_retcode := '2';
2295: fnd_file.put_line(fnd_file.LOG, 'STATEMENT_GROUP_ID =' || X_STATEMENT_GROUP_ID );
2296: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_STATEMENT_ID =' || X_FINANCIAL_STATEMENT_ID);
2297: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_ITEM_ID=' || X_FINANCIAL_ITEM_ID);
2298: fnd_file.put_line(fnd_file.LOG, 'PARENT_FINANCIAL_ITEM_ID =' || X_PARENT_FINANCIAL_ITEM_ID );
2299:
2300:
2301: RAISE ;
2302: RETURN;

Line 2381: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

2377: end if;
2378: close c;
2379: */
2380: WHEN OTHERS THEN
2381: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2382: -- dbms_output.put_line(SQLERRM);
2383: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
2384: g_retcode := '2';
2385: fnd_file.put_line(fnd_file.LOG, 'STATEMENT_GROUP_ID =' || X_STATEMENT_GROUP_ID );

Line 2385: fnd_file.put_line(fnd_file.LOG, 'STATEMENT_GROUP_ID =' || X_STATEMENT_GROUP_ID );

2381: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2382: -- dbms_output.put_line(SQLERRM);
2383: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
2384: g_retcode := '2';
2385: fnd_file.put_line(fnd_file.LOG, 'STATEMENT_GROUP_ID =' || X_STATEMENT_GROUP_ID );
2386: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_STATEMENT_ID =' || X_FINANCIAL_STATEMENT_ID);
2387: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_ITEM_ID=' || X_FINANCIAL_ITEM_ID);
2388: fnd_file.put_line(fnd_file.LOG, 'LANGUAGE=' || X_LANGUAGE);
2389:

Line 2386: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_STATEMENT_ID =' || X_FINANCIAL_STATEMENT_ID);

2382: -- dbms_output.put_line(SQLERRM);
2383: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
2384: g_retcode := '2';
2385: fnd_file.put_line(fnd_file.LOG, 'STATEMENT_GROUP_ID =' || X_STATEMENT_GROUP_ID );
2386: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_STATEMENT_ID =' || X_FINANCIAL_STATEMENT_ID);
2387: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_ITEM_ID=' || X_FINANCIAL_ITEM_ID);
2388: fnd_file.put_line(fnd_file.LOG, 'LANGUAGE=' || X_LANGUAGE);
2389:
2390:

Line 2387: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_ITEM_ID=' || X_FINANCIAL_ITEM_ID);

2383: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
2384: g_retcode := '2';
2385: fnd_file.put_line(fnd_file.LOG, 'STATEMENT_GROUP_ID =' || X_STATEMENT_GROUP_ID );
2386: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_STATEMENT_ID =' || X_FINANCIAL_STATEMENT_ID);
2387: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_ITEM_ID=' || X_FINANCIAL_ITEM_ID);
2388: fnd_file.put_line(fnd_file.LOG, 'LANGUAGE=' || X_LANGUAGE);
2389:
2390:
2391: RAISE ;

Line 2388: fnd_file.put_line(fnd_file.LOG, 'LANGUAGE=' || X_LANGUAGE);

2384: g_retcode := '2';
2385: fnd_file.put_line(fnd_file.LOG, 'STATEMENT_GROUP_ID =' || X_STATEMENT_GROUP_ID );
2386: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_STATEMENT_ID =' || X_FINANCIAL_STATEMENT_ID);
2387: fnd_file.put_line(fnd_file.LOG, 'FINANCIAL_ITEM_ID=' || X_FINANCIAL_ITEM_ID);
2388: fnd_file.put_line(fnd_file.LOG, 'LANGUAGE=' || X_LANGUAGE);
2389:
2390:
2391: RAISE ;
2392: RETURN;

Line 2444: fnd_file.put_line(fnd_file.LOG, 'Warning :- Duplicate Account '|| X_ACCOUNT_GROUP_ID ||' found for Financial Item ' || X_FINANCIAL_ITEM_ID || 'for Statement ' || X_STATEMENT_GROUP_ID );

2440: NATURAL_ACCOUNT_ID = X_NATURAL_ACCOUNT_ID ;
2441:
2442: if itmacc_count <> 0 then
2443:
2444: fnd_file.put_line(fnd_file.LOG, 'Warning :- Duplicate Account '|| X_ACCOUNT_GROUP_ID ||' found for Financial Item ' || X_FINANCIAL_ITEM_ID || 'for Statement ' || X_STATEMENT_GROUP_ID );
2445:
2446: else -- if no recrods exists for the unique key
2447: insert into AMW_FIN_ITEMS_KEY_ACC(
2448: STATEMENT_GROUP_ID,

Line 2509: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

2505: X_OBJECT_VERSION_NUMBER );
2506: END IF;
2507: end;
2508: EXCEPTION WHEN OTHERS THEN
2509: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
2510: -- dbms_output.put_line(SQLERRM);
2511: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
2512: g_retcode := '2';
2513:

Line 2537: fnd_file.put_line(fnd_file.LOG,g_errbuf );

2533:
2534: FND_MESSAGE.SET_NAME ('AMW', 'AMW_ACCIMPORT_PROFILE_NO_VALUE');
2535: g_errbuf := FND_MESSAGE.GET_STRING('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');
2536: m_errMsg := FND_MESSAGE.GET_STRING('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');
2537: fnd_file.put_line(fnd_file.LOG,g_errbuf );
2538:
2539: -- fnd_file.put_line(fnd_file.LOG, SUBSTR ('Run Aborted. No value for Profile AMW_ACCOUNT_SOURCE_VIEW. Make sure that value exists for AMW_ACCOUNT_SOURCE_VIEW and AMW_ACCOUNT_NAMES_VIEW', 1, 200));
2540: -- g_errbuf := 'Run Aborted. No value for Profile AMW_ACCOUNT_SOURCE_VIEW. Make sure that value exists for AMW_ACCOUNT_SOURCE_VIEW and AMW_ACCOUNT_NAMES_VIEW';
2541:

Line 2539: -- fnd_file.put_line(fnd_file.LOG, SUBSTR ('Run Aborted. No value for Profile AMW_ACCOUNT_SOURCE_VIEW. Make sure that value exists for AMW_ACCOUNT_SOURCE_VIEW and AMW_ACCOUNT_NAMES_VIEW', 1, 200));

2535: g_errbuf := FND_MESSAGE.GET_STRING('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');
2536: m_errMsg := FND_MESSAGE.GET_STRING('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');
2537: fnd_file.put_line(fnd_file.LOG,g_errbuf );
2538:
2539: -- fnd_file.put_line(fnd_file.LOG, SUBSTR ('Run Aborted. No value for Profile AMW_ACCOUNT_SOURCE_VIEW. Make sure that value exists for AMW_ACCOUNT_SOURCE_VIEW and AMW_ACCOUNT_NAMES_VIEW', 1, 200));
2540: -- g_errbuf := 'Run Aborted. No value for Profile AMW_ACCOUNT_SOURCE_VIEW. Make sure that value exists for AMW_ACCOUNT_SOURCE_VIEW and AMW_ACCOUNT_NAMES_VIEW';
2541:
2542: g_retcode := '2';
2543:

Line 2551: fnd_file.put_line(fnd_file.LOG,g_errbuf );

2547:
2548: FND_MESSAGE.SET_NAME ('AMW', 'AMW_ACCIMPORT_PROFILE_NO_VALUE');
2549: g_errbuf := FND_MESSAGE.GET_STRING('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');
2550: m_errMsg := FND_MESSAGE.GET_STRING('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');
2551: fnd_file.put_line(fnd_file.LOG,g_errbuf );
2552:
2553:
2554: -- fnd_file.put_line(fnd_file.LOG, SUBSTR ('Run Aborted. No value for Profile AMW_ACCOUNT_NAMES_VIEW Make sure that value exists for AMW_ACCOUNT_SOURCE_VIEW and AMW_ACCOUNT_NAMES_VIEW', 1, 200));
2555: -- g_errbuf := 'Run Aborted. No value for Profile AMW_ACCOUNT_NAMES_VIEW Make sure that value exists for AMW_ACCOUNT_SOURCE_VIEW and AMW_ACCOUNT_NAMES_VIEW';

Line 2554: -- fnd_file.put_line(fnd_file.LOG, SUBSTR ('Run Aborted. No value for Profile AMW_ACCOUNT_NAMES_VIEW Make sure that value exists for AMW_ACCOUNT_SOURCE_VIEW and AMW_ACCOUNT_NAMES_VIEW', 1, 200));

2550: m_errMsg := FND_MESSAGE.GET_STRING('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');
2551: fnd_file.put_line(fnd_file.LOG,g_errbuf );
2552:
2553:
2554: -- fnd_file.put_line(fnd_file.LOG, SUBSTR ('Run Aborted. No value for Profile AMW_ACCOUNT_NAMES_VIEW Make sure that value exists for AMW_ACCOUNT_SOURCE_VIEW and AMW_ACCOUNT_NAMES_VIEW', 1, 200));
2555: -- g_errbuf := 'Run Aborted. No value for Profile AMW_ACCOUNT_NAMES_VIEW Make sure that value exists for AMW_ACCOUNT_SOURCE_VIEW and AMW_ACCOUNT_NAMES_VIEW';
2556: g_retcode := '2';
2557:
2558:

Line 2589: fnd_file.put_line(fnd_file.LOG,g_errbuf );

2585: if (trim(M_AMW_STMNT_SOURCE_VIEW) is null) then
2586:
2587: FND_MESSAGE.SET_NAME ('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');
2588: g_errbuf := FND_MESSAGE.GET_STRING('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');
2589: fnd_file.put_line(fnd_file.LOG,g_errbuf );
2590: g_retcode := '2';
2591:
2592: /* fnd_file.put_line(fnd_file.LOG, SUBSTR ('Run Aborted. No value for Profile AMW_STMNT_SOURCE_VIEW . Make sure that value exists for AMW_STMNT_SOURCE_VIEW', 1, 200));
2593:

Line 2592: /* fnd_file.put_line(fnd_file.LOG, SUBSTR ('Run Aborted. No value for Profile AMW_STMNT_SOURCE_VIEW . Make sure that value exists for AMW_STMNT_SOURCE_VIEW', 1, 200));

2588: g_errbuf := FND_MESSAGE.GET_STRING('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');
2589: fnd_file.put_line(fnd_file.LOG,g_errbuf );
2590: g_retcode := '2';
2591:
2592: /* fnd_file.put_line(fnd_file.LOG, SUBSTR ('Run Aborted. No value for Profile AMW_STMNT_SOURCE_VIEW . Make sure that value exists for AMW_STMNT_SOURCE_VIEW', 1, 200));
2593:
2594: g_errbuf := 'Run Aborted. No value for Profile AMW_STMNT_SOURCE_VIEW . Make sure that value exists for AMW_STMNT_SOURCE_VIEW';
2595: g_retcode := '2';
2596: */

Line 2603: fnd_file.put_line(fnd_file.LOG,g_errbuf );

2599: if (trim(M_AMW_FINITEM_SOURCE_VIEW) is null) then
2600:
2601: FND_MESSAGE.SET_NAME ('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');
2602: g_errbuf := FND_MESSAGE.GET_STRING('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');
2603: fnd_file.put_line(fnd_file.LOG,g_errbuf );
2604: g_retcode := '2';
2605:
2606:
2607: /* fnd_file.put_line(fnd_file.LOG, SUBSTR ('Run Aborted. No value for Profile AMW_FINITEM_SOURCE_VIEW. Make sure that value exists for AMW_FINITEM_SOURCE_VIEW ', 1, 200));

Line 2607: /* fnd_file.put_line(fnd_file.LOG, SUBSTR ('Run Aborted. No value for Profile AMW_FINITEM_SOURCE_VIEW. Make sure that value exists for AMW_FINITEM_SOURCE_VIEW ', 1, 200));

2603: fnd_file.put_line(fnd_file.LOG,g_errbuf );
2604: g_retcode := '2';
2605:
2606:
2607: /* fnd_file.put_line(fnd_file.LOG, SUBSTR ('Run Aborted. No value for Profile AMW_FINITEM_SOURCE_VIEW. Make sure that value exists for AMW_FINITEM_SOURCE_VIEW ', 1, 200));
2608: g_errbuf := 'Run Aborted. No value for Profile AMW_FINITEM_SOURCE_VIEW. Make sure that value exists for AMW_FINITEM_SOURCE_VIEW ';
2609: g_retcode := '2';
2610: */
2611: return False;

Line 2618: fnd_file.put_line(fnd_file.LOG,g_errbuf );

2614: if (trim(M_AMW_FIN_ITEM_ACC_MAP_VIEW) is null) then
2615:
2616: FND_MESSAGE.SET_NAME ('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');
2617: g_errbuf := FND_MESSAGE.GET_STRING('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');
2618: fnd_file.put_line(fnd_file.LOG,g_errbuf );
2619: g_retcode := '2';
2620:
2621: /*
2622: fnd_file.put_line(fnd_file.LOG, SUBSTR ('Run Aborted. No value for Profile AMW_FIN_ITEM_ACC_RELATIONS_VIEW. Make sure that value exists for AMW_FIN_ITEM_ACC_RELATIONS_VIEW ', 1, 200));

Line 2622: fnd_file.put_line(fnd_file.LOG, SUBSTR ('Run Aborted. No value for Profile AMW_FIN_ITEM_ACC_RELATIONS_VIEW. Make sure that value exists for AMW_FIN_ITEM_ACC_RELATIONS_VIEW ', 1, 200));

2618: fnd_file.put_line(fnd_file.LOG,g_errbuf );
2619: g_retcode := '2';
2620:
2621: /*
2622: fnd_file.put_line(fnd_file.LOG, SUBSTR ('Run Aborted. No value for Profile AMW_FIN_ITEM_ACC_RELATIONS_VIEW. Make sure that value exists for AMW_FIN_ITEM_ACC_RELATIONS_VIEW ', 1, 200));
2623: g_errbuf := 'Run Aborted. No value for Profile AMW_FIN_ITEM_ACC_RELATIONS_VIEW. Make sure that value exists for AMW_FIN_ITEM_ACC_RELATIONS_VIEW ';
2624: g_retcode := '2';
2625: */
2626: return False;

Line 2632: fnd_file.put_line(fnd_file.LOG,g_errbuf );

2628: if (trim(M_AMW_STMNT_SOURCE_TL_VIEW) is null) then
2629:
2630: FND_MESSAGE.SET_NAME ('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');
2631: g_errbuf := FND_MESSAGE.GET_STRING('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');
2632: fnd_file.put_line(fnd_file.LOG,g_errbuf );
2633: g_retcode := '2';
2634:
2635: /*
2636: fnd_file.put_line(fnd_file.LOG, SUBSTR ('Run Aborted. No value for Profile AMW_STMNT_SOURCE_TL_VIEW. Make sure that value exists for AMW_STMNT_SOURCE_TL_VIEW', 1, 200));

Line 2636: fnd_file.put_line(fnd_file.LOG, SUBSTR ('Run Aborted. No value for Profile AMW_STMNT_SOURCE_TL_VIEW. Make sure that value exists for AMW_STMNT_SOURCE_TL_VIEW', 1, 200));

2632: fnd_file.put_line(fnd_file.LOG,g_errbuf );
2633: g_retcode := '2';
2634:
2635: /*
2636: fnd_file.put_line(fnd_file.LOG, SUBSTR ('Run Aborted. No value for Profile AMW_STMNT_SOURCE_TL_VIEW. Make sure that value exists for AMW_STMNT_SOURCE_TL_VIEW', 1, 200));
2637: g_errbuf := 'Run Aborted. No value for Profile AMW_STMNT_SOURCE_TL_VIEW. Make sure that value exists for AMW_STMNT_SOURCE_TL_VIEW';
2638: g_retcode := '2';
2639: */
2640:

Line 2648: fnd_file.put_line(fnd_file.LOG,g_errbuf );

2644: if (trim(M_AMW_FINITEM_SOURCE_TL_VIEW) is null) then
2645:
2646: FND_MESSAGE.SET_NAME ('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');
2647: g_errbuf := FND_MESSAGE.GET_STRING('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');
2648: fnd_file.put_line(fnd_file.LOG,g_errbuf );
2649: g_retcode := '2';
2650:
2651: /*
2652: fnd_file.put_line(fnd_file.LOG, SUBSTR ('Run Aborted. No value for Profile AMW_FINITEM_SOURCE_TL_VIEW. Make sure that value exists for AMW_FINITEM_SOURCE_TL_VIEW', 1, 200));

Line 2652: fnd_file.put_line(fnd_file.LOG, SUBSTR ('Run Aborted. No value for Profile AMW_FINITEM_SOURCE_TL_VIEW. Make sure that value exists for AMW_FINITEM_SOURCE_TL_VIEW', 1, 200));

2648: fnd_file.put_line(fnd_file.LOG,g_errbuf );
2649: g_retcode := '2';
2650:
2651: /*
2652: fnd_file.put_line(fnd_file.LOG, SUBSTR ('Run Aborted. No value for Profile AMW_FINITEM_SOURCE_TL_VIEW. Make sure that value exists for AMW_FINITEM_SOURCE_TL_VIEW', 1, 200));
2653: g_errbuf := 'Run Aborted. No value for Profile AMW_FINITEM_SOURCE_TL_VIEW. Make sure that value exists for AMW_FINITEM_SOURCE_TL_VIEW';
2654: g_retcode := '2';
2655: */
2656:

Line 2681: fnd_file.put_line(fnd_file.LOG,g_errbuf );

2677: FND_MESSAGE.SET_NAME ('AMW', 'AMW_KEY_ACCOUNTS_NOT_IMPORTED');
2678: g_errbuf := FND_MESSAGE.GET_STRING('AMW', 'AMW_KEY_ACCOUNTS_NOT_IMPORTED');
2679: --m_errMsg := FND_MESSAGE.GET_STRING('AMW', 'AMW_KEY_ACCOUNTS_NOT_IMPORTED');
2680: g_retcode :=2;
2681: fnd_file.put_line(fnd_file.LOG,g_errbuf );
2682: return False;
2683: end if;
2684: return True;
2685: end;

Line 2703: fnd_file.put_line(fnd_file.LOG,g_errbuf );

2699: FND_MESSAGE.SET_NAME ('AMW', 'AMW_ACCT_VALUE_SET_NOT_DEFINED');
2700: g_errbuf := FND_MESSAGE.GET_STRING('AMW', 'AMW_ACCT_VALUE_SET_NOT_DEFINED');
2701: --m_errMsg := FND_MESSAGE.GET_STRING('AMW', 'AMW_ACCT_VALUE_SET_NOT_DEFINED');
2702: g_retcode :=2;
2703: fnd_file.put_line(fnd_file.LOG,g_errbuf );
2704: return False;
2705: end if;
2706: return True;
2707: end;