[Home] [Help]
PACKAGE: APPS.OKL_OA_DATA_INTEGRITY
Source
1 PACKAGE OKL_OA_DATA_INTEGRITY AS
2 /* $Header: OKLROAQS.pls 120.0 2005/09/15 18:22:48 manumanu noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL MESSAGE CONSTANTS
6 ---------------------------------------------------------------------------
7 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
8 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
9 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
10 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
11 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
12 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
13 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
14 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
15 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
16 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
17 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
18 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
19 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
20 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
21 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPERCASE_REQUIRED';
22 G_INVALID_END_DATE CONSTANT VARCHAR2(200) := 'OKC_INVALID_END_DATE';
23 --
24 G_QA_SUCCESS CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_QA_SUCCESS';
25 G_PARTY_COUNT CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_PARTY_COUNT';
26 G_REQUIRED_RULE CONSTANT VARCHAR2(200) := 'OKC_REQUIRED_RULE';
27 G_REQUIRED_RULE_GROUP CONSTANT VARCHAR2(200) := 'OKC_REQUIRED_RULE_GROUP';
28 G_REQUIRED_RULE_VALUES CONSTANT VARCHAR2(200) := 'OKC_REQUIRED_RULE_VALUES';
29 G_REQUIRED_RULE_PARTY_ROLE CONSTANT VARCHAR2(200) := 'OKC_REQUIRED_RULE_PARTY_ROLE';
30 G_RULE_DEPENDENT_VALUE CONSTANT VARCHAR2(200) := 'OKC_RULE_DEPENDENT_VALUE';
31 G_INVALID_LINE_DATES CONSTANT VARCHAR2(200) := 'OKC_INVALID_LINE_DATES';
32 G_REQUIRED_LINE_VALUE CONSTANT VARCHAR2(200) := 'OKC_REQUIRED_LINE_FIELD';
33 G_INVALID_LINE_CURRENCY CONSTANT VARCHAR2(200) := 'OKC_INVALID_LINE_CURRENCY';
34 G_RULE_ROLE_DELETED CONSTANT VARCHAR2(200) := 'OKC_RULE_ROLE_DELETED';
35 G_RULE_ROLE_CHANGED CONSTANT VARCHAR2(200) := 'OKC_RULE_ROLE_CHANGED';
36 G_NO_SUBLINE_PARTY CONSTANT VARCHAR2(200) := 'OKC_NO_PARTY_SUBLINE';
37 G_NO_HEADER_PARTY CONSTANT VARCHAR2(200) := 'OKC_NO_PARTY_HEADER';
38 G_NO_SUBLINE_RULE CONSTANT VARCHAR2(200) := 'OKC_NO_RULE_SUBLINE';
39 G_NOT_ALLOWED_RULE CONSTANT VARCHAR2(200) := 'OKC_NOT_ALLOWED_RULE';
40 ------------------------------------------------------------------------------------
41 -- GLOBAL EXCEPTION
42 ---------------------------------------------------------------------------
43 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
44
45 -- GLOBAL VARIABLES
46 ---------------------------------------------------------------------------
47 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_QA_SECURITIZATION';
48 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
49 ---------------------------------------------------------------------------
50
51
52 PROCEDURE check_functional_constraints(
53 x_return_status OUT NOCOPY VARCHAR2,
54 p_chr_id IN NUMBER);
55
56 END OKL_OA_DATA_INTEGRITY;