1 PACKAGE BODY OKC_REP_VAL_CODE_HOOK AS
2 /* $Header: OKCRVALCHKB.pls 120.0.12020000.2 2013/03/22 06:43:20 kkolukul noship $ */
3
4 ---------------------------------------------------------------------------
5 -- PROCEDURES AND FUNCTIONS
6 ---------------------------------------------------------------------------
7
8 -- START OF COMMENTS
9 --API NAME : CUSTOM_CONT_VALIDATE
10 --TYPE : PRIVATE.
11 --FUNCTION : THIS API PERFORMS CUSTOM QA CHECKS ON A REPOSITORY CONTRACT IN ADDITION TO THE EXISTING VALIDATIONS.
12 --PRE-REQS : NONE.
13 --PARAMETERS :
14 --IN : P_API_VERSION IN NUMBER REQUIRED
15 -- : P_INIT_MSG_LIST IN VARCHAR2 OPTIONAL
16 -- : DEFAULT = FND_API.G_FALSE
17 -- : P_CONTRACT_ID IN NUMBER REQUIRED
18 -- : CONTRACT ID OF THE CONTRACT TO BE QA CHECKED
19 -- : P_CONTRACT_TYPE IN NUMBER REQUIRED
20 -- : TYPE OF THE CONTRACT TO BE QA CHECKED
21 --INOUT : P_QA_RESULT_TBL IN OUT
22 -- : THE TABLE OF RECORDS THAT CONTAINS VALIDATION ERRORS AND WARNINGS
23 --
24 -- ERRORS SHOULD BE POPULATED IN THE RESULT TABLE(PX_QA_RESULT_TBL) AS FOLLOWS
25 --
26 -- L_INDEX := PX_QA_RESULT_TBL.COUNT + 1;
27 -- PX_QA_RESULT_TBL(L_INDEX).ERROR_RECORD_TYPE := <WHERE THE ERROR IS COMING FROM>
28 -- PX_QA_RESULT_TBL(L_INDEX).TITLE := <TITLE OF THE ERROR>
29 -- PX_QA_RESULT_TBL(L_INDEX).QA_CODE := <CODE FOR THE ERROR>
30 -- PX_QA_RESULT_TBL(L_INDEX).MESSAGE_NAME := <ERROR MESSAGE NAME>
31 -- PX_QA_RESULT_TBL(L_INDEX).SUGGESTION := <ERROR SUGGESTION>
32 -- PX_QA_RESULT_TBL(L_INDEX).ERROR_SEVERITY := <ERROR SEVERITY>
33 -- PX_QA_RESULT_TBL(L_INDEX).PROBLEM_SHORT_DESC := <ERROR SHORT DESCRIPTION>
34 -- PX_QA_RESULT_TBL(L_INDEX).PROBLEM_DETAILS := <ERROR MESSAGE TEXT>
35 --
36 -- X_RETURN_STATUS WILL BE 'S' IF THE PROCEDURE HAS EXECUTED WITHOUT ANY EXCEPTIONS(HANDLED OR UNHANDLED).
37 --
38 --OUT : X_RETURN_STATUS OUT VARCHAR2(1)
39 -- : X_MSG_COUNT OUT NUMBER
40 -- : X_MSG_DATA OUT VARCHAR2(2000)
41 -- NOTE :
42 -- END OF COMMENTS
43
44 PROCEDURE CUSTOM_CONT_VALIDATE (
45 P_API_VERSION IN NUMBER,
46 P_INIT_MSG_LIST IN VARCHAR2,
47 P_CONTRACT_TYPE IN VARCHAR2,
48 P_CONTRACT_ID IN NUMBER,
49 PX_QA_RESULT_TBL IN OUT NOCOPY OKC_TERMS_QA_PVT.QA_RESULT_TBL_TYPE,
50 X_MSG_DATA OUT NOCOPY VARCHAR2,
51 X_MSG_COUNT OUT NOCOPY NUMBER,
52 X_RETURN_STATUS OUT NOCOPY VARCHAR2)
53 IS
54
55 BEGIN
56 X_RETURN_STATUS := G_RET_STS_SUCCESS;
57
58
59
60 END;
61
62
63 END OKC_REP_VAL_CODE_HOOK;