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.CN_RULE_PUB dependencies on FND_API

Line 22: -- Default = FND_API.G_FALSE

18: -- Pre-reqs : None.
19: -- Parameters :
20: -- IN : p_api_version IN NUMBER Required
21: -- p_init_msg_list IN VARCHAR2 Optional
22: -- Default = FND_API.G_FALSE
23: -- p_commit IN VARCHAR2 Optional
24: -- Default = FND_API.G_FALSE
25: -- p_validation_level IN NUMBER Optional
26: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 24: -- Default = FND_API.G_FALSE

20: -- IN : p_api_version IN NUMBER Required
21: -- p_init_msg_list IN VARCHAR2 Optional
22: -- Default = FND_API.G_FALSE
23: -- p_commit IN VARCHAR2 Optional
24: -- Default = FND_API.G_FALSE
25: -- p_validation_level IN NUMBER Optional
26: -- Default = FND_API.G_VALID_LEVEL_FULL
27: -- p_rule_rec IN
28: -- CN_Rule_PUB.rule_rec_type

Line 26: -- Default = FND_API.G_VALID_LEVEL_FULL

22: -- Default = FND_API.G_FALSE
23: -- p_commit IN VARCHAR2 Optional
24: -- Default = FND_API.G_FALSE
25: -- p_validation_level IN NUMBER Optional
26: -- Default = FND_API.G_VALID_LEVEL_FULL
27: -- p_rule_rec IN
28: -- CN_Rule_PUB.rule_rec_type
29: --
30: -- OUT : x_return_status OUT VARCHAR2(1)

Line 47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

43: -- End of comments
44:
45: PROCEDURE Create_Rule
46: ( p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: x_return_status OUT NOCOPY VARCHAR2,
51: x_msg_count OUT NOCOPY NUMBER,

Line 48: p_commit IN VARCHAR2 := FND_API.G_FALSE,

44:
45: PROCEDURE Create_Rule
46: ( p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: x_return_status OUT NOCOPY VARCHAR2,
51: x_msg_count OUT NOCOPY NUMBER,
52: x_msg_data OUT NOCOPY VARCHAR2,

Line 49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

45: PROCEDURE Create_Rule
46: ( p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: x_return_status OUT NOCOPY VARCHAR2,
51: x_msg_count OUT NOCOPY NUMBER,
52: x_msg_data OUT NOCOPY VARCHAR2,
53: x_loading_status OUT NOCOPY VARCHAR2,

Line 95: IF NOT FND_API.Compatible_API_Call ( l_api_version,

91:
92: --
93: -- Standard call to check for call compatibility.
94: --
95: IF NOT FND_API.Compatible_API_Call ( l_api_version,
96: p_api_version,
97: l_api_name,
98: G_PKG_NAME )
99: THEN

Line 100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

96: p_api_version,
97: l_api_name,
98: G_PKG_NAME )
99: THEN
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101: END IF;
102:
103: -- Initialize message list if p_init_msg_list is set to TRUE.
104: IF FND_API.to_Boolean( p_init_msg_list )

Line 104: IF FND_API.to_Boolean( p_init_msg_list )

100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101: END IF;
102:
103: -- Initialize message list if p_init_msg_list is set to TRUE.
104: IF FND_API.to_Boolean( p_init_msg_list )
105: THEN
106: FND_MSG_PUB.initialize;
107: END IF;
108:

Line 110: x_return_status := FND_API.G_RET_STS_SUCCESS;

106: FND_MSG_PUB.initialize;
107: END IF;
108:
109: -- Initialize API return status to success
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111: x_loading_status := 'CN_INSERTED';
112:
113:
114: --

Line 140: IF x_return_status = fnd_api.g_ret_sts_error

136: x_msg_data => x_msg_data,
137: x_loading_status => x_loading_status,
138: p_rule_rec => l_rule_rec);
139:
140: IF x_return_status = fnd_api.g_ret_sts_error
141: THEN
142: RAISE fnd_api.g_exc_error;
143: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
144: THEN

Line 142: RAISE fnd_api.g_exc_error;

138: p_rule_rec => l_rule_rec);
139:
140: IF x_return_status = fnd_api.g_ret_sts_error
141: THEN
142: RAISE fnd_api.g_exc_error;
143: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
144: THEN
145: RAISE fnd_api.g_exc_unexpected_error;
146: END IF;

Line 143: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

139:
140: IF x_return_status = fnd_api.g_ret_sts_error
141: THEN
142: RAISE fnd_api.g_exc_error;
143: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
144: THEN
145: RAISE fnd_api.g_exc_unexpected_error;
146: END IF;
147: END IF;

Line 145: RAISE fnd_api.g_exc_unexpected_error;

141: THEN
142: RAISE fnd_api.g_exc_error;
143: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
144: THEN
145: RAISE fnd_api.g_exc_unexpected_error;
146: END IF;
147: END IF;
148:
149: -- vertical industry pre-processing section

Line 166: IF x_return_status = fnd_api.g_ret_sts_error

162: x_msg_data => x_msg_data,
163: x_loading_status => x_loading_status,
164: p_rule_rec => l_rule_rec);
165:
166: IF x_return_status = fnd_api.g_ret_sts_error
167: THEN
168: RAISE fnd_api.g_exc_error;
169: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
170: THEN

Line 168: RAISE fnd_api.g_exc_error;

164: p_rule_rec => l_rule_rec);
165:
166: IF x_return_status = fnd_api.g_ret_sts_error
167: THEN
168: RAISE fnd_api.g_exc_error;
169: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
170: THEN
171: RAISE fnd_api.g_exc_unexpected_error;
172: END IF;

Line 169: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

165:
166: IF x_return_status = fnd_api.g_ret_sts_error
167: THEN
168: RAISE fnd_api.g_exc_error;
169: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
170: THEN
171: RAISE fnd_api.g_exc_unexpected_error;
172: END IF;
173: END IF;

Line 171: RAISE fnd_api.g_exc_unexpected_error;

167: THEN
168: RAISE fnd_api.g_exc_error;
169: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
170: THEN
171: RAISE fnd_api.g_exc_unexpected_error;
172: END IF;
173: END IF;
174:
175:

Line 186: x_loading_status) = FND_API.G_TRUE )

182: IF (cn_api.chk_miss_null_char_para
183: ( l_rule_rec.ruleset_name,
184: cn_api.get_lkup_meaning('RULESET_NAME', 'RULESET_TYPE'),
185: x_loading_status,
186: x_loading_status) = FND_API.G_TRUE )
187: THEN
188: RAISE fnd_api.g_exc_error;
189: END IF;
190:

Line 188: RAISE fnd_api.g_exc_error;

184: cn_api.get_lkup_meaning('RULESET_NAME', 'RULESET_TYPE'),
185: x_loading_status,
186: x_loading_status) = FND_API.G_TRUE )
187: THEN
188: RAISE fnd_api.g_exc_error;
189: END IF;
190:
191: IF cn_api.chk_miss_null_date_para
192: ( l_rule_rec.end_date,

Line 195: x_loading_status) = fnd_api.g_true

191: IF cn_api.chk_miss_null_date_para
192: ( l_rule_rec.end_date,
193: cn_api.get_lkup_meaning('END_DATE', 'RULESET_TYPE'),
194: x_loading_status,
195: x_loading_status) = fnd_api.g_true
196: THEN
197: RAISE fnd_api.g_exc_error;
198: END IF;
199:

Line 197: RAISE fnd_api.g_exc_error;

193: cn_api.get_lkup_meaning('END_DATE', 'RULESET_TYPE'),
194: x_loading_status,
195: x_loading_status) = fnd_api.g_true
196: THEN
197: RAISE fnd_api.g_exc_error;
198: END IF;
199:
200: IF cn_api.chk_miss_null_date_para
201: (l_rule_rec.start_date,

Line 204: x_loading_status)= fnd_api.g_true

200: IF cn_api.chk_miss_null_date_para
201: (l_rule_rec.start_date,
202: cn_api.get_lkup_meaning('START_DATE', 'RULESET_TYPE'),
203: x_loading_status,
204: x_loading_status)= fnd_api.g_true
205: THEN
206: RAISE fnd_api.g_exc_error;
207: END IF;
208:

Line 206: RAISE fnd_api.g_exc_error;

202: cn_api.get_lkup_meaning('START_DATE', 'RULESET_TYPE'),
203: x_loading_status,
204: x_loading_status)= fnd_api.g_true
205: THEN
206: RAISE fnd_api.g_exc_error;
207: END IF;
208:
209: IF (cn_api.chk_miss_null_char_para
210: ( l_rule_rec.rule_name,

Line 213: x_loading_status) = FND_API.G_TRUE )

209: IF (cn_api.chk_miss_null_char_para
210: ( l_rule_rec.rule_name,
211: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),
212: x_loading_status,
213: x_loading_status) = FND_API.G_TRUE )
214: THEN
215: RAISE fnd_api.g_exc_error;
216: END IF;
217: IF (cn_api.chk_miss_null_char_para

Line 215: RAISE fnd_api.g_exc_error;

211: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),
212: x_loading_status,
213: x_loading_status) = FND_API.G_TRUE )
214: THEN
215: RAISE fnd_api.g_exc_error;
216: END IF;
217: IF (cn_api.chk_miss_null_char_para
218: ( l_rule_rec.rule_name,
219: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),

Line 221: x_loading_status) = FND_API.G_TRUE )

217: IF (cn_api.chk_miss_null_char_para
218: ( l_rule_rec.rule_name,
219: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),
220: x_loading_status,
221: x_loading_status) = FND_API.G_TRUE )
222: THEN
223: RAISE fnd_api.g_exc_error;
224: END IF;
225: IF (cn_api.chk_miss_null_char_para

Line 223: RAISE fnd_api.g_exc_error;

219: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),
220: x_loading_status,
221: x_loading_status) = FND_API.G_TRUE )
222: THEN
223: RAISE fnd_api.g_exc_error;
224: END IF;
225: IF (cn_api.chk_miss_null_char_para
226: ( l_rule_rec.parent_rule_name,
227: cn_api.get_lkup_meaning('PARENT_RULE_NAME', 'RULESET_TYPE'),

Line 229: x_loading_status) = FND_API.G_TRUE )

225: IF (cn_api.chk_miss_null_char_para
226: ( l_rule_rec.parent_rule_name,
227: cn_api.get_lkup_meaning('PARENT_RULE_NAME', 'RULESET_TYPE'),
228: x_loading_status,
229: x_loading_status) = FND_API.G_TRUE )
230: THEN
231: RAISE fnd_api.g_exc_error;
232: END IF;
233:

Line 231: RAISE fnd_api.g_exc_error;

227: cn_api.get_lkup_meaning('PARENT_RULE_NAME', 'RULESET_TYPE'),
228: x_loading_status,
229: x_loading_status) = FND_API.G_TRUE )
230: THEN
231: RAISE fnd_api.g_exc_error;
232: END IF;
233:
234: --Now check if the ruleset exists.
235: SELECT count(1)

Line 252: RAISE FND_API.G_EXC_ERROR;

248: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
249: fnd_msg_pub.add;
250: END IF;
251: x_loading_status := 'CN_INVALID_RULESET';
252: RAISE FND_API.G_EXC_ERROR;
253: ELSE
254: SELECT ruleset_id
255: INTO l_rule_rec_pvt.ruleset_id
256: FROM cn_rulesets

Line 282: RAISE FND_API.G_EXC_ERROR;

278: fnd_message.set_name('CN', 'CN_INVALID_REVENUE_CLASS');
279: fnd_msg_pub.add;
280: END IF;
281: x_loading_status := 'CN_INVALID_REVENUE_CLASS';
282: RAISE FND_API.G_EXC_ERROR;
283: ELSE
284: SELECT revenue_class_id
285: INTO l_rule_rec_pvt.revenue_class_id
286: FROM cn_revenue_classes

Line 309: RAISE FND_API.G_EXC_ERROR;

305: fnd_message.set_name('CN', 'CN_INVALID_EXPENSE_AC');
306: fnd_msg_pub.add;
307: END IF;
308: x_loading_status := 'CN_INVALID_EXPENSE_AC';
309: RAISE FND_API.G_EXC_ERROR;
310: ELSE
311: l_rule_rec_pvt.expense_ccid := l_rule_rec.expense_ccid;
312: END IF;
313: END IF;

Line 333: RAISE FND_API.G_EXC_ERROR;

329: fnd_message.set_name('CN', 'CN_INVALID_LIABILITY_AC');
330: fnd_msg_pub.add;
331: END IF;
332: x_loading_status := 'CN_INVALID_LIABILITY_AC';
333: RAISE FND_API.G_EXC_ERROR;
334: ELSE
335: l_rule_rec_pvt.liability_ccid := l_rule_rec.liability_ccid;
336: END IF;
337: END IF;

Line 357: RAISE FND_API.G_EXC_ERROR;

353: fnd_message.set_name('CN', 'CN_INVALID_PARENT_RULE');
354: fnd_msg_pub.add;
355: END IF;
356: x_loading_status := 'CN_INVALID_PARENT_RULE';
357: RAISE FND_API.G_EXC_ERROR;
358:
359: END IF;
360:
361:

Line 395: IF x_return_status = fnd_api.g_ret_sts_error

391: x_rule_id => l_rule_id,
392: p_rule_rec => l_rule_rec_pvt);
393:
394:
395: IF x_return_status = fnd_api.g_ret_sts_error
396: THEN
397: RAISE fnd_api.g_exc_error;
398: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
399: THEN

Line 397: RAISE fnd_api.g_exc_error;

393:
394:
395: IF x_return_status = fnd_api.g_ret_sts_error
396: THEN
397: RAISE fnd_api.g_exc_error;
398: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
399: THEN
400: RAISE fnd_api.g_exc_unexpected_error;
401: END IF;

Line 398: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

394:
395: IF x_return_status = fnd_api.g_ret_sts_error
396: THEN
397: RAISE fnd_api.g_exc_error;
398: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
399: THEN
400: RAISE fnd_api.g_exc_unexpected_error;
401: END IF;
402: END LOOP;

Line 400: RAISE fnd_api.g_exc_unexpected_error;

396: THEN
397: RAISE fnd_api.g_exc_error;
398: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
399: THEN
400: RAISE fnd_api.g_exc_unexpected_error;
401: END IF;
402: END LOOP;
403:
404: --

Line 432: IF x_return_status = fnd_api.g_ret_sts_error

428: x_msg_data => x_msg_data,
429: x_loading_status => x_loading_status,
430: p_rule_rec => l_rule_rec);
431:
432: IF x_return_status = fnd_api.g_ret_sts_error
433: THEN
434: RAISE fnd_api.g_exc_error;
435: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
436: THEN

Line 434: RAISE fnd_api.g_exc_error;

430: p_rule_rec => l_rule_rec);
431:
432: IF x_return_status = fnd_api.g_ret_sts_error
433: THEN
434: RAISE fnd_api.g_exc_error;
435: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
436: THEN
437: RAISE fnd_api.g_exc_unexpected_error;
438: END IF;

Line 435: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

431:
432: IF x_return_status = fnd_api.g_ret_sts_error
433: THEN
434: RAISE fnd_api.g_exc_error;
435: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
436: THEN
437: RAISE fnd_api.g_exc_unexpected_error;
438: END IF;
439: END IF;

Line 437: RAISE fnd_api.g_exc_unexpected_error;

433: THEN
434: RAISE fnd_api.g_exc_error;
435: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
436: THEN
437: RAISE fnd_api.g_exc_unexpected_error;
438: END IF;
439: END IF;
440:
441: -- customer post processing section

Line 458: IF x_return_status = fnd_api.g_ret_sts_error

454: x_msg_data => x_msg_data,
455: x_loading_status => x_loading_status,
456: p_rule_rec => l_rule_rec);
457:
458: IF x_return_status = fnd_api.g_ret_sts_error
459: THEN
460: RAISE fnd_api.g_exc_error;
461: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
462: THEN

Line 460: RAISE fnd_api.g_exc_error;

456: p_rule_rec => l_rule_rec);
457:
458: IF x_return_status = fnd_api.g_ret_sts_error
459: THEN
460: RAISE fnd_api.g_exc_error;
461: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
462: THEN
463: RAISE fnd_api.g_exc_unexpected_error;
464: END IF;

Line 461: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

457:
458: IF x_return_status = fnd_api.g_ret_sts_error
459: THEN
460: RAISE fnd_api.g_exc_error;
461: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
462: THEN
463: RAISE fnd_api.g_exc_unexpected_error;
464: END IF;
465: END IF;

Line 463: RAISE fnd_api.g_exc_unexpected_error;

459: THEN
460: RAISE fnd_api.g_exc_error;
461: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
462: THEN
463: RAISE fnd_api.g_exc_unexpected_error;
464: END IF;
465: END IF;
466: -- SK End of post processing hooks
467:

Line 501: IF (l_return_code = FND_API.G_RET_STS_ERROR)

497: p_action_code => 'I',
498: p_bind_data_id => l_bind_data_id,
499: x_return_code => l_return_code) ;
500:
501: IF (l_return_code = FND_API.G_RET_STS_ERROR)
502: THEN
503: RAISE FND_API.G_EXC_ERROR;
504: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
505: THEN

Line 503: RAISE FND_API.G_EXC_ERROR;

499: x_return_code => l_return_code) ;
500:
501: IF (l_return_code = FND_API.G_RET_STS_ERROR)
502: THEN
503: RAISE FND_API.G_EXC_ERROR;
504: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
505: THEN
506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
507: END IF;

Line 504: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )

500:
501: IF (l_return_code = FND_API.G_RET_STS_ERROR)
502: THEN
503: RAISE FND_API.G_EXC_ERROR;
504: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
505: THEN
506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
507: END IF;
508:

Line 506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

502: THEN
503: RAISE FND_API.G_EXC_ERROR;
504: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
505: THEN
506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
507: END IF;
508:
509:
510: /*

Line 521: IF (x_return_status = FND_API.G_RET_STS_ERROR)

517: p_oai_param => null,
518: p_oai_array => l_oai_array,
519: x_return_code => x_return_status) ;
520:
521: IF (x_return_status = FND_API.G_RET_STS_ERROR)
522: THEN
523: RAISE FND_API.G_EXC_ERROR;
524: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
525: THEN

Line 523: RAISE FND_API.G_EXC_ERROR;

519: x_return_code => x_return_status) ;
520:
521: IF (x_return_status = FND_API.G_RET_STS_ERROR)
522: THEN
523: RAISE FND_API.G_EXC_ERROR;
524: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
525: THEN
526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: END IF;

Line 524: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

520:
521: IF (x_return_status = FND_API.G_RET_STS_ERROR)
522: THEN
523: RAISE FND_API.G_EXC_ERROR;
524: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
525: THEN
526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: END IF;
528:

Line 526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

522: THEN
523: RAISE FND_API.G_EXC_ERROR;
524: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
525: THEN
526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: END IF;
528:
529: */
530:

Line 537: IF FND_API.To_Boolean( p_commit )

533: END IF;
534:
535:
536: -- Standard check of p_commit.
537: IF FND_API.To_Boolean( p_commit )
538: THEN
539: COMMIT WORK;
540: END IF;
541:

Line 548: WHEN FND_API.G_EXC_ERROR THEN

544: (p_count => x_msg_count,
545: p_data => x_msg_data
546: );
547: EXCEPTION
548: WHEN FND_API.G_EXC_ERROR THEN
549: ROLLBACK TO Create_Rule;
550: x_return_status := FND_API.G_RET_STS_ERROR ;
551: FND_MSG_PUB.Count_And_Get
552: (p_count => x_msg_count,

Line 550: x_return_status := FND_API.G_RET_STS_ERROR ;

546: );
547: EXCEPTION
548: WHEN FND_API.G_EXC_ERROR THEN
549: ROLLBACK TO Create_Rule;
550: x_return_status := FND_API.G_RET_STS_ERROR ;
551: FND_MSG_PUB.Count_And_Get
552: (p_count => x_msg_count,
553: p_data => x_msg_data,
554: p_encoded => fnd_api.g_false

Line 554: p_encoded => fnd_api.g_false

550: x_return_status := FND_API.G_RET_STS_ERROR ;
551: FND_MSG_PUB.Count_And_Get
552: (p_count => x_msg_count,
553: p_data => x_msg_data,
554: p_encoded => fnd_api.g_false
555: );
556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
557: ROLLBACK TO Create_Rule;
558: x_loading_status := 'UNEXPECTED_ERR';

Line 556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

552: (p_count => x_msg_count,
553: p_data => x_msg_data,
554: p_encoded => fnd_api.g_false
555: );
556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
557: ROLLBACK TO Create_Rule;
558: x_loading_status := 'UNEXPECTED_ERR';
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
560: FND_MSG_PUB.Count_And_Get

Line 559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

555: );
556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
557: ROLLBACK TO Create_Rule;
558: x_loading_status := 'UNEXPECTED_ERR';
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
560: FND_MSG_PUB.Count_And_Get
561: (p_count => x_msg_count,
562: p_data => x_msg_data,
563: p_encoded => fnd_api.g_false

Line 563: p_encoded => fnd_api.g_false

559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
560: FND_MSG_PUB.Count_And_Get
561: (p_count => x_msg_count,
562: p_data => x_msg_data,
563: p_encoded => fnd_api.g_false
564: );
565: WHEN OTHERS THEN
566: ROLLBACK TO Create_Rule;
567: x_loading_status := 'UNEXPECTED_ERR';

Line 568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

564: );
565: WHEN OTHERS THEN
566: ROLLBACK TO Create_Rule;
567: x_loading_status := 'UNEXPECTED_ERR';
568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
569: IF FND_MSG_PUB.Check_Msg_Level
570: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
571: THEN
572: FND_MSG_PUB.Add_Exc_Msg

Line 578: p_encoded => fnd_api.g_false

574: END IF;
575: FND_MSG_PUB.Count_And_Get
576: (p_count => x_msg_count,
577: p_data => x_msg_data,
578: p_encoded => fnd_api.g_false
579: );
580: END Create_Rule;
581:
582: -- Start of comments

Line 592: -- Default = FND_API.G_FALSE

588: -- Pre-reqs : None.
589: -- Parameters :
590: -- IN : p_api_version IN NUMBER Required
591: -- p_init_msg_list IN VARCHAR2 Optional
592: -- Default = FND_API.G_FALSE
593: -- p_commit IN VARCHAR2 Optional
594: -- Default = FND_API.G_FALSE
595: -- p_validation_level IN NUMBER Optional
596: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 594: -- Default = FND_API.G_FALSE

590: -- IN : p_api_version IN NUMBER Required
591: -- p_init_msg_list IN VARCHAR2 Optional
592: -- Default = FND_API.G_FALSE
593: -- p_commit IN VARCHAR2 Optional
594: -- Default = FND_API.G_FALSE
595: -- p_validation_level IN NUMBER Optional
596: -- Default = FND_API.G_VALID_LEVEL_FULL
597: -- p_rule_rec_type IN
598: -- CN_Rule_PUB.rule_rec_type

Line 596: -- Default = FND_API.G_VALID_LEVEL_FULL

592: -- Default = FND_API.G_FALSE
593: -- p_commit IN VARCHAR2 Optional
594: -- Default = FND_API.G_FALSE
595: -- p_validation_level IN NUMBER Optional
596: -- Default = FND_API.G_VALID_LEVEL_FULL
597: -- p_rule_rec_type IN
598: -- CN_Rule_PUB.rule_rec_type
599: --
600: -- OUT : x_return_status OUT VARCHAR2(1)

Line 618: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

614:
615:
616: PROCEDURE Update_Rule
617: ( p_api_version IN NUMBER,
618: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
619: p_commit IN VARCHAR2 := FND_API.G_FALSE,
620: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
621: x_return_status OUT NOCOPY VARCHAR2,
622: x_msg_count OUT NOCOPY NUMBER,

Line 619: p_commit IN VARCHAR2 := FND_API.G_FALSE,

615:
616: PROCEDURE Update_Rule
617: ( p_api_version IN NUMBER,
618: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
619: p_commit IN VARCHAR2 := FND_API.G_FALSE,
620: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
621: x_return_status OUT NOCOPY VARCHAR2,
622: x_msg_count OUT NOCOPY NUMBER,
623: x_msg_data OUT NOCOPY VARCHAR2,

Line 620: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

616: PROCEDURE Update_Rule
617: ( p_api_version IN NUMBER,
618: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
619: p_commit IN VARCHAR2 := FND_API.G_FALSE,
620: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
621: x_return_status OUT NOCOPY VARCHAR2,
622: x_msg_count OUT NOCOPY NUMBER,
623: x_msg_data OUT NOCOPY VARCHAR2,
624: x_loading_status OUT NOCOPY VARCHAR2,

Line 674: IF NOT FND_API.Compatible_API_Call ( l_api_version,

670:
671: -- Standard Start of API savepoint
672: SAVEPOINT Update_Rule;
673: -- Standard call to check for call compatibility.
674: IF NOT FND_API.Compatible_API_Call ( l_api_version,
675: p_api_version,
676: l_api_name,
677: G_PKG_NAME )
678: THEN

Line 679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

675: p_api_version,
676: l_api_name,
677: G_PKG_NAME )
678: THEN
679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
680: END IF;
681:
682: -- Initialize message list if p_init_msg_list is set to TRUE.
683: IF FND_API.to_Boolean( p_init_msg_list )

Line 683: IF FND_API.to_Boolean( p_init_msg_list )

679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
680: END IF;
681:
682: -- Initialize message list if p_init_msg_list is set to TRUE.
683: IF FND_API.to_Boolean( p_init_msg_list )
684: THEN
685: FND_MSG_PUB.initialize;
686: END IF;
687:

Line 689: x_return_status := FND_API.G_RET_STS_SUCCESS;

685: FND_MSG_PUB.initialize;
686: END IF;
687:
688: -- Initialize API return status to success
689: x_return_status := FND_API.G_RET_STS_SUCCESS;
690: x_loading_status := 'CN_UPDATED';
691:
692:
693: --

Line 722: IF x_return_status = fnd_api.g_ret_sts_error

718: x_loading_status => x_loading_status,
719: p_rule_rec => l_rule_rec,
720: p_old_rule_rec => l_old_rule_rec);
721:
722: IF x_return_status = fnd_api.g_ret_sts_error
723: THEN
724: RAISE fnd_api.g_exc_error;
725: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
726: THEN

Line 724: RAISE fnd_api.g_exc_error;

720: p_old_rule_rec => l_old_rule_rec);
721:
722: IF x_return_status = fnd_api.g_ret_sts_error
723: THEN
724: RAISE fnd_api.g_exc_error;
725: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
726: THEN
727: RAISE fnd_api.g_exc_unexpected_error;
728: END IF;

Line 725: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

721:
722: IF x_return_status = fnd_api.g_ret_sts_error
723: THEN
724: RAISE fnd_api.g_exc_error;
725: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
726: THEN
727: RAISE fnd_api.g_exc_unexpected_error;
728: END IF;
729: END IF;

Line 727: RAISE fnd_api.g_exc_unexpected_error;

723: THEN
724: RAISE fnd_api.g_exc_error;
725: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
726: THEN
727: RAISE fnd_api.g_exc_unexpected_error;
728: END IF;
729: END IF;
730:
731: -- vertical industry pre-processing section

Line 749: IF x_return_status = fnd_api.g_ret_sts_error

745: x_loading_status => x_loading_status,
746: p_rule_rec => l_rule_rec,
747: p_old_rule_rec => l_old_rule_rec);
748:
749: IF x_return_status = fnd_api.g_ret_sts_error
750: THEN
751: RAISE fnd_api.g_exc_error;
752: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
753: THEN

Line 751: RAISE fnd_api.g_exc_error;

747: p_old_rule_rec => l_old_rule_rec);
748:
749: IF x_return_status = fnd_api.g_ret_sts_error
750: THEN
751: RAISE fnd_api.g_exc_error;
752: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
753: THEN
754: RAISE fnd_api.g_exc_unexpected_error;
755: END IF;

Line 752: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

748:
749: IF x_return_status = fnd_api.g_ret_sts_error
750: THEN
751: RAISE fnd_api.g_exc_error;
752: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
753: THEN
754: RAISE fnd_api.g_exc_unexpected_error;
755: END IF;
756: END IF;

Line 754: RAISE fnd_api.g_exc_unexpected_error;

750: THEN
751: RAISE fnd_api.g_exc_error;
752: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
753: THEN
754: RAISE fnd_api.g_exc_unexpected_error;
755: END IF;
756: END IF;
757:
758: --

Line 768: x_loading_status) = FND_API.G_TRUE )

764: IF (cn_api.chk_miss_null_char_para
765: ( l_old_rule_rec.ruleset_name,
766: cn_api.get_lkup_meaning('RULESET_NAME', 'RULESET_TYPE'),
767: x_loading_status,
768: x_loading_status) = FND_API.G_TRUE )
769: THEN
770: RAISE fnd_api.g_exc_error;
771: END IF;
772: IF (cn_api.chk_miss_null_date_para

Line 770: RAISE fnd_api.g_exc_error;

766: cn_api.get_lkup_meaning('RULESET_NAME', 'RULESET_TYPE'),
767: x_loading_status,
768: x_loading_status) = FND_API.G_TRUE )
769: THEN
770: RAISE fnd_api.g_exc_error;
771: END IF;
772: IF (cn_api.chk_miss_null_date_para
773: ( l_old_rule_rec.start_date,
774: cn_api.get_lkup_meaning('START_DATE', 'RULESET_TYPE'),

Line 776: x_loading_status) = FND_API.G_TRUE )

772: IF (cn_api.chk_miss_null_date_para
773: ( l_old_rule_rec.start_date,
774: cn_api.get_lkup_meaning('START_DATE', 'RULESET_TYPE'),
775: x_loading_status,
776: x_loading_status) = FND_API.G_TRUE )
777: THEN
778: RAISE fnd_api.g_exc_error;
779: END IF;
780: IF (cn_api.chk_miss_null_date_para

Line 778: RAISE fnd_api.g_exc_error;

774: cn_api.get_lkup_meaning('START_DATE', 'RULESET_TYPE'),
775: x_loading_status,
776: x_loading_status) = FND_API.G_TRUE )
777: THEN
778: RAISE fnd_api.g_exc_error;
779: END IF;
780: IF (cn_api.chk_miss_null_date_para
781: ( l_old_rule_rec.end_date,
782: cn_api.get_lkup_meaning('END_DATE', 'RULESET_TYPE'),

Line 784: x_loading_status) = FND_API.G_TRUE )

780: IF (cn_api.chk_miss_null_date_para
781: ( l_old_rule_rec.end_date,
782: cn_api.get_lkup_meaning('END_DATE', 'RULESET_TYPE'),
783: x_loading_status,
784: x_loading_status) = FND_API.G_TRUE )
785: THEN
786: RAISE fnd_api.g_exc_error;
787: END IF;
788: IF (cn_api.chk_miss_null_char_para

Line 786: RAISE fnd_api.g_exc_error;

782: cn_api.get_lkup_meaning('END_DATE', 'RULESET_TYPE'),
783: x_loading_status,
784: x_loading_status) = FND_API.G_TRUE )
785: THEN
786: RAISE fnd_api.g_exc_error;
787: END IF;
788: IF (cn_api.chk_miss_null_char_para
789: ( l_old_rule_rec.rule_name,
790: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),

Line 792: x_loading_status) = FND_API.G_TRUE )

788: IF (cn_api.chk_miss_null_char_para
789: ( l_old_rule_rec.rule_name,
790: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),
791: x_loading_status,
792: x_loading_status) = FND_API.G_TRUE )
793: THEN
794: RAISE fnd_api.g_exc_error;
795: END IF;
796: IF (cn_api.chk_miss_null_char_para

Line 794: RAISE fnd_api.g_exc_error;

790: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),
791: x_loading_status,
792: x_loading_status) = FND_API.G_TRUE )
793: THEN
794: RAISE fnd_api.g_exc_error;
795: END IF;
796: IF (cn_api.chk_miss_null_char_para
797: ( l_old_rule_rec.parent_rule_name,
798: cn_api.get_lkup_meaning('PARENT_RULE_NAME', 'RULESET_TYPE'),

Line 800: x_loading_status) = FND_API.G_TRUE )

796: IF (cn_api.chk_miss_null_char_para
797: ( l_old_rule_rec.parent_rule_name,
798: cn_api.get_lkup_meaning('PARENT_RULE_NAME', 'RULESET_TYPE'),
799: x_loading_status,
800: x_loading_status) = FND_API.G_TRUE )
801: THEN
802: RAISE fnd_api.g_exc_error;
803: END IF;
804: IF (cn_api.chk_miss_null_char_para

Line 802: RAISE fnd_api.g_exc_error;

798: cn_api.get_lkup_meaning('PARENT_RULE_NAME', 'RULESET_TYPE'),
799: x_loading_status,
800: x_loading_status) = FND_API.G_TRUE )
801: THEN
802: RAISE fnd_api.g_exc_error;
803: END IF;
804: IF (cn_api.chk_miss_null_char_para
805: ( l_rule_rec.ruleset_name,
806: cn_api.get_lkup_meaning('RULESET_NAME', 'RULESET_TYPE'),

Line 808: x_loading_status) = FND_API.G_TRUE )

804: IF (cn_api.chk_miss_null_char_para
805: ( l_rule_rec.ruleset_name,
806: cn_api.get_lkup_meaning('RULESET_NAME', 'RULESET_TYPE'),
807: x_loading_status,
808: x_loading_status) = FND_API.G_TRUE )
809: THEN
810: RAISE fnd_api.g_exc_error;
811: END IF;
812: IF (cn_api.chk_miss_null_date_para

Line 810: RAISE fnd_api.g_exc_error;

806: cn_api.get_lkup_meaning('RULESET_NAME', 'RULESET_TYPE'),
807: x_loading_status,
808: x_loading_status) = FND_API.G_TRUE )
809: THEN
810: RAISE fnd_api.g_exc_error;
811: END IF;
812: IF (cn_api.chk_miss_null_date_para
813: ( l_old_rule_rec.start_date,
814: cn_api.get_lkup_meaning('START_DATE', 'RULESET_TYPE'),

Line 816: x_loading_status) = FND_API.G_TRUE )

812: IF (cn_api.chk_miss_null_date_para
813: ( l_old_rule_rec.start_date,
814: cn_api.get_lkup_meaning('START_DATE', 'RULESET_TYPE'),
815: x_loading_status,
816: x_loading_status) = FND_API.G_TRUE )
817: THEN
818: RAISE fnd_api.g_exc_error;
819: END IF;
820: IF (cn_api.chk_miss_null_date_para

Line 818: RAISE fnd_api.g_exc_error;

814: cn_api.get_lkup_meaning('START_DATE', 'RULESET_TYPE'),
815: x_loading_status,
816: x_loading_status) = FND_API.G_TRUE )
817: THEN
818: RAISE fnd_api.g_exc_error;
819: END IF;
820: IF (cn_api.chk_miss_null_date_para
821: ( l_old_rule_rec.end_date,
822: cn_api.get_lkup_meaning('END_DATE', 'RULESET_TYPE'),

Line 824: x_loading_status) = FND_API.G_TRUE )

820: IF (cn_api.chk_miss_null_date_para
821: ( l_old_rule_rec.end_date,
822: cn_api.get_lkup_meaning('END_DATE', 'RULESET_TYPE'),
823: x_loading_status,
824: x_loading_status) = FND_API.G_TRUE )
825: THEN
826: RAISE fnd_api.g_exc_error;
827: END IF;
828: IF (cn_api.chk_miss_null_char_para

Line 826: RAISE fnd_api.g_exc_error;

822: cn_api.get_lkup_meaning('END_DATE', 'RULESET_TYPE'),
823: x_loading_status,
824: x_loading_status) = FND_API.G_TRUE )
825: THEN
826: RAISE fnd_api.g_exc_error;
827: END IF;
828: IF (cn_api.chk_miss_null_char_para
829: ( l_rule_rec.rule_name,
830: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),

Line 832: x_loading_status) = FND_API.G_TRUE )

828: IF (cn_api.chk_miss_null_char_para
829: ( l_rule_rec.rule_name,
830: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),
831: x_loading_status,
832: x_loading_status) = FND_API.G_TRUE )
833: THEN
834: RAISE fnd_api.g_exc_error;
835: END IF;
836: IF (cn_api.chk_miss_null_char_para

Line 834: RAISE fnd_api.g_exc_error;

830: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),
831: x_loading_status,
832: x_loading_status) = FND_API.G_TRUE )
833: THEN
834: RAISE fnd_api.g_exc_error;
835: END IF;
836: IF (cn_api.chk_miss_null_char_para
837: ( l_rule_rec.parent_rule_name,
838: cn_api.get_lkup_meaning('PARENT_RULE_NAME', 'RULESET_TYPE'),

Line 840: x_loading_status) = FND_API.G_TRUE )

836: IF (cn_api.chk_miss_null_char_para
837: ( l_rule_rec.parent_rule_name,
838: cn_api.get_lkup_meaning('PARENT_RULE_NAME', 'RULESET_TYPE'),
839: x_loading_status,
840: x_loading_status) = FND_API.G_TRUE )
841: THEN
842: RAISE fnd_api.g_exc_error;
843: END IF;
844:

Line 842: RAISE fnd_api.g_exc_error;

838: cn_api.get_lkup_meaning('PARENT_RULE_NAME', 'RULESET_TYPE'),
839: x_loading_status,
840: x_loading_status) = FND_API.G_TRUE )
841: THEN
842: RAISE fnd_api.g_exc_error;
843: END IF;
844:
845: --Check if the old ruleset exists.
846: SELECT count(1)

Line 861: RAISE FND_API.G_EXC_ERROR;

857: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
858: fnd_msg_pub.add;
859: END IF;
860: x_loading_status := 'CN_INVALID_RULESET';
861: RAISE FND_API.G_EXC_ERROR;
862: ELSE
863: SELECT ruleset_id,org_id
864: INTO l_old_rule_rec_pvt.ruleset_id,l_old_rule_rec_pvt.org_id
865: FROM cn_rulesets

Line 887: RAISE FND_API.G_EXC_ERROR;

883: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
884: fnd_msg_pub.add;
885: END IF;
886: x_loading_status := 'CN_INVALID_RULESET';
887: RAISE FND_API.G_EXC_ERROR;
888: ELSE
889: SELECT ruleset_id,org_id
890: INTO l_rule_rec_pvt.ruleset_id,l_rule_rec_pvt.org_id
891: FROM cn_rulesets

Line 914: RAISE FND_API.G_EXC_ERROR;

910: fnd_message.set_name('CN', 'CN_INVALID_RULE');
911: fnd_msg_pub.add;
912: END IF;
913: x_loading_status := 'CN_INVALID_RULE';
914: RAISE FND_API.G_EXC_ERROR;
915: END IF;
916:
917: --Validate new parent rule
918: SELECT count(1)

Line 934: RAISE FND_API.G_EXC_ERROR;

930: fnd_message.set_name('CN', 'CN_INVALID_RULE');
931: fnd_msg_pub.add;
932: END IF;
933: x_loading_status := 'CN_INVALID_RULE';
934: RAISE FND_API.G_EXC_ERROR;
935: END IF;
936:
937: IF l_rule_rec.revenue_class_name IS NOT NULL
938: THEN

Line 955: RAISE FND_API.G_EXC_ERROR;

951: fnd_message.set_name('CN', 'CN_INVALID_REVENUE_CLASS');
952: fnd_msg_pub.add;
953: END IF;
954: x_loading_status := 'CN_INVALID_REVENUE_CLASS';
955: RAISE FND_API.G_EXC_ERROR;
956: ELSE
957: SELECT revenue_class_id
958: INTO l_rule_rec_pvt.revenue_class_id
959: FROM cn_revenue_classes

Line 981: RAISE FND_API.G_EXC_ERROR;

977: fnd_message.set_name('CN', 'CN_INVALID_EXPENSE_CCID');
978: fnd_msg_pub.add;
979: END IF;
980: x_loading_status := 'CN_INVALID_EXPENSE_CCID';
981: RAISE FND_API.G_EXC_ERROR;
982: ELSE
983: l_rule_rec_pvt.expense_ccid := l_rule_rec.expense_ccid;
984: END IF;
985: END IF;

Line 1004: RAISE FND_API.G_EXC_ERROR;

1000: fnd_message.set_name('CN', 'CN_INVALID_LIABILITY_CCID');
1001: fnd_msg_pub.add;
1002: END IF;
1003: x_loading_status := 'CN_INVALID_LIABILITY_CCID';
1004: RAISE FND_API.G_EXC_ERROR;
1005: ELSE
1006: l_rule_rec_pvt.liability_ccid := l_rule_rec.liability_ccid;
1007: END IF;
1008: END IF;

Line 1036: IF x_return_status = fnd_api.g_ret_sts_error

1032: x_msg_data => x_msg_data,
1033: x_loading_status => x_loading_status,
1034: p_old_rule_rec => l_old_rule_rec_pvt,
1035: p_rule_rec => l_rule_rec_pvt);
1036: IF x_return_status = fnd_api.g_ret_sts_error
1037: THEN
1038: RAISE fnd_api.g_exc_error;
1039: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1040: THEN

Line 1038: RAISE fnd_api.g_exc_error;

1034: p_old_rule_rec => l_old_rule_rec_pvt,
1035: p_rule_rec => l_rule_rec_pvt);
1036: IF x_return_status = fnd_api.g_ret_sts_error
1037: THEN
1038: RAISE fnd_api.g_exc_error;
1039: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1040: THEN
1041: RAISE fnd_api.g_exc_unexpected_error;
1042: END IF;

Line 1039: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

1035: p_rule_rec => l_rule_rec_pvt);
1036: IF x_return_status = fnd_api.g_ret_sts_error
1037: THEN
1038: RAISE fnd_api.g_exc_error;
1039: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1040: THEN
1041: RAISE fnd_api.g_exc_unexpected_error;
1042: END IF;
1043: END LOOP;

Line 1041: RAISE fnd_api.g_exc_unexpected_error;

1037: THEN
1038: RAISE fnd_api.g_exc_error;
1039: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1040: THEN
1041: RAISE fnd_api.g_exc_unexpected_error;
1042: END IF;
1043: END LOOP;
1044: ELSE
1045: l_rule_rec_pvt.parent_rule_id := i.parent_rule_id;

Line 1057: IF x_return_status = fnd_api.g_ret_sts_error

1053: x_msg_data => x_msg_data,
1054: x_loading_status => x_loading_status,
1055: p_old_rule_rec => l_old_rule_rec_pvt,
1056: p_rule_rec => l_rule_rec_pvt);
1057: IF x_return_status = fnd_api.g_ret_sts_error
1058: THEN
1059: RAISE fnd_api.g_exc_error;
1060: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1061: THEN

Line 1059: RAISE fnd_api.g_exc_error;

1055: p_old_rule_rec => l_old_rule_rec_pvt,
1056: p_rule_rec => l_rule_rec_pvt);
1057: IF x_return_status = fnd_api.g_ret_sts_error
1058: THEN
1059: RAISE fnd_api.g_exc_error;
1060: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1061: THEN
1062: RAISE fnd_api.g_exc_unexpected_error;
1063: END IF;

Line 1060: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

1056: p_rule_rec => l_rule_rec_pvt);
1057: IF x_return_status = fnd_api.g_ret_sts_error
1058: THEN
1059: RAISE fnd_api.g_exc_error;
1060: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1061: THEN
1062: RAISE fnd_api.g_exc_unexpected_error;
1063: END IF;
1064: END IF;

Line 1062: RAISE fnd_api.g_exc_unexpected_error;

1058: THEN
1059: RAISE fnd_api.g_exc_error;
1060: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1061: THEN
1062: RAISE fnd_api.g_exc_unexpected_error;
1063: END IF;
1064: END IF;
1065:
1066: END LOOP;

Line 1098: IF x_return_status = fnd_api.g_ret_sts_error

1094: x_loading_status => x_loading_status,
1095: p_rule_rec => l_rule_rec,
1096: p_old_rule_rec => l_old_rule_rec);
1097:
1098: IF x_return_status = fnd_api.g_ret_sts_error
1099: THEN
1100: RAISE fnd_api.g_exc_error;
1101: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1102: THEN

Line 1100: RAISE fnd_api.g_exc_error;

1096: p_old_rule_rec => l_old_rule_rec);
1097:
1098: IF x_return_status = fnd_api.g_ret_sts_error
1099: THEN
1100: RAISE fnd_api.g_exc_error;
1101: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1102: THEN
1103: RAISE fnd_api.g_exc_unexpected_error;
1104: END IF;

Line 1101: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

1097:
1098: IF x_return_status = fnd_api.g_ret_sts_error
1099: THEN
1100: RAISE fnd_api.g_exc_error;
1101: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1102: THEN
1103: RAISE fnd_api.g_exc_unexpected_error;
1104: END IF;
1105: END IF;

Line 1103: RAISE fnd_api.g_exc_unexpected_error;

1099: THEN
1100: RAISE fnd_api.g_exc_error;
1101: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1102: THEN
1103: RAISE fnd_api.g_exc_unexpected_error;
1104: END IF;
1105: END IF;
1106:
1107: -- customer post processing section

Line 1125: IF x_return_status = fnd_api.g_ret_sts_error

1121: x_loading_status => x_loading_status,
1122: p_rule_rec => l_rule_rec,
1123: p_old_rule_rec => l_old_rule_rec);
1124:
1125: IF x_return_status = fnd_api.g_ret_sts_error
1126: THEN
1127: RAISE fnd_api.g_exc_error;
1128: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1129: THEN

Line 1127: RAISE fnd_api.g_exc_error;

1123: p_old_rule_rec => l_old_rule_rec);
1124:
1125: IF x_return_status = fnd_api.g_ret_sts_error
1126: THEN
1127: RAISE fnd_api.g_exc_error;
1128: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1129: THEN
1130: RAISE fnd_api.g_exc_unexpected_error;
1131: END IF;

Line 1128: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

1124:
1125: IF x_return_status = fnd_api.g_ret_sts_error
1126: THEN
1127: RAISE fnd_api.g_exc_error;
1128: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1129: THEN
1130: RAISE fnd_api.g_exc_unexpected_error;
1131: END IF;
1132: END IF;

Line 1130: RAISE fnd_api.g_exc_unexpected_error;

1126: THEN
1127: RAISE fnd_api.g_exc_error;
1128: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1129: THEN
1130: RAISE fnd_api.g_exc_unexpected_error;
1131: END IF;
1132: END IF;
1133: -- SK End of post processing hooks
1134:

Line 1167: IF (l_return_code = FND_API.G_RET_STS_ERROR)

1163: p_action_code => 'U',
1164: p_bind_data_id => l_bind_data_id,
1165: x_return_code => l_return_code) ;
1166:
1167: IF (l_return_code = FND_API.G_RET_STS_ERROR)
1168: THEN
1169: RAISE FND_API.G_EXC_ERROR;
1170: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
1171: THEN

Line 1169: RAISE FND_API.G_EXC_ERROR;

1165: x_return_code => l_return_code) ;
1166:
1167: IF (l_return_code = FND_API.G_RET_STS_ERROR)
1168: THEN
1169: RAISE FND_API.G_EXC_ERROR;
1170: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
1171: THEN
1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1173: END IF;

Line 1170: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )

1166:
1167: IF (l_return_code = FND_API.G_RET_STS_ERROR)
1168: THEN
1169: RAISE FND_API.G_EXC_ERROR;
1170: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
1171: THEN
1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1173: END IF;
1174:

Line 1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1168: THEN
1169: RAISE FND_API.G_EXC_ERROR;
1170: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
1171: THEN
1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1173: END IF;
1174:
1175:
1176: /*

Line 1187: IF (x_return_status = FND_API.G_RET_STS_ERROR)

1183: p_oai_param => null,
1184: p_oai_array => l_oai_array,
1185: x_return_code => x_return_status) ;
1186:
1187: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1188: THEN
1189: RAISE FND_API.G_EXC_ERROR;
1190: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1191: THEN

Line 1189: RAISE FND_API.G_EXC_ERROR;

1185: x_return_code => x_return_status) ;
1186:
1187: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1188: THEN
1189: RAISE FND_API.G_EXC_ERROR;
1190: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1191: THEN
1192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1193: END IF;

Line 1190: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1186:
1187: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1188: THEN
1189: RAISE FND_API.G_EXC_ERROR;
1190: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1191: THEN
1192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1193: END IF;
1194: */

Line 1192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1188: THEN
1189: RAISE FND_API.G_EXC_ERROR;
1190: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1191: THEN
1192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1193: END IF;
1194: */
1195:
1196: END IF;

Line 1202: IF FND_API.To_Boolean( p_commit )

1198:
1199:
1200:
1201: -- Standard check of p_commit.
1202: IF FND_API.To_Boolean( p_commit )
1203: THEN
1204: COMMIT WORK;
1205: END IF;
1206:

Line 1213: WHEN FND_API.G_EXC_ERROR THEN

1209: (p_count => x_msg_count,
1210: p_data => x_msg_data
1211: );
1212: EXCEPTION
1213: WHEN FND_API.G_EXC_ERROR THEN
1214: ROLLBACK TO Update_Rule;
1215: x_return_status := FND_API.G_RET_STS_ERROR ;
1216: FND_MSG_PUB.Count_And_Get
1217: (p_count => x_msg_count,

Line 1215: x_return_status := FND_API.G_RET_STS_ERROR ;

1211: );
1212: EXCEPTION
1213: WHEN FND_API.G_EXC_ERROR THEN
1214: ROLLBACK TO Update_Rule;
1215: x_return_status := FND_API.G_RET_STS_ERROR ;
1216: FND_MSG_PUB.Count_And_Get
1217: (p_count => x_msg_count,
1218: p_data => x_msg_data,
1219: p_encoded => fnd_api.g_false

Line 1219: p_encoded => fnd_api.g_false

1215: x_return_status := FND_API.G_RET_STS_ERROR ;
1216: FND_MSG_PUB.Count_And_Get
1217: (p_count => x_msg_count,
1218: p_data => x_msg_data,
1219: p_encoded => fnd_api.g_false
1220: );
1221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1222: ROLLBACK TO Update_Rule;
1223: x_loading_status := 'UNEXPECTED_ERR';

Line 1221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1217: (p_count => x_msg_count,
1218: p_data => x_msg_data,
1219: p_encoded => fnd_api.g_false
1220: );
1221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1222: ROLLBACK TO Update_Rule;
1223: x_loading_status := 'UNEXPECTED_ERR';
1224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1225: FND_MSG_PUB.Count_And_Get

Line 1224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1220: );
1221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1222: ROLLBACK TO Update_Rule;
1223: x_loading_status := 'UNEXPECTED_ERR';
1224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1225: FND_MSG_PUB.Count_And_Get
1226: (p_count => x_msg_count,
1227: p_data => x_msg_data,
1228: p_encoded => fnd_api.g_false

Line 1228: p_encoded => fnd_api.g_false

1224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1225: FND_MSG_PUB.Count_And_Get
1226: (p_count => x_msg_count,
1227: p_data => x_msg_data,
1228: p_encoded => fnd_api.g_false
1229: );
1230: WHEN OTHERS THEN
1231: ROLLBACK TO Update_Rule;
1232: x_loading_status := 'UNEXPECTED_ERR';

Line 1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1229: );
1230: WHEN OTHERS THEN
1231: ROLLBACK TO Update_Rule;
1232: x_loading_status := 'UNEXPECTED_ERR';
1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1234: IF FND_MSG_PUB.Check_Msg_Level
1235: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1236: THEN
1237: FND_MSG_PUB.Add_Exc_Msg

Line 1243: p_encoded => fnd_api.g_false

1239: END IF;
1240: FND_MSG_PUB.Count_And_Get
1241: (p_count => x_msg_count,
1242: p_data => x_msg_data,
1243: p_encoded => fnd_api.g_false
1244: );
1245:
1246: END;
1247:

Line 1256: -- Default = FND_API.G_FALSE

1252: -- Pre-reqs : None.
1253: -- Parameters :
1254: -- IN : p_api_version IN NUMBER Required
1255: -- p_init_msg_list IN VARCHAR2 Optional
1256: -- Default = FND_API.G_FALSE
1257: -- p_commit IN VARCHAR2 Optional
1258: -- Default = FND_API.G_FALSE
1259: -- p_validation_level IN NUMBER Optional
1260: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1258: -- Default = FND_API.G_FALSE

1254: -- IN : p_api_version IN NUMBER Required
1255: -- p_init_msg_list IN VARCHAR2 Optional
1256: -- Default = FND_API.G_FALSE
1257: -- p_commit IN VARCHAR2 Optional
1258: -- Default = FND_API.G_FALSE
1259: -- p_validation_level IN NUMBER Optional
1260: -- Default = FND_API.G_VALID_LEVEL_FULL
1261: -- p_rule_id IN NUMBER
1262: --

Line 1260: -- Default = FND_API.G_VALID_LEVEL_FULL

1256: -- Default = FND_API.G_FALSE
1257: -- p_commit IN VARCHAR2 Optional
1258: -- Default = FND_API.G_FALSE
1259: -- p_validation_level IN NUMBER Optional
1260: -- Default = FND_API.G_VALID_LEVEL_FULL
1261: -- p_rule_id IN NUMBER
1262: --
1263: -- OUT : x_return_status OUT VARCHAR2(1)
1264: -- x_msg_count OUT NUMBER

Line 1283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1279:
1280:
1281: PROCEDURE Delete_Rule
1282: ( p_api_version IN NUMBER,
1283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1286: x_return_status OUT NOCOPY VARCHAR2,
1287: x_msg_count OUT NOCOPY NUMBER,

Line 1284: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1280:
1281: PROCEDURE Delete_Rule
1282: ( p_api_version IN NUMBER,
1283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1286: x_return_status OUT NOCOPY VARCHAR2,
1287: x_msg_count OUT NOCOPY NUMBER,
1288: x_msg_data OUT NOCOPY VARCHAR2,

Line 1285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1281: PROCEDURE Delete_Rule
1282: ( p_api_version IN NUMBER,
1283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1286: x_return_status OUT NOCOPY VARCHAR2,
1287: x_msg_count OUT NOCOPY NUMBER,
1288: x_msg_data OUT NOCOPY VARCHAR2,
1289: x_loading_status OUT NOCOPY VARCHAR2,

Line 1328: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1324:
1325: -- Standard Start of API savepoint
1326: SAVEPOINT Delete_Rule;
1327: -- Standard call to check for call compatibility.
1328: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1329: p_api_version,
1330: l_api_name,
1331: G_PKG_NAME )
1332: THEN

Line 1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1329: p_api_version,
1330: l_api_name,
1331: G_PKG_NAME )
1332: THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: END IF;
1335:
1336: -- Initialize message list if p_init_msg_list is set to TRUE.
1337: IF FND_API.to_Boolean( p_init_msg_list )

Line 1337: IF FND_API.to_Boolean( p_init_msg_list )

1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: END IF;
1335:
1336: -- Initialize message list if p_init_msg_list is set to TRUE.
1337: IF FND_API.to_Boolean( p_init_msg_list )
1338: THEN
1339: FND_MSG_PUB.initialize;
1340: END IF;
1341:

Line 1343: x_return_status := FND_API.G_RET_STS_SUCCESS;

1339: FND_MSG_PUB.initialize;
1340: END IF;
1341:
1342: -- Initialize API return status to success
1343: x_return_status := FND_API.G_RET_STS_SUCCESS;
1344: x_loading_status := 'CN_DELETED';
1345:
1346:
1347: --

Line 1379: IF x_return_status = fnd_api.g_ret_sts_error

1375: p_ruleset_name => l_ruleset_name,
1376: p_ruleset_start_date => l_ruleset_start_date,
1377: p_ruleset_end_date => l_ruleset_end_date);
1378:
1379: IF x_return_status = fnd_api.g_ret_sts_error
1380: THEN
1381: RAISE fnd_api.g_exc_error;
1382: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1383: THEN

Line 1381: RAISE fnd_api.g_exc_error;

1377: p_ruleset_end_date => l_ruleset_end_date);
1378:
1379: IF x_return_status = fnd_api.g_ret_sts_error
1380: THEN
1381: RAISE fnd_api.g_exc_error;
1382: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1383: THEN
1384: RAISE fnd_api.g_exc_unexpected_error;
1385: END IF;

Line 1382: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

1378:
1379: IF x_return_status = fnd_api.g_ret_sts_error
1380: THEN
1381: RAISE fnd_api.g_exc_error;
1382: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1383: THEN
1384: RAISE fnd_api.g_exc_unexpected_error;
1385: END IF;
1386: END IF;

Line 1384: RAISE fnd_api.g_exc_unexpected_error;

1380: THEN
1381: RAISE fnd_api.g_exc_error;
1382: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1383: THEN
1384: RAISE fnd_api.g_exc_unexpected_error;
1385: END IF;
1386: END IF;
1387:
1388: -- vertical industry pre-processing section

Line 1408: IF x_return_status = fnd_api.g_ret_sts_error

1404: p_ruleset_name => l_ruleset_name,
1405: p_ruleset_start_date => l_ruleset_start_date,
1406: p_ruleset_end_date => l_ruleset_end_date);
1407:
1408: IF x_return_status = fnd_api.g_ret_sts_error
1409: THEN
1410: RAISE fnd_api.g_exc_error;
1411: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1412: THEN

Line 1410: RAISE fnd_api.g_exc_error;

1406: p_ruleset_end_date => l_ruleset_end_date);
1407:
1408: IF x_return_status = fnd_api.g_ret_sts_error
1409: THEN
1410: RAISE fnd_api.g_exc_error;
1411: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1412: THEN
1413: RAISE fnd_api.g_exc_unexpected_error;
1414: END IF;

Line 1411: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

1407:
1408: IF x_return_status = fnd_api.g_ret_sts_error
1409: THEN
1410: RAISE fnd_api.g_exc_error;
1411: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1412: THEN
1413: RAISE fnd_api.g_exc_unexpected_error;
1414: END IF;
1415: END IF;

Line 1413: RAISE fnd_api.g_exc_unexpected_error;

1409: THEN
1410: RAISE fnd_api.g_exc_error;
1411: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1412: THEN
1413: RAISE fnd_api.g_exc_unexpected_error;
1414: END IF;
1415: END IF;
1416:
1417:

Line 1438: RAISE FND_API.G_EXC_ERROR;

1434: fnd_msg_pub.add;
1435: END IF;
1436:
1437: x_loading_status := 'CN_INVALID_RULESET';
1438: RAISE FND_API.G_EXC_ERROR;
1439: ELSE
1440: SELECT ruleset_id,org_id
1441: INTO l_ruleset_id,l_org_id
1442: FROM cn_rulesets

Line 1463: IF x_return_status = fnd_api.g_ret_sts_error

1459: x_loading_status => x_loading_status,
1460: p_ruleset_id => l_ruleset_id,
1461: p_rule_id => i.rule_id,
1462: p_org_id => l_org_id);
1463: IF x_return_status = fnd_api.g_ret_sts_error
1464: THEN
1465: RAISE fnd_api.g_exc_error;
1466: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1467: THEN

Line 1465: RAISE fnd_api.g_exc_error;

1461: p_rule_id => i.rule_id,
1462: p_org_id => l_org_id);
1463: IF x_return_status = fnd_api.g_ret_sts_error
1464: THEN
1465: RAISE fnd_api.g_exc_error;
1466: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1467: THEN
1468: RAISE fnd_api.g_exc_unexpected_error;
1469: END IF;

Line 1466: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

1462: p_org_id => l_org_id);
1463: IF x_return_status = fnd_api.g_ret_sts_error
1464: THEN
1465: RAISE fnd_api.g_exc_error;
1466: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1467: THEN
1468: RAISE fnd_api.g_exc_unexpected_error;
1469: END IF;
1470: END LOOP;

Line 1468: RAISE fnd_api.g_exc_unexpected_error;

1464: THEN
1465: RAISE fnd_api.g_exc_error;
1466: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1467: THEN
1468: RAISE fnd_api.g_exc_unexpected_error;
1469: END IF;
1470: END LOOP;
1471:
1472: --

Line 1503: IF x_return_status = fnd_api.g_ret_sts_error

1499: p_ruleset_name => l_ruleset_name,
1500: p_ruleset_start_date => l_ruleset_start_date,
1501: p_ruleset_end_date => l_ruleset_end_date);
1502:
1503: IF x_return_status = fnd_api.g_ret_sts_error
1504: THEN
1505: RAISE fnd_api.g_exc_error;
1506: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1507: THEN

Line 1505: RAISE fnd_api.g_exc_error;

1501: p_ruleset_end_date => l_ruleset_end_date);
1502:
1503: IF x_return_status = fnd_api.g_ret_sts_error
1504: THEN
1505: RAISE fnd_api.g_exc_error;
1506: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1507: THEN
1508: RAISE fnd_api.g_exc_unexpected_error;
1509: END IF;

Line 1506: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

1502:
1503: IF x_return_status = fnd_api.g_ret_sts_error
1504: THEN
1505: RAISE fnd_api.g_exc_error;
1506: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1507: THEN
1508: RAISE fnd_api.g_exc_unexpected_error;
1509: END IF;
1510: END IF;

Line 1508: RAISE fnd_api.g_exc_unexpected_error;

1504: THEN
1505: RAISE fnd_api.g_exc_error;
1506: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1507: THEN
1508: RAISE fnd_api.g_exc_unexpected_error;
1509: END IF;
1510: END IF;
1511:
1512: -- customer post processing section

Line 1532: IF x_return_status = fnd_api.g_ret_sts_error

1528: p_ruleset_name => l_ruleset_name,
1529: p_ruleset_start_date => l_ruleset_start_date,
1530: p_ruleset_end_date => l_ruleset_end_date);
1531:
1532: IF x_return_status = fnd_api.g_ret_sts_error
1533: THEN
1534: RAISE fnd_api.g_exc_error;
1535: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1536: THEN

Line 1534: RAISE fnd_api.g_exc_error;

1530: p_ruleset_end_date => l_ruleset_end_date);
1531:
1532: IF x_return_status = fnd_api.g_ret_sts_error
1533: THEN
1534: RAISE fnd_api.g_exc_error;
1535: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1536: THEN
1537: RAISE fnd_api.g_exc_unexpected_error;
1538: END IF;

Line 1535: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

1531:
1532: IF x_return_status = fnd_api.g_ret_sts_error
1533: THEN
1534: RAISE fnd_api.g_exc_error;
1535: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1536: THEN
1537: RAISE fnd_api.g_exc_unexpected_error;
1538: END IF;
1539: END IF;

Line 1537: RAISE fnd_api.g_exc_unexpected_error;

1533: THEN
1534: RAISE fnd_api.g_exc_error;
1535: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1536: THEN
1537: RAISE fnd_api.g_exc_unexpected_error;
1538: END IF;
1539: END IF;
1540: -- SK End of post processing hooks
1541:

Line 1572: IF (l_return_code = FND_API.G_RET_STS_ERROR)

1568: p_action_code => 'D',
1569: p_bind_data_id => l_bind_data_id,
1570: x_return_code => l_return_code) ;
1571:
1572: IF (l_return_code = FND_API.G_RET_STS_ERROR)
1573: THEN
1574: RAISE FND_API.G_EXC_ERROR;
1575: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
1576: THEN

Line 1574: RAISE FND_API.G_EXC_ERROR;

1570: x_return_code => l_return_code) ;
1571:
1572: IF (l_return_code = FND_API.G_RET_STS_ERROR)
1573: THEN
1574: RAISE FND_API.G_EXC_ERROR;
1575: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
1576: THEN
1577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1578: END IF;

Line 1575: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )

1571:
1572: IF (l_return_code = FND_API.G_RET_STS_ERROR)
1573: THEN
1574: RAISE FND_API.G_EXC_ERROR;
1575: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
1576: THEN
1577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1578: END IF;
1579:

Line 1577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1573: THEN
1574: RAISE FND_API.G_EXC_ERROR;
1575: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
1576: THEN
1577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1578: END IF;
1579:
1580: /*
1581: -- Message generation API

Line 1591: IF (x_return_status = FND_API.G_RET_STS_ERROR)

1587: p_oai_param => null,
1588: p_oai_array => l_oai_array,
1589: x_return_code => x_return_status) ;
1590:
1591: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1592: THEN
1593: RAISE FND_API.G_EXC_ERROR;
1594: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1595: THEN

Line 1593: RAISE FND_API.G_EXC_ERROR;

1589: x_return_code => x_return_status) ;
1590:
1591: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1592: THEN
1593: RAISE FND_API.G_EXC_ERROR;
1594: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1595: THEN
1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1597: END IF;

Line 1594: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1590:
1591: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1592: THEN
1593: RAISE FND_API.G_EXC_ERROR;
1594: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1595: THEN
1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1597: END IF;
1598: */

Line 1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1592: THEN
1593: RAISE FND_API.G_EXC_ERROR;
1594: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1595: THEN
1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1597: END IF;
1598: */
1599: END IF;
1600: END IF;

Line 1605: IF FND_API.To_Boolean( p_commit )

1601:
1602:
1603:
1604: -- Standard check of p_commit.
1605: IF FND_API.To_Boolean( p_commit )
1606: THEN
1607: COMMIT WORK;
1608: END IF;
1609:

Line 1616: WHEN FND_API.G_EXC_ERROR THEN

1612: (p_count => x_msg_count,
1613: p_data => x_msg_data
1614: );
1615: EXCEPTION
1616: WHEN FND_API.G_EXC_ERROR THEN
1617: ROLLBACK TO Delete_Rule;
1618: x_return_status := FND_API.G_RET_STS_ERROR ;
1619: FND_MSG_PUB.Count_And_Get
1620: (p_count => x_msg_count,

Line 1618: x_return_status := FND_API.G_RET_STS_ERROR ;

1614: );
1615: EXCEPTION
1616: WHEN FND_API.G_EXC_ERROR THEN
1617: ROLLBACK TO Delete_Rule;
1618: x_return_status := FND_API.G_RET_STS_ERROR ;
1619: FND_MSG_PUB.Count_And_Get
1620: (p_count => x_msg_count,
1621: p_data => x_msg_data,
1622: p_encoded => fnd_api.g_false

Line 1622: p_encoded => fnd_api.g_false

1618: x_return_status := FND_API.G_RET_STS_ERROR ;
1619: FND_MSG_PUB.Count_And_Get
1620: (p_count => x_msg_count,
1621: p_data => x_msg_data,
1622: p_encoded => fnd_api.g_false
1623: );
1624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1625: ROLLBACK TO Delete_Rule;
1626: x_loading_status := 'UNEXPECTED_ERR';

Line 1624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1620: (p_count => x_msg_count,
1621: p_data => x_msg_data,
1622: p_encoded => fnd_api.g_false
1623: );
1624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1625: ROLLBACK TO Delete_Rule;
1626: x_loading_status := 'UNEXPECTED_ERR';
1627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1628: FND_MSG_PUB.Count_And_Get

Line 1627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1623: );
1624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1625: ROLLBACK TO Delete_Rule;
1626: x_loading_status := 'UNEXPECTED_ERR';
1627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1628: FND_MSG_PUB.Count_And_Get
1629: (p_count => x_msg_count,
1630: p_data => x_msg_data,
1631: p_encoded => fnd_api.g_false

Line 1631: p_encoded => fnd_api.g_false

1627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1628: FND_MSG_PUB.Count_And_Get
1629: (p_count => x_msg_count,
1630: p_data => x_msg_data,
1631: p_encoded => fnd_api.g_false
1632: );
1633: WHEN OTHERS THEN
1634: ROLLBACK TO Delete_Rule;
1635: x_loading_status := 'UNEXPECTED_ERR';

Line 1636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1632: );
1633: WHEN OTHERS THEN
1634: ROLLBACK TO Delete_Rule;
1635: x_loading_status := 'UNEXPECTED_ERR';
1636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1637: IF FND_MSG_PUB.Check_Msg_Level
1638: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1639: THEN
1640: FND_MSG_PUB.Add_Exc_Msg

Line 1646: p_encoded => fnd_api.g_false

1642: END IF;
1643: FND_MSG_PUB.Count_And_Get
1644: (p_count => x_msg_count,
1645: p_data => x_msg_data,
1646: p_encoded => fnd_api.g_false
1647: );
1648: END;
1649:
1650: ---------------------------+