APPS.DPP_EXECUTIONDETAILS_PVT dependencies on DPP_EXECUTIONDETAILS_PVT

Line 1: PACKAGE BODY DPP_EXECUTIONDETAILS_PVT AS

1: PACKAGE BODY DPP_EXECUTIONDETAILS_PVT AS
2: /* $Header: dppvexeb.pls 120.10.12010000.2 2010/04/21 11:33:07 anbbalas ship $ */
3:
4: -- Package name : DPP_EXECUTIONDETAILS_PVT
5: -- Purpose :

Line 4: -- Package name : DPP_EXECUTIONDETAILS_PVT

1: PACKAGE BODY DPP_EXECUTIONDETAILS_PVT AS
2: /* $Header: dppvexeb.pls 120.10.12010000.2 2010/04/21 11:33:07 anbbalas ship $ */
3:
4: -- Package name : DPP_EXECUTIONDETAILS_PVT
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

6: -- History :
7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_EXECUTIONDETAILS_PVT';
11: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
12: G_FILE_NAME CONSTANT VARCHAR2(14) := 'dppvexeb.pls';
13:
14: ---------------------------------------------------------------------

Line 43: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_EXECUTIONDETAILS_PVT.UPDATE_EXECUTIONDETAILS';

39: IS
40: l_api_name CONSTANT VARCHAR2(30) := 'Update_ExecutionDetails';
41: l_api_version CONSTANT NUMBER := 1.0;
42: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
43: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_EXECUTIONDETAILS_PVT.UPDATE_EXECUTIONDETAILS';
44:
45: l_return_status VARCHAR2(30);
46: l_msg_count NUMBER;
47: l_msg_data VARCHAR2(4000);

Line 49: l_exe_update_rec DPP_EXECUTIONDETAILS_PVT.DPP_EXE_UPDATE_REC_TYPE := p_EXE_UPDATE_rec;

45: l_return_status VARCHAR2(30);
46: l_msg_count NUMBER;
47: l_msg_data VARCHAR2(4000);
48:
49: l_exe_update_rec DPP_EXECUTIONDETAILS_PVT.DPP_EXE_UPDATE_REC_TYPE := p_EXE_UPDATE_rec;
50: l_status_Update_tbl DPP_EXECUTIONDETAILS_PVT.dpp_status_Update_tbl_type := p_status_Update_tbl;
51: l_update_count NUMBER;
52:
53: l_process_code VARCHAR2(30);

Line 50: l_status_Update_tbl DPP_EXECUTIONDETAILS_PVT.dpp_status_Update_tbl_type := p_status_Update_tbl;

46: l_msg_count NUMBER;
47: l_msg_data VARCHAR2(4000);
48:
49: l_exe_update_rec DPP_EXECUTIONDETAILS_PVT.DPP_EXE_UPDATE_REC_TYPE := p_EXE_UPDATE_rec;
50: l_status_Update_tbl DPP_EXECUTIONDETAILS_PVT.dpp_status_Update_tbl_type := p_status_Update_tbl;
51: l_update_count NUMBER;
52:
53: l_process_code VARCHAR2(30);
54:

Line 255: fnd_message.set_token('ROUTINE', 'DPP_EXECUTIONDETAILS_PVT.Update_ExecutionDetails');

251: WHEN OTHERS THEN
252: ROLLBACK TO Update_ExecutionDetails_PVT;
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
255: fnd_message.set_token('ROUTINE', 'DPP_EXECUTIONDETAILS_PVT.Update_ExecutionDetails');
256: fnd_message.set_token('ERRNO', sqlcode);
257: fnd_message.set_token('REASON', sqlerrm);
258: fnd_msg_pub.add;
259: -- Standard call to get message count and if count=1, get the message

Line 301: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_EXECUTIONDETAILS_PVT.UPDATE_ESB_INSTANCEID';

297: IS
298: l_api_name CONSTANT VARCHAR2(30) := 'Update_ESB_InstanceID';
299: l_api_version CONSTANT NUMBER := 1.0;
300: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
301: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_EXECUTIONDETAILS_PVT.UPDATE_ESB_INSTANCEID';
302:
303: l_return_status VARCHAR2(30);
304: l_msg_count NUMBER;
305: l_msg_data VARCHAR2(4000);

Line 398: fnd_message.set_token('ROUTINE', 'DPP_EXECUTIONDETAILS_PVT.Update_ESB_InstanceID');

394: WHEN OTHERS THEN
395: ROLLBACK TO Update_ESB_InstanceID_PVT;
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
398: fnd_message.set_token('ROUTINE', 'DPP_EXECUTIONDETAILS_PVT.Update_ESB_InstanceID');
399: fnd_message.set_token('ERRNO', sqlcode);
400: fnd_message.set_token('REASON', sqlerrm);
401: fnd_msg_pub.add;
402: -- Standard call to get message count and if count=1, get the message

Line 415: END DPP_ExecutionDetails_PVT;

411: END LOOP;
412: END IF;
413: END Update_ESB_InstanceID;
414:
415: END DPP_ExecutionDetails_PVT;