DBA Data[Home] [Help]

APPS.PA_CI_SUPPLIER_UTILS dependencies on PA_DEBUG

Line 8: PA_DEBUG.g_err_stage := p_msg;

4: PROCEDURE print_msg(p_msg varchar2) IS
5: BEGIN
6: --dbms_output.put_line('Log:'||p_msg);
7: --r_debug.r_msg('Log:'||p_msg);
8: PA_DEBUG.g_err_stage := p_msg;
9: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
10: NULL;
11:
12: END print_msg;

Line 9: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);

5: BEGIN
6: --dbms_output.put_line('Log:'||p_msg);
7: --r_debug.r_msg('Log:'||p_msg);
8: PA_DEBUG.g_err_stage := p_msg;
9: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
10: NULL;
11:
12: END print_msg;
13:

Line 273: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

269:
270: END Validate_changeamt ;
271:
272: BEGIN
273: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
274: l_debug_mode := NVL(l_debug_mode, 'N');
275:
276: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
277:

Line 276: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

272: BEGIN
273: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
274: l_debug_mode := NVL(l_debug_mode, 'N');
275:
276: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
277:
278: /** reset the return status and error msg code **/
279: x_return_status := 'S';
280: x_error_msg_code := NULL;

Line 381: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

377:
378:
379:
380: BEGIN
381: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
382: l_debug_mode := NVL(l_debug_mode, 'N');
383:
384: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
385:

Line 384: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

380: BEGIN
381: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
382: l_debug_mode := NVL(l_debug_mode, 'N');
383:
384: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
385:
386: -- initialize the error stack
387: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.validate_insert_SI');
388:

Line 387: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.validate_insert_SI');

383:
384: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
385:
386: -- initialize the error stack
387: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.validate_insert_SI');
388:
389: /** clear the message stack **/
390: fnd_msg_pub.INITIALIZE;
391:

Line 555: pa_debug.reset_err_stack;

551:
552:
553: END IF;
554:
555: pa_debug.reset_err_stack;
556: EXCEPTION
557: when others then
558: x_return_status := 'U';
559: x_msg_count := 1;

Line 561: pa_debug.reset_err_stack;

557: when others then
558: x_return_status := 'U';
559: x_msg_count := 1;
560: x_msg_data := SQLCODE||SQLERRM;
561: pa_debug.reset_err_stack;
562: RAISE;
563:
564: END validate_insert_SI;
565:

Line 602: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

598: l_debug_mode varchar2(1) := 'N';
599:
600: BEGIN
601:
602: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
603: l_debug_mode := NVL(l_debug_mode, 'N');
604:
605: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
606:

Line 605: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

601:
602: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
603: l_debug_mode := NVL(l_debug_mode, 'N');
604:
605: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
606:
607: -- initialize the error stack
608: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.validateSI');
609:

Line 608: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.validateSI');

604:
605: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
606:
607: -- initialize the error stack
608: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.validateSI');
609:
610: /** clear the message stack **/
611: fnd_msg_pub.INITIALIZE;
612:

Line 857: pa_debug.reset_err_stack;

853: x_msg_count := l_msg_count;
854: x_msg_data := null;
855: End if;
856: END IF; -- end of p_callingModule
857: pa_debug.reset_err_stack;
858: EXCEPTION
859: when others then
860: x_return_status := 'U';
861: x_msg_count := 1;

Line 863: pa_debug.reset_err_stack;

859: when others then
860: x_return_status := 'U';
861: x_msg_count := 1;
862: x_msg_data := SQLCODE||SQLERRM;
863: pa_debug.reset_err_stack;
864: RAISE;
865: END validateSI;
866:
867: PROCEDURE deleteSIrecord(P_CALLING_MODE IN varchar2

Line 876: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

872: ,X_MSG_COUNT IN OUT NOCOPY number ) IS
873:
874: l_debug_mode varchar2(1) := 'N';
875: BEGIN
876: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
877: l_debug_mode := NVL(l_debug_mode, 'N');
878:
879: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
880:

Line 879: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

875: BEGIN
876: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
877: l_debug_mode := NVL(l_debug_mode, 'N');
878:
879: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
880:
881: -- initialize the error stack
882: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.deleteSIrecord');
883: IF l_debug_mode = 'Y' THEN

Line 882: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.deleteSIrecord');

878:
879: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
880:
881: -- initialize the error stack
882: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.deleteSIrecord');
883: IF l_debug_mode = 'Y' THEN
884: print_msg('inside deleteSIrecord api P_CALLING_MODE['||P_CALLING_MODE||']p_ROWID['||p_ROWID||
885: '] P_CI_TRANSACTION_ID['||P_CI_TRANSACTION_ID||']');
886: End If;

Line 901: pa_debug.reset_err_stack;

897:
898: End if;
899:
900:
901: pa_debug.reset_err_stack;
902: EXCEPTION
903: when others then
904: IF l_debug_mode = 'Y' THEN
905: print_msg('deleteSIrecord Error:'||sqlcode||sqlerrm);

Line 929: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

925:
926: l_debug_mode varchar2(1) := 'N';
927:
928: BEGIN
929: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
930: l_debug_mode := NVL(l_debug_mode, 'N');
931:
932: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
933:

Line 932: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

928: BEGIN
929: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
930: l_debug_mode := NVL(l_debug_mode, 'N');
931:
932: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
933:
934: IF l_debug_mode = 'Y' THEN
935: print_msg('Inside Merge_suppliers Api params p_from_ci_item_id['||p_from_ci_item_id||
936: ']p_to_ci_item_id['||p_to_ci_item_id||']' );

Line 1013: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

1009:
1010: l_debug_mode varchar2(1) := 'N';
1011:
1012: BEGIN
1013: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1014: l_debug_mode := NVL(l_debug_mode, 'N');
1015:
1016: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1017:

Line 1016: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

1012: BEGIN
1013: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1014: l_debug_mode := NVL(l_debug_mode, 'N');
1015:
1016: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1017:
1018: -- initialize the error stack
1019: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.delete_impact');
1020: IF l_debug_mode = 'Y' THEN

Line 1019: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.delete_impact');

1015:
1016: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1017:
1018: -- initialize the error stack
1019: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.delete_impact');
1020: IF l_debug_mode = 'Y' THEN
1021: print_msg('Inside DELETE_IMPACT api p_ci_id['||p_ci_id||']' );
1022: End If;
1023:

Line 1035: pa_debug.reset_err_stack;

1031: commit;
1032:
1033: End if;
1034:
1035: pa_debug.reset_err_stack;
1036: EXCEPTION
1037: when others then
1038: IF l_debug_mode = 'Y' THEN
1039: print_msg('sqlerror:'||sqlcode||sqlerrm);

Line 1044: pa_debug.reset_err_stack;

1040: End If;
1041: x_return_status := 'U';
1042: x_msg_count := 1;
1043: x_msg_data := SQLCODE||SQLERRM;
1044: pa_debug.reset_err_stack;
1045: RAISE;
1046:
1047: END DELETE_IMPACT;
1048:

Line 1071: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

1067: l_msg_index_out Number;
1068: l_debug_mode varchar2(1) := 'N';
1069:
1070: BEGIN
1071: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1072: l_debug_mode := NVL(l_debug_mode, 'N');
1073:
1074: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1075:

Line 1074: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

1070: BEGIN
1071: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1072: l_debug_mode := NVL(l_debug_mode, 'N');
1073:
1074: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1075:
1076: -- initialize the error stack
1077: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.delete_impact');
1078:

Line 1077: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.delete_impact');

1073:
1074: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1075:
1076: -- initialize the error stack
1077: PA_DEBUG.init_err_stack('PA_CI_SUPPLIER_UTILS.delete_impact');
1078:
1079: /** clear the message stack **/
1080: fnd_msg_pub.INITIALIZE;
1081:

Line 1120: pa_debug.reset_err_stack;

1116: );
1117:
1118: End if;
1119: -- Reset the error stack
1120: pa_debug.reset_err_stack;
1121:
1122: EXCEPTION
1123:
1124: WHEN OTHERS THEN

Line 1131: pa_debug.reset_err_stack;

1127: End If;
1128: x_return_status := 'U';
1129: x_msg_count := 1;
1130: x_msg_data := SQLCODE||SQLERRM;
1131: pa_debug.reset_err_stack;
1132: RAISE;
1133:
1134: END IS_SI_DELETE_OK;
1135: