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_MF_CREATE_DISTRIBUTIONS dependencies on PSA_UTILS

Line 84: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Create_distribution ');

80: l_set_of_books_id := p_set_of_books_id;
81: FND_PROFILE.GET ('ORG_ID', l_org_id);
82:
83: -- ========================= FND LOG ===========================
84: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Create_distribution ');
85: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS ');
86: psa_utils.debug_other_string(g_state_level,l_full_path,' ========== ');
87: psa_utils.debug_other_string(g_state_level,l_full_path,' p_mode --> ' || p_mode);
88: psa_utils.debug_other_string(g_state_level,l_full_path,' p_document_id --> ' || p_document_id);

Line 85: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS ');

81: FND_PROFILE.GET ('ORG_ID', l_org_id);
82:
83: -- ========================= FND LOG ===========================
84: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Create_distribution ');
85: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS ');
86: psa_utils.debug_other_string(g_state_level,l_full_path,' ========== ');
87: psa_utils.debug_other_string(g_state_level,l_full_path,' p_mode --> ' || p_mode);
88: psa_utils.debug_other_string(g_state_level,l_full_path,' p_document_id --> ' || p_document_id);
89: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id --> ' || p_set_of_books_id);

Line 86: psa_utils.debug_other_string(g_state_level,l_full_path,' ========== ');

82:
83: -- ========================= FND LOG ===========================
84: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Create_distribution ');
85: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS ');
86: psa_utils.debug_other_string(g_state_level,l_full_path,' ========== ');
87: psa_utils.debug_other_string(g_state_level,l_full_path,' p_mode --> ' || p_mode);
88: psa_utils.debug_other_string(g_state_level,l_full_path,' p_document_id --> ' || p_document_id);
89: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id --> ' || p_set_of_books_id);
90: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_id --> ' || l_org_id);

Line 87: psa_utils.debug_other_string(g_state_level,l_full_path,' p_mode --> ' || p_mode);

83: -- ========================= FND LOG ===========================
84: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Create_distribution ');
85: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS ');
86: psa_utils.debug_other_string(g_state_level,l_full_path,' ========== ');
87: psa_utils.debug_other_string(g_state_level,l_full_path,' p_mode --> ' || p_mode);
88: psa_utils.debug_other_string(g_state_level,l_full_path,' p_document_id --> ' || p_document_id);
89: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id --> ' || p_set_of_books_id);
90: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_id --> ' || l_org_id);
91: psa_utils.debug_other_string(g_state_level,l_full_path,' p_report_only --> ' || p_report_only );

Line 88: psa_utils.debug_other_string(g_state_level,l_full_path,' p_document_id --> ' || p_document_id);

84: psa_utils.debug_other_string(g_state_level,l_full_path,' Inside Create_distribution ');
85: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS ');
86: psa_utils.debug_other_string(g_state_level,l_full_path,' ========== ');
87: psa_utils.debug_other_string(g_state_level,l_full_path,' p_mode --> ' || p_mode);
88: psa_utils.debug_other_string(g_state_level,l_full_path,' p_document_id --> ' || p_document_id);
89: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id --> ' || p_set_of_books_id);
90: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_id --> ' || l_org_id);
91: psa_utils.debug_other_string(g_state_level,l_full_path,' p_report_only --> ' || p_report_only );
92: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

Line 89: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id --> ' || p_set_of_books_id);

85: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS ');
86: psa_utils.debug_other_string(g_state_level,l_full_path,' ========== ');
87: psa_utils.debug_other_string(g_state_level,l_full_path,' p_mode --> ' || p_mode);
88: psa_utils.debug_other_string(g_state_level,l_full_path,' p_document_id --> ' || p_document_id);
89: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id --> ' || p_set_of_books_id);
90: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_id --> ' || l_org_id);
91: psa_utils.debug_other_string(g_state_level,l_full_path,' p_report_only --> ' || p_report_only );
92: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
93: -- ========================= FND LOG ===========================

Line 90: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_id --> ' || l_org_id);

86: psa_utils.debug_other_string(g_state_level,l_full_path,' ========== ');
87: psa_utils.debug_other_string(g_state_level,l_full_path,' p_mode --> ' || p_mode);
88: psa_utils.debug_other_string(g_state_level,l_full_path,' p_document_id --> ' || p_document_id);
89: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id --> ' || p_set_of_books_id);
90: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_id --> ' || l_org_id);
91: psa_utils.debug_other_string(g_state_level,l_full_path,' p_report_only --> ' || p_report_only );
92: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
93: -- ========================= FND LOG ===========================
94:

Line 91: psa_utils.debug_other_string(g_state_level,l_full_path,' p_report_only --> ' || p_report_only );

87: psa_utils.debug_other_string(g_state_level,l_full_path,' p_mode --> ' || p_mode);
88: psa_utils.debug_other_string(g_state_level,l_full_path,' p_document_id --> ' || p_document_id);
89: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id --> ' || p_set_of_books_id);
90: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_id --> ' || l_org_id);
91: psa_utils.debug_other_string(g_state_level,l_full_path,' p_report_only --> ' || p_report_only );
92: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
93: -- ========================= FND LOG ===========================
94:
95: /* checking whether MFAR is available */

Line 92: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

88: psa_utils.debug_other_string(g_state_level,l_full_path,' p_document_id --> ' || p_document_id);
89: psa_utils.debug_other_string(g_state_level,l_full_path,' p_set_of_books_id --> ' || p_set_of_books_id);
90: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_id --> ' || l_org_id);
91: psa_utils.debug_other_string(g_state_level,l_full_path,' p_report_only --> ' || p_report_only );
92: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
93: -- ========================= FND LOG ===========================
94:
95: /* checking whether MFAR is available */
96: IF (NOT (PSA_IMPLEMENTATION.GET (l_org_id, 'MFAR', l_mfar_implemented)) OR

Line 99: psa_utils.debug_other_string(g_error_level,l_full_path,

95: /* checking whether MFAR is available */
96: IF (NOT (PSA_IMPLEMENTATION.GET (l_org_id, 'MFAR', l_mfar_implemented)) OR
97: (l_mfar_implemented <> 'Y')) THEN
98: -- ========================= FND LOG ===========================
99: psa_utils.debug_other_string(g_error_level,l_full_path,
100: ' MFAR not implemented !');
101: -- ========================= FND LOG ===========================
102: RAISE MFAR_NOT_IMPLEMENTED ;
103: ELSE

Line 105: psa_utils.debug_other_string(g_state_level,l_full_path,' MFAR is implemented ');

101: -- ========================= FND LOG ===========================
102: RAISE MFAR_NOT_IMPLEMENTED ;
103: ELSE
104: -- ========================= FND LOG ===========================
105: psa_utils.debug_other_string(g_state_level,l_full_path,' MFAR is implemented ');
106: -- ========================= FND LOG ===========================
107: END IF;
108:
109:

Line 116: psa_utils.debug_other_string(g_state_level,l_full_path,

112: SELECT psa_mf_error_log_s.NEXTVAL INTO run_num
113: FROM sys.dual;
114:
115: -- ========================= FND LOG ===========================
116: psa_utils.debug_other_string(g_state_level,l_full_path,
117: ' Sequence number -> ' || run_num);
118: -- ========================= FND LOG ===========================
119:
120: EXCEPTION

Line 127: psa_utils.debug_other_msg(g_excep_level,l_full_path,FALSE);

123: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',
124: 'PSA_MF_CREATE_DISTRIBUTIONS - '
125: || 'Cannot create run number');
126: -- ========================= FND LOG ===========================
127: psa_utils.debug_other_msg(g_excep_level,l_full_path,FALSE);
128: -- ========================= FND LOG ===========================
129: p_error_message := FND_MESSAGE.GET;
130: -- ========================= FND LOG ===========================
131: psa_utils.debug_other_string(g_excep_level,l_full_path,

Line 131: psa_utils.debug_other_string(g_excep_level,l_full_path,

127: psa_utils.debug_other_msg(g_excep_level,l_full_path,FALSE);
128: -- ========================= FND LOG ===========================
129: p_error_message := FND_MESSAGE.GET;
130: -- ========================= FND LOG ===========================
131: psa_utils.debug_other_string(g_excep_level,l_full_path,
132: ' PSAMFCRB: ' || p_error_message);
133: psa_utils.debug_other_string(g_excep_level,l_full_path,
134: ' PSAMFCRB: ' || sqlcode || sqlerrm);
135: -- ========================= FND LOG ===========================

Line 133: psa_utils.debug_other_string(g_excep_level,l_full_path,

129: p_error_message := FND_MESSAGE.GET;
130: -- ========================= FND LOG ===========================
131: psa_utils.debug_other_string(g_excep_level,l_full_path,
132: ' PSAMFCRB: ' || p_error_message);
133: psa_utils.debug_other_string(g_excep_level,l_full_path,
134: ' PSAMFCRB: ' || sqlcode || sqlerrm);
135: -- ========================= FND LOG ===========================
136: RETURN FALSE;
137: END;

Line 141: psa_utils.debug_other_string(g_state_level,l_full_path,

137: END;
138:
139: IF p_mode IN ('A','T') THEN
140: -- ========================= FND LOG ===========================
141: psa_utils.debug_other_string(g_state_level,l_full_path,
142: ' p_mode in A or T');
143: -- ========================= FND LOG ===========================
144:
145: FOR a_row IN a(p_document_id)

Line 148: psa_utils.debug_other_string(g_state_level,l_full_path,

144:
145: FOR a_row IN a(p_document_id)
146: LOOP
147: -- ========================= FND LOG ===========================
148: psa_utils.debug_other_string(g_state_level,l_full_path,
149: ' Customer trx id --> ' || a_row.customer_trx_id);
150: psa_utils.debug_other_string(g_state_level,l_full_path,
151: ' CAlling PSA_MFAR_VAL_PKG.ar_mfar_validate_check');
152: -- ========================= FND LOG ===========================

Line 150: psa_utils.debug_other_string(g_state_level,l_full_path,

146: LOOP
147: -- ========================= FND LOG ===========================
148: psa_utils.debug_other_string(g_state_level,l_full_path,
149: ' Customer trx id --> ' || a_row.customer_trx_id);
150: psa_utils.debug_other_string(g_state_level,l_full_path,
151: ' CAlling PSA_MFAR_VAL_PKG.ar_mfar_validate_check');
152: -- ========================= FND LOG ===========================
153:
154: IF PSA_MFAR_VAL_PKG.ar_mfar_validate_check

Line 158: psa_utils.debug_other_string(g_state_level,l_full_path,

154: IF PSA_MFAR_VAL_PKG.ar_mfar_validate_check
155: (a_row.customer_trx_id,'TRX', p_set_of_books_id) = 'Y' THEN
156:
157: -- ========================= FND LOG ===========================
158: psa_utils.debug_other_string(g_state_level,l_full_path,
159: ' calling PSA_MFAR_TRANSACTIONS.create_distributions ');
160: -- ========================= FND LOG ===========================
161:
162: IF NOT (PSA_MFAR_TRANSACTIONS.create_distributions (errbuf => errbuf,

Line 170: psa_utils.debug_other_string(g_error_level,l_full_path,

166: p_run_id => run_num,
167: p_error_message => p_error_message)) THEN
168:
169: -- ========================= FND LOG ===========================
170: psa_utils.debug_other_string(g_error_level,l_full_path,
171: ' PSA_MFAR_TRANSACTIONS.create_distributions --> FALSE ');
172: -- ========================= FND LOG ===========================
173:
174: IF p_error_message IS NOT NULL OR retcode = 'F' THEN

Line 176: psa_utils.debug_other_string(g_error_level,l_full_path,

172: -- ========================= FND LOG ===========================
173:
174: IF p_error_message IS NOT NULL OR retcode = 'F' THEN
175: -- ========================= FND LOG ===========================
176: psa_utils.debug_other_string(g_error_level,l_full_path,
177: ' Error Message --> '
178: || p_error_message);
179: -- ========================= FND LOG ===========================
180:

Line 183: psa_utils.debug_other_string(g_error_level,l_full_path,

179: -- ========================= FND LOG ===========================
180:
181: IF NVL(p_report_only,'N') = 'N' THEN
182: -- ========================= FND LOG ===========================
183: psa_utils.debug_other_string(g_error_level,l_full_path,
184: ' p_report_only --> N : ' ||
185: ' This is not for reporting purpose so end processing. ');
186: -- ========================= FND LOG ===========================
187: Raise MFAR_DIST_EXCEP ;

Line 193: psa_utils.debug_other_string(g_state_level,l_full_path,

189: END IF;
190:
191: ELSE
192: -- ========================= FND LOG ===========================
193: psa_utils.debug_other_string(g_state_level,l_full_path,
194: ' PSA_MFAR_TRANSACTIONS.create_distributions --> ' || a_row.customer_trx_id);
195: -- ========================= FND LOG ===========================
196: END IF;
197:

Line 202: psa_utils.debug_other_string(g_state_level,l_full_path,

198: /* RECEIPTS */
199: FOR b_row IN b(a_row.customer_trx_id)
200: LOOP
201: -- ========================= FND LOG ===========================
202: psa_utils.debug_other_string(g_state_level,l_full_path,
203: ' calling PSA_MFAR_RECEIPTS.create_distributions '
204: || ' -- ' || b_row.receivable_application_id);
205: -- ========================= FND LOG ===========================
206:

Line 215: psa_utils.debug_other_string(g_state_level,l_full_path,

211: p_run_id => run_num,
212: p_error_message => p_error_message)) THEN
213:
214: -- ========================= FND LOG ===========================
215: psa_utils.debug_other_string(g_state_level,l_full_path,
216: ' PSA_MFAR_RECEIPTS.create_distributions --> FALSE ');
217: -- ========================= FND LOG ===========================
218:
219: IF p_error_message IS NOT NULL OR retcode = 'F' THEN

Line 221: psa_utils.debug_other_string(g_excep_level,l_full_path,

217: -- ========================= FND LOG ===========================
218:
219: IF p_error_message IS NOT NULL OR retcode = 'F' THEN
220: -- ========================= FND LOG ===========================
221: psa_utils.debug_other_string(g_excep_level,l_full_path,
222: ' Error Message --> '|| p_error_message);
223: -- ========================= FND LOG ===========================
224:
225: IF NVL(p_report_only,'N') = 'N' THEN

Line 227: psa_utils.debug_other_string(g_excep_level,l_full_path,

223: -- ========================= FND LOG ===========================
224:
225: IF NVL(p_report_only,'N') = 'N' THEN
226: -- ========================= FND LOG ===========================
227: psa_utils.debug_other_string(g_excep_level,l_full_path,
228: ' p_report_only --> : This is not for reporting purpose so end processing. ');
229: -- ========================= FND LOG ===========================
230: Raise MFAR_DIST_EXCEP ;
231: END IF;

Line 236: psa_utils.debug_other_string(g_state_level,l_full_path,

232: END IF;
233:
234: ELSE
235: -- ========================= FND LOG ===========================
236: psa_utils.debug_other_string(g_state_level,l_full_path,
237: ' PSA_MFAR_RECEIPTS.create_distributions TRUE --> ' || b_row.receivable_application_id);
238: -- ========================= FND LOG ===========================
239:
240: END IF;

Line 249: psa_utils.debug_other_string(g_state_level,l_full_path,

245: FOR c_row IN c(a_row.customer_trx_id)
246: LOOP
247:
248: -- ========================= FND LOG ===========================
249: psa_utils.debug_other_string(g_state_level,l_full_path,
250: ' calling PSA_MFAR_ADJUSTMENTS.create_distributions '
251: || ' -- ' || c_row.adjustment_id );
252: -- ========================= FND LOG ===========================
253:

Line 263: psa_utils.debug_other_string(g_error_level,l_full_path,

259: p_run_id => run_num,
260: p_error_message => p_error_message)) THEN
261:
262: -- ========================= FND LOG ===========================
263: psa_utils.debug_other_string(g_error_level,l_full_path,
264: ' PSA_MFAR_TRANSACTIONS.create_distributions --> FALSE ');
265: -- ========================= FND LOG ===========================
266:
267: IF p_error_message IS NOT NULL OR retcode = 'F' THEN

Line 269: psa_utils.debug_other_string(g_excep_level,l_full_path,

265: -- ========================= FND LOG ===========================
266:
267: IF p_error_message IS NOT NULL OR retcode = 'F' THEN
268: -- ========================= FND LOG ===========================
269: psa_utils.debug_other_string(g_excep_level,l_full_path,
270: ' Error Message --> '
271: || p_error_message);
272: -- ========================= FND LOG ===========================
273:

Line 276: psa_utils.debug_other_string(g_excep_level,l_full_path,

272: -- ========================= FND LOG ===========================
273:
274: IF NVL(p_report_only,'N') = 'N' THEN
275: -- ========================= FND LOG ===========================
276: psa_utils.debug_other_string(g_excep_level,l_full_path,
277: ' p_report_only --> N : This is not for reporting purpose so end processing. ');
278: -- ========================= FND LOG ===========================
279: Raise MFAR_DIST_EXCEP ;
280: END IF;

Line 286: psa_utils.debug_other_string(g_state_level,l_full_path,

282: END IF;
283:
284: ELSE
285: -- ========================= FND LOG ===========================
286: psa_utils.debug_other_string(g_state_level,l_full_path,
287: ' PSA_MFAR_ADJUSTMENTS.create_distributions TRUE --> ' || c_row.adjustment_id);
288: -- ========================= FND LOG ===========================
289: END IF;
290:

Line 300: psa_utils.debug_other_string(g_state_level,l_full_path,' p_mode in A or R');

296:
297:
298: IF p_mode IN ('A','R') THEN
299: -- ========================= FND LOG ===========================
300: psa_utils.debug_other_string(g_state_level,l_full_path,' p_mode in A or R');
301: -- ========================= FND LOG ===========================
302:
303: OPEN d(p_document_id);
304: LOOP

Line 310: psa_utils.debug_other_string(g_state_level,l_full_path,

306: FETCH d INTO cash_receipt_rec;
307: EXIT WHEN d%notfound;
308:
309: -- ========================= FND LOG ===========================
310: psa_utils.debug_other_string(g_state_level,l_full_path,
311: ' calling PSA_MF_MISC_PKG.generate_distributions '
312: || ' -- ' || cash_receipt_rec.cash_receipt_id);
313: -- ========================= FND LOG ===========================
314:

Line 325: psa_utils.debug_other_string(g_error_level,l_full_path,

321: p_error_message => p_error_message,
322: p_report_only => p_report_only)) THEN
323:
324: -- ========================= FND LOG ===========================
325: psa_utils.debug_other_string(g_error_level,l_full_path,
326: ' PSA_MF_MISC_PKG.generate_distributions --> FALSE ');
327: -- ========================= FND LOG ===========================
328:
329: IF p_error_message IS NOT NULL OR retcode = 'F' THEN

Line 331: psa_utils.debug_other_string(g_excep_level,l_full_path,

327: -- ========================= FND LOG ===========================
328:
329: IF p_error_message IS NOT NULL OR retcode = 'F' THEN
330: -- ========================= FND LOG ===========================
331: psa_utils.debug_other_string(g_excep_level,l_full_path,
332: ' Error Message --> '|| p_error_message);
333: -- ========================= FND LOG ===========================
334:
335: IF NVL(p_report_only,'N') = 'N' THEN

Line 337: psa_utils.debug_other_string(g_excep_level,l_full_path,

333: -- ========================= FND LOG ===========================
334:
335: IF NVL(p_report_only,'N') = 'N' THEN
336: -- ========================= FND LOG ===========================
337: psa_utils.debug_other_string(g_excep_level,l_full_path,
338: ' p_report_only --> N : This is not for reporting purpose so end processing. ');
339: -- ========================= FND LOG ===========================
340: Raise MFAR_DIST_EXCEP ;
341: END IF;

Line 345: psa_utils.debug_other_string(g_state_level,l_full_path,

341: END IF;
342: END IF;
343: ELSE
344: -- ========================= FND LOG ===========================
345: psa_utils.debug_other_string(g_state_level,l_full_path,
346: ' PSA_MF_MISC_PKG.generate_distributions TRUE --> '
347: || cash_receipt_rec.cash_receipt_id);
348: -- ========================= FND LOG ===========================
349: END IF;

Line 362: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURNING TRUE ');

358: -- as F so the records will be removed from gl_interface
359: END IF;
360:
361: -- ========================= FND LOG ===========================
362: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURNING TRUE ');
363: -- ========================= FND LOG ===========================
364:
365: RETURN TRUE;
366:

Line 370: psa_utils.debug_other_string(g_excep_level,l_full_path,

366:
367: EXCEPTION
368: WHEN MFAR_DIST_EXCEP THEN
369: -- ========================= FND LOG ===========================
370: psa_utils.debug_other_string(g_excep_level,l_full_path,
371: 'EXCEPTION - MFAR_NOT_IMPLEMENTED PACKAGE - PSA_MF_CREATE_DISTRIBUTIONS.CREATE_DISTRIBUTIONS');
372: psa_utils.debug_other_string(g_excep_level,l_full_path, p_error_message);
373: -- ========================= FND LOG ===========================
374:

Line 372: psa_utils.debug_other_string(g_excep_level,l_full_path, p_error_message);

368: WHEN MFAR_DIST_EXCEP THEN
369: -- ========================= FND LOG ===========================
370: psa_utils.debug_other_string(g_excep_level,l_full_path,
371: 'EXCEPTION - MFAR_NOT_IMPLEMENTED PACKAGE - PSA_MF_CREATE_DISTRIBUTIONS.CREATE_DISTRIBUTIONS');
372: psa_utils.debug_other_string(g_excep_level,l_full_path, p_error_message);
373: -- ========================= FND LOG ===========================
374:
375: BEGIN
376: -- ========================= FND LOG ===========================

Line 377: psa_utils.debug_other_string(g_excep_level,l_full_path, 'Rolling back to PSA_PSAMFCRB');

373: -- ========================= FND LOG ===========================
374:
375: BEGIN
376: -- ========================= FND LOG ===========================
377: psa_utils.debug_other_string(g_excep_level,l_full_path, 'Rolling back to PSA_PSAMFCRB');
378: -- ========================= FND LOG ===========================
379: ROLLBACK TO PSA_PSAMFCRB;
380: EXCEPTION
381: WHEN OTHERS THEN

Line 383: psa_utils.debug_other_string(g_excep_level,l_full_path,

379: ROLLBACK TO PSA_PSAMFCRB;
380: EXCEPTION
381: WHEN OTHERS THEN
382: -- ========================= FND LOG ===========================
383: psa_utils.debug_other_string(g_excep_level,l_full_path,
384: 'EXCEPTION - OTHERS : SAVEPOINT PSA_PSAMFCRB ERASED.');
385: -- ========================= FND LOG ===========================
386: END;
387:

Line 395: psa_utils.debug_other_string(g_excep_level,l_full_path,

391: WHEN MFAR_NOT_IMPLEMENTED THEN
392: fnd_message.set_name ('PSA','PSA_MF_NOT_IMPLEMENTED');
393: p_error_message := fnd_message.get;
394: -- ========================= FND LOG ===========================
395: psa_utils.debug_other_string(g_excep_level,l_full_path,
396: 'EXCEPTION - MFAR_NOT_IMPLEMENTED PACKAGE - PSA_MF_CREATE_DISTRIBUTIONS.CREATE_DISTRIBUTIONS');
397: psa_utils.debug_other_string(g_excep_level,l_full_path, p_error_message);
398: -- ========================= FND LOG ===========================
399: retcode := 'S';

Line 397: psa_utils.debug_other_string(g_excep_level,l_full_path, p_error_message);

393: p_error_message := fnd_message.get;
394: -- ========================= FND LOG ===========================
395: psa_utils.debug_other_string(g_excep_level,l_full_path,
396: 'EXCEPTION - MFAR_NOT_IMPLEMENTED PACKAGE - PSA_MF_CREATE_DISTRIBUTIONS.CREATE_DISTRIBUTIONS');
397: psa_utils.debug_other_string(g_excep_level,l_full_path, p_error_message);
398: -- ========================= FND LOG ===========================
399: retcode := 'S';
400: RETURN FALSE;
401:

Line 405: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);

401:
402: WHEN OTHERS THEN
403: p_error_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MF_CREATE_DISTRIBUTIONS.CREATE_DISTRIBUTIONS - '||sqlerrm;
404: -- ========================= FND LOG ===========================
405: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
406: psa_utils.debug_unexpected_msg(l_full_path);
407: -- ========================= FND LOG ===========================
408: retcode := 'F';
409: RETURN FALSE;

Line 406: psa_utils.debug_unexpected_msg(l_full_path);

402: WHEN OTHERS THEN
403: p_error_message := 'EXCEPTION - OTHERS PACKAGE - PSA_MF_CREATE_DISTRIBUTIONS.CREATE_DISTRIBUTIONS - '||sqlerrm;
404: -- ========================= FND LOG ===========================
405: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
406: psa_utils.debug_unexpected_msg(l_full_path);
407: -- ========================= FND LOG ===========================
408: retcode := 'F';
409: RETURN FALSE;
410:

Line 438: psa_utils.debug_other_string(g_state_level,l_full_path,

434:
435: BEGIN
436:
437: -- ========================= FND LOG ===========================
438: psa_utils.debug_other_string(g_state_level,l_full_path,
439: ' submit_create_distribution --> START ');
440: -- ========================= FND LOG ===========================
441:
442: IF NOT (create_distributions (

Line 453: psa_utils.debug_other_string(g_state_level,l_full_path,

449: p_error_message,
450: p_report_only)) THEN
451:
452: -- ========================= FND LOG ===========================
453: psa_utils.debug_other_string(g_state_level,l_full_path,
454: ' submit_create_distribution --> Document id --> ' || p_document_id
455: || ' Number --> ' || run_num);
456: psa_utils.debug_other_string(g_state_level,l_full_path,
457: ' submit_create_distribution --> Error Message : ' || p_error_message);

Line 456: psa_utils.debug_other_string(g_state_level,l_full_path,

452: -- ========================= FND LOG ===========================
453: psa_utils.debug_other_string(g_state_level,l_full_path,
454: ' submit_create_distribution --> Document id --> ' || p_document_id
455: || ' Number --> ' || run_num);
456: psa_utils.debug_other_string(g_state_level,l_full_path,
457: ' submit_create_distribution --> Error Message : ' || p_error_message);
458: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
459: -- ========================= FND LOG ===========================
460:

Line 458: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

454: ' submit_create_distribution --> Document id --> ' || p_document_id
455: || ' Number --> ' || run_num);
456: psa_utils.debug_other_string(g_state_level,l_full_path,
457: ' submit_create_distribution --> Error Message : ' || p_error_message);
458: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
459: -- ========================= FND LOG ===========================
460:
461: END IF;
462:

Line 464: psa_utils.debug_other_string(g_state_level,l_full_path,

460:
461: END IF;
462:
463: -- ========================= FND LOG ===========================
464: psa_utils.debug_other_string(g_state_level,l_full_path,
465: ' submit_create_distribution --> END ');
466: -- ========================= FND LOG ===========================
467:
468: EXCEPTION

Line 471: psa_utils.debug_other_string(g_excep_level,l_full_path,'submit_create_distributions: '

467:
468: EXCEPTION
469: WHEN OTHERS THEN
470: -- ========================= FND LOG ===========================
471: psa_utils.debug_other_string(g_excep_level,l_full_path,'submit_create_distributions: '
472: || 'PSAMFCRB: Exception Main in submit_create..');
473: psa_utils.debug_other_string(g_excep_level,l_full_path,'submit_create_distributions: '
474: || 'PSAMFCRB ' || sqlcode || sqlerrm);
475: psa_utils.debug_unexpected_msg(l_full_path);

Line 473: psa_utils.debug_other_string(g_excep_level,l_full_path,'submit_create_distributions: '

469: WHEN OTHERS THEN
470: -- ========================= FND LOG ===========================
471: psa_utils.debug_other_string(g_excep_level,l_full_path,'submit_create_distributions: '
472: || 'PSAMFCRB: Exception Main in submit_create..');
473: psa_utils.debug_other_string(g_excep_level,l_full_path,'submit_create_distributions: '
474: || 'PSAMFCRB ' || sqlcode || sqlerrm);
475: psa_utils.debug_unexpected_msg(l_full_path);
476: -- ========================= FND LOG ===========================
477: END submit_create_distributions;

Line 475: psa_utils.debug_unexpected_msg(l_full_path);

471: psa_utils.debug_other_string(g_excep_level,l_full_path,'submit_create_distributions: '
472: || 'PSAMFCRB: Exception Main in submit_create..');
473: psa_utils.debug_other_string(g_excep_level,l_full_path,'submit_create_distributions: '
474: || 'PSAMFCRB ' || sqlcode || sqlerrm);
475: psa_utils.debug_unexpected_msg(l_full_path);
476: -- ========================= FND LOG ===========================
477: END submit_create_distributions;
478:
479: FUNCTION create_distributions_rpt (