1: package body psp_efforts_pkg AS
2: /* $Header: PSPEREFB.pls 120.2.12010000.2 2008/08/05 10:11:27 ubhat ship $ */
3: /***********************************************************************************
4: ** NAME: psp_efforts_pkg
5: ** CONTENTS: Package Body for psp_efforts_pkg
1: package body psp_efforts_pkg AS
2: /* $Header: PSPEREFB.pls 120.2.12010000.2 2008/08/05 10:11:27 ubhat ship $ */
3: /***********************************************************************************
4: ** NAME: psp_efforts_pkg
5: ** CONTENTS: Package Body for psp_efforts_pkg
6: ** PURPOSE: This Package Body contains two procedures .
7: ** 1. PROCEDURE crt
8: ** This procedure takes in as input the various input criteria
1: package body psp_efforts_pkg AS
2: /* $Header: PSPEREFB.pls 120.2.12010000.2 2008/08/05 10:11:27 ubhat ship $ */
3: /***********************************************************************************
4: ** NAME: psp_efforts_pkg
5: ** CONTENTS: Package Body for psp_efforts_pkg
6: ** PURPOSE: This Package Body contains two procedures .
7: ** 1. PROCEDURE crt
8: ** This procedure takes in as input the various input criteria
9: ** entered by the user during Effort Report Creation. The input
231: ---
232: EXCEPTION
233: WHEN OTHERS THEN
234: --dbms_output.put_line('POETA retrieval failed');
235: FND_MESSAGE.set_name('PSP','PSP_EFFORTS_PKG.CRT_POETA_FAIL');
236: log_errors(template_id1,person_id1,'GL_POETA Selection Criteria failed' ,NULL,NULL);
237: ---RAISE FND_API.g_exc_unexpected_error;
238: END;
239: -----