DBA Data[Home] [Help]

APPS.ASO_APR_PUB dependencies on ASO_DEBUG_PUB

Line 26: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

22: l_api_name varchar2(240):= 'GET_ALL_APPROVERS';
23:
24: BEGIN
25:
26: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
27:
28: -- Standard Start of API savepoint
29: SAVEPOINT GET_ALL_APPROVERS_PUB;
30:

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

27:
28: -- Standard Start of API savepoint
29: SAVEPOINT GET_ALL_APPROVERS_PUB;
30:
31: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
32: aso_debug_pub.ADD (
33: 'BEGIN get_all_approvers in ASO_APR_PUB package ',
34: 1,
35: 'N'

Line 32: aso_debug_pub.ADD (

28: -- Standard Start of API savepoint
29: SAVEPOINT GET_ALL_APPROVERS_PUB;
30:
31: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
32: aso_debug_pub.ADD (
33: 'BEGIN get_all_approvers in ASO_APR_PUB package ',
34: 1,
35: 'N'
36: );

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

100: x_msg_data,
101: x_approvers_list,
102: x_rules_list
103: );
104: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
105: aso_debug_pub.ADD (
106: 'After caling get_all_approvers in ASO_APR_INT package ',
107: 1,
108: 'N'

Line 105: aso_debug_pub.ADD (

101: x_approvers_list,
102: x_rules_list
103: );
104: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
105: aso_debug_pub.ADD (
106: 'After caling get_all_approvers in ASO_APR_INT package ',
107: 1,
108: 'N'
109: );

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

178: ( p_count => x_msg_count,
179: p_data => x_msg_data
180: );
181:
182: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
183: aso_debug_pub.ADD (
184: 'END get_all_approvers in ASO_APR_PUB package ',
185: 1,
186: 'N'

Line 183: aso_debug_pub.ADD (

179: p_data => x_msg_data
180: );
181:
182: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
183: aso_debug_pub.ADD (
184: 'END get_all_approvers in ASO_APR_PUB package ',
185: 1,
186: 'N'
187: );

Line 243: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

239: l_api_name varchar2(240):= 'START_APPROVAL_PROCESS';
240:
241: BEGIN
242:
243: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
244:
245: -- Standard Start of API savepoint
246: SAVEPOINT START_APPROVAL_PROCESS_PUB;
247:

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

245: -- Standard Start of API savepoint
246: SAVEPOINT START_APPROVAL_PROCESS_PUB;
247:
248:
249: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
250: aso_debug_pub.ADD (
251: 'BEGIN start_approval_process in ASO_APR_PUB package ',
252: 1,
253: 'N'

Line 250: aso_debug_pub.ADD (

246: SAVEPOINT START_APPROVAL_PROCESS_PUB;
247:
248:
249: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
250: aso_debug_pub.ADD (
251: 'BEGIN start_approval_process in ASO_APR_PUB package ',
252: 1,
253: 'N'
254: );

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

323: x_return_status,
324: x_msg_count,
325: x_msg_data
326: );
327: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
328: aso_debug_pub.ADD (
329: 'AFTER calling start_approval_process in ASO_APR_INT package ',
330: 1,
331: 'N'

Line 328: aso_debug_pub.ADD (

324: x_msg_count,
325: x_msg_data
326: );
327: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
328: aso_debug_pub.ADD (
329: 'AFTER calling start_approval_process in ASO_APR_INT package ',
330: 1,
331: 'N'
332: );

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

406: ( p_count => x_msg_count,
407: p_data => x_msg_data
408: );
409:
410: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
411: aso_debug_pub.ADD (
412: 'END start_approval_process in ASO_APR_PUB package ',
413: 1,
414: 'N'

Line 411: aso_debug_pub.ADD (

407: p_data => x_msg_data
408: );
409:
410: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
411: aso_debug_pub.ADD (
412: 'END start_approval_process in ASO_APR_PUB package ',
413: 1,
414: 'N'
415: );

Line 468: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

464: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
465: ) IS
466: BEGIN
467:
468: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
469:
470: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
471: aso_debug_pub.ADD (
472: 'BEGIN cancel_approval_process in ASO_APR_PUB package ',

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

466: BEGIN
467:
468: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
469:
470: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
471: aso_debug_pub.ADD (
472: 'BEGIN cancel_approval_process in ASO_APR_PUB package ',
473: 1,
474: 'N'

Line 471: aso_debug_pub.ADD (

467:
468: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
469:
470: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
471: aso_debug_pub.ADD (
472: 'BEGIN cancel_approval_process in ASO_APR_PUB package ',
473: 1,
474: 'N'
475: );

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

487: x_return_status,
488: x_msg_count,
489: x_msg_data
490: );
491: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
492: aso_debug_pub.ADD (
493: 'END cancel_approval_process in ASO_APR_PUB package ',
494: 1,
495: 'N'

Line 492: aso_debug_pub.ADD (

488: x_msg_count,
489: x_msg_data
490: );
491: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
492: aso_debug_pub.ADD (
493: 'END cancel_approval_process in ASO_APR_PUB package ',
494: 1,
495: 'N'
496: );

Line 515: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

511: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
512: ) IS
513: BEGIN
514:
515: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
516:
517: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
518: aso_debug_pub.ADD (
519: 'BEGIN skip_approver in ASO_APR_PUB package ',

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

513: BEGIN
514:
515: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
516:
517: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
518: aso_debug_pub.ADD (
519: 'BEGIN skip_approver in ASO_APR_PUB package ',
520: 1,
521: 'N'

Line 518: aso_debug_pub.ADD (

514:
515: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
516:
517: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
518: aso_debug_pub.ADD (
519: 'BEGIN skip_approver in ASO_APR_PUB package ',
520: 1,
521: 'N'
522: );

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

533: x_return_status,
534: x_msg_count,
535: x_msg_data
536: );
537: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
538: aso_debug_pub.ADD (
539: 'END skip_approver in ASO_APR_PUB package ',
540: 1,
541: 'N'

Line 538: aso_debug_pub.ADD (

534: x_msg_count,
535: x_msg_data
536: );
537: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
538: aso_debug_pub.ADD (
539: 'END skip_approver in ASO_APR_PUB package ',
540: 1,
541: 'N'
542: );

Line 559: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

555:
556: IS
557: BEGIN
558:
559: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
560:
561: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
562: aso_debug_pub.ADD (
563: 'BEGIN get_rule_details in ASO_APR_PUB package ',

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

557: BEGIN
558:
559: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
560:
561: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
562: aso_debug_pub.ADD (
563: 'BEGIN get_rule_details in ASO_APR_PUB package ',
564: 1,
565: 'N'

Line 562: aso_debug_pub.ADD (

558:
559: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
560:
561: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
562: aso_debug_pub.ADD (
563: 'BEGIN get_rule_details in ASO_APR_PUB package ',
564: 1,
565: 'N'
566: );

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

575: x_return_status,
576: x_msg_count,
577: x_msg_data);
578:
579: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
580: aso_debug_pub.ADD (
581: 'END get_rule_details in ASO_APR_PUB package ',
582: 1,
583: 'N'

Line 580: aso_debug_pub.ADD (

576: x_msg_count,
577: x_msg_data);
578:
579: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
580: aso_debug_pub.ADD (
581: 'END get_rule_details in ASO_APR_PUB package ',
582: 1,
583: 'N'
584: );

Line 603: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

599: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
600: IS
601: BEGIN
602:
603: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
604:
605: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
606: aso_debug_pub.ADD (
607: 'BEGIN start_approval_workflow in ASO_APR_PUB package ',

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

601: BEGIN
602:
603: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
604:
605: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
606: aso_debug_pub.ADD (
607: 'BEGIN start_approval_workflow in ASO_APR_PUB package ',
608: 1,
609: 'N'

Line 606: aso_debug_pub.ADD (

602:
603: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
604:
605: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
606: aso_debug_pub.ADD (
607: 'BEGIN start_approval_workflow in ASO_APR_PUB package ',
608: 1,
609: 'N'
610: );

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

620: x_return_status,
621: x_msg_count,
622: x_msg_data);
623:
624: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
625: aso_debug_pub.ADD (
626: 'END start_approval_workflow in ASO_APR_PUB package ',
627: 1,
628: 'N'

Line 625: aso_debug_pub.ADD (

621: x_msg_count,
622: x_msg_data);
623:
624: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
625: aso_debug_pub.ADD (
626: 'END start_approval_workflow in ASO_APR_PUB package ',
627: 1,
628: 'N'
629: );