DBA Data[Home] [Help]

APPS.EAM_CONSTRUCTION_EST_PVT dependencies on EAM_CONSTRUCTION_EST_PVT

Line 1: PACKAGE BODY EAM_CONSTRUCTION_EST_PVT AS

1: PACKAGE BODY EAM_CONSTRUCTION_EST_PVT AS
2: /* $Header: EAMVCESB.pls 120.29.12020000.4 2012/10/08 11:50:11 antmishr ship $ */
3: -- Start of Comments
4: -- Package name : EAM_CONSTRUCTION_EST_PVT
5: -- Purpose : Privatre Package Body for Construction estimate

Line 4: -- Package name : EAM_CONSTRUCTION_EST_PVT

1: PACKAGE BODY EAM_CONSTRUCTION_EST_PVT AS
2: /* $Header: EAMVCESB.pls 120.29.12020000.4 2012/10/08 11:50:11 antmishr ship $ */
3: -- Start of Comments
4: -- Package name : EAM_CONSTRUCTION_EST_PVT
5: -- Purpose : Privatre Package Body for Construction estimate
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EAM_CONSTRUCTION_EST_PVT';

6: -- History :
7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EAM_CONSTRUCTION_EST_PVT';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'EAMVCESB.pls';
12: G_DEBUG_FILENAME CONSTANT VARCHAR2(50) := 'EAM_CONSTRUCTION_EST_DBG.log';
13:
14: PROCEDURE INIT_DEBUG(

Line 95: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'eam.plsql.EAM_CONSTRUCTION_EST_PVT', p_message);

91: l_sLog CONSTANT BOOLEAN := fnd_log.level_statement >= l_log_level;
92: BEGIN
93: EAM_ERROR_MESSAGE_PVT.WRITE_DEBUG(p_message);
94: IF (l_sLog) THEN
95: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'eam.plsql.EAM_CONSTRUCTION_EST_PVT', p_message);
96: END IF;
97: EXCEPTION
98: WHEN OTHERS THEN
99: NULL;

Line 4467: ( 'EAM_CONSTRUCTION_EST_PVT'

4463: ROLLBACK TO CREATE_CU_WORKORDERS;
4464: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4465: THEN
4466: fnd_msg_pub.add_exc_msg
4467: ( 'EAM_CONSTRUCTION_EST_PVT'
4468: , 'Create_CU_Workorders : l_stmt_num - '||to_char(l_stmt_num)
4469: );
4470:
4471: END IF;

Line 4634: ( 'EAM_CONSTRUCTION_EST_PVT'

4630: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4631: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4632: THEN
4633: fnd_msg_pub.add_exc_msg
4634: ( 'EAM_CONSTRUCTION_EST_PVT'
4635: , 'Populate_WO : Statement - '|| to_char(l_stmt_num)
4636: );
4637:
4638: END IF;

Line 4715: --EAM_CONSTRUCTION_MESSAGE_PVT.DEBUG('EAM_CONSTRUCTION_EST_PVT.POPULATE_OPERATION: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));

4711: );
4712: --
4713: WHEN OTHERS THEN
4714: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4715: --EAM_CONSTRUCTION_MESSAGE_PVT.DEBUG('EAM_CONSTRUCTION_EST_PVT.POPULATE_OPERATION: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
4716: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4717: THEN
4718: fnd_msg_pub.add_exc_msg
4719: ( 'EAM_CONSTRUCTION_EST_PVT'

Line 4719: ( 'EAM_CONSTRUCTION_EST_PVT'

4715: --EAM_CONSTRUCTION_MESSAGE_PVT.DEBUG('EAM_CONSTRUCTION_EST_PVT.POPULATE_OPERATION: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
4716: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4717: THEN
4718: fnd_msg_pub.add_exc_msg
4719: ( 'EAM_CONSTRUCTION_EST_PVT'
4720: , 'Populate_WO : Statement - '|| to_char(l_stmt_num)
4721: );
4722:
4723: END IF;

Line 4824: --EAM_CONSTRUCTION_MESSAGE_PVT.DEBUG('EAM_CONSTRUCTION_EST_PVT.POPULATE_RESOURCE: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));

4820: );
4821: --
4822: WHEN OTHERS THEN
4823: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4824: --EAM_CONSTRUCTION_MESSAGE_PVT.DEBUG('EAM_CONSTRUCTION_EST_PVT.POPULATE_RESOURCE: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
4825: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4826: THEN
4827: fnd_msg_pub.add_exc_msg
4828: ( 'EAM_CONSTRUCTION_EST_PVT'

Line 4828: ( 'EAM_CONSTRUCTION_EST_PVT'

4824: --EAM_CONSTRUCTION_MESSAGE_PVT.DEBUG('EAM_CONSTRUCTION_EST_PVT.POPULATE_RESOURCE: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
4825: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4826: THEN
4827: fnd_msg_pub.add_exc_msg
4828: ( 'EAM_CONSTRUCTION_EST_PVT'
4829: , 'POPULATE_RESOURCE : Statement - '|| to_char(l_stmt_num)
4830: );
4831:
4832: END IF;

Line 4937: --EAM_CONSTRUCTION_MESSAGE_PVT.DEBUG('EAM_CONSTRUCTION_EST_PVT.POPULATE_RESOURCE: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));

4933: );
4934: --
4935: WHEN OTHERS THEN
4936: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4937: --EAM_CONSTRUCTION_MESSAGE_PVT.DEBUG('EAM_CONSTRUCTION_EST_PVT.POPULATE_RESOURCE: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
4938: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4939: THEN
4940: fnd_msg_pub.add_exc_msg
4941: ( 'EAM_CONSTRUCTION_EST_PVT'

Line 4941: ( 'EAM_CONSTRUCTION_EST_PVT'

4937: --EAM_CONSTRUCTION_MESSAGE_PVT.DEBUG('EAM_CONSTRUCTION_EST_PVT.POPULATE_RESOURCE: Statement(' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,240));
4938: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4939: THEN
4940: fnd_msg_pub.add_exc_msg
4941: ( 'EAM_CONSTRUCTION_EST_PVT'
4942: , 'POPULATE_RESOURCE : Statement - '|| to_char(l_stmt_num)
4943: );
4944:
4945: END IF;

Line 5329: End EAM_CONSTRUCTION_EST_PVT;

5325: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5326: p_data => x_msg_data);
5327: END COPY_EST_WORKBENCH;
5328:
5329: End EAM_CONSTRUCTION_EST_PVT;