DBA Data[Home] [Help]

APPS.CST_EAM_WORKORDERS_PVT dependencies on CST_EAM_WORKORDERS_PVT

Line 1: PACKAGE BODY CST_eAM_WorkOrders_PVT AS

1: PACKAGE BODY CST_eAM_WorkOrders_PVT AS
2: /* $Header: CSTPEEAB.pls 120.3.12010000.2 2008/10/30 12:15:08 svelumur ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_eAM_WorkOrders_PVT';
5:

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

1: PACKAGE BODY CST_eAM_WorkOrders_PVT AS
2: /* $Header: CSTPEEAB.pls 120.3.12010000.2 2008/10/30 12:15:08 svelumur ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_eAM_WorkOrders_PVT';
5:
6: PROCEDURE Generate_XMLData (
7: errcode OUT NOCOPY VARCHAR2,
8: errno OUT NOCOPY NUMBER,

Line 32: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_eAM_WorkOrders_PVT.Generate_XMLData';

28: l_msg_data VARCHAR2(2000);
29: l_success BOOLEAN;
30: l_stmt_num NUMBER;
31:
32: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_eAM_WorkOrders_PVT.Generate_XMLData';
33: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
34: l_uLog CONSTANT BOOLEAN := fnd_log.TEST(fnd_log.level_unexpected, l_module) AND fnd_log.level_unexpected >= l_log_level;
35: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
36: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

Line 47: 'Entering CST_eAM_WorkOrders_PVT.Generate_XMLData with '||

43: IF l_plog THEN
44: fnd_log.string(
45: fnd_log.level_procedure,
46: l_module||'.'||l_stmt_num,
47: 'Entering CST_eAM_WorkOrders_PVT.Generate_XMLData with '||
48: 'p_legal_entity_id = '||p_legal_entity_id||','||
49: 'p_cost_group_id = '||p_cost_group_id||','||
50: 'p_cost_type_id = '||p_cost_type_id||','||
51: 'p_range = '||p_range||','||

Line 147: 'Exiting CST_eAM_WorkOrders_PVT.Generate_XMLData with '||

143: IF l_plog THEN
144: fnd_log.string(
145: fnd_log.level_procedure,
146: l_module||'.'||l_stmt_num,
147: 'Exiting CST_eAM_WorkOrders_PVT.Generate_XMLData with '||
148: 'errno = '||errno
149: );
150: END IF;
151:

Line 160: p_pkg_name => 'CST_eAM_WorkOrders_PVT',

156: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_msg_data);
157:
158: IF l_exceptionlog THEN
159: fnd_msg_pub.add_exc_msg(
160: p_pkg_name => 'CST_eAM_WorkOrders_PVT',
161: p_procedure_name => 'Generate_XMLData',
162: p_error_text => 'An exception has occurred.'
163: );
164: fnd_log.string(

Line 215: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_eAM_WorkOrders_PVT.Display_Parameters';

211: l_legal_entity VARCHAR2(240);
212: l_cost_type VARCHAR2(10);
213: l_cost_group VARCHAR2(10);
214:
215: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_eAM_WorkOrders_PVT.Display_Parameters';
216: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
217: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
218: fnd_log.TEST(fnd_log.level_unexpected, l_module);
219: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

Line 233: 'Entering CST_eAM_WorkOrders_PVT.Display_Parameters with '||

229: IF l_plog THEN
230: fnd_log.string(
231: fnd_log.level_procedure,
232: l_module||'.'||l_stmt_num,
233: 'Entering CST_eAM_WorkOrders_PVT.Display_Parameters with '||
234: 'p_init_msg_list = '||p_init_msg_list||','||
235: 'p_validation_level = '||p_validation_level||','||
236: 'p_legal_entity_id = '||p_legal_entity_id||','||
237: 'p_cost_group_id = '||p_cost_group_id||','||

Line 361: 'Exiting CST_eAM_WorkOrders_PVT.Display_Parameters with '||

357: IF l_plog THEN
358: fnd_log.string(
359: fnd_log.level_procedure,
360: l_module||'.'||l_stmt_num,
361: 'Exiting CST_eAM_WorkOrders_PVT.Display_Parameters with '||
362: 'x_return_status = '||x_return_status||','||
363: 'x_msg_count = '||x_msg_count||','||
364: 'x_msg_data = '||x_msg_data
365: );

Line 371: p_pkg_name => 'CST_eAM_WorkOrders_PVT',

367: EXCEPTION
368: WHEN fnd_api.g_exc_unexpected_error THEN
369: IF l_exceptionlog THEN
370: fnd_msg_pub.add_exc_msg(
371: p_pkg_name => 'CST_eAM_WorkOrders_PVT',
372: p_procedure_name => 'Display_Parameters',
373: p_error_text => 'An exception has occurred.'
374: );
375: fnd_log.string(

Line 418: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_eAM_WorkOrders_PVT.eAM_Est_Actual_details';

414: l_offset PLS_INTEGER;
415: l_total_rows_processed NUMBER;
416: l_stmt_num NUMBER;
417:
418: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_eAM_WorkOrders_PVT.eAM_Est_Actual_details';
419: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
420: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
421: fnd_log.TEST(fnd_log.level_unexpected, l_module);
422: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

Line 434: 'Entering CST_eAM_WorkOrders_PVT.eAM_Est_Actual_details with '||

430: IF l_plog THEN
431: fnd_log.string(
432: fnd_log.level_procedure,
433: l_module||'.'||l_stmt_num,
434: 'Entering CST_eAM_WorkOrders_PVT.eAM_Est_Actual_details with '||
435: 'p_init_msg_list = '||p_init_msg_list||','||
436: 'p_validation_level = '||p_validation_level||','||
437: 'p_legal_entity_id = '||p_legal_entity_id||','||
438: 'p_cost_group_id = '||p_cost_group_id||','||

Line 636: 'Exiting CST_eAM_WorkOrders_PVT.eAM_Est_Actual_details with '||

632: IF l_plog THEN
633: fnd_log.string(
634: fnd_log.level_procedure,
635: l_module||'.'||l_stmt_num,
636: 'Exiting CST_eAM_WorkOrders_PVT.eAM_Est_Actual_details with '||
637: 'x_return_status = '||x_return_status||','||
638: 'x_msg_count = '||x_msg_count||','||
639: 'x_msg_data = '||x_msg_data
640: );

Line 647: p_pkg_name => 'CST_eAM_WorkOrders_PVT',

643: EXCEPTION
644: WHEN fnd_api.g_exc_unexpected_error THEN
645: IF l_exceptionlog THEN
646: fnd_msg_pub.add_exc_msg(
647: p_pkg_name => 'CST_eAM_WorkOrders_PVT',
648: p_procedure_name => 'eAM_Est_Actual_details',
649: p_error_text => 'An exception has occurred.'
650: );
651: fnd_log.string(

Line 670: END CST_eAM_WorkOrders_PVT;

666: );
667: END IF;
668: END eAM_Est_Actual_details;
669:
670: END CST_eAM_WorkOrders_PVT;