APPS.DPP_REQUEST_STATUS_PVT dependencies on DPP_REQUEST_STATUS_PVT

Line 1: PACKAGE BODY DPP_REQUEST_STATUS_PVT AS

1: PACKAGE BODY DPP_REQUEST_STATUS_PVT AS
2: /* $Header: dppvrstb.pls 120.11.12010000.3 2010/04/21 13:33:54 kansari ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_REQUEST_STATUS_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'dppvrstb.pls';

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

1: PACKAGE BODY DPP_REQUEST_STATUS_PVT AS
2: /* $Header: dppvrstb.pls 120.11.12010000.3 2010/04/21 13:33:54 kansari ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_REQUEST_STATUS_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'dppvrstb.pls';
6:
7: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
8: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 53: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_REQUEST_STATUS_PVT.EVENT_SUBSCRIPTION';

49: l_msg_count number;
50: l_msg_data varchar2(2000);
51: l_return_status varchar2(10);
52: l_approval_rec DPP_APPROVAL_PVT.approval_rec_type;
53: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_REQUEST_STATUS_PVT.EVENT_SUBSCRIPTION';
54: BEGIN
55: -- Standard begin of API savepoint
56: SAVEPOINT Event_Subscription_PVT;
57: -- Debug Message

Line 91: l_msg_callback_api := 'DPP_REQUEST_STATUS_PVT.Set_Request_Message';

87:
88: i := l_parameter_list.next(i);
89: END LOOP;
90:
91: l_msg_callback_api := 'DPP_REQUEST_STATUS_PVT.Set_Request_Message';
92:
93: l_approval_rec.object_type := l_object_type;
94: l_approval_rec.object_id := l_object_id;
95: l_approval_rec.status_code := l_status;

Line 192: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_REQUEST_STATUS_PVT.SET_REQUEST_MESSAGE';

188: l_days_covered number;
189: l_status varchar2(30);
190:
191: l_function_id NUMBER;
192: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_REQUEST_STATUS_PVT.SET_REQUEST_MESSAGE';
193:
194: cursor lc_get_request_details (pc_header_id number) is
195: select dtha.transaction_header_id
196: , dtha.transaction_number

Line 257: 'dpp.plsql.DPP_REQUEST_STATUS_PVT.Set_Request_Message.start',

253: BEGIN
254:
255: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
256: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
257: 'dpp.plsql.DPP_REQUEST_STATUS_PVT.Set_Request_Message.start',
258: 'Item type:' || p_itemtype || 'Item key:' || p_itemkey || '. Entity id: ' ||
259: p_transaction_header_id || '. Status:' || p_status );
260: end if;
261:

Line 435: 'dpp.plsql.DPP_REQUEST_STATUS_PVT.Set_Request_Message.end', 'Exiting');

431:
432: end if;
433: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
434: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
435: 'dpp.plsql.DPP_REQUEST_STATUS_PVT.Set_Request_Message.end', 'Exiting');
436: end if;
437:
438: END;
439: END DPP_REQUEST_STATUS_PVT;

Line 439: END DPP_REQUEST_STATUS_PVT;

435: 'dpp.plsql.DPP_REQUEST_STATUS_PVT.Set_Request_Message.end', 'Exiting');
436: end if;
437:
438: END;
439: END DPP_REQUEST_STATUS_PVT;