[Home] [Help]
PACKAGE: APPS.OKC_QA_DATA_INTEGRITY
Source
1 PACKAGE OKC_QA_DATA_INTEGRITY AUTHID CURRENT_USER AS
2 /* $Header: OKCRQADS.pls 120.0 2005/05/25 22:54:17 appldev noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL MESSAGE CONSTANTS
6 ---------------------------------------------------------------------------
7 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
8 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
9 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
10 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
11 G_INVALID_END_DATE CONSTANT VARCHAR2(200) := 'OKC_INVALID_END_DATE';
12 --
13 G_QA_SUCCESS CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_QA_SUCCESS';
14 G_PARTY_COUNT CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_PARTY_COUNT';
15 G_REQUIRED_RULE CONSTANT VARCHAR2(200) := 'OKC_REQUIRED_RULE';
16 G_REQUIRED_RULE_GROUP CONSTANT VARCHAR2(200) := 'OKC_REQUIRED_RULE_GROUP';
17 G_REQUIRED_RULE_VALUES CONSTANT VARCHAR2(200) := 'OKC_REQUIRED_RULE_VALUES';
18 G_REQUIRED_RULE_PARTY_ROLE CONSTANT VARCHAR2(200) := 'OKC_REQUIRED_RULE_PARTY_ROLE';
19 G_RULE_DEPENDENT_VALUE CONSTANT VARCHAR2(200) := 'OKC_RULE_DEPENDENT_VALUE';
20 G_INVALID_LINE_DATES CONSTANT VARCHAR2(200) := 'OKC_INVALID_LINE_DATES';
21 G_INVALID_COVERAGELINE_DATES CONSTANT VARCHAR2(200) := 'OKC_INVALID_COVERAGELINE_DATES';
22 G_REQUIRED_LINE_VALUE CONSTANT VARCHAR2(200) := 'OKC_REQUIRED_LINE_FIELD';
23 G_INVALID_LINE_CURRENCY CONSTANT VARCHAR2(200) := 'OKC_INVALID_LINE_CURRENCY';
24 G_RULE_ROLE_DELETED CONSTANT VARCHAR2(200) := 'OKC_RULE_ROLE_DELETED';
25 G_RULE_ROLE_CHANGED CONSTANT VARCHAR2(200) := 'OKC_RULE_ROLE_CHANGED';
26 G_NO_SUBLINE_PARTY CONSTANT VARCHAR2(200) := 'OKC_NO_PARTY_SUBLINE';
27 G_NO_HEADER_PARTY CONSTANT VARCHAR2(200) := 'OKC_NO_PARTY_HEADER';
28 G_NO_SUBLINE_RULE CONSTANT VARCHAR2(200) := 'OKC_NO_RULE_SUBLINE';
29
30 ------------------------------------------------------------------------------------
31 -- GLOBAL EXCEPTION
32 ---------------------------------------------------------------------------
33 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
34
35 -- GLOBAL VARIABLES
36 ---------------------------------------------------------------------------
37 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKC_QA_DATA_INTEGRITY';
38 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
39 ---------------------------------------------------------------------------
40
41 PROCEDURE check_required_values(
42 x_return_status OUT NOCOPY VARCHAR2,
43 p_chr_id IN NUMBER);
44
45 PROCEDURE check_art_compatible(
46 x_return_status OUT NOCOPY VARCHAR2,
47 p_chr_id IN NUMBER
48 );
49
50 PROCEDURE check_rule_groups(
51 x_return_status OUT NOCOPY VARCHAR2,
52 p_chr_id IN NUMBER);
53
54 PROCEDURE check_rule_group_parties(
55 x_return_status OUT NOCOPY VARCHAR2,
56 p_chr_id IN NUMBER);
57
58 PROCEDURE check_effectivity_dates(
59 x_return_status OUT NOCOPY VARCHAR2,
60 p_chr_id IN NUMBER);
61
62 END OKC_QA_DATA_INTEGRITY;