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.ASO_APR_INT dependencies on ASO_DEBUG_PUB

Line 41: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

37: end_date_active,
38: SYSDATE
39: );
40: BEGIN
41: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
42: aso_debug_pub.ADD (
43: 'Begin Get approver name function ',
44: 1,
45: 'N'

Line 42: aso_debug_pub.ADD (

38: SYSDATE
39: );
40: BEGIN
41: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
42: aso_debug_pub.ADD (
43: 'Begin Get approver name function ',
44: 1,
45: 'N'
46: );

Line 47: aso_debug_pub.ADD (

43: 'Begin Get approver name function ',
44: 1,
45: 'N'
46: );
47: aso_debug_pub.ADD (
48: 'p_user_id ' || p_user_id || ' p_person_id ' || p_person_id,
49: 1,
50: 'N'
51: );

Line 72: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

68: IF ((l_person_id IS NULL)
69: AND (l_user_id IS NULL)
70: )
71: THEN
72: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
73: aso_debug_pub.ADD (
74: 'The person id and user id are null',
75: 1,
76: 'N'

Line 73: aso_debug_pub.ADD (

69: AND (l_user_id IS NULL)
70: )
71: THEN
72: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
73: aso_debug_pub.ADD (
74: 'The person id and user id are null',
75: 1,
76: 'N'
77: );

Line 88: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

84: )
85: LOOP
86: IF i.full_name IS NULL
87: THEN
88: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
89: aso_debug_pub.ADD (
90: 'full name is null for person_id :' || l_person_id,
91: 1,
92: 'N'

Line 89: aso_debug_pub.ADD (

85: LOOP
86: IF i.full_name IS NULL
87: THEN
88: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
89: aso_debug_pub.ADD (
90: 'full name is null for person_id :' || l_person_id,
91: 1,
92: 'N'
93: );

Line 97: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

93: );
94: END IF;
95: RAISE no_user_id;
96: ELSE
97: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
98: aso_debug_pub.ADD (
99: 'The approver name is from HR table ' || i.full_name,
100: 1,
101: 'N'

Line 98: aso_debug_pub.ADD (

94: END IF;
95: RAISE no_user_id;
96: ELSE
97: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
98: aso_debug_pub.ADD (
99: 'The approver name is from HR table ' || i.full_name,
100: 1,
101: 'N'
102: );

Line 108: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

104: RETURN i.full_name;
105: END IF;
106: END LOOP;
107:
108: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
109: aso_debug_pub.ADD (
110: 'person_id ' || l_person_id || ' does not exist in per_all_people_f',
111: 1,
112: 'N'

Line 109: aso_debug_pub.ADD (

105: END IF;
106: END LOOP;
107:
108: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
109: aso_debug_pub.ADD (
110: 'person_id ' || l_person_id || ' does not exist in per_all_people_f',
111: 1,
112: 'N'
113: );

Line 123: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

119: )
120: LOOP
121: IF k.source_name IS NULL
122: THEN
123: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
124: aso_debug_pub.ADD (
125: 'Resource name is null for user_id :' || l_user_id,
126: 1,
127: 'N'

Line 124: aso_debug_pub.ADD (

120: LOOP
121: IF k.source_name IS NULL
122: THEN
123: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
124: aso_debug_pub.ADD (
125: 'Resource name is null for user_id :' || l_user_id,
126: 1,
127: 'N'
128: );

Line 132: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

128: );
129: END IF;
130: RAISE no_user_id;
131: ELSE
132: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
133: aso_debug_pub.ADD (
134: 'The approver name is from JTF table ' || k.source_name,
135: 1,
136: 'N'

Line 133: aso_debug_pub.ADD (

129: END IF;
130: RAISE no_user_id;
131: ELSE
132: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
133: aso_debug_pub.ADD (
134: 'The approver name is from JTF table ' || k.source_name,
135: 1,
136: 'N'
137: );

Line 143: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

139: RETURN k.source_name;
140: END IF;
141: END LOOP;
142:
143: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
144: aso_debug_pub.ADD (
145: 'user_id ' || l_user_id || 'does not exist in jtf resources',
146: 1,
147: 'N'

Line 144: aso_debug_pub.ADD (

140: END IF;
141: END LOOP;
142:
143: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
144: aso_debug_pub.ADD (
145: 'user_id ' || l_user_id || 'does not exist in jtf resources',
146: 1,
147: 'N'
148: );

Line 153: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

149: END IF;
150: RAISE no_user_id;
151: END IF;
152:
153: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
154: aso_debug_pub.ADD (
155: 'Should not be reached inside the get_approver_name',
156: 1,
157: 'N'

Line 154: aso_debug_pub.ADD (

150: RAISE no_user_id;
151: END IF;
152:
153: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
154: aso_debug_pub.ADD (
155: 'Should not be reached inside the get_approver_name',
156: 1,
157: 'N'
158: );

Line 163: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

159: END IF;
160: EXCEPTION
161: WHEN no_user_id
162: THEN
163: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
164: aso_debug_pub.ADD (
165: 'No username found from ids',
166: 1,
167: 'N'

Line 164: aso_debug_pub.ADD (

160: EXCEPTION
161: WHEN no_user_id
162: THEN
163: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
164: aso_debug_pub.ADD (
165: 'No username found from ids',
166: 1,
167: 'N'
168: );

Line 186: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

182: fnd_msg_pub.ADD;
183: RAISE fnd_api.g_exc_error;
184: WHEN OTHERS
185: THEN
186: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
187: aso_debug_pub.ADD (
188: 'No username found from ids',
189: 1,
190: 'N'

Line 187: aso_debug_pub.ADD (

183: RAISE fnd_api.g_exc_error;
184: WHEN OTHERS
185: THEN
186: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
187: aso_debug_pub.ADD (
188: 'No username found from ids',
189: 1,
190: 'N'
191: );

Line 234: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

230: l_approvaltypenameout VARCHAR2 (240);
231: l_approvaltypedescriptionout VARCHAR2 (240);
232: m integer;
233: BEGIN
234: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
235: aso_debug_pub.ADD (
236: 'Begin get_all_approvers',
237: 1,
238: 'N'

Line 235: aso_debug_pub.ADD (

231: l_approvaltypedescriptionout VARCHAR2 (240);
232: m integer;
233: BEGIN
234: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
235: aso_debug_pub.ADD (
236: 'Begin get_all_approvers',
237: 1,
238: 'N'
239: );

Line 240: aso_debug_pub.ADD (

236: 'Begin get_all_approvers',
237: 1,
238: 'N'
239: );
240: aso_debug_pub.ADD (
241: 'Application ID : ' || p_application_id,
242: 1,
243: 'N'
244: );

Line 245: aso_debug_pub.ADD (

241: 'Application ID : ' || p_application_id,
242: 1,
243: 'N'
244: );
245: aso_debug_pub.ADD (
246: 'Object ID : ' || p_object_id,
247: 1,
248: 'N'
249: );

Line 250: aso_debug_pub.ADD (

246: 'Object ID : ' || p_object_id,
247: 1,
248: 'N'
249: );
250: aso_debug_pub.ADD (
251: 'Object Type : ' || p_object_type,
252: 1,
253: 'N'
254: );

Line 255: aso_debug_pub.ADD (

251: 'Object Type : ' || p_object_type,
252: 1,
253: 'N'
254: );
255: aso_debug_pub.ADD (
256: 'Commit Flag : ' || p_commit,
257: 1,
258: 'N'
259: );

Line 263: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

259: );
260: END IF;
261: -- Standard call to establisg savepoint .
262:
263: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
264: aso_debug_pub.ADD (
265: 'Establishing save point GET_ALL_APPROVERS_INT',
266: 1,
267: 'N'

Line 264: aso_debug_pub.ADD (

260: END IF;
261: -- Standard call to establisg savepoint .
262:
263: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
264: aso_debug_pub.ADD (
265: 'Establishing save point GET_ALL_APPROVERS_INT',
266: 1,
267: 'N'
268: );

Line 281: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

277: l_api_name,
278: g_pkg_name
279: )
280: THEN
281: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
282: aso_debug_pub.ADD (
283: 'GET_ALL_APROVERS api call was not compatible pls check version ',
284: 1,
285: 'N'

Line 282: aso_debug_pub.ADD (

278: g_pkg_name
279: )
280: THEN
281: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
282: aso_debug_pub.ADD (
283: 'GET_ALL_APROVERS api call was not compatible pls check version ',
284: 1,
285: 'N'
286: );

Line 297: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

293: IF fnd_api.to_boolean (
294: p_init_msg_list
295: )
296: THEN
297: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
298: aso_debug_pub.ADD (
299: 'Initializing the message list ',
300: 1,
301: 'N'

Line 298: aso_debug_pub.ADD (

294: p_init_msg_list
295: )
296: THEN
297: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
298: aso_debug_pub.ADD (
299: 'Initializing the message list ',
300: 1,
301: 'N'
302: );

Line 317: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

313: IF fnd_api.to_boolean (
314: p_clear_transaction_flag
315: )
316: THEN
317: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
318: aso_debug_pub.ADD (
319: 'clearing all previous transactions in AME ',
320: 1,
321: 'N'

Line 318: aso_debug_pub.ADD (

314: p_clear_transaction_flag
315: )
316: THEN
317: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
318: aso_debug_pub.ADD (
319: 'clearing all previous transactions in AME ',
320: 1,
321: 'N'
322: );

Line 323: aso_debug_pub.ADD (

319: 'clearing all previous transactions in AME ',
320: 1,
321: 'N'
322: );
323: aso_debug_pub.ADD (
324: 'Calling AME clearAllApprovals',
325: 1,
326: 'N'
327: );

Line 338: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

334: END IF;
335:
336: -- Calling the OAM API to get all the approvers -----
337:
338: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
339: aso_debug_pub.ADD (
340: 'Calling AME get All Approvers Procedure',
341: 1,
342: 'N'

Line 339: aso_debug_pub.ADD (

335:
336: -- Calling the OAM API to get all the approvers -----
337:
338: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
339: aso_debug_pub.ADD (
340: 'Calling AME get All Approvers Procedure',
341: 1,
342: 'N'
343: );

Line 352: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

348: transactiontypein => p_object_type,
349: approversout => approvers,
350: ruleidsout => ruleids
351: );
352: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
353: aso_debug_pub.ADD (
354: 'Approvers Count is ' || approvers.COUNT,
355: 1,
356: 'N'

Line 353: aso_debug_pub.ADD (

349: approversout => approvers,
350: ruleidsout => ruleids
351: );
352: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
353: aso_debug_pub.ADD (
354: 'Approvers Count is ' || approvers.COUNT,
355: 1,
356: 'N'
357: );

Line 365: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

361: -- Added code to check if it is a self-approval case
362: IF ((approvers.count = 1) and (approvers(1).approval_status = ame_util.approvedStatus)) THEN
363:
364: -- the requester is approver in this case
365: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
366: aso_debug_pub.add('Self approval case -- requester is only approver', 1, 'N');
367: END IF;
368: NULL;
369:

Line 366: aso_debug_pub.add('Self approval case -- requester is only approver', 1, 'N');

362: IF ((approvers.count = 1) and (approvers(1).approval_status = ame_util.approvedStatus)) THEN
363:
364: -- the requester is approver in this case
365: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
366: aso_debug_pub.add('Self approval case -- requester is only approver', 1, 'N');
367: END IF;
368: NULL;
369:
370: ELSE

Line 389: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

385:
386: IF i > 1 THEN
387:
388:
389: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
390: aso_debug_pub.ADD (' Checking for duplicate approvers',1,'N');
391: END IF;
392:
393:

Line 390: aso_debug_pub.ADD (' Checking for duplicate approvers',1,'N');

386: IF i > 1 THEN
387:
388:
389: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
390: aso_debug_pub.ADD (' Checking for duplicate approvers',1,'N');
391: END IF;
392:
393:
394: FOR j IN 1..x_approvers_list.COUNT LOOP

Line 400: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

396: IF (( approvers(i).user_id = x_approvers_list(j).approver_user_id ) OR
397: ( approvers(i).person_id = x_approvers_list(j).approver_person_id )) THEN
398:
399:
400: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
401: aso_debug_pub.ADD ('Found a duplicate approver ',1,'N');
402: aso_debug_pub.ADD ('Duplicate approver person_id is '|| approvers(i).person_id,1,'N');
403:
404:

Line 401: aso_debug_pub.ADD ('Found a duplicate approver ',1,'N');

397: ( approvers(i).person_id = x_approvers_list(j).approver_person_id )) THEN
398:
399:
400: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
401: aso_debug_pub.ADD ('Found a duplicate approver ',1,'N');
402: aso_debug_pub.ADD ('Duplicate approver person_id is '|| approvers(i).person_id,1,'N');
403:
404:
405: END IF;

Line 402: aso_debug_pub.ADD ('Duplicate approver person_id is '|| approvers(i).person_id,1,'N');

398:
399:
400: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
401: aso_debug_pub.ADD ('Found a duplicate approver ',1,'N');
402: aso_debug_pub.ADD ('Duplicate approver person_id is '|| approvers(i).person_id,1,'N');
403:
404:
405: END IF;
406:

Line 429: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

425: ).person_id;
426: x_approvers_list (
427: m
428: ).approver_sequence := m;
429: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
430: aso_debug_pub.ADD (
431: 'The person_id is ' || approvers (
432: i
433: ).person_id,

Line 430: aso_debug_pub.ADD (

426: x_approvers_list (
427: m
428: ).approver_sequence := m;
429: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
430: aso_debug_pub.ADD (
431: 'The person_id is ' || approvers (
432: i
433: ).person_id,
434: 1,

Line 437: aso_debug_pub.ADD (

433: ).person_id,
434: 1,
435: 'N'
436: );
437: aso_debug_pub.ADD (
438: 'The user_id is ' || approvers (
439: i
440: ).user_id,
441: 1,

Line 480: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

476: i
477: ).rule_id := ruleids (
478: i
479: );
480: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
481: aso_debug_pub.ADD (
482: 'Calling AME get applicable rules procedure',
483: 1,
484: 'N'

Line 481: aso_debug_pub.ADD (

477: ).rule_id := ruleids (
478: i
479: );
480: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
481: aso_debug_pub.ADD (
482: 'Calling AME get applicable rules procedure',
483: 1,
484: 'N'
485: );

Line 510: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

506: IF fnd_api.to_boolean (
507: p_commit
508: )
509: THEN
510: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
511: aso_debug_pub.ADD (
512: 'Commiting the work in get_all_approvers procedure ',
513: 1,
514: 'N'

Line 511: aso_debug_pub.ADD (

507: p_commit
508: )
509: THEN
510: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
511: aso_debug_pub.ADD (
512: 'Commiting the work in get_all_approvers procedure ',
513: 1,
514: 'N'
515: );

Line 520: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

516: END IF;
517: COMMIT WORK;
518: END IF;
519:
520: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
521: aso_debug_pub.ADD (
522: 'End get all approvers procedure ',
523: 1,
524: 'N'

Line 521: aso_debug_pub.ADD (

517: COMMIT WORK;
518: END IF;
519:
520: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
521: aso_debug_pub.ADD (
522: 'End get all approvers procedure ',
523: 1,
524: 'N'
525: );

Line 530: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

526: END IF;
527: EXCEPTION
528: WHEN fnd_api.g_exc_error
529: THEN
530: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
531: aso_debug_pub.ADD (
532: 'Exception FND_API.G_EXC_ERROR in get_all_approvers ',
533: 1,
534: 'N'

Line 531: aso_debug_pub.ADD (

527: EXCEPTION
528: WHEN fnd_api.g_exc_error
529: THEN
530: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
531: aso_debug_pub.ADD (
532: 'Exception FND_API.G_EXC_ERROR in get_all_approvers ',
533: 1,
534: 'N'
535: );

Line 550: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

546: x_return_status => x_return_status
547: );
548: WHEN fnd_api.g_exc_unexpected_error
549: THEN
550: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
551: aso_debug_pub.ADD (
552: 'Exception FND_API.G_EXC_UNEXPECTED_ERROR in get_all_approvers ',
553: 1,
554: 'N'

Line 551: aso_debug_pub.ADD (

547: );
548: WHEN fnd_api.g_exc_unexpected_error
549: THEN
550: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
551: aso_debug_pub.ADD (
552: 'Exception FND_API.G_EXC_UNEXPECTED_ERROR in get_all_approvers ',
553: 1,
554: 'N'
555: );

Line 570: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

566: x_return_status => x_return_status
567: );
568: WHEN OTHERS
569: THEN
570: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
571: aso_debug_pub.ADD (
572: 'When Others Exception in get_all_approvers ',
573: 1,
574: 'N'

Line 571: aso_debug_pub.ADD (

567: );
568: WHEN OTHERS
569: THEN
570: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
571: aso_debug_pub.ADD (
572: 'When Others Exception in get_all_approvers ',
573: 1,
574: 'N'
575: );

Line 653: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

649:
650:
651: BEGIN
652: g_user_id := fnd_global.user_id;
653: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
654: aso_debug_pub.ADD (
655: 'Begin start_approval_process procedure ',
656: 1,
657: 'N'

Line 654: aso_debug_pub.ADD (

650:
651: BEGIN
652: g_user_id := fnd_global.user_id;
653: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
654: aso_debug_pub.ADD (
655: 'Begin start_approval_process procedure ',
656: 1,
657: 'N'
658: );

Line 659: aso_debug_pub.ADD (

655: 'Begin start_approval_process procedure ',
656: 1,
657: 'N'
658: );
659: aso_debug_pub.ADD (
660: 'Application ID : ' || p_application_id,
661: 1,
662: 'N'
663: );

Line 664: aso_debug_pub.ADD (

660: 'Application ID : ' || p_application_id,
661: 1,
662: 'N'
663: );
664: aso_debug_pub.ADD (
665: 'Object ID : ' || p_object_id,
666: 1,
667: 'N'
668: );

Line 669: aso_debug_pub.ADD (

665: 'Object ID : ' || p_object_id,
666: 1,
667: 'N'
668: );
669: aso_debug_pub.ADD (
670: 'Object Type : ' || p_object_type,
671: 1,
672: 'N'
673: );

Line 674: aso_debug_pub.ADD (

670: 'Object Type : ' || p_object_type,
671: 1,
672: 'N'
673: );
674: aso_debug_pub.ADD (
675: 'Commit Flag : ' || p_commit,
676: 1,
677: 'N'
678: );

Line 682: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

678: );
679: END IF;
680: -- Standard call to establisg savepoint .
681:
682: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
683: aso_debug_pub.ADD (
684: 'Establishing save point START_APPROVAL_PROCESS_INT',
685: 1,
686: 'N'

Line 683: aso_debug_pub.ADD (

679: END IF;
680: -- Standard call to establisg savepoint .
681:
682: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
683: aso_debug_pub.ADD (
684: 'Establishing save point START_APPROVAL_PROCESS_INT',
685: 1,
686: 'N'
687: );

Line 699: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

695: l_api_name,
696: g_pkg_name
697: )
698: THEN
699: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
700: aso_debug_pub.ADD (
701: 'START_APPROVAL_PROCESS_PUB api call was not compatible pls check version ',
702: 1,
703: 'N'

Line 700: aso_debug_pub.ADD (

696: g_pkg_name
697: )
698: THEN
699: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
700: aso_debug_pub.ADD (
701: 'START_APPROVAL_PROCESS_PUB api call was not compatible pls check version ',
702: 1,
703: 'N'
704: );

Line 715: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

711: IF fnd_api.to_boolean (
712: p_init_msg_list
713: )
714: THEN
715: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
716: aso_debug_pub.ADD (
717: 'Initializing the message list ',
718: 1,
719: 'N'

Line 716: aso_debug_pub.ADD (

712: p_init_msg_list
713: )
714: THEN
715: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
716: aso_debug_pub.ADD (
717: 'Initializing the message list ',
718: 1,
719: 'N'
720: );

Line 733: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

729: OPEN C_get_duplicate_approval;
730: FETCH C_get_duplicate_approval INTO l_dup_approval ;
731: CLOSE C_get_duplicate_approval;
732:
733: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
734: aso_debug_pub.ADD('l_dup_approval: '|| l_dup_approval,1,'N');
735: END IF;
736:
737: IF l_dup_approval = 0 THEN

Line 734: aso_debug_pub.ADD('l_dup_approval: '|| l_dup_approval,1,'N');

730: FETCH C_get_duplicate_approval INTO l_dup_approval ;
731: CLOSE C_get_duplicate_approval;
732:
733: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
734: aso_debug_pub.ADD('l_dup_approval: '|| l_dup_approval,1,'N');
735: END IF;
736:
737: IF l_dup_approval = 0 THEN
738:

Line 739: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

735: END IF;
736:
737: IF l_dup_approval = 0 THEN
738:
739: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
740: aso_debug_pub.ADD (
741: 'Parameter p_approver sequence is :' || p_approver_sequence,
742: 1,
743: 'N'

Line 740: aso_debug_pub.ADD (

736:
737: IF l_dup_approval = 0 THEN
738:
739: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
740: aso_debug_pub.ADD (
741: 'Parameter p_approver sequence is :' || p_approver_sequence,
742: 1,
743: 'N'
744: );

Line 759: IF aso_debug_pub.g_debug_flag = 'Y' THEN

755:
756: -- Get the Requester Group id
757: begin
758:
759: IF aso_debug_pub.g_debug_flag = 'Y' THEN
760: aso_debug_pub.add('Before calling aso_utility_pvt.Get_Profile_Obsolete_Status', 1, 'N');
761: END IF;
762:
763: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',

Line 760: aso_debug_pub.add('Before calling aso_utility_pvt.Get_Profile_Obsolete_Status', 1, 'N');

756: -- Get the Requester Group id
757: begin
758:
759: IF aso_debug_pub.g_debug_flag = 'Y' THEN
760: aso_debug_pub.add('Before calling aso_utility_pvt.Get_Profile_Obsolete_Status', 1, 'N');
761: END IF;
762:
763: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
764: p_application_id => 521);

Line 766: IF aso_debug_pub.g_debug_flag = 'Y' THEN

762:
763: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
764: p_application_id => 521);
765:
766: IF aso_debug_pub.g_debug_flag = 'Y' THEN
767: aso_debug_pub.add('After calling Get_Profile_Obsolete_Status: l_obsolete_status: ' || l_obsolete_status, 1, 'N');
768: END IF;
769:
770: if l_obsolete_status = 'T' then

Line 767: aso_debug_pub.add('After calling Get_Profile_Obsolete_Status: l_obsolete_status: ' || l_obsolete_status, 1, 'N');

763: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
764: p_application_id => 521);
765:
766: IF aso_debug_pub.g_debug_flag = 'Y' THEN
767: aso_debug_pub.add('After calling Get_Profile_Obsolete_Status: l_obsolete_status: ' || l_obsolete_status, 1, 'N');
768: END IF;
769:
770: if l_obsolete_status = 'T' then
771:

Line 774: IF aso_debug_pub.g_debug_flag = 'Y' THEN

770: if l_obsolete_status = 'T' then
771:
772: l_sales_group_role := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
773:
774: IF aso_debug_pub.g_debug_flag = 'Y' THEN
775: aso_debug_pub.add('l_sales_group_role: ' || l_sales_group_role, 1, 'N');
776: END IF;
777:
778: l_requester_group_id := SUBSTR(l_sales_group_role, 1, INSTR(l_sales_group_role,'(')-1);

Line 775: aso_debug_pub.add('l_sales_group_role: ' || l_sales_group_role, 1, 'N');

771:
772: l_sales_group_role := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
773:
774: IF aso_debug_pub.g_debug_flag = 'Y' THEN
775: aso_debug_pub.add('l_sales_group_role: ' || l_sales_group_role, 1, 'N');
776: END IF;
777:
778: l_requester_group_id := SUBSTR(l_sales_group_role, 1, INSTR(l_sales_group_role,'(')-1);
779:

Line 780: IF aso_debug_pub.g_debug_flag = 'Y' THEN

776: END IF;
777:
778: l_requester_group_id := SUBSTR(l_sales_group_role, 1, INSTR(l_sales_group_role,'(')-1);
779:
780: IF aso_debug_pub.g_debug_flag = 'Y' THEN
781: aso_debug_pub.add('l_requester_group_id: ' || l_requester_group_id, 1, 'N');
782: END IF;
783:
784: if l_requester_group_id is null then

Line 781: aso_debug_pub.add('l_requester_group_id: ' || l_requester_group_id, 1, 'N');

777:
778: l_requester_group_id := SUBSTR(l_sales_group_role, 1, INSTR(l_sales_group_role,'(')-1);
779:
780: IF aso_debug_pub.g_debug_flag = 'Y' THEN
781: aso_debug_pub.add('l_requester_group_id: ' || l_requester_group_id, 1, 'N');
782: END IF;
783:
784: if l_requester_group_id is null then
785:

Line 788: IF aso_debug_pub.g_debug_flag = 'Y' THEN

784: if l_requester_group_id is null then
785:
786: l_sales_group_role := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);
787:
788: IF aso_debug_pub.g_debug_flag = 'Y' THEN
789: aso_debug_pub.add('l_sales_group_role: ' || l_sales_group_role, 1, 'N');
790: END IF;
791:
792: l_requester_group_id := to_number(l_sales_group_role);

Line 789: aso_debug_pub.add('l_sales_group_role: ' || l_sales_group_role, 1, 'N');

785:
786: l_sales_group_role := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);
787:
788: IF aso_debug_pub.g_debug_flag = 'Y' THEN
789: aso_debug_pub.add('l_sales_group_role: ' || l_sales_group_role, 1, 'N');
790: END IF;
791:
792: l_requester_group_id := to_number(l_sales_group_role);
793:

Line 794: IF aso_debug_pub.g_debug_flag = 'Y' THEN

790: END IF;
791:
792: l_requester_group_id := to_number(l_sales_group_role);
793:
794: IF aso_debug_pub.g_debug_flag = 'Y' THEN
795: aso_debug_pub.add('l_requester_group_id: ' || l_requester_group_id, 1, 'N');
796: END IF;
797:
798: end if;

Line 795: aso_debug_pub.add('l_requester_group_id: ' || l_requester_group_id, 1, 'N');

791:
792: l_requester_group_id := to_number(l_sales_group_role);
793:
794: IF aso_debug_pub.g_debug_flag = 'Y' THEN
795: aso_debug_pub.add('l_requester_group_id: ' || l_requester_group_id, 1, 'N');
796: END IF;
797:
798: end if;
799:

Line 804: IF aso_debug_pub.g_debug_flag = 'Y' THEN

800: else
801:
802: l_sales_group_role := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
803:
804: IF aso_debug_pub.g_debug_flag = 'Y' THEN
805: aso_debug_pub.add('l_sales_group_role: ' || l_sales_group_role, 1, 'N');
806: END IF;
807:
808: l_requester_group_id := SUBSTR(l_sales_group_role, 1, INSTR(l_sales_group_role,'(')-1);

Line 805: aso_debug_pub.add('l_sales_group_role: ' || l_sales_group_role, 1, 'N');

801:
802: l_sales_group_role := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
803:
804: IF aso_debug_pub.g_debug_flag = 'Y' THEN
805: aso_debug_pub.add('l_sales_group_role: ' || l_sales_group_role, 1, 'N');
806: END IF;
807:
808: l_requester_group_id := SUBSTR(l_sales_group_role, 1, INSTR(l_sales_group_role,'(')-1);
809:

Line 810: IF aso_debug_pub.g_debug_flag = 'Y' THEN

806: END IF;
807:
808: l_requester_group_id := SUBSTR(l_sales_group_role, 1, INSTR(l_sales_group_role,'(')-1);
809:
810: IF aso_debug_pub.g_debug_flag = 'Y' THEN
811: aso_debug_pub.add('l_requester_group_id: ' || l_requester_group_id, 1, 'N');
812: END IF;
813:
814: if l_requester_group_id is null then

Line 811: aso_debug_pub.add('l_requester_group_id: ' || l_requester_group_id, 1, 'N');

807:
808: l_requester_group_id := SUBSTR(l_sales_group_role, 1, INSTR(l_sales_group_role,'(')-1);
809:
810: IF aso_debug_pub.g_debug_flag = 'Y' THEN
811: aso_debug_pub.add('l_requester_group_id: ' || l_requester_group_id, 1, 'N');
812: END IF;
813:
814: if l_requester_group_id is null then
815:

Line 818: IF aso_debug_pub.g_debug_flag = 'Y' THEN

814: if l_requester_group_id is null then
815:
816: l_sales_group_role := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);
817:
818: IF aso_debug_pub.g_debug_flag = 'Y' THEN
819: aso_debug_pub.add('l_sales_group_role: ' || l_sales_group_role, 1, 'N');
820: END IF;
821:
822: l_requester_group_id := substr(l_sales_group_role, instr(l_sales_group_role,':', -1) + 1, length(l_sales_group_role));

Line 819: aso_debug_pub.add('l_sales_group_role: ' || l_sales_group_role, 1, 'N');

815:
816: l_sales_group_role := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);
817:
818: IF aso_debug_pub.g_debug_flag = 'Y' THEN
819: aso_debug_pub.add('l_sales_group_role: ' || l_sales_group_role, 1, 'N');
820: END IF;
821:
822: l_requester_group_id := substr(l_sales_group_role, instr(l_sales_group_role,':', -1) + 1, length(l_sales_group_role));
823:

Line 824: IF aso_debug_pub.g_debug_flag = 'Y' THEN

820: END IF;
821:
822: l_requester_group_id := substr(l_sales_group_role, instr(l_sales_group_role,':', -1) + 1, length(l_sales_group_role));
823:
824: IF aso_debug_pub.g_debug_flag = 'Y' THEN
825: aso_debug_pub.add('l_requester_group_id: ' || l_requester_group_id, 1, 'N');
826: END IF;
827:
828: end if;

Line 825: aso_debug_pub.add('l_requester_group_id: ' || l_requester_group_id, 1, 'N');

821:
822: l_requester_group_id := substr(l_sales_group_role, instr(l_sales_group_role,':', -1) + 1, length(l_sales_group_role));
823:
824: IF aso_debug_pub.g_debug_flag = 'Y' THEN
825: aso_debug_pub.add('l_requester_group_id: ' || l_requester_group_id, 1, 'N');
826: END IF;
827:
828: end if;
829:

Line 838: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

834: when others then
835: l_requester_group_id := 0;
836: end;
837:
838: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
839: aso_debug_pub.ADD (
840: 'Requester Group ID is ' || l_requester_group_id,
841: 1,
842: 'N'

Line 839: aso_debug_pub.ADD (

835: l_requester_group_id := 0;
836: end;
837:
838: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
839: aso_debug_pub.ADD (
840: 'Requester Group ID is ' || l_requester_group_id,
841: 1,
842: 'N'
843: );

Line 851: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

847: p_object_id
848: );
849: FETCH c2 INTO p_approval_instance_id;
850: CLOSE c2;
851: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
852: aso_debug_pub.ADD (
853: 'Approval Instance ID is ' || p_approval_instance_id,
854: 1,
855: 'N'

Line 852: aso_debug_pub.ADD (

848: );
849: FETCH c2 INTO p_approval_instance_id;
850: CLOSE c2;
851: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
852: aso_debug_pub.ADD (
853: 'Approval Instance ID is ' || p_approval_instance_id,
854: 1,
855: 'N'
856: );

Line 857: aso_debug_pub.ADD (

853: 'Approval Instance ID is ' || p_approval_instance_id,
854: 1,
855: 'N'
856: );
857: aso_debug_pub.ADD (
858: 'Inserting a row into the header table ',
859: 1,
860: 'N'
861: );

Line 920: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

916: l_requester_group_id -- p_REQUESTER_GROUP_ID
917: );
918: -- Calling the API to get all the approvers -----
919:
920: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
921: aso_debug_pub.ADD (
922: 'Calling get All Approvers Procedure',
923: 1,
924: 'N'

Line 921: aso_debug_pub.ADD (

917: );
918: -- Calling the API to get all the approvers -----
919:
920: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
921: aso_debug_pub.ADD (
922: 'Calling get All Approvers Procedure',
923: 1,
924: 'N'
925: );

Line 941: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

937: l_msg_data,
938: x_approvers_list,
939: x_rules_list
940: );
941: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
942: aso_debug_pub.ADD (
943: 'Return Status from get_all_approvers is ' || l_return_status,
944: 1,
945: 'N'

Line 942: aso_debug_pub.ADD (

938: x_approvers_list,
939: x_rules_list
940: );
941: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
942: aso_debug_pub.ADD (
943: 'Return Status from get_all_approvers is ' || l_return_status,
944: 1,
945: 'N'
946: );

Line 953: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

949: -- Checking to find if the call to above API was successfull or not
950:
951: IF l_return_status <> fnd_api.g_ret_sts_success
952: THEN
953: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
954: aso_debug_pub.ADD (
955: 'Return Status from get_all_approvers is ' || x_return_status,
956: 1,
957: 'N'

Line 954: aso_debug_pub.ADD (

950:
951: IF l_return_status <> fnd_api.g_ret_sts_success
952: THEN
953: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
954: aso_debug_pub.ADD (
955: 'Return Status from get_all_approvers is ' || x_return_status,
956: 1,
957: 'N'
958: );

Line 962: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

958: );
959: END IF;
960: RAISE fnd_api.g_exc_error;
961: ELSE
962: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
963: aso_debug_pub.ADD (
964: 'No of approvers is ' || x_approvers_list.COUNT,
965: 1,
966: 'N'

Line 963: aso_debug_pub.ADD (

959: END IF;
960: RAISE fnd_api.g_exc_error;
961: ELSE
962: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
963: aso_debug_pub.ADD (
964: 'No of approvers is ' || x_approvers_list.COUNT,
965: 1,
966: 'N'
967: );

Line 968: aso_debug_pub.ADD (

964: 'No of approvers is ' || x_approvers_list.COUNT,
965: 1,
966: 'N'
967: );
968: aso_debug_pub.ADD (
969: 'Object Approval ID is ' || p_object_approval_id,
970: 1,
971: 'N'
972: );

Line 991: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

987:
988: -- fix for bug 4590633
989: l_employee_id := x_approvers_list(i).approver_person_id;
990:
991: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
992: aso_debug_pub.ADD ('person_id got from AME is: '||to_char(l_employee_id),1,'N');
993: END IF;
994:
995: IF ((x_approvers_list(i).approver_person_id is null) or (x_approvers_list(i).approver_person_id = fnd_api.g_miss_num) and

Line 992: aso_debug_pub.ADD ('person_id got from AME is: '||to_char(l_employee_id),1,'N');

988: -- fix for bug 4590633
989: l_employee_id := x_approvers_list(i).approver_person_id;
990:
991: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
992: aso_debug_pub.ADD ('person_id got from AME is: '||to_char(l_employee_id),1,'N');
993: END IF;
994:
995: IF ((x_approvers_list(i).approver_person_id is null) or (x_approvers_list(i).approver_person_id = fnd_api.g_miss_num) and
996: (x_approvers_list(i).approver_user_id is not null) and (x_approvers_list(i).approver_user_id <> fnd_api.g_miss_num)) then

Line 998: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

994:
995: IF ((x_approvers_list(i).approver_person_id is null) or (x_approvers_list(i).approver_person_id = fnd_api.g_miss_num) and
996: (x_approvers_list(i).approver_user_id is not null) and (x_approvers_list(i).approver_user_id <> fnd_api.g_miss_num)) then
997:
998: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
999: aso_debug_pub.ADD ('Person_id is null from AME Hence deriving it from user_id',1,'N');
1000: END IF;
1001:
1002: open get_employee_id(x_approvers_list(i).approver_user_id);

Line 999: aso_debug_pub.ADD ('Person_id is null from AME Hence deriving it from user_id',1,'N');

995: IF ((x_approvers_list(i).approver_person_id is null) or (x_approvers_list(i).approver_person_id = fnd_api.g_miss_num) and
996: (x_approvers_list(i).approver_user_id is not null) and (x_approvers_list(i).approver_user_id <> fnd_api.g_miss_num)) then
997:
998: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
999: aso_debug_pub.ADD ('Person_id is null from AME Hence deriving it from user_id',1,'N');
1000: END IF;
1001:
1002: open get_employee_id(x_approvers_list(i).approver_user_id);
1003: fetch get_employee_id into l_employee_id;

Line 1006: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1002: open get_employee_id(x_approvers_list(i).approver_user_id);
1003: fetch get_employee_id into l_employee_id;
1004: close get_employee_id;
1005:
1006: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1007: aso_debug_pub.ADD ('Derived person_id is: '||to_char(l_employee_id),1,'N');
1008: END IF;
1009:
1010: END IF;

Line 1007: aso_debug_pub.ADD ('Derived person_id is: '||to_char(l_employee_id),1,'N');

1003: fetch get_employee_id into l_employee_id;
1004: close get_employee_id;
1005:
1006: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1007: aso_debug_pub.ADD ('Derived person_id is: '||to_char(l_employee_id),1,'N');
1008: END IF;
1009:
1010: END IF;
1011:

Line 1014: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1010: END IF;
1011:
1012: -- end of fix for bug 4590633
1013:
1014: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1015: aso_debug_pub.ADD (
1016: 'Inserting rows into the detail table ',
1017: 1,
1018: 'N'

Line 1015: aso_debug_pub.ADD (

1011:
1012: -- end of fix for bug 4590633
1013:
1014: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1015: aso_debug_pub.ADD (
1016: 'Inserting rows into the detail table ',
1017: 1,
1018: 'N'
1019: );

Line 1099: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1095: NULL -- p_OBJECT_VERSION_NUMBER
1096: );
1097: END LOOP;
1098:
1099: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1100: aso_debug_pub.ADD (
1101: 'Inserting rows into the rule table ',
1102: 1,
1103: 'N'

Line 1100: aso_debug_pub.ADD (

1096: );
1097: END LOOP;
1098:
1099: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1100: aso_debug_pub.ADD (
1101: 'Inserting rows into the rule table ',
1102: 1,
1103: 'N'
1104: );

Line 1186: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1182: */
1183:
1184: IF x_approvers_list.count = 0 then
1185:
1186: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1187: aso_debug_pub.ADD ('Self Approval Case: Updating to Approved',1,'N');
1188: END IF;
1189: update aso_apr_obj_approvals
1190: set approval_status = 'APPR',

Line 1187: aso_debug_pub.ADD ('Self Approval Case: Updating to Approved',1,'N');

1183:
1184: IF x_approvers_list.count = 0 then
1185:
1186: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1187: aso_debug_pub.ADD ('Self Approval Case: Updating to Approved',1,'N');
1188: END IF;
1189: update aso_apr_obj_approvals
1190: set approval_status = 'APPR',
1191: end_date = sysdate

Line 1199: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1195: -- Pass back the new approval id
1196: x_object_approval_id := p_object_approval_id;
1197: x_approval_instance_id := p_approval_instance_id;
1198:
1199: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1200: aso_debug_pub.ADD (
1201: 'Object Approval ID :' || x_approval_instance_id,
1202: 1,
1203: 'N'

Line 1200: aso_debug_pub.ADD (

1196: x_object_approval_id := p_object_approval_id;
1197: x_approval_instance_id := p_approval_instance_id;
1198:
1199: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1200: aso_debug_pub.ADD (
1201: 'Object Approval ID :' || x_approval_instance_id,
1202: 1,
1203: 'N'
1204: );

Line 1205: aso_debug_pub.ADD (

1201: 'Object Approval ID :' || x_approval_instance_id,
1202: 1,
1203: 'N'
1204: );
1205: aso_debug_pub.ADD (
1206: 'Approval Instance ID :' || x_approval_instance_id,
1207: 1,
1208: 'N'
1209: );

Line 1216: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1212: ELSE -- l_dup_approval is not 0
1213:
1214: -- return a dummy instance id
1215: x_approval_instance_id := -1;
1216: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1217: aso_debug_pub.ADD(' Duplicate approval process FOUND , hence another process NOT Started',1,'N');
1218: END IF;
1219: END IF;
1220:

Line 1217: aso_debug_pub.ADD(' Duplicate approval process FOUND , hence another process NOT Started',1,'N');

1213:
1214: -- return a dummy instance id
1215: x_approval_instance_id := -1;
1216: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1217: aso_debug_pub.ADD(' Duplicate approval process FOUND , hence another process NOT Started',1,'N');
1218: END IF;
1219: END IF;
1220:
1221: -- commit the work

Line 1227: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1223: IF fnd_api.to_boolean (
1224: p_commit
1225: )
1226: THEN
1227: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1228: aso_debug_pub.ADD (
1229: 'Commiting the work in START_APPROVAL_PROCESS procedure ',
1230: 1,
1231: 'N'

Line 1228: aso_debug_pub.ADD (

1224: p_commit
1225: )
1226: THEN
1227: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1228: aso_debug_pub.ADD (
1229: 'Commiting the work in START_APPROVAL_PROCESS procedure ',
1230: 1,
1231: 'N'
1232: );

Line 1237: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1233: END IF;
1234: COMMIT WORK;
1235: END IF;
1236:
1237: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1238: aso_debug_pub.ADD (
1239: 'End Start_approval_process PROCEDURE ',
1240: 1,
1241: 'N'

Line 1238: aso_debug_pub.ADD (

1234: COMMIT WORK;
1235: END IF;
1236:
1237: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1238: aso_debug_pub.ADD (
1239: 'End Start_approval_process PROCEDURE ',
1240: 1,
1241: 'N'
1242: );

Line 1247: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1243: END IF;
1244: EXCEPTION
1245: WHEN fnd_api.g_exc_error
1246: THEN
1247: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1248: aso_debug_pub.ADD (
1249: 'Exception FND_API.G_EXC_ERROR in start_approval_process',
1250: 1,
1251: 'N'

Line 1248: aso_debug_pub.ADD (

1244: EXCEPTION
1245: WHEN fnd_api.g_exc_error
1246: THEN
1247: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1248: aso_debug_pub.ADD (
1249: 'Exception FND_API.G_EXC_ERROR in start_approval_process',
1250: 1,
1251: 'N'
1252: );

Line 1267: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1263: x_return_status => x_return_status
1264: );
1265: WHEN fnd_api.g_exc_unexpected_error
1266: THEN
1267: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1268: aso_debug_pub.ADD (
1269: 'Exception FND_API.G_EXC_UNEXPECTED_ERROR in start_approval_process',
1270: 1,
1271: 'N'

Line 1268: aso_debug_pub.ADD (

1264: );
1265: WHEN fnd_api.g_exc_unexpected_error
1266: THEN
1267: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1268: aso_debug_pub.ADD (
1269: 'Exception FND_API.G_EXC_UNEXPECTED_ERROR in start_approval_process',
1270: 1,
1271: 'N'
1272: );

Line 1288: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1284: );
1285:
1286: WHEN OTHERS
1287: THEN
1288: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1289: aso_debug_pub.ADD (
1290: 'When Others Exception in start_approval_process',
1291: 1,
1292: 'N'

Line 1289: aso_debug_pub.ADD (

1285:
1286: WHEN OTHERS
1287: THEN
1288: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1289: aso_debug_pub.ADD (
1290: 'When Others Exception in start_approval_process',
1291: 1,
1292: 'N'
1293: );

Line 1341: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1337: FROM aso_apr_obj_approvals
1338: WHERE object_id = c_object_id
1339: AND object_type = c_object_type);
1340: BEGIN
1341: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1342: aso_debug_pub.ADD (
1343: 'Begin cancel_approval_process PROCEDURE ',
1344: 1,
1345: 'N'

Line 1342: aso_debug_pub.ADD (

1338: WHERE object_id = c_object_id
1339: AND object_type = c_object_type);
1340: BEGIN
1341: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1342: aso_debug_pub.ADD (
1343: 'Begin cancel_approval_process PROCEDURE ',
1344: 1,
1345: 'N'
1346: );

Line 1347: aso_debug_pub.ADD (

1343: 'Begin cancel_approval_process PROCEDURE ',
1344: 1,
1345: 'N'
1346: );
1347: aso_debug_pub.ADD (
1348: 'Application ID : ' || p_application_id,
1349: 1,
1350: 'N'
1351: );

Line 1352: aso_debug_pub.ADD (

1348: 'Application ID : ' || p_application_id,
1349: 1,
1350: 'N'
1351: );
1352: aso_debug_pub.ADD (
1353: 'Object ID : ' || p_object_id,
1354: 1,
1355: 'N'
1356: );

Line 1357: aso_debug_pub.ADD (

1353: 'Object ID : ' || p_object_id,
1354: 1,
1355: 'N'
1356: );
1357: aso_debug_pub.ADD (
1358: 'Object Type : ' || p_object_type,
1359: 1,
1360: 'N'
1361: );

Line 1362: aso_debug_pub.ADD (

1358: 'Object Type : ' || p_object_type,
1359: 1,
1360: 'N'
1361: );
1362: aso_debug_pub.ADD (
1363: 'Commit Flag : ' || p_commit,
1364: 1,
1365: 'N'
1366: );

Line 1367: aso_debug_pub.ADD (

1363: 'Commit Flag : ' || p_commit,
1364: 1,
1365: 'N'
1366: );
1367: aso_debug_pub.ADD (
1368: 'Object Approval Id : ' || p_object_approval_id,
1369: 1,
1370: 'N'
1371: );

Line 1377: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1373:
1374:
1375: END IF;
1376: -- Set a save point
1377: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1378: aso_debug_pub.ADD (
1379: 'Establishing save point CANCEL_APPROVAL_PROCESS_INT',
1380: 1,
1381: 'N'

Line 1378: aso_debug_pub.ADD (

1374:
1375: END IF;
1376: -- Set a save point
1377: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1378: aso_debug_pub.ADD (
1379: 'Establishing save point CANCEL_APPROVAL_PROCESS_INT',
1380: 1,
1381: 'N'
1382: );

Line 1394: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1390: l_api_name,
1391: g_pkg_name
1392: )
1393: THEN
1394: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1395: aso_debug_pub.ADD (
1396: 'cancel_approval_process api call was not compatible pls check version ',
1397: 1,
1398: 'N'

Line 1395: aso_debug_pub.ADD (

1391: g_pkg_name
1392: )
1393: THEN
1394: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1395: aso_debug_pub.ADD (
1396: 'cancel_approval_process api call was not compatible pls check version ',
1397: 1,
1398: 'N'
1399: );

Line 1438: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1434: )
1435: LOOP
1436: -- calling the prccedure to cancel the workflow process
1437:
1438: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1439: aso_debug_pub.ADD (
1440: 'Object approval ID :' || i.object_approval_id,
1441: 1,
1442: 'N'

Line 1439: aso_debug_pub.ADD (

1435: LOOP
1436: -- calling the prccedure to cancel the workflow process
1437:
1438: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1439: aso_debug_pub.ADD (
1440: 'Object approval ID :' || i.object_approval_id,
1441: 1,
1442: 'N'
1443: );

Line 1444: aso_debug_pub.ADD (

1440: 'Object approval ID :' || i.object_approval_id,
1441: 1,
1442: 'N'
1443: );
1444: aso_debug_pub.ADD (
1445: 'Calling the wokflow procedure to start the cancellation process ',
1446: 1,
1447: 'N'
1448: );

Line 1458: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1454: );
1455: END LOOP;
1456: ELSE
1457: -- calling the prccedure to cancel the workflow process
1458: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1459: aso_debug_pub.ADD (
1460: 'Object approval ID :' || p_object_approval_id,
1461: 1,
1462: 'N'

Line 1459: aso_debug_pub.ADD (

1455: END LOOP;
1456: ELSE
1457: -- calling the prccedure to cancel the workflow process
1458: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1459: aso_debug_pub.ADD (
1460: 'Object approval ID :' || p_object_approval_id,
1461: 1,
1462: 'N'
1463: );

Line 1464: aso_debug_pub.ADD (

1460: 'Object approval ID :' || p_object_approval_id,
1461: 1,
1462: 'N'
1463: );
1464: aso_debug_pub.ADD (
1465: 'Calling the wokflow procedure to start the cancellation process ',
1466: 1,
1467: 'N'
1468: );

Line 1483: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1479: IF fnd_api.to_boolean (
1480: p_commit
1481: )
1482: THEN
1483: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1484: aso_debug_pub.ADD (
1485: 'Committing the work in cancel approval procedure ',
1486: 1,
1487: 'N'

Line 1484: aso_debug_pub.ADD (

1480: p_commit
1481: )
1482: THEN
1483: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1484: aso_debug_pub.ADD (
1485: 'Committing the work in cancel approval procedure ',
1486: 1,
1487: 'N'
1488: );

Line 1501: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1497: x_msg_data := fnd_msg_pub.get(p_msg_index => k,
1498: p_encoded => 'F');
1499: end loop;
1500:
1501: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1502: aso_debug_pub.ADD (
1503: 'End CancelApproval procedure ',
1504: 1,
1505: 'N'

Line 1502: aso_debug_pub.ADD (

1498: p_encoded => 'F');
1499: end loop;
1500:
1501: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1502: aso_debug_pub.ADD (
1503: 'End CancelApproval procedure ',
1504: 1,
1505: 'N'
1506: );

Line 1511: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1507: END IF;
1508: EXCEPTION
1509: WHEN fnd_api.g_exc_error
1510: THEN
1511: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1512: aso_debug_pub.ADD (
1513: 'Exception FND_API.G_EXC_ERROR in CancelApproval',
1514: 1,
1515: 'N'

Line 1512: aso_debug_pub.ADD (

1508: EXCEPTION
1509: WHEN fnd_api.g_exc_error
1510: THEN
1511: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1512: aso_debug_pub.ADD (
1513: 'Exception FND_API.G_EXC_ERROR in CancelApproval',
1514: 1,
1515: 'N'
1516: );

Line 1531: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1527: x_return_status => x_return_status
1528: );
1529: WHEN fnd_api.g_exc_unexpected_error
1530: THEN
1531: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1532: aso_debug_pub.ADD (
1533: 'Exception FND_API.G_EXC_UNEXPECTED_ERROR in CancelApproval',
1534: 1,
1535: 'N'

Line 1532: aso_debug_pub.ADD (

1528: );
1529: WHEN fnd_api.g_exc_unexpected_error
1530: THEN
1531: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1532: aso_debug_pub.ADD (
1533: 'Exception FND_API.G_EXC_UNEXPECTED_ERROR in CancelApproval',
1534: 1,
1535: 'N'
1536: );

Line 1551: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1547: x_return_status => x_return_status
1548: );
1549: WHEN OTHERS
1550: THEN
1551: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1552: aso_debug_pub.ADD (
1553: 'When Others Exception in CancelApproval',
1554: 1,
1555: 'N'

Line 1552: aso_debug_pub.ADD (

1548: );
1549: WHEN OTHERS
1550: THEN
1551: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1552: aso_debug_pub.ADD (
1553: 'When Others Exception in CancelApproval',
1554: 1,
1555: 'N'
1556: );

Line 1587: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1583: ) IS
1584: l_api_name CONSTANT VARCHAR2 (30) := 'skip_approver';
1585: l_api_version CONSTANT NUMBER := 1.0;
1586: BEGIN
1587: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1588: aso_debug_pub.ADD (
1589: 'Start of skip_approver',
1590: 1,
1591: 'N'

Line 1588: aso_debug_pub.ADD (

1584: l_api_name CONSTANT VARCHAR2 (30) := 'skip_approver';
1585: l_api_version CONSTANT NUMBER := 1.0;
1586: BEGIN
1587: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1588: aso_debug_pub.ADD (
1589: 'Start of skip_approver',
1590: 1,
1591: 'N'
1592: );

Line 1686: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1682: WHERE object_approval_id = c_obj_app_id;
1683:
1684:
1685: BEGIN
1686: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1687: aso_debug_pub.ADD (
1688: 'Start of get_rule_details',
1689: 1,
1690: 'N'

Line 1687: aso_debug_pub.ADD (

1683:
1684:
1685: BEGIN
1686: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1687: aso_debug_pub.ADD (
1688: 'Start of get_rule_details',
1689: 1,
1690: 'N'
1691: );

Line 1718: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1714: x_return_status := fnd_api.g_ret_sts_success;
1715:
1716: FOR i IN get_rule_ids(p_object_approval_id)
1717: LOOP
1718: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1719: aso_debug_pub.ADD (
1720: 'Calling AME get applicable rules procedure',
1721: 1,
1722: 'N'

Line 1719: aso_debug_pub.ADD (

1715:
1716: FOR i IN get_rule_ids(p_object_approval_id)
1717: LOOP
1718: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1719: aso_debug_pub.ADD (
1720: 'Calling AME get applicable rules procedure',
1721: 1,
1722: 'N'
1723: );

Line 1724: aso_debug_pub.ADD (

1720: 'Calling AME get applicable rules procedure',
1721: 1,
1722: 'N'
1723: );
1724: aso_debug_pub.ADD (
1725: 'Object_approval_id'||p_object_approval_id,
1726: 1,
1727: 'N'
1728: );

Line 1750: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1746: j:= j+1;
1747:
1748: END LOOP;
1749:
1750: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1751: aso_debug_pub.ADD (
1752: 'End of get_rule_details',
1753: 1,
1754: 'N'

Line 1751: aso_debug_pub.ADD (

1747:
1748: END LOOP;
1749:
1750: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1751: aso_debug_pub.ADD (
1752: 'End of get_rule_details',
1753: 1,
1754: 'N'
1755: );

Line 1820: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1816: l_api_name CONSTANT VARCHAR2 (30) := 'start_approval_workflow';
1817: l_api_version CONSTANT NUMBER := 1.0;
1818:
1819: BEGIN
1820: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1821: aso_debug_pub.ADD (
1822: 'Start of start_approval_workflow',
1823: 1,
1824: 'N'

Line 1821: aso_debug_pub.ADD (

1817: l_api_version CONSTANT NUMBER := 1.0;
1818:
1819: BEGIN
1820: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1821: aso_debug_pub.ADD (
1822: 'Start of start_approval_workflow',
1823: 1,
1824: 'N'
1825: );

Line 1826: aso_debug_pub.ADD (

1822: 'Start of start_approval_workflow',
1823: 1,
1824: 'N'
1825: );
1826: aso_debug_pub.ADD (
1827: 'Object Approval ID : ' || P_Object_approval_id,
1828: 1,
1829: 'N'
1830: );

Line 1831: aso_debug_pub.ADD (

1827: 'Object Approval ID : ' || P_Object_approval_id,
1828: 1,
1829: 'N'
1830: );
1831: aso_debug_pub.ADD (
1832: 'ItemType : ' || P_itemtype,
1833: 1,
1834: 'N'
1835: );

Line 1836: aso_debug_pub.ADD (

1832: 'ItemType : ' || P_itemtype,
1833: 1,
1834: 'N'
1835: );
1836: aso_debug_pub.ADD (
1837: 'Sender name : ' || P_sender_name,
1838: 1,
1839: 'N'
1840: );

Line 1841: aso_debug_pub.ADD (

1837: 'Sender name : ' || P_sender_name,
1838: 1,
1839: 'N'
1840: );
1841: aso_debug_pub.ADD (
1842: 'Commit Flag : ' || p_commit,
1843: 1,
1844: 'N'
1845: );

Line 1885: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1881: FND_MSG_PUB.ADD;
1882: RAISE FND_API.G_EXC_ERROR;
1883: END IF;
1884:
1885: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1886: aso_debug_pub.ADD (
1887: 'Calling procedure aso_apr_wf_pvt.start_aso_approvals',
1888: 1,
1889: 'N'

Line 1886: aso_debug_pub.ADD (

1882: RAISE FND_API.G_EXC_ERROR;
1883: END IF;
1884:
1885: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1886: aso_debug_pub.ADD (
1887: 'Calling procedure aso_apr_wf_pvt.start_aso_approvals',
1888: 1,
1889: 'N'
1890: );

Line 1899: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1895: P_itemtype,
1896: P_sender_name);
1897:
1898:
1899: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1900: aso_debug_pub.ADD (
1901: 'After Calling procedure aso_apr_wf_pvt.start_aso_approvals',
1902: 1,
1903: 'N'

Line 1900: aso_debug_pub.ADD (

1896: P_sender_name);
1897:
1898:
1899: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1900: aso_debug_pub.ADD (
1901: 'After Calling procedure aso_apr_wf_pvt.start_aso_approvals',
1902: 1,
1903: 'N'
1904: );

Line 1914: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1910: IF fnd_api.to_boolean (
1911: p_commit
1912: )
1913: THEN
1914: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1915: aso_debug_pub.ADD (
1916: 'Committing the work in start_approval_workflow ',
1917: 1,
1918: 'N'

Line 1915: aso_debug_pub.ADD (

1911: p_commit
1912: )
1913: THEN
1914: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1915: aso_debug_pub.ADD (
1916: 'Committing the work in start_approval_workflow ',
1917: 1,
1918: 'N'
1919: );

Line 1934: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1930: end loop;
1931:
1932:
1933:
1934: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1935: aso_debug_pub.ADD (
1936: 'End start_approval_workflow procedure ',
1937: 1,
1938: 'N'

Line 1935: aso_debug_pub.ADD (

1931:
1932:
1933:
1934: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1935: aso_debug_pub.ADD (
1936: 'End start_approval_workflow procedure ',
1937: 1,
1938: 'N'
1939: );

Line 2015: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2011: WHERE Status_Code = 'APPROVAL PENDING';
2012:
2013: BEGIN
2014:
2015: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2016: aso_debug_pub.add('upd_status_self_appr: BEGIN ', 1, 'Y');
2017: END IF;
2018:
2019: -- Initialize API return status to success

Line 2016: aso_debug_pub.add('upd_status_self_appr: BEGIN ', 1, 'Y');

2012:
2013: BEGIN
2014:
2015: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2016: aso_debug_pub.add('upd_status_self_appr: BEGIN ', 1, 'Y');
2017: END IF;
2018:
2019: -- Initialize API return status to success
2020: x_return_status := fnd_api.g_ret_sts_success;

Line 2024: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2020: x_return_status := fnd_api.g_ret_sts_success;
2021:
2022: SAVEPOINT upd_status_self_appr_int;
2023:
2024: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2025: aso_debug_pub.add('upd_status_self_appr: p_qte_hdr_id: '|| p_qte_hdr_id , 1, 'Y');
2026: aso_debug_pub.add('upd_status_self_appr: p_obj_ver_num: || p_obj_ver_num ', 1, 'Y');
2027: aso_debug_pub.add('upd_status_self_appr: p_last_update_date: || p_last_update_date ', 1, 'Y');
2028: END IF;

Line 2025: aso_debug_pub.add('upd_status_self_appr: p_qte_hdr_id: '|| p_qte_hdr_id , 1, 'Y');

2021:
2022: SAVEPOINT upd_status_self_appr_int;
2023:
2024: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2025: aso_debug_pub.add('upd_status_self_appr: p_qte_hdr_id: '|| p_qte_hdr_id , 1, 'Y');
2026: aso_debug_pub.add('upd_status_self_appr: p_obj_ver_num: || p_obj_ver_num ', 1, 'Y');
2027: aso_debug_pub.add('upd_status_self_appr: p_last_update_date: || p_last_update_date ', 1, 'Y');
2028: END IF;
2029:

Line 2026: aso_debug_pub.add('upd_status_self_appr: p_obj_ver_num: || p_obj_ver_num ', 1, 'Y');

2022: SAVEPOINT upd_status_self_appr_int;
2023:
2024: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2025: aso_debug_pub.add('upd_status_self_appr: p_qte_hdr_id: '|| p_qte_hdr_id , 1, 'Y');
2026: aso_debug_pub.add('upd_status_self_appr: p_obj_ver_num: || p_obj_ver_num ', 1, 'Y');
2027: aso_debug_pub.add('upd_status_self_appr: p_last_update_date: || p_last_update_date ', 1, 'Y');
2028: END IF;
2029:
2030: Open c_get_qte_info(p_qte_hdr_id);

Line 2027: aso_debug_pub.add('upd_status_self_appr: p_last_update_date: || p_last_update_date ', 1, 'Y');

2023:
2024: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2025: aso_debug_pub.add('upd_status_self_appr: p_qte_hdr_id: '|| p_qte_hdr_id , 1, 'Y');
2026: aso_debug_pub.add('upd_status_self_appr: p_obj_ver_num: || p_obj_ver_num ', 1, 'Y');
2027: aso_debug_pub.add('upd_status_self_appr: p_last_update_date: || p_last_update_date ', 1, 'Y');
2028: END IF;
2029:
2030: Open c_get_qte_info(p_qte_hdr_id);
2031: Fetch c_get_qte_info into l_LAST_UPDATE_DATE,l_object_version_number;

Line 2042: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2038: raise FND_API.G_EXC_ERROR;
2039: END IF;
2040: Close c_get_qte_info;
2041:
2042: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2043: aso_debug_pub.add('upd_status_self_appr: l_LAST_UPDATE_DATE: '|| l_LAST_UPDATE_DATE, 1, 'Y');
2044: aso_debug_pub.add('upd_status_self_appr: l_object_version_number: '|| l_object_version_number,1,'Y');
2045: END IF;
2046:

Line 2043: aso_debug_pub.add('upd_status_self_appr: l_LAST_UPDATE_DATE: '|| l_LAST_UPDATE_DATE, 1, 'Y');

2039: END IF;
2040: Close c_get_qte_info;
2041:
2042: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2043: aso_debug_pub.add('upd_status_self_appr: l_LAST_UPDATE_DATE: '|| l_LAST_UPDATE_DATE, 1, 'Y');
2044: aso_debug_pub.add('upd_status_self_appr: l_object_version_number: '|| l_object_version_number,1,'Y');
2045: END IF;
2046:
2047: If (l_last_update_date is NULL or l_last_update_date = FND_API.G_MISS_Date ) Then

Line 2044: aso_debug_pub.add('upd_status_self_appr: l_object_version_number: '|| l_object_version_number,1,'Y');

2040: Close c_get_qte_info;
2041:
2042: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2043: aso_debug_pub.add('upd_status_self_appr: l_LAST_UPDATE_DATE: '|| l_LAST_UPDATE_DATE, 1, 'Y');
2044: aso_debug_pub.add('upd_status_self_appr: l_object_version_number: '|| l_object_version_number,1,'Y');
2045: END IF;
2046:
2047: If (l_last_update_date is NULL or l_last_update_date = FND_API.G_MISS_Date ) Then
2048: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 2068: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2064: End if;
2065:
2066: OPEN C_Get_Status;
2067: FETCH C_Get_Status into l_status_id;
2068: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2069: aso_debug_pub.add('upd_status_self_appr: l_status_id: '|| l_status_id, 1, 'Y');
2070: END IF;
2071:
2072: CLOSE C_Get_Status;

Line 2069: aso_debug_pub.add('upd_status_self_appr: l_status_id: '|| l_status_id, 1, 'Y');

2065:
2066: OPEN C_Get_Status;
2067: FETCH C_Get_Status into l_status_id;
2068: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2069: aso_debug_pub.add('upd_status_self_appr: l_status_id: '|| l_status_id, 1, 'Y');
2070: END IF;
2071:
2072: CLOSE C_Get_Status;
2073: -- set the out variables

Line 2093: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2089: x_msg_data := fnd_msg_pub.get(p_msg_index => k,
2090: p_encoded => 'F');
2091: end loop;
2092:
2093: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2094: aso_debug_pub.add('upd_status_self_appr: END ', 1, 'Y');
2095: END IF;
2096:
2097: EXCEPTION

Line 2094: aso_debug_pub.add('upd_status_self_appr: END ', 1, 'Y');

2090: p_encoded => 'F');
2091: end loop;
2092:
2093: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2094: aso_debug_pub.add('upd_status_self_appr: END ', 1, 'Y');
2095: END IF;
2096:
2097: EXCEPTION
2098: WHEN fnd_api.g_exc_error