eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ADVERTISEMENTS_PUB dependencies on PA_DEBUG

Line 15: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */

11: -- This API is currently empty.
12: -- Validate a single action line of an advertisement action set
13: -- template or an advertisement action set on a requirement.
14: ----------------------------------------------------------------------
15: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
16:
17: PROCEDURE Validate_Action_Set_Line (
18: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
19: , p_action_set_line_rec IN pa_action_set_lines%ROWTYPE

Line 156: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_ADVERTISEMENTS_PUB.Prepare_Adv_Action_Set.begin',x_Msg => 'in PA_ADVERTISEMENTS_PUB.Prepare_Adv_Action_Set', x_Log_Level => 6);

152:
153: --dbms_output.put_line('PA_ADVERTISEMENTS_PUB.Process_Action_Set');
154:
155: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
156: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_ADVERTISEMENTS_PUB.Prepare_Adv_Action_Set.begin',x_Msg => 'in PA_ADVERTISEMENTS_PUB.Prepare_Adv_Action_Set', x_Log_Level => 6);
157: END IF;
158:
159: --initialize the return status.
160: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 163: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PUB.Prepare_Adv_Action_Set');

159: --initialize the return status.
160: x_return_status := FND_API.G_RET_STS_SUCCESS;
161:
162: -- Initialise the error stack
163: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PUB.Prepare_Adv_Action_Set');
164:
165: --get the related details of the requirement if
166: --validating the action set of the requirement
167: IF p_action_set_template_flag='N' OR p_action_set_template_flag IS NULL THEN

Line 319: PA_DEBUG.Reset_Err_Stack;

315: END IF; -- need validation
316: END IF; -- more than 1 action line
317:
318: -- Reset the error stack when returning to the calling program
319: PA_DEBUG.Reset_Err_Stack;
320:
321: -- If there are any messages in the stack then set x_return_status
322:
323: IF FND_MSG_PUB.Count_Msg > 0 THEN

Line 335: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

331: WHEN OTHERS THEN
332:
333: -- Set the excetption Message and the stack
334: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PUB.Prepare_Adv_Action_Set'
335: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
336: --
337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
338: RAISE; -- This is optional depending on the needs
339:

Line 392: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_ADVERTISEMENTS_PUB.Perform_Adv_Action_Set.begin',x_Msg => 'in PA_ADVERTISEMENTS_PUB.Perform_Adv_Action_Set ', x_Log_Level => 6);

388:
389: --dbms_output.put_line('begin of PA_ADVERTISEMENTS_PUB.Perform_Adv_Action_Set');
390:
391: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
392: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_ADVERTISEMENTS_PUB.Perform_Adv_Action_Set.begin',x_Msg => 'in PA_ADVERTISEMENTS_PUB.Perform_Adv_Action_Set ', x_Log_Level => 6);
393: END IF;
394:
395: -- Initialise the error stack
396: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PUB.Perform_Adv_Action_Set');

Line 396: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PUB.Perform_Adv_Action_Set');

392: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_ADVERTISEMENTS_PUB.Perform_Adv_Action_Set.begin',x_Msg => 'in PA_ADVERTISEMENTS_PUB.Perform_Adv_Action_Set ', x_Log_Level => 6);
393: END IF;
394:
395: -- Initialise the error stack
396: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PUB.Perform_Adv_Action_Set');
397:
398: -- Initialize audit record table
399: g_action_line_audit_tbl.DELETE;
400:

Line 584: PA_DEBUG.Reset_Err_Stack;

580:
581: --dbms_output.put_line('result code = '||x_action_line_result_code);
582:
583: -- Reset the error stack when returning to the calling program
584: PA_DEBUG.Reset_Err_Stack;
585:
586: EXCEPTION
587: WHEN OTHERS THEN
588:

Line 591: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

587: WHEN OTHERS THEN
588:
589: -- Set the excetption Message and the stack
590: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PUB.Perform_Adv_Action_Set'
591: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
592:
593: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED;
594: RAISE; -- This is optional depending on the needs
595:

Line 653: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_ADVERTISEMENTS_PUB.Reevaluate_Adv_Action_Set.begin',x_Msg => 'in PA_ADVERTISEMENTS_PUB.Reevaluate_Adv_Action_Set', x_Log_Level => 6);

649:
650: BEGIN
651:
652: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
653: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_ADVERTISEMENTS_PUB.Reevaluate_Adv_Action_Set.begin',x_Msg => 'in PA_ADVERTISEMENTS_PUB.Reevaluate_Adv_Action_Set', x_Log_Level => 6);
654: END IF;
655:
656: --initialize the return status.
657: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 660: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PUB.Reevaluate_Adv_Action_Set');

656: --initialize the return status.
657: x_return_status := FND_API.G_RET_STS_SUCCESS;
658:
659: -- Initialise the error stack
660: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PUB.Reevaluate_Adv_Action_Set');
661:
662: --get the related details of the requirement
663: OPEN get_req_action_set_info;
664: FETCH get_req_action_set_info INTO

Line 780: PA_DEBUG.Reset_Err_Stack;

776:
777: END IF;
778:
779: -- Reset the error stack when returning to the calling program
780: PA_DEBUG.Reset_Err_Stack;
781:
782: -- If there are any messages in the stack then set x_return_status
783:
784: IF FND_MSG_PUB.Count_Msg > 0 THEN

Line 796: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

792: WHEN OTHERS THEN
793:
794: -- Set the excetption Message and the stack
795: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PUB.Reevaluate_Adv_Action_Set'
796: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
797: --
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
799: RAISE; -- This is optional depending on the needs
800:

Line 821: pa_debug.init_err_stack ('PA_ADVERTISEMENTS_PUB.Is_Action_Set_Started_On_Apply');

817: l_action_set_start_flag VARCHAR2(1);
818:
819: BEGIN
820:
821: pa_debug.init_err_stack ('PA_ADVERTISEMENTS_PUB.Is_Action_Set_Started_On_Apply');
822:
823:
824: IF PA_ADVERTISEMENTS_PUB.g_start_adv_action_set_flag IS NOT NULL THEN
825: l_action_set_start_flag := PA_ADVERTISEMENTS_PUB.g_start_adv_action_set_flag;