APPS.OZF_REQUEST_STATUS_PVT dependencies on OZF_REQUEST_STATUS_PVT

Line 1: PACKAGE BODY OZF_REQUEST_STATUS_PVT AS

1: PACKAGE BODY OZF_REQUEST_STATUS_PVT AS
2: /* $Header: ozfvrstb.pls 120.7.12020000.2 2012/07/13 05:46:49 rvkondur ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_REQUEST_STATUS_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvrstb.pls';

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

1: PACKAGE BODY OZF_REQUEST_STATUS_PVT AS
2: /* $Header: ozfvrstb.pls 120.7.12020000.2 2012/07/13 05:46:49 rvkondur ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_REQUEST_STATUS_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvrstb.pls';
6:
7: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
8: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 104: l_msg_callback_api := 'OZF_REQUEST_STATUS_PVT.Set_Request_Message';

100: OPEN csr_benefit (l_object_id);
101: FETCH csr_benefit INTO l_benefit_id, l_partner_id;
102: CLOSE csr_benefit;
103:
104: l_msg_callback_api := 'OZF_REQUEST_STATUS_PVT.Set_Request_Message';
105: l_user_callback_api := 'OZF_REQUEST_STATUS_PVT.Return_Request_Userlist';
106:
107: l_approval_rec.object_type := l_object_type;
108: l_approval_rec.object_id := l_object_id;

Line 105: l_user_callback_api := 'OZF_REQUEST_STATUS_PVT.Return_Request_Userlist';

101: FETCH csr_benefit INTO l_benefit_id, l_partner_id;
102: CLOSE csr_benefit;
103:
104: l_msg_callback_api := 'OZF_REQUEST_STATUS_PVT.Set_Request_Message';
105: l_user_callback_api := 'OZF_REQUEST_STATUS_PVT.Return_Request_Userlist';
106:
107: l_approval_rec.object_type := l_object_type;
108: l_approval_rec.object_id := l_object_id;
109: l_approval_rec.status_code := l_status;

Line 345: 'ozf.plsql.OZF_REQUEST_STATUS_PVT.Set_Request_Message.start',

341: BEGIN
342:
343: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
344: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
345: 'ozf.plsql.OZF_REQUEST_STATUS_PVT.Set_Request_Message.start',
346: 'Item type:' || p_itemtype || 'Item key:' || p_itemkey || '. Entity id: ' ||
347: p_entity_id || '. Status:' || p_status || '. User type: ' || p_user_type);
348: end if;
349:

Line 763: 'ozf.plsql.OZF_REQUEST_STATUS_PVT.Set_Request_Message.end', 'Exiting');

759: end if; --if p_itemtype = 'OZFSPBEN' then
760:
761: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
762: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
763: 'ozf.plsql.OZF_REQUEST_STATUS_PVT.Set_Request_Message.end', 'Exiting');
764: end if;
765:
766: END;
767:

Line 866: 'ozf.plsql.OZF_REQUEST_STATUS_PVT.Return_Request_Userlist.start',

862:
863: begin
864: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
865: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
866: 'ozf.plsql.OZF_REQUEST_STATUS_PVT.Return_Request_Userlist.start',
867: 'Benefit type:' || p_benefit_type || '. Entity id: ' || p_entity_id ||
868: '. Status:' || p_status || '. User type: ' || p_user_role);
869: end if;
870:

Line 915: 'ozf.plsql.OZF_REQUEST_STATUS_PVT.Return_Request_Userlist.info',

911:
912: else
913: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
914: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
915: 'ozf.plsql.OZF_REQUEST_STATUS_PVT.Return_Request_Userlist.info',
916: 'Unrecognized user role:' || p_user_role);
917: END IF;
918: end if;
919:

Line 922: 'ozf.plsql.OZF_REQUEST_STATUS_PVT.Return_Request_Userlist.end', 'Exiting');

918: end if;
919:
920: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
921: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
922: 'ozf.plsql.OZF_REQUEST_STATUS_PVT.Return_Request_Userlist.end', 'Exiting');
923: end if;
924:
925: return l_role_list;
926: end;

Line 1319: END OZF_REQUEST_STATUS_PVT;

1315:
1316: -- 'R12.1 Enhancement: Ship & Debit Request' by ateotia(-)
1317:
1318:
1319: END OZF_REQUEST_STATUS_PVT;