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_SETUP_ACCRUALS_PUB dependencies on FND_API

Line 16: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

12:
13: IS
14: l_api_version CONSTANT NUMBER := 1.0;
15: l_api_name CONSTANT VARCHAR2(30) := 'create_accrual_rules';
16: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
17: l_agnv_rec agnv_rec_type := p_agnv_rec;
18:
19: BEGIN
20: SAVEPOINT create_accrual_rules;

Line 22: x_return_status := FND_API.G_RET_STS_SUCCESS;

18:
19: BEGIN
20: SAVEPOINT create_accrual_rules;
21:
22: x_return_status := FND_API.G_RET_STS_SUCCESS;
23:
24: -- customer pre-processing
25:
26:

Line 37: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

33: x_msg_data => x_msg_data,
34: p_agnv_rec => p_agnv_rec,
35: x_agnv_rec => x_agnv_rec);
36:
37: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
38: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
39: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
40: RAISE FND_API.G_EXC_ERROR;
41: END IF;

Line 38: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

34: p_agnv_rec => p_agnv_rec,
35: x_agnv_rec => x_agnv_rec);
36:
37: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
38: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
39: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
40: RAISE FND_API.G_EXC_ERROR;
41: END IF;
42:

Line 39: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

35: x_agnv_rec => x_agnv_rec);
36:
37: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
38: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
39: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
40: RAISE FND_API.G_EXC_ERROR;
41: END IF;
42:
43: -- customer post-processing

Line 40: RAISE FND_API.G_EXC_ERROR;

36:
37: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
38: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
39: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
40: RAISE FND_API.G_EXC_ERROR;
41: END IF;
42:
43: -- customer post-processing
44:

Line 48: WHEN FND_API.G_EXC_ERROR THEN

44:
45:
46: EXCEPTION
47:
48: WHEN FND_API.G_EXC_ERROR THEN
49: ROLLBACK TO create_accrual_rules;
50: x_return_status := FND_API.G_RET_STS_ERROR;
51:
52: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

Line 50: x_return_status := FND_API.G_RET_STS_ERROR;

46: EXCEPTION
47:
48: WHEN FND_API.G_EXC_ERROR THEN
49: ROLLBACK TO create_accrual_rules;
50: x_return_status := FND_API.G_RET_STS_ERROR;
51:
52: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
53: ,p_count => x_msg_count
54: ,p_data => x_msg_data);

Line 52: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

48: WHEN FND_API.G_EXC_ERROR THEN
49: ROLLBACK TO create_accrual_rules;
50: x_return_status := FND_API.G_RET_STS_ERROR;
51:
52: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
53: ,p_count => x_msg_count
54: ,p_data => x_msg_data);
55:
56: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 56: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

52: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
53: ,p_count => x_msg_count
54: ,p_data => x_msg_data);
55:
56: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
57: ROLLBACK TO create_accrual_rules;
58: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
59: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
60: ,p_count => x_msg_count

Line 58: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

54: ,p_data => x_msg_data);
55:
56: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
57: ROLLBACK TO create_accrual_rules;
58: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
59: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
60: ,p_count => x_msg_count
61: ,p_data => x_msg_data);
62:

Line 59: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

55:
56: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
57: ROLLBACK TO create_accrual_rules;
58: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
59: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
60: ,p_count => x_msg_count
61: ,p_data => x_msg_data);
62:
63: WHEN OTHERS THEN

Line 66: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

62:
63: WHEN OTHERS THEN
64: ROLLBACK TO create_accrual_rules;
65: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUP_ACCRUALS_PUB','create_accrual_rules');
66: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
67: ,p_count => x_msg_count
68: ,p_data => x_msg_data);
69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
70:

Line 69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

65: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUP_ACCRUALS_PUB','create_accrual_rules');
66: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
67: ,p_count => x_msg_count
68: ,p_data => x_msg_data);
69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
70:
71: END create_accrual_rules;
72:
73:

Line 86: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

82:
83: IS
84: l_api_version CONSTANT NUMBER := 1.0;
85: l_api_name CONSTANT VARCHAR2(30) := 'create_accrual_rules';
86: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
87: l_agnv_tbl agnv_tbl_type := p_agnv_tbl;
88: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
89: BEGIN
90: SAVEPOINT create_accrual_rules;

Line 88: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

84: l_api_version CONSTANT NUMBER := 1.0;
85: l_api_name CONSTANT VARCHAR2(30) := 'create_accrual_rules';
86: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
87: l_agnv_tbl agnv_tbl_type := p_agnv_tbl;
88: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
89: BEGIN
90: SAVEPOINT create_accrual_rules;
91:
92: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 92: x_return_status := FND_API.G_RET_STS_SUCCESS;

88: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
89: BEGIN
90: SAVEPOINT create_accrual_rules;
91:
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93:
94: -- customer pre-processing
95:
96:

Line 110: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

106: x_msg_data => x_msg_data,
107: p_agnv_rec => l_agnv_tbl(i),
108: x_agnv_rec => x_agnv_tbl(i));
109:
110: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
113: RAISE FND_API.G_EXC_ERROR;
114: END IF;

Line 111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

107: p_agnv_rec => l_agnv_tbl(i),
108: x_agnv_rec => x_agnv_tbl(i));
109:
110: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
113: RAISE FND_API.G_EXC_ERROR;
114: END IF;
115:

Line 112: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

108: x_agnv_rec => x_agnv_tbl(i));
109:
110: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
113: RAISE FND_API.G_EXC_ERROR;
114: END IF;
115:
116: END LOOP;

Line 113: RAISE FND_API.G_EXC_ERROR;

109:
110: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
113: RAISE FND_API.G_EXC_ERROR;
114: END IF;
115:
116: END LOOP;
117: -- return overall status

Line 126: WHEN FND_API.G_EXC_ERROR THEN

122:
123:
124: EXCEPTION
125:
126: WHEN FND_API.G_EXC_ERROR THEN
127: ROLLBACK TO create_accrual_rules;
128: x_return_status := FND_API.G_RET_STS_ERROR;
129:
130: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

Line 128: x_return_status := FND_API.G_RET_STS_ERROR;

124: EXCEPTION
125:
126: WHEN FND_API.G_EXC_ERROR THEN
127: ROLLBACK TO create_accrual_rules;
128: x_return_status := FND_API.G_RET_STS_ERROR;
129:
130: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
131: ,p_count => x_msg_count
132: ,p_data => x_msg_data);

Line 130: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

126: WHEN FND_API.G_EXC_ERROR THEN
127: ROLLBACK TO create_accrual_rules;
128: x_return_status := FND_API.G_RET_STS_ERROR;
129:
130: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
131: ,p_count => x_msg_count
132: ,p_data => x_msg_data);
133:
134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

130: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
131: ,p_count => x_msg_count
132: ,p_data => x_msg_data);
133:
134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
135: ROLLBACK TO create_accrual_rules;
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
138: ,p_count => x_msg_count

Line 136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

132: ,p_data => x_msg_data);
133:
134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
135: ROLLBACK TO create_accrual_rules;
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
138: ,p_count => x_msg_count
139: ,p_data => x_msg_data);
140:

Line 137: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

133:
134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
135: ROLLBACK TO create_accrual_rules;
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
138: ,p_count => x_msg_count
139: ,p_data => x_msg_data);
140:
141: WHEN OTHERS THEN

Line 144: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

140:
141: WHEN OTHERS THEN
142: ROLLBACK TO create_accrual_rules;
143: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUP_ACCRUALS_PUB','create_accrual_rules');
144: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
145: ,p_count => x_msg_count
146: ,p_data => x_msg_data);
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
148:

Line 147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

143: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUP_ACCRUALS_PUB','create_accrual_rules');
144: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
145: ,p_count => x_msg_count
146: ,p_data => x_msg_data);
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
148:
149: END create_accrual_rules;
150:
151:

Line 164: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

160:
161: IS
162: l_api_version CONSTANT NUMBER := 1.0;
163: l_api_name CONSTANT VARCHAR2(30) := 'update_accrual_rules';
164: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
165: l_agnv_rec agnv_rec_type := p_agnv_rec;
166:
167: BEGIN
168: SAVEPOINT update_accrual_rules;

Line 169: x_return_status := FND_API.G_RET_STS_SUCCESS;

165: l_agnv_rec agnv_rec_type := p_agnv_rec;
166:
167: BEGIN
168: SAVEPOINT update_accrual_rules;
169: x_return_status := FND_API.G_RET_STS_SUCCESS;
170: -- customer pre-processing
171:
172: -- CALL THE MAIN PROCEDURE
173: OKL_SETUP_ACCRUALS_PVT.update_accrual_rules(p_api_version => l_api_version,

Line 180: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

176: x_msg_count => x_msg_count,
177: x_msg_data => x_msg_data,
178: p_agnv_rec => p_agnv_rec,
179: x_agnv_rec => x_agnv_rec);
180: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;

Line 181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

177: x_msg_data => x_msg_data,
178: p_agnv_rec => p_agnv_rec,
179: x_agnv_rec => x_agnv_rec);
180: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185:

Line 182: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

178: p_agnv_rec => p_agnv_rec,
179: x_agnv_rec => x_agnv_rec);
180: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185:
186: -- customer post-processing

Line 183: RAISE FND_API.G_EXC_ERROR;

179: x_agnv_rec => x_agnv_rec);
180: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185:
186: -- customer post-processing
187:

Line 190: WHEN FND_API.G_EXC_ERROR THEN

186: -- customer post-processing
187:
188: EXCEPTION
189:
190: WHEN FND_API.G_EXC_ERROR THEN
191: ROLLBACK TO update_accrual_rules;
192: x_return_status := FND_API.G_RET_STS_ERROR;
193:
194: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

Line 192: x_return_status := FND_API.G_RET_STS_ERROR;

188: EXCEPTION
189:
190: WHEN FND_API.G_EXC_ERROR THEN
191: ROLLBACK TO update_accrual_rules;
192: x_return_status := FND_API.G_RET_STS_ERROR;
193:
194: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
195: ,p_count => x_msg_count
196: ,p_data => x_msg_data);

Line 194: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

190: WHEN FND_API.G_EXC_ERROR THEN
191: ROLLBACK TO update_accrual_rules;
192: x_return_status := FND_API.G_RET_STS_ERROR;
193:
194: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
195: ,p_count => x_msg_count
196: ,p_data => x_msg_data);
197:
198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

194: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
195: ,p_count => x_msg_count
196: ,p_data => x_msg_data);
197:
198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
199: ROLLBACK TO update_accrual_rules;
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
201: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
202: ,p_count => x_msg_count

Line 200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

196: ,p_data => x_msg_data);
197:
198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
199: ROLLBACK TO update_accrual_rules;
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
201: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
202: ,p_count => x_msg_count
203: ,p_data => x_msg_data);
204:

Line 201: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

197:
198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
199: ROLLBACK TO update_accrual_rules;
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
201: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
202: ,p_count => x_msg_count
203: ,p_data => x_msg_data);
204:
205: WHEN OTHERS THEN

Line 208: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

204:
205: WHEN OTHERS THEN
206: ROLLBACK TO update_accrual_rules;
207: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUP_ACCRUALS_PUB','update_accrual_rules');
208: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
209: ,p_count => x_msg_count
210: ,p_data => x_msg_data);
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212:

Line 211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

207: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUP_ACCRUALS_PUB','update_accrual_rules');
208: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
209: ,p_count => x_msg_count
210: ,p_data => x_msg_data);
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212:
213: END update_accrual_rules;
214:
215:

Line 228: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

224:
225: IS
226: l_api_version CONSTANT NUMBER := 1.0;
227: l_api_name CONSTANT VARCHAR2(30) := 'update_accrual_rules';
228: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
229: l_agnv_tbl agnv_tbl_type := p_agnv_tbl;
230: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
231: BEGIN
232: SAVEPOINT update_accrual_rules;

Line 230: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

226: l_api_version CONSTANT NUMBER := 1.0;
227: l_api_name CONSTANT VARCHAR2(30) := 'update_accrual_rules';
228: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
229: l_agnv_tbl agnv_tbl_type := p_agnv_tbl;
230: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
231: BEGIN
232: SAVEPOINT update_accrual_rules;
233: x_return_status := FND_API.G_RET_STS_SUCCESS;
234: -- customer pre-processing

Line 233: x_return_status := FND_API.G_RET_STS_SUCCESS;

229: l_agnv_tbl agnv_tbl_type := p_agnv_tbl;
230: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
231: BEGIN
232: SAVEPOINT update_accrual_rules;
233: x_return_status := FND_API.G_RET_STS_SUCCESS;
234: -- customer pre-processing
235:
236: IF l_agnv_tbl.COUNT > 0 THEN
237: FOR i IN l_agnv_tbl.FIRST..l_agnv_tbl.LAST

Line 247: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

243: x_msg_count => x_msg_count,
244: x_msg_data => x_msg_data,
245: p_agnv_rec => l_agnv_tbl(i),
246: x_agnv_rec => x_agnv_tbl(i));
247: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
250: RAISE FND_API.G_EXC_ERROR;
251: END IF;

Line 248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

244: x_msg_data => x_msg_data,
245: p_agnv_rec => l_agnv_tbl(i),
246: x_agnv_rec => x_agnv_tbl(i));
247: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
250: RAISE FND_API.G_EXC_ERROR;
251: END IF;
252: END LOOP;

Line 249: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

245: p_agnv_rec => l_agnv_tbl(i),
246: x_agnv_rec => x_agnv_tbl(i));
247: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
250: RAISE FND_API.G_EXC_ERROR;
251: END IF;
252: END LOOP;
253:

Line 250: RAISE FND_API.G_EXC_ERROR;

246: x_agnv_rec => x_agnv_tbl(i));
247: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
250: RAISE FND_API.G_EXC_ERROR;
251: END IF;
252: END LOOP;
253:
254: -- return overall status

Line 261: WHEN FND_API.G_EXC_ERROR THEN

257:
258: -- customer post-processing
259:
260: EXCEPTION
261: WHEN FND_API.G_EXC_ERROR THEN
262: ROLLBACK TO update_accrual_rules;
263: x_return_status := FND_API.G_RET_STS_ERROR;
264:
265: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

Line 263: x_return_status := FND_API.G_RET_STS_ERROR;

259:
260: EXCEPTION
261: WHEN FND_API.G_EXC_ERROR THEN
262: ROLLBACK TO update_accrual_rules;
263: x_return_status := FND_API.G_RET_STS_ERROR;
264:
265: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
266: ,p_count => x_msg_count
267: ,p_data => x_msg_data);

Line 265: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

261: WHEN FND_API.G_EXC_ERROR THEN
262: ROLLBACK TO update_accrual_rules;
263: x_return_status := FND_API.G_RET_STS_ERROR;
264:
265: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
266: ,p_count => x_msg_count
267: ,p_data => x_msg_data);
268:
269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

265: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
266: ,p_count => x_msg_count
267: ,p_data => x_msg_data);
268:
269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
270: ROLLBACK TO update_accrual_rules;
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
272: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
273: ,p_count => x_msg_count

Line 271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

267: ,p_data => x_msg_data);
268:
269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
270: ROLLBACK TO update_accrual_rules;
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
272: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
273: ,p_count => x_msg_count
274: ,p_data => x_msg_data);
275:

Line 272: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

268:
269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
270: ROLLBACK TO update_accrual_rules;
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
272: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
273: ,p_count => x_msg_count
274: ,p_data => x_msg_data);
275:
276: WHEN OTHERS THEN

Line 279: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

275:
276: WHEN OTHERS THEN
277: ROLLBACK TO update_accrual_rules;
278: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUP_ACCRUALS_PUB','update_accrual_rules');
279: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
280: ,p_count => x_msg_count
281: ,p_data => x_msg_data);
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283:

Line 282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

278: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUP_ACCRUALS_PUB','update_accrual_rules');
279: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
280: ,p_count => x_msg_count
281: ,p_data => x_msg_data);
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283:
284: END update_accrual_rules;
285:
286:

Line 298: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

294:
295: IS
296: l_api_version CONSTANT NUMBER := 1.0;
297: l_api_name CONSTANT VARCHAR2(30) := 'delete_accrual_rules';
298: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
299: l_agnv_rec agnv_rec_type := p_agnv_rec;
300:
301: BEGIN
302: SAVEPOINT delete_accrual_rules;

Line 303: x_return_status := FND_API.G_RET_STS_SUCCESS;

299: l_agnv_rec agnv_rec_type := p_agnv_rec;
300:
301: BEGIN
302: SAVEPOINT delete_accrual_rules;
303: x_return_status := FND_API.G_RET_STS_SUCCESS;
304: -- customer pre-processing
305:
306: -- CALL THE MAIN PROCEDURE
307: OKL_SETUP_ACCRUALS_PVT.delete_accrual_rules(p_api_version => l_api_version,

Line 313: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

309: x_return_status => x_return_Status,
310: x_msg_count => x_msg_count,
311: x_msg_data => x_msg_data,
312: p_agnv_rec => p_agnv_rec);
313: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
316: RAISE FND_API.G_EXC_ERROR;
317: END IF;

Line 314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

310: x_msg_count => x_msg_count,
311: x_msg_data => x_msg_data,
312: p_agnv_rec => p_agnv_rec);
313: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
316: RAISE FND_API.G_EXC_ERROR;
317: END IF;
318:

Line 315: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

311: x_msg_data => x_msg_data,
312: p_agnv_rec => p_agnv_rec);
313: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
316: RAISE FND_API.G_EXC_ERROR;
317: END IF;
318:
319: -- customer post-processing

Line 316: RAISE FND_API.G_EXC_ERROR;

312: p_agnv_rec => p_agnv_rec);
313: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
316: RAISE FND_API.G_EXC_ERROR;
317: END IF;
318:
319: -- customer post-processing
320:

Line 322: WHEN FND_API.G_EXC_ERROR THEN

318:
319: -- customer post-processing
320:
321: EXCEPTION
322: WHEN FND_API.G_EXC_ERROR THEN
323: ROLLBACK TO delete_accrual_rules;
324: x_return_status := FND_API.G_RET_STS_ERROR;
325:
326: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

Line 324: x_return_status := FND_API.G_RET_STS_ERROR;

320:
321: EXCEPTION
322: WHEN FND_API.G_EXC_ERROR THEN
323: ROLLBACK TO delete_accrual_rules;
324: x_return_status := FND_API.G_RET_STS_ERROR;
325:
326: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
327: ,p_count => x_msg_count
328: ,p_data => x_msg_data);

Line 326: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

322: WHEN FND_API.G_EXC_ERROR THEN
323: ROLLBACK TO delete_accrual_rules;
324: x_return_status := FND_API.G_RET_STS_ERROR;
325:
326: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
327: ,p_count => x_msg_count
328: ,p_data => x_msg_data);
329:
330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

326: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
327: ,p_count => x_msg_count
328: ,p_data => x_msg_data);
329:
330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
331: ROLLBACK TO delete_accrual_rules;
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
333: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
334: ,p_count => x_msg_count

Line 332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

328: ,p_data => x_msg_data);
329:
330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
331: ROLLBACK TO delete_accrual_rules;
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
333: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
334: ,p_count => x_msg_count
335: ,p_data => x_msg_data);
336:

Line 333: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

329:
330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
331: ROLLBACK TO delete_accrual_rules;
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
333: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
334: ,p_count => x_msg_count
335: ,p_data => x_msg_data);
336:
337: WHEN OTHERS THEN

Line 340: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

336:
337: WHEN OTHERS THEN
338: ROLLBACK TO delete_accrual_rules;
339: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUP_ACCRUALS_PUB','delete_accrual_rules');
340: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
341: ,p_count => x_msg_count
342: ,p_data => x_msg_data);
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344:

Line 343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

339: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUP_ACCRUALS_PUB','delete_accrual_rules');
340: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
341: ,p_count => x_msg_count
342: ,p_data => x_msg_data);
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344:
345: END delete_accrual_rules;
346:
347: PROCEDURE delete_accrual_rules(

Line 359: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

355: IS
356:
357: l_api_version CONSTANT NUMBER := 1.0;
358: l_api_name CONSTANT VARCHAR2(30) := 'delete_accrual_rules';
359: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
360: l_agnv_tbl agnv_tbl_type := p_agnv_tbl;
361: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
362: BEGIN
363: SAVEPOINT delete_accrual_rules;

Line 361: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

357: l_api_version CONSTANT NUMBER := 1.0;
358: l_api_name CONSTANT VARCHAR2(30) := 'delete_accrual_rules';
359: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
360: l_agnv_tbl agnv_tbl_type := p_agnv_tbl;
361: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
362: BEGIN
363: SAVEPOINT delete_accrual_rules;
364: x_return_status := FND_API.G_RET_STS_SUCCESS;
365: -- customer pre-processing

Line 364: x_return_status := FND_API.G_RET_STS_SUCCESS;

360: l_agnv_tbl agnv_tbl_type := p_agnv_tbl;
361: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
362: BEGIN
363: SAVEPOINT delete_accrual_rules;
364: x_return_status := FND_API.G_RET_STS_SUCCESS;
365: -- customer pre-processing
366:
367: IF l_agnv_tbl.COUNT > 0 THEN
368: FOR i IN l_agnv_tbl.FIRST..l_agnv_tbl.LAST

Line 377: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

373: x_return_status => x_return_Status,
374: x_msg_count => x_msg_count,
375: x_msg_data => x_msg_data,
376: p_agnv_rec => l_agnv_tbl(i));
377: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
379: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
380: RAISE FND_API.G_EXC_ERROR;
381: END IF;

Line 378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

374: x_msg_count => x_msg_count,
375: x_msg_data => x_msg_data,
376: p_agnv_rec => l_agnv_tbl(i));
377: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
379: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
380: RAISE FND_API.G_EXC_ERROR;
381: END IF;
382: END LOOP;

Line 379: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

375: x_msg_data => x_msg_data,
376: p_agnv_rec => l_agnv_tbl(i));
377: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
379: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
380: RAISE FND_API.G_EXC_ERROR;
381: END IF;
382: END LOOP;
383: -- return overall status

Line 380: RAISE FND_API.G_EXC_ERROR;

376: p_agnv_rec => l_agnv_tbl(i));
377: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
379: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
380: RAISE FND_API.G_EXC_ERROR;
381: END IF;
382: END LOOP;
383: -- return overall status
384: x_return_status := l_overall_status;

Line 390: WHEN FND_API.G_EXC_ERROR THEN

386:
387: -- customer post-processing
388:
389: EXCEPTION
390: WHEN FND_API.G_EXC_ERROR THEN
391: ROLLBACK TO delete_accrual_rules;
392: x_return_status := FND_API.G_RET_STS_ERROR;
393:
394: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

Line 392: x_return_status := FND_API.G_RET_STS_ERROR;

388:
389: EXCEPTION
390: WHEN FND_API.G_EXC_ERROR THEN
391: ROLLBACK TO delete_accrual_rules;
392: x_return_status := FND_API.G_RET_STS_ERROR;
393:
394: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
395: ,p_count => x_msg_count
396: ,p_data => x_msg_data);

Line 394: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

390: WHEN FND_API.G_EXC_ERROR THEN
391: ROLLBACK TO delete_accrual_rules;
392: x_return_status := FND_API.G_RET_STS_ERROR;
393:
394: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
395: ,p_count => x_msg_count
396: ,p_data => x_msg_data);
397:
398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

394: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
395: ,p_count => x_msg_count
396: ,p_data => x_msg_data);
397:
398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
399: ROLLBACK TO delete_accrual_rules;
400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
401: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
402: ,p_count => x_msg_count

Line 400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

396: ,p_data => x_msg_data);
397:
398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
399: ROLLBACK TO delete_accrual_rules;
400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
401: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
402: ,p_count => x_msg_count
403: ,p_data => x_msg_data);
404:

Line 401: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

397:
398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
399: ROLLBACK TO delete_accrual_rules;
400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
401: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
402: ,p_count => x_msg_count
403: ,p_data => x_msg_data);
404:
405: WHEN OTHERS THEN

Line 408: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE

404:
405: WHEN OTHERS THEN
406: ROLLBACK TO delete_accrual_rules;
407: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUP_ACCRUALS_PUB','delete_accrual_rules');
408: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
409: ,p_count => x_msg_count
410: ,p_data => x_msg_data);
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412:

Line 411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

407: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUP_ACCRUALS_PUB','delete_accrual_rules');
408: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
409: ,p_count => x_msg_count
410: ,p_data => x_msg_data);
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412:
413: END delete_accrual_rules;
414:
415: END OKL_SETUP_ACCRUALS_PUB;