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 728: pa_debug.debug(G_err_stack);

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

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

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

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

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

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

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

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

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

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

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

Line 740: pa_debug.debug(' ');

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

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

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

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

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

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

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

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

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

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

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

Line 798: pa_debug.debug(p_message);

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