21: x_rules_list OUT NOCOPY /* file.sql.39 change */ rules_list_tbl_type
22: ) AS
23: l_api_name varchar2(240):= 'GET_ALL_APPROVERS';
24: BEGIN
25: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
26:
27: -- Standard Start of API savepoint
28: SAVEPOINT GET_ALL_APPROVERS_PUB;
29:
26:
27: -- Standard Start of API savepoint
28: SAVEPOINT GET_ALL_APPROVERS_PUB;
29:
30: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
31: aso_debug_pub.ADD (
32: 'BEGIN get_all_approvers in ASO_PA_APR_PUB package ',
33: 1,
34: 'N'
27: -- Standard Start of API savepoint
28: SAVEPOINT GET_ALL_APPROVERS_PUB;
29:
30: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
31: aso_debug_pub.ADD (
32: 'BEGIN get_all_approvers in ASO_PA_APR_PUB package ',
33: 1,
34: 'N'
35: );
101: x_msg_data,
102: x_approvers_list,
103: x_rules_list
104: );
105: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
106: aso_debug_pub.ADD (
107: 'After caling get_all_approvers in ASO_PA_APR_INT package ',
108: 1,
109: 'N'
102: x_approvers_list,
103: x_rules_list
104: );
105: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
106: aso_debug_pub.ADD (
107: 'After caling get_all_approvers in ASO_PA_APR_INT package ',
108: 1,
109: 'N'
110: );
179: ( p_count => x_msg_count,
180: p_data => x_msg_data
181: );
182:
183: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
184: aso_debug_pub.ADD (
185: 'END get_all_approvers in ASO_PA_APR_PUB package ',
186: 1,
187: 'N'
180: p_data => x_msg_data
181: );
182:
183: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
184: aso_debug_pub.ADD (
185: 'END get_all_approvers in ASO_PA_APR_PUB package ',
186: 1,
187: 'N'
188: );
238: ) AS
239: l_api_name varchar2(240):= 'START_PAPPROVAL_PROCESS';
240: BEGIN
241:
242: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
243:
244: -- Standard Start of API savepoint
245: SAVEPOINT START_PAPPROVAL_PROCESS_PUB;
246:
244: -- Standard Start of API savepoint
245: SAVEPOINT START_PAPPROVAL_PROCESS_PUB;
246:
247:
248: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
249: aso_debug_pub.ADD (
250: 'BEGIN start_papproval_process in ASO_PA_APR_PUB package ',
251: 1,
252: 'N'
245: SAVEPOINT START_PAPPROVAL_PROCESS_PUB;
246:
247:
248: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
249: aso_debug_pub.ADD (
250: 'BEGIN start_papproval_process in ASO_PA_APR_PUB package ',
251: 1,
252: 'N'
253: );
322: x_return_status,
323: x_msg_count,
324: x_msg_data
325: );
326: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
327: aso_debug_pub.ADD (
328: 'AFTER calling start_papproval_process in ASO_PA_APR_INT package ',
329: 1,
330: 'N'
323: x_msg_count,
324: x_msg_data
325: );
326: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
327: aso_debug_pub.ADD (
328: 'AFTER calling start_papproval_process in ASO_PA_APR_INT package ',
329: 1,
330: 'N'
331: );
405: ( p_count => x_msg_count,
406: p_data => x_msg_data
407: );
408:
409: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
410: aso_debug_pub.ADD (
411: 'END start_papproval_process in ASO_PA_APR_PUB package ',
412: 1,
413: 'N'
406: p_data => x_msg_data
407: );
408:
409: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
410: aso_debug_pub.ADD (
411: 'END start_papproval_process in ASO_PA_APR_PUB package ',
412: 1,
413: 'N'
414: );
463: x_msg_data OUT NOCOPY VARCHAR2
464: ) AS
465: BEGIN
466:
467: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
468:
469: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
470: aso_debug_pub.ADD (
471: 'BEGIN cancel_approval_process in ASO_PA_APR_PUB package ',
465: BEGIN
466:
467: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
468:
469: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
470: aso_debug_pub.ADD (
471: 'BEGIN cancel_approval_process in ASO_PA_APR_PUB package ',
472: 1,
473: 'N'
466:
467: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
468:
469: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
470: aso_debug_pub.ADD (
471: 'BEGIN cancel_approval_process in ASO_PA_APR_PUB package ',
472: 1,
473: 'N'
474: );
486: x_return_status,
487: x_msg_count,
488: x_msg_data
489: );
490: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
491: aso_debug_pub.ADD (
492: 'END cancel_approval_process in ASO_PA_APR_PUB package ',
493: 1,
494: 'N'
487: x_msg_count,
488: x_msg_data
489: );
490: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
491: aso_debug_pub.ADD (
492: 'END cancel_approval_process in ASO_PA_APR_PUB package ',
493: 1,
494: 'N'
495: );
506: x_return_status OUT NOCOPY VARCHAR2,
507: x_msg_count OUT NOCOPY NUMBER,
508: x_msg_data OUT NOCOPY VARCHAR2) AS
509: BEGIN
510: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
511:
512: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
513: aso_debug_pub.ADD (
514: 'BEGIN start_pa_approval_workflow in ASO_PA_APR_PUB package ',
508: x_msg_data OUT NOCOPY VARCHAR2) AS
509: BEGIN
510: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
511:
512: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
513: aso_debug_pub.ADD (
514: 'BEGIN start_pa_approval_workflow in ASO_PA_APR_PUB package ',
515: 1,
516: 'N'
509: BEGIN
510: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
511:
512: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
513: aso_debug_pub.ADD (
514: 'BEGIN start_pa_approval_workflow in ASO_PA_APR_PUB package ',
515: 1,
516: 'N'
517: );
527: x_return_status,
528: x_msg_count,
529: x_msg_data);
530:
531: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
532: aso_debug_pub.ADD (
533: 'END start_pa_approval_workflow in ASO_PA_APR_PUB package ',
534: 1,
535: 'N'
528: x_msg_count,
529: x_msg_data);
530:
531: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
532: aso_debug_pub.ADD (
533: 'END start_pa_approval_workflow in ASO_PA_APR_PUB package ',
534: 1,
535: 'N'
536: );