DBA Data[Home] [Help]

APPS.EDR_ISIGN_CHECKLIST_PVT dependencies on EDR_ISIGN_CHECKLIST_PVT

Line 1: PACKAGE BODY EDR_ISIGN_CHECKLIST_PVT AS

1: PACKAGE BODY EDR_ISIGN_CHECKLIST_PVT AS
2: /* $Header: EDRVISCB.pls 120.8.12000000.1 2007/01/18 05:56:21 appldev ship $ */
3:
4: -- GLOBAL decleration
5:

Line 228: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_ISIGN_CHECKLIST_PVT');

224: x_checklist_ver:=NULL;
225: ROLLBACK TO CHECKLIST_REQUIRED;
226: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
227: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
228: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_ISIGN_CHECKLIST_PVT');
229: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','IS_CHECKLIST_REQUIRED ');
230: --Bug 4162993: Start
231: APP_EXCEPTION.RAISE_EXCEPTION;
232: --Bug 4162993: End

Line 306: EDR_ISIGN_CHECKLIST_PVT.IS_CHECKLIST_PRESENT(p_file_id =>p_file_id,

302: l_category_id NUMBER;
303: l_checklist_status VARCHAR2(1);
304: Begin
305: -- Check if checklsit exists for the file
306: EDR_ISIGN_CHECKLIST_PVT.IS_CHECKLIST_PRESENT(p_file_id =>p_file_id,
307: x_checklist_Status=>l_checklist_Status
308: );
309:
310: If l_checklist_status= 'Y' THEN

Line 397: END EDR_ISIGN_CHECKLIST_PVT;

393: when others then
394: x_return_Status:='E';
395: END DELETE_CHECKLIST;
396:
397: END EDR_ISIGN_CHECKLIST_PVT;