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_APIS_PUB dependencies on OKL_API

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

16: x_msg_count OUT NOCOPY NUMBER,
17: x_msg_data OUT NOCOPY VARCHAR2,
18: x_rgpv_tbl OUT NOCOPY rgpv_tbl_type,
19: x_rg_count OUT NOCOPY NUMBER) is
20: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
21: l_api_name CONSTANT VARCHAR2(30) := 'GET_CONTRACT_RGS';
22: l_api_version CONSTANT NUMBER := 1.0;
23: BEGIN
24: --Call OKL_API.START_ACTIVITY

Line 24: --Call OKL_API.START_ACTIVITY

20: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
21: l_api_name CONSTANT VARCHAR2(30) := 'GET_CONTRACT_RGS';
22: l_api_version CONSTANT NUMBER := 1.0;
23: BEGIN
24: --Call OKL_API.START_ACTIVITY
25: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
26: G_PKG_NAME,
27: p_init_msg_list,
28: l_api_version,

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

21: l_api_name CONSTANT VARCHAR2(30) := 'GET_CONTRACT_RGS';
22: l_api_version CONSTANT NUMBER := 1.0;
23: BEGIN
24: --Call OKL_API.START_ACTIVITY
25: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
26: G_PKG_NAME,
27: p_init_msg_list,
28: l_api_version,
29: p_api_version,

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

29: p_api_version,
30: '_PUB',
31: x_return_status);
32:
33: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
34: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
35: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
36: RAISE OKL_API.G_EXCEPTION_ERROR;
37: END IF;

Line 34: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

30: '_PUB',
31: x_return_status);
32:
33: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
34: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
35: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
36: RAISE OKL_API.G_EXCEPTION_ERROR;
37: END IF;
38:

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

31: x_return_status);
32:
33: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
34: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
35: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
36: RAISE OKL_API.G_EXCEPTION_ERROR;
37: END IF;
38:
39: OKL_RULE_APIS_PVT.Get_Contract_Rgs(p_api_version => p_api_version,

Line 36: RAISE OKL_API.G_EXCEPTION_ERROR;

32:
33: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
34: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
35: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
36: RAISE OKL_API.G_EXCEPTION_ERROR;
37: END IF;
38:
39: OKL_RULE_APIS_PVT.Get_Contract_Rgs(p_api_version => p_api_version,
40: p_init_msg_list => p_init_msg_list,

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

45: x_msg_count => x_msg_count,
46: x_msg_data => x_msg_data,
47: x_rgpv_tbl => x_rgpv_tbl,
48: x_rg_count => x_rg_count);
49: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
50: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
51: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
52: RAISE OKL_API.G_EXCEPTION_ERROR;
53: END IF;

Line 50: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

46: x_msg_data => x_msg_data,
47: x_rgpv_tbl => x_rgpv_tbl,
48: x_rg_count => x_rg_count);
49: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
50: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
51: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
52: RAISE OKL_API.G_EXCEPTION_ERROR;
53: END IF;
54:

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

47: x_rgpv_tbl => x_rgpv_tbl,
48: x_rg_count => x_rg_count);
49: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
50: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
51: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
52: RAISE OKL_API.G_EXCEPTION_ERROR;
53: END IF;
54:
55: --Call End Activity

Line 52: RAISE OKL_API.G_EXCEPTION_ERROR;

48: x_rg_count => x_rg_count);
49: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
50: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
51: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
52: RAISE OKL_API.G_EXCEPTION_ERROR;
53: END IF;
54:
55: --Call End Activity
56: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

52: RAISE OKL_API.G_EXCEPTION_ERROR;
53: END IF;
54:
55: --Call End Activity
56: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
57: x_msg_data => x_msg_data);
58: EXCEPTION
59: when OKL_API.G_EXCEPTION_ERROR then
60: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 59: when OKL_API.G_EXCEPTION_ERROR then

55: --Call End Activity
56: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
57: x_msg_data => x_msg_data);
58: EXCEPTION
59: when OKL_API.G_EXCEPTION_ERROR then
60: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
61: p_api_name => l_api_name,
62: p_pkg_name => g_pkg_name,
63: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 60: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

56: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
57: x_msg_data => x_msg_data);
58: EXCEPTION
59: when OKL_API.G_EXCEPTION_ERROR then
60: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
61: p_api_name => l_api_name,
62: p_pkg_name => g_pkg_name,
63: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
64: x_msg_count => x_msg_count,

Line 63: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

59: when OKL_API.G_EXCEPTION_ERROR then
60: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
61: p_api_name => l_api_name,
62: p_pkg_name => g_pkg_name,
63: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
64: x_msg_count => x_msg_count,
65: x_msg_data => x_msg_data,
66: p_api_type => g_api_type);
67:

Line 68: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

64: x_msg_count => x_msg_count,
65: x_msg_data => x_msg_data,
66: p_api_type => g_api_type);
67:
68: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
69: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
70: p_api_name => l_api_name,
71: p_pkg_name => g_pkg_name,
72: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 69: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

65: x_msg_data => x_msg_data,
66: p_api_type => g_api_type);
67:
68: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
69: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
70: p_api_name => l_api_name,
71: p_pkg_name => g_pkg_name,
72: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
73: x_msg_count => x_msg_count,

Line 72: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

68: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
69: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
70: p_api_name => l_api_name,
71: p_pkg_name => g_pkg_name,
72: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
73: x_msg_count => x_msg_count,
74: x_msg_data => x_msg_data,
75: p_api_type => g_api_type);
76:

Line 78: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

74: x_msg_data => x_msg_data,
75: p_api_type => g_api_type);
76:
77: when OTHERS then
78: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
79: p_api_name => l_api_name,
80: p_pkg_name => g_pkg_name,
81: p_exc_name => 'OTHERS',
82: x_msg_count => x_msg_count,

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

98: x_msg_data OUT NOCOPY VARCHAR2,
99: x_rulv_tbl OUT NOCOPY rulv_tbl_type,
100: x_rule_count OUT NOCOPY NUMBER ) IS
101:
102: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
103: l_api_name CONSTANT VARCHAR2(30) := 'GET_CONTRACT_RULES';
104: l_api_version CONSTANT NUMBER := 1.0;
105: BEGIN
106: --Call OKL_API.START_ACTIVITY

Line 106: --Call OKL_API.START_ACTIVITY

102: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
103: l_api_name CONSTANT VARCHAR2(30) := 'GET_CONTRACT_RULES';
104: l_api_version CONSTANT NUMBER := 1.0;
105: BEGIN
106: --Call OKL_API.START_ACTIVITY
107: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
108: G_PKG_NAME,
109: p_init_msg_list,
110: l_api_version,

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

103: l_api_name CONSTANT VARCHAR2(30) := 'GET_CONTRACT_RULES';
104: l_api_version CONSTANT NUMBER := 1.0;
105: BEGIN
106: --Call OKL_API.START_ACTIVITY
107: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
108: G_PKG_NAME,
109: p_init_msg_list,
110: l_api_version,
111: p_api_version,

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

111: p_api_version,
112: '_PUB',
113: x_return_status);
114:
115: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
116: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
117: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
118: RAISE OKL_API.G_EXCEPTION_ERROR;
119: END IF;

Line 116: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

112: '_PUB',
113: x_return_status);
114:
115: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
116: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
117: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
118: RAISE OKL_API.G_EXCEPTION_ERROR;
119: END IF;
120:

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

113: x_return_status);
114:
115: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
116: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
117: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
118: RAISE OKL_API.G_EXCEPTION_ERROR;
119: END IF;
120:
121: OKL_RULE_APIS_PVT.Get_Contract_Rules(p_api_version => p_api_version,

Line 118: RAISE OKL_API.G_EXCEPTION_ERROR;

114:
115: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
116: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
117: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
118: RAISE OKL_API.G_EXCEPTION_ERROR;
119: END IF;
120:
121: OKL_RULE_APIS_PVT.Get_Contract_Rules(p_api_version => p_api_version,
122: p_init_msg_list => p_init_msg_list,

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

127: x_msg_data => x_msg_data,
128: x_rulv_tbl => x_rulv_tbl,
129: x_rule_count => x_rule_count);
130:
131: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
133: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
134: RAISE OKL_API.G_EXCEPTION_ERROR;
135: END IF;

Line 132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

128: x_rulv_tbl => x_rulv_tbl,
129: x_rule_count => x_rule_count);
130:
131: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
133: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
134: RAISE OKL_API.G_EXCEPTION_ERROR;
135: END IF;
136:

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

129: x_rule_count => x_rule_count);
130:
131: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
133: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
134: RAISE OKL_API.G_EXCEPTION_ERROR;
135: END IF;
136:
137: --Call End Activity

Line 134: RAISE OKL_API.G_EXCEPTION_ERROR;

130:
131: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
133: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
134: RAISE OKL_API.G_EXCEPTION_ERROR;
135: END IF;
136:
137: --Call End Activity
138: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

134: RAISE OKL_API.G_EXCEPTION_ERROR;
135: END IF;
136:
137: --Call End Activity
138: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
139: x_msg_data => x_msg_data);
140: EXCEPTION
141: when OKL_API.G_EXCEPTION_ERROR then
142: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 141: when OKL_API.G_EXCEPTION_ERROR then

137: --Call End Activity
138: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
139: x_msg_data => x_msg_data);
140: EXCEPTION
141: when OKL_API.G_EXCEPTION_ERROR then
142: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
143: p_api_name => l_api_name,
144: p_pkg_name => g_pkg_name,
145: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 142: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

138: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
139: x_msg_data => x_msg_data);
140: EXCEPTION
141: when OKL_API.G_EXCEPTION_ERROR then
142: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
143: p_api_name => l_api_name,
144: p_pkg_name => g_pkg_name,
145: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
146: x_msg_count => x_msg_count,

Line 145: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

141: when OKL_API.G_EXCEPTION_ERROR then
142: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
143: p_api_name => l_api_name,
144: p_pkg_name => g_pkg_name,
145: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
146: x_msg_count => x_msg_count,
147: x_msg_data => x_msg_data,
148: p_api_type => g_api_type);
149:

Line 150: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

146: x_msg_count => x_msg_count,
147: x_msg_data => x_msg_data,
148: p_api_type => g_api_type);
149:
150: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
151: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
152: p_api_name => l_api_name,
153: p_pkg_name => g_pkg_name,
154: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 151: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

147: x_msg_data => x_msg_data,
148: p_api_type => g_api_type);
149:
150: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
151: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
152: p_api_name => l_api_name,
153: p_pkg_name => g_pkg_name,
154: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
155: x_msg_count => x_msg_count,

Line 154: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

150: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
151: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
152: p_api_name => l_api_name,
153: p_pkg_name => g_pkg_name,
154: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
155: x_msg_count => x_msg_count,
156: x_msg_data => x_msg_data,
157: p_api_type => g_api_type);
158:

Line 160: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

156: x_msg_data => x_msg_data,
157: p_api_type => g_api_type);
158:
159: when OTHERS then
160: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
161: p_api_name => l_api_name,
162: p_pkg_name => g_pkg_name,
163: p_exc_name => 'OTHERS',
164: x_msg_count => x_msg_count,

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

187: x_msg_data OUT NOCOPY VARCHAR2,
188: x_name OUT NOCOPY VARCHAR2,
189: x_select OUT NOCOPY VARCHAR2) IS
190:
191: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
192: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_INFORMATION';
193: l_api_version CONSTANT NUMBER := 1.0;
194: BEGIN
195: --Call OKL_API.START_ACTIVITY

Line 195: --Call OKL_API.START_ACTIVITY

191: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
192: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_INFORMATION';
193: l_api_version CONSTANT NUMBER := 1.0;
194: BEGIN
195: --Call OKL_API.START_ACTIVITY
196: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
197: G_PKG_NAME,
198: p_init_msg_list,
199: l_api_version,

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

192: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_INFORMATION';
193: l_api_version CONSTANT NUMBER := 1.0;
194: BEGIN
195: --Call OKL_API.START_ACTIVITY
196: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
197: G_PKG_NAME,
198: p_init_msg_list,
199: l_api_version,
200: p_api_version,

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

200: p_api_version,
201: '_PUB',
202: x_return_status);
203:
204: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
205: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
206: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
207: RAISE OKL_API.G_EXCEPTION_ERROR;
208: END IF;

Line 205: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

201: '_PUB',
202: x_return_status);
203:
204: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
205: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
206: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
207: RAISE OKL_API.G_EXCEPTION_ERROR;
208: END IF;
209:

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

202: x_return_status);
203:
204: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
205: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
206: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
207: RAISE OKL_API.G_EXCEPTION_ERROR;
208: END IF;
209:
210: OKL_RULE_APIS_PVT.Get_rule_Information (p_api_version => p_api_version,

Line 207: RAISE OKL_API.G_EXCEPTION_ERROR;

203:
204: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
205: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
206: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
207: RAISE OKL_API.G_EXCEPTION_ERROR;
208: END IF;
209:
210: OKL_RULE_APIS_PVT.Get_rule_Information (p_api_version => p_api_version,
211: p_init_msg_list => p_init_msg_list,

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

217: x_msg_data => x_msg_data,
218: x_name => x_name,
219: x_select => x_select);
220:
221: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
223: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
224: RAISE OKL_API.G_EXCEPTION_ERROR;
225: END IF;

Line 222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

218: x_name => x_name,
219: x_select => x_select);
220:
221: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
223: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
224: RAISE OKL_API.G_EXCEPTION_ERROR;
225: END IF;
226:

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

219: x_select => x_select);
220:
221: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
223: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
224: RAISE OKL_API.G_EXCEPTION_ERROR;
225: END IF;
226:
227: --Call End Activity

Line 224: RAISE OKL_API.G_EXCEPTION_ERROR;

220:
221: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
223: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
224: RAISE OKL_API.G_EXCEPTION_ERROR;
225: END IF;
226:
227: --Call End Activity
228: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

224: RAISE OKL_API.G_EXCEPTION_ERROR;
225: END IF;
226:
227: --Call End Activity
228: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
229: x_msg_data => x_msg_data);
230: EXCEPTION
231: when OKL_API.G_EXCEPTION_ERROR then
232: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 231: when OKL_API.G_EXCEPTION_ERROR then

227: --Call End Activity
228: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
229: x_msg_data => x_msg_data);
230: EXCEPTION
231: when OKL_API.G_EXCEPTION_ERROR then
232: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
233: p_api_name => l_api_name,
234: p_pkg_name => g_pkg_name,
235: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 232: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

228: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
229: x_msg_data => x_msg_data);
230: EXCEPTION
231: when OKL_API.G_EXCEPTION_ERROR then
232: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
233: p_api_name => l_api_name,
234: p_pkg_name => g_pkg_name,
235: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
236: x_msg_count => x_msg_count,

Line 235: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

231: when OKL_API.G_EXCEPTION_ERROR then
232: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
233: p_api_name => l_api_name,
234: p_pkg_name => g_pkg_name,
235: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
236: x_msg_count => x_msg_count,
237: x_msg_data => x_msg_data,
238: p_api_type => g_api_type);
239:

Line 240: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

236: x_msg_count => x_msg_count,
237: x_msg_data => x_msg_data,
238: p_api_type => g_api_type);
239:
240: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
241: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
242: p_api_name => l_api_name,
243: p_pkg_name => g_pkg_name,
244: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 241: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

237: x_msg_data => x_msg_data,
238: p_api_type => g_api_type);
239:
240: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
241: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
242: p_api_name => l_api_name,
243: p_pkg_name => g_pkg_name,
244: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
245: x_msg_count => x_msg_count,

Line 244: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

240: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
241: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
242: p_api_name => l_api_name,
243: p_pkg_name => g_pkg_name,
244: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
245: x_msg_count => x_msg_count,
246: x_msg_data => x_msg_data,
247: p_api_type => g_api_type);
248:

Line 250: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

246: x_msg_data => x_msg_data,
247: p_api_type => g_api_type);
248:
249: when OTHERS then
250: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
251: p_api_name => l_api_name,
252: p_pkg_name => g_pkg_name,
253: p_exc_name => 'OTHERS',
254: x_msg_count => x_msg_count,

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

283: x_inv_org_id OUT NOCOPY NUMBER,
284: x_book_type_code OUT NOCOPY VARCHAR2,
285: x_select OUT NOCOPY VARCHAR2)IS
286:
287: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
288: l_api_name CONSTANT VARCHAR2(30) := 'GET_JTOT_OBJECT';
289: l_api_version CONSTANT NUMBER := 1.0;
290: BEGIN
291: --Call OKL_API.START_ACTIVITY

Line 291: --Call OKL_API.START_ACTIVITY

287: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
288: l_api_name CONSTANT VARCHAR2(30) := 'GET_JTOT_OBJECT';
289: l_api_version CONSTANT NUMBER := 1.0;
290: BEGIN
291: --Call OKL_API.START_ACTIVITY
292: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
293: G_PKG_NAME,
294: p_init_msg_list,
295: l_api_version,

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

288: l_api_name CONSTANT VARCHAR2(30) := 'GET_JTOT_OBJECT';
289: l_api_version CONSTANT NUMBER := 1.0;
290: BEGIN
291: --Call OKL_API.START_ACTIVITY
292: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
293: G_PKG_NAME,
294: p_init_msg_list,
295: l_api_version,
296: p_api_version,

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

296: p_api_version,
297: '_PUB',
298: x_return_status);
299:
300: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
302: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
303: RAISE OKL_API.G_EXCEPTION_ERROR;
304: END IF;

Line 301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

297: '_PUB',
298: x_return_status);
299:
300: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
302: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
303: RAISE OKL_API.G_EXCEPTION_ERROR;
304: END IF;
305:

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

298: x_return_status);
299:
300: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
302: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
303: RAISE OKL_API.G_EXCEPTION_ERROR;
304: END IF;
305:
306: OKL_RULE_APIS_PVT.Get_jtot_object(p_api_version => p_api_version,

Line 303: RAISE OKL_API.G_EXCEPTION_ERROR;

299:
300: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
302: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
303: RAISE OKL_API.G_EXCEPTION_ERROR;
304: END IF;
305:
306: OKL_RULE_APIS_PVT.Get_jtot_object(p_api_version => p_api_version,
307: p_init_msg_list => p_init_msg_list,

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

322: x_inv_org_id => x_inv_org_id,
323: x_book_type_code => x_book_type_code,
324: x_select => x_select);
325:
326: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
327: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
328: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
329: RAISE OKL_API.G_EXCEPTION_ERROR;
330: END IF;

Line 327: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

323: x_book_type_code => x_book_type_code,
324: x_select => x_select);
325:
326: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
327: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
328: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
329: RAISE OKL_API.G_EXCEPTION_ERROR;
330: END IF;
331:

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

324: x_select => x_select);
325:
326: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
327: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
328: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
329: RAISE OKL_API.G_EXCEPTION_ERROR;
330: END IF;
331:
332: --Call End Activity

Line 329: RAISE OKL_API.G_EXCEPTION_ERROR;

325:
326: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
327: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
328: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
329: RAISE OKL_API.G_EXCEPTION_ERROR;
330: END IF;
331:
332: --Call End Activity
333: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

329: RAISE OKL_API.G_EXCEPTION_ERROR;
330: END IF;
331:
332: --Call End Activity
333: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
334: x_msg_data => x_msg_data);
335: EXCEPTION
336: when OKL_API.G_EXCEPTION_ERROR then
337: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 336: when OKL_API.G_EXCEPTION_ERROR then

332: --Call End Activity
333: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
334: x_msg_data => x_msg_data);
335: EXCEPTION
336: when OKL_API.G_EXCEPTION_ERROR then
337: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
338: p_api_name => l_api_name,
339: p_pkg_name => g_pkg_name,
340: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 337: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

333: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
334: x_msg_data => x_msg_data);
335: EXCEPTION
336: when OKL_API.G_EXCEPTION_ERROR then
337: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
338: p_api_name => l_api_name,
339: p_pkg_name => g_pkg_name,
340: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
341: x_msg_count => x_msg_count,

Line 340: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

336: when OKL_API.G_EXCEPTION_ERROR then
337: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
338: p_api_name => l_api_name,
339: p_pkg_name => g_pkg_name,
340: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
341: x_msg_count => x_msg_count,
342: x_msg_data => x_msg_data,
343: p_api_type => g_api_type);
344:

Line 345: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

341: x_msg_count => x_msg_count,
342: x_msg_data => x_msg_data,
343: p_api_type => g_api_type);
344:
345: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
346: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
347: p_api_name => l_api_name,
348: p_pkg_name => g_pkg_name,
349: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 346: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

342: x_msg_data => x_msg_data,
343: p_api_type => g_api_type);
344:
345: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
346: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
347: p_api_name => l_api_name,
348: p_pkg_name => g_pkg_name,
349: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
350: x_msg_count => x_msg_count,

Line 349: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

345: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
346: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
347: p_api_name => l_api_name,
348: p_pkg_name => g_pkg_name,
349: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
350: x_msg_count => x_msg_count,
351: x_msg_data => x_msg_data,
352: p_api_type => g_api_type);
353:

Line 355: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

351: x_msg_data => x_msg_data,
352: p_api_type => g_api_type);
353:
354: when OTHERS then
355: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
356: p_api_name => l_api_name,
357: p_pkg_name => g_pkg_name,
358: p_exc_name => 'OTHERS',
359: x_msg_count => x_msg_count,

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

372: x_msg_count OUT NOCOPY NUMBER,
373: x_msg_data OUT NOCOPY VARCHAR2,
374: x_rulv_disp_rec OUT NOCOPY rulv_disp_rec_type)IS
375:
376: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
377: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_DISP_VALUE';
378: l_api_version CONSTANT NUMBER := 1.0;
379: BEGIN
380: --Call OKL_API.START_ACTIVITY

Line 380: --Call OKL_API.START_ACTIVITY

376: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
377: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_DISP_VALUE';
378: l_api_version CONSTANT NUMBER := 1.0;
379: BEGIN
380: --Call OKL_API.START_ACTIVITY
381: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
382: G_PKG_NAME,
383: p_init_msg_list,
384: l_api_version,

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

377: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_DISP_VALUE';
378: l_api_version CONSTANT NUMBER := 1.0;
379: BEGIN
380: --Call OKL_API.START_ACTIVITY
381: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
382: G_PKG_NAME,
383: p_init_msg_list,
384: l_api_version,
385: p_api_version,

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

385: p_api_version,
386: '_PUB',
387: x_return_status);
388:
389: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
391: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
392: RAISE OKL_API.G_EXCEPTION_ERROR;
393: END IF;

Line 390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

386: '_PUB',
387: x_return_status);
388:
389: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
391: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
392: RAISE OKL_API.G_EXCEPTION_ERROR;
393: END IF;
394:

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

387: x_return_status);
388:
389: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
391: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
392: RAISE OKL_API.G_EXCEPTION_ERROR;
393: END IF;
394:
395: OKL_RULE_APIS_PVT.Get_Rule_disp_value(p_api_version => p_api_version,

Line 392: RAISE OKL_API.G_EXCEPTION_ERROR;

388:
389: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
391: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
392: RAISE OKL_API.G_EXCEPTION_ERROR;
393: END IF;
394:
395: OKL_RULE_APIS_PVT.Get_Rule_disp_value(p_api_version => p_api_version,
396: p_init_msg_list => p_init_msg_list,

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

399: x_msg_count => x_msg_count,
400: x_msg_data => x_msg_data,
401: x_rulv_disp_rec => x_rulv_disp_rec);
402:
403: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
404: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
405: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
406: RAISE OKL_API.G_EXCEPTION_ERROR;
407: END IF;

Line 404: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

400: x_msg_data => x_msg_data,
401: x_rulv_disp_rec => x_rulv_disp_rec);
402:
403: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
404: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
405: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
406: RAISE OKL_API.G_EXCEPTION_ERROR;
407: END IF;
408:

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

401: x_rulv_disp_rec => x_rulv_disp_rec);
402:
403: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
404: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
405: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
406: RAISE OKL_API.G_EXCEPTION_ERROR;
407: END IF;
408:
409: --Call End Activity

Line 406: RAISE OKL_API.G_EXCEPTION_ERROR;

402:
403: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
404: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
405: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
406: RAISE OKL_API.G_EXCEPTION_ERROR;
407: END IF;
408:
409: --Call End Activity
410: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

406: RAISE OKL_API.G_EXCEPTION_ERROR;
407: END IF;
408:
409: --Call End Activity
410: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
411: x_msg_data => x_msg_data);
412: EXCEPTION
413: when OKL_API.G_EXCEPTION_ERROR then
414: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 413: when OKL_API.G_EXCEPTION_ERROR then

409: --Call End Activity
410: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
411: x_msg_data => x_msg_data);
412: EXCEPTION
413: when OKL_API.G_EXCEPTION_ERROR then
414: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
415: p_api_name => l_api_name,
416: p_pkg_name => g_pkg_name,
417: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 414: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

410: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
411: x_msg_data => x_msg_data);
412: EXCEPTION
413: when OKL_API.G_EXCEPTION_ERROR then
414: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
415: p_api_name => l_api_name,
416: p_pkg_name => g_pkg_name,
417: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
418: x_msg_count => x_msg_count,

Line 417: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

413: when OKL_API.G_EXCEPTION_ERROR then
414: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
415: p_api_name => l_api_name,
416: p_pkg_name => g_pkg_name,
417: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
418: x_msg_count => x_msg_count,
419: x_msg_data => x_msg_data,
420: p_api_type => g_api_type);
421:

Line 422: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

418: x_msg_count => x_msg_count,
419: x_msg_data => x_msg_data,
420: p_api_type => g_api_type);
421:
422: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
423: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
424: p_api_name => l_api_name,
425: p_pkg_name => g_pkg_name,
426: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 423: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

419: x_msg_data => x_msg_data,
420: p_api_type => g_api_type);
421:
422: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
423: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
424: p_api_name => l_api_name,
425: p_pkg_name => g_pkg_name,
426: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
427: x_msg_count => x_msg_count,

Line 426: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

422: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
423: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
424: p_api_name => l_api_name,
425: p_pkg_name => g_pkg_name,
426: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
427: x_msg_count => x_msg_count,
428: x_msg_data => x_msg_data,
429: p_api_type => g_api_type);
430:

Line 432: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

428: x_msg_data => x_msg_data,
429: p_api_type => g_api_type);
430:
431: when OTHERS then
432: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
433: p_api_name => l_api_name,
434: p_pkg_name => g_pkg_name,
435: p_exc_name => 'OTHERS',
436: x_msg_count => x_msg_count,

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

465: x_inv_org_id OUT NOCOPY NUMBER,
466: x_book_type_code OUT NOCOPY VARCHAR2,
467: x_select OUT NOCOPY VARCHAR2) is
468:
469: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
470: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_SEGMENT_VALUE';
471: l_api_version CONSTANT NUMBER := 1.0;
472: Begin
473: --Call OKL_API.START_ACTIVITY

Line 473: --Call OKL_API.START_ACTIVITY

469: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
470: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_SEGMENT_VALUE';
471: l_api_version CONSTANT NUMBER := 1.0;
472: Begin
473: --Call OKL_API.START_ACTIVITY
474: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
475: G_PKG_NAME,
476: p_init_msg_list,
477: l_api_version,

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

470: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_SEGMENT_VALUE';
471: l_api_version CONSTANT NUMBER := 1.0;
472: Begin
473: --Call OKL_API.START_ACTIVITY
474: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
475: G_PKG_NAME,
476: p_init_msg_list,
477: l_api_version,
478: p_api_version,

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

477: l_api_version,
478: p_api_version,
479: '_PUB',
480: x_return_status);
481: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
482: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
483: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
484: RAISE OKL_API.G_EXCEPTION_ERROR;
485: END IF;

Line 482: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

478: p_api_version,
479: '_PUB',
480: x_return_status);
481: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
482: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
483: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
484: RAISE OKL_API.G_EXCEPTION_ERROR;
485: END IF;
486:

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

479: '_PUB',
480: x_return_status);
481: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
482: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
483: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
484: RAISE OKL_API.G_EXCEPTION_ERROR;
485: END IF;
486:
487: OKL_RULE_APIS_PVT.Get_rule_Segment_Value(p_api_version => p_api_version,

Line 484: RAISE OKL_API.G_EXCEPTION_ERROR;

480: x_return_status);
481: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
482: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
483: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
484: RAISE OKL_API.G_EXCEPTION_ERROR;
485: END IF;
486:
487: OKL_RULE_APIS_PVT.Get_rule_Segment_Value(p_api_version => p_api_version,
488: p_init_msg_list => p_init_msg_list,

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

505: x_inv_org_id => x_inv_org_id,
506: x_book_type_code => x_book_type_code,
507: x_select => x_select);
508:
509: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
510: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
511: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
512: RAISE OKL_API.G_EXCEPTION_ERROR;
513: END IF;

Line 510: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

506: x_book_type_code => x_book_type_code,
507: x_select => x_select);
508:
509: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
510: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
511: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
512: RAISE OKL_API.G_EXCEPTION_ERROR;
513: END IF;
514:

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

507: x_select => x_select);
508:
509: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
510: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
511: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
512: RAISE OKL_API.G_EXCEPTION_ERROR;
513: END IF;
514:
515: --Call End Activity

Line 512: RAISE OKL_API.G_EXCEPTION_ERROR;

508:
509: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
510: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
511: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
512: RAISE OKL_API.G_EXCEPTION_ERROR;
513: END IF;
514:
515: --Call End Activity
516: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

512: RAISE OKL_API.G_EXCEPTION_ERROR;
513: END IF;
514:
515: --Call End Activity
516: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
517: x_msg_data => x_msg_data);
518: EXCEPTION
519: when OKL_API.G_EXCEPTION_ERROR then
520: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 519: when OKL_API.G_EXCEPTION_ERROR then

515: --Call End Activity
516: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
517: x_msg_data => x_msg_data);
518: EXCEPTION
519: when OKL_API.G_EXCEPTION_ERROR then
520: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
521: p_api_name => l_api_name,
522: p_pkg_name => g_pkg_name,
523: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 520: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

516: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
517: x_msg_data => x_msg_data);
518: EXCEPTION
519: when OKL_API.G_EXCEPTION_ERROR then
520: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
521: p_api_name => l_api_name,
522: p_pkg_name => g_pkg_name,
523: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
524: x_msg_count => x_msg_count,

Line 523: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

519: when OKL_API.G_EXCEPTION_ERROR then
520: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
521: p_api_name => l_api_name,
522: p_pkg_name => g_pkg_name,
523: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
524: x_msg_count => x_msg_count,
525: x_msg_data => x_msg_data,
526: p_api_type => g_api_type);
527:

Line 528: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

524: x_msg_count => x_msg_count,
525: x_msg_data => x_msg_data,
526: p_api_type => g_api_type);
527:
528: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
529: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
530: p_api_name => l_api_name,
531: p_pkg_name => g_pkg_name,
532: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 529: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

525: x_msg_data => x_msg_data,
526: p_api_type => g_api_type);
527:
528: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
529: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
530: p_api_name => l_api_name,
531: p_pkg_name => g_pkg_name,
532: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
533: x_msg_count => x_msg_count,

Line 532: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

528: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
529: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
530: p_api_name => l_api_name,
531: p_pkg_name => g_pkg_name,
532: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
533: x_msg_count => x_msg_count,
534: x_msg_data => x_msg_data,
535: p_api_type => g_api_type);
536:

Line 538: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

534: x_msg_data => x_msg_data,
535: p_api_type => g_api_type);
536:
537: when OTHERS then
538: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
539: p_api_name => l_api_name,
540: p_pkg_name => g_pkg_name,
541: p_exc_name => 'OTHERS',
542: x_msg_count => x_msg_count,

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

573: x_org_id OUT NOCOPY NUMBER,
574: x_inv_org_id OUT NOCOPY NUMBER,
575: x_book_type_code OUT NOCOPY VARCHAR2,
576: x_select OUT NOCOPY VARCHAR2) is
577: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
578: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_SEGMENT_VALUE';
579: l_api_version CONSTANT NUMBER := 1.0;
580: Begin
581: --Call OKL_API.START_ACTIVITY

Line 581: --Call OKL_API.START_ACTIVITY

577: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
578: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_SEGMENT_VALUE';
579: l_api_version CONSTANT NUMBER := 1.0;
580: Begin
581: --Call OKL_API.START_ACTIVITY
582: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
583: G_PKG_NAME,
584: p_init_msg_list,
585: l_api_version,

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

578: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_SEGMENT_VALUE';
579: l_api_version CONSTANT NUMBER := 1.0;
580: Begin
581: --Call OKL_API.START_ACTIVITY
582: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
583: G_PKG_NAME,
584: p_init_msg_list,
585: l_api_version,
586: p_api_version,

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

585: l_api_version,
586: p_api_version,
587: '_PUB',
588: x_return_status);
589: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
590: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
591: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
592: RAISE OKL_API.G_EXCEPTION_ERROR;
593: END IF;

Line 590: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

586: p_api_version,
587: '_PUB',
588: x_return_status);
589: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
590: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
591: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
592: RAISE OKL_API.G_EXCEPTION_ERROR;
593: END IF;
594:

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

587: '_PUB',
588: x_return_status);
589: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
590: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
591: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
592: RAISE OKL_API.G_EXCEPTION_ERROR;
593: END IF;
594:
595: OKL_RULE_APIS_PVT.Get_rule_Segment_Value(p_api_version => p_api_version,

Line 592: RAISE OKL_API.G_EXCEPTION_ERROR;

588: x_return_status);
589: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
590: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
591: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
592: RAISE OKL_API.G_EXCEPTION_ERROR;
593: END IF;
594:
595: OKL_RULE_APIS_PVT.Get_rule_Segment_Value(p_api_version => p_api_version,
596: p_init_msg_list => p_init_msg_list,

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

613: x_inv_org_id => x_inv_org_id,
614: x_book_type_code => x_book_type_code,
615: x_select => x_select);
616:
617: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
618: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
619: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
620: RAISE OKL_API.G_EXCEPTION_ERROR;
621: END IF;

Line 618: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

614: x_book_type_code => x_book_type_code,
615: x_select => x_select);
616:
617: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
618: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
619: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
620: RAISE OKL_API.G_EXCEPTION_ERROR;
621: END IF;
622:

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

615: x_select => x_select);
616:
617: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
618: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
619: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
620: RAISE OKL_API.G_EXCEPTION_ERROR;
621: END IF;
622:
623: --Call End Activity

Line 620: RAISE OKL_API.G_EXCEPTION_ERROR;

616:
617: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
618: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
619: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
620: RAISE OKL_API.G_EXCEPTION_ERROR;
621: END IF;
622:
623: --Call End Activity
624: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

620: RAISE OKL_API.G_EXCEPTION_ERROR;
621: END IF;
622:
623: --Call End Activity
624: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
625: x_msg_data => x_msg_data);
626: EXCEPTION
627: when OKL_API.G_EXCEPTION_ERROR then
628: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 627: when OKL_API.G_EXCEPTION_ERROR then

623: --Call End Activity
624: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
625: x_msg_data => x_msg_data);
626: EXCEPTION
627: when OKL_API.G_EXCEPTION_ERROR then
628: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
629: p_api_name => l_api_name,
630: p_pkg_name => g_pkg_name,
631: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 628: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

624: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
625: x_msg_data => x_msg_data);
626: EXCEPTION
627: when OKL_API.G_EXCEPTION_ERROR then
628: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
629: p_api_name => l_api_name,
630: p_pkg_name => g_pkg_name,
631: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
632: x_msg_count => x_msg_count,

Line 631: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

627: when OKL_API.G_EXCEPTION_ERROR then
628: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
629: p_api_name => l_api_name,
630: p_pkg_name => g_pkg_name,
631: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
632: x_msg_count => x_msg_count,
633: x_msg_data => x_msg_data,
634: p_api_type => g_api_type);
635:

Line 636: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

632: x_msg_count => x_msg_count,
633: x_msg_data => x_msg_data,
634: p_api_type => g_api_type);
635:
636: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
637: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
638: p_api_name => l_api_name,
639: p_pkg_name => g_pkg_name,
640: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 637: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

633: x_msg_data => x_msg_data,
634: p_api_type => g_api_type);
635:
636: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
637: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
638: p_api_name => l_api_name,
639: p_pkg_name => g_pkg_name,
640: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
641: x_msg_count => x_msg_count,

Line 640: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

636: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
637: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
638: p_api_name => l_api_name,
639: p_pkg_name => g_pkg_name,
640: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
641: x_msg_count => x_msg_count,
642: x_msg_data => x_msg_data,
643: p_api_type => g_api_type);
644:

Line 646: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

642: x_msg_data => x_msg_data,
643: p_api_type => g_api_type);
644:
645: when OTHERS then
646: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
647: p_api_name => l_api_name,
648: p_pkg_name => g_pkg_name,
649: p_exc_name => 'OTHERS',
650: x_msg_count => x_msg_count,