DBA Data[Home] [Help]

APPS.PAAPIMP_PKG dependencies on PA_DEBUG

Line 7: g_body_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

3:
4: /*------------------Main Procedure-------------------------------------------*/
5: /* Added for Bug # 2138340 */
6: p_trans_import_failed varchar2(1) := 'N'; /* package level var for detecting if trans import ever failed */
7: g_body_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
8: --g_body_debug_mode varchar2(1) := 'Y';
9:
10: /* 3917045 : This variable holds the value of the request parameter 'Interface Supplier Invoices' */
11: G_PROCESS_INVOICES VARCHAR2(1) := 'Y';

Line 406: pa_debug.debug_level := pa_debug.DEBUG_LEVEL_TIMING;

402:
403: /* Initialize debug level */
404: IF (p_debug_mode = 'Y') THEN
405:
406: pa_debug.debug_level := pa_debug.DEBUG_LEVEL_TIMING;
407: --ALTER SESSION SET SQL_TRACE = TRUE;
408:
409: END IF;
410:

Line 726: pa_debug.debug(G_err_stack);

722: G_err_stack := G_err_stack || '->PAAPIMP_PKG.write_validate_param_log';
723: G_err_stage := 'WRITE PARAMETERS TO LOG';
724:
725: If g_body_debug_mode = 'Y' Then
726: pa_debug.debug(G_err_stack);
727: End If;
728:
729: IF (G_OUTPUT = G_OUTPUT_SQLPLUS) THEN
730: NULL;

Line 733: pa_debug.debug('Validated parameters are as follows:');

729: IF (G_OUTPUT = G_OUTPUT_SQLPLUS) THEN
730: NULL;
731: ELSIF (G_OUTPUT = G_OUTPUT_SQLPLUS) THEN
732: If g_body_debug_mode ='Y' Then
733: pa_debug.debug('Validated parameters are as follows:');
734: pa_debug.debug(' Parameter1 - Project ID : ' || G_PROJECT_ID);
735: pa_debug.debug(' Parameter2 - Batch Name : ' || G_BATCH_NAME);
736: pa_debug.debug(' Parameter3 - GL Date through : ' || to_char(G_GL_DATE));
737: pa_debug.debug(' Parameter4 - Transaction Date through : ' || to_char(G_TRANSACTION_DATE));

Line 734: pa_debug.debug(' Parameter1 - Project ID : ' || G_PROJECT_ID);

730: NULL;
731: ELSIF (G_OUTPUT = G_OUTPUT_SQLPLUS) THEN
732: If g_body_debug_mode ='Y' Then
733: pa_debug.debug('Validated parameters are as follows:');
734: pa_debug.debug(' Parameter1 - Project ID : ' || G_PROJECT_ID);
735: pa_debug.debug(' Parameter2 - Batch Name : ' || G_BATCH_NAME);
736: pa_debug.debug(' Parameter3 - GL Date through : ' || to_char(G_GL_DATE));
737: pa_debug.debug(' Parameter4 - Transaction Date through : ' || to_char(G_TRANSACTION_DATE));
738: pa_debug.debug(' ');

Line 735: pa_debug.debug(' Parameter2 - Batch Name : ' || G_BATCH_NAME);

731: ELSIF (G_OUTPUT = G_OUTPUT_SQLPLUS) THEN
732: If g_body_debug_mode ='Y' Then
733: pa_debug.debug('Validated parameters are as follows:');
734: pa_debug.debug(' Parameter1 - Project ID : ' || G_PROJECT_ID);
735: pa_debug.debug(' Parameter2 - Batch Name : ' || G_BATCH_NAME);
736: pa_debug.debug(' Parameter3 - GL Date through : ' || to_char(G_GL_DATE));
737: pa_debug.debug(' Parameter4 - Transaction Date through : ' || to_char(G_TRANSACTION_DATE));
738: pa_debug.debug(' ');
739: pa_debug.debug('Other relevant information:');

Line 736: pa_debug.debug(' Parameter3 - GL Date through : ' || to_char(G_GL_DATE));

732: If g_body_debug_mode ='Y' Then
733: pa_debug.debug('Validated parameters are as follows:');
734: pa_debug.debug(' Parameter1 - Project ID : ' || G_PROJECT_ID);
735: pa_debug.debug(' Parameter2 - Batch Name : ' || G_BATCH_NAME);
736: pa_debug.debug(' Parameter3 - GL Date through : ' || to_char(G_GL_DATE));
737: pa_debug.debug(' Parameter4 - Transaction Date through : ' || to_char(G_TRANSACTION_DATE));
738: pa_debug.debug(' ');
739: pa_debug.debug('Other relevant information:');
740: pa_debug.debug(' User ID = ' || to_char(G_USER_ID));

Line 737: pa_debug.debug(' Parameter4 - Transaction Date through : ' || to_char(G_TRANSACTION_DATE));

733: pa_debug.debug('Validated parameters are as follows:');
734: pa_debug.debug(' Parameter1 - Project ID : ' || G_PROJECT_ID);
735: pa_debug.debug(' Parameter2 - Batch Name : ' || G_BATCH_NAME);
736: pa_debug.debug(' Parameter3 - GL Date through : ' || to_char(G_GL_DATE));
737: pa_debug.debug(' Parameter4 - Transaction Date through : ' || to_char(G_TRANSACTION_DATE));
738: pa_debug.debug(' ');
739: pa_debug.debug('Other relevant information:');
740: pa_debug.debug(' User ID = ' || to_char(G_USER_ID));
741: pa_debug.debug(' Request ID = ' || to_char(G_REQUEST_ID));

Line 738: pa_debug.debug(' ');

734: pa_debug.debug(' Parameter1 - Project ID : ' || G_PROJECT_ID);
735: pa_debug.debug(' Parameter2 - Batch Name : ' || G_BATCH_NAME);
736: pa_debug.debug(' Parameter3 - GL Date through : ' || to_char(G_GL_DATE));
737: pa_debug.debug(' Parameter4 - Transaction Date through : ' || to_char(G_TRANSACTION_DATE));
738: pa_debug.debug(' ');
739: pa_debug.debug('Other relevant information:');
740: pa_debug.debug(' User ID = ' || to_char(G_USER_ID));
741: pa_debug.debug(' Request ID = ' || to_char(G_REQUEST_ID));
742: pa_debug.debug(' Program ID = ' || to_char(G_PROG_ID));

Line 739: pa_debug.debug('Other relevant information:');

735: pa_debug.debug(' Parameter2 - Batch Name : ' || G_BATCH_NAME);
736: pa_debug.debug(' Parameter3 - GL Date through : ' || to_char(G_GL_DATE));
737: pa_debug.debug(' Parameter4 - Transaction Date through : ' || to_char(G_TRANSACTION_DATE));
738: pa_debug.debug(' ');
739: pa_debug.debug('Other relevant information:');
740: pa_debug.debug(' User ID = ' || to_char(G_USER_ID));
741: pa_debug.debug(' Request ID = ' || to_char(G_REQUEST_ID));
742: pa_debug.debug(' Program ID = ' || to_char(G_PROG_ID));
743: pa_debug.debug(' Login ID = ' || to_char(G_LOGIN_ID));

Line 740: pa_debug.debug(' User ID = ' || to_char(G_USER_ID));

736: pa_debug.debug(' Parameter3 - GL Date through : ' || to_char(G_GL_DATE));
737: pa_debug.debug(' Parameter4 - Transaction Date through : ' || to_char(G_TRANSACTION_DATE));
738: pa_debug.debug(' ');
739: pa_debug.debug('Other relevant information:');
740: pa_debug.debug(' User ID = ' || to_char(G_USER_ID));
741: pa_debug.debug(' Request ID = ' || to_char(G_REQUEST_ID));
742: pa_debug.debug(' Program ID = ' || to_char(G_PROG_ID));
743: pa_debug.debug(' Login ID = ' || to_char(G_LOGIN_ID));
744: End If;

Line 741: pa_debug.debug(' Request ID = ' || to_char(G_REQUEST_ID));

737: pa_debug.debug(' Parameter4 - Transaction Date through : ' || to_char(G_TRANSACTION_DATE));
738: pa_debug.debug(' ');
739: pa_debug.debug('Other relevant information:');
740: pa_debug.debug(' User ID = ' || to_char(G_USER_ID));
741: pa_debug.debug(' Request ID = ' || to_char(G_REQUEST_ID));
742: pa_debug.debug(' Program ID = ' || to_char(G_PROG_ID));
743: pa_debug.debug(' Login ID = ' || to_char(G_LOGIN_ID));
744: End If;
745: ELSIF (G_OUTPUT = G_OUTPUT_FND) THEN

Line 742: pa_debug.debug(' Program ID = ' || to_char(G_PROG_ID));

738: pa_debug.debug(' ');
739: pa_debug.debug('Other relevant information:');
740: pa_debug.debug(' User ID = ' || to_char(G_USER_ID));
741: pa_debug.debug(' Request ID = ' || to_char(G_REQUEST_ID));
742: pa_debug.debug(' Program ID = ' || to_char(G_PROG_ID));
743: pa_debug.debug(' Login ID = ' || to_char(G_LOGIN_ID));
744: End If;
745: ELSIF (G_OUTPUT = G_OUTPUT_FND) THEN
746: If g_body_debug_mode ='Y' Then

Line 743: pa_debug.debug(' Login ID = ' || to_char(G_LOGIN_ID));

739: pa_debug.debug('Other relevant information:');
740: pa_debug.debug(' User ID = ' || to_char(G_USER_ID));
741: pa_debug.debug(' Request ID = ' || to_char(G_REQUEST_ID));
742: pa_debug.debug(' Program ID = ' || to_char(G_PROG_ID));
743: pa_debug.debug(' Login ID = ' || to_char(G_LOGIN_ID));
744: End If;
745: ELSIF (G_OUTPUT = G_OUTPUT_FND) THEN
746: If g_body_debug_mode ='Y' Then
747: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Validated parameters are as follows:');

Line 796: pa_debug.debug(p_message);

792: NULL;
793:
794: ELSIF (G_OUTPUT = G_OUTPUT_PADEBUG) THEN
795:
796: pa_debug.debug(p_message);
797:
798: ELSIF (G_OUTPUT = G_OUTPUT_FND) THEN
799:
800: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(sysdate,'HH:MI:SS: ')|| p_message);