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 FND_LOG

Line 13: --===========================FND_LOG.START=====================================

9: ## If Activity is (M)iscellanous Receipt, Misc. receipts will be processed
10: ## If Activity is (A)ll, all the Multifund distributions will be processed.
11: */
12:
13: --===========================FND_LOG.START=====================================
14: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
15: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
16: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
17: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 14: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;

10: ## If Activity is (A)ll, all the Multifund distributions will be processed.
11: */
12:
13: --===========================FND_LOG.START=====================================
14: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
15: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
16: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
17: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
18: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;

Line 15: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

11: */
12:
13: --===========================FND_LOG.START=====================================
14: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
15: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
16: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
17: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
18: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
19: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 16: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;

12:
13: --===========================FND_LOG.START=====================================
14: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
15: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
16: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
17: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
18: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
19: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
20: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFCRB.PSA_MF_CREATE_DISTRIBUTIONS.';

Line 17: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

13: --===========================FND_LOG.START=====================================
14: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
15: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
16: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
17: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
18: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
19: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
20: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFCRB.PSA_MF_CREATE_DISTRIBUTIONS.';
21: --===========================FND_LOG.END=======================================

Line 18: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;

14: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
15: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
16: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
17: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
18: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
19: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
20: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFCRB.PSA_MF_CREATE_DISTRIBUTIONS.';
21: --===========================FND_LOG.END=======================================
22:

Line 19: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;

15: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
16: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
17: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
18: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
19: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
20: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFCRB.PSA_MF_CREATE_DISTRIBUTIONS.';
21: --===========================FND_LOG.END=======================================
22:
23: FUNCTION create_distributions (

Line 21: --===========================FND_LOG.END=======================================

17: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
18: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
19: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
20: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFCRB.PSA_MF_CREATE_DISTRIBUTIONS.';
21: --===========================FND_LOG.END=======================================
22:
23: FUNCTION create_distributions (
24: errbuf OUT NOCOPY VARCHAR2,
25: retcode OUT NOCOPY VARCHAR2,

Line 72: -- ========================= FND LOG ===========================

68:
69: MFAR_DIST_EXCEP EXCEPTION;
70: MFAR_NOT_IMPLEMENTED EXCEPTION;
71:
72: -- ========================= FND LOG ===========================
73: l_full_path VARCHAR2(100) := g_path || 'create_distributions';
74: -- ========================= FND LOG ===========================
75:
76: BEGIN

Line 74: -- ========================= FND LOG ===========================

70: MFAR_NOT_IMPLEMENTED EXCEPTION;
71:
72: -- ========================= FND LOG ===========================
73: l_full_path VARCHAR2(100) := g_path || 'create_distributions';
74: -- ========================= FND LOG ===========================
75:
76: BEGIN
77:
78: SAVEPOINT PSA_PSAMFCRB;

Line 83: -- ========================= FND LOG ===========================

79:
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);

Line 93: -- ========================= FND LOG ===========================

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
97: (l_mfar_implemented <> 'Y')) THEN

Line 98: -- ========================= FND LOG ===========================

94:
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 ;

Line 101: -- ========================= FND LOG ===========================

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
104: -- ========================= FND LOG ===========================
105: psa_utils.debug_other_string(g_state_level,l_full_path,' MFAR is implemented ');

Line 104: -- ========================= FND LOG ===========================

100: ' MFAR not 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:

Line 106: -- ========================= 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:
110: /* getting the sequence number */

Line 115: -- ========================= FND LOG ===========================

111: BEGIN
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:

Line 118: -- ========================= FND LOG ===========================

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
121: WHEN OTHERS THEN
122: FND_MESSAGE.SET_NAME ('AR', 'GENERIC_MESSAGE');

Line 126: -- ========================= FND LOG ===========================

122: FND_MESSAGE.SET_NAME ('AR', 'GENERIC_MESSAGE');
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 ===========================

Line 128: -- ========================= FND LOG ===========================

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,
132: ' PSAMFCRB: ' || p_error_message);

Line 130: -- ========================= FND LOG ===========================

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,
132: ' PSAMFCRB: ' || p_error_message);
133: psa_utils.debug_other_string(g_excep_level,l_full_path,
134: ' PSAMFCRB: ' || sqlcode || sqlerrm);

Line 135: -- ========================= 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;
138:
139: IF p_mode IN ('A','T') THEN

Line 140: -- ========================= FND LOG ===========================

136: RETURN FALSE;
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:

Line 143: -- ========================= FND LOG ===========================

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)
146: LOOP
147: -- ========================= FND LOG ===========================

Line 147: -- ========================= FND LOG ===========================

143: -- ========================= FND LOG ===========================
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');

Line 152: -- ========================= 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
155: (a_row.customer_trx_id,'TRX', p_set_of_books_id) = 'Y' THEN
156:

Line 157: -- ========================= FND LOG ===========================

153:
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:

Line 160: -- ========================= FND LOG ===========================

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,
163: retcode => retcode,
164: p_cust_trx_id => a_row.customer_trx_id,

Line 169: -- ========================= FND LOG ===========================

165: p_set_of_books_id => p_set_of_books_id,
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:

Line 172: -- ========================= FND LOG ===========================

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
175: -- ========================= FND LOG ===========================
176: psa_utils.debug_other_string(g_error_level,l_full_path,

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

171: ' PSA_MFAR_TRANSACTIONS.create_distributions --> FALSE ');
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 ===========================

Line 179: -- ========================= FND LOG ===========================

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:
181: IF NVL(p_report_only,'N') = 'N' THEN
182: -- ========================= FND LOG ===========================
183: psa_utils.debug_other_string(g_error_level,l_full_path,

Line 182: -- ========================= FND LOG ===========================

178: || p_error_message);
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 ===========================

Line 186: -- ========================= FND LOG ===========================

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 ;
188: END IF;
189: END IF;
190:

Line 192: -- ========================= FND LOG ===========================

188: END IF;
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;

Line 195: -- ========================= FND LOG ===========================

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:
198: /* RECEIPTS */
199: FOR b_row IN b(a_row.customer_trx_id)

Line 201: -- ========================= FND LOG ===========================

197:
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 ===========================

Line 205: -- ========================= FND LOG ===========================

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:
207: IF NOT (PSA_MFAR_RECEIPTS.create_distributions (errbuf => errbuf,
208: retcode => retcode,
209: p_receivable_app_id => b_row.receivable_application_id,

Line 214: -- ========================= FND LOG ===========================

210: p_set_of_books_id => p_set_of_books_id,
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:

Line 217: -- ========================= FND LOG ===========================

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
220: -- ========================= FND LOG ===========================
221: psa_utils.debug_other_string(g_excep_level,l_full_path,

Line 220: -- ========================= FND LOG ===========================

216: ' PSA_MFAR_RECEIPTS.create_distributions --> FALSE ');
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:

Line 223: -- ========================= FND LOG ===========================

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
226: -- ========================= FND LOG ===========================
227: psa_utils.debug_other_string(g_excep_level,l_full_path,

Line 226: -- ========================= FND LOG ===========================

222: ' Error Message --> '|| p_error_message);
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 ;

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

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;
232: END IF;
233:

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

231: END IF;
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:

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

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;
241:
242: END LOOP;

Line 248: -- ========================= FND LOG ===========================

244: /* ADJUSTMENTS */
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 ===========================

Line 252: -- ========================= FND LOG ===========================

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:
254: IF NOT (PSA_MFAR_ADJUSTMENTS.create_distributions (
255: errbuf => errbuf,
256: retcode => retcode,

Line 262: -- ========================= FND LOG ===========================

258: p_set_of_books_id => p_set_of_books_id,
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:

Line 265: -- ========================= FND LOG ===========================

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
268: -- ========================= FND LOG ===========================
269: psa_utils.debug_other_string(g_excep_level,l_full_path,

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

264: ' PSA_MFAR_TRANSACTIONS.create_distributions --> FALSE ');
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 ===========================

Line 272: -- ========================= FND LOG ===========================

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:
274: IF NVL(p_report_only,'N') = 'N' THEN
275: -- ========================= FND LOG ===========================
276: psa_utils.debug_other_string(g_excep_level,l_full_path,

Line 275: -- ========================= FND LOG ===========================

271: || p_error_message);
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 ;

Line 278: -- ========================= FND LOG ===========================

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;
281:
282: END IF;

Line 285: -- ========================= FND LOG ===========================

281:
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;

Line 288: -- ========================= FND LOG ===========================

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:
291: END LOOP;
292: END IF; -- AR_MFAR_VALIDATE_CHECK

Line 299: -- ========================= FND LOG ===========================

295: END IF;
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);

Line 301: -- ========================= FND LOG ===========================

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
305:

Line 309: -- ========================= FND LOG ===========================

305:
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 ===========================

Line 313: -- ========================= FND LOG ===========================

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:
315: IF NOT (PSA_MF_MISC_PKG.generate_distributions (
316: errbuf => errbuf,
317: retcode => retcode,

Line 324: -- ========================= FND LOG ===========================

320: p_run_id => run_num,
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:

Line 327: -- ========================= FND LOG ===========================

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
330: -- ========================= FND LOG ===========================
331: psa_utils.debug_other_string(g_excep_level,l_full_path,

Line 330: -- ========================= FND LOG ===========================

326: ' PSA_MF_MISC_PKG.generate_distributions --> FALSE ');
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:

Line 333: -- ========================= FND LOG ===========================

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
336: -- ========================= FND LOG ===========================
337: psa_utils.debug_other_string(g_excep_level,l_full_path,

Line 336: -- ========================= FND LOG ===========================

332: ' Error Message --> '|| p_error_message);
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 ;

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

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;
342: END IF;
343: ELSE

Line 344: -- ========================= FND LOG ===========================

340: Raise MFAR_DIST_EXCEP ;
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 ===========================

Line 348: -- ========================= FND LOG ===========================

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;
350:
351: END LOOP;
352: CLOSE d;

Line 361: -- ========================= FND LOG ===========================

357: -- have to check with sanjay if report_only is YES then should we have to pass
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;

Line 363: -- ========================= FND LOG ===========================

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:
367: EXCEPTION

Line 369: -- ========================= FND LOG ===========================

365: RETURN TRUE;
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 ===========================

Line 373: -- ========================= FND LOG ===========================

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 ===========================
377: psa_utils.debug_other_string(g_excep_level,l_full_path, 'Rolling back to PSA_PSAMFCRB');

Line 376: -- ========================= FND LOG ===========================

372: psa_utils.debug_other_string(g_excep_level,l_full_path, p_error_message);
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

Line 378: -- ========================= 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
382: -- ========================= FND LOG ===========================

Line 382: -- ========================= FND LOG ===========================

378: -- ========================= FND LOG ===========================
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;

Line 385: -- ========================= FND LOG ===========================

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:
388: retcode := 'F';
389: RETURN FALSE;

Line 394: -- ========================= FND LOG ===========================

390:
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 ===========================

Line 398: -- ========================= FND LOG ===========================

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:
402: WHEN OTHERS THEN

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

400: RETURN FALSE;
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';

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

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:
411: END create_distributions;

Line 431: -- ========================= FND LOG ===========================

427: p_report_only IN VARCHAR2 DEFAULT 'N')
428: IS
429: run_num NUMBER;
430: p_error_message VARCHAR2(3000);
431: -- ========================= FND LOG ===========================
432: l_full_path VARCHAR2(100) := g_path || 'submit_create_distributions';
433: -- ========================= FND LOG ===========================
434:
435: BEGIN

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

429: run_num NUMBER;
430: p_error_message VARCHAR2(3000);
431: -- ========================= FND LOG ===========================
432: l_full_path VARCHAR2(100) := g_path || 'submit_create_distributions';
433: -- ========================= FND LOG ===========================
434:
435: BEGIN
436:
437: -- ========================= FND LOG ===========================

Line 437: -- ========================= FND LOG ===========================

433: -- ========================= FND LOG ===========================
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:

Line 440: -- ========================= FND LOG ===========================

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 (
443: errbuf,
444: retcode,

Line 452: -- ========================= FND LOG ===========================

448: run_num,
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,

Line 459: -- ========================= FND LOG ===========================

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:
463: -- ========================= FND LOG ===========================

Line 463: -- ========================= FND LOG ===========================

459: -- ========================= FND LOG ===========================
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:

Line 466: -- ========================= FND LOG ===========================

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
469: WHEN OTHERS THEN
470: -- ========================= FND LOG ===========================

Line 470: -- ========================= FND LOG ===========================

466: -- ========================= FND LOG ===========================
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);

Line 476: -- ========================= FND LOG ===========================

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 (
480: errbuf OUT NOCOPY VARCHAR2,