DBA Data[Home] [Help]

APPS.FV_GTAS_INTERFACE dependencies on FND_FILE

Line 790: fnd_file.put_line(fnd_file.output, rpad(p_acct_num,24)||rpad(P_Fund_Value,23)) ;

786: p_exception_category:= 'USSGL_DISABLED';
787: --ER:Print the account number
788: log(l_module_name,'Ussgl disabled');
789: print_header;
790: fnd_file.put_line(fnd_file.output, rpad(p_acct_num,24)||rpad(P_Fund_Value,23)) ;
791: del_disabled_accts(p_acct_num);
792:
793: Return;
794: End If;

Line 859: fnd_file.put_line(fnd_file.output, rpad(p_acct_num,24)||rpad(P_Fund_Value,23)) ;

855: IF L_Ussgl_Enabled Is Not Null and L_Ussgl_Enabled = 'N' THEN
856: p_exception_category:= 'USSGL_DISABLED';
857: log(l_module_name,'Ussgl disabled');
858: print_header;
859: fnd_file.put_line(fnd_file.output, rpad(p_acct_num,24)||rpad(P_Fund_Value,23)) ;
860: del_disabled_accts(p_acct_num);
861: Return;
862: End If;
863: Gbl_Error_Code := 0;

Line 878: fnd_file.put_line(fnd_file.output, rpad(p_acct_num,24)||rpad(P_Fund_Value,23)) ;

874: doesGTASAccountExist := false;
875: P_Exception_Category := 'GTAS_UNDEFINED';
876: log(l_module_name,'GTAS Undefined');
877: print_header;
878: fnd_file.put_line(fnd_file.output, rpad(p_acct_num,24)||rpad(P_Fund_Value,23)) ;
879: del_disabled_accts(p_acct_num);
880: log(l_module_name, 'Begin 3'||SQLERRM);
881: Return;
882: End;

Line 891: fnd_file.put_line(fnd_file.output, rpad(p_acct_num,24)||rpad(P_Fund_Value,23)) ;

887: -- Attributes window and is not reported in GTAS.
888: If Cnt = 0 Then
889: P_Exception_Category := 'GTAS_UNDEFINED';
890: print_header;
891: fnd_file.put_line(fnd_file.output, rpad(p_acct_num,24)||rpad(P_Fund_Value,23)) ;
892: log(l_module_name, 'gtas_undefined');
893: del_disabled_accts(p_acct_num);
894: Return;
895: End If;

Line 914: fnd_file.put_line(fnd_file.output, rpad(p_acct_num,24)||rpad(P_Fund_Value,23)) ;

910: --Not a Valid US SGL Account
911: If L_Ussgl_Not_Found = 'Y' And l_ussgl_acct_num IS NULL AND Not Doesgtasaccountexist Then
912: P_Exception_Category := 'NON_USSGL_ACCT';
913: print_header;
914: fnd_file.put_line(fnd_file.output, rpad(p_acct_num,24)||rpad(P_Fund_Value,23)) ;
915: log(l_module_name,'Non Ussgl account');
916: del_disabled_accts(p_acct_num);
917: return;
918: END IF;

Line 2577: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No data found for this period year.');

2573:
2574: ELSE -- l_rec_count
2575: l_run_status := 'U';
2576: log(l_module_name, 'No data found for this period year.');
2577: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No data found for this period year.');
2578: END IF;
2579:
2580:
2581: -- Update fv_gtas_run only if there were records

Line 3014: fnd_file.put_line(fnd_file.output, ' GTAS Federal Account Creation Process Report');

3010: FROM GL_LEDGERS_V
3011: WHERE ledger_id = gbl_set_of_books_id;
3012:
3013: IF NOT gbl_header_printed THEN
3014: fnd_file.put_line(fnd_file.output, ' GTAS Federal Account Creation Process Report');
3015: fnd_file.put_line(fnd_file.output, ' ');
3016: fnd_file.put_line(fnd_file.output,'Ledger: '||l_ledger_name);
3017: fnd_file.put_line(fnd_file.output, 'Fiscal Year: '||gbl_fiscal_year);
3018: fnd_file.put_line(fnd_file.output, ' ');

Line 3015: fnd_file.put_line(fnd_file.output, ' ');

3011: WHERE ledger_id = gbl_set_of_books_id;
3012:
3013: IF NOT gbl_header_printed THEN
3014: fnd_file.put_line(fnd_file.output, ' GTAS Federal Account Creation Process Report');
3015: fnd_file.put_line(fnd_file.output, ' ');
3016: fnd_file.put_line(fnd_file.output,'Ledger: '||l_ledger_name);
3017: fnd_file.put_line(fnd_file.output, 'Fiscal Year: '||gbl_fiscal_year);
3018: fnd_file.put_line(fnd_file.output, ' ');
3019: --fnd_file.put_line(fnd_file.output,'USSGL Account Number '||rpad(' ', 16)||' Identified as');

Line 3016: fnd_file.put_line(fnd_file.output,'Ledger: '||l_ledger_name);

3012:
3013: IF NOT gbl_header_printed THEN
3014: fnd_file.put_line(fnd_file.output, ' GTAS Federal Account Creation Process Report');
3015: fnd_file.put_line(fnd_file.output, ' ');
3016: fnd_file.put_line(fnd_file.output,'Ledger: '||l_ledger_name);
3017: fnd_file.put_line(fnd_file.output, 'Fiscal Year: '||gbl_fiscal_year);
3018: fnd_file.put_line(fnd_file.output, ' ');
3019: --fnd_file.put_line(fnd_file.output,'USSGL Account Number '||rpad(' ', 16)||' Identified as');
3020: fnd_file.put_line(fnd_file.output,'USSGL Account Number Fed Non-Fed Trading Ptnr Auth Type Bud Impact');

Line 3017: fnd_file.put_line(fnd_file.output, 'Fiscal Year: '||gbl_fiscal_year);

3013: IF NOT gbl_header_printed THEN
3014: fnd_file.put_line(fnd_file.output, ' GTAS Federal Account Creation Process Report');
3015: fnd_file.put_line(fnd_file.output, ' ');
3016: fnd_file.put_line(fnd_file.output,'Ledger: '||l_ledger_name);
3017: fnd_file.put_line(fnd_file.output, 'Fiscal Year: '||gbl_fiscal_year);
3018: fnd_file.put_line(fnd_file.output, ' ');
3019: --fnd_file.put_line(fnd_file.output,'USSGL Account Number '||rpad(' ', 16)||' Identified as');
3020: fnd_file.put_line(fnd_file.output,'USSGL Account Number Fed Non-Fed Trading Ptnr Auth Type Bud Impact');
3021: fnd_file.put_line(fnd_file.output,'------ -------------- ----------- ------------ --------- ----------');

Line 3018: fnd_file.put_line(fnd_file.output, ' ');

3014: fnd_file.put_line(fnd_file.output, ' GTAS Federal Account Creation Process Report');
3015: fnd_file.put_line(fnd_file.output, ' ');
3016: fnd_file.put_line(fnd_file.output,'Ledger: '||l_ledger_name);
3017: fnd_file.put_line(fnd_file.output, 'Fiscal Year: '||gbl_fiscal_year);
3018: fnd_file.put_line(fnd_file.output, ' ');
3019: --fnd_file.put_line(fnd_file.output,'USSGL Account Number '||rpad(' ', 16)||' Identified as');
3020: fnd_file.put_line(fnd_file.output,'USSGL Account Number Fed Non-Fed Trading Ptnr Auth Type Bud Impact');
3021: fnd_file.put_line(fnd_file.output,'------ -------------- ----------- ------------ --------- ----------');
3022: gbl_header_printed := TRUE;

Line 3019: --fnd_file.put_line(fnd_file.output,'USSGL Account Number '||rpad(' ', 16)||' Identified as');

3015: fnd_file.put_line(fnd_file.output, ' ');
3016: fnd_file.put_line(fnd_file.output,'Ledger: '||l_ledger_name);
3017: fnd_file.put_line(fnd_file.output, 'Fiscal Year: '||gbl_fiscal_year);
3018: fnd_file.put_line(fnd_file.output, ' ');
3019: --fnd_file.put_line(fnd_file.output,'USSGL Account Number '||rpad(' ', 16)||' Identified as');
3020: fnd_file.put_line(fnd_file.output,'USSGL Account Number Fed Non-Fed Trading Ptnr Auth Type Bud Impact');
3021: fnd_file.put_line(fnd_file.output,'------ -------------- ----------- ------------ --------- ----------');
3022: gbl_header_printed := TRUE;
3023: END IF;

Line 3020: fnd_file.put_line(fnd_file.output,'USSGL Account Number Fed Non-Fed Trading Ptnr Auth Type Bud Impact');

3016: fnd_file.put_line(fnd_file.output,'Ledger: '||l_ledger_name);
3017: fnd_file.put_line(fnd_file.output, 'Fiscal Year: '||gbl_fiscal_year);
3018: fnd_file.put_line(fnd_file.output, ' ');
3019: --fnd_file.put_line(fnd_file.output,'USSGL Account Number '||rpad(' ', 16)||' Identified as');
3020: fnd_file.put_line(fnd_file.output,'USSGL Account Number Fed Non-Fed Trading Ptnr Auth Type Bud Impact');
3021: fnd_file.put_line(fnd_file.output,'------ -------------- ----------- ------------ --------- ----------');
3022: gbl_header_printed := TRUE;
3023: END IF;
3024:

Line 3021: fnd_file.put_line(fnd_file.output,'------ -------------- ----------- ------------ --------- ----------');

3017: fnd_file.put_line(fnd_file.output, 'Fiscal Year: '||gbl_fiscal_year);
3018: fnd_file.put_line(fnd_file.output, ' ');
3019: --fnd_file.put_line(fnd_file.output,'USSGL Account Number '||rpad(' ', 16)||' Identified as');
3020: fnd_file.put_line(fnd_file.output,'USSGL Account Number Fed Non-Fed Trading Ptnr Auth Type Bud Impact');
3021: fnd_file.put_line(fnd_file.output,'------ -------------- ----------- ------------ --------- ----------');
3022: gbl_header_printed := TRUE;
3023: END IF;
3024:
3025: BEGIN

Line 3061: fnd_file.put_line(fnd_file.output, RPAD(vg_sgl_acct_number,' ',6)||RPAD(vg_acct_number,' ',15) ||

3057: AND fiscal_year = gbl_fiscal_year;
3058: END IF;
3059:
3060:
3061: fnd_file.put_line(fnd_file.output, RPAD(vg_sgl_acct_number,' ',6)||RPAD(vg_acct_number,' ',15) ||
3062: RPAD(NVL(vl_fed_non_fed_flag,' '),12)||RPAD(NVL(vl_authority_type_flag,' '),10)||
3063: RPAD(NVL(vl_bud_impact_ind_flag,' '),11)||RPAD(NVL(vl_trading_partner_flag,' '),13)||
3064: RPAD(NVL(vg_fed_nonfed_flag,' '),12)||RPAD(NVL(vg_authority_type_flag,' '),10)||
3065: RPAD(NVL(vg_bud_impact_ind_flag,' '),11)||RPAD(NVL(vg_trading_partner_flag,' '),13));

Line 3100: fnd_file.put_line(fnd_file.output, RPAD(vg_sgl_acct_number,7)||RPAD(vg_acct_number,15)||

3096:
3097:
3098: gbl_error_code := 0;
3099:
3100: fnd_file.put_line(fnd_file.output, RPAD(vg_sgl_acct_number,7)||RPAD(vg_acct_number,15)||
3101: RPAD(NVL(vg_fed_nonfed_flag,' '),12)||
3102: RPAD(NVL(vg_trading_partner_flag,' '),13)||RPAD(NVL(vg_authority_type_flag,' '),10)||
3103: RPAD(NVL(vg_bud_impact_ind_flag,' '),11));
3104:

Line 3188: fnd_file.put_line(fnd_file.output,

3184:
3185: BEGIN
3186: IF NOT gbl_header_printed THEN
3187: --IF p_hdr_type = 'DISABLED_USSGL' THEN
3188: fnd_file.put_line(fnd_file.output,
3189: 'The following GL Accounts do not have valid US SGL Accounts');
3190: fnd_file.put_line(fnd_file.output,
3191: '-----------------------------------------------------------');
3192: fnd_file.put_line(fnd_file.output,

Line 3190: fnd_file.put_line(fnd_file.output,

3186: IF NOT gbl_header_printed THEN
3187: --IF p_hdr_type = 'DISABLED_USSGL' THEN
3188: fnd_file.put_line(fnd_file.output,
3189: 'The following GL Accounts do not have valid US SGL Accounts');
3190: fnd_file.put_line(fnd_file.output,
3191: '-----------------------------------------------------------');
3192: fnd_file.put_line(fnd_file.output,
3193: 'GL ACCOUNT FUND');
3194: fnd_file.put_line(fnd_file.output,

Line 3192: fnd_file.put_line(fnd_file.output,

3188: fnd_file.put_line(fnd_file.output,
3189: 'The following GL Accounts do not have valid US SGL Accounts');
3190: fnd_file.put_line(fnd_file.output,
3191: '-----------------------------------------------------------');
3192: fnd_file.put_line(fnd_file.output,
3193: 'GL ACCOUNT FUND');
3194: fnd_file.put_line(fnd_file.output,
3195: '----------------------- -----------------------');
3196:

Line 3194: fnd_file.put_line(fnd_file.output,

3190: fnd_file.put_line(fnd_file.output,
3191: '-----------------------------------------------------------');
3192: fnd_file.put_line(fnd_file.output,
3193: 'GL ACCOUNT FUND');
3194: fnd_file.put_line(fnd_file.output,
3195: '----------------------- -----------------------');
3196:
3197: gbl_header_printed := TRUE;
3198: END IF;