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

Line 43: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

39: fnd_msg_pub.initialize;
40:
41: l_return_status := FND_API.g_ret_sts_success;
42:
43: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
44: THEN
45: fnd_log.string
46: (
47: fnd_log.level_procedure,

Line 45: fnd_log.string

41: l_return_status := FND_API.g_ret_sts_success;
42:
43: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
44: THEN
45: fnd_log.string
46: (
47: fnd_log.level_procedure,
48: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details.begin',
49: 'At the start of PLSQL procedure'

Line 47: fnd_log.level_procedure,

43: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
44: THEN
45: fnd_log.string
46: (
47: fnd_log.level_procedure,
48: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details.begin',
49: 'At the start of PLSQL procedure'
50: );
51: END IF;

Line 60: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

56: ,itemkey => itemkey
57: ,aname => 'OBJECT_ID'
58: );
59:
60: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
61: THEN
62: fnd_log.string
63: (
64: fnd_log.level_statement,

Line 62: fnd_log.string

58: );
59:
60: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
61: THEN
62: fnd_log.string
63: (
64: fnd_log.level_statement,
65: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
66: 'OBJECT_ID='||l_object_id

Line 64: fnd_log.level_statement,

60: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
61: THEN
62: fnd_log.string
63: (
64: fnd_log.level_statement,
65: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
66: 'OBJECT_ID='||l_object_id
67: );
68: END IF;

Line 87: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

83: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
84: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
85: fnd_message.set_token('NAME', l_mc_header_rec.NAME, false);
86: fnd_msg_pub.add;
87: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
88: THEN
89: fnd_log.message
90: (
91: fnd_log.level_exception,

Line 89: fnd_log.message

85: fnd_message.set_token('NAME', l_mc_header_rec.NAME, false);
86: fnd_msg_pub.add;
87: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
88: THEN
89: fnd_log.message
90: (
91: fnd_log.level_exception,
92: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
93: false

Line 91: fnd_log.level_exception,

87: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
88: THEN
89: fnd_log.message
90: (
91: fnd_log.level_exception,
92: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
93: false
94: );
95: END IF;

Line 113: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

109: ,aname => 'FORWARD_SUBJECT'
110: ,avalue => l_subject
111: );
112:
113: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
114: THEN
115: fnd_log.string
116: (
117: fnd_log.level_statement,

Line 115: fnd_log.string

111: );
112:
113: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
114: THEN
115: fnd_log.string
116: (
117: fnd_log.level_statement,
118: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
119: 'FORWARD_SUBJECT='||l_subject

Line 117: fnd_log.level_statement,

113: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
114: THEN
115: fnd_log.string
116: (
117: fnd_log.level_statement,
118: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
119: 'FORWARD_SUBJECT='||l_subject
120: );
121: END IF;

Line 136: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

132: ,aname => 'APPROVAL_SUBJECT'
133: ,avalue => l_subject
134: );
135:
136: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
137: THEN
138: fnd_log.string
139: (
140: fnd_log.level_statement,

Line 138: fnd_log.string

134: );
135:
136: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
137: THEN
138: fnd_log.string
139: (
140: fnd_log.level_statement,
141: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
142: 'APPROVAL_SUBJECT='||l_subject

Line 140: fnd_log.level_statement,

136: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
137: THEN
138: fnd_log.string
139: (
140: fnd_log.level_statement,
141: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
142: 'APPROVAL_SUBJECT='||l_subject
143: );
144: END IF;

Line 159: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

155: ,aname => 'REJECT_SUBJECT'
156: ,avalue => l_subject
157: );
158:
159: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
160: THEN
161: fnd_log.string
162: (
163: fnd_log.level_statement,

Line 161: fnd_log.string

157: );
158:
159: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
160: THEN
161: fnd_log.string
162: (
163: fnd_log.level_statement,
164: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
165: 'REJECT_SUBJECT='||l_subject

Line 163: fnd_log.level_statement,

159: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
160: THEN
161: fnd_log.string
162: (
163: fnd_log.level_statement,
164: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
165: 'REJECT_SUBJECT='||l_subject
166: );
167: END IF;

Line 182: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

178: ,aname => 'APPROVED_SUBJECT'
179: ,avalue => l_subject
180: );
181:
182: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
183: THEN
184: fnd_log.string
185: (
186: fnd_log.level_statement,

Line 184: fnd_log.string

180: );
181:
182: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
183: THEN
184: fnd_log.string
185: (
186: fnd_log.level_statement,
187: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
188: 'APPROVED_SUBJECT='||l_subject

Line 186: fnd_log.level_statement,

182: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
183: THEN
184: fnd_log.string
185: (
186: fnd_log.level_statement,
187: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
188: 'APPROVED_SUBJECT='||l_subject
189: );
190: END IF;

Line 205: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

201: ,aname => 'FINAL_SUBJECT'
202: ,avalue => l_subject
203: );
204:
205: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
206: THEN
207: fnd_log.string
208: (
209: fnd_log.level_statement,

Line 207: fnd_log.string

203: );
204:
205: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
206: THEN
207: fnd_log.string
208: (
209: fnd_log.level_statement,
210: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
211: 'FINAL_SUBJECT='||l_subject

Line 209: fnd_log.level_statement,

205: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
206: THEN
207: fnd_log.string
208: (
209: fnd_log.level_statement,
210: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
211: 'FINAL_SUBJECT='||l_subject
212: );
213: END IF;

Line 228: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

224: ,aname => 'REMIND_SUBJECT'
225: ,avalue => l_subject
226: );
227:
228: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
229: THEN
230: fnd_log.string
231: (
232: fnd_log.level_statement,

Line 230: fnd_log.string

226: );
227:
228: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
229: THEN
230: fnd_log.string
231: (
232: fnd_log.level_statement,
233: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
234: 'REMIND_SUBJECT='||l_subject

Line 232: fnd_log.level_statement,

228: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
229: THEN
230: fnd_log.string
231: (
232: fnd_log.level_statement,
233: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
234: 'REMIND_SUBJECT='||l_subject
235: );
236: END IF;

Line 251: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

247: ,aname => 'ERROR_SUBJECT'
248: ,avalue => l_subject
249: );
250:
251: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
252: THEN
253: fnd_log.string
254: (
255: fnd_log.level_statement,

Line 253: fnd_log.string

249: );
250:
251: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
252: THEN
253: fnd_log.string
254: (
255: fnd_log.level_statement,
256: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
257: 'ERROR_SUBJECT='||l_subject

Line 255: fnd_log.level_statement,

251: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
252: THEN
253: fnd_log.string
254: (
255: fnd_log.level_statement,
256: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
257: 'ERROR_SUBJECT='||l_subject
258: );
259: END IF;

Line 261: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

257: 'ERROR_SUBJECT='||l_subject
258: );
259: END IF;
260:
261: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
262: THEN
263: fnd_log.string
264: (
265: fnd_log.level_statement,

Line 263: fnd_log.string

259: END IF;
260:
261: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
262: THEN
263: fnd_log.string
264: (
265: fnd_log.level_statement,
266: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
267: 'Calling AHL_GENERIC_APRV_PVT.GET_APPROVAL_DETAILS'

Line 265: fnd_log.level_statement,

261: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
262: THEN
263: fnd_log.string
264: (
265: fnd_log.level_statement,
266: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
267: 'Calling AHL_GENERIC_APRV_PVT.GET_APPROVAL_DETAILS'
268: );
269: END IF;

Line 291: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

287: aname => 'RULE_ID',
288: avalue => l_approval_rule_id
289: );
290:
291: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
292: THEN
293: fnd_log.string
294: (
295: fnd_log.level_statement,

Line 293: fnd_log.string

289: );
290:
291: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
292: THEN
293: fnd_log.string
294: (
295: fnd_log.level_statement,
296: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
297: 'RULE_ID='||l_approval_rule_id

Line 295: fnd_log.level_statement,

291: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
292: THEN
293: fnd_log.string
294: (
295: fnd_log.level_statement,
296: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
297: 'RULE_ID='||l_approval_rule_id
298: );
299: END IF;

Line 309: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

305: aname => 'APPROVER_SEQ',
306: avalue => l_approver_seq
307: );
308:
309: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
310: THEN
311: fnd_log.string
312: (
313: fnd_log.level_statement,

Line 311: fnd_log.string

307: );
308:
309: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
310: THEN
311: fnd_log.string
312: (
313: fnd_log.level_statement,
314: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
315: 'APPROVER_SEQ='||l_approver_seq

Line 313: fnd_log.level_statement,

309: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
310: THEN
311: fnd_log.string
312: (
313: fnd_log.level_statement,
314: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
315: 'APPROVER_SEQ='||l_approver_seq
316: );
317: END IF;

Line 347: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

343: resultout := 'COMPLETE:';
344: RETURN;
345: END IF;
346:
347: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
348: THEN
349: fnd_log.string
350: (
351: fnd_log.level_procedure,

Line 349: fnd_log.string

345: END IF;
346:
347: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
348: THEN
349: fnd_log.string
350: (
351: fnd_log.level_procedure,
352: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details.end',
353: 'At the end of PLSQL procedure'

Line 351: fnd_log.level_procedure,

347: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
348: THEN
349: fnd_log.string
350: (
351: fnd_log.level_procedure,
352: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details.end',
353: 'At the end of PLSQL procedure'
354: );
355: END IF;

Line 374: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

370: p_msg_data => l_msg_data ,
371: p_attr_name => 'ERROR_MSG',
372: x_error_msg => l_error_msg
373: );
374: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
375: THEN
376: fnd_log.string
377: (
378: fnd_log.level_exception,

Line 376: fnd_log.string

372: x_error_msg => l_error_msg
373: );
374: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
375: THEN
376: fnd_log.string
377: (
378: fnd_log.level_exception,
379: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
380: l_error_msg

Line 378: fnd_log.level_exception,

374: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
375: THEN
376: fnd_log.string
377: (
378: fnd_log.level_exception,
379: 'ahl.plsql.AHL_MC_Approvals_PVT.Set_Activity_Details',
380: l_error_msg
381: );
382: END IF;

Line 434: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

430: l_mc_header_rec check_mc_exists%rowtype;
431:
432: BEGIN
433:
434: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
435: THEN
436: fnd_log.string
437: (
438: fnd_log.level_procedure,

Line 436: fnd_log.string

432: BEGIN
433:
434: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
435: THEN
436: fnd_log.string
437: (
438: fnd_log.level_procedure,
439: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FORWARD_FYI.begin',
440: 'At the start of PLSQL procedure'

Line 438: fnd_log.level_procedure,

434: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
435: THEN
436: fnd_log.string
437: (
438: fnd_log.level_procedure,
439: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FORWARD_FYI.begin',
440: 'At the start of PLSQL procedure'
441: );
442: END IF;

Line 484: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

480: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
481: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
482: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
483: fnd_msg_pub.add;
484: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
485: THEN
486: fnd_log.message
487: (
488: fnd_log.level_exception,

Line 486: fnd_log.message

482: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
483: fnd_msg_pub.add;
484: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
485: THEN
486: fnd_log.message
487: (
488: fnd_log.level_exception,
489: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FORWARD_FYI',
490: false

Line 488: fnd_log.level_exception,

484: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
485: THEN
486: fnd_log.message
487: (
488: fnd_log.level_exception,
489: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FORWARD_FYI',
490: false
491: );
492: END IF;

Line 505: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

501: CLOSE check_mc_exists;
502:
503: document := document || l_body;
504:
505: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
506: THEN
507: fnd_log.string
508: (
509: fnd_log.level_statement,

Line 507: fnd_log.string

503: document := document || l_body;
504:
505: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
506: THEN
507: fnd_log.string
508: (
509: fnd_log.level_statement,
510: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FORWARD_FYI',
511: 'document='||document

Line 509: fnd_log.level_statement,

505: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
506: THEN
507: fnd_log.string
508: (
509: fnd_log.level_statement,
510: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FORWARD_FYI',
511: 'document='||document
512: );
513:

Line 514: fnd_log.string

510: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FORWARD_FYI',
511: 'document='||document
512: );
513:
514: fnd_log.string
515: (
516: fnd_log.level_statement,
517: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FORWARD_FYI.end',
518: 'At the end of PLSQL procedure'

Line 516: fnd_log.level_statement,

512: );
513:
514: fnd_log.string
515: (
516: fnd_log.level_statement,
517: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FORWARD_FYI.end',
518: 'At the end of PLSQL procedure'
519: );
520: END IF;

Line 541: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

537: p_msg_data => l_msg_data ,
538: p_attr_name => 'ERROR_MSG',
539: x_error_msg => l_error_msg
540: );
541: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
542: THEN
543: fnd_log.string
544: (
545: fnd_log.level_exception,

Line 543: fnd_log.string

539: x_error_msg => l_error_msg
540: );
541: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
542: THEN
543: fnd_log.string
544: (
545: fnd_log.level_exception,
546: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FORWARD_FYI',
547: l_error_msg

Line 545: fnd_log.level_exception,

541: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
542: THEN
543: fnd_log.string
544: (
545: fnd_log.level_exception,
546: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FORWARD_FYI',
547: l_error_msg
548: );
549: END IF;

Line 596: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

592: l_mc_header_rec check_mc_exists%rowtype;
593:
594: BEGIN
595:
596: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
597: THEN
598: fnd_log.string
599: (
600: fnd_log.level_procedure,

Line 598: fnd_log.string

594: BEGIN
595:
596: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
597: THEN
598: fnd_log.string
599: (
600: fnd_log.level_procedure,
601: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVED_FYI.begin',
602: 'At the start of PLSQL procedure'

Line 600: fnd_log.level_procedure,

596: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
597: THEN
598: fnd_log.string
599: (
600: fnd_log.level_procedure,
601: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVED_FYI.begin',
602: 'At the start of PLSQL procedure'
603: );
604: END IF;

Line 646: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

642: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
643: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
644: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
645: fnd_msg_pub.add;
646: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
647: THEN
648: fnd_log.message
649: (
650: fnd_log.level_exception,

Line 648: fnd_log.message

644: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
645: fnd_msg_pub.add;
646: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
647: THEN
648: fnd_log.message
649: (
650: fnd_log.level_exception,
651: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVED_FYI',
652: false

Line 650: fnd_log.level_exception,

646: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
647: THEN
648: fnd_log.message
649: (
650: fnd_log.level_exception,
651: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVED_FYI',
652: false
653: );
654: END IF;

Line 667: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

663: CLOSE check_mc_exists;
664:
665: document := document || l_body;
666:
667: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
668: THEN
669: fnd_log.string
670: (
671: fnd_log.level_statement,

Line 669: fnd_log.string

665: document := document || l_body;
666:
667: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
668: THEN
669: fnd_log.string
670: (
671: fnd_log.level_statement,
672: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVED_FYI',
673: 'document='||document

Line 671: fnd_log.level_statement,

667: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
668: THEN
669: fnd_log.string
670: (
671: fnd_log.level_statement,
672: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVED_FYI',
673: 'document='||document
674: );
675:

Line 676: fnd_log.string

672: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVED_FYI',
673: 'document='||document
674: );
675:
676: fnd_log.string
677: (
678: fnd_log.level_statement,
679: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVED_FYI.end',
680: 'At the end of PLSQL procedure'

Line 678: fnd_log.level_statement,

674: );
675:
676: fnd_log.string
677: (
678: fnd_log.level_statement,
679: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVED_FYI.end',
680: 'At the end of PLSQL procedure'
681: );
682: END IF;

Line 703: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

699: p_msg_data => l_msg_data ,
700: p_attr_name => 'ERROR_MSG',
701: x_error_msg => l_error_msg
702: );
703: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
704: THEN
705: fnd_log.string
706: (
707: fnd_log.level_exception,

Line 705: fnd_log.string

701: x_error_msg => l_error_msg
702: );
703: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
704: THEN
705: fnd_log.string
706: (
707: fnd_log.level_exception,
708: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVED_FYI',
709: l_error_msg

Line 707: fnd_log.level_exception,

703: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
704: THEN
705: fnd_log.string
706: (
707: fnd_log.level_exception,
708: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVED_FYI',
709: l_error_msg
710: );
711: END IF;

Line 756: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

752: l_mc_header_rec check_mc_exists%rowtype;
753:
754: BEGIN
755:
756: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
757: THEN
758: fnd_log.string
759: (
760: fnd_log.level_procedure,

Line 758: fnd_log.string

754: BEGIN
755:
756: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
757: THEN
758: fnd_log.string
759: (
760: fnd_log.level_procedure,
761: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FINAL_APPROVAL_FYI.begin',
762: 'At the start of PLSQL procedure'

Line 760: fnd_log.level_procedure,

756: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
757: THEN
758: fnd_log.string
759: (
760: fnd_log.level_procedure,
761: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FINAL_APPROVAL_FYI.begin',
762: 'At the start of PLSQL procedure'
763: );
764: END IF;

Line 799: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

795: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
796: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
797: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
798: fnd_msg_pub.add;
799: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
800: THEN
801: fnd_log.message
802: (
803: fnd_log.level_exception,

Line 801: fnd_log.message

797: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
798: fnd_msg_pub.add;
799: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
800: THEN
801: fnd_log.message
802: (
803: fnd_log.level_exception,
804: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FINAL_APPROVAL_FYI',
805: false

Line 803: fnd_log.level_exception,

799: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
800: THEN
801: fnd_log.message
802: (
803: fnd_log.level_exception,
804: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FINAL_APPROVAL_FYI',
805: false
806: );
807: END IF;

Line 819: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

815: CLOSE check_mc_exists;
816:
817: document := document || l_body;
818:
819: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
820: THEN
821: fnd_log.string
822: (
823: fnd_log.level_statement,

Line 821: fnd_log.string

817: document := document || l_body;
818:
819: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
820: THEN
821: fnd_log.string
822: (
823: fnd_log.level_statement,
824: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FINAL_APPROVAL_FYI',
825: 'document='||document

Line 823: fnd_log.level_statement,

819: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
820: THEN
821: fnd_log.string
822: (
823: fnd_log.level_statement,
824: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FINAL_APPROVAL_FYI',
825: 'document='||document
826: );
827:

Line 828: fnd_log.string

824: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FINAL_APPROVAL_FYI',
825: 'document='||document
826: );
827:
828: fnd_log.string
829: (
830: fnd_log.level_statement,
831: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FINAL_APPROVAL_FYI.end',
832: 'At the end of PLSQL procedure'

Line 830: fnd_log.level_statement,

826: );
827:
828: fnd_log.string
829: (
830: fnd_log.level_statement,
831: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FINAL_APPROVAL_FYI.end',
832: 'At the end of PLSQL procedure'
833: );
834: END IF;

Line 855: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

851: p_msg_data => l_msg_data ,
852: p_attr_name => 'ERROR_MSG',
853: x_error_msg => l_error_msg
854: );
855: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
856: THEN
857: fnd_log.string
858: (
859: fnd_log.level_exception,

Line 857: fnd_log.string

853: x_error_msg => l_error_msg
854: );
855: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
856: THEN
857: fnd_log.string
858: (
859: fnd_log.level_exception,
860: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FINAL_APPROVAL_FYI',
861: l_error_msg

Line 859: fnd_log.level_exception,

855: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
856: THEN
857: fnd_log.string
858: (
859: fnd_log.level_exception,
860: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_FINAL_APPROVAL_FYI',
861: l_error_msg
862: );
863: END IF;

Line 910: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

906: l_mc_header_rec check_mc_exists%rowtype;
907:
908: BEGIN
909:
910: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
911: THEN
912: fnd_log.string
913: (
914: fnd_log.level_procedure,

Line 912: fnd_log.string

908: BEGIN
909:
910: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
911: THEN
912: fnd_log.string
913: (
914: fnd_log.level_procedure,
915: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_REJECTED_FYI.begin',
916: 'At the start of PLSQL procedure'

Line 914: fnd_log.level_procedure,

910: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
911: THEN
912: fnd_log.string
913: (
914: fnd_log.level_procedure,
915: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_REJECTED_FYI.begin',
916: 'At the start of PLSQL procedure'
917: );
918: END IF;

Line 960: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

956: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
957: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
958: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
959: fnd_msg_pub.add;
960: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
961: THEN
962: fnd_log.message
963: (
964: fnd_log.level_exception,

Line 962: fnd_log.message

958: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
959: fnd_msg_pub.add;
960: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
961: THEN
962: fnd_log.message
963: (
964: fnd_log.level_exception,
965: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_REJECTED_FYI',
966: false

Line 964: fnd_log.level_exception,

960: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
961: THEN
962: fnd_log.message
963: (
964: fnd_log.level_exception,
965: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_REJECTED_FYI',
966: false
967: );
968: END IF;

Line 981: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

977: CLOSE check_mc_exists;
978:
979: document := document || l_body;
980:
981: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
982: THEN
983: fnd_log.string
984: (
985: fnd_log.level_statement,

Line 983: fnd_log.string

979: document := document || l_body;
980:
981: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
982: THEN
983: fnd_log.string
984: (
985: fnd_log.level_statement,
986: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_REJECTED_FYI',
987: 'document='||document

Line 985: fnd_log.level_statement,

981: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
982: THEN
983: fnd_log.string
984: (
985: fnd_log.level_statement,
986: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_REJECTED_FYI',
987: 'document='||document
988: );
989:

Line 990: fnd_log.string

986: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_REJECTED_FYI',
987: 'document='||document
988: );
989:
990: fnd_log.string
991: (
992: fnd_log.level_statement,
993: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_REJECTED_FYI.end',
994: 'At the end of PLSQL procedure'

Line 992: fnd_log.level_statement,

988: );
989:
990: fnd_log.string
991: (
992: fnd_log.level_statement,
993: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_REJECTED_FYI.end',
994: 'At the end of PLSQL procedure'
995: );
996: END IF;

Line 1017: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

1013: p_msg_data => l_msg_data ,
1014: p_attr_name => 'ERROR_MSG',
1015: x_error_msg => l_error_msg
1016: );
1017: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1018: THEN
1019: fnd_log.string
1020: (
1021: fnd_log.level_exception,

Line 1019: fnd_log.string

1015: x_error_msg => l_error_msg
1016: );
1017: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1018: THEN
1019: fnd_log.string
1020: (
1021: fnd_log.level_exception,
1022: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_REJECTED_FYI',
1023: l_error_msg

Line 1021: fnd_log.level_exception,

1017: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1018: THEN
1019: fnd_log.string
1020: (
1021: fnd_log.level_exception,
1022: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_REJECTED_FYI',
1023: l_error_msg
1024: );
1025: END IF;

Line 1071: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1067: l_mc_header_rec check_mc_exists%rowtype;
1068:
1069: BEGIN
1070:
1071: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1072: THEN
1073: fnd_log.string
1074: (
1075: fnd_log.level_procedure,

Line 1073: fnd_log.string

1069: BEGIN
1070:
1071: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1072: THEN
1073: fnd_log.string
1074: (
1075: fnd_log.level_procedure,
1076: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVAL.begin',
1077: 'At the start of PLSQL procedure'

Line 1075: fnd_log.level_procedure,

1071: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1072: THEN
1073: fnd_log.string
1074: (
1075: fnd_log.level_procedure,
1076: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVAL.begin',
1077: 'At the start of PLSQL procedure'
1078: );
1079: END IF;

Line 1129: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

1125: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
1126: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
1127: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1128: fnd_msg_pub.add;
1129: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1130: THEN
1131: fnd_log.message
1132: (
1133: fnd_log.level_exception,

Line 1131: fnd_log.message

1127: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1128: fnd_msg_pub.add;
1129: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1130: THEN
1131: fnd_log.message
1132: (
1133: fnd_log.level_exception,
1134: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVAL',
1135: false

Line 1133: fnd_log.level_exception,

1129: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1130: THEN
1131: fnd_log.message
1132: (
1133: fnd_log.level_exception,
1134: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVAL',
1135: false
1136: );
1137: END IF;

Line 1151: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1147: CLOSE check_mc_exists;
1148:
1149: document := document || l_body;
1150:
1151: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1152: THEN
1153: fnd_log.string
1154: (
1155: fnd_log.level_statement,

Line 1153: fnd_log.string

1149: document := document || l_body;
1150:
1151: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1152: THEN
1153: fnd_log.string
1154: (
1155: fnd_log.level_statement,
1156: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVAL_FYI',
1157: 'document='||document

Line 1155: fnd_log.level_statement,

1151: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1152: THEN
1153: fnd_log.string
1154: (
1155: fnd_log.level_statement,
1156: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVAL_FYI',
1157: 'document='||document
1158: );
1159:

Line 1160: fnd_log.string

1156: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVAL_FYI',
1157: 'document='||document
1158: );
1159:
1160: fnd_log.string
1161: (
1162: fnd_log.level_statement,
1163: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVAL_FYI.end',
1164: 'At the end of PLSQL procedure'

Line 1162: fnd_log.level_statement,

1158: );
1159:
1160: fnd_log.string
1161: (
1162: fnd_log.level_statement,
1163: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVAL_FYI.end',
1164: 'At the end of PLSQL procedure'
1165: );
1166: END IF;

Line 1187: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

1183: p_msg_data => l_msg_data ,
1184: p_attr_name => 'ERROR_MSG',
1185: x_error_msg => l_error_msg
1186: );
1187: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1188: THEN
1189: fnd_log.string
1190: (
1191: fnd_log.level_exception,

Line 1189: fnd_log.string

1185: x_error_msg => l_error_msg
1186: );
1187: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1188: THEN
1189: fnd_log.string
1190: (
1191: fnd_log.level_exception,
1192: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_REJECTED_FYI',
1193: l_error_msg

Line 1191: fnd_log.level_exception,

1187: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1188: THEN
1189: fnd_log.string
1190: (
1191: fnd_log.level_exception,
1192: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_REJECTED_FYI',
1193: l_error_msg
1194: );
1195: END IF;

Line 1241: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1237: l_mc_header_rec check_mc_exists%rowtype;
1238:
1239: BEGIN
1240:
1241: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1242: THEN
1243: fnd_log.string
1244: (
1245: fnd_log.level_procedure,

Line 1243: fnd_log.string

1239: BEGIN
1240:
1241: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1242: THEN
1243: fnd_log.string
1244: (
1245: fnd_log.level_procedure,
1246: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVAL_REMINDER.begin',
1247: 'At the start of PLSQL procedure'

Line 1245: fnd_log.level_procedure,

1241: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1242: THEN
1243: fnd_log.string
1244: (
1245: fnd_log.level_procedure,
1246: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVAL_REMINDER.begin',
1247: 'At the start of PLSQL procedure'
1248: );
1249: END IF;

Line 1299: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

1295: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
1296: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
1297: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1298: fnd_msg_pub.add;
1299: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1300: THEN
1301: fnd_log.message
1302: (
1303: fnd_log.level_exception,

Line 1301: fnd_log.message

1297: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1298: fnd_msg_pub.add;
1299: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1300: THEN
1301: fnd_log.message
1302: (
1303: fnd_log.level_exception,
1304: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVAL_REMINDER',
1305: false

Line 1303: fnd_log.level_exception,

1299: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1300: THEN
1301: fnd_log.message
1302: (
1303: fnd_log.level_exception,
1304: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVAL_REMINDER',
1305: false
1306: );
1307: END IF;

Line 1321: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1317: CLOSE check_mc_exists;
1318:
1319: document := document || l_body;
1320:
1321: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1322: THEN
1323: fnd_log.string
1324: (
1325: fnd_log.level_statement,

Line 1323: fnd_log.string

1319: document := document || l_body;
1320:
1321: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1322: THEN
1323: fnd_log.string
1324: (
1325: fnd_log.level_statement,
1326: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVAL_REMINDER',
1327: 'document='||document

Line 1325: fnd_log.level_statement,

1321: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1322: THEN
1323: fnd_log.string
1324: (
1325: fnd_log.level_statement,
1326: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVAL_REMINDER',
1327: 'document='||document
1328: );
1329:

Line 1330: fnd_log.string

1326: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVAL_REMINDER',
1327: 'document='||document
1328: );
1329:
1330: fnd_log.string
1331: (
1332: fnd_log.level_statement,
1333: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVAL_REMINDER.end',
1334: 'At the end of PLSQL procedure'

Line 1332: fnd_log.level_statement,

1328: );
1329:
1330: fnd_log.string
1331: (
1332: fnd_log.level_statement,
1333: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVAL_REMINDER.end',
1334: 'At the end of PLSQL procedure'
1335: );
1336: END IF;

Line 1357: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

1353: p_msg_data => l_msg_data ,
1354: p_attr_name => 'ERROR_MSG',
1355: x_error_msg => l_error_msg
1356: );
1357: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1358: THEN
1359: fnd_log.string
1360: (
1361: fnd_log.level_exception,

Line 1359: fnd_log.string

1355: x_error_msg => l_error_msg
1356: );
1357: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1358: THEN
1359: fnd_log.string
1360: (
1361: fnd_log.level_exception,
1362: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVAL_REMINDER',
1363: l_error_msg

Line 1361: fnd_log.level_exception,

1357: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1358: THEN
1359: fnd_log.string
1360: (
1361: fnd_log.level_exception,
1362: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_APPROVAL_REMINDER',
1363: l_error_msg
1364: );
1365: END IF;

Line 1409: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1405: l_mc_header_rec check_mc_exists%rowtype;
1406:
1407: BEGIN
1408:
1409: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1410: THEN
1411: fnd_log.string
1412: (
1413: fnd_log.level_procedure,

Line 1411: fnd_log.string

1407: BEGIN
1408:
1409: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1410: THEN
1411: fnd_log.string
1412: (
1413: fnd_log.level_procedure,
1414: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_ERROR_ACT.begin',
1415: 'At the start of PLSQL procedure'

Line 1413: fnd_log.level_procedure,

1409: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1410: THEN
1411: fnd_log.string
1412: (
1413: fnd_log.level_procedure,
1414: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_ERROR_ACT.begin',
1415: 'At the start of PLSQL procedure'
1416: );
1417: END IF;

Line 1459: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

1455: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
1456: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
1457: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1458: fnd_msg_pub.add;
1459: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1460: THEN
1461: fnd_log.message
1462: (
1463: fnd_log.level_exception,

Line 1461: fnd_log.message

1457: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1458: fnd_msg_pub.add;
1459: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1460: THEN
1461: fnd_log.message
1462: (
1463: fnd_log.level_exception,
1464: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_ERROR_ACT',
1465: false

Line 1463: fnd_log.level_exception,

1459: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1460: THEN
1461: fnd_log.message
1462: (
1463: fnd_log.level_exception,
1464: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_ERROR_ACT',
1465: false
1466: );
1467: END IF;

Line 1480: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1476: CLOSE check_mc_exists;
1477:
1478: document := document || l_body;
1479:
1480: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1481: THEN
1482: fnd_log.string
1483: (
1484: fnd_log.level_statement,

Line 1482: fnd_log.string

1478: document := document || l_body;
1479:
1480: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1481: THEN
1482: fnd_log.string
1483: (
1484: fnd_log.level_statement,
1485: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_ERROR_ACT',
1486: 'document='||document

Line 1484: fnd_log.level_statement,

1480: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1481: THEN
1482: fnd_log.string
1483: (
1484: fnd_log.level_statement,
1485: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_ERROR_ACT',
1486: 'document='||document
1487: );
1488:

Line 1489: fnd_log.string

1485: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_ERROR_ACT',
1486: 'document='||document
1487: );
1488:
1489: fnd_log.string
1490: (
1491: fnd_log.level_statement,
1492: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_ERROR_ACT.end',
1493: 'At the end of PLSQL procedure'

Line 1491: fnd_log.level_statement,

1487: );
1488:
1489: fnd_log.string
1490: (
1491: fnd_log.level_statement,
1492: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_ERROR_ACT.end',
1493: 'At the end of PLSQL procedure'
1494: );
1495: END IF;

Line 1516: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

1512: p_msg_data => l_msg_data ,
1513: p_attr_name => 'ERROR_MSG',
1514: x_error_msg => l_error_msg
1515: );
1516: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1517: THEN
1518: fnd_log.string
1519: (
1520: fnd_log.level_exception,

Line 1518: fnd_log.string

1514: x_error_msg => l_error_msg
1515: );
1516: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1517: THEN
1518: fnd_log.string
1519: (
1520: fnd_log.level_exception,
1521: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_ERROR_ACT',
1522: l_error_msg

Line 1520: fnd_log.level_exception,

1516: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1517: THEN
1518: fnd_log.string
1519: (
1520: fnd_log.level_exception,
1521: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_ERROR_ACT',
1522: l_error_msg
1523: );
1524: END IF;

Line 1568: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1564: l_mc_header_rec check_mc_exists%ROWTYPE;
1565:
1566: BEGIN
1567:
1568: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1569: THEN
1570: fnd_log.string
1571: (
1572: fnd_log.level_procedure,

Line 1570: fnd_log.string

1566: BEGIN
1567:
1568: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1569: THEN
1570: fnd_log.string
1571: (
1572: fnd_log.level_procedure,
1573: 'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS.begin',
1574: 'At the start of PLSQL procedure'

Line 1572: fnd_log.level_procedure,

1568: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1569: THEN
1570: fnd_log.string
1571: (
1572: fnd_log.level_procedure,
1573: 'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS.begin',
1574: 'At the start of PLSQL procedure'
1575: );
1576: END IF;

Line 1604: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1600: ,itemkey => itemkey
1601: ,aname => 'OBJECT_ID'
1602: );
1603:
1604: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1605: THEN
1606: fnd_log.string
1607: (
1608: fnd_log.level_statement,

Line 1606: fnd_log.string

1602: );
1603:
1604: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1605: THEN
1606: fnd_log.string
1607: (
1608: fnd_log.level_statement,
1609: 'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS',
1610: 'UPDATE_GEN_STATUS='||l_next_status||' -- OBJECT_VER='||l_object_version_number|| ' -- OBJECT_ID='||l_object_id

Line 1608: fnd_log.level_statement,

1604: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1605: THEN
1606: fnd_log.string
1607: (
1608: fnd_log.level_statement,
1609: 'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS',
1610: 'UPDATE_GEN_STATUS='||l_next_status||' -- OBJECT_VER='||l_object_version_number|| ' -- OBJECT_ID='||l_object_id
1611: );
1612: END IF;

Line 1623: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

1619: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
1620: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
1621: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1622: fnd_msg_pub.add;
1623: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1624: THEN
1625: fnd_log.message
1626: (
1627: fnd_log.level_exception,

Line 1625: fnd_log.message

1621: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1622: fnd_msg_pub.add;
1623: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1624: THEN
1625: fnd_log.message
1626: (
1627: fnd_log.level_exception,
1628: 'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS',
1629: false

Line 1627: fnd_log.level_exception,

1623: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1624: THEN
1625: fnd_log.message
1626: (
1627: fnd_log.level_exception,
1628: 'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS',
1629: false
1630: );
1631: END IF;

Line 1644: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1640: last_updated_by = to_number(fnd_global.login_id),
1641: last_update_login = to_number(fnd_global.login_id)
1642: WHERE mc_header_id = l_object_id;
1643:
1644: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1645: THEN
1646: fnd_log.string
1647: (
1648: fnd_log.level_statement,

Line 1646: fnd_log.string

1642: WHERE mc_header_id = l_object_id;
1643:
1644: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1645: THEN
1646: fnd_log.string
1647: (
1648: fnd_log.level_statement,
1649: 'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS',
1650: 'Successfully completed the MC with mc_header_id='||l_object_id

Line 1648: fnd_log.level_statement,

1644: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1645: THEN
1646: fnd_log.string
1647: (
1648: fnd_log.level_statement,
1649: 'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS',
1650: 'Successfully completed the MC with mc_header_id='||l_object_id
1651: );
1652: END IF;

Line 1676: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1672: resultout := 'COMPLETE:';
1673: RETURN;
1674: END IF;
1675:
1676: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1677: THEN
1678: fnd_log.string
1679: (
1680: fnd_log.level_procedure,

Line 1678: fnd_log.string

1674: END IF;
1675:
1676: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1677: THEN
1678: fnd_log.string
1679: (
1680: fnd_log.level_procedure,
1681: 'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS.end',
1682: 'At the end of PLSQL procedure'

Line 1680: fnd_log.level_procedure,

1676: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1677: THEN
1678: fnd_log.string
1679: (
1680: fnd_log.level_procedure,
1681: 'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS.end',
1682: 'At the end of PLSQL procedure'
1683: );
1684: END IF;

Line 1703: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

1699: p_msg_data => l_msg_data ,
1700: p_attr_name => 'ERROR_MSG',
1701: x_error_msg => l_error_msg
1702: );
1703: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1704: THEN
1705: fnd_log.string
1706: (
1707: fnd_log.level_exception,

Line 1705: fnd_log.string

1701: x_error_msg => l_error_msg
1702: );
1703: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1704: THEN
1705: fnd_log.string
1706: (
1707: fnd_log.level_exception,
1708: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_REJECTED_FYI',
1709: l_error_msg

Line 1707: fnd_log.level_exception,

1703: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1704: THEN
1705: fnd_log.string
1706: (
1707: fnd_log.level_exception,
1708: 'ahl.plsql.AHL_MC_Approvals_PVT.NTF_REJECTED_FYI',
1709: l_error_msg
1710: );
1711: END IF;

Line 1761: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1757: l_mc_header_rec check_mc_exists%rowtype;
1758:
1759: BEGIN
1760:
1761: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1762: THEN
1763: fnd_log.string
1764: (
1765: fnd_log.level_procedure,

Line 1763: fnd_log.string

1759: BEGIN
1760:
1761: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1762: THEN
1763: fnd_log.string
1764: (
1765: fnd_log.level_procedure,
1766: 'ahl.plsql.AHL_MC_Approvals_PVT.REVERT_STATUS.begin',
1767: 'At the start of PLSQL procedure'

Line 1765: fnd_log.level_procedure,

1761: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1762: THEN
1763: fnd_log.string
1764: (
1765: fnd_log.level_procedure,
1766: 'ahl.plsql.AHL_MC_Approvals_PVT.REVERT_STATUS.begin',
1767: 'At the start of PLSQL procedure'
1768: );
1769: END IF;

Line 1796: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1792: ,itemkey => itemkey
1793: ,aname => 'OBJECT_ID'
1794: );
1795:
1796: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1797: THEN
1798: fnd_log.string
1799: (
1800: fnd_log.level_statement,

Line 1798: fnd_log.string

1794: );
1795:
1796: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1797: THEN
1798: fnd_log.string
1799: (
1800: fnd_log.level_statement,
1801: 'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS',
1802: 'ORG_STATUS_ID='||l_next_status||' -- OBJECT_VER='||l_object_version_number|| ' -- OBJECT_ID='||l_object_id

Line 1800: fnd_log.level_statement,

1796: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1797: THEN
1798: fnd_log.string
1799: (
1800: fnd_log.level_statement,
1801: 'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS',
1802: 'ORG_STATUS_ID='||l_next_status||' -- OBJECT_VER='||l_object_version_number|| ' -- OBJECT_ID='||l_object_id
1803: );
1804: END IF;

Line 1815: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

1811: fnd_message.set_name('AHL', 'AHL_MC_HEADER_ID_INVALID');
1812: fnd_message.set_token('MC_HEADER_ID',l_mc_header_rec.mc_header_id,false);
1813: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1814: fnd_msg_pub.add;
1815: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1816: THEN
1817: fnd_log.message
1818: (
1819: fnd_log.level_exception,

Line 1817: fnd_log.message

1813: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
1814: fnd_msg_pub.add;
1815: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1816: THEN
1817: fnd_log.message
1818: (
1819: fnd_log.level_exception,
1820: 'ahl.plsql.AHL_MC_Approvals_PVT.REVERT_STATUS',
1821: false

Line 1819: fnd_log.level_exception,

1815: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1816: THEN
1817: fnd_log.message
1818: (
1819: fnd_log.level_exception,
1820: 'ahl.plsql.AHL_MC_Approvals_PVT.REVERT_STATUS',
1821: false
1822: );
1823: END IF;

Line 1836: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1832: last_updated_by = to_number(fnd_global.login_id),
1833: last_update_login = to_number(fnd_global.login_id)
1834: WHERE mc_header_id = l_object_id;
1835:
1836: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1837: THEN
1838: fnd_log.string
1839: (
1840: fnd_log.level_statement,

Line 1838: fnd_log.string

1834: WHERE mc_header_id = l_object_id;
1835:
1836: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1837: THEN
1838: fnd_log.string
1839: (
1840: fnd_log.level_statement,
1841: 'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS',
1842: 'Successfully reverted status of the MC with mc_header_id='||l_object_id

Line 1840: fnd_log.level_statement,

1836: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1837: THEN
1838: fnd_log.string
1839: (
1840: fnd_log.level_statement,
1841: 'ahl.plsql.AHL_MC_Approvals_PVT.UPDATE_STATUS',
1842: 'Successfully reverted status of the MC with mc_header_id='||l_object_id
1843: );
1844: END IF;

Line 1868: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1864: resultout := 'COMPLETE:';
1865: RETURN;
1866: END IF;
1867:
1868: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1869: THEN
1870: fnd_log.string
1871: (
1872: fnd_log.level_procedure,

Line 1870: fnd_log.string

1866: END IF;
1867:
1868: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1869: THEN
1870: fnd_log.string
1871: (
1872: fnd_log.level_procedure,
1873: 'ahl.plsql.AHL_MC_Approvals_PVT.REVERT_STATUS.end',
1874: 'At the end of PLSQL procedure'

Line 1872: fnd_log.level_procedure,

1868: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1869: THEN
1870: fnd_log.string
1871: (
1872: fnd_log.level_procedure,
1873: 'ahl.plsql.AHL_MC_Approvals_PVT.REVERT_STATUS.end',
1874: 'At the end of PLSQL procedure'
1875: );
1876: END IF;

Line 1895: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

1891: p_msg_data => l_msg_data ,
1892: p_attr_name => 'ERROR_MSG',
1893: x_error_msg => l_error_msg
1894: );
1895: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1896: THEN
1897: fnd_log.string
1898: (
1899: fnd_log.level_exception,

Line 1897: fnd_log.string

1893: x_error_msg => l_error_msg
1894: );
1895: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1896: THEN
1897: fnd_log.string
1898: (
1899: fnd_log.level_exception,
1900: 'ahl.plsql.AHL_MC_Approvals_PVT.REVERT_STATUS',
1901: l_error_msg

Line 1899: fnd_log.level_exception,

1895: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1896: THEN
1897: fnd_log.string
1898: (
1899: fnd_log.level_exception,
1900: 'ahl.plsql.AHL_MC_Approvals_PVT.REVERT_STATUS',
1901: l_error_msg
1902: );
1903: END IF;