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_PA_APR_INT dependencies on ASO_DEBUG_PUB

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

109: l_displayname varchar2(320);
110: j integer:=0;
111:
112: BEGIN
113: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
114: aso_debug_pub.ADD (
115: 'Begin get_all_approvers',
116: 1,
117: 'N'

Line 114: aso_debug_pub.ADD (

110: j integer:=0;
111:
112: BEGIN
113: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
114: aso_debug_pub.ADD (
115: 'Begin get_all_approvers',
116: 1,
117: 'N'
118: );

Line 119: aso_debug_pub.ADD (

115: 'Begin get_all_approvers',
116: 1,
117: 'N'
118: );
119: aso_debug_pub.ADD (
120: 'Application ID : ' || p_application_id,
121: 1,
122: 'N'
123: );

Line 124: aso_debug_pub.ADD (

120: 'Application ID : ' || p_application_id,
121: 1,
122: 'N'
123: );
124: aso_debug_pub.ADD (
125: 'Object ID : ' || p_object_id,
126: 1,
127: 'N'
128: );

Line 129: aso_debug_pub.ADD (

125: 'Object ID : ' || p_object_id,
126: 1,
127: 'N'
128: );
129: aso_debug_pub.ADD (
130: 'Object Type : ' || p_object_type,
131: 1,
132: 'N'
133: );

Line 134: aso_debug_pub.ADD (

130: 'Object Type : ' || p_object_type,
131: 1,
132: 'N'
133: );
134: aso_debug_pub.ADD (
135: 'Commit Flag : ' || p_commit,
136: 1,
137: 'N'
138: );

Line 139: aso_debug_pub.ADD (

135: 'Commit Flag : ' || p_commit,
136: 1,
137: 'N'
138: );
139: aso_debug_pub.ADD (
140: 'Data Flag : ' || p_data_flag,
141: 1,
142: 'N'
143: );

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

143: );
144: END IF;
145: -- Standard call to establisg savepoint .
146:
147: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
148: aso_debug_pub.ADD (
149: 'Establishing save point GET_ALL_APPROVERS_INT',
150: 1,
151: 'N'

Line 148: aso_debug_pub.ADD (

144: END IF;
145: -- Standard call to establisg savepoint .
146:
147: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
148: aso_debug_pub.ADD (
149: 'Establishing save point GET_ALL_APPROVERS_INT',
150: 1,
151: 'N'
152: );

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

161: l_api_name,
162: g_pkg_name
163: )
164: THEN
165: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
166: aso_debug_pub.ADD (
167: 'GET_ALL_APROVERS api call was not compatible pls check version ',
168: 1,
169: 'N'

Line 166: aso_debug_pub.ADD (

162: g_pkg_name
163: )
164: THEN
165: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
166: aso_debug_pub.ADD (
167: 'GET_ALL_APROVERS api call was not compatible pls check version ',
168: 1,
169: 'N'
170: );

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

177: IF fnd_api.to_boolean (
178: p_init_msg_list
179: )
180: THEN
181: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
182: aso_debug_pub.ADD (
183: 'Initializing the message list ',
184: 1,
185: 'N'

Line 182: aso_debug_pub.ADD (

178: p_init_msg_list
179: )
180: THEN
181: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
182: aso_debug_pub.ADD (
183: 'Initializing the message list ',
184: 1,
185: 'N'
186: );

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

194:
195: --pp_debug('p_data_flag'||p_data_flag);
196: --pp_debug('p_object_approval_id'||p_object_approval_id);
197:
198: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
199: aso_debug_pub.ADD ('Inside get_all_approvers p_data_flag'||p_data_flag,1,'N');
200: aso_debug_pub.ADD ('Inside get_all_approvers p_object_approval_id'||p_object_approval_id,1,'N');
201: END IF;
202:

Line 199: aso_debug_pub.ADD ('Inside get_all_approvers p_data_flag'||p_data_flag,1,'N');

195: --pp_debug('p_data_flag'||p_data_flag);
196: --pp_debug('p_object_approval_id'||p_object_approval_id);
197:
198: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
199: aso_debug_pub.ADD ('Inside get_all_approvers p_data_flag'||p_data_flag,1,'N');
200: aso_debug_pub.ADD ('Inside get_all_approvers p_object_approval_id'||p_object_approval_id,1,'N');
201: END IF;
202:
203: if (p_data_flag='W') or (p_data_flag='N') then

Line 200: aso_debug_pub.ADD ('Inside get_all_approvers p_object_approval_id'||p_object_approval_id,1,'N');

196: --pp_debug('p_object_approval_id'||p_object_approval_id);
197:
198: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
199: aso_debug_pub.ADD ('Inside get_all_approvers p_data_flag'||p_data_flag,1,'N');
200: aso_debug_pub.ADD ('Inside get_all_approvers p_object_approval_id'||p_object_approval_id,1,'N');
201: END IF;
202:
203: if (p_data_flag='W') or (p_data_flag='N') then
204: if p_object_approval_id is not null then

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

205: select approval_Status into l_appr_instance_status
206: from aso_apr_obj_approvals
207: where object_approval_id= p_object_approval_id;
208: end if;
209: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
210: aso_debug_pub.ADD ('Inside get_all_approvers approval_Status'||l_appr_instance_status,1,'N');
211: END IF;
212:
213:

Line 210: aso_debug_pub.ADD ('Inside get_all_approvers approval_Status'||l_appr_instance_status,1,'N');

206: from aso_apr_obj_approvals
207: where object_approval_id= p_object_approval_id;
208: end if;
209: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
210: aso_debug_pub.ADD ('Inside get_all_approvers approval_Status'||l_appr_instance_status,1,'N');
211: END IF;
212:
213:
214: end if;

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

218: IF fnd_api.to_boolean (
219: p_clear_transaction_flag
220: )
221: THEN
222: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
223: aso_debug_pub.ADD (
224: 'clearing all previous transactions in AME ',
225: 1,
226: 'N'

Line 223: aso_debug_pub.ADD (

219: p_clear_transaction_flag
220: )
221: THEN
222: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
223: aso_debug_pub.ADD (
224: 'clearing all previous transactions in AME ',
225: 1,
226: 'N'
227: );

Line 228: aso_debug_pub.ADD (

224: 'clearing all previous transactions in AME ',
225: 1,
226: 'N'
227: );
228: aso_debug_pub.ADD (
229: 'Calling AME clearAllApprovals',
230: 1,
231: 'N'
232: );

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

244: if (p_Data_flag='Y') or (p_data_flag='W' and l_appr_instance_status ='PEND') or (p_Data_flag='N' and l_appr_instance_status='PEND') then
245: --pp_debug('Begore call to AME');
246: -- Calling the AME API to get all the approvers -----
247:
248: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
249: aso_debug_pub.ADD (
250: 'Calling AME get All Approvers Procedure',
251: 1,
252: 'N'

Line 249: aso_debug_pub.ADD (

245: --pp_debug('Begore call to AME');
246: -- Calling the AME API to get all the approvers -----
247:
248: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
249: aso_debug_pub.ADD (
250: 'Calling AME get All Approvers Procedure',
251: 1,
252: 'N'
253: );

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

274: j:=0;
275: approvers2:=ame_util.emptyApproversTable2;
276: for c1 in get_approver_details(p_object_approval_id) loop
277:
278: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
279: aso_debug_pub.ADD ('get_approver_details: c1.name'||c1.name,1,'N');
280: end if;
281:
282:

Line 279: aso_debug_pub.ADD ('get_approver_details: c1.name'||c1.name,1,'N');

275: approvers2:=ame_util.emptyApproversTable2;
276: for c1 in get_approver_details(p_object_approval_id) loop
277:
278: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
279: aso_debug_pub.ADD ('get_approver_details: c1.name'||c1.name,1,'N');
280: end if;
281:
282:
283: If c1.name is null then -- for backward compatibility

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

292: else
293: l_name:=c1.name;
294: end if;
295:
296: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
297: aso_debug_pub.ADD ('l_name'||l_name,1,'N');
298: end if;
299: approverrecord2:=ame_util.emptyApproverRecord2;
300: j:=j+1;

Line 297: aso_debug_pub.ADD ('l_name'||l_name,1,'N');

293: l_name:=c1.name;
294: end if;
295:
296: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
297: aso_debug_pub.ADD ('l_name'||l_name,1,'N');
298: end if;
299: approverrecord2:=ame_util.emptyApproverRecord2;
300: j:=j+1;
301: approverrecord2.name:=c1.name;

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

322:
323: end if;
324:
325: --pp_debug( 'Approvers2 Count is ' || approvers2.COUNT);
326: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
327: aso_debug_pub.ADD ( 'Approvers2 Count is ' || approvers2.COUNT, 1, 'N');
328: aso_debug_pub.ADD ( 'approvalProcessCompleteYN =' || approvalProcessCompleteYN, 1, 'N');
329: END IF;
330:

Line 327: aso_debug_pub.ADD ( 'Approvers2 Count is ' || approvers2.COUNT, 1, 'N');

323: end if;
324:
325: --pp_debug( 'Approvers2 Count is ' || approvers2.COUNT);
326: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
327: aso_debug_pub.ADD ( 'Approvers2 Count is ' || approvers2.COUNT, 1, 'N');
328: aso_debug_pub.ADD ( 'approvalProcessCompleteYN =' || approvalProcessCompleteYN, 1, 'N');
329: END IF;
330:
331:

Line 328: aso_debug_pub.ADD ( 'approvalProcessCompleteYN =' || approvalProcessCompleteYN, 1, 'N');

324:
325: --pp_debug( 'Approvers2 Count is ' || approvers2.COUNT);
326: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
327: aso_debug_pub.ADD ( 'Approvers2 Count is ' || approvers2.COUNT, 1, 'N');
328: aso_debug_pub.ADD ( 'approvalProcessCompleteYN =' || approvalProcessCompleteYN, 1, 'N');
329: END IF;
330:
331:
332: -- Added code to check if it is a self-approval case

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

332: -- Added code to check if it is a self-approval case
333: IF (approvers2.count = 0) THEN
334:
335: -- the requester is approver in this case
336: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
337: aso_debug_pub.add('Self approval case -- requester is only approver', 1, 'N');
338: END IF;
339: NULL;
340:

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

333: IF (approvers2.count = 0) THEN
334:
335: -- the requester is approver in this case
336: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
337: aso_debug_pub.add('Self approval case -- requester is only approver', 1, 'N');
338: END IF;
339: NULL;
340:
341: ELSE

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

356: tempOrigSystem := approvers2(i).orig_system;
357: tempOrigSystemId := approvers2(i).orig_system_id;
358: end if;
359:
360: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
361: aso_debug_pub.ADD ('approvers2(i).orig_system'||approvers2(i).orig_system,1,'N' );
362: aso_debug_pub.ADD ('approvers2(i).orig_system_id'||approvers2(i).orig_system_id,1,'N' );
363: aso_debug_pub.ADD ('tempOrigSystem '||tempOrigSystem,1,'N' );
364: aso_debug_pub.ADD ('tempOrigSystemId '||tempOrigSystemId,1,'N' );

Line 361: aso_debug_pub.ADD ('approvers2(i).orig_system'||approvers2(i).orig_system,1,'N' );

357: tempOrigSystemId := approvers2(i).orig_system_id;
358: end if;
359:
360: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
361: aso_debug_pub.ADD ('approvers2(i).orig_system'||approvers2(i).orig_system,1,'N' );
362: aso_debug_pub.ADD ('approvers2(i).orig_system_id'||approvers2(i).orig_system_id,1,'N' );
363: aso_debug_pub.ADD ('tempOrigSystem '||tempOrigSystem,1,'N' );
364: aso_debug_pub.ADD ('tempOrigSystemId '||tempOrigSystemId,1,'N' );
365: end if;

Line 362: aso_debug_pub.ADD ('approvers2(i).orig_system_id'||approvers2(i).orig_system_id,1,'N' );

358: end if;
359:
360: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
361: aso_debug_pub.ADD ('approvers2(i).orig_system'||approvers2(i).orig_system,1,'N' );
362: aso_debug_pub.ADD ('approvers2(i).orig_system_id'||approvers2(i).orig_system_id,1,'N' );
363: aso_debug_pub.ADD ('tempOrigSystem '||tempOrigSystem,1,'N' );
364: aso_debug_pub.ADD ('tempOrigSystemId '||tempOrigSystemId,1,'N' );
365: end if;
366:

Line 363: aso_debug_pub.ADD ('tempOrigSystem '||tempOrigSystem,1,'N' );

359:
360: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
361: aso_debug_pub.ADD ('approvers2(i).orig_system'||approvers2(i).orig_system,1,'N' );
362: aso_debug_pub.ADD ('approvers2(i).orig_system_id'||approvers2(i).orig_system_id,1,'N' );
363: aso_debug_pub.ADD ('tempOrigSystem '||tempOrigSystem,1,'N' );
364: aso_debug_pub.ADD ('tempOrigSystemId '||tempOrigSystemId,1,'N' );
365: end if;
366:
367: if tempOrigSystem = ame_util.perOrigSystem then

Line 364: aso_debug_pub.ADD ('tempOrigSystemId '||tempOrigSystemId,1,'N' );

360: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
361: aso_debug_pub.ADD ('approvers2(i).orig_system'||approvers2(i).orig_system,1,'N' );
362: aso_debug_pub.ADD ('approvers2(i).orig_system_id'||approvers2(i).orig_system_id,1,'N' );
363: aso_debug_pub.ADD ('tempOrigSystem '||tempOrigSystem,1,'N' );
364: aso_debug_pub.ADD ('tempOrigSystemId '||tempOrigSystemId,1,'N' );
365: end if;
366:
367: if tempOrigSystem = ame_util.perOrigSystem then
368: x_approvers_list(m).approver_user_id := null;

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

456: x_approvers_list ( m).chain_number := approvers2(i).group_or_chain_id;
457: x_approvers_list ( m).occurrence := approvers2(i).occurrence;
458:
459:
460: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
461: aso_debug_pub.ADD ( 'Approver Sequence : ' || approvers2(i).approver_order_number, 1, 'N');
462: aso_debug_pub.ADD ( 'Approver category : ' || x_approvers_list (m).approver_category, 1, 'N');
463: aso_debug_pub.ADD ( 'Approver name = ' || approvers2(i).name, 1, 'N');
464: aso_debug_pub.ADD ( 'Approver display name = ' || approvers2(i).display_name, 1, 'N');

Line 461: aso_debug_pub.ADD ( 'Approver Sequence : ' || approvers2(i).approver_order_number, 1, 'N');

457: x_approvers_list ( m).occurrence := approvers2(i).occurrence;
458:
459:
460: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
461: aso_debug_pub.ADD ( 'Approver Sequence : ' || approvers2(i).approver_order_number, 1, 'N');
462: aso_debug_pub.ADD ( 'Approver category : ' || x_approvers_list (m).approver_category, 1, 'N');
463: aso_debug_pub.ADD ( 'Approver name = ' || approvers2(i).name, 1, 'N');
464: aso_debug_pub.ADD ( 'Approver display name = ' || approvers2(i).display_name, 1, 'N');
465: aso_debug_pub.ADD ( 'item_class = ' || approvers2(i).item_class, 1, 'N');

Line 462: aso_debug_pub.ADD ( 'Approver category : ' || x_approvers_list (m).approver_category, 1, 'N');

458:
459:
460: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
461: aso_debug_pub.ADD ( 'Approver Sequence : ' || approvers2(i).approver_order_number, 1, 'N');
462: aso_debug_pub.ADD ( 'Approver category : ' || x_approvers_list (m).approver_category, 1, 'N');
463: aso_debug_pub.ADD ( 'Approver name = ' || approvers2(i).name, 1, 'N');
464: aso_debug_pub.ADD ( 'Approver display name = ' || approvers2(i).display_name, 1, 'N');
465: aso_debug_pub.ADD ( 'item_class = ' || approvers2(i).item_class, 1, 'N');
466: aso_debug_pub.ADD ( 'item_id = ' || approvers2(i).item_id, 1, 'N');

Line 463: aso_debug_pub.ADD ( 'Approver name = ' || approvers2(i).name, 1, 'N');

459:
460: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
461: aso_debug_pub.ADD ( 'Approver Sequence : ' || approvers2(i).approver_order_number, 1, 'N');
462: aso_debug_pub.ADD ( 'Approver category : ' || x_approvers_list (m).approver_category, 1, 'N');
463: aso_debug_pub.ADD ( 'Approver name = ' || approvers2(i).name, 1, 'N');
464: aso_debug_pub.ADD ( 'Approver display name = ' || approvers2(i).display_name, 1, 'N');
465: aso_debug_pub.ADD ( 'item_class = ' || approvers2(i).item_class, 1, 'N');
466: aso_debug_pub.ADD ( 'item_id = ' || approvers2(i).item_id, 1, 'N');
467: aso_debug_pub.ADD ( 'action type = ' || x_approvers_list(m).action_type, 1, 'N');

Line 464: aso_debug_pub.ADD ( 'Approver display name = ' || approvers2(i).display_name, 1, 'N');

460: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
461: aso_debug_pub.ADD ( 'Approver Sequence : ' || approvers2(i).approver_order_number, 1, 'N');
462: aso_debug_pub.ADD ( 'Approver category : ' || x_approvers_list (m).approver_category, 1, 'N');
463: aso_debug_pub.ADD ( 'Approver name = ' || approvers2(i).name, 1, 'N');
464: aso_debug_pub.ADD ( 'Approver display name = ' || approvers2(i).display_name, 1, 'N');
465: aso_debug_pub.ADD ( 'item_class = ' || approvers2(i).item_class, 1, 'N');
466: aso_debug_pub.ADD ( 'item_id = ' || approvers2(i).item_id, 1, 'N');
467: aso_debug_pub.ADD ( 'action type = ' || x_approvers_list(m).action_type, 1, 'N');
468: aso_debug_pub.ADD ( 'The person_id is ' || x_approvers_list ( m).approver_person_id, 1, 'N');

Line 465: aso_debug_pub.ADD ( 'item_class = ' || approvers2(i).item_class, 1, 'N');

461: aso_debug_pub.ADD ( 'Approver Sequence : ' || approvers2(i).approver_order_number, 1, 'N');
462: aso_debug_pub.ADD ( 'Approver category : ' || x_approvers_list (m).approver_category, 1, 'N');
463: aso_debug_pub.ADD ( 'Approver name = ' || approvers2(i).name, 1, 'N');
464: aso_debug_pub.ADD ( 'Approver display name = ' || approvers2(i).display_name, 1, 'N');
465: aso_debug_pub.ADD ( 'item_class = ' || approvers2(i).item_class, 1, 'N');
466: aso_debug_pub.ADD ( 'item_id = ' || approvers2(i).item_id, 1, 'N');
467: aso_debug_pub.ADD ( 'action type = ' || x_approvers_list(m).action_type, 1, 'N');
468: aso_debug_pub.ADD ( 'The person_id is ' || x_approvers_list ( m).approver_person_id, 1, 'N');
469: aso_debug_pub.ADD ( 'The user_id is ' || x_approvers_list ( m).approver_user_id, 1, 'N');

Line 466: aso_debug_pub.ADD ( 'item_id = ' || approvers2(i).item_id, 1, 'N');

462: aso_debug_pub.ADD ( 'Approver category : ' || x_approvers_list (m).approver_category, 1, 'N');
463: aso_debug_pub.ADD ( 'Approver name = ' || approvers2(i).name, 1, 'N');
464: aso_debug_pub.ADD ( 'Approver display name = ' || approvers2(i).display_name, 1, 'N');
465: aso_debug_pub.ADD ( 'item_class = ' || approvers2(i).item_class, 1, 'N');
466: aso_debug_pub.ADD ( 'item_id = ' || approvers2(i).item_id, 1, 'N');
467: aso_debug_pub.ADD ( 'action type = ' || x_approvers_list(m).action_type, 1, 'N');
468: aso_debug_pub.ADD ( 'The person_id is ' || x_approvers_list ( m).approver_person_id, 1, 'N');
469: aso_debug_pub.ADD ( 'The user_id is ' || x_approvers_list ( m).approver_user_id, 1, 'N');
470: END IF;

Line 467: aso_debug_pub.ADD ( 'action type = ' || x_approvers_list(m).action_type, 1, 'N');

463: aso_debug_pub.ADD ( 'Approver name = ' || approvers2(i).name, 1, 'N');
464: aso_debug_pub.ADD ( 'Approver display name = ' || approvers2(i).display_name, 1, 'N');
465: aso_debug_pub.ADD ( 'item_class = ' || approvers2(i).item_class, 1, 'N');
466: aso_debug_pub.ADD ( 'item_id = ' || approvers2(i).item_id, 1, 'N');
467: aso_debug_pub.ADD ( 'action type = ' || x_approvers_list(m).action_type, 1, 'N');
468: aso_debug_pub.ADD ( 'The person_id is ' || x_approvers_list ( m).approver_person_id, 1, 'N');
469: aso_debug_pub.ADD ( 'The user_id is ' || x_approvers_list ( m).approver_user_id, 1, 'N');
470: END IF;
471:

Line 468: aso_debug_pub.ADD ( 'The person_id is ' || x_approvers_list ( m).approver_person_id, 1, 'N');

464: aso_debug_pub.ADD ( 'Approver display name = ' || approvers2(i).display_name, 1, 'N');
465: aso_debug_pub.ADD ( 'item_class = ' || approvers2(i).item_class, 1, 'N');
466: aso_debug_pub.ADD ( 'item_id = ' || approvers2(i).item_id, 1, 'N');
467: aso_debug_pub.ADD ( 'action type = ' || x_approvers_list(m).action_type, 1, 'N');
468: aso_debug_pub.ADD ( 'The person_id is ' || x_approvers_list ( m).approver_person_id, 1, 'N');
469: aso_debug_pub.ADD ( 'The user_id is ' || x_approvers_list ( m).approver_user_id, 1, 'N');
470: END IF;
471:
472: END LOOP;

Line 469: aso_debug_pub.ADD ( 'The user_id is ' || x_approvers_list ( m).approver_user_id, 1, 'N');

465: aso_debug_pub.ADD ( 'item_class = ' || approvers2(i).item_class, 1, 'N');
466: aso_debug_pub.ADD ( 'item_id = ' || approvers2(i).item_id, 1, 'N');
467: aso_debug_pub.ADD ( 'action type = ' || x_approvers_list(m).action_type, 1, 'N');
468: aso_debug_pub.ADD ( 'The person_id is ' || x_approvers_list ( m).approver_person_id, 1, 'N');
469: aso_debug_pub.ADD ( 'The user_id is ' || x_approvers_list ( m).approver_user_id, 1, 'N');
470: END IF;
471:
472: END LOOP;
473:

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

519:
520: FOR i IN 1 .. ruleids.COUNT
521: LOOP
522:
523: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
524: aso_debug_pub.ADD ('Calling AME get applicable rules procedure'|| ruleids.COUNT,1,'N');
525: END IF;
526:
527: IF i > 1 THEN

Line 524: aso_debug_pub.ADD ('Calling AME get applicable rules procedure'|| ruleids.COUNT,1,'N');

520: FOR i IN 1 .. ruleids.COUNT
521: LOOP
522:
523: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
524: aso_debug_pub.ADD ('Calling AME get applicable rules procedure'|| ruleids.COUNT,1,'N');
525: END IF;
526:
527: IF i > 1 THEN
528:

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

525: END IF;
526:
527: IF i > 1 THEN
528:
529: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
530: aso_debug_pub.ADD (' Checking for duplicate ruleids.. ',1,'N');
531: END IF;
532:
533:

Line 530: aso_debug_pub.ADD (' Checking for duplicate ruleids.. ',1,'N');

526:
527: IF i > 1 THEN
528:
529: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
530: aso_debug_pub.ADD (' Checking for duplicate ruleids.. ',1,'N');
531: END IF;
532:
533:
534: FOR j IN 1..x_rules_list.COUNT LOOP

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

534: FOR j IN 1..x_rules_list.COUNT LOOP
535:
536: IF ( ruleids(i) = x_rules_list(j).rule_id ) THEN
537:
538: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
539: aso_debug_pub.ADD ('Found a duplicate rule ',1,'N');
540: aso_debug_pub.ADD ('Duplicate rule_id is '|| ruleids(i),1,'N');
541:
542: END IF;

Line 539: aso_debug_pub.ADD ('Found a duplicate rule ',1,'N');

535:
536: IF ( ruleids(i) = x_rules_list(j).rule_id ) THEN
537:
538: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
539: aso_debug_pub.ADD ('Found a duplicate rule ',1,'N');
540: aso_debug_pub.ADD ('Duplicate rule_id is '|| ruleids(i),1,'N');
541:
542: END IF;
543:

Line 540: aso_debug_pub.ADD ('Duplicate rule_id is '|| ruleids(i),1,'N');

536: IF ( ruleids(i) = x_rules_list(j).rule_id ) THEN
537:
538: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
539: aso_debug_pub.ADD ('Found a duplicate rule ',1,'N');
540: aso_debug_pub.ADD ('Duplicate rule_id is '|| ruleids(i),1,'N');
541:
542: END IF;
543:
544: GOTO end_of_loop;

Line 551: aso_debug_pub.add('Rule id'||ruleids(I), 1, 'N');

547: END LOOP;
548:
549: END IF;
550:
551: aso_debug_pub.add('Rule id'||ruleids(I), 1, 'N');
552: ame_api3.getruledetails3 (
553: ruleIdIn => ruleids(i),
554: ruleTypeOut => l_ruletypeout,
555: ruleDescriptionOut => lRuleDescription,

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

565: m := x_rules_list.count + 1;
566: end if;
567:
568:
569: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
570: aso_debug_pub.ADD ( 'm= '||m, 1, 'N');
571: aso_debug_pub.ADD ( 'l_actionDescriptionsOut.count = '||l_actionDescriptionsOut.count, 1, 'N');
572: end if;
573:

Line 570: aso_debug_pub.ADD ( 'm= '||m, 1, 'N');

566: end if;
567:
568:
569: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
570: aso_debug_pub.ADD ( 'm= '||m, 1, 'N');
571: aso_debug_pub.ADD ( 'l_actionDescriptionsOut.count = '||l_actionDescriptionsOut.count, 1, 'N');
572: end if;
573:
574: aso_debug_pub.ADD ('m '||m, 1, 'N');

Line 571: aso_debug_pub.ADD ( 'l_actionDescriptionsOut.count = '||l_actionDescriptionsOut.count, 1, 'N');

567:
568:
569: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
570: aso_debug_pub.ADD ( 'm= '||m, 1, 'N');
571: aso_debug_pub.ADD ( 'l_actionDescriptionsOut.count = '||l_actionDescriptionsOut.count, 1, 'N');
572: end if;
573:
574: aso_debug_pub.ADD ('m '||m, 1, 'N');
575: aso_debug_pub.ADD ('l_actionDescriptionsOut'||l_actionDescriptionsOut.count, 1, 'N');

Line 574: aso_debug_pub.ADD ('m '||m, 1, 'N');

570: aso_debug_pub.ADD ( 'm= '||m, 1, 'N');
571: aso_debug_pub.ADD ( 'l_actionDescriptionsOut.count = '||l_actionDescriptionsOut.count, 1, 'N');
572: end if;
573:
574: aso_debug_pub.ADD ('m '||m, 1, 'N');
575: aso_debug_pub.ADD ('l_actionDescriptionsOut'||l_actionDescriptionsOut.count, 1, 'N');
576:
577:
578: for r in 1..l_actionDescriptionsOut.COUNT

Line 575: aso_debug_pub.ADD ('l_actionDescriptionsOut'||l_actionDescriptionsOut.count, 1, 'N');

571: aso_debug_pub.ADD ( 'l_actionDescriptionsOut.count = '||l_actionDescriptionsOut.count, 1, 'N');
572: end if;
573:
574: aso_debug_pub.ADD ('m '||m, 1, 'N');
575: aso_debug_pub.ADD ('l_actionDescriptionsOut'||l_actionDescriptionsOut.count, 1, 'N');
576:
577:
578: for r in 1..l_actionDescriptionsOut.COUNT
579: loop

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

631: IF fnd_api.to_boolean (
632: p_commit
633: )
634: THEN
635: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
636: aso_debug_pub.ADD (
637: 'Commiting the work in get_all_approvers procedure ',
638: 1,
639: 'N'

Line 636: aso_debug_pub.ADD (

632: p_commit
633: )
634: THEN
635: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
636: aso_debug_pub.ADD (
637: 'Commiting the work in get_all_approvers procedure ',
638: 1,
639: 'N'
640: );

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

641: END IF;
642: COMMIT WORK;
643: END IF;
644:
645: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
646: aso_debug_pub.ADD (
647: 'End get all pa approvers procedure ',
648: 1,
649: 'N'

Line 646: aso_debug_pub.ADD (

642: COMMIT WORK;
643: END IF;
644:
645: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
646: aso_debug_pub.ADD (
647: 'End get all pa approvers procedure ',
648: 1,
649: 'N'
650: );

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

651: END IF;
652: EXCEPTION
653: WHEN fnd_api.g_exc_error
654: THEN
655: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
656: aso_debug_pub.ADD (
657: 'Exception FND_API.G_EXC_ERROR in get_all_approvers ',
658: 1,
659: 'N'

Line 656: aso_debug_pub.ADD (

652: EXCEPTION
653: WHEN fnd_api.g_exc_error
654: THEN
655: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
656: aso_debug_pub.ADD (
657: 'Exception FND_API.G_EXC_ERROR in get_all_approvers ',
658: 1,
659: 'N'
660: );

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

671: x_return_status => x_return_status
672: );
673: WHEN fnd_api.g_exc_unexpected_error
674: THEN
675: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
676: aso_debug_pub.ADD (
677: 'Exception FND_API.G_EXC_UNEXPECTED_ERROR in get_all_approvers ',
678: 1,
679: 'N'

Line 676: aso_debug_pub.ADD (

672: );
673: WHEN fnd_api.g_exc_unexpected_error
674: THEN
675: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
676: aso_debug_pub.ADD (
677: 'Exception FND_API.G_EXC_UNEXPECTED_ERROR in get_all_approvers ',
678: 1,
679: 'N'
680: );

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

691: x_return_status => x_return_status
692: );
693: WHEN OTHERS
694: THEN
695: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
696: aso_debug_pub.ADD (
697: 'When Others Exception in get_all_approvers ',
698: 1,
699: 'N'

Line 696: aso_debug_pub.ADD (

692: );
693: WHEN OTHERS
694: THEN
695: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
696: aso_debug_pub.ADD (
697: 'When Others Exception in get_all_approvers ',
698: 1,
699: 'N'
700: );

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

770: AND approval_status = 'PEND';
771:
772: BEGIN
773: g_user_id := fnd_global.user_id;
774: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
775: aso_debug_pub.ADD (
776: 'Begin start_papproval_process procedure ',
777: 1,
778: 'N'

Line 775: aso_debug_pub.ADD (

771:
772: BEGIN
773: g_user_id := fnd_global.user_id;
774: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
775: aso_debug_pub.ADD (
776: 'Begin start_papproval_process procedure ',
777: 1,
778: 'N'
779: );

Line 780: aso_debug_pub.ADD (

776: 'Begin start_papproval_process procedure ',
777: 1,
778: 'N'
779: );
780: aso_debug_pub.ADD (
781: 'Application ID : ' || p_application_id,
782: 1,
783: 'N'
784: );

Line 785: aso_debug_pub.ADD (

781: 'Application ID : ' || p_application_id,
782: 1,
783: 'N'
784: );
785: aso_debug_pub.ADD (
786: 'Object ID : ' || p_object_id,
787: 1,
788: 'N'
789: );

Line 790: aso_debug_pub.ADD (

786: 'Object ID : ' || p_object_id,
787: 1,
788: 'N'
789: );
790: aso_debug_pub.ADD (
791: 'Object Type : ' || p_object_type,
792: 1,
793: 'N'
794: );

Line 795: aso_debug_pub.ADD (

791: 'Object Type : ' || p_object_type,
792: 1,
793: 'N'
794: );
795: aso_debug_pub.ADD (
796: 'Commit Flag : ' || p_commit,
797: 1,
798: 'N'
799: );

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

799: );
800: END IF;
801: -- Standard call to establisg savepoint .
802:
803: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
804: aso_debug_pub.ADD (
805: 'Establishing save point START_PAPPROVAL_PROCESS_INT',
806: 1,
807: 'N'

Line 804: aso_debug_pub.ADD (

800: END IF;
801: -- Standard call to establisg savepoint .
802:
803: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
804: aso_debug_pub.ADD (
805: 'Establishing save point START_PAPPROVAL_PROCESS_INT',
806: 1,
807: 'N'
808: );

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

816: l_api_name,
817: g_pkg_name
818: )
819: THEN
820: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
821: aso_debug_pub.ADD (
822: 'START_PAPPROVAL_PROCESS api call was not compatible pls check version ',
823: 1,
824: 'N'

Line 821: aso_debug_pub.ADD (

817: g_pkg_name
818: )
819: THEN
820: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
821: aso_debug_pub.ADD (
822: 'START_PAPPROVAL_PROCESS api call was not compatible pls check version ',
823: 1,
824: 'N'
825: );

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

832: IF fnd_api.to_boolean (
833: p_init_msg_list
834: )
835: THEN
836: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
837: aso_debug_pub.ADD (
838: 'Initializing the message list ',
839: 1,
840: 'N'

Line 837: aso_debug_pub.ADD (

833: p_init_msg_list
834: )
835: THEN
836: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
837: aso_debug_pub.ADD (
838: 'Initializing the message list ',
839: 1,
840: 'N'
841: );

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

850: OPEN C_get_duplicate_approval;
851: FETCH C_get_duplicate_approval INTO l_dup_approval ;
852: CLOSE C_get_duplicate_approval;
853:
854: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
855: aso_debug_pub.ADD('l_dup_approval: '|| l_dup_approval,1,'N');
856: END IF;
857:
858: IF l_dup_approval = 0 THEN

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

851: FETCH C_get_duplicate_approval INTO l_dup_approval ;
852: CLOSE C_get_duplicate_approval;
853:
854: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
855: aso_debug_pub.ADD('l_dup_approval: '|| l_dup_approval,1,'N');
856: END IF;
857:
858: IF l_dup_approval = 0 THEN
859:

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

891:
892: -- Get the Requester Group id
893: begin
894:
895: IF aso_debug_pub.g_debug_flag = 'Y' THEN
896: aso_debug_pub.add('Before calling aso_utility_pvt.Get_Profile_Obsolete_Status', 1, 'N');
897: END IF;
898:
899: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',

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

892: -- Get the Requester Group id
893: begin
894:
895: IF aso_debug_pub.g_debug_flag = 'Y' THEN
896: aso_debug_pub.add('Before calling aso_utility_pvt.Get_Profile_Obsolete_Status', 1, 'N');
897: END IF;
898:
899: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
900: p_application_id => 521);

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

898:
899: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
900: p_application_id => 521);
901:
902: IF aso_debug_pub.g_debug_flag = 'Y' THEN
903: aso_debug_pub.add('After calling Get_Profile_Obsolete_Status: l_obsolete_status: ' || l_obsolete_status, 1, 'N');
904: END IF;
905:
906: if l_obsolete_status = 'T' then

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

899: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
900: p_application_id => 521);
901:
902: IF aso_debug_pub.g_debug_flag = 'Y' THEN
903: aso_debug_pub.add('After calling Get_Profile_Obsolete_Status: l_obsolete_status: ' || l_obsolete_status, 1, 'N');
904: END IF;
905:
906: if l_obsolete_status = 'T' then
907:

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

906: if l_obsolete_status = 'T' then
907:
908: l_sales_group_role := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
909:
910: IF aso_debug_pub.g_debug_flag = 'Y' THEN
911: aso_debug_pub.add('l_sales_group_role: ' || l_sales_group_role, 1, 'N');
912: END IF;
913:
914: l_requester_group_id := SUBSTR(l_sales_group_role, 1, INSTR(l_sales_group_role,'(')-1);

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

907:
908: l_sales_group_role := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
909:
910: IF aso_debug_pub.g_debug_flag = 'Y' THEN
911: aso_debug_pub.add('l_sales_group_role: ' || l_sales_group_role, 1, 'N');
912: END IF;
913:
914: l_requester_group_id := SUBSTR(l_sales_group_role, 1, INSTR(l_sales_group_role,'(')-1);
915:

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

912: END IF;
913:
914: l_requester_group_id := SUBSTR(l_sales_group_role, 1, INSTR(l_sales_group_role,'(')-1);
915:
916: IF aso_debug_pub.g_debug_flag = 'Y' THEN
917: aso_debug_pub.add('l_requester_group_id: ' || l_requester_group_id, 1, 'N');
918: END IF;
919:
920: if l_requester_group_id is null then

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

913:
914: l_requester_group_id := SUBSTR(l_sales_group_role, 1, INSTR(l_sales_group_role,'(')-1);
915:
916: IF aso_debug_pub.g_debug_flag = 'Y' THEN
917: aso_debug_pub.add('l_requester_group_id: ' || l_requester_group_id, 1, 'N');
918: END IF;
919:
920: if l_requester_group_id is null then
921:

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

920: if l_requester_group_id is null then
921:
922: l_sales_group_role := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);
923:
924: IF aso_debug_pub.g_debug_flag = 'Y' THEN
925: aso_debug_pub.add('l_sales_group_role: ' || l_sales_group_role, 1, 'N');
926: END IF;
927:
928: l_requester_group_id := to_number(l_sales_group_role);

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

921:
922: l_sales_group_role := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);
923:
924: IF aso_debug_pub.g_debug_flag = 'Y' THEN
925: aso_debug_pub.add('l_sales_group_role: ' || l_sales_group_role, 1, 'N');
926: END IF;
927:
928: l_requester_group_id := to_number(l_sales_group_role);
929:

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

926: END IF;
927:
928: l_requester_group_id := to_number(l_sales_group_role);
929:
930: IF aso_debug_pub.g_debug_flag = 'Y' THEN
931: aso_debug_pub.add('l_requester_group_id: ' || l_requester_group_id, 1, 'N');
932: END IF;
933:
934: end if;

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

927:
928: l_requester_group_id := to_number(l_sales_group_role);
929:
930: IF aso_debug_pub.g_debug_flag = 'Y' THEN
931: aso_debug_pub.add('l_requester_group_id: ' || l_requester_group_id, 1, 'N');
932: END IF;
933:
934: end if;
935:

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

936: else
937:
938: l_sales_group_role := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
939:
940: IF aso_debug_pub.g_debug_flag = 'Y' THEN
941: aso_debug_pub.add('l_sales_group_role: ' || l_sales_group_role, 1, 'N');
942: END IF;
943:
944: l_requester_group_id := SUBSTR(l_sales_group_role, 1, INSTR(l_sales_group_role,'(')-1);

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

937:
938: l_sales_group_role := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
939:
940: IF aso_debug_pub.g_debug_flag = 'Y' THEN
941: aso_debug_pub.add('l_sales_group_role: ' || l_sales_group_role, 1, 'N');
942: END IF;
943:
944: l_requester_group_id := SUBSTR(l_sales_group_role, 1, INSTR(l_sales_group_role,'(')-1);
945:

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

942: END IF;
943:
944: l_requester_group_id := SUBSTR(l_sales_group_role, 1, INSTR(l_sales_group_role,'(')-1);
945:
946: IF aso_debug_pub.g_debug_flag = 'Y' THEN
947: aso_debug_pub.add('l_requester_group_id: ' || l_requester_group_id, 1, 'N');
948: END IF;
949:
950: if l_requester_group_id is null then

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

943:
944: l_requester_group_id := SUBSTR(l_sales_group_role, 1, INSTR(l_sales_group_role,'(')-1);
945:
946: IF aso_debug_pub.g_debug_flag = 'Y' THEN
947: aso_debug_pub.add('l_requester_group_id: ' || l_requester_group_id, 1, 'N');
948: END IF;
949:
950: if l_requester_group_id is null then
951:

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

950: if l_requester_group_id is null then
951:
952: l_sales_group_role := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);
953:
954: IF aso_debug_pub.g_debug_flag = 'Y' THEN
955: aso_debug_pub.add('l_sales_group_role: ' || l_sales_group_role, 1, 'N');
956: END IF;
957:
958: l_requester_group_id := substr(l_sales_group_role, instr(l_sales_group_role,':', -1) + 1, length(l_sales_group_role));

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

951:
952: l_sales_group_role := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);
953:
954: IF aso_debug_pub.g_debug_flag = 'Y' THEN
955: aso_debug_pub.add('l_sales_group_role: ' || l_sales_group_role, 1, 'N');
956: END IF;
957:
958: l_requester_group_id := substr(l_sales_group_role, instr(l_sales_group_role,':', -1) + 1, length(l_sales_group_role));
959:

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

956: END IF;
957:
958: l_requester_group_id := substr(l_sales_group_role, instr(l_sales_group_role,':', -1) + 1, length(l_sales_group_role));
959:
960: IF aso_debug_pub.g_debug_flag = 'Y' THEN
961: aso_debug_pub.add('l_requester_group_id: ' || l_requester_group_id, 1, 'N');
962: END IF;
963:
964: end if;

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

957:
958: l_requester_group_id := substr(l_sales_group_role, instr(l_sales_group_role,':', -1) + 1, length(l_sales_group_role));
959:
960: IF aso_debug_pub.g_debug_flag = 'Y' THEN
961: aso_debug_pub.add('l_requester_group_id: ' || l_requester_group_id, 1, 'N');
962: END IF;
963:
964: end if;
965:

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

970: when others then
971: l_requester_group_id := 0;
972: end;
973:
974: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
975: aso_debug_pub.ADD (
976: 'Requester Group ID is ' || l_requester_group_id,
977: 1,
978: 'N'

Line 975: aso_debug_pub.ADD (

971: l_requester_group_id := 0;
972: end;
973:
974: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
975: aso_debug_pub.ADD (
976: 'Requester Group ID is ' || l_requester_group_id,
977: 1,
978: 'N'
979: );

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

983: p_object_id
984: );
985: FETCH c2 INTO p_approval_instance_id;
986: CLOSE c2;
987: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
988: aso_debug_pub.ADD (
989: 'Approval Instance ID is ' || p_approval_instance_id,
990: 1,
991: 'N'

Line 988: aso_debug_pub.ADD (

984: );
985: FETCH c2 INTO p_approval_instance_id;
986: CLOSE c2;
987: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
988: aso_debug_pub.ADD (
989: 'Approval Instance ID is ' || p_approval_instance_id,
990: 1,
991: 'N'
992: );

Line 993: aso_debug_pub.ADD (

989: 'Approval Instance ID is ' || p_approval_instance_id,
990: 1,
991: 'N'
992: );
993: aso_debug_pub.ADD (
994: 'Inserting a row into the header table ',
995: 1,
996: 'N'
997: );

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

1083: -- Pass back the new approval id
1084: x_object_approval_id := p_object_approval_id;
1085: x_approval_instance_id := p_approval_instance_id;
1086:
1087: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1088: aso_debug_pub.ADD (
1089: 'Object Approval ID :' || x_approval_instance_id,
1090: 1,
1091: 'N'

Line 1088: aso_debug_pub.ADD (

1084: x_object_approval_id := p_object_approval_id;
1085: x_approval_instance_id := p_approval_instance_id;
1086:
1087: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1088: aso_debug_pub.ADD (
1089: 'Object Approval ID :' || x_approval_instance_id,
1090: 1,
1091: 'N'
1092: );

Line 1093: aso_debug_pub.ADD (

1089: 'Object Approval ID :' || x_approval_instance_id,
1090: 1,
1091: 'N'
1092: );
1093: aso_debug_pub.ADD (
1094: 'Approval Instance ID :' || x_approval_instance_id,
1095: 1,
1096: 'N'
1097: );

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

1100: ELSE -- l_dup_approval is not 0
1101:
1102: -- return a dummy instance id
1103: x_approval_instance_id := -1;
1104: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1105: aso_debug_pub.ADD(' Duplicate approval process FOUND , hence another process NOT Started',1,'N');
1106: END IF;
1107: END IF;
1108:

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

1101:
1102: -- return a dummy instance id
1103: x_approval_instance_id := -1;
1104: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1105: aso_debug_pub.ADD(' Duplicate approval process FOUND , hence another process NOT Started',1,'N');
1106: END IF;
1107: END IF;
1108:
1109: -- commit the work

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

1111: IF fnd_api.to_boolean (
1112: p_commit
1113: )
1114: THEN
1115: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1116: aso_debug_pub.ADD (
1117: 'Commiting the work in START_PAPPROVAL_PROCESS procedure ',
1118: 1,
1119: 'N'

Line 1116: aso_debug_pub.ADD (

1112: p_commit
1113: )
1114: THEN
1115: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1116: aso_debug_pub.ADD (
1117: 'Commiting the work in START_PAPPROVAL_PROCESS procedure ',
1118: 1,
1119: 'N'
1120: );

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

1121: END IF;
1122: COMMIT WORK;
1123: END IF;
1124:
1125: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1126: aso_debug_pub.ADD (
1127: 'End Start_papproval_process PROCEDURE ',
1128: 1,
1129: 'N'

Line 1126: aso_debug_pub.ADD (

1122: COMMIT WORK;
1123: END IF;
1124:
1125: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1126: aso_debug_pub.ADD (
1127: 'End Start_papproval_process PROCEDURE ',
1128: 1,
1129: 'N'
1130: );

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

1131: END IF;
1132: EXCEPTION
1133: WHEN fnd_api.g_exc_error
1134: THEN
1135: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1136: aso_debug_pub.ADD (
1137: 'Exception FND_API.G_EXC_ERROR in start_papproval_process',
1138: 1,
1139: 'N'

Line 1136: aso_debug_pub.ADD (

1132: EXCEPTION
1133: WHEN fnd_api.g_exc_error
1134: THEN
1135: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1136: aso_debug_pub.ADD (
1137: 'Exception FND_API.G_EXC_ERROR in start_papproval_process',
1138: 1,
1139: 'N'
1140: );

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

1151: x_return_status => x_return_status
1152: );
1153: WHEN fnd_api.g_exc_unexpected_error
1154: THEN
1155: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1156: aso_debug_pub.ADD (
1157: 'Exception FND_API.G_EXC_UNEXPECTED_ERROR in start_papproval_process',
1158: 1,
1159: 'N'

Line 1156: aso_debug_pub.ADD (

1152: );
1153: WHEN fnd_api.g_exc_unexpected_error
1154: THEN
1155: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1156: aso_debug_pub.ADD (
1157: 'Exception FND_API.G_EXC_UNEXPECTED_ERROR in start_papproval_process',
1158: 1,
1159: 'N'
1160: );

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

1172: );
1173:
1174: WHEN OTHERS
1175: THEN
1176: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1177: aso_debug_pub.ADD (
1178: 'When Others Exception in start_papproval_process',
1179: 1,
1180: 'N'

Line 1177: aso_debug_pub.ADD (

1173:
1174: WHEN OTHERS
1175: THEN
1176: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1177: aso_debug_pub.ADD (
1178: 'When Others Exception in start_papproval_process',
1179: 1,
1180: 'N'
1181: );

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

1227: AND object_type = c_object_type);
1228:
1229:
1230: BEGIN
1231: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1232: aso_debug_pub.ADD (
1233: 'Begin cancel_approval_process PROCEDURE ',
1234: 1,
1235: 'N'

Line 1232: aso_debug_pub.ADD (

1228:
1229:
1230: BEGIN
1231: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1232: aso_debug_pub.ADD (
1233: 'Begin cancel_approval_process PROCEDURE ',
1234: 1,
1235: 'N'
1236: );

Line 1237: aso_debug_pub.ADD (

1233: 'Begin cancel_approval_process PROCEDURE ',
1234: 1,
1235: 'N'
1236: );
1237: aso_debug_pub.ADD (
1238: 'Application ID : ' || p_application_id,
1239: 1,
1240: 'N'
1241: );

Line 1242: aso_debug_pub.ADD (

1238: 'Application ID : ' || p_application_id,
1239: 1,
1240: 'N'
1241: );
1242: aso_debug_pub.ADD (
1243: 'Object ID : ' || p_object_id,
1244: 1,
1245: 'N'
1246: );

Line 1247: aso_debug_pub.ADD (

1243: 'Object ID : ' || p_object_id,
1244: 1,
1245: 'N'
1246: );
1247: aso_debug_pub.ADD (
1248: 'Object Type : ' || p_object_type,
1249: 1,
1250: 'N'
1251: );

Line 1252: aso_debug_pub.ADD (

1248: 'Object Type : ' || p_object_type,
1249: 1,
1250: 'N'
1251: );
1252: aso_debug_pub.ADD (
1253: 'Commit Flag : ' || p_commit,
1254: 1,
1255: 'N'
1256: );

Line 1257: aso_debug_pub.ADD (

1253: 'Commit Flag : ' || p_commit,
1254: 1,
1255: 'N'
1256: );
1257: aso_debug_pub.ADD (
1258: 'Object Approval Id : ' || p_object_approval_id,
1259: 1,
1260: 'N'
1261: );

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

1263:
1264:
1265: END IF;
1266: -- Set a save point
1267: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1268: aso_debug_pub.ADD (
1269: 'Establishing save point CANCEL_APPROVAL_PROCESS_INT',
1270: 1,
1271: 'N'

Line 1268: aso_debug_pub.ADD (

1264:
1265: END IF;
1266: -- Set a save point
1267: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1268: aso_debug_pub.ADD (
1269: 'Establishing save point CANCEL_APPROVAL_PROCESS_INT',
1270: 1,
1271: 'N'
1272: );

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

1280: l_api_name,
1281: g_pkg_name
1282: )
1283: THEN
1284: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1285: aso_debug_pub.ADD (
1286: 'cancel_approval_process api call was not compatible pls check version ',
1287: 1,
1288: 'N'

Line 1285: aso_debug_pub.ADD (

1281: g_pkg_name
1282: )
1283: THEN
1284: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1285: aso_debug_pub.ADD (
1286: 'cancel_approval_process api call was not compatible pls check version ',
1287: 1,
1288: 'N'
1289: );

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

1324: )
1325: LOOP
1326: -- calling the prccedure to cancel the workflow process
1327:
1328: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1329: aso_debug_pub.ADD (
1330: 'Object approval ID :' || i.object_approval_id,
1331: 1,
1332: 'N'

Line 1329: aso_debug_pub.ADD (

1325: LOOP
1326: -- calling the prccedure to cancel the workflow process
1327:
1328: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1329: aso_debug_pub.ADD (
1330: 'Object approval ID :' || i.object_approval_id,
1331: 1,
1332: 'N'
1333: );

Line 1334: aso_debug_pub.ADD (

1330: 'Object approval ID :' || i.object_approval_id,
1331: 1,
1332: 'N'
1333: );
1334: aso_debug_pub.ADD (
1335: 'Calling the wokflow procedure to start the cancellation process ',
1336: 1,
1337: 'N'
1338: );

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

1344: );
1345: END LOOP;
1346: ELSE
1347: -- calling the prccedure to cancel the workflow process
1348: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1349: aso_debug_pub.ADD (
1350: 'Object approval ID :' || p_object_approval_id,
1351: 1,
1352: 'N'

Line 1349: aso_debug_pub.ADD (

1345: END LOOP;
1346: ELSE
1347: -- calling the prccedure to cancel the workflow process
1348: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1349: aso_debug_pub.ADD (
1350: 'Object approval ID :' || p_object_approval_id,
1351: 1,
1352: 'N'
1353: );

Line 1354: aso_debug_pub.ADD (

1350: 'Object approval ID :' || p_object_approval_id,
1351: 1,
1352: 'N'
1353: );
1354: aso_debug_pub.ADD (
1355: 'Calling the wokflow procedure to start the cancellation process ',
1356: 1,
1357: 'N'
1358: );

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

1369: IF fnd_api.to_boolean (
1370: p_commit
1371: )
1372: THEN
1373: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1374: aso_debug_pub.ADD (
1375: 'Committing the work in cancel approval procedure ',
1376: 1,
1377: 'N'

Line 1374: aso_debug_pub.ADD (

1370: p_commit
1371: )
1372: THEN
1373: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1374: aso_debug_pub.ADD (
1375: 'Committing the work in cancel approval procedure ',
1376: 1,
1377: 'N'
1378: );

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

1387: x_msg_data := fnd_msg_pub.get(p_msg_index => k,
1388: p_encoded => 'F');
1389: end loop;
1390:
1391: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1392: aso_debug_pub.ADD (
1393: 'End CancelApproval procedure ',
1394: 1,
1395: 'N'

Line 1392: aso_debug_pub.ADD (

1388: p_encoded => 'F');
1389: end loop;
1390:
1391: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1392: aso_debug_pub.ADD (
1393: 'End CancelApproval procedure ',
1394: 1,
1395: 'N'
1396: );

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

1397: END IF;
1398: EXCEPTION
1399: WHEN fnd_api.g_exc_error
1400: THEN
1401: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1402: aso_debug_pub.ADD (
1403: 'Exception FND_API.G_EXC_ERROR in CancelApproval',
1404: 1,
1405: 'N'

Line 1402: aso_debug_pub.ADD (

1398: EXCEPTION
1399: WHEN fnd_api.g_exc_error
1400: THEN
1401: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1402: aso_debug_pub.ADD (
1403: 'Exception FND_API.G_EXC_ERROR in CancelApproval',
1404: 1,
1405: 'N'
1406: );

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

1417: x_return_status => x_return_status
1418: );
1419: WHEN fnd_api.g_exc_unexpected_error
1420: THEN
1421: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1422: aso_debug_pub.ADD (
1423: 'Exception FND_API.G_EXC_UNEXPECTED_ERROR in CancelApproval',
1424: 1,
1425: 'N'

Line 1422: aso_debug_pub.ADD (

1418: );
1419: WHEN fnd_api.g_exc_unexpected_error
1420: THEN
1421: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1422: aso_debug_pub.ADD (
1423: 'Exception FND_API.G_EXC_UNEXPECTED_ERROR in CancelApproval',
1424: 1,
1425: 'N'
1426: );

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

1437: x_return_status => x_return_status
1438: );
1439: WHEN OTHERS
1440: THEN
1441: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1442: aso_debug_pub.ADD (
1443: 'When Others Exception in CancelApproval',
1444: 1,
1445: 'N'

Line 1442: aso_debug_pub.ADD (

1438: );
1439: WHEN OTHERS
1440: THEN
1441: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1442: aso_debug_pub.ADD (
1443: 'When Others Exception in CancelApproval',
1444: 1,
1445: 'N'
1446: );

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

1475: l_api_version CONSTANT NUMBER := 1.0;
1476:
1477:
1478: BEGIN
1479: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1480: aso_debug_pub.ADD (
1481: 'Start of start_pa_approval_workflow',
1482: 1,
1483: 'N'

Line 1480: aso_debug_pub.ADD (

1476:
1477:
1478: BEGIN
1479: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1480: aso_debug_pub.ADD (
1481: 'Start of start_pa_approval_workflow',
1482: 1,
1483: 'N'
1484: );

Line 1487: aso_debug_pub.ADD (

1483: 'N'
1484: );
1485:
1486: --pp_debug('In Workflow');
1487: aso_debug_pub.ADD (
1488: 'Object Approval ID : ' || P_Object_approval_id,
1489: 1,
1490: 'N'
1491: );

Line 1492: aso_debug_pub.ADD (

1488: 'Object Approval ID : ' || P_Object_approval_id,
1489: 1,
1490: 'N'
1491: );
1492: aso_debug_pub.ADD (
1493: 'ItemType : ' || P_itemtype,
1494: 1,
1495: 'N'
1496: );

Line 1497: aso_debug_pub.ADD (

1493: 'ItemType : ' || P_itemtype,
1494: 1,
1495: 'N'
1496: );
1497: aso_debug_pub.ADD (
1498: 'Sender name : ' || P_sender_name,
1499: 1,
1500: 'N'
1501: );

Line 1502: aso_debug_pub.ADD (

1498: 'Sender name : ' || P_sender_name,
1499: 1,
1500: 'N'
1501: );
1502: aso_debug_pub.ADD (
1503: 'Commit Flag : ' || p_commit,
1504: 1,
1505: 'N'
1506: );

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

1542: FND_MSG_PUB.ADD;
1543: RAISE FND_API.G_EXC_ERROR;
1544: END IF;
1545:
1546: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1547: aso_debug_pub.ADD (
1548: 'Calling procedure aso_pa_apr_wf_pvt.start_aso_approvals',
1549: 1,
1550: 'N'

Line 1547: aso_debug_pub.ADD (

1543: RAISE FND_API.G_EXC_ERROR;
1544: END IF;
1545:
1546: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1547: aso_debug_pub.ADD (
1548: 'Calling procedure aso_pa_apr_wf_pvt.start_aso_approvals',
1549: 1,
1550: 'N'
1551: );

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

1556: P_itemtype,
1557: P_sender_name);
1558:
1559:
1560: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1561: aso_debug_pub.ADD (
1562: 'After Calling procedure aso_pa_apr_wf_pvt.start_aso_approvals',
1563: 1,
1564: 'N'

Line 1561: aso_debug_pub.ADD (

1557: P_sender_name);
1558:
1559:
1560: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1561: aso_debug_pub.ADD (
1562: 'After Calling procedure aso_pa_apr_wf_pvt.start_aso_approvals',
1563: 1,
1564: 'N'
1565: );

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

1571: IF fnd_api.to_boolean (
1572: p_commit
1573: )
1574: THEN
1575: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1576: aso_debug_pub.ADD (
1577: 'Committing the work in start_pa_approval_workflow ',
1578: 1,
1579: 'N'

Line 1576: aso_debug_pub.ADD (

1572: p_commit
1573: )
1574: THEN
1575: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1576: aso_debug_pub.ADD (
1577: 'Committing the work in start_pa_approval_workflow ',
1578: 1,
1579: 'N'
1580: );

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

1591: end loop;
1592:
1593:
1594:
1595: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1596: aso_debug_pub.ADD (
1597: 'End start_pa_approval_workflow procedure ',
1598: 1,
1599: 'N'

Line 1596: aso_debug_pub.ADD (

1592:
1593:
1594:
1595: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1596: aso_debug_pub.ADD (
1597: 'End start_pa_approval_workflow procedure ',
1598: 1,
1599: 'N'
1600: );

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

1685: and approval_Status='PEND';
1686:
1687: BEGIN
1688:
1689: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1690: aso_debug_pub.add('upd_status_self_appr: BEGIN ', 1, 'Y');
1691: END IF;
1692:
1693: -- Initialize API return status to success

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

1686:
1687: BEGIN
1688:
1689: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1690: aso_debug_pub.add('upd_status_self_appr: BEGIN ', 1, 'Y');
1691: END IF;
1692:
1693: -- Initialize API return status to success
1694: x_return_status := fnd_api.g_ret_sts_success;

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

1694: x_return_status := fnd_api.g_ret_sts_success;
1695:
1696: SAVEPOINT upd_status_self_appr_int;
1697:
1698: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1699: aso_debug_pub.add('upd_status_self_appr: p_qte_hdr_id: '|| p_qte_hdr_id , 1, 'Y');
1700: aso_debug_pub.add('upd_status_self_appr: p_obj_ver_num: || p_obj_ver_num ', 1, 'Y');
1701: aso_debug_pub.add('upd_status_self_appr: p_last_update_date: || p_last_update_date ', 1, 'Y');
1702: END IF;

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

1695:
1696: SAVEPOINT upd_status_self_appr_int;
1697:
1698: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1699: aso_debug_pub.add('upd_status_self_appr: p_qte_hdr_id: '|| p_qte_hdr_id , 1, 'Y');
1700: aso_debug_pub.add('upd_status_self_appr: p_obj_ver_num: || p_obj_ver_num ', 1, 'Y');
1701: aso_debug_pub.add('upd_status_self_appr: p_last_update_date: || p_last_update_date ', 1, 'Y');
1702: END IF;
1703:

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

1696: SAVEPOINT upd_status_self_appr_int;
1697:
1698: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1699: aso_debug_pub.add('upd_status_self_appr: p_qte_hdr_id: '|| p_qte_hdr_id , 1, 'Y');
1700: aso_debug_pub.add('upd_status_self_appr: p_obj_ver_num: || p_obj_ver_num ', 1, 'Y');
1701: aso_debug_pub.add('upd_status_self_appr: p_last_update_date: || p_last_update_date ', 1, 'Y');
1702: END IF;
1703:
1704: Open c_get_qte_info(p_qte_hdr_id);

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

1697:
1698: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1699: aso_debug_pub.add('upd_status_self_appr: p_qte_hdr_id: '|| p_qte_hdr_id , 1, 'Y');
1700: aso_debug_pub.add('upd_status_self_appr: p_obj_ver_num: || p_obj_ver_num ', 1, 'Y');
1701: aso_debug_pub.add('upd_status_self_appr: p_last_update_date: || p_last_update_date ', 1, 'Y');
1702: END IF;
1703:
1704: Open c_get_qte_info(p_qte_hdr_id);
1705: Fetch c_get_qte_info into l_LAST_UPDATE_DATE,l_object_version_number;

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

1712: raise FND_API.G_EXC_ERROR;
1713: END IF;
1714: Close c_get_qte_info;
1715:
1716: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1717: aso_debug_pub.add('upd_status_self_appr: l_LAST_UPDATE_DATE: '|| l_LAST_UPDATE_DATE, 1, 'Y');
1718: aso_debug_pub.add('upd_status_self_appr: l_object_version_number: '|| l_object_version_number,1,'Y');
1719: END IF;
1720:

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

1713: END IF;
1714: Close c_get_qte_info;
1715:
1716: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1717: aso_debug_pub.add('upd_status_self_appr: l_LAST_UPDATE_DATE: '|| l_LAST_UPDATE_DATE, 1, 'Y');
1718: aso_debug_pub.add('upd_status_self_appr: l_object_version_number: '|| l_object_version_number,1,'Y');
1719: END IF;
1720:
1721: If (l_last_update_date is NULL or l_last_update_date = FND_API.G_MISS_Date ) Then

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

1714: Close c_get_qte_info;
1715:
1716: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1717: aso_debug_pub.add('upd_status_self_appr: l_LAST_UPDATE_DATE: '|| l_LAST_UPDATE_DATE, 1, 'Y');
1718: aso_debug_pub.add('upd_status_self_appr: l_object_version_number: '|| l_object_version_number,1,'Y');
1719: END IF;
1720:
1721: If (l_last_update_date is NULL or l_last_update_date = FND_API.G_MISS_Date ) Then
1722: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

1738: End if;
1739:
1740: OPEN C_Get_Status;
1741: FETCH C_Get_Status into l_status_id;
1742: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1743: aso_debug_pub.add('upd_status_self_appr: l_status_id: '|| l_status_id, 1, 'Y');
1744: END IF;
1745:
1746: CLOSE C_Get_Status;

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

1739:
1740: OPEN C_Get_Status;
1741: FETCH C_Get_Status into l_status_id;
1742: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1743: aso_debug_pub.add('upd_status_self_appr: l_status_id: '|| l_status_id, 1, 'Y');
1744: END IF;
1745:
1746: CLOSE C_Get_Status;
1747: -- set the out variables

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

1816: x_msg_data := fnd_msg_pub.get(p_msg_index => k,
1817: p_encoded => 'F');
1818: end loop;
1819:
1820: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1821: aso_debug_pub.add('upd_status_self_appr: END ', 1, 'Y');
1822: END IF;
1823:
1824: EXCEPTION

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

1817: p_encoded => 'F');
1818: end loop;
1819:
1820: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1821: aso_debug_pub.add('upd_status_self_appr: END ', 1, 'Y');
1822: END IF;
1823:
1824: EXCEPTION
1825: WHEN fnd_api.g_exc_error

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

1916: l_api_name varchar2(240):='insert_approvers_gtt';
1917: l_approval_status_desc varchar2(30);
1918: begin
1919:
1920: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1921: aso_debug_pub.add('insert_approvers_gtt: BEGIN ', 1, 'Y');
1922: END IF;
1923:
1924: --pp_debug('insert_approvers_gtt: BEGIN');

Line 1921: aso_debug_pub.add('insert_approvers_gtt: BEGIN ', 1, 'Y');

1917: l_approval_status_desc varchar2(30);
1918: begin
1919:
1920: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1921: aso_debug_pub.add('insert_approvers_gtt: BEGIN ', 1, 'Y');
1922: END IF;
1923:
1924: --pp_debug('insert_approvers_gtt: BEGIN');
1925: -- Initialize API return status to success

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

1931: into l_approval_status
1932: from ASO_APR_OBJ_APPROVALS
1933: where OBJECT_APPROVAL_ID=p_object_appr_id;
1934:
1935: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1936: aso_debug_pub.ADD ('insert_approvers_gtt:',1,'N');
1937: --pp_debug('insert_approvers_gtt: BEGIN'||l_approval_status);
1938: end if;
1939:

Line 1936: aso_debug_pub.ADD ('insert_approvers_gtt:',1,'N');

1932: from ASO_APR_OBJ_APPROVALS
1933: where OBJECT_APPROVAL_ID=p_object_appr_id;
1934:
1935: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1936: aso_debug_pub.ADD ('insert_approvers_gtt:',1,'N');
1937: --pp_debug('insert_approvers_gtt: BEGIN'||l_approval_status);
1938: end if;
1939:
1940:

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

1942: select count(*) into l_count
1943: from ASO_APR_APPROVAL_DETAILS_TEMP
1944: where object_approval_id = p_object_appr_id;
1945:
1946: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1947: aso_debug_pub.ADD ('insert_approvers_gtt: temp count'||l_count,1,'N');
1948: --pp_debug('insert_approvers_gtt: temp count'||l_count);
1949: end if;
1950: if l_count>0 then

Line 1947: aso_debug_pub.ADD ('insert_approvers_gtt: temp count'||l_count,1,'N');

1943: from ASO_APR_APPROVAL_DETAILS_TEMP
1944: where object_approval_id = p_object_appr_id;
1945:
1946: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1947: aso_debug_pub.ADD ('insert_approvers_gtt: temp count'||l_count,1,'N');
1948: --pp_debug('insert_approvers_gtt: temp count'||l_count);
1949: end if;
1950: if l_count>0 then
1951: Delete from ASO_APR_APPROVAL_DETAILS_TEMP

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

1952: where object_approval_id = p_object_appr_id;
1953: end if;
1954:
1955: if (l_approval_status='PEND') then
1956: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1957: aso_debug_pub.ADD ('insert_approvers_gtt: approvertblin count'||approvertblin.count,1,'N');
1958: --pp_debug('insert_approvers_gtt: approvertblin'||approvertblin.count);
1959: end if;
1960:

Line 1957: aso_debug_pub.ADD ('insert_approvers_gtt: approvertblin count'||approvertblin.count,1,'N');

1953: end if;
1954:
1955: if (l_approval_status='PEND') then
1956: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1957: aso_debug_pub.ADD ('insert_approvers_gtt: approvertblin count'||approvertblin.count,1,'N');
1958: --pp_debug('insert_approvers_gtt: approvertblin'||approvertblin.count);
1959: end if;
1960:
1961: if approvertblin.count>0 then

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

1976: exception
1977: when no_data_found then
1978: l_approval_Detail_id:=null;
1979: l_approver_comments:=null;
1980: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1981: aso_debug_pub.ADD ('insert_approvers_gtt: approvertblin count'||approvertblin.count,1,'N');
1982: --pp_debug('Not in approvers table');
1983: end if;
1984: null;

Line 1981: aso_debug_pub.ADD ('insert_approvers_gtt: approvertblin count'||approvertblin.count,1,'N');

1977: when no_data_found then
1978: l_approval_Detail_id:=null;
1979: l_approver_comments:=null;
1980: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1981: aso_debug_pub.ADD ('insert_approvers_gtt: approvertblin count'||approvertblin.count,1,'N');
1982: --pp_debug('Not in approvers table');
1983: end if;
1984: null;
1985:

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

2003: select count(*) into l_count
2004: from ASO_APR_APPROVAL_DETAILS_TEMP
2005: where object_approval_id = p_object_appr_id;
2006:
2007: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2008: aso_debug_pub.ADD ('insert_approvers_gtt: After inserting into temp table count'||l_count,1,'N');
2009: --pp_debug('insert_approvers_gtt: temp table count:'||l_count);
2010: end if;
2011:

Line 2008: aso_debug_pub.ADD ('insert_approvers_gtt: After inserting into temp table count'||l_count,1,'N');

2004: from ASO_APR_APPROVAL_DETAILS_TEMP
2005: where object_approval_id = p_object_appr_id;
2006:
2007: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2008: aso_debug_pub.ADD ('insert_approvers_gtt: After inserting into temp table count'||l_count,1,'N');
2009: --pp_debug('insert_approvers_gtt: temp table count:'||l_count);
2010: end if;
2011:
2012:

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

2015: elsif (l_approval_status='CAN') or (l_approval_status='REJ') or (l_approval_status='APPR') then
2016:
2017: for c1 in get_approver_details(p_object_appr_id) loop
2018:
2019: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2020: aso_debug_pub.ADD ('insert_approvers_gtt: c1.name'||c1.name,1,'N');
2021: end if;
2022:
2023:

Line 2020: aso_debug_pub.ADD ('insert_approvers_gtt: c1.name'||c1.name,1,'N');

2016:
2017: for c1 in get_approver_details(p_object_appr_id) loop
2018:
2019: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2020: aso_debug_pub.ADD ('insert_approvers_gtt: c1.name'||c1.name,1,'N');
2021: end if;
2022:
2023:
2024: If c1.name is null then -- for backward compatibility

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

2033: else
2034: l_name:=c1.name;
2035: end if;
2036:
2037: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2038: aso_debug_pub.ADD ('l_name'||l_name,1,'N');
2039: end if;
2040:
2041:

Line 2038: aso_debug_pub.ADD ('l_name'||l_name,1,'N');

2034: l_name:=c1.name;
2035: end if;
2036:
2037: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2038: aso_debug_pub.ADD ('l_name'||l_name,1,'N');
2039: end if;
2040:
2041:
2042: