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

Line 37: psa_utils.debug_other_string(g_state_level,l_full_path,

33:
34: BEGIN
35:
36: -- ========================= FND LOG ===========================
37: psa_utils.debug_other_string(g_state_level,l_full_path,
38: ' ########################## ');
39: psa_utils.debug_other_string(g_state_level,l_full_path,
40: ' ## Reset Transaction Codes START ## ');
41: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 39: psa_utils.debug_other_string(g_state_level,l_full_path,

35:
36: -- ========================= FND LOG ===========================
37: psa_utils.debug_other_string(g_state_level,l_full_path,
38: ' ########################## ');
39: psa_utils.debug_other_string(g_state_level,l_full_path,
40: ' ## Reset Transaction Codes START ## ');
41: psa_utils.debug_other_string(g_state_level,l_full_path,
42: ' ########################## ');
43: psa_utils.debug_other_string(g_state_level,l_full_path, ' '

Line 41: psa_utils.debug_other_string(g_state_level,l_full_path,

37: psa_utils.debug_other_string(g_state_level,l_full_path,
38: ' ########################## ');
39: psa_utils.debug_other_string(g_state_level,l_full_path,
40: ' ## Reset Transaction Codes START ## ');
41: psa_utils.debug_other_string(g_state_level,l_full_path,
42: ' ########################## ');
43: psa_utils.debug_other_string(g_state_level,l_full_path, ' '
44: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
45: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

Line 43: psa_utils.debug_other_string(g_state_level,l_full_path, ' '

39: psa_utils.debug_other_string(g_state_level,l_full_path,
40: ' ## Reset Transaction Codes START ## ');
41: psa_utils.debug_other_string(g_state_level,l_full_path,
42: ' ########################## ');
43: psa_utils.debug_other_string(g_state_level,l_full_path, ' '
44: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
45: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
46: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
47: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');

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

41: psa_utils.debug_other_string(g_state_level,l_full_path,
42: ' ########################## ');
43: psa_utils.debug_other_string(g_state_level,l_full_path, ' '
44: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
45: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
46: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
47: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
48: psa_utils.debug_other_string(g_state_level,l_full_path,' p_pstctrl_id -->' || p_pstctrl_id );
49: psa_utils.debug_other_string(g_state_level,l_full_path,' Setting save point PSA_PSAARTCB' );

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

42: ' ########################## ');
43: psa_utils.debug_other_string(g_state_level,l_full_path, ' '
44: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
45: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
46: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
47: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
48: psa_utils.debug_other_string(g_state_level,l_full_path,' p_pstctrl_id -->' || p_pstctrl_id );
49: psa_utils.debug_other_string(g_state_level,l_full_path,' Setting save point PSA_PSAARTCB' );
50: -- ========================= FND LOG ===========================

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

43: psa_utils.debug_other_string(g_state_level,l_full_path, ' '
44: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
45: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
46: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
47: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
48: psa_utils.debug_other_string(g_state_level,l_full_path,' p_pstctrl_id -->' || p_pstctrl_id );
49: psa_utils.debug_other_string(g_state_level,l_full_path,' Setting save point PSA_PSAARTCB' );
50: -- ========================= FND LOG ===========================
51:

Line 48: psa_utils.debug_other_string(g_state_level,l_full_path,' p_pstctrl_id -->' || p_pstctrl_id );

44: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
45: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
46: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
47: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
48: psa_utils.debug_other_string(g_state_level,l_full_path,' p_pstctrl_id -->' || p_pstctrl_id );
49: psa_utils.debug_other_string(g_state_level,l_full_path,' Setting save point PSA_PSAARTCB' );
50: -- ========================= FND LOG ===========================
51:
52: SAVEPOINT PSA_PSAARTCB;

Line 49: psa_utils.debug_other_string(g_state_level,l_full_path,' Setting save point PSA_PSAARTCB' );

45: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
46: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
47: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
48: psa_utils.debug_other_string(g_state_level,l_full_path,' p_pstctrl_id -->' || p_pstctrl_id );
49: psa_utils.debug_other_string(g_state_level,l_full_path,' Setting save point PSA_PSAARTCB' );
50: -- ========================= FND LOG ===========================
51:
52: SAVEPOINT PSA_PSAARTCB;
53: ret_code := 'S';

Line 57: psa_utils.debug_other_string(g_state_level,l_full_path,' l_group_id -->' || l_group_id );

53: ret_code := 'S';
54: l_group_id := p_pstctrl_id;
55:
56: -- ========================= FND LOG ===========================
57: psa_utils.debug_other_string(g_state_level,l_full_path,' l_group_id -->' || l_group_id );
58: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
59: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS : ');
60: psa_utils.debug_other_string(g_state_level,l_full_path,' ========= ');
61: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id );

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

54: l_group_id := p_pstctrl_id;
55:
56: -- ========================= FND LOG ===========================
57: psa_utils.debug_other_string(g_state_level,l_full_path,' l_group_id -->' || l_group_id );
58: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
59: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS : ');
60: psa_utils.debug_other_string(g_state_level,l_full_path,' ========= ');
61: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id );
62: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_id -->' || l_org_id );

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

55:
56: -- ========================= FND LOG ===========================
57: psa_utils.debug_other_string(g_state_level,l_full_path,' l_group_id -->' || l_group_id );
58: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
59: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS : ');
60: psa_utils.debug_other_string(g_state_level,l_full_path,' ========= ');
61: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id );
62: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_id -->' || l_org_id );
63: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

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

56: -- ========================= FND LOG ===========================
57: psa_utils.debug_other_string(g_state_level,l_full_path,' l_group_id -->' || l_group_id );
58: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
59: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS : ');
60: psa_utils.debug_other_string(g_state_level,l_full_path,' ========= ');
61: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id );
62: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_id -->' || l_org_id );
63: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
64: -- ========================= FND LOG ===========================

Line 61: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id );

57: psa_utils.debug_other_string(g_state_level,l_full_path,' l_group_id -->' || l_group_id );
58: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
59: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS : ');
60: psa_utils.debug_other_string(g_state_level,l_full_path,' ========= ');
61: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id );
62: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_id -->' || l_org_id );
63: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
64: -- ========================= FND LOG ===========================
65:

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

58: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
59: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS : ');
60: psa_utils.debug_other_string(g_state_level,l_full_path,' ========= ');
61: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id );
62: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_id -->' || l_org_id );
63: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
64: -- ========================= FND LOG ===========================
65:
66: UPDATE GL_INTERFACE

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

59: psa_utils.debug_other_string(g_state_level,l_full_path,' PROCESS : ');
60: psa_utils.debug_other_string(g_state_level,l_full_path,' ========= ');
61: psa_utils.debug_other_string(g_state_level,l_full_path,' l_sob_id -->' || l_sob_id );
62: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_id -->' || l_org_id );
63: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
64: -- ========================= FND LOG ===========================
65:
66: UPDATE GL_INTERFACE
67: SET ussgl_transaction_code = NULL

Line 81: psa_utils.debug_other_string(g_state_level,l_full_path,' UPDATE GL_INTERFACE ## 1 -->'

77: reference29 = 'TRADE_APP' AND
78: reference30 = 'AR_RECEIVABLE_APPLICATIONS' ) );
79:
80: -- ========================= FND LOG ===========================
81: psa_utils.debug_other_string(g_state_level,l_full_path,' UPDATE GL_INTERFACE ## 1 -->'
82: || SQL%ROWCOUNT );
83: -- ========================= FND LOG ===========================
84:
85: --

Line 107: psa_utils.debug_other_string(g_state_level,l_full_path,' UPDATE GL_INTERFACE ## 2 -->'

103: WHERE ar.cash_receipt_id = TO_NUMBER(SUBSTR(gl.reference22, 1, INSTR(gl.reference22, 'C')-1))
104: AND status = 'UNAPP' );
105:
106: -- ========================= FND LOG ===========================
107: psa_utils.debug_other_string(g_state_level,l_full_path,' UPDATE GL_INTERFACE ## 2 -->'
108: || SQL%ROWCOUNT );
109: -- ========================= FND LOG ===========================
110:
111: --

Line 145: psa_utils.debug_other_string(g_state_level,l_full_path,' UPDATE GL_INTERFACE ## 3 -->'

141: SUBSTR(gl.reference22, 1, INSTR(gl.reference22, 'C')-1) );
142:
143:
144: -- ========================= FND LOG ===========================
145: psa_utils.debug_other_string(g_state_level,l_full_path,' UPDATE GL_INTERFACE ## 3 -->'
146: || SQL%ROWCOUNT );
147: -- ========================= FND LOG ===========================
148:
149:

Line 157: psa_utils.debug_other_string(g_state_level,l_full_path,' l_enabled -->' || l_enabled );

153: FETCH c_mfar_enabled INTO l_enabled;
154: CLOSE c_mfar_enabled;
155:
156: -- ========================= FND LOG ===========================
157: psa_utils.debug_other_string(g_state_level,l_full_path,' l_enabled -->' || l_enabled );
158: -- ========================= FND LOG ===========================
159:
160: IF l_enabled = 'Y' THEN
161:

Line 174: psa_utils.debug_other_string(g_state_level,l_full_path,' UPDATE GL_INTERFACE ## 4 -->'

170: AND is_mfar_transaction
171: (TO_NUMBER(SUBSTR(reference22, INSTR(reference22, 'C')+1)), l_sob_id) = 'Y';
172:
173: -- ========================= FND LOG ===========================
174: psa_utils.debug_other_string(g_state_level,l_full_path,' UPDATE GL_INTERFACE ## 4 -->'
175: || SQL%ROWCOUNT );
176: -- ========================= FND LOG ===========================
177:
178: END IF;

Line 182: psa_utils.debug_other_string(g_state_level,l_full_path,

178: END IF;
179: END IF;
180:
181: -- ========================= FND LOG ===========================
182: psa_utils.debug_other_string(g_state_level,l_full_path,
183: ' ########################## ');
184: psa_utils.debug_other_string(g_state_level,l_full_path,
185: ' ## Reset Transaction Codes END ## ');
186: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 184: psa_utils.debug_other_string(g_state_level,l_full_path,

180:
181: -- ========================= FND LOG ===========================
182: psa_utils.debug_other_string(g_state_level,l_full_path,
183: ' ########################## ');
184: psa_utils.debug_other_string(g_state_level,l_full_path,
185: ' ## Reset Transaction Codes END ## ');
186: psa_utils.debug_other_string(g_state_level,l_full_path,
187: ' ########################## ');
188: psa_utils.debug_other_string(g_state_level,l_full_path, ' '

Line 186: psa_utils.debug_other_string(g_state_level,l_full_path,

182: psa_utils.debug_other_string(g_state_level,l_full_path,
183: ' ########################## ');
184: psa_utils.debug_other_string(g_state_level,l_full_path,
185: ' ## Reset Transaction Codes END ## ');
186: psa_utils.debug_other_string(g_state_level,l_full_path,
187: ' ########################## ');
188: psa_utils.debug_other_string(g_state_level,l_full_path, ' '
189: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
190: psa_utils.debug_other_string(g_state_level,l_full_path,' ');

Line 188: psa_utils.debug_other_string(g_state_level,l_full_path, ' '

184: psa_utils.debug_other_string(g_state_level,l_full_path,
185: ' ## Reset Transaction Codes END ## ');
186: psa_utils.debug_other_string(g_state_level,l_full_path,
187: ' ########################## ');
188: psa_utils.debug_other_string(g_state_level,l_full_path, ' '
189: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
190: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
191: -- ========================= FND LOG ===========================
192:

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

186: psa_utils.debug_other_string(g_state_level,l_full_path,
187: ' ########################## ');
188: psa_utils.debug_other_string(g_state_level,l_full_path, ' '
189: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
190: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
191: -- ========================= FND LOG ===========================
192:
193: EXCEPTION
194: WHEN OTHERS THEN

Line 196: psa_utils.debug_other_string(g_excep_level,l_full_path,

192:
193: EXCEPTION
194: WHEN OTHERS THEN
195: -- ========================= FND LOG ===========================
196: psa_utils.debug_other_string(g_excep_level,l_full_path,
197: ' --> EXCEPTION - OTHERS raised during PSA_AR_GL_INTERFACE.reset_transaction_codes ');
198: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
199: psa_utils.debug_unexpected_msg(l_full_path);
200: -- ========================= FND LOG ===========================

Line 198: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);

194: WHEN OTHERS THEN
195: -- ========================= FND LOG ===========================
196: psa_utils.debug_other_string(g_excep_level,l_full_path,
197: ' --> EXCEPTION - OTHERS raised during PSA_AR_GL_INTERFACE.reset_transaction_codes ');
198: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
199: psa_utils.debug_unexpected_msg(l_full_path);
200: -- ========================= FND LOG ===========================
201:
202: BEGIN

Line 199: psa_utils.debug_unexpected_msg(l_full_path);

195: -- ========================= FND LOG ===========================
196: psa_utils.debug_other_string(g_excep_level,l_full_path,
197: ' --> EXCEPTION - OTHERS raised during PSA_AR_GL_INTERFACE.reset_transaction_codes ');
198: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
199: psa_utils.debug_unexpected_msg(l_full_path);
200: -- ========================= FND LOG ===========================
201:
202: BEGIN
203: -- ========================= FND LOG ===========================

Line 204: psa_utils.debug_other_string(g_excep_level,l_full_path,'Rolling back');

200: -- ========================= FND LOG ===========================
201:
202: BEGIN
203: -- ========================= FND LOG ===========================
204: psa_utils.debug_other_string(g_excep_level,l_full_path,'Rolling back');
205: -- ========================= FND LOG ===========================
206: ROLLBACK TO PSA_PSAARTCB;
207: EXCEPTION
208: WHEN OTHERS THEN

Line 210: psa_utils.debug_other_string(g_excep_level,l_full_path,

206: ROLLBACK TO PSA_PSAARTCB;
207: EXCEPTION
208: WHEN OTHERS THEN
209: -- ========================= FND LOG ===========================
210: psa_utils.debug_other_string(g_excep_level,l_full_path,
211: 'EXCEPTION - OTHERS : SAVEPOINT ERASED.');
212: -- ========================= FND LOG ===========================
213: END;
214:

Line 242: psa_utils.debug_other_string(g_state_level,l_full_path,

238:
239: BEGIN
240:
241: -- ========================= FND LOG ===========================
242: psa_utils.debug_other_string(g_state_level,l_full_path,
243: ' ## is_mfar_transaction START ## ');
244: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
245: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
246: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');

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

240:
241: -- ========================= FND LOG ===========================
242: psa_utils.debug_other_string(g_state_level,l_full_path,
243: ' ## is_mfar_transaction START ## ');
244: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
245: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
246: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
247: psa_utils.debug_other_string(g_state_level,l_full_path,' p_doc_id -->' || p_doc_id );
248: psa_utils.debug_other_string(g_state_level,l_full_path,' p_sob_id -->' || p_sob_id );

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

241: -- ========================= FND LOG ===========================
242: psa_utils.debug_other_string(g_state_level,l_full_path,
243: ' ## is_mfar_transaction START ## ');
244: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
245: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
246: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
247: psa_utils.debug_other_string(g_state_level,l_full_path,' p_doc_id -->' || p_doc_id );
248: psa_utils.debug_other_string(g_state_level,l_full_path,' p_sob_id -->' || p_sob_id );
249: -- ========================= FND LOG ===========================

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

242: psa_utils.debug_other_string(g_state_level,l_full_path,
243: ' ## is_mfar_transaction START ## ');
244: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
245: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
246: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
247: psa_utils.debug_other_string(g_state_level,l_full_path,' p_doc_id -->' || p_doc_id );
248: psa_utils.debug_other_string(g_state_level,l_full_path,' p_sob_id -->' || p_sob_id );
249: -- ========================= FND LOG ===========================
250:

Line 247: psa_utils.debug_other_string(g_state_level,l_full_path,' p_doc_id -->' || p_doc_id );

243: ' ## is_mfar_transaction START ## ');
244: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
245: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
246: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
247: psa_utils.debug_other_string(g_state_level,l_full_path,' p_doc_id -->' || p_doc_id );
248: psa_utils.debug_other_string(g_state_level,l_full_path,' p_sob_id -->' || p_sob_id );
249: -- ========================= FND LOG ===========================
250:
251: OPEN c_trx_id(p_doc_id);

Line 248: psa_utils.debug_other_string(g_state_level,l_full_path,' p_sob_id -->' || p_sob_id );

244: psa_utils.debug_other_string(g_state_level,l_full_path,' ');
245: psa_utils.debug_other_string(g_state_level,l_full_path,' PARAMETERS :');
246: psa_utils.debug_other_string(g_state_level,l_full_path,' ============');
247: psa_utils.debug_other_string(g_state_level,l_full_path,' p_doc_id -->' || p_doc_id );
248: psa_utils.debug_other_string(g_state_level,l_full_path,' p_sob_id -->' || p_sob_id );
249: -- ========================= FND LOG ===========================
250:
251: OPEN c_trx_id(p_doc_id);
252: FETCH c_trx_id INTO l_cust_trx_id;

Line 256: psa_utils.debug_other_string(g_state_level,l_full_path,' l_cust_trx_id -->' || l_cust_trx_id );

252: FETCH c_trx_id INTO l_cust_trx_id;
253: CLOSE c_trx_id;
254:
255: -- ========================= FND LOG ===========================
256: psa_utils.debug_other_string(g_state_level,l_full_path,' l_cust_trx_id -->' || l_cust_trx_id );
257: -- ========================= FND LOG ===========================
258:
259: IF PSA_MFAR_VAL_PKG.AR_MFAR_VALIDATE_CHECK (l_cust_trx_id, 'TRX', p_sob_id) = 'Y' THEN
260: -- ========================= FND LOG ===========================

Line 261: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN Y' );

257: -- ========================= FND LOG ===========================
258:
259: IF PSA_MFAR_VAL_PKG.AR_MFAR_VALIDATE_CHECK (l_cust_trx_id, 'TRX', p_sob_id) = 'Y' THEN
260: -- ========================= FND LOG ===========================
261: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN Y' );
262: -- ========================= FND LOG ===========================
263: RETURN 'Y';
264: END IF;
265: -- ========================= FND LOG ===========================

Line 266: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN N ' );

262: -- ========================= FND LOG ===========================
263: RETURN 'Y';
264: END IF;
265: -- ========================= FND LOG ===========================
266: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN N ' );
267: -- ========================= FND LOG ===========================
268: RETURN 'N';
269:
270: EXCEPTION

Line 273: psa_utils.debug_other_string(g_excep_level,l_full_path,

269:
270: EXCEPTION
271: WHEN OTHERS THEN
272: -- ========================= FND LOG ===========================
273: psa_utils.debug_other_string(g_excep_level,l_full_path,
274: ' --> EXCEPTION - OTHERS raised during PSA_AR_GL_INTERFACE.is_mfar_transaction ');
275: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
276: psa_utils.debug_unexpected_msg(l_full_path);
277: -- ========================= FND LOG ===========================

Line 275: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);

271: WHEN OTHERS THEN
272: -- ========================= FND LOG ===========================
273: psa_utils.debug_other_string(g_excep_level,l_full_path,
274: ' --> EXCEPTION - OTHERS raised during PSA_AR_GL_INTERFACE.is_mfar_transaction ');
275: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
276: psa_utils.debug_unexpected_msg(l_full_path);
277: -- ========================= FND LOG ===========================
278: RETURN 'N';
279:

Line 276: psa_utils.debug_unexpected_msg(l_full_path);

272: -- ========================= FND LOG ===========================
273: psa_utils.debug_other_string(g_excep_level,l_full_path,
274: ' --> EXCEPTION - OTHERS raised during PSA_AR_GL_INTERFACE.is_mfar_transaction ');
275: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
276: psa_utils.debug_unexpected_msg(l_full_path);
277: -- ========================= FND LOG ===========================
278: RETURN 'N';
279:
280: END is_mfar_transaction;