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

Line 50: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);

46: INTO lc_company_name
47: FROM fa_system_controls FSC;
48: EXCEPTION
49: WHEN OTHERS THEN
50: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
51: END;
52:
53:
54: --********************************************************

Line 68: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);

64: WHERE book_type_code = P_BOOK_NAME
65: AND FBC.set_of_books_id = GL.ledger_id;
66: EXCEPTION
67: WHEN NO_DATA_FOUND THEN
68: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
69: WHEN OTHERS THEN
70: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
71: END;
72:

Line 70: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);

66: EXCEPTION
67: WHEN NO_DATA_FOUND THEN
68: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
69: WHEN OTHERS THEN
70: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
71: END;
72:
73:
74: --************************************************

Line 79: FND_FILE.PUT_LINE(FND_FILE.LOG,'state registration date='||lc_state_reg_date);

75: --1)To fetch DFF STATE REGISTRATION DATE--
76: --************************************************
77:
78: lc_state_reg_date:= GET_DFF_COLUMN_NAME ('140','fa_additions','state registration date');
79: FND_FILE.PUT_LINE(FND_FILE.LOG,'state registration date='||lc_state_reg_date);
80:
81: --***********************************************
82: --2)To fetch DFF YEARS--
83: --***********************************************

Line 86: FND_FILE.PUT_LINE(FND_FILE.LOG,'years='||lc_years);

82: --2)To fetch DFF YEARS--
83: --***********************************************
84:
85: lc_years:= GET_DFF_COLUMN_NAME ('140','fa_flat_rates','years');
86: FND_FILE.PUT_LINE(FND_FILE.LOG,'years='||lc_years);
87:
88: --***********************************************
89: --3)To fetch DFF MONTHS--
90: --***********************************************

Line 93: FND_FILE.PUT_LINE(FND_FILE.LOG,'months='||lc_months);

89: --3)To fetch DFF MONTHS--
90: --***********************************************
91:
92: lc_months:= GET_DFF_COLUMN_NAME ('140','fa_flat_rates','months');
93: FND_FILE.PUT_LINE(FND_FILE.LOG,'months='||lc_months);
94:
95: --***********************************************
96: --4)To fetch DFF TAX BOOK COST--
97: --***********************************************

Line 100: FND_FILE.PUT_LINE(FND_FILE.LOG,'tax book cost='||lc_tax_book_cost);

96: --4)To fetch DFF TAX BOOK COST--
97: --***********************************************
98:
99: lc_tax_book_cost:= GET_DFF_COLUMN_NAME ('140','fa_asset_invoices','tax book cost');
100: FND_FILE.PUT_LINE(FND_FILE.LOG,'tax book cost='||lc_tax_book_cost);
101:
102: --***********************************************
103: --5)To fetch DFF REFERENCE--
104: --***********************************************

Line 107: FND_FILE.PUT_LINE(FND_FILE.LOG,'reference='||lc_reference);

103: --5)To fetch DFF REFERENCE--
104: --***********************************************
105:
106: lc_reference:= GET_DFF_COLUMN_NAME ('140','fa_transaction_headers','reference');
107: FND_FILE.PUT_LINE(FND_FILE.LOG,'reference='||lc_reference);
108:
109: --***********************************************
110: --6)To fetch DFF EVENT_DATE--
111: --***********************************************

Line 113: FND_FILE.PUT_LINE(FND_FILE.LOG,'event_date='||lc_event_date);

109: --***********************************************
110: --6)To fetch DFF EVENT_DATE--
111: --***********************************************
112: lc_event_date:= GET_DFF_COLUMN_NAME ('140','fa_transaction_headers','event_date');
113: FND_FILE.PUT_LINE(FND_FILE.LOG,'event_date='||lc_event_date);
114:
115: --***********************************************
116: --7)To fetch DFF SUSPENSE_REASON--
117: --***********************************************

Line 120: FND_FILE.PUT_LINE(FND_FILE.LOG,'suspense_reason='||lc_suspense_reason);

116: --7)To fetch DFF SUSPENSE_REASON--
117: --***********************************************
118:
119: lc_suspense_reason:= GET_DFF_COLUMN_NAME ('140','fa_transaction_headers','suspense_reason');
120: FND_FILE.PUT_LINE(FND_FILE.LOG,'suspense_reason='||lc_suspense_reason);
121:
122: --***********************************************
123: --8)To fetch DFF ADJUSTING COEFFICIENT--
124: --***********************************************

Line 126: FND_FILE.PUT_LINE(FND_FILE.LOG,'adjusting coefficient='||lc_adjusting_coefficient);

122: --***********************************************
123: --8)To fetch DFF ADJUSTING COEFFICIENT--
124: --***********************************************
125: lc_adjusting_coefficient:= GET_DFF_COLUMN_NAME ('140','fa_flat_rates','adjusting coefficient');
126: FND_FILE.PUT_LINE(FND_FILE.LOG,'adjusting coefficient='||lc_adjusting_coefficient);
127:
128: --***********************************************
129: --9)To fetch DFF ADJ_RATE_REASON
130: --***********************************************

Line 133: FND_FILE.PUT_LINE(FND_FILE.LOG,'adj_rate_reason='||lc_adj_rate_reason);

129: --9)To fetch DFF ADJ_RATE_REASON
130: --***********************************************
131:
132: lc_adj_rate_reason:= GET_DFF_COLUMN_NAME ('140','fa_transaction_headers','adj_rate_reason');
133: FND_FILE.PUT_LINE(FND_FILE.LOG,'adj_rate_reason='||lc_adj_rate_reason);
134:
135: --***********************************************
136: --10)To fetch DFF BASE RATE--
137: --***********************************************

Line 139: FND_FILE.PUT_LINE(FND_FILE.LOG,'base rate='||lc_base_rate);

135: --***********************************************
136: --10)To fetch DFF BASE RATE--
137: --***********************************************
138: lc_base_rate:= GET_DFF_COLUMN_NAME ('140','fa_flat_rates','base rate');
139: FND_FILE.PUT_LINE(FND_FILE.LOG,'base rate='||lc_base_rate);
140:
141:
142: RETURN TRUE;
143: END beforereport;

Line 169: FND_FILE.PUT_LINE(FND_FILE.LOG,'DATA NOT FOUND .');

165: AND UPPER(FDFCU.descriptive_flex_context_code) = 'GLOBAL DATA ELEMENTS'
166: AND UPPER(FDFCU.end_user_column_name) = UPPER(p_segment_name);
167: EXCEPTION
168: WHEN NO_DATA_FOUND THEN
169: FND_FILE.PUT_LINE(FND_FILE.LOG,'DATA NOT FOUND .');
170: WHEN OTHERS THEN
171: FND_FILE.PUT_LINE(FND_FILE.LOG,'DATA NOT FOUND .');
172: end;
173: IF p_dff_appln_colname IS NULL THEN

Line 171: FND_FILE.PUT_LINE(FND_FILE.LOG,'DATA NOT FOUND .');

167: EXCEPTION
168: WHEN NO_DATA_FOUND THEN
169: FND_FILE.PUT_LINE(FND_FILE.LOG,'DATA NOT FOUND .');
170: WHEN OTHERS THEN
171: FND_FILE.PUT_LINE(FND_FILE.LOG,'DATA NOT FOUND .');
172: end;
173: IF p_dff_appln_colname IS NULL THEN
174: FND_FILE.PUT_LINE(FND_FILE.LOG,p_segment_name||'not found');
175: ELSE

Line 174: FND_FILE.PUT_LINE(FND_FILE.LOG,p_segment_name||'not found');

170: WHEN OTHERS THEN
171: FND_FILE.PUT_LINE(FND_FILE.LOG,'DATA NOT FOUND .');
172: end;
173: IF p_dff_appln_colname IS NULL THEN
174: FND_FILE.PUT_LINE(FND_FILE.LOG,p_segment_name||'not found');
175: ELSE
176: RETURN (p_dff_appln_colname);
177: END IF;
178: END get_dff_column_name;