981: m_flex_value_set_id := acc_segment.flex_value_set_id;
982:
983: if m_flex_value_set_id <> default_value_set_id then
984:
985: FND_MESSAGE.SET_NAME ('AMW', 'AMW_STMNTS_NOT_IN_ACC_VAL_SET');
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:
982:
983: if m_flex_value_set_id <> default_value_set_id then
984:
985: FND_MESSAGE.SET_NAME ('AMW', 'AMW_STMNTS_NOT_IN_ACC_VAL_SET');
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,'---------------------------!!!!!!!!!!!!---------------------------------');
983: if m_flex_value_set_id <> default_value_set_id then
984:
985: FND_MESSAGE.SET_NAME ('AMW', 'AMW_STMNTS_NOT_IN_ACC_VAL_SET');
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:
2528: select fnd_profile.value('AMW_ACCOUNT_SOURCE_VIEW') into M_AMW_ACCOUNT_SOURCE_VIEW from dual;
2529: select fnd_profile.value('AMW_ACCOUNT_NAMES_VIEW' ) into M_AMW_ACCOUNT_NAMES_VIEW from dual;
2530: if (trim(M_AMW_ACCOUNT_SOURCE_VIEW) is null) then
2531:
2532: -- FND_MESSAGE.SET_NAME ('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');
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');
2530: if (trim(M_AMW_ACCOUNT_SOURCE_VIEW) is null) then
2531:
2532: -- FND_MESSAGE.SET_NAME ('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');
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:
2531:
2532: -- FND_MESSAGE.SET_NAME ('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');
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));
2532: -- FND_MESSAGE.SET_NAME ('AMW', 'AMW_FINIMPORT_PROFILE_NO_VALUE');
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';
2544: return False;
2545: end if;
2546: if (trim(M_AMW_ACCOUNT_SOURCE_VIEW) is null) then
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:
2545: end if;
2546: if (trim(M_AMW_ACCOUNT_SOURCE_VIEW) is null) then
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:
2546: if (trim(M_AMW_ACCOUNT_SOURCE_VIEW) is null) then
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));
2583:
2584:
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:
2584:
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));
2597: return False;
2598: end if;
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:
2598: end if;
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:
2612: end if;
2613:
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:
2613:
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: /*
2626: return False;
2627: end if;
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:
2627: end if;
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: /*
2642: end if;
2643:
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:
2643:
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: /*
2673: begin
2674: select count(account_group_id) into M_acct_count from amw_fin_key_Accounts_b where END_DATE is null;
2675:
2676: if M_acct_count = 0 then
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 );
2674: select count(account_group_id) into M_acct_count from amw_fin_key_Accounts_b where END_DATE is null;
2675:
2676: if M_acct_count = 0 then
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;
2675:
2676: if M_acct_count = 0 then
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;
2695: begin
2696: select fnd_profile.value('AMW_NATRL_ACCT_VALUE_SET') into acc_value_set_id from dual ;
2697:
2698: if acc_value_set_id IS NULL then
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 );
2696: select fnd_profile.value('AMW_NATRL_ACCT_VALUE_SET') into acc_value_set_id from dual ;
2697:
2698: if acc_value_set_id IS NULL then
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;
2697:
2698: if acc_value_set_id IS NULL then
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;