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_AP_CASH_POS_DTL_PKG dependencies on FND_LOG

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

72: AND set_of_books_id = g_set_of_books_id
73: AND org_id = g_org_id;
74:
75: INITIALIZE_PROCESS;
76: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
77: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'INITIALIZED PROCESS');
78: END IF;
79:
80: IF g_error_code <> 0 THEN

Line 77: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'INITIALIZED PROCESS');

73: AND org_id = g_org_id;
74:
75: INITIALIZE_PROCESS;
76: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
77: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'INITIALIZED PROCESS');
78: END IF;
79:
80: IF g_error_code <> 0 THEN
81: retcode := g_error_code;

Line 83: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1',g_error_buf);

79:
80: IF g_error_code <> 0 THEN
81: retcode := g_error_code;
82: errbuf := g_error_buf;
83: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1',g_error_buf);
84: RETURN;
85: END IF;
86:
87: CREATE_CASH_POSITION_RECORD;

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

84: RETURN;
85: END IF;
86:
87: CREATE_CASH_POSITION_RECORD;
88: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
89: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CREATE_CASH_POSITION_RECORD');
90: END IF;
91:
92: IF g_error_code <> 0 THEN

Line 89: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CREATE_CASH_POSITION_RECORD');

85: END IF;
86:
87: CREATE_CASH_POSITION_RECORD;
88: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
89: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CREATE_CASH_POSITION_RECORD');
90: END IF;
91:
92: IF g_error_code <> 0 THEN
93: retcode := g_error_code;

Line 95: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error2',g_error_buf);

91:
92: IF g_error_code <> 0 THEN
93: retcode := g_error_code;
94: errbuf := g_error_buf;
95: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error2',g_error_buf);
96: RETURN;
97: END IF;
98: COMMIT;
99:

Line 104: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' ');

100: -- Added the below IF for the Bug # 2521634
101:
102: IF g_auto_offset_method = 'None' THEN
103: retcode := 1;
104: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' ');
105: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'The Automatic Offset option is set to None.');
106: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'It should be either Balancing or Account.');
107: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Please note that the report'||''''||'s G/L Cash Balance is determined by the');
108: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'funds of the invoices, while journal entries for the payments will be posted');

Line 105: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'The Automatic Offset option is set to None.');

101:
102: IF g_auto_offset_method = 'None' THEN
103: retcode := 1;
104: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' ');
105: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'The Automatic Offset option is set to None.');
106: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'It should be either Balancing or Account.');
107: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Please note that the report'||''''||'s G/L Cash Balance is determined by the');
108: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'funds of the invoices, while journal entries for the payments will be posted');
109: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'to the cash account as defined for the bank account.');

Line 106: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'It should be either Balancing or Account.');

102: IF g_auto_offset_method = 'None' THEN
103: retcode := 1;
104: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' ');
105: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'The Automatic Offset option is set to None.');
106: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'It should be either Balancing or Account.');
107: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Please note that the report'||''''||'s G/L Cash Balance is determined by the');
108: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'funds of the invoices, while journal entries for the payments will be posted');
109: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'to the cash account as defined for the bank account.');
110: /*---------------------------comments begin-------------------------------------

Line 107: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Please note that the report'||''''||'s G/L Cash Balance is determined by the');

103: retcode := 1;
104: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' ');
105: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'The Automatic Offset option is set to None.');
106: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'It should be either Balancing or Account.');
107: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Please note that the report'||''''||'s G/L Cash Balance is determined by the');
108: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'funds of the invoices, while journal entries for the payments will be posted');
109: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'to the cash account as defined for the bank account.');
110: /*---------------------------comments begin-------------------------------------
111: ELSIF g_pooled_flag = 'Y' THEN

Line 108: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'funds of the invoices, while journal entries for the payments will be posted');

104: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' ');
105: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'The Automatic Offset option is set to None.');
106: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'It should be either Balancing or Account.');
107: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Please note that the report'||''''||'s G/L Cash Balance is determined by the');
108: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'funds of the invoices, while journal entries for the payments will be posted');
109: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'to the cash account as defined for the bank account.');
110: /*---------------------------comments begin-------------------------------------
111: ELSIF g_pooled_flag = 'Y' THEN
112: retcode := 0;

Line 109: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'to the cash account as defined for the bank account.');

105: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'The Automatic Offset option is set to None.');
106: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'It should be either Balancing or Account.');
107: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Please note that the report'||''''||'s G/L Cash Balance is determined by the');
108: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'funds of the invoices, while journal entries for the payments will be posted');
109: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'to the cash account as defined for the bank account.');
110: /*---------------------------comments begin-------------------------------------
111: ELSIF g_pooled_flag = 'Y' THEN
112: retcode := 0;
113: errbuf := '** Cash Position Detail Process completed successfully ** ';

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

110: /*---------------------------comments begin-------------------------------------
111: ELSIF g_pooled_flag = 'Y' THEN
112: retcode := 0;
113: errbuf := '** Cash Position Detail Process completed successfully ** ';
114: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
115: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,errbuf);
116: END IF;
117: ------------------------------------------------------------------------------*/
118: END IF;

Line 115: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,errbuf);

111: ELSIF g_pooled_flag = 'Y' THEN
112: retcode := 0;
113: errbuf := '** Cash Position Detail Process completed successfully ** ';
114: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
115: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,errbuf);
116: END IF;
117: ------------------------------------------------------------------------------*/
118: END IF;
119:

Line 123: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' ');

119:
120: /*-------------------------------comments start---------------------------------
121: IF g_pooled_flag = 'N' THEN
122: retcode := 1;
123: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' ');
124: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'The pooled flag is not selected on the bank account '||g_bank_acct_name||'.');
125: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'The G/L Cash Balance is determined by the funds of the invoices.');
126: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Please note that the journal entry for the payments will be posted');
127: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'to the fund of the cash account as defined on the bank account.');

Line 124: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'The pooled flag is not selected on the bank account '||g_bank_acct_name||'.');

120: /*-------------------------------comments start---------------------------------
121: IF g_pooled_flag = 'N' THEN
122: retcode := 1;
123: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' ');
124: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'The pooled flag is not selected on the bank account '||g_bank_acct_name||'.');
125: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'The G/L Cash Balance is determined by the funds of the invoices.');
126: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Please note that the journal entry for the payments will be posted');
127: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'to the fund of the cash account as defined on the bank account.');
128: END IF;

Line 125: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'The G/L Cash Balance is determined by the funds of the invoices.');

121: IF g_pooled_flag = 'N' THEN
122: retcode := 1;
123: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' ');
124: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'The pooled flag is not selected on the bank account '||g_bank_acct_name||'.');
125: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'The G/L Cash Balance is determined by the funds of the invoices.');
126: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Please note that the journal entry for the payments will be posted');
127: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'to the fund of the cash account as defined on the bank account.');
128: END IF;
129: -------------------------------end of comments--------------------------------*/

Line 126: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Please note that the journal entry for the payments will be posted');

122: retcode := 1;
123: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' ');
124: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'The pooled flag is not selected on the bank account '||g_bank_acct_name||'.');
125: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'The G/L Cash Balance is determined by the funds of the invoices.');
126: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Please note that the journal entry for the payments will be posted');
127: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'to the fund of the cash account as defined on the bank account.');
128: END IF;
129: -------------------------------end of comments--------------------------------*/
130:

Line 127: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'to the fund of the cash account as defined on the bank account.');

123: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' ');
124: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'The pooled flag is not selected on the bank account '||g_bank_acct_name||'.');
125: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'The G/L Cash Balance is determined by the funds of the invoices.');
126: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Please note that the journal entry for the payments will be posted');
127: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'to the fund of the cash account as defined on the bank account.');
128: END IF;
129: -------------------------------end of comments--------------------------------*/
130:
131: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' ');

Line 131: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' ');

127: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'to the fund of the cash account as defined on the bank account.');
128: END IF;
129: -------------------------------end of comments--------------------------------*/
130:
131: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' ');
132: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Please Note: It is assumed that payments are made using pooled bank accounts.');
133: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'If pooled accounts are not used, liabilities and payments are not properly distrubuted across multiple funds.');
134:
135: -- make sure to pass g_org_id (not p_org_id) - p_org_id will most probably be NULL

Line 132: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Please Note: It is assumed that payments are made using pooled bank accounts.');

128: END IF;
129: -------------------------------end of comments--------------------------------*/
130:
131: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' ');
132: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Please Note: It is assumed that payments are made using pooled bank accounts.');
133: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'If pooled accounts are not used, liabilities and payments are not properly distrubuted across multiple funds.');
134:
135: -- make sure to pass g_org_id (not p_org_id) - p_org_id will most probably be NULL
136: req_id := FND_REQUEST.SUBMIT_REQUEST('FV', 'FVAPCPDR',NULL,

Line 133: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'If pooled accounts are not used, liabilities and payments are not properly distrubuted across multiple funds.');

129: -------------------------------end of comments--------------------------------*/
130:
131: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' ');
132: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Please Note: It is assumed that payments are made using pooled bank accounts.');
133: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'If pooled accounts are not used, liabilities and payments are not properly distrubuted across multiple funds.');
134:
135: -- make sure to pass g_org_id (not p_org_id) - p_org_id will most probably be NULL
136: req_id := FND_REQUEST.SUBMIT_REQUEST('FV', 'FVAPCPDR',NULL,
137: NULL, FALSE,p_payment_batch,g_org_id);

Line 142: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,errbuf);

138:
139: IF (req_id = 0) THEN
140: retcode := 2;
141: errbuf := 'Failed to submit request for Cash Position Detail Report .';
142: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,errbuf);
143: END IF;
144: IF (retcode <> 0 AND retcode = -1) THEN
145: --changed checkrun_name to checkrun_id
146: DELETE FROM fv_ap_cash_pos_temp

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

152: EXCEPTION
153: WHEN OTHERS THEN
154: retcode := 2;
155: errbuf := SQLERRM;
156: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
157: END MAIN;
158:
159: /********** **********/
160: /********** PROCEDURE: Initialize_Process **********/

Line 247: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,g_error_buf);

243:
244: IF l_record_count = 0 THEN
245: g_error_code := -1;
246: g_error_buf := 'No Invoices were selected for this Payment Batch.';
247: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,g_error_buf);
248: RETURN;
249: END IF;
250:
251: -- get the GL BALANCING and GL ACCOUNT segment numbers

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

276:
277: l_record_count := 0;
278: l_count := 0;
279:
280: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
281: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'The USSGL Accounts identified as Cash Accounts are :');
282: END IF;
283:
284:

Line 281: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'The USSGL Accounts identified as Cash Accounts are :');

277: l_record_count := 0;
278: l_count := 0;
279:
280: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
281: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'The USSGL Accounts identified as Cash Accounts are :');
282: END IF;
283:
284:
285: OPEN cash_position_accounts_cur ;

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

294: FETCH parent_child_rollups_cur INTO l_record_count;
295: CLOSE parent_child_rollups_cur;
296:
297: IF l_record_count = 1 THEN
298: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
299: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_cash_ussgl_acct);
300: END IF;
301: l_record_count := 2 ;
302: END IF;

Line 299: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_cash_ussgl_acct);

295: CLOSE parent_child_rollups_cur;
296:
297: IF l_record_count = 1 THEN
298: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
299: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_cash_ussgl_acct);
300: END IF;
301: l_record_count := 2 ;
302: END IF;
303: l_count := 1;

Line 312: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,g_error_buf);

308:
309: IF ( l_record_count = 0 ) THEN
310: g_error_code := -1;
311: g_error_buf := 'Please define US SGL Cash Position Accounts in General Ledger.';
312: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,g_error_buf);
313: RETURN;
314: END IF ;
315:
316: IF l_count = 0 THEN

Line 319: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,g_error_buf);

315:
316: IF l_count = 0 THEN
317: g_error_code := -1;
318: g_error_buf := 'Please define Cash Position Accounts in Define USSGL Accounts screen. ';
319: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,g_error_buf);
320: RETURN;
321: END IF ;
322:
323:

Line 329: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',g_error_buf);

325:
326: WHEN OTHERS THEN
327: g_error_code := -1;
328: g_error_buf := to_char(sqlcode) ||' '|| sqlerrm||' [Intialize Process]';
329: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',g_error_buf);
330: ROLLBACK;
331: RETURN;
332:
333: END Initialize_Process;

Line 466: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception2',g_error_buf);

462: EXCEPTION
463: WHEN OTHERS THEN
464: g_error_code := sqlcode ;
465: g_error_buf := sqlerrm || ' [CALC_BALANCE - Open Cursor] ' ;
466: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception2',g_error_buf);
467: RETURN;
468: END ;
469:
470: l_bal_select :=

Line 486: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Dynamic SQL Statement');

482: AND ffvh.child_flex_value_high
483: AND ffv.flex_value_set_id = :g_value_set_id AND ffv.flex_value_set_id = ffvh.flex_value_set_id'||
484: ' AND parent_flex_value = :l_cash_ussgl_acct)) AND GLB.period_year = :l_period_year AND GLB.period_num = :l_period_num AND GLB.LEDGER_ID = :g_set_of_books_id AND glb.currency_code = :l_currency_code';
485:
486: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Dynamic SQL Statement');
487: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_bal_select);
488: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_cash_ussgl_acct = ' || l_cash_ussgl_acct);
489: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_year = ' || l_period_year);
490: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_num = ' || l_period_num);

Line 487: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_bal_select);

483: AND ffv.flex_value_set_id = :g_value_set_id AND ffv.flex_value_set_id = ffvh.flex_value_set_id'||
484: ' AND parent_flex_value = :l_cash_ussgl_acct)) AND GLB.period_year = :l_period_year AND GLB.period_num = :l_period_num AND GLB.LEDGER_ID = :g_set_of_books_id AND glb.currency_code = :l_currency_code';
485:
486: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Dynamic SQL Statement');
487: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_bal_select);
488: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_cash_ussgl_acct = ' || l_cash_ussgl_acct);
489: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_year = ' || l_period_year);
490: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_num = ' || l_period_num);
491: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_set_of_books_id = ' || g_set_of_books_id);

Line 488: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_cash_ussgl_acct = ' || l_cash_ussgl_acct);

484: ' AND parent_flex_value = :l_cash_ussgl_acct)) AND GLB.period_year = :l_period_year AND GLB.period_num = :l_period_num AND GLB.LEDGER_ID = :g_set_of_books_id AND glb.currency_code = :l_currency_code';
485:
486: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Dynamic SQL Statement');
487: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_bal_select);
488: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_cash_ussgl_acct = ' || l_cash_ussgl_acct);
489: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_year = ' || l_period_year);
490: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_num = ' || l_period_num);
491: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_set_of_books_id = ' || g_set_of_books_id);
492: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_currency_code = ' || l_currency_code);

Line 489: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_year = ' || l_period_year);

485:
486: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Dynamic SQL Statement');
487: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_bal_select);
488: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_cash_ussgl_acct = ' || l_cash_ussgl_acct);
489: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_year = ' || l_period_year);
490: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_num = ' || l_period_num);
491: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_set_of_books_id = ' || g_set_of_books_id);
492: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_currency_code = ' || l_currency_code);
493: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_value_set_id = ' || g_value_set_id);

Line 490: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_num = ' || l_period_num);

486: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Dynamic SQL Statement');
487: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_bal_select);
488: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_cash_ussgl_acct = ' || l_cash_ussgl_acct);
489: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_year = ' || l_period_year);
490: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_num = ' || l_period_num);
491: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_set_of_books_id = ' || g_set_of_books_id);
492: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_currency_code = ' || l_currency_code);
493: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_value_set_id = ' || g_value_set_id);
494:

Line 491: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_set_of_books_id = ' || g_set_of_books_id);

487: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_bal_select);
488: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_cash_ussgl_acct = ' || l_cash_ussgl_acct);
489: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_year = ' || l_period_year);
490: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_num = ' || l_period_num);
491: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_set_of_books_id = ' || g_set_of_books_id);
492: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_currency_code = ' || l_currency_code);
493: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_value_set_id = ' || g_value_set_id);
494:
495:

Line 492: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_currency_code = ' || l_currency_code);

488: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_cash_ussgl_acct = ' || l_cash_ussgl_acct);
489: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_year = ' || l_period_year);
490: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_num = ' || l_period_num);
491: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_set_of_books_id = ' || g_set_of_books_id);
492: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_currency_code = ' || l_currency_code);
493: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_value_set_id = ' || g_value_set_id);
494:
495:
496:

Line 493: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_value_set_id = ' || g_value_set_id);

489: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_year = ' || l_period_year);
490: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_num = ' || l_period_num);
491: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_set_of_books_id = ' || g_set_of_books_id);
492: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_currency_code = ' || l_currency_code);
493: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_value_set_id = ' || g_value_set_id);
494:
495:
496:
497:

Line 516: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,g_error_buf);

512: EXCEPTION
513: WHEN OTHERS THEN
514: g_error_code := sqlcode ;
515: g_error_buf := sqlerrm || 'Create_cash_position - Execute Cursor]' ;
516: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,g_error_buf);
517: RETURN ;
518: END ;
519:
520: IF dbms_sql.fetch_rows(l_bal_cursor) = 0 THEN

Line 536: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception_A',g_error_buf);

532: EXCEPTION
533: WHEN OTHERS THEN
534: g_error_code := sqlcode ;
535: g_error_buf := sqlerrm ||' Create_cash_position - Close Cursor]' ;
536: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception_A',g_error_buf);
537: RETURN ;
538: END ;
539:
540: EXCEPTION

Line 544: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception_B',g_error_buf);

540: EXCEPTION
541: WHEN OTHERS THEN
542: g_error_code := sqlcode ;
543: g_error_buf := sqlerrm ||' Create_cash_position';
544: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception_B',g_error_buf);
545: RETURN ;
546: END ;
547: END LOOP;
548:

Line 596: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',g_error_buf);

592: EXCEPTION
593: WHEN invalid_segment THEN
594: g_error_code := -1;
595: g_error_buf := 'Unable to determine the segments [Create_Cash_Position_Record] ';
596: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',g_error_buf);
597: ROLLBACK;
598: RETURN;
599: WHEN OTHERS THEN
600: g_error_code := -1;

Line 602: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',g_error_buf);

598: RETURN;
599: WHEN OTHERS THEN
600: g_error_code := -1;
601: g_error_buf := to_char(sqlcode)||' '||sqlerrm||' [Create_Cash_Position_Record]';
602: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',g_error_buf);
603: ROLLBACK;
604: RETURN;
605: END Create_Cash_Position_Record;
606:

Line 693: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception1',g_error_buf);

689: EXCEPTION
690: WHEN invalid_segment THEN
691: g_error_code := -1;
692: g_error_buf := 'Unable to determine the Segment Information [get_segment_num]';
693: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception1',g_error_buf);
694: ROLLBACK;
695: RETURN;
696: WHEN OTHERS THEN
697: g_error_code := -1;

Line 699: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',g_error_buf);

695: RETURN;
696: WHEN OTHERS THEN
697: g_error_code := -1;
698: g_error_buf := to_char(sqlcode)||' '||sqlerrm||' [get_segment_num]';
699: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',g_error_buf);
700: ROLLBACK;
701: RETURN;
702: END get_segment_num;
703: Begin