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.CST_PAC_WIP_VALUE_REPORT_PVT dependencies on CST_PAC_WIP_VALUE_REPORT_PVT

Line 1: PACKAGE BODY CST_PAC_WIP_VALUE_REPORT_PVT AS

1: PACKAGE BODY CST_PAC_WIP_VALUE_REPORT_PVT AS
2: /* $Header: CSTPWVRB.pls 120.11 2010/08/31 20:50:25 fayang ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_PAC_WIP_VALUE_REPORT_PVT';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_PAC_WIP_VALUE_REPORT_PVT';

1: PACKAGE BODY CST_PAC_WIP_VALUE_REPORT_PVT AS
2: /* $Header: CSTPWVRB.pls 120.11 2010/08/31 20:50:25 fayang ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_PAC_WIP_VALUE_REPORT_PVT';
5:
6: /*-------------------------------------------------------------------------------
7: -- PROCEDURE : Generate_XML
8: -- DESCRIPTION : Procedure to call all the procedures which generates XML data

Line 33: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Generate_XMLData';

29: p_stuct_number IN NUMBER
30: )
31: IS
32: l_api_name CONSTANT VARCHAR2(30) := 'Generate_XMLData';
33: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Generate_XMLData';
34: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
35: l_uLog CONSTANT BOOLEAN := fnd_log.TEST(fnd_log.level_unexpected, l_module) AND fnd_log.level_unexpected >= l_log_level;
36: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
37: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

Line 65: 'Entering CST_PAC_WIP_Value_Report_PVT.Generate_XMLData with << '||

61: IF l_plog THEN
62: fnd_log.string(
63: fnd_log.level_procedure,
64: l_module||'.'||l_stmt_num,
65: 'Entering CST_PAC_WIP_Value_Report_PVT.Generate_XMLData with << '||
66: 'p_report_type = '||p_report_type||','||
67: 'p_legal_entity_id = '||p_legal_entity_id||','||
68: 'p_cost_group_id = '||p_cost_group_id||','||
69: 'p_cost_type_id = '||p_cost_type_id||','||

Line 204: 'Exiting CST_PAC_WIP_Value_Report_PVT.Generate_XMLData >> ');

200: IF l_plog THEN
201: fnd_log.string(
202: fnd_log.level_procedure,
203: l_module||'.'||l_stmt_num,
204: 'Exiting CST_PAC_WIP_Value_Report_PVT.Generate_XMLData >> ');
205: END IF;
206:
207: EXCEPTION
208: WHEN fnd_api.g_exc_unexpected_error THEN

Line 212: p_pkg_name => 'CST_PAC_WIP_Value_Report_PVT',

208: WHEN fnd_api.g_exc_unexpected_error THEN
209:
210: IF l_exceptionlog THEN
211: fnd_msg_pub.add_exc_msg(
212: p_pkg_name => 'CST_PAC_WIP_Value_Report_PVT',
213: p_procedure_name => 'Generate_XMLData',
214: p_error_text => 'An exception has occurred.'
215: );
216: fnd_log.string(

Line 267: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Display_Parameters';

263: IS
264: l_api_name CONSTANT VARCHAR2(30) := 'Display_Parameters';
265: l_api_version CONSTANT NUMBER := 1.0;
266:
267: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Display_Parameters';
268: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
269: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
270: fnd_log.TEST(fnd_log.level_unexpected, l_module);
271: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

Line 293: 'Entering CST_PAC_WIP_Value_Report_PVT.Display_Parameters with << '||

289: IF l_plog THEN
290: fnd_log.string(
291: fnd_log.level_procedure,
292: l_module||'.'||l_stmt_num,
293: 'Entering CST_PAC_WIP_Value_Report_PVT.Display_Parameters with << '||
294: 'p_init_msg_list = '||p_init_msg_list||','||
295: 'p_validation_level = '||p_validation_level||','||
296: 'p_report_type = '||p_report_type||','||
297: 'p_legal_entity_id = '||p_legal_entity_id||','||

Line 411: 'Exiting CST_PAC_WIP_Value_Report_PVT.Display_Parameters >> ');

407: IF l_plog THEN
408: fnd_log.string(
409: fnd_log.level_procedure,
410: l_module||'.'||l_stmt_num,
411: 'Exiting CST_PAC_WIP_Value_Report_PVT.Display_Parameters >> ');
412: END IF;
413:
414: EXCEPTION
415: WHEN fnd_api.g_exc_unexpected_error THEN

Line 420: p_pkg_name => 'CST_PAC_WIP_Value_Report_PVT',

416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
417:
418: IF l_exceptionlog THEN
419: fnd_msg_pub.add_exc_msg(
420: p_pkg_name => 'CST_PAC_WIP_Value_Report_PVT',
421: p_procedure_name => 'Display_Parameters',
422: p_error_text => 'An exception has occurred.'
423: );
424: IF l_uLog THEN

Line 463: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Periodic_WIP_Value_Rpt_Details';

459: p_cost_type_id IN NUMBER,
460: p_legal_entity_id IN NUMBER)
461: IS
462:
463: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Periodic_WIP_Value_Rpt_Details';
464: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
465: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
466: fnd_log.TEST(fnd_log.level_unexpected, l_module);
467: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

Line 542: 'Entering CST_PAC_WIP_Value_Report_PVT.Periodic_WIP_Value_Rpt_Details with '||

538: IF l_plog THEN
539: fnd_log.string(
540: fnd_log.level_procedure,
541: l_module||'.'||l_stmt_num,
542: 'Entering CST_PAC_WIP_Value_Report_PVT.Periodic_WIP_Value_Rpt_Details with '||
543: 'p_init_msg_list = '||p_init_msg_list||','||
544: 'p_validation_level = '||p_validation_level||','||
545: 'p_report_type = '||p_report_type||','||
546: 'p_pac_period_id = '||p_pac_period_id||','||

Line 734: 'Exiting CST_PAC_WIP_Value_Report_PVT.Periodic_WIP_Value_Rpt_Details >> ');

730: fnd_log.string(
731: fnd_log.level_procedure,
732: l_module||'.'||l_stmt_num,
733: 'Inserted '||l_ctr|| ' rows into temp table.' ||
734: 'Exiting CST_PAC_WIP_Value_Report_PVT.Periodic_WIP_Value_Rpt_Details >> ');
735: END IF;
736:
737: EXCEPTION
738: WHEN fnd_api.g_exc_unexpected_error THEN

Line 743: p_pkg_name => 'CST_PAC_WIP_Value_Report_PVT',

739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
740:
741: IF l_exceptionlog THEN
742: fnd_msg_pub.add_exc_msg(
743: p_pkg_name => 'CST_PAC_WIP_Value_Report_PVT',
744: p_procedure_name => 'Periodic_WIP_Value_Rpt_Details',
745: p_error_text => 'An exception has occurred.'
746: );
747: IF l_uLog THEN

Line 796: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Get_XMLData';

792: x_xml_doc IN OUT NOCOPY CLOB)
793: IS
794: l_api_name CONSTANT VARCHAR2(30) := 'Get_XMLData';
795: l_api_version CONSTANT NUMBER := 1.0;
796: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Get_XMLData';
797: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
798: l_uLog CONSTANT BOOLEAN := fnd_log.TEST(fnd_log.level_unexpected, l_module) AND fnd_log.level_unexpected >= l_log_level;
799: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
800: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

Line 833: 'Entering CST_PAC_WIP_Value_Report_PVT.Get_XMLData with '||

829: IF l_plog THEN
830: fnd_log.string(
831: fnd_log.level_procedure,
832: l_module||'.'||l_stmt_num,
833: 'Entering CST_PAC_WIP_Value_Report_PVT.Get_XMLData with '||
834: 'p_init_msg_list = '||p_init_msg_list||','||
835: 'p_validation_level = '||p_validation_level||','||
836: 'p_legal_entity_id = '||p_legal_entity_id||','||
837: 'p_cost_group_id = '||p_cost_group_id||','||

Line 1063: 'Exiting CST_PAC_WIP_Value_Report_PVT.Get_XMLData >> ');

1059: IF l_plog THEN
1060: fnd_log.string(
1061: fnd_log.level_procedure,
1062: l_module||'.'||l_stmt_num,
1063: 'Exiting CST_PAC_WIP_Value_Report_PVT.Get_XMLData >> ');
1064: END IF;
1065:
1066:
1067: EXCEPTION

Line 1073: p_pkg_name => 'CST_PAC_WIP_Value_Report_PVT',

1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1070:
1071: IF l_exceptionlog THEN
1072: fnd_msg_pub.add_exc_msg(
1073: p_pkg_name => 'CST_PAC_WIP_Value_Report_PVT',
1074: p_procedure_name => 'Get_XMLData',
1075: p_error_text => 'An exception has occurred.'
1076: );
1077: IF l_uLog THEN

Line 1098: END CST_PAC_WIP_VALUE_REPORT_PVT;

1094: );
1095: END IF;
1096: END Get_XMLData;
1097:
1098: END CST_PAC_WIP_VALUE_REPORT_PVT;