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.FV_1099_TRANSACTION dependencies on FND_LOG

Line 78: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

74: BEGIN
75:
76: l_module_name := g_module_name || 'fvr1099p';
77:
78: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
79: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BEGIN');
80: END IF;
81: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
82: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BEGIN');

Line 79: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BEGIN');

75:
76: l_module_name := g_module_name || 'fvr1099p';
77:
78: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
79: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BEGIN');
80: END IF;
81: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
82: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BEGIN');
83: END IF;

Line 81: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

77:
78: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
79: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BEGIN');
80: END IF;
81: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
82: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BEGIN');
83: END IF;
84:
85: /* Multi org changes */

Line 82: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BEGIN');

78: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
79: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BEGIN');
80: END IF;
81: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
82: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BEGIN');
83: END IF;
84:
85: /* Multi org changes */
86: --- v_org_id := to_number(fnd_profile.value('ORG_ID'));

Line 111: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

107: -- v_end_date := to_date(l_end_date, 'DD-MON-YYYY') ;
108:
109:
110:
111: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
112: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BEGIN_DATE ='||TO_CHAR(V_BEGIN_DATE, 'DD-MON-YYYY'));
113: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BEGIN_DATE ='||TO_CHAR(V_END_DATE, 'DD-MON-YYYY'));
114: END IF;
115: v_user_id := FND_GLOBAL.USER_ID;

Line 112: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BEGIN_DATE ='||TO_CHAR(V_BEGIN_DATE, 'DD-MON-YYYY'));

108:
109:
110:
111: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
112: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BEGIN_DATE ='||TO_CHAR(V_BEGIN_DATE, 'DD-MON-YYYY'));
113: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BEGIN_DATE ='||TO_CHAR(V_END_DATE, 'DD-MON-YYYY'));
114: END IF;
115: v_user_id := FND_GLOBAL.USER_ID;
116: v_login_id := FND_GLOBAL.LOGIN_ID;

Line 113: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BEGIN_DATE ='||TO_CHAR(V_END_DATE, 'DD-MON-YYYY'));

109:
110:
111: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
112: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BEGIN_DATE ='||TO_CHAR(V_BEGIN_DATE, 'DD-MON-YYYY'));
113: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BEGIN_DATE ='||TO_CHAR(V_END_DATE, 'DD-MON-YYYY'));
114: END IF;
115: v_user_id := FND_GLOBAL.USER_ID;
116: v_login_id := FND_GLOBAL.LOGIN_ID;
117:

Line 127: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

123: -- reassign variables.
124: v_process_inv_id := v_adjustment_rec.id;
125: v_customer_id := v_adjustment_rec.bill_to_customer_id;
126:
127: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
128: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'INVOICE_ID ='||V_PROCESS_INV_ID);
129: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CUSTOMER_ID = '||V_CUSTOMER_ID);
130: END IF;
131:

Line 128: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'INVOICE_ID ='||V_PROCESS_INV_ID);

124: v_process_inv_id := v_adjustment_rec.id;
125: v_customer_id := v_adjustment_rec.bill_to_customer_id;
126:
127: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
128: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'INVOICE_ID ='||V_PROCESS_INV_ID);
129: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CUSTOMER_ID = '||V_CUSTOMER_ID);
130: END IF;
131:
132: -- sum all finance charge debit memos for an invoice and specified type.

Line 129: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CUSTOMER_ID = '||V_CUSTOMER_ID);

125: v_customer_id := v_adjustment_rec.bill_to_customer_id;
126:
127: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
128: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'INVOICE_ID ='||V_PROCESS_INV_ID);
129: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CUSTOMER_ID = '||V_CUSTOMER_ID);
130: END IF;
131:
132: -- sum all finance charge debit memos for an invoice and specified type.
133: OPEN debit_memos_c;

Line 140: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

136: IF debit_memos_c%NOTFOUND THEN
137: v_debit_memo_sum := 0;
138: END IF;
139:
140: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
141: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'DEBIT_MEMO_SUM ='||V_DEBIT_MEMO_SUM);
142: END IF;
143: CLOSE debit_memos_c;
144:

Line 141: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'DEBIT_MEMO_SUM ='||V_DEBIT_MEMO_SUM);

137: v_debit_memo_sum := 0;
138: END IF;
139:
140: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
141: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'DEBIT_MEMO_SUM ='||V_DEBIT_MEMO_SUM);
142: END IF;
143: CLOSE debit_memos_c;
144:
145: BEGIN

Line 156: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error1', errbuf) ;

152: EXCEPTION
153: when others then
154: retcode := 2;
155: errbuf := 'A-'||sqlerrm;
156: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error1', errbuf) ;
157: /* Bug No: 1979347
158: Bug Desc: 1099-C SET-UP PROCESS FAILS WITH ERROR*/
159: --CLOSE all_adjustments_c;
160: --rollback;

Line 180: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error2', errbuf) ;

176: EXCEPTION
177: when others then
178: retcode := 2;
179: errbuf := 'B-'||sqlerrm;
180: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error2', errbuf) ;
181: /* Bug No: 1979347
182: Bug Desc: 1099-C SET-UP PROCESS FAILS WITH ERROR*/
183: --CLOSE all_adjustments_c;
184: --rollback;

Line 197: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error3', errbuf) ;

193: EXCEPTION
194: when others then
195: retcode := 2;
196: errbuf := 'C-'||sqlerrm;
197: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error3', errbuf) ;
198: /* Bug No: 1979347
199: Bug Desc: 1099-C SET-UP PROCESS FAILS WITH ERROR*/
200: --CLOSE all_adjustments_c;
201: --rollback;

Line 239: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error4', errbuf) ;

235: EXCEPTION
236: WHEN others THEN
237: retcode := 2;
238: errbuf := 'D-'||sqlerrm;
239: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error4', errbuf) ;
240: /* Bug No: 1979347
241: Bug Desc: 1099-C SET-UP PROCESS FAILS WITH ERROR*/
242: --CLOSE all_adjustments_c;
243: --rollback;

Line 250: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error5', errbuf) ;

246: EXCEPTION
247: when others THEN
248: retcode := 2;
249: errbuf := 'E-'||sqlerrm;
250: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error5', errbuf) ;
251: /* Bug No: 1979347
252: Bug Desc: 1099-C SET-UP PROCESS FAILS WITH ERROR*/
253: --CLOSE all_adjustments_c;
254: END;

Line 256: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

252: Bug Desc: 1099-C SET-UP PROCESS FAILS WITH ERROR*/
253: --CLOSE all_adjustments_c;
254: END;
255:
256: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
257: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'APPLY_DATE = '||V_APPLY_DATE);
258: END IF;
259: INSERT INTO fv_1099c
260: (set_of_books_id,

Line 257: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'APPLY_DATE = '||V_APPLY_DATE);

253: --CLOSE all_adjustments_c;
254: END;
255:
256: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
257: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'APPLY_DATE = '||V_APPLY_DATE);
258: END IF;
259: INSERT INTO fv_1099c
260: (set_of_books_id,
261: creditors_tin,

Line 320: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception', errbuf) ;

316: EXCEPTION
317: WHEN others then
318: retcode := 2;
319: errbuf := sqlerrm;
320: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception', errbuf) ;
321: rollback;
322: END;
323: BEGIN
324: