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

Line 8: --===========================FND_LOG.START=====================================

4: g_cust_trx_id ra_customer_trx_all.customer_trx_id%type;
5: g_set_of_books_id ra_customer_trx_all.set_of_books_id%type;
6: g_receivables_ccid ra_cust_trx_line_gl_dist_all.code_combination_id%type;
7: g_run_id NUMBER;
8: --===========================FND_LOG.START=====================================
9: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
10: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
12: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 9: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;

5: g_set_of_books_id ra_customer_trx_all.set_of_books_id%type;
6: g_receivables_ccid ra_cust_trx_line_gl_dist_all.code_combination_id%type;
7: g_run_id NUMBER;
8: --===========================FND_LOG.START=====================================
9: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
10: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
12: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;

Line 10: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

6: g_receivables_ccid ra_cust_trx_line_gl_dist_all.code_combination_id%type;
7: g_run_id NUMBER;
8: --===========================FND_LOG.START=====================================
9: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
10: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
12: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
14: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 11: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;

7: g_run_id NUMBER;
8: --===========================FND_LOG.START=====================================
9: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
10: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
12: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
14: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFTXB.PSA_MFAR_TRANSACTIONS.';

Line 12: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

8: --===========================FND_LOG.START=====================================
9: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
10: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
12: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
14: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFTXB.PSA_MFAR_TRANSACTIONS.';
16: --===========================FND_LOG.END=======================================

Line 13: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;

9: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
10: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
12: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
14: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFTXB.PSA_MFAR_TRANSACTIONS.';
16: --===========================FND_LOG.END=======================================
17:

Line 14: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;

10: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
12: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
14: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFTXB.PSA_MFAR_TRANSACTIONS.';
16: --===========================FND_LOG.END=======================================
17:
18: --

Line 16: --===========================FND_LOG.END=======================================

12: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
14: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFTXB.PSA_MFAR_TRANSACTIONS.';
16: --===========================FND_LOG.END=======================================
17:
18: --
19: -- LOCAL PROCEDURES
20: --

Line 79: -- ========================= FND LOG ===========================

75:
76: -- EXCEPTION
77: FLEX_COMPARE_ERROR EXCEPTION;
78: generate_trx_dist_excep EXCEPTION;
79: -- ========================= FND LOG ===========================
80: l_full_path VARCHAR2(100) := g_path || 'create_distributions';
81: -- ========================= FND LOG ===========================
82: BEGIN
83:

Line 81: -- ========================= FND LOG ===========================

77: FLEX_COMPARE_ERROR EXCEPTION;
78: generate_trx_dist_excep EXCEPTION;
79: -- ========================= FND LOG ===========================
80: l_full_path VARCHAR2(100) := g_path || 'create_distributions';
81: -- ========================= FND LOG ===========================
82: BEGIN
83:
84: retcode := 'F';
85:

Line 86: -- ========================= FND LOG ===========================

82: BEGIN
83:
84: retcode := 'F';
85:
86: -- ========================= FND LOG ===========================
87: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
88: psa_utils.debug_other_string(g_state_level,l_full_path,' Create_distributions ');
89: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
90: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS : ');

Line 96: -- ========================= FND LOG ===========================

92: psa_utils.debug_other_string(g_state_level,l_full_path,' p_cust_trx_id -->' || p_cust_trx_id);
93: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id -->' || p_set_of_books_id);
94: psa_utils.debug_other_string(g_state_level,l_full_path,' p_run_id -->' || p_run_id);
95: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
96: -- ========================= FND LOG ===========================
97:
98: -- IF arp_global.sysparam.accounting_method = 'CASH' THEN
99:
100: -- retcode := 'S';

Line 113: -- ========================= FND LOG ===========================

109: g_cust_trx_id := p_cust_trx_id;
110: g_set_of_books_id := p_set_of_books_id;
111: g_run_id := p_run_id;
112:
113: -- ========================= FND LOG ===========================
114: psa_utils.debug_other_string(g_state_level,l_full_path,
115: ' Create_distribution --> Is transaction compelete ? ');
116: -- ========================= FND LOG ===========================
117:

Line 116: -- ========================= FND LOG ===========================

112:
113: -- ========================= FND LOG ===========================
114: psa_utils.debug_other_string(g_state_level,l_full_path,
115: ' Create_distribution --> Is transaction compelete ? ');
116: -- ========================= FND LOG ===========================
117:
118: IF (transaction_is_complete) THEN
119: -- ========================= FND LOG ===========================
120: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 119: -- ========================= FND LOG ===========================

115: ' Create_distribution --> Is transaction compelete ? ');
116: -- ========================= FND LOG ===========================
117:
118: IF (transaction_is_complete) THEN
119: -- ========================= FND LOG ===========================
120: psa_utils.debug_other_string(g_state_level,l_full_path,
121: ' Create_distribution --> Transaction is complete ');
122: -- ========================= FND LOG ===========================
123:

Line 122: -- ========================= FND LOG ===========================

118: IF (transaction_is_complete) THEN
119: -- ========================= FND LOG ===========================
120: psa_utils.debug_other_string(g_state_level,l_full_path,
121: ' Create_distribution --> Transaction is complete ');
122: -- ========================= FND LOG ===========================
123:
124: SELECT code_combination_id
125: INTO g_receivables_ccid
126: FROM ra_cust_trx_line_gl_dist_all

Line 131: -- ========================= FND LOG ===========================

127: WHERE customer_trx_id = g_cust_trx_id
128: AND account_class = 'REC'
129: AND account_set_flag = 'N';
130:
131: -- ========================= FND LOG ===========================
132: psa_utils.debug_other_string(g_state_level,l_full_path,
133: ' Create_distribution --> g_receivables_ccid --> ' || g_receivables_ccid);
134: -- ========================= FND LOG ===========================
135:

Line 134: -- ========================= FND LOG ===========================

130:
131: -- ========================= FND LOG ===========================
132: psa_utils.debug_other_string(g_state_level,l_full_path,
133: ' Create_distribution --> g_receivables_ccid --> ' || g_receivables_ccid);
134: -- ========================= FND LOG ===========================
135:
136: --
137: -- Check if distributions already created
138: --

Line 144: -- ========================= FND LOG ===========================

140: OPEN c_trx_dist;
141: FETCH c_trx_dist INTO l_trx_dist_rec;
142: CLOSE c_trx_dist;
143:
144: -- ========================= FND LOG ===========================
145: psa_utils.debug_other_string(g_state_level,l_full_path,
146: ' #cust_trx_line_gl_dist_id --> ' || l_trx_dist_rec.gl_dist_id
147: || ' #code_combination_id --> ' || l_trx_dist_rec.rev_ccid
148: || ' #mf_receivables_ccid --> ' || l_trx_dist_rec.mf_ccid

Line 150: -- ========================= FND LOG ===========================

146: ' #cust_trx_line_gl_dist_id --> ' || l_trx_dist_rec.gl_dist_id
147: || ' #code_combination_id --> ' || l_trx_dist_rec.rev_ccid
148: || ' #mf_receivables_ccid --> ' || l_trx_dist_rec.mf_ccid
149: || ' #prev_mf_receivables_ccid --> ' || l_trx_dist_rec.prev_mf_ccid);
150: -- ========================= FND LOG ===========================
151:
152: IF l_trx_dist_rec.gl_dist_id Is Not Null THEN -- Transaction Distributions already created
153: IF (transaction_modified) THEN
154:

Line 156: -- ========================= FND LOG ===========================

152: IF l_trx_dist_rec.gl_dist_id Is Not Null THEN -- Transaction Distributions already created
153: IF (transaction_modified) THEN
154:
155: IF NOT (GENERATE_TRX_DIST (l_errbuf, l_retcode, l_exception_error)) THEN
156: -- ========================= FND LOG ===========================
157: psa_utils.debug_other_string(g_state_level,l_full_path,
158: ' Create_distribution --> GENERATE_TRX_DIST -> FALSE');
159: -- ========================= FND LOG ===========================
160: RAISE generate_trx_dist_excep;

Line 159: -- ========================= FND LOG ===========================

155: IF NOT (GENERATE_TRX_DIST (l_errbuf, l_retcode, l_exception_error)) THEN
156: -- ========================= FND LOG ===========================
157: psa_utils.debug_other_string(g_state_level,l_full_path,
158: ' Create_distribution --> GENERATE_TRX_DIST -> FALSE');
159: -- ========================= FND LOG ===========================
160: RAISE generate_trx_dist_excep;
161: ELSE
162: -- ========================= FND LOG ===========================
163: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 162: -- ========================= FND LOG ===========================

158: ' Create_distribution --> GENERATE_TRX_DIST -> FALSE');
159: -- ========================= FND LOG ===========================
160: RAISE generate_trx_dist_excep;
161: ELSE
162: -- ========================= FND LOG ===========================
163: psa_utils.debug_other_string(g_state_level,l_full_path,
164: ' Create_distribution --> GENERATE_TRX_DIST -> TRUE');
165: -- ========================= FND LOG ===========================
166: END IF;

Line 165: -- ========================= FND LOG ===========================

161: ELSE
162: -- ========================= FND LOG ===========================
163: psa_utils.debug_other_string(g_state_level,l_full_path,
164: ' Create_distribution --> GENERATE_TRX_DIST -> TRUE');
165: -- ========================= FND LOG ===========================
166: END IF;
167:
168: ELSE
169:

Line 175: -- ========================= FND LOG ===========================

171: LOOP
172: FETCH c_trx_dist INTO l_trx_dist_rec;
173: EXIT WHEN c_trx_dist%NOTFOUND;
174:
175: -- ========================= FND LOG ===========================
176: psa_utils.debug_other_string(g_state_level,l_full_path,
177: ' Create_distribution --> calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS');
178: -- ========================= FND LOG ===========================
179:

Line 178: -- ========================= FND LOG ===========================

174:
175: -- ========================= FND LOG ===========================
176: psa_utils.debug_other_string(g_state_level,l_full_path,
177: ' Create_distribution --> calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS');
178: -- ========================= FND LOG ===========================
179:
180: IF NOT (PSA_MFAR_UTILS.OVERRIDE_SEGMENTS (
181: p_primary_ccid => g_receivables_ccid,
182: p_override_ccid => l_trx_dist_rec.rev_ccid,

Line 187: -- ========================= FND LOG ===========================

183: p_set_of_books_id => g_set_of_books_id,
184: p_trx_type => 'TRX',
185: p_ccid => l_temp_rec_ccid)) THEN
186:
187: -- ========================= FND LOG ===========================
188: psa_utils.debug_other_string(g_state_level,l_full_path,
189: ' Create_distribution --> Raising FLEX_COMPARE_ERROR ');
190: -- ========================= FND LOG ===========================
191: RAISE FLEX_COMPARE_ERROR;

Line 190: -- ========================= FND LOG ===========================

186:
187: -- ========================= FND LOG ===========================
188: psa_utils.debug_other_string(g_state_level,l_full_path,
189: ' Create_distribution --> Raising FLEX_COMPARE_ERROR ');
190: -- ========================= FND LOG ===========================
191: RAISE FLEX_COMPARE_ERROR;
192: END IF;
193:
194: IF NOT (l_temp_rec_ccid = l_trx_dist_rec.prev_mf_ccid) THEN

Line 197: -- ========================= FND LOG ===========================

193:
194: IF NOT (l_temp_rec_ccid = l_trx_dist_rec.prev_mf_ccid) THEN
195:
196: IF NOT (GENERATE_TRX_DIST (l_errbuf, l_retcode, l_exception_error)) THEN
197: -- ========================= FND LOG ===========================
198: psa_utils.debug_other_string(g_state_level,l_full_path,
199: ' Create_distribution --> GENERATE_TRX_DIST -> FALSE');
200: -- ========================= FND LOG ===========================
201: RAISE generate_trx_dist_excep;

Line 200: -- ========================= FND LOG ===========================

196: IF NOT (GENERATE_TRX_DIST (l_errbuf, l_retcode, l_exception_error)) THEN
197: -- ========================= FND LOG ===========================
198: psa_utils.debug_other_string(g_state_level,l_full_path,
199: ' Create_distribution --> GENERATE_TRX_DIST -> FALSE');
200: -- ========================= FND LOG ===========================
201: RAISE generate_trx_dist_excep;
202: ELSE
203: -- ========================= FND LOG ===========================
204: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 203: -- ========================= FND LOG ===========================

199: ' Create_distribution --> GENERATE_TRX_DIST -> FALSE');
200: -- ========================= FND LOG ===========================
201: RAISE generate_trx_dist_excep;
202: ELSE
203: -- ========================= FND LOG ===========================
204: psa_utils.debug_other_string(g_state_level,l_full_path,
205: ' Create_distribution --> GENERATE_TRX_DIST -> TRUE');
206: -- ========================= FND LOG ===========================
207: END IF;

Line 206: -- ========================= FND LOG ===========================

202: ELSE
203: -- ========================= FND LOG ===========================
204: psa_utils.debug_other_string(g_state_level,l_full_path,
205: ' Create_distribution --> GENERATE_TRX_DIST -> TRUE');
206: -- ========================= FND LOG ===========================
207: END IF;
208:
209: EXIT;
210: END IF;

Line 222: -- ========================= FND LOG ===========================

218: OPEN c_trx_type;
219: FETCH c_trx_type INTO l_trx_type;
220: CLOSE c_trx_type;
221:
222: -- ========================= FND LOG ===========================
223: psa_utils.debug_other_string(g_state_level,l_full_path,
224: ' Create_distribution --> Else part --> Type - Invoice OR DM');
225: -- ========================= FND LOG ===========================
226:

Line 225: -- ========================= FND LOG ===========================

221:
222: -- ========================= FND LOG ===========================
223: psa_utils.debug_other_string(g_state_level,l_full_path,
224: ' Create_distribution --> Else part --> Type - Invoice OR DM');
225: -- ========================= FND LOG ===========================
226:
227: IF l_trx_type.row_id Is Not Null THEN -- Transaction is an invoice or a debit memo
228: IF NOT (GENERATE_TRX_DIST (l_errbuf, l_retcode, l_exception_error)) THEN
229: -- ========================= FND LOG ===========================

Line 229: -- ========================= FND LOG ===========================

225: -- ========================= FND LOG ===========================
226:
227: IF l_trx_type.row_id Is Not Null THEN -- Transaction is an invoice or a debit memo
228: IF NOT (GENERATE_TRX_DIST (l_errbuf, l_retcode, l_exception_error)) THEN
229: -- ========================= FND LOG ===========================
230: psa_utils.debug_other_string(g_state_level,l_full_path,
231: ' Create_distribution --> GENERATE_TRX_DIST -> FALSE');
232: -- ========================= FND LOG ===========================
233: RAISE generate_trx_dist_excep;

Line 232: -- ========================= FND LOG ===========================

228: IF NOT (GENERATE_TRX_DIST (l_errbuf, l_retcode, l_exception_error)) THEN
229: -- ========================= FND LOG ===========================
230: psa_utils.debug_other_string(g_state_level,l_full_path,
231: ' Create_distribution --> GENERATE_TRX_DIST -> FALSE');
232: -- ========================= FND LOG ===========================
233: RAISE generate_trx_dist_excep;
234: ELSE
235: -- ========================= FND LOG ===========================
236: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 235: -- ========================= FND LOG ===========================

231: ' Create_distribution --> GENERATE_TRX_DIST -> FALSE');
232: -- ========================= FND LOG ===========================
233: RAISE generate_trx_dist_excep;
234: ELSE
235: -- ========================= FND LOG ===========================
236: psa_utils.debug_other_string(g_state_level,l_full_path,
237: ' Create_distribution --> GENERATE_TRX_DIST -> TRUE');
238: -- ========================= FND LOG ===========================
239: END IF;

Line 238: -- ========================= FND LOG ===========================

234: ELSE
235: -- ========================= FND LOG ===========================
236: psa_utils.debug_other_string(g_state_level,l_full_path,
237: ' Create_distribution --> GENERATE_TRX_DIST -> TRUE');
238: -- ========================= FND LOG ===========================
239: END IF;
240: END IF;
241:
242: END IF;

Line 254: -- ========================= FND LOG ===========================

250: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'TRANSACTION',
251: g_cust_trx_id, Null, l_exception_error);
252: p_error_message := l_exception_error;
253: retcode := 'F';
254: -- ========================= FND LOG ===========================
255: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
256: -- ========================= FND LOG ===========================
257: RETURN FALSE;
258:

Line 256: -- ========================= FND LOG ===========================

252: p_error_message := l_exception_error;
253: retcode := 'F';
254: -- ========================= FND LOG ===========================
255: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
256: -- ========================= FND LOG ===========================
257: RETURN FALSE;
258:
259: WHEN FLEX_COMPARE_ERROR THEN
260: l_exception_error := 'EXCEPTION - FLEX_COMPARE_ERROR PACKAGE - PSA_MFAR_TRANSACTIONS.CREATE_DISTRIBUTIONS: '||FND_MESSAGE.GET;

Line 266: -- ========================= FND LOG ===========================

262: g_cust_trx_id, Null, l_exception_error);
263:
264: p_error_message := l_exception_error;
265: retcode := 'F';
266: -- ========================= FND LOG ===========================
267: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
268: -- ========================= FND LOG ===========================
269: RETURN FALSE;
270:

Line 268: -- ========================= FND LOG ===========================

264: p_error_message := l_exception_error;
265: retcode := 'F';
266: -- ========================= FND LOG ===========================
267: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
268: -- ========================= FND LOG ===========================
269: RETURN FALSE;
270:
271: WHEN OTHERS THEN
272: l_exception_error := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_TRANSACTIONS.CREATE_DISTRIBUTIONS: '

Line 279: -- ========================= FND LOG ===========================

275: g_cust_trx_id, Null, l_exception_error);
276:
277: retcode := 'F';
278: p_error_message := l_exception_error;
279: -- ========================= FND LOG ===========================
280: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
281: psa_utils.debug_unexpected_msg(l_full_path);
282: -- ========================= FND LOG ===========================
283: RETURN FALSE;

Line 282: -- ========================= FND LOG ===========================

278: p_error_message := l_exception_error;
279: -- ========================= FND LOG ===========================
280: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
281: psa_utils.debug_unexpected_msg(l_full_path);
282: -- ========================= FND LOG ===========================
283: RETURN FALSE;
284:
285: END create_distributions;
286:

Line 318: -- ========================= FND LOG ===========================

314: l_revenue_ccid ra_cust_trx_line_gl_dist_all.code_combination_id%type;
315: l_ccid ra_cust_trx_line_gl_dist_all.code_combination_id%type;
316: l_trx_gl_dist_rec c_trx_gl_dist%rowtype;
317: l_rowid ROWID;
318: -- ========================= FND LOG ===========================
319: l_full_path VARCHAR2(100) := g_path || 'generate_trx_dist';
320: -- ========================= FND LOG ===========================
321:
322: -- EXCEPTION

Line 320: -- ========================= FND LOG ===========================

316: l_trx_gl_dist_rec c_trx_gl_dist%rowtype;
317: l_rowid ROWID;
318: -- ========================= FND LOG ===========================
319: l_full_path VARCHAR2(100) := g_path || 'generate_trx_dist';
320: -- ========================= FND LOG ===========================
321:
322: -- EXCEPTION
323:
324: l_exception_error VARCHAR2(2000);

Line 339: -- ========================= FND LOG ===========================

335: FROM ra_cust_trx_line_gl_dist_all
336: WHERE customer_trx_id = g_cust_trx_id)
337: AND posting_control_id IS NULL;
338:
339: -- ========================= FND LOG ===========================
340: psa_utils.debug_other_string(g_state_level,l_full_path,
341: ' Generate_trx_dist --> delete from psa_mf_trx_dist_all -->'
342: || SQL%ROWCOUNT);
343: -- ========================= FND LOG ===========================

Line 343: -- ========================= FND LOG ===========================

339: -- ========================= FND LOG ===========================
340: psa_utils.debug_other_string(g_state_level,l_full_path,
341: ' Generate_trx_dist --> delete from psa_mf_trx_dist_all -->'
342: || SQL%ROWCOUNT);
343: -- ========================= FND LOG ===========================
344:
345: --
346: -- Get revenue/tax/freight ccid's and create
347: -- corresponding receivable ccid

Line 362: -- ========================= FND LOG ===========================

358: --
359: -- Retrieve/Generate receivable ccid
360: --
361:
362: -- ========================= FND LOG ===========================
363: psa_utils.debug_other_string(g_state_level,l_full_path,
364: ' Generate_trx_dist --> psa_mfar_utils.override_segments : ');
365: psa_utils.debug_other_string(g_state_level,l_full_path,
366: ' Generate_trx_dist --> g_receivables_ccid --> '

Line 377: -- ========================= FND LOG ===========================

373: psa_utils.debug_other_string(g_state_level,l_full_path,
374: ' Generate_trx_dist --> transaction type --> ' || 'TRX');
375: psa_utils.debug_other_string(g_state_level,l_full_path,
376: ' Generate_trx_dist --> l_ccid --> ' || l_ccid);
377: -- ========================= FND LOG ===========================
378:
379:
380: IF NOT (PSA_MFAR_UTILS.OVERRIDE_SEGMENTS (g_receivables_ccid,
381: l_revenue_ccid,

Line 386: -- ========================= FND LOG ===========================

382: g_set_of_books_id,
383: 'TRX',
384: l_ccid)) THEN
385:
386: -- ========================= FND LOG ===========================
387: psa_utils.debug_other_string(g_state_level,l_full_path,
388: ' Generate_trx_dist --> PSA_MFAR_UTILS.OVERRIDE_SEGMENTS --> FALSE');
389: -- ========================= FND LOG ===========================
390: RAISE FLEX_BUILD_ERROR;

Line 389: -- ========================= FND LOG ===========================

385:
386: -- ========================= FND LOG ===========================
387: psa_utils.debug_other_string(g_state_level,l_full_path,
388: ' Generate_trx_dist --> PSA_MFAR_UTILS.OVERRIDE_SEGMENTS --> FALSE');
389: -- ========================= FND LOG ===========================
390: RAISE FLEX_BUILD_ERROR;
391: END IF;
392:
393: --

Line 404: -- ========================= FND LOG ===========================

400: X_RECEIVABLES_CCID => l_ccid,
401: X_PREV_MF_RECEIVABLES_CCID => l_ccid,
402: X_MODE => 'R');
403:
404: -- ========================= FND LOG ===========================
405: psa_utils.debug_other_string(g_state_level,l_full_path,
406: ' Generate_trx_dist --> PSA_MFAR_TRANSACTION_COVER_PKG.INSERT_ROW ');
407: -- ========================= FND LOG ===========================
408:

Line 407: -- ========================= FND LOG ===========================

403:
404: -- ========================= FND LOG ===========================
405: psa_utils.debug_other_string(g_state_level,l_full_path,
406: ' Generate_trx_dist --> PSA_MFAR_TRANSACTION_COVER_PKG.INSERT_ROW ');
407: -- ========================= FND LOG ===========================
408:
409: END LOOP;
410: CLOSE c_trx_gl_dist;
411: retcode := 'S';

Line 420: -- ========================= FND LOG ===========================

416: p_error_message := 'EXCEPTION - FLEX_BUILD_ERROR PACKAGE - PSA_MFAR_TRANSACTIONS.GENERATE_TRX_DIST: '||FND_MESSAGE.GET;
417: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'TRANSACTION',
418: g_cust_trx_id, Null, p_error_message);
419: retcode := 'F';
420: -- ========================= FND LOG ===========================
421: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
422: -- ========================= FND LOG ===========================
423: RETURN FALSE;
424:

Line 422: -- ========================= FND LOG ===========================

418: g_cust_trx_id, Null, p_error_message);
419: retcode := 'F';
420: -- ========================= FND LOG ===========================
421: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
422: -- ========================= FND LOG ===========================
423: RETURN FALSE;
424:
425: WHEN OTHERS THEN
426: p_error_message := 'EXCEPTION - WHEN OTHERS - PSA_MFAR_TRANSACTIONS.GENERATE_TRX_DIST: '|| SQLERRM;

Line 430: -- ========================= FND LOG ===========================

426: p_error_message := 'EXCEPTION - WHEN OTHERS - PSA_MFAR_TRANSACTIONS.GENERATE_TRX_DIST: '|| SQLERRM;
427: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'TRANSACTION',
428: g_cust_trx_id, Null, p_error_message);
429: retcode := 'F';
430: -- ========================= FND LOG ===========================
431: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
432: psa_utils.debug_unexpected_msg(l_full_path);
433: -- ========================= FND LOG ===========================
434: RETURN FALSE;

Line 433: -- ========================= FND LOG ===========================

429: retcode := 'F';
430: -- ========================= FND LOG ===========================
431: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
432: psa_utils.debug_unexpected_msg(l_full_path);
433: -- ========================= FND LOG ===========================
434: RETURN FALSE;
435:
436: END generate_trx_dist;
437:

Line 449: -- ========================= FND LOG ===========================

445: FROM ra_customer_trx_all
446: WHERE customer_trx_id = g_cust_trx_id;
447:
448: l_trx_complete_rec c_trx_complete%rowtype;
449: -- ========================= FND LOG ===========================
450: l_full_path VARCHAR2(100) := g_path || 'transaction_is_complete';
451: -- ========================= FND LOG ===========================
452:
453: BEGIN

Line 451: -- ========================= FND LOG ===========================

447:
448: l_trx_complete_rec c_trx_complete%rowtype;
449: -- ========================= FND LOG ===========================
450: l_full_path VARCHAR2(100) := g_path || 'transaction_is_complete';
451: -- ========================= FND LOG ===========================
452:
453: BEGIN
454:
455: OPEN c_trx_complete;

Line 460: -- ========================= FND LOG ===========================

456: FETCH c_trx_complete INTO l_trx_complete_rec;
457: CLOSE c_trx_complete;
458:
459: IF l_trx_complete_rec.complete_flag = 'Y' THEN
460: -- ========================= FND LOG ===========================
461: psa_utils.debug_other_string(g_state_level,l_full_path,' Transaction_is_complete --> return TRUE');
462: -- ========================= FND LOG ===========================
463: RETURN TRUE;
464: ELSE

Line 462: -- ========================= FND LOG ===========================

458:
459: IF l_trx_complete_rec.complete_flag = 'Y' THEN
460: -- ========================= FND LOG ===========================
461: psa_utils.debug_other_string(g_state_level,l_full_path,' Transaction_is_complete --> return TRUE');
462: -- ========================= FND LOG ===========================
463: RETURN TRUE;
464: ELSE
465: -- ========================= FND LOG ===========================
466: psa_utils.debug_other_string(g_state_level,l_full_path,' Transaction_is_complete --> return FALSE');

Line 465: -- ========================= FND LOG ===========================

461: psa_utils.debug_other_string(g_state_level,l_full_path,' Transaction_is_complete --> return TRUE');
462: -- ========================= FND LOG ===========================
463: RETURN TRUE;
464: ELSE
465: -- ========================= FND LOG ===========================
466: psa_utils.debug_other_string(g_state_level,l_full_path,' Transaction_is_complete --> return FALSE');
467: -- ========================= FND LOG ===========================
468: RETURN FALSE;
469: END IF;

Line 467: -- ========================= FND LOG ===========================

463: RETURN TRUE;
464: ELSE
465: -- ========================= FND LOG ===========================
466: psa_utils.debug_other_string(g_state_level,l_full_path,' Transaction_is_complete --> return FALSE');
467: -- ========================= FND LOG ===========================
468: RETURN FALSE;
469: END IF;
470:
471: EXCEPTION

Line 477: -- ========================= FND LOG ===========================

473: l_exception_error := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_TRANSACTIONS.TRANSACTION_IS_COMPLETE: '
474: || SQLERRM;
475: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'TRANSACTION', g_cust_trx_id, Null,
476: l_exception_error);
477: -- ========================= FND LOG ===========================
478: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_error);
479: psa_utils.debug_unexpected_msg(l_full_path);
480: -- ========================= FND LOG ===========================
481: RETURN FALSE;

Line 480: -- ========================= FND LOG ===========================

476: l_exception_error);
477: -- ========================= FND LOG ===========================
478: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_error);
479: psa_utils.debug_unexpected_msg(l_full_path);
480: -- ========================= FND LOG ===========================
481: RETURN FALSE;
482:
483: END transaction_is_complete;
484:

Line 504: -- ========================= FND LOG ===========================

500: AND A.customer_trx_id = g_cust_trx_id;
501:
502: l_core_count NUMBER;
503: l_mf_dist_count NUMBER;
504: -- ========================= FND LOG ===========================
505: l_full_path VARCHAR2(100) := g_path || 'transaction_modified';
506: -- ========================= FND LOG ===========================
507: BEGIN
508: OPEN c_core_trx_count;

Line 506: -- ========================= FND LOG ===========================

502: l_core_count NUMBER;
503: l_mf_dist_count NUMBER;
504: -- ========================= FND LOG ===========================
505: l_full_path VARCHAR2(100) := g_path || 'transaction_modified';
506: -- ========================= FND LOG ===========================
507: BEGIN
508: OPEN c_core_trx_count;
509: FETCH c_core_trx_count INTO l_core_count;
510: CLOSE c_core_trx_count;

Line 512: -- ========================= FND LOG ===========================

508: OPEN c_core_trx_count;
509: FETCH c_core_trx_count INTO l_core_count;
510: CLOSE c_core_trx_count;
511:
512: -- ========================= FND LOG ===========================
513: psa_utils.debug_other_string(g_state_level,l_full_path,
514: ' Transaction_modified --> l_core_count --> ' || l_core_count);
515: -- ========================= FND LOG ===========================
516:

Line 515: -- ========================= FND LOG ===========================

511:
512: -- ========================= FND LOG ===========================
513: psa_utils.debug_other_string(g_state_level,l_full_path,
514: ' Transaction_modified --> l_core_count --> ' || l_core_count);
515: -- ========================= FND LOG ===========================
516:
517: OPEN c_mf_trx_count;
518: FETCH c_mf_trx_count INTO l_mf_dist_count;
519: CLOSE c_mf_trx_count;

Line 521: -- ========================= FND LOG ===========================

517: OPEN c_mf_trx_count;
518: FETCH c_mf_trx_count INTO l_mf_dist_count;
519: CLOSE c_mf_trx_count;
520:
521: -- ========================= FND LOG ===========================
522: psa_utils.debug_other_string(g_state_level,l_full_path,
523: ' Transaction_modified --> l_mf_dist_count --> ' || l_mf_dist_count);
524: -- ========================= FND LOG ===========================
525:

Line 524: -- ========================= FND LOG ===========================

520:
521: -- ========================= FND LOG ===========================
522: psa_utils.debug_other_string(g_state_level,l_full_path,
523: ' Transaction_modified --> l_mf_dist_count --> ' || l_mf_dist_count);
524: -- ========================= FND LOG ===========================
525:
526: -- Bug 3671841, Delete statement commented and now placed in PSAMFG2B.pls
527: /*
528: DELETE FROM psa_mf_trx_dist_all

Line 533: -- ========================= FND LOG ===========================

529: WHERE cust_trx_line_gl_dist_id Not In
530: ( SELECT cust_trx_line_gl_dist_id FROM ra_cust_trx_line_gl_dist_all );
531: */
532:
533: -- ========================= FND LOG ===========================
534: psa_utils.debug_other_string(g_state_level,l_full_path,
535: ' Transaction_modified --> delete psa_mf_trx_dist_all --> '
536: || SQL%ROWCOUNT);
537: -- ========================= FND LOG ===========================

Line 537: -- ========================= FND LOG ===========================

533: -- ========================= FND LOG ===========================
534: psa_utils.debug_other_string(g_state_level,l_full_path,
535: ' Transaction_modified --> delete psa_mf_trx_dist_all --> '
536: || SQL%ROWCOUNT);
537: -- ========================= FND LOG ===========================
538:
539: IF l_core_count <> l_mf_dist_count THEN
540: RETURN TRUE;
541: ELSE

Line 551: -- ========================= FND LOG ===========================

547: l_exception_error := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_TRANSACTIONS.TRANSACTION_MODIFIED: '
548: || SQLERRM;
549: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'TRANSACTION',
550: g_cust_trx_id, Null,l_exception_error);
551: -- ========================= FND LOG ===========================
552: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_error);
553: psa_utils.debug_unexpected_msg(l_full_path);
554: -- ========================= FND LOG ===========================
555: RETURN FALSE;

Line 554: -- ========================= FND LOG ===========================

550: g_cust_trx_id, Null,l_exception_error);
551: -- ========================= FND LOG ===========================
552: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_error);
553: psa_utils.debug_unexpected_msg(l_full_path);
554: -- ========================= FND LOG ===========================
555: RETURN FALSE;
556:
557: END transaction_modified;
558: