eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_RULE_EXTRACT_PUB dependencies on OKL_API

Line 15: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

11: x_msg_data OUT NOCOPY VARCHAR2,
12: p_chr_id IN Varchar2,
13: x_sc_rg_tbl OUT NOCOPY sc_rg_tbl_type) is
14: l_api_name CONSTANT VARCHAR2(30) := 'GET_SUBCLASS_RGS';
15: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
16: Begin
17: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
18: G_PKG_NAME,
19: p_init_msg_list,

Line 17: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

13: x_sc_rg_tbl OUT NOCOPY sc_rg_tbl_type) is
14: l_api_name CONSTANT VARCHAR2(30) := 'GET_SUBCLASS_RGS';
15: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
16: Begin
17: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
18: G_PKG_NAME,
19: p_init_msg_list,
20: G_API_VERSION,
21: p_api_version,

Line 25: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

21: p_api_version,
22: G_SCOPE,
23: x_return_status);
24:
25: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
26: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
27: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
28: RAISE OKL_API.G_EXCEPTION_ERROR;
29: END IF;

Line 26: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

22: G_SCOPE,
23: x_return_status);
24:
25: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
26: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
27: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
28: RAISE OKL_API.G_EXCEPTION_ERROR;
29: END IF;
30: x_return_status := l_return_status;

Line 27: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

23: x_return_status);
24:
25: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
26: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
27: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
28: RAISE OKL_API.G_EXCEPTION_ERROR;
29: END IF;
30: x_return_status := l_return_status;
31: OKL_RULE_EXTRACT_PVT.Get_subclass_Rgs (p_api_version => p_api_version,

Line 28: RAISE OKL_API.G_EXCEPTION_ERROR;

24:
25: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
26: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
27: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
28: RAISE OKL_API.G_EXCEPTION_ERROR;
29: END IF;
30: x_return_status := l_return_status;
31: OKL_RULE_EXTRACT_PVT.Get_subclass_Rgs (p_api_version => p_api_version,
32: p_init_msg_list => p_init_msg_list,

Line 38: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

34: x_msg_count => x_msg_count,
35: x_msg_data => x_msg_data,
36: p_chr_id => p_chr_id,
37: x_sc_rg_tbl => x_sc_rg_tbl);
38: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
39: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
40: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
41: RAISE OKL_API.G_EXCEPTION_ERROR;
42: END IF;

Line 39: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

35: x_msg_data => x_msg_data,
36: p_chr_id => p_chr_id,
37: x_sc_rg_tbl => x_sc_rg_tbl);
38: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
39: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
40: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
41: RAISE OKL_API.G_EXCEPTION_ERROR;
42: END IF;
43: --Call End Activity

Line 40: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

36: p_chr_id => p_chr_id,
37: x_sc_rg_tbl => x_sc_rg_tbl);
38: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
39: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
40: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
41: RAISE OKL_API.G_EXCEPTION_ERROR;
42: END IF;
43: --Call End Activity
44: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 41: RAISE OKL_API.G_EXCEPTION_ERROR;

37: x_sc_rg_tbl => x_sc_rg_tbl);
38: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
39: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
40: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
41: RAISE OKL_API.G_EXCEPTION_ERROR;
42: END IF;
43: --Call End Activity
44: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
45: x_msg_data => x_msg_data);

Line 44: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

40: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
41: RAISE OKL_API.G_EXCEPTION_ERROR;
42: END IF;
43: --Call End Activity
44: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
45: x_msg_data => x_msg_data);
46: EXCEPTION
47: WHEN OKL_API.G_EXCEPTION_ERROR THEN
48: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 47: WHEN OKL_API.G_EXCEPTION_ERROR THEN

43: --Call End Activity
44: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
45: x_msg_data => x_msg_data);
46: EXCEPTION
47: WHEN OKL_API.G_EXCEPTION_ERROR THEN
48: x_return_status := OKL_API.HANDLE_EXCEPTIONS
49: (substr(l_api_name,1,26),
50: G_PKG_NAME,
51: 'OKL_API.G_RET_STS_ERROR',

Line 48: x_return_status := OKL_API.HANDLE_EXCEPTIONS

44: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
45: x_msg_data => x_msg_data);
46: EXCEPTION
47: WHEN OKL_API.G_EXCEPTION_ERROR THEN
48: x_return_status := OKL_API.HANDLE_EXCEPTIONS
49: (substr(l_api_name,1,26),
50: G_PKG_NAME,
51: 'OKL_API.G_RET_STS_ERROR',
52: x_msg_count,

Line 51: 'OKL_API.G_RET_STS_ERROR',

47: WHEN OKL_API.G_EXCEPTION_ERROR THEN
48: x_return_status := OKL_API.HANDLE_EXCEPTIONS
49: (substr(l_api_name,1,26),
50: G_PKG_NAME,
51: 'OKL_API.G_RET_STS_ERROR',
52: x_msg_count,
53: x_msg_data,
54: G_SCOPE);
55:

Line 56: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

52: x_msg_count,
53: x_msg_data,
54: G_SCOPE);
55:
56: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
57: x_return_status := OKL_API.HANDLE_EXCEPTIONS
58: (substr(l_api_name,1,26),
59: G_PKG_NAME,
60: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 57: x_return_status := OKL_API.HANDLE_EXCEPTIONS

53: x_msg_data,
54: G_SCOPE);
55:
56: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
57: x_return_status := OKL_API.HANDLE_EXCEPTIONS
58: (substr(l_api_name,1,26),
59: G_PKG_NAME,
60: 'OKL_API.G_RET_STS_UNEXP_ERROR',
61: x_msg_count,

Line 60: 'OKL_API.G_RET_STS_UNEXP_ERROR',

56: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
57: x_return_status := OKL_API.HANDLE_EXCEPTIONS
58: (substr(l_api_name,1,26),
59: G_PKG_NAME,
60: 'OKL_API.G_RET_STS_UNEXP_ERROR',
61: x_msg_count,
62: x_msg_data,
63: G_SCOPE);
64:

Line 67: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

63: G_SCOPE);
64:
65: WHEN OTHERS THEN
66: -- store SQL error message on message stack for caller
67: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
68: x_return_status := OKL_API.HANDLE_EXCEPTIONS
69: (substr(l_api_name,1,26),
70: G_PKG_NAME,
71: 'OTHERS',

Line 68: x_return_status := OKL_API.HANDLE_EXCEPTIONS

64:
65: WHEN OTHERS THEN
66: -- store SQL error message on message stack for caller
67: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
68: x_return_status := OKL_API.HANDLE_EXCEPTIONS
69: (substr(l_api_name,1,26),
70: G_PKG_NAME,
71: 'OTHERS',
72: x_msg_count,

Line 88: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

84: x_msg_data OUT NOCOPY VARCHAR2,
85: p_rgd_code IN Varchar2,
86: x_rg_rules_tbl OUT NOCOPY rg_rules_tbl_type) Is
87: l_api_name CONSTANT VARCHAR2(30) := 'GET_RG_RULES';
88: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
89: BEGIN
90: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
91: G_PKG_NAME,
92: p_init_msg_list,

Line 90: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

86: x_rg_rules_tbl OUT NOCOPY rg_rules_tbl_type) Is
87: l_api_name CONSTANT VARCHAR2(30) := 'GET_RG_RULES';
88: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
89: BEGIN
90: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
91: G_PKG_NAME,
92: p_init_msg_list,
93: G_API_VERSION,
94: p_api_version,

Line 98: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

94: p_api_version,
95: G_SCOPE,
96: x_return_status);
97:
98: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
99: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
100: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
101: RAISE OKL_API.G_EXCEPTION_ERROR;
102: END IF;

Line 99: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

95: G_SCOPE,
96: x_return_status);
97:
98: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
99: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
100: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
101: RAISE OKL_API.G_EXCEPTION_ERROR;
102: END IF;
103: x_return_status := l_return_status;

Line 100: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

96: x_return_status);
97:
98: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
99: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
100: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
101: RAISE OKL_API.G_EXCEPTION_ERROR;
102: END IF;
103: x_return_status := l_return_status;
104: OKL_RULE_EXTRACT_PVT.Get_Rg_Rules (p_api_version => p_api_version,

Line 101: RAISE OKL_API.G_EXCEPTION_ERROR;

97:
98: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
99: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
100: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
101: RAISE OKL_API.G_EXCEPTION_ERROR;
102: END IF;
103: x_return_status := l_return_status;
104: OKL_RULE_EXTRACT_PVT.Get_Rg_Rules (p_api_version => p_api_version,
105: p_init_msg_list => p_init_msg_list,

Line 111: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

107: x_msg_count => x_msg_count,
108: x_msg_data => x_msg_data,
109: p_rgd_code => p_rgd_code,
110: x_rg_rules_tbl => x_rg_rules_tbl);
111: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
112: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
114: RAISE OKL_API.G_EXCEPTION_ERROR;
115: END IF;

Line 112: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

108: x_msg_data => x_msg_data,
109: p_rgd_code => p_rgd_code,
110: x_rg_rules_tbl => x_rg_rules_tbl);
111: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
112: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
114: RAISE OKL_API.G_EXCEPTION_ERROR;
115: END IF;
116: --Call End Activity

Line 113: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

109: p_rgd_code => p_rgd_code,
110: x_rg_rules_tbl => x_rg_rules_tbl);
111: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
112: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
114: RAISE OKL_API.G_EXCEPTION_ERROR;
115: END IF;
116: --Call End Activity
117: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 114: RAISE OKL_API.G_EXCEPTION_ERROR;

110: x_rg_rules_tbl => x_rg_rules_tbl);
111: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
112: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
114: RAISE OKL_API.G_EXCEPTION_ERROR;
115: END IF;
116: --Call End Activity
117: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
118: x_msg_data => x_msg_data);

Line 117: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

113: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
114: RAISE OKL_API.G_EXCEPTION_ERROR;
115: END IF;
116: --Call End Activity
117: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
118: x_msg_data => x_msg_data);
119: EXCEPTION
120: WHEN OKL_API.G_EXCEPTION_ERROR THEN
121: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 120: WHEN OKL_API.G_EXCEPTION_ERROR THEN

116: --Call End Activity
117: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
118: x_msg_data => x_msg_data);
119: EXCEPTION
120: WHEN OKL_API.G_EXCEPTION_ERROR THEN
121: x_return_status := OKL_API.HANDLE_EXCEPTIONS
122: (substr(l_api_name,1,26),
123: G_PKG_NAME,
124: 'OKL_API.G_RET_STS_ERROR',

Line 121: x_return_status := OKL_API.HANDLE_EXCEPTIONS

117: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
118: x_msg_data => x_msg_data);
119: EXCEPTION
120: WHEN OKL_API.G_EXCEPTION_ERROR THEN
121: x_return_status := OKL_API.HANDLE_EXCEPTIONS
122: (substr(l_api_name,1,26),
123: G_PKG_NAME,
124: 'OKL_API.G_RET_STS_ERROR',
125: x_msg_count,

Line 124: 'OKL_API.G_RET_STS_ERROR',

120: WHEN OKL_API.G_EXCEPTION_ERROR THEN
121: x_return_status := OKL_API.HANDLE_EXCEPTIONS
122: (substr(l_api_name,1,26),
123: G_PKG_NAME,
124: 'OKL_API.G_RET_STS_ERROR',
125: x_msg_count,
126: x_msg_data,
127: G_SCOPE);
128:

Line 129: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

125: x_msg_count,
126: x_msg_data,
127: G_SCOPE);
128:
129: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
130: x_return_status := OKL_API.HANDLE_EXCEPTIONS
131: (substr(l_api_name,1,26),
132: G_PKG_NAME,
133: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 130: x_return_status := OKL_API.HANDLE_EXCEPTIONS

126: x_msg_data,
127: G_SCOPE);
128:
129: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
130: x_return_status := OKL_API.HANDLE_EXCEPTIONS
131: (substr(l_api_name,1,26),
132: G_PKG_NAME,
133: 'OKL_API.G_RET_STS_UNEXP_ERROR',
134: x_msg_count,

Line 133: 'OKL_API.G_RET_STS_UNEXP_ERROR',

129: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
130: x_return_status := OKL_API.HANDLE_EXCEPTIONS
131: (substr(l_api_name,1,26),
132: G_PKG_NAME,
133: 'OKL_API.G_RET_STS_UNEXP_ERROR',
134: x_msg_count,
135: x_msg_data,
136: G_SCOPE);
137:

Line 140: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

136: G_SCOPE);
137:
138: WHEN OTHERS THEN
139: -- store SQL error message on message stack for caller
140: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
141: x_return_status := OKL_API.HANDLE_EXCEPTIONS
142: (substr(l_api_name,1,26),
143: G_PKG_NAME,
144: 'OTHERS',

Line 141: x_return_status := OKL_API.HANDLE_EXCEPTIONS

137:
138: WHEN OTHERS THEN
139: -- store SQL error message on message stack for caller
140: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
141: x_return_status := OKL_API.HANDLE_EXCEPTIONS
142: (substr(l_api_name,1,26),
143: G_PKG_NAME,
144: 'OTHERS',
145: x_msg_count,

Line 163: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

159: p_rgs_code IN VARCHAR2,
160: p_buy_or_sell IN VARCHAR2,
161: x_rule_segment_tbl OUT NOCOPY rule_segment_tbl_type) IS
162: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_DEF';
163: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
164: BEGIN
165: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
166: G_PKG_NAME,
167: p_init_msg_list,

Line 165: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

161: x_rule_segment_tbl OUT NOCOPY rule_segment_tbl_type) IS
162: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_DEF';
163: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
164: BEGIN
165: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
166: G_PKG_NAME,
167: p_init_msg_list,
168: G_API_VERSION,
169: p_api_version,

Line 173: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

169: p_api_version,
170: G_SCOPE,
171: x_return_status);
172:
173: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
176: RAISE OKL_API.G_EXCEPTION_ERROR;
177: END IF;

Line 174: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

170: G_SCOPE,
171: x_return_status);
172:
173: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
176: RAISE OKL_API.G_EXCEPTION_ERROR;
177: END IF;
178: x_return_status := l_return_status;

Line 175: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

171: x_return_status);
172:
173: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
176: RAISE OKL_API.G_EXCEPTION_ERROR;
177: END IF;
178: x_return_status := l_return_status;
179: OKL_RULE_EXTRACT_PVT.Get_Rule_Def (p_api_version => p_api_version,

Line 176: RAISE OKL_API.G_EXCEPTION_ERROR;

172:
173: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
176: RAISE OKL_API.G_EXCEPTION_ERROR;
177: END IF;
178: x_return_status := l_return_status;
179: OKL_RULE_EXTRACT_PVT.Get_Rule_Def (p_api_version => p_api_version,
180: p_init_msg_list => p_init_msg_list,

Line 188: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

184: p_rgd_code => p_rgd_code,
185: p_rgs_code => p_rgs_code,
186: p_buy_or_sell => p_buy_or_sell,
187: x_rule_segment_tbl => x_rule_segment_tbl);
188: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
189: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
190: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
191: RAISE OKL_API.G_EXCEPTION_ERROR;
192: END IF;

Line 189: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

185: p_rgs_code => p_rgs_code,
186: p_buy_or_sell => p_buy_or_sell,
187: x_rule_segment_tbl => x_rule_segment_tbl);
188: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
189: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
190: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
191: RAISE OKL_API.G_EXCEPTION_ERROR;
192: END IF;
193: --Call End Activity

Line 190: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

186: p_buy_or_sell => p_buy_or_sell,
187: x_rule_segment_tbl => x_rule_segment_tbl);
188: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
189: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
190: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
191: RAISE OKL_API.G_EXCEPTION_ERROR;
192: END IF;
193: --Call End Activity
194: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 191: RAISE OKL_API.G_EXCEPTION_ERROR;

187: x_rule_segment_tbl => x_rule_segment_tbl);
188: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
189: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
190: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
191: RAISE OKL_API.G_EXCEPTION_ERROR;
192: END IF;
193: --Call End Activity
194: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
195: x_msg_data => x_msg_data);

Line 194: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

190: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
191: RAISE OKL_API.G_EXCEPTION_ERROR;
192: END IF;
193: --Call End Activity
194: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
195: x_msg_data => x_msg_data);
196: EXCEPTION
197: WHEN OKL_API.G_EXCEPTION_ERROR THEN
198: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 197: WHEN OKL_API.G_EXCEPTION_ERROR THEN

193: --Call End Activity
194: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
195: x_msg_data => x_msg_data);
196: EXCEPTION
197: WHEN OKL_API.G_EXCEPTION_ERROR THEN
198: x_return_status := OKL_API.HANDLE_EXCEPTIONS
199: (substr(l_api_name,1,26),
200: G_PKG_NAME,
201: 'OKL_API.G_RET_STS_ERROR',

Line 198: x_return_status := OKL_API.HANDLE_EXCEPTIONS

194: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
195: x_msg_data => x_msg_data);
196: EXCEPTION
197: WHEN OKL_API.G_EXCEPTION_ERROR THEN
198: x_return_status := OKL_API.HANDLE_EXCEPTIONS
199: (substr(l_api_name,1,26),
200: G_PKG_NAME,
201: 'OKL_API.G_RET_STS_ERROR',
202: x_msg_count,

Line 201: 'OKL_API.G_RET_STS_ERROR',

197: WHEN OKL_API.G_EXCEPTION_ERROR THEN
198: x_return_status := OKL_API.HANDLE_EXCEPTIONS
199: (substr(l_api_name,1,26),
200: G_PKG_NAME,
201: 'OKL_API.G_RET_STS_ERROR',
202: x_msg_count,
203: x_msg_data,
204: G_SCOPE);
205:

Line 206: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

202: x_msg_count,
203: x_msg_data,
204: G_SCOPE);
205:
206: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
207: x_return_status := OKL_API.HANDLE_EXCEPTIONS
208: (substr(l_api_name,1,26),
209: G_PKG_NAME,
210: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 207: x_return_status := OKL_API.HANDLE_EXCEPTIONS

203: x_msg_data,
204: G_SCOPE);
205:
206: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
207: x_return_status := OKL_API.HANDLE_EXCEPTIONS
208: (substr(l_api_name,1,26),
209: G_PKG_NAME,
210: 'OKL_API.G_RET_STS_UNEXP_ERROR',
211: x_msg_count,

Line 210: 'OKL_API.G_RET_STS_UNEXP_ERROR',

206: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
207: x_return_status := OKL_API.HANDLE_EXCEPTIONS
208: (substr(l_api_name,1,26),
209: G_PKG_NAME,
210: 'OKL_API.G_RET_STS_UNEXP_ERROR',
211: x_msg_count,
212: x_msg_data,
213: G_SCOPE);
214:

Line 217: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

213: G_SCOPE);
214:
215: WHEN OTHERS THEN
216: -- store SQL error message on message stack for caller
217: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
218: x_return_status := OKL_API.HANDLE_EXCEPTIONS
219: (substr(l_api_name,1,26),
220: G_PKG_NAME,
221: 'OTHERS',

Line 218: x_return_status := OKL_API.HANDLE_EXCEPTIONS

214:
215: WHEN OTHERS THEN
216: -- store SQL error message on message stack for caller
217: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
218: x_return_status := OKL_API.HANDLE_EXCEPTIONS
219: (substr(l_api_name,1,26),
220: G_PKG_NAME,
221: 'OTHERS',
222: x_msg_count,

Line 250: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

246: p_entity_column IN VARCHAR2,
247: x_rule_segment_tbl OUT NOCOPY rule_segment_tbl_type2) IS
248:
249: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_DEF';
250: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
251: BEGIN
252: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
253: G_PKG_NAME,
254: p_init_msg_list,

Line 252: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

248:
249: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_DEF';
250: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
251: BEGIN
252: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
253: G_PKG_NAME,
254: p_init_msg_list,
255: G_API_VERSION,
256: p_api_version,

Line 260: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

256: p_api_version,
257: G_SCOPE,
258: x_return_status);
259:
260: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
261: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
262: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
263: RAISE OKL_API.G_EXCEPTION_ERROR;
264: END IF;

Line 261: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

257: G_SCOPE,
258: x_return_status);
259:
260: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
261: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
262: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
263: RAISE OKL_API.G_EXCEPTION_ERROR;
264: END IF;
265: x_return_status := l_return_status;

Line 262: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

258: x_return_status);
259:
260: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
261: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
262: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
263: RAISE OKL_API.G_EXCEPTION_ERROR;
264: END IF;
265: x_return_status := l_return_status;
266: OKL_RULE_EXTRACT_PVT.Get_Rules_Metadata (

Line 263: RAISE OKL_API.G_EXCEPTION_ERROR;

259:
260: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
261: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
262: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
263: RAISE OKL_API.G_EXCEPTION_ERROR;
264: END IF;
265: x_return_status := l_return_status;
266: OKL_RULE_EXTRACT_PVT.Get_Rules_Metadata (
267: p_api_version => p_api_version,

Line 282: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

278: p_template_table => p_template_table,
279: p_rule_id_column => p_rule_id_column,
280: p_entity_column => p_entity_column,
281: x_rule_segment_tbl => x_rule_segment_tbl);
282: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
283: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
284: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
285: RAISE OKL_API.G_EXCEPTION_ERROR;
286: END IF;

Line 283: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

279: p_rule_id_column => p_rule_id_column,
280: p_entity_column => p_entity_column,
281: x_rule_segment_tbl => x_rule_segment_tbl);
282: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
283: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
284: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
285: RAISE OKL_API.G_EXCEPTION_ERROR;
286: END IF;
287: --Call End Activity

Line 284: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

280: p_entity_column => p_entity_column,
281: x_rule_segment_tbl => x_rule_segment_tbl);
282: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
283: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
284: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
285: RAISE OKL_API.G_EXCEPTION_ERROR;
286: END IF;
287: --Call End Activity
288: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 285: RAISE OKL_API.G_EXCEPTION_ERROR;

281: x_rule_segment_tbl => x_rule_segment_tbl);
282: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
283: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
284: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
285: RAISE OKL_API.G_EXCEPTION_ERROR;
286: END IF;
287: --Call End Activity
288: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
289: x_msg_data => x_msg_data);

Line 288: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

284: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
285: RAISE OKL_API.G_EXCEPTION_ERROR;
286: END IF;
287: --Call End Activity
288: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
289: x_msg_data => x_msg_data);
290: EXCEPTION
291: WHEN OKL_API.G_EXCEPTION_ERROR THEN
292: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 291: WHEN OKL_API.G_EXCEPTION_ERROR THEN

287: --Call End Activity
288: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
289: x_msg_data => x_msg_data);
290: EXCEPTION
291: WHEN OKL_API.G_EXCEPTION_ERROR THEN
292: x_return_status := OKL_API.HANDLE_EXCEPTIONS
293: (substr(l_api_name,1,26),
294: G_PKG_NAME,
295: 'OKL_API.G_RET_STS_ERROR',

Line 292: x_return_status := OKL_API.HANDLE_EXCEPTIONS

288: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
289: x_msg_data => x_msg_data);
290: EXCEPTION
291: WHEN OKL_API.G_EXCEPTION_ERROR THEN
292: x_return_status := OKL_API.HANDLE_EXCEPTIONS
293: (substr(l_api_name,1,26),
294: G_PKG_NAME,
295: 'OKL_API.G_RET_STS_ERROR',
296: x_msg_count,

Line 295: 'OKL_API.G_RET_STS_ERROR',

291: WHEN OKL_API.G_EXCEPTION_ERROR THEN
292: x_return_status := OKL_API.HANDLE_EXCEPTIONS
293: (substr(l_api_name,1,26),
294: G_PKG_NAME,
295: 'OKL_API.G_RET_STS_ERROR',
296: x_msg_count,
297: x_msg_data,
298: G_SCOPE);
299:

Line 300: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

296: x_msg_count,
297: x_msg_data,
298: G_SCOPE);
299:
300: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
301: x_return_status := OKL_API.HANDLE_EXCEPTIONS
302: (substr(l_api_name,1,26),
303: G_PKG_NAME,
304: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 301: x_return_status := OKL_API.HANDLE_EXCEPTIONS

297: x_msg_data,
298: G_SCOPE);
299:
300: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
301: x_return_status := OKL_API.HANDLE_EXCEPTIONS
302: (substr(l_api_name,1,26),
303: G_PKG_NAME,
304: 'OKL_API.G_RET_STS_UNEXP_ERROR',
305: x_msg_count,

Line 304: 'OKL_API.G_RET_STS_UNEXP_ERROR',

300: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
301: x_return_status := OKL_API.HANDLE_EXCEPTIONS
302: (substr(l_api_name,1,26),
303: G_PKG_NAME,
304: 'OKL_API.G_RET_STS_UNEXP_ERROR',
305: x_msg_count,
306: x_msg_data,
307: G_SCOPE);
308:

Line 311: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

307: G_SCOPE);
308:
309: WHEN OTHERS THEN
310: -- store SQL error message on message stack for caller
311: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
312: x_return_status := OKL_API.HANDLE_EXCEPTIONS
313: (substr(l_api_name,1,26),
314: G_PKG_NAME,
315: 'OTHERS',

Line 312: x_return_status := OKL_API.HANDLE_EXCEPTIONS

308:
309: WHEN OTHERS THEN
310: -- store SQL error message on message stack for caller
311: OKL_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
312: x_return_status := OKL_API.HANDLE_EXCEPTIONS
313: (substr(l_api_name,1,26),
314: G_PKG_NAME,
315: 'OTHERS',
316: x_msg_count,