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_ADVERTISEMENTS_PUB

Line 1: PACKAGE BODY PA_ADVERTISEMENTS_PUB AS

1: PACKAGE BODY PA_ADVERTISEMENTS_PUB AS
2: --$Header: PARAVPBB.pls 120.1 2005/08/19 16:48:46 mwasowic noship $
3: --
4:
5:

Line 153: --dbms_output.put_line('PA_ADVERTISEMENTS_PUB.Process_Action_Set');

149: AND action_set_id = p_action_set_id);
150:
151: BEGIN
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;

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 334: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PUB.Prepare_Adv_Action_Set'

330: EXCEPTION
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

Line 389: --dbms_output.put_line('begin of PA_ADVERTISEMENTS_PUB.Perform_Adv_Action_Set');

385: AND ast.action_set_id = p_action_set_line_rec.action_set_id;
386:
387: BEGIN
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;

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 590: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PUB.Perform_Adv_Action_Set'

586: EXCEPTION
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

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 795: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PUB.Reevaluate_Adv_Action_Set'

791: EXCEPTION
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

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;

Line 824: IF PA_ADVERTISEMENTS_PUB.g_start_adv_action_set_flag IS NOT NULL THEN

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;
826: ELSE
827:
828: SELECT proj.start_adv_action_set_flag

Line 825: l_action_set_start_flag := PA_ADVERTISEMENTS_PUB.g_start_adv_action_set_flag;

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;
826: ELSE
827:
828: SELECT proj.start_adv_action_set_flag
829: INTO l_action_set_start_flag

Line 837: PA_ADVERTISEMENTS_PUB.g_start_adv_action_set_flag := NULL;

833: AND asgn.project_id = proj.project_id;
834:
835: END IF;
836:
837: PA_ADVERTISEMENTS_PUB.g_start_adv_action_set_flag := NULL;
838:
839: RETURN l_action_set_start_flag;
840:
841: EXCEPTION

Line 848: END PA_ADVERTISEMENTS_PUB;

844: WHEN OTHERS THEN
845: RETURN 'N';
846: END Is_Action_Set_Started_On_Apply;
847:
848: END PA_ADVERTISEMENTS_PUB;