DBA Data[Home] [Help]

APPS.OKL_ACCT_GEN_RULE_PUB dependencies on OKL_API

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

14: l_api_version NUMBER := 1.0;
15: l_api_name VARCHAR2(30) := 'GET_RULE_LINES_COUNT';
16:
17: l_ae_line_type VARCHAR2(30) := p_ae_line_type;
18: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
19: l_line_count NUMBER := 0;
20:
21: BEGIN
22:

Line 43: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

39: p_ae_line_type => l_ae_line_type,
40: x_line_count => x_line_count);
41:
42:
43: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
44:
45: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
46:
47: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

Line 45: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

41:
42:
43: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
44:
45: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
46:
47: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
48:
49: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 47: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

43: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
44:
45: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
46:
47: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
48:
49: RAISE OKL_API.G_EXCEPTION_ERROR;
50:
51: END IF;

Line 49: RAISE OKL_API.G_EXCEPTION_ERROR;

45: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
46:
47: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
48:
49: RAISE OKL_API.G_EXCEPTION_ERROR;
50:
51: END IF;
52:
53: l_line_count := x_line_count;

Line 65: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

61: WHEN FND_API.G_EXC_ERROR THEN
62: ROLLBACK TO GET_RULE_LINES_COUNT;
63: x_return_status := FND_API.G_RET_STS_ERROR;
64:
65: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
66: ,p_count => x_msg_count
67: ,p_data => x_msg_data);
68:
69: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 72: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

68:
69: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
70: ROLLBACK TO GET_RULE_LINES_COUNT;
71: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
72: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
73: ,p_count => x_msg_count
74: ,p_data => x_msg_data);
75:
76: WHEN OTHERS THEN

Line 79: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

75:
76: WHEN OTHERS THEN
77:
78: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_GEN_RULE_PUB','GET_RULE_LINES_COUNT');
79: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
80: ,p_count => x_msg_count
81: ,p_data => x_msg_data);
82: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
83:

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

99: l_api_version NUMBER := 1.0;
100: l_api_name VARCHAR2(30) := 'GET_RULE_LINES';
101:
102: l_ae_line_type VARCHAR2(30) := p_ae_line_type;
103: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
104: l_acc_lines ACCT_TBL_TYPE;
105: l_line_count NUMBER := 0;
106:
107: BEGIN

Line 129: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

125: p_ae_line_type => l_ae_line_type,
126: x_acc_lines => x_acc_lines);
127:
128:
129: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
130:
131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
132:
133: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

Line 131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

127:
128:
129: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
130:
131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
132:
133: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
134:
135: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 133: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

129: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
130:
131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
132:
133: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
134:
135: RAISE OKL_API.G_EXCEPTION_ERROR;
136:
137: END IF;

Line 135: RAISE OKL_API.G_EXCEPTION_ERROR;

131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
132:
133: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
134:
135: RAISE OKL_API.G_EXCEPTION_ERROR;
136:
137: END IF;
138:
139: l_acc_lines := x_acc_lines;

Line 151: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

147: WHEN FND_API.G_EXC_ERROR THEN
148: ROLLBACK TO GET_RULE_LINES;
149: x_return_status := FND_API.G_RET_STS_ERROR;
150:
151: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
152: ,p_count => x_msg_count
153: ,p_data => x_msg_data);
154:
155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 158: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

154:
155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
156: ROLLBACK TO GET_RULE_LINES;
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
159: ,p_count => x_msg_count
160: ,p_data => x_msg_data);
161:
162: WHEN OTHERS THEN

Line 165: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

161:
162: WHEN OTHERS THEN
163:
164: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_GEN_RULE_PUB','GET_RULE_LINES');
165: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
166: ,p_count => x_msg_count
167: ,p_data => x_msg_data);
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
169:

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

186: l_api_version NUMBER := 1.0;
187:
188: l_api_name VARCHAR2(30) := 'UPDT_RULE_LINES';
189: l_acc_lines_in ACCT_TBL_TYPE := p_acc_lines;
190: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
191: l_acc_lines ACCT_TBL_TYPE;
192:
193:
194: BEGIN

Line 218: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

214: x_acc_lines => x_acc_lines);
215:
216:
217:
218: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
219:
220: RAISE FND_API.G_EXC_ERROR;
221:
222: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

Line 222: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

218: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
219:
220: RAISE FND_API.G_EXC_ERROR;
221:
222: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
223:
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225:
226: END IF;

Line 240: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

236: WHEN FND_API.G_EXC_ERROR THEN
237: ROLLBACK TO UPDT_RULE_LINES;
238: x_return_status := FND_API.G_RET_STS_ERROR;
239:
240: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
241: ,p_count => x_msg_count
242: ,p_data => x_msg_data);
243:
244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 247: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

243:
244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
245: ROLLBACK TO UPDT_RULE_LINES;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
248: ,p_count => x_msg_count
249: ,p_data => x_msg_data);
250:
251: WHEN OTHERS THEN

Line 254: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

250:
251: WHEN OTHERS THEN
252:
253: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_GEN_RULE_PUB','UPDT_RULE_LINES');
254: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
255: ,p_count => x_msg_count
256: ,p_data => x_msg_data);
257:
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;