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

Line 23: -- Default = FND_API.G_FALSE

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

Line 25: -- Default = FND_API.G_FALSE

21: -- IN : p_api_version IN NUMBER Required
22: -- p_init_msg_list IN VARCHAR2 Optional
23: -- Default = FND_API.G_FALSE
24: -- p_commit IN VARCHAR2 Optional
25: -- Default = FND_API.G_FALSE
26: -- p_validation_level IN NUMBER Optional
27: -- Default = FND_API.G_VALID_LEVEL_FULL
28: -- p_RuleAttribute_rec IN
29: -- CN_RuleAttribute_PUB.RuleAttribute_rec_type

Line 27: -- Default = FND_API.G_VALID_LEVEL_FULL

23: -- Default = FND_API.G_FALSE
24: -- p_commit IN VARCHAR2 Optional
25: -- Default = FND_API.G_FALSE
26: -- p_validation_level IN NUMBER Optional
27: -- Default = FND_API.G_VALID_LEVEL_FULL
28: -- p_RuleAttribute_rec IN
29: -- CN_RuleAttribute_PUB.RuleAttribute_rec_type
30: --
31: -- OUT : x_return_status OUT VARCHAR2(1)

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

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

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

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

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

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

Line 86: IF NOT FND_API.Compatible_API_Call ( l_api_version,

82:
83: -- Standard Start of API savepoint
84: SAVEPOINT Create_RuleAttribute;
85: -- Standard call to check for call compatibility.
86: IF NOT FND_API.Compatible_API_Call ( l_api_version,
87: p_api_version,
88: l_api_name,
89: G_PKG_NAME )
90: THEN

Line 91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

87: p_api_version,
88: l_api_name,
89: G_PKG_NAME )
90: THEN
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: END IF;
93:
94: -- Initialize message list if p_init_msg_list is set to TRUE.
95: IF FND_API.to_Boolean( p_init_msg_list )

Line 95: IF FND_API.to_Boolean( p_init_msg_list )

91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: END IF;
93:
94: -- Initialize message list if p_init_msg_list is set to TRUE.
95: IF FND_API.to_Boolean( p_init_msg_list )
96: THEN
97: FND_MSG_PUB.initialize;
98: END IF;
99:

Line 101: x_return_status := FND_API.G_RET_STS_SUCCESS;

97: FND_MSG_PUB.initialize;
98: END IF;
99:
100: -- Initialize API return status to success
101: x_return_status := FND_API.G_RET_STS_SUCCESS;
102: x_loading_status := 'CN_INSERTED';
103:
104:
105: --

Line 132: IF x_return_status = fnd_api.g_ret_sts_error

128: x_msg_data => x_msg_data,
129: x_loading_status => x_loading_status,
130: p_ruleattribute_rec => l_ruleattribute_rec);
131:
132: IF x_return_status = fnd_api.g_ret_sts_error
133: THEN
134: RAISE fnd_api.g_exc_error;
135: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
136: THEN

Line 134: RAISE fnd_api.g_exc_error;

130: p_ruleattribute_rec => l_ruleattribute_rec);
131:
132: IF x_return_status = fnd_api.g_ret_sts_error
133: THEN
134: RAISE fnd_api.g_exc_error;
135: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
136: THEN
137: RAISE fnd_api.g_exc_unexpected_error;
138: END IF;

Line 135: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

131:
132: IF x_return_status = fnd_api.g_ret_sts_error
133: THEN
134: RAISE fnd_api.g_exc_error;
135: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
136: THEN
137: RAISE fnd_api.g_exc_unexpected_error;
138: END IF;
139: END IF;

Line 137: RAISE fnd_api.g_exc_unexpected_error;

133: THEN
134: RAISE fnd_api.g_exc_error;
135: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
136: THEN
137: RAISE fnd_api.g_exc_unexpected_error;
138: END IF;
139: END IF;
140:
141: -- vertical industry pre-processing section

Line 158: IF x_return_status = fnd_api.g_ret_sts_error

154: x_msg_data => x_msg_data,
155: x_loading_status => x_loading_status,
156: p_ruleattribute_rec => l_ruleattribute_rec);
157:
158: IF x_return_status = fnd_api.g_ret_sts_error
159: THEN
160: RAISE fnd_api.g_exc_error;
161: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
162: THEN

Line 160: RAISE fnd_api.g_exc_error;

156: p_ruleattribute_rec => l_ruleattribute_rec);
157:
158: IF x_return_status = fnd_api.g_ret_sts_error
159: THEN
160: RAISE fnd_api.g_exc_error;
161: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
162: THEN
163: RAISE fnd_api.g_exc_unexpected_error;
164: END IF;

Line 161: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

157:
158: IF x_return_status = fnd_api.g_ret_sts_error
159: THEN
160: RAISE fnd_api.g_exc_error;
161: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
162: THEN
163: RAISE fnd_api.g_exc_unexpected_error;
164: END IF;
165: END IF;

Line 163: RAISE fnd_api.g_exc_unexpected_error;

159: THEN
160: RAISE fnd_api.g_exc_error;
161: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
162: THEN
163: RAISE fnd_api.g_exc_unexpected_error;
164: END IF;
165: END IF;
166:
167:

Line 178: x_loading_status) = FND_API.G_TRUE )

174: IF (cn_api.chk_miss_null_char_para
175: ( l_RuleAttribute_rec.ruleset_name,
176: cn_api.get_lkup_meaning('RULESET_NAME', 'RULESET_TYPE'),
177: x_loading_status,
178: x_loading_status) = FND_API.G_TRUE )
179: THEN
180: RAISE fnd_api.g_exc_error;
181: END IF;
182: IF (cn_api.chk_miss_null_date_para

Line 180: RAISE fnd_api.g_exc_error;

176: cn_api.get_lkup_meaning('RULESET_NAME', 'RULESET_TYPE'),
177: x_loading_status,
178: x_loading_status) = FND_API.G_TRUE )
179: THEN
180: RAISE fnd_api.g_exc_error;
181: END IF;
182: IF (cn_api.chk_miss_null_date_para
183: ( l_RuleAttribute_rec.start_date,
184: cn_api.get_lkup_meaning('START_DATE', 'RULESET_TYPE'),

Line 186: x_loading_status) = FND_API.G_TRUE )

182: IF (cn_api.chk_miss_null_date_para
183: ( l_RuleAttribute_rec.start_date,
184: cn_api.get_lkup_meaning('START_DATE', '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: IF (cn_api.chk_miss_null_date_para

Line 188: RAISE fnd_api.g_exc_error;

184: cn_api.get_lkup_meaning('START_DATE', '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: IF (cn_api.chk_miss_null_date_para
191: ( l_RuleAttribute_rec.end_date,
192: cn_api.get_lkup_meaning('END_DATE', 'RULESET_TYPE'),

Line 194: x_loading_status) = FND_API.G_TRUE )

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

Line 196: RAISE fnd_api.g_exc_error;

192: cn_api.get_lkup_meaning('END_DATE', 'RULESET_TYPE'),
193: x_loading_status,
194: x_loading_status) = FND_API.G_TRUE )
195: THEN
196: RAISE fnd_api.g_exc_error;
197: END IF;
198:
199: IF (cn_api.chk_miss_null_char_para
200: ( l_RuleAttribute_rec.rule_name,

Line 203: x_loading_status) = FND_API.G_TRUE )

199: IF (cn_api.chk_miss_null_char_para
200: ( l_RuleAttribute_rec.rule_name,
201: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),
202: x_loading_status,
203: x_loading_status) = FND_API.G_TRUE )
204: THEN
205: RAISE fnd_api.g_exc_error;
206: END IF;
207:

Line 205: RAISE fnd_api.g_exc_error;

201: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),
202: x_loading_status,
203: x_loading_status) = FND_API.G_TRUE )
204: THEN
205: RAISE fnd_api.g_exc_error;
206: END IF;
207:
208: IF (cn_api.chk_null_char_para
209: ( l_RuleAttribute_rec.object_name,

Line 212: x_loading_status) = FND_API.G_TRUE )

208: IF (cn_api.chk_null_char_para
209: ( l_RuleAttribute_rec.object_name,
210: cn_api.get_lkup_meaning('OBJECT_NAME', 'RULESET_TYPE'),
211: x_loading_status,
212: x_loading_status) = FND_API.G_TRUE )
213: THEN
214: RAISE fnd_api.g_exc_error;
215: END IF;
216:

Line 214: RAISE fnd_api.g_exc_error;

210: cn_api.get_lkup_meaning('OBJECT_NAME', 'RULESET_TYPE'),
211: x_loading_status,
212: x_loading_status) = FND_API.G_TRUE )
213: THEN
214: RAISE fnd_api.g_exc_error;
215: END IF;
216:
217: IF (cn_api.chk_null_char_para
218: ( l_RuleAttribute_rec.data_flag,

Line 221: x_loading_status) = FND_API.G_TRUE )

217: IF (cn_api.chk_null_char_para
218: ( l_RuleAttribute_rec.data_flag,
219: cn_api.get_lkup_meaning('DATA_FLAG', '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:

Line 223: RAISE fnd_api.g_exc_error;

219: cn_api.get_lkup_meaning('DATA_FLAG', '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:
226: SELECT object_id
227: INTO l_object_id

Line 254: RAISE FND_API.G_EXC_ERROR;

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

Line 287: IF x_return_status = fnd_api.g_ret_sts_error

283: x_msg_data => x_msg_data,
284: x_loading_status => x_loading_status,
285: p_ruleattribute_rec => l_ruleattribute_rec_pvt);
286:
287: IF x_return_status = fnd_api.g_ret_sts_error
288: THEN
289: RAISE fnd_api.g_exc_error;
290: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
291: THEN

Line 289: RAISE fnd_api.g_exc_error;

285: p_ruleattribute_rec => l_ruleattribute_rec_pvt);
286:
287: IF x_return_status = fnd_api.g_ret_sts_error
288: THEN
289: RAISE fnd_api.g_exc_error;
290: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
291: THEN
292: RAISE fnd_api.g_exc_unexpected_error;
293: END IF;

Line 290: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

286:
287: IF x_return_status = fnd_api.g_ret_sts_error
288: THEN
289: RAISE fnd_api.g_exc_error;
290: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
291: THEN
292: RAISE fnd_api.g_exc_unexpected_error;
293: END IF;
294: END LOOP;

Line 292: RAISE fnd_api.g_exc_unexpected_error;

288: THEN
289: RAISE fnd_api.g_exc_error;
290: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
291: THEN
292: RAISE fnd_api.g_exc_unexpected_error;
293: END IF;
294: END LOOP;
295:
296: --

Line 323: IF x_return_status = fnd_api.g_ret_sts_error

319: x_msg_data => x_msg_data,
320: x_loading_status => x_loading_status,
321: p_ruleattribute_rec => l_ruleattribute_rec);
322:
323: IF x_return_status = fnd_api.g_ret_sts_error
324: THEN
325: RAISE fnd_api.g_exc_error;
326: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
327: THEN

Line 325: RAISE fnd_api.g_exc_error;

321: p_ruleattribute_rec => l_ruleattribute_rec);
322:
323: IF x_return_status = fnd_api.g_ret_sts_error
324: THEN
325: RAISE fnd_api.g_exc_error;
326: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
327: THEN
328: RAISE fnd_api.g_exc_unexpected_error;
329: END IF;

Line 326: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

322:
323: IF x_return_status = fnd_api.g_ret_sts_error
324: THEN
325: RAISE fnd_api.g_exc_error;
326: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
327: THEN
328: RAISE fnd_api.g_exc_unexpected_error;
329: END IF;
330: END IF;

Line 328: RAISE fnd_api.g_exc_unexpected_error;

324: THEN
325: RAISE fnd_api.g_exc_error;
326: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
327: THEN
328: RAISE fnd_api.g_exc_unexpected_error;
329: END IF;
330: END IF;
331:
332: -- customer post processing section

Line 349: IF x_return_status = fnd_api.g_ret_sts_error

345: x_msg_data => x_msg_data,
346: x_loading_status => x_loading_status,
347: p_ruleattribute_rec => l_ruleattribute_rec);
348:
349: IF x_return_status = fnd_api.g_ret_sts_error
350: THEN
351: RAISE fnd_api.g_exc_error;
352: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
353: THEN

Line 351: RAISE fnd_api.g_exc_error;

347: p_ruleattribute_rec => l_ruleattribute_rec);
348:
349: IF x_return_status = fnd_api.g_ret_sts_error
350: THEN
351: RAISE fnd_api.g_exc_error;
352: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
353: THEN
354: RAISE fnd_api.g_exc_unexpected_error;
355: END IF;

Line 352: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

348:
349: IF x_return_status = fnd_api.g_ret_sts_error
350: THEN
351: RAISE fnd_api.g_exc_error;
352: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
353: THEN
354: RAISE fnd_api.g_exc_unexpected_error;
355: END IF;
356: END IF;

Line 354: RAISE fnd_api.g_exc_unexpected_error;

350: THEN
351: RAISE fnd_api.g_exc_error;
352: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
353: THEN
354: RAISE fnd_api.g_exc_unexpected_error;
355: END IF;
356: END IF;
357:
358: -- Message generation section.

Line 387: IF (l_return_code = FND_API.G_RET_STS_ERROR)

383: p_action_code => 'I',
384: p_bind_data_id => l_bind_data_id,
385: x_return_code => l_return_code) ;
386:
387: IF (l_return_code = FND_API.G_RET_STS_ERROR)
388: THEN
389: RAISE FND_API.G_EXC_ERROR;
390: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
391: THEN

Line 389: RAISE FND_API.G_EXC_ERROR;

385: x_return_code => l_return_code) ;
386:
387: IF (l_return_code = FND_API.G_RET_STS_ERROR)
388: THEN
389: RAISE FND_API.G_EXC_ERROR;
390: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
391: THEN
392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
393: END IF;

Line 390: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )

386:
387: IF (l_return_code = FND_API.G_RET_STS_ERROR)
388: THEN
389: RAISE FND_API.G_EXC_ERROR;
390: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
391: THEN
392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
393: END IF;
394:

Line 392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

388: THEN
389: RAISE FND_API.G_EXC_ERROR;
390: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
391: THEN
392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
393: END IF;
394:
395: /*
396: -- Message generation API

Line 406: IF (x_return_status = FND_API.G_RET_STS_ERROR)

402: p_oai_param => null,
403: p_oai_array => l_oai_array,
404: x_return_code => x_return_status) ;
405:
406: IF (x_return_status = FND_API.G_RET_STS_ERROR)
407: THEN
408: RAISE FND_API.G_EXC_ERROR;
409: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
410: THEN

Line 408: RAISE FND_API.G_EXC_ERROR;

404: x_return_code => x_return_status) ;
405:
406: IF (x_return_status = FND_API.G_RET_STS_ERROR)
407: THEN
408: RAISE FND_API.G_EXC_ERROR;
409: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
410: THEN
411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
412: END IF;

Line 409: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

405:
406: IF (x_return_status = FND_API.G_RET_STS_ERROR)
407: THEN
408: RAISE FND_API.G_EXC_ERROR;
409: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
410: THEN
411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
412: END IF;
413: */

Line 411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

407: THEN
408: RAISE FND_API.G_EXC_ERROR;
409: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
410: THEN
411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
412: END IF;
413: */
414:
415: END IF;

Line 420: IF FND_API.To_Boolean( p_commit )

416: END IF;
417:
418:
419: -- Standard check of p_commit.
420: IF FND_API.To_Boolean( p_commit )
421: THEN
422: COMMIT WORK;
423: END IF;
424:

Line 431: WHEN FND_API.G_EXC_ERROR THEN

427: (p_count => x_msg_count,
428: p_data => x_msg_data
429: );
430: EXCEPTION
431: WHEN FND_API.G_EXC_ERROR THEN
432: ROLLBACK TO Create_RuleAttribute;
433: x_return_status := FND_API.G_RET_STS_ERROR ;
434: FND_MSG_PUB.Count_And_Get
435: (p_count => x_msg_count,

Line 433: x_return_status := FND_API.G_RET_STS_ERROR ;

429: );
430: EXCEPTION
431: WHEN FND_API.G_EXC_ERROR THEN
432: ROLLBACK TO Create_RuleAttribute;
433: x_return_status := FND_API.G_RET_STS_ERROR ;
434: FND_MSG_PUB.Count_And_Get
435: (p_count => x_msg_count,
436: p_data => x_msg_data,
437: p_encoded => fnd_api.g_false

Line 437: p_encoded => fnd_api.g_false

433: x_return_status := FND_API.G_RET_STS_ERROR ;
434: FND_MSG_PUB.Count_And_Get
435: (p_count => x_msg_count,
436: p_data => x_msg_data,
437: p_encoded => fnd_api.g_false
438: );
439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
440: ROLLBACK TO Create_RuleAttribute;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

435: (p_count => x_msg_count,
436: p_data => x_msg_data,
437: p_encoded => fnd_api.g_false
438: );
439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
440: ROLLBACK TO Create_RuleAttribute;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
442: x_loading_status := 'UNEXPECTED_ERR';
443: FND_MSG_PUB.Count_And_Get

Line 441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

437: p_encoded => fnd_api.g_false
438: );
439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
440: ROLLBACK TO Create_RuleAttribute;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
442: x_loading_status := 'UNEXPECTED_ERR';
443: FND_MSG_PUB.Count_And_Get
444: (p_count => x_msg_count,
445: p_data => x_msg_data,

Line 446: p_encoded => fnd_api.g_false

442: x_loading_status := 'UNEXPECTED_ERR';
443: FND_MSG_PUB.Count_And_Get
444: (p_count => x_msg_count,
445: p_data => x_msg_data,
446: p_encoded => fnd_api.g_false
447: );
448: WHEN OTHERS THEN
449: ROLLBACK TO Create_RuleAttribute;
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

446: p_encoded => fnd_api.g_false
447: );
448: WHEN OTHERS THEN
449: ROLLBACK TO Create_RuleAttribute;
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
451: x_loading_status := 'UNEXPECTED_ERR';
452: IF FND_MSG_PUB.Check_Msg_Level
453: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
454: THEN

Line 461: p_encoded => fnd_api.g_false

457: END IF;
458: FND_MSG_PUB.Count_And_Get
459: (p_count => x_msg_count,
460: p_data => x_msg_data,
461: p_encoded => fnd_api.g_false
462: );
463: END Create_RuleAttribute;
464:
465:

Line 477: -- Default = FND_API.G_FALSE

473: -- Pre-reqs : None.
474: -- Parameters :
475: -- IN : p_api_version IN NUMBER Required
476: -- p_init_msg_list IN VARCHAR2 Optional
477: -- Default = FND_API.G_FALSE
478: -- p_commit IN VARCHAR2 Optional
479: -- Default = FND_API.G_FALSE
480: -- p_validation_level IN NUMBER Optional
481: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 479: -- Default = FND_API.G_FALSE

475: -- IN : p_api_version IN NUMBER Required
476: -- p_init_msg_list IN VARCHAR2 Optional
477: -- Default = FND_API.G_FALSE
478: -- p_commit IN VARCHAR2 Optional
479: -- Default = FND_API.G_FALSE
480: -- p_validation_level IN NUMBER Optional
481: -- Default = FND_API.G_VALID_LEVEL_FULL
482: -- p_rule_rec_type IN
483: -- CN_RuleAttribute_PUB.rule_rec_type

Line 481: -- Default = FND_API.G_VALID_LEVEL_FULL

477: -- Default = FND_API.G_FALSE
478: -- p_commit IN VARCHAR2 Optional
479: -- Default = FND_API.G_FALSE
480: -- p_validation_level IN NUMBER Optional
481: -- Default = FND_API.G_VALID_LEVEL_FULL
482: -- p_rule_rec_type IN
483: -- CN_RuleAttribute_PUB.rule_rec_type
484: -- p_RuleAttribute_rec_type IN
485: -- CN_RuleAttribute_PUB.RuleAttribute_rec_type

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

501:
502:
503: PROCEDURE Update_RuleAttribute
504: ( p_api_version IN NUMBER,
505: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
506: p_commit IN VARCHAR2 := FND_API.G_FALSE,
507: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
508: x_return_status OUT NOCOPY VARCHAR2,
509: x_msg_count OUT NOCOPY NUMBER,

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

502:
503: PROCEDURE Update_RuleAttribute
504: ( p_api_version IN NUMBER,
505: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
506: p_commit IN VARCHAR2 := FND_API.G_FALSE,
507: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
508: x_return_status OUT NOCOPY VARCHAR2,
509: x_msg_count OUT NOCOPY NUMBER,
510: x_msg_data OUT NOCOPY VARCHAR2,

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

503: PROCEDURE Update_RuleAttribute
504: ( p_api_version IN NUMBER,
505: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
506: p_commit IN VARCHAR2 := FND_API.G_FALSE,
507: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
508: x_return_status OUT NOCOPY VARCHAR2,
509: x_msg_count OUT NOCOPY NUMBER,
510: x_msg_data OUT NOCOPY VARCHAR2,
511: x_loading_status OUT NOCOPY VARCHAR2,

Line 558: IF NOT FND_API.Compatible_API_Call ( l_api_version,

554:
555: -- Standard Start of API savepoint
556: SAVEPOINT Update_RuleAttribute;
557: -- Standard call to check for call compatibility.
558: IF NOT FND_API.Compatible_API_Call ( l_api_version,
559: p_api_version,
560: l_api_name,
561: G_PKG_NAME )
562: THEN

Line 563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

559: p_api_version,
560: l_api_name,
561: G_PKG_NAME )
562: THEN
563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
564: END IF;
565:
566: -- Initialize message list if p_init_msg_list is set to TRUE.
567: IF FND_API.to_Boolean( p_init_msg_list )

Line 567: IF FND_API.to_Boolean( p_init_msg_list )

563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
564: END IF;
565:
566: -- Initialize message list if p_init_msg_list is set to TRUE.
567: IF FND_API.to_Boolean( p_init_msg_list )
568: THEN
569: FND_MSG_PUB.initialize;
570: END IF;
571:

Line 573: x_return_status := FND_API.G_RET_STS_SUCCESS;

569: FND_MSG_PUB.initialize;
570: END IF;
571:
572: -- Initialize API return status to success
573: x_return_status := FND_API.G_RET_STS_SUCCESS;
574: x_loading_status := 'CN_UPDATED';
575:
576:
577: --

Line 606: IF x_return_status = fnd_api.g_ret_sts_error

602: x_loading_status => x_loading_status,
603: p_ruleattribute_rec => l_ruleattribute_rec,
604: p_old_RuleAttribute_rec => l_old_RuleAttribute_rec);
605:
606: IF x_return_status = fnd_api.g_ret_sts_error
607: THEN
608: RAISE fnd_api.g_exc_error;
609: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
610: THEN

Line 608: RAISE fnd_api.g_exc_error;

604: p_old_RuleAttribute_rec => l_old_RuleAttribute_rec);
605:
606: IF x_return_status = fnd_api.g_ret_sts_error
607: THEN
608: RAISE fnd_api.g_exc_error;
609: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
610: THEN
611: RAISE fnd_api.g_exc_unexpected_error;
612: END IF;

Line 609: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

605:
606: IF x_return_status = fnd_api.g_ret_sts_error
607: THEN
608: RAISE fnd_api.g_exc_error;
609: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
610: THEN
611: RAISE fnd_api.g_exc_unexpected_error;
612: END IF;
613: END IF;

Line 611: RAISE fnd_api.g_exc_unexpected_error;

607: THEN
608: RAISE fnd_api.g_exc_error;
609: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
610: THEN
611: RAISE fnd_api.g_exc_unexpected_error;
612: END IF;
613: END IF;
614:
615: -- vertical industry pre-processing section

Line 633: IF x_return_status = fnd_api.g_ret_sts_error

629: x_loading_status => x_loading_status,
630: p_ruleattribute_rec => l_ruleattribute_rec,
631: p_old_RuleAttribute_rec => l_old_RuleAttribute_rec);
632:
633: IF x_return_status = fnd_api.g_ret_sts_error
634: THEN
635: RAISE fnd_api.g_exc_error;
636: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
637: THEN

Line 635: RAISE fnd_api.g_exc_error;

631: p_old_RuleAttribute_rec => l_old_RuleAttribute_rec);
632:
633: IF x_return_status = fnd_api.g_ret_sts_error
634: THEN
635: RAISE fnd_api.g_exc_error;
636: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
637: THEN
638: RAISE fnd_api.g_exc_unexpected_error;
639: END IF;

Line 636: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

632:
633: IF x_return_status = fnd_api.g_ret_sts_error
634: THEN
635: RAISE fnd_api.g_exc_error;
636: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
637: THEN
638: RAISE fnd_api.g_exc_unexpected_error;
639: END IF;
640: END IF;

Line 638: RAISE fnd_api.g_exc_unexpected_error;

634: THEN
635: RAISE fnd_api.g_exc_error;
636: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
637: THEN
638: RAISE fnd_api.g_exc_unexpected_error;
639: END IF;
640: END IF;
641:
642:

Line 653: x_loading_status) = FND_API.G_TRUE )

649: IF (cn_api.chk_miss_null_char_para
650: ( l_old_RuleAttribute_rec.ruleset_name,
651: cn_api.get_lkup_meaning('RULESET_NAME', 'RULESET_TYPE'),
652: x_loading_status,
653: x_loading_status) = FND_API.G_TRUE )
654: THEN
655: RAISE fnd_api.g_exc_error;
656: END IF;
657:

Line 655: RAISE fnd_api.g_exc_error;

651: cn_api.get_lkup_meaning('RULESET_NAME', 'RULESET_TYPE'),
652: x_loading_status,
653: x_loading_status) = FND_API.G_TRUE )
654: THEN
655: RAISE fnd_api.g_exc_error;
656: END IF;
657:
658: IF (cn_api.chk_miss_null_date_para
659: ( l_old_RuleAttribute_rec.start_date,

Line 662: x_loading_status) = FND_API.G_TRUE )

658: IF (cn_api.chk_miss_null_date_para
659: ( l_old_RuleAttribute_rec.start_date,
660: cn_api.get_lkup_meaning('START_DATE', 'RULESET_TYPE'),
661: x_loading_status,
662: x_loading_status) = FND_API.G_TRUE )
663: THEN
664: RAISE fnd_api.g_exc_error;
665: END IF;
666:

Line 664: RAISE fnd_api.g_exc_error;

660: cn_api.get_lkup_meaning('START_DATE', 'RULESET_TYPE'),
661: x_loading_status,
662: x_loading_status) = FND_API.G_TRUE )
663: THEN
664: RAISE fnd_api.g_exc_error;
665: END IF;
666:
667: IF (cn_api.chk_miss_null_date_para
668: ( l_old_RuleAttribute_rec.end_date,

Line 671: x_loading_status) = FND_API.G_TRUE )

667: IF (cn_api.chk_miss_null_date_para
668: ( l_old_RuleAttribute_rec.end_date,
669: cn_api.get_lkup_meaning('END_DATE', 'RULESET_TYPE'),
670: x_loading_status,
671: x_loading_status) = FND_API.G_TRUE )
672: THEN
673: RAISE fnd_api.g_exc_error;
674: END IF;
675:

Line 673: RAISE fnd_api.g_exc_error;

669: cn_api.get_lkup_meaning('END_DATE', 'RULESET_TYPE'),
670: x_loading_status,
671: x_loading_status) = FND_API.G_TRUE )
672: THEN
673: RAISE fnd_api.g_exc_error;
674: END IF;
675:
676: IF (cn_api.chk_miss_null_char_para
677: ( l_old_RuleAttribute_rec.rule_name,

Line 680: x_loading_status) = FND_API.G_TRUE )

676: IF (cn_api.chk_miss_null_char_para
677: ( l_old_RuleAttribute_rec.rule_name,
678: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),
679: x_loading_status,
680: x_loading_status) = FND_API.G_TRUE )
681: THEN
682: RAISE fnd_api.g_exc_error;
683: END IF;
684:

Line 682: RAISE fnd_api.g_exc_error;

678: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),
679: x_loading_status,
680: x_loading_status) = FND_API.G_TRUE )
681: THEN
682: RAISE fnd_api.g_exc_error;
683: END IF;
684:
685: IF (cn_api.chk_null_char_para
686: ( l_old_RuleAttribute_rec.object_name,

Line 689: x_loading_status) = FND_API.G_TRUE )

685: IF (cn_api.chk_null_char_para
686: ( l_old_RuleAttribute_rec.object_name,
687: cn_api.get_lkup_meaning('OBJECT_NAME', 'RULESET_TYPE'),
688: x_loading_status,
689: x_loading_status) = FND_API.G_TRUE )
690: THEN
691: RAISE fnd_api.g_exc_error;
692: END IF;
693:

Line 691: RAISE fnd_api.g_exc_error;

687: cn_api.get_lkup_meaning('OBJECT_NAME', 'RULESET_TYPE'),
688: x_loading_status,
689: x_loading_status) = FND_API.G_TRUE )
690: THEN
691: RAISE fnd_api.g_exc_error;
692: END IF;
693:
694: IF (cn_api.chk_null_char_para
695: ( l_old_RuleAttribute_rec.data_flag,

Line 698: x_loading_status) = FND_API.G_TRUE )

694: IF (cn_api.chk_null_char_para
695: ( l_old_RuleAttribute_rec.data_flag,
696: cn_api.get_lkup_meaning('DATA_FLAG', 'RULESET_TYPE'),
697: x_loading_status,
698: x_loading_status) = FND_API.G_TRUE )
699: THEN
700: RAISE fnd_api.g_exc_error;
701: END IF;
702:

Line 700: RAISE fnd_api.g_exc_error;

696: cn_api.get_lkup_meaning('DATA_FLAG', 'RULESET_TYPE'),
697: x_loading_status,
698: x_loading_status) = FND_API.G_TRUE )
699: THEN
700: RAISE fnd_api.g_exc_error;
701: END IF;
702:
703: --New parameters
704: IF (cn_api.chk_miss_null_char_para

Line 708: x_loading_status) = FND_API.G_TRUE )

704: IF (cn_api.chk_miss_null_char_para
705: ( l_RuleAttribute_rec.ruleset_name,
706: cn_api.get_lkup_meaning('RULESET_NAME', 'RULESET_TYPE'),
707: x_loading_status,
708: x_loading_status) = FND_API.G_TRUE )
709: THEN
710: RAISE fnd_api.g_exc_error;
711: END IF;
712:

Line 710: RAISE fnd_api.g_exc_error;

706: cn_api.get_lkup_meaning('RULESET_NAME', 'RULESET_TYPE'),
707: x_loading_status,
708: x_loading_status) = FND_API.G_TRUE )
709: THEN
710: RAISE fnd_api.g_exc_error;
711: END IF;
712:
713: IF (cn_api.chk_miss_null_date_para
714: ( l_RuleAttribute_rec.start_date,

Line 717: x_loading_status) = FND_API.G_TRUE )

713: IF (cn_api.chk_miss_null_date_para
714: ( l_RuleAttribute_rec.start_date,
715: cn_api.get_lkup_meaning('START_DATE', 'RULESET_TYPE'),
716: x_loading_status,
717: x_loading_status) = FND_API.G_TRUE )
718: THEN
719: RAISE fnd_api.g_exc_error;
720: END IF;
721:

Line 719: RAISE fnd_api.g_exc_error;

715: cn_api.get_lkup_meaning('START_DATE', 'RULESET_TYPE'),
716: x_loading_status,
717: x_loading_status) = FND_API.G_TRUE )
718: THEN
719: RAISE fnd_api.g_exc_error;
720: END IF;
721:
722: IF (cn_api.chk_miss_null_date_para
723: ( l_RuleAttribute_rec.end_date,

Line 726: x_loading_status) = FND_API.G_TRUE )

722: IF (cn_api.chk_miss_null_date_para
723: ( l_RuleAttribute_rec.end_date,
724: cn_api.get_lkup_meaning('END_DATE', 'RULESET_TYPE'),
725: x_loading_status,
726: x_loading_status) = FND_API.G_TRUE )
727: THEN
728: RAISE fnd_api.g_exc_error;
729: END IF;
730:

Line 728: RAISE fnd_api.g_exc_error;

724: cn_api.get_lkup_meaning('END_DATE', 'RULESET_TYPE'),
725: x_loading_status,
726: x_loading_status) = FND_API.G_TRUE )
727: THEN
728: RAISE fnd_api.g_exc_error;
729: END IF;
730:
731: IF (cn_api.chk_miss_null_char_para
732: ( l_RuleAttribute_rec.rule_name,

Line 735: x_loading_status) = FND_API.G_TRUE )

731: IF (cn_api.chk_miss_null_char_para
732: ( l_RuleAttribute_rec.rule_name,
733: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),
734: x_loading_status,
735: x_loading_status) = FND_API.G_TRUE )
736: THEN
737: RAISE fnd_api.g_exc_error;
738: END IF;
739:

Line 737: RAISE fnd_api.g_exc_error;

733: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),
734: x_loading_status,
735: x_loading_status) = FND_API.G_TRUE )
736: THEN
737: RAISE fnd_api.g_exc_error;
738: END IF;
739:
740: IF (cn_api.chk_null_char_para
741: ( l_RuleAttribute_rec.object_name,

Line 744: x_loading_status) = FND_API.G_TRUE )

740: IF (cn_api.chk_null_char_para
741: ( l_RuleAttribute_rec.object_name,
742: cn_api.get_lkup_meaning('OBJECT_NAME', 'RULESET_TYPE'),
743: x_loading_status,
744: x_loading_status) = FND_API.G_TRUE )
745: THEN
746: RAISE fnd_api.g_exc_error;
747: END IF;
748:

Line 746: RAISE fnd_api.g_exc_error;

742: cn_api.get_lkup_meaning('OBJECT_NAME', 'RULESET_TYPE'),
743: x_loading_status,
744: x_loading_status) = FND_API.G_TRUE )
745: THEN
746: RAISE fnd_api.g_exc_error;
747: END IF;
748:
749: IF (cn_api.chk_null_char_para
750: ( l_RuleAttribute_rec.data_flag,

Line 753: x_loading_status) = FND_API.G_TRUE )

749: IF (cn_api.chk_null_char_para
750: ( l_RuleAttribute_rec.data_flag,
751: cn_api.get_lkup_meaning('DATA_FLAG', 'RULESET_TYPE'),
752: x_loading_status,
753: x_loading_status) = FND_API.G_TRUE )
754: THEN
755: RAISE fnd_api.g_exc_error;
756: END IF;
757:

Line 755: RAISE fnd_api.g_exc_error;

751: cn_api.get_lkup_meaning('DATA_FLAG', 'RULESET_TYPE'),
752: x_loading_status,
753: x_loading_status) = FND_API.G_TRUE )
754: THEN
755: RAISE fnd_api.g_exc_error;
756: END IF;
757:
758: -- l_old_ruleattribute_rec.object_name := p_old_ruleattribute_rec.object_name;
759: SELECT object_id

Line 790: RAISE FND_API.G_EXC_ERROR;

786: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
787: fnd_msg_pub.add;
788: END IF;
789: x_loading_status := 'CN_INVALID_RULESET';
790: RAISE FND_API.G_EXC_ERROR;
791: ELSE
792: SELECT ruleset_id
793: INTO l_ruleattribute_rec_pvt.ruleset_id
794: FROM cn_rulesets

Line 818: RAISE FND_API.G_EXC_ERROR;

814: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
815: fnd_msg_pub.add;
816: END IF;
817: x_loading_status := 'CN_INVALID_RULESET';
818: RAISE FND_API.G_EXC_ERROR;
819: ELSE
820: SELECT ruleset_id
821: INTO l_old_ruleattribute_rec_pvt.ruleset_id
822: FROM cn_rulesets

Line 886: IF x_return_status = fnd_api.g_ret_sts_error

882: x_loading_status => x_loading_status,
883: p_ruleattribute_rec => l_ruleattribute_rec_pvt,
884: p_old_ruleattribute_rec => l_old_ruleattribute_rec_pvt);
885:
886: IF x_return_status = fnd_api.g_ret_sts_error
887: THEN
888: RAISE fnd_api.g_exc_error;
889: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
890: THEN

Line 888: RAISE fnd_api.g_exc_error;

884: p_old_ruleattribute_rec => l_old_ruleattribute_rec_pvt);
885:
886: IF x_return_status = fnd_api.g_ret_sts_error
887: THEN
888: RAISE fnd_api.g_exc_error;
889: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
890: THEN
891: RAISE fnd_api.g_exc_unexpected_error;
892: END IF;

Line 889: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

885:
886: IF x_return_status = fnd_api.g_ret_sts_error
887: THEN
888: RAISE fnd_api.g_exc_error;
889: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
890: THEN
891: RAISE fnd_api.g_exc_unexpected_error;
892: END IF;
893: END LOOP;

Line 891: RAISE fnd_api.g_exc_unexpected_error;

887: THEN
888: RAISE fnd_api.g_exc_error;
889: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
890: THEN
891: RAISE fnd_api.g_exc_unexpected_error;
892: END IF;
893: END LOOP;
894: END LOOP;
895:

Line 924: IF x_return_status = fnd_api.g_ret_sts_error

920: x_loading_status => x_loading_status,
921: p_ruleattribute_rec => l_ruleattribute_rec,
922: p_old_RuleAttribute_rec => l_old_RuleAttribute_rec);
923:
924: IF x_return_status = fnd_api.g_ret_sts_error
925: THEN
926: RAISE fnd_api.g_exc_error;
927: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
928: THEN

Line 926: RAISE fnd_api.g_exc_error;

922: p_old_RuleAttribute_rec => l_old_RuleAttribute_rec);
923:
924: IF x_return_status = fnd_api.g_ret_sts_error
925: THEN
926: RAISE fnd_api.g_exc_error;
927: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
928: THEN
929: RAISE fnd_api.g_exc_unexpected_error;
930: END IF;

Line 927: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

923:
924: IF x_return_status = fnd_api.g_ret_sts_error
925: THEN
926: RAISE fnd_api.g_exc_error;
927: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
928: THEN
929: RAISE fnd_api.g_exc_unexpected_error;
930: END IF;
931: END IF;

Line 929: RAISE fnd_api.g_exc_unexpected_error;

925: THEN
926: RAISE fnd_api.g_exc_error;
927: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
928: THEN
929: RAISE fnd_api.g_exc_unexpected_error;
930: END IF;
931: END IF;
932:
933:

Line 952: IF x_return_status = fnd_api.g_ret_sts_error

948: x_loading_status => x_loading_status,
949: p_ruleattribute_rec => l_ruleattribute_rec,
950: p_old_RuleAttribute_rec => l_old_RuleAttribute_rec);
951:
952: IF x_return_status = fnd_api.g_ret_sts_error
953: THEN
954: RAISE fnd_api.g_exc_error;
955: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
956: THEN

Line 954: RAISE fnd_api.g_exc_error;

950: p_old_RuleAttribute_rec => l_old_RuleAttribute_rec);
951:
952: IF x_return_status = fnd_api.g_ret_sts_error
953: THEN
954: RAISE fnd_api.g_exc_error;
955: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
956: THEN
957: RAISE fnd_api.g_exc_unexpected_error;
958: END IF;

Line 955: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

951:
952: IF x_return_status = fnd_api.g_ret_sts_error
953: THEN
954: RAISE fnd_api.g_exc_error;
955: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
956: THEN
957: RAISE fnd_api.g_exc_unexpected_error;
958: END IF;
959: END IF;

Line 957: RAISE fnd_api.g_exc_unexpected_error;

953: THEN
954: RAISE fnd_api.g_exc_error;
955: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
956: THEN
957: RAISE fnd_api.g_exc_unexpected_error;
958: END IF;
959: END IF;
960: -- SK End of post processing hooks
961:

Line 992: IF (l_return_code = FND_API.G_RET_STS_ERROR)

988: p_action_code => 'U',
989: p_bind_data_id => l_bind_data_id,
990: x_return_code => l_return_code) ;
991:
992: IF (l_return_code = FND_API.G_RET_STS_ERROR)
993: THEN
994: RAISE FND_API.G_EXC_ERROR;
995: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
996: THEN

Line 994: RAISE FND_API.G_EXC_ERROR;

990: x_return_code => l_return_code) ;
991:
992: IF (l_return_code = FND_API.G_RET_STS_ERROR)
993: THEN
994: RAISE FND_API.G_EXC_ERROR;
995: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
996: THEN
997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: END IF;

Line 995: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )

991:
992: IF (l_return_code = FND_API.G_RET_STS_ERROR)
993: THEN
994: RAISE FND_API.G_EXC_ERROR;
995: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
996: THEN
997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: END IF;
999:

Line 997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

993: THEN
994: RAISE FND_API.G_EXC_ERROR;
995: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
996: THEN
997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: END IF;
999:
1000: /*
1001: -- Message generation API

Line 1011: IF (x_return_status = FND_API.G_RET_STS_ERROR)

1007: p_oai_param => null,
1008: p_oai_array => l_oai_array,
1009: x_return_code => x_return_status) ;
1010:
1011: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1012: THEN
1013: RAISE FND_API.G_EXC_ERROR;
1014: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1015: THEN

Line 1013: RAISE FND_API.G_EXC_ERROR;

1009: x_return_code => x_return_status) ;
1010:
1011: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1012: THEN
1013: RAISE FND_API.G_EXC_ERROR;
1014: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1015: THEN
1016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1017: END IF;

Line 1014: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1010:
1011: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1012: THEN
1013: RAISE FND_API.G_EXC_ERROR;
1014: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1015: THEN
1016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1017: END IF;
1018: */

Line 1016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1012: THEN
1013: RAISE FND_API.G_EXC_ERROR;
1014: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1015: THEN
1016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1017: END IF;
1018: */
1019: END IF;
1020: END IF;

Line 1024: IF FND_API.To_Boolean( p_commit )

1020: END IF;
1021:
1022:
1023: -- Standard check of p_commit.
1024: IF FND_API.To_Boolean( p_commit )
1025: THEN
1026: COMMIT WORK;
1027: END IF;
1028:

Line 1035: WHEN FND_API.G_EXC_ERROR THEN

1031: (p_count => x_msg_count,
1032: p_data => x_msg_data
1033: );
1034: EXCEPTION
1035: WHEN FND_API.G_EXC_ERROR THEN
1036: ROLLBACK TO Update_RuleAttribute;
1037: x_return_status := FND_API.G_RET_STS_ERROR ;
1038: FND_MSG_PUB.Count_And_Get
1039: (p_count => x_msg_count,

Line 1037: x_return_status := FND_API.G_RET_STS_ERROR ;

1033: );
1034: EXCEPTION
1035: WHEN FND_API.G_EXC_ERROR THEN
1036: ROLLBACK TO Update_RuleAttribute;
1037: x_return_status := FND_API.G_RET_STS_ERROR ;
1038: FND_MSG_PUB.Count_And_Get
1039: (p_count => x_msg_count,
1040: p_data => x_msg_data,
1041: p_encoded => fnd_api.g_false

Line 1041: p_encoded => fnd_api.g_false

1037: x_return_status := FND_API.G_RET_STS_ERROR ;
1038: FND_MSG_PUB.Count_And_Get
1039: (p_count => x_msg_count,
1040: p_data => x_msg_data,
1041: p_encoded => fnd_api.g_false
1042: );
1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1044: ROLLBACK TO Update_RuleAttribute;
1045: x_loading_status := 'UNEXPECTED_ERR';

Line 1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1039: (p_count => x_msg_count,
1040: p_data => x_msg_data,
1041: p_encoded => fnd_api.g_false
1042: );
1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1044: ROLLBACK TO Update_RuleAttribute;
1045: x_loading_status := 'UNEXPECTED_ERR';
1046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1047: FND_MSG_PUB.Count_And_Get

Line 1046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1042: );
1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1044: ROLLBACK TO Update_RuleAttribute;
1045: x_loading_status := 'UNEXPECTED_ERR';
1046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1047: FND_MSG_PUB.Count_And_Get
1048: (p_count => x_msg_count,
1049: p_data => x_msg_data,
1050: p_encoded => fnd_api.g_false

Line 1050: p_encoded => fnd_api.g_false

1046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1047: FND_MSG_PUB.Count_And_Get
1048: (p_count => x_msg_count,
1049: p_data => x_msg_data,
1050: p_encoded => fnd_api.g_false
1051: );
1052: WHEN OTHERS THEN
1053: ROLLBACK TO Update_RuleAttribute;
1054: x_loading_status := 'UNEXPECTED_ERR';

Line 1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1051: );
1052: WHEN OTHERS THEN
1053: ROLLBACK TO Update_RuleAttribute;
1054: x_loading_status := 'UNEXPECTED_ERR';
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1056: IF FND_MSG_PUB.Check_Msg_Level
1057: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1058: THEN
1059: FND_MSG_PUB.Add_Exc_Msg

Line 1067: p_encoded => fnd_api.g_false

1063: END IF;
1064: FND_MSG_PUB.Count_And_Get
1065: (p_count => x_msg_count,
1066: p_data => x_msg_data,
1067: p_encoded => fnd_api.g_false
1068: );
1069:
1070: END;
1071:

Line 1081: -- Default = FND_API.G_FALSE

1077: -- Pre-reqs : None.
1078: -- Parameters :
1079: -- IN : p_api_version IN NUMBER Required
1080: -- p_init_msg_list IN VARCHAR2 Optional
1081: -- Default = FND_API.G_FALSE
1082: -- p_commit IN VARCHAR2 Optional
1083: -- Default = FND_API.G_FALSE
1084: -- p_validation_level IN NUMBER Optional
1085: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1083: -- Default = FND_API.G_FALSE

1079: -- IN : p_api_version IN NUMBER Required
1080: -- p_init_msg_list IN VARCHAR2 Optional
1081: -- Default = FND_API.G_FALSE
1082: -- p_commit IN VARCHAR2 Optional
1083: -- Default = FND_API.G_FALSE
1084: -- p_validation_level IN NUMBER Optional
1085: -- Default = FND_API.G_VALID_LEVEL_FULL
1086: -- p_rule_rec_type IN
1087: -- CN_RuleAttribute_PUB.rule_rec_type

Line 1085: -- Default = FND_API.G_VALID_LEVEL_FULL

1081: -- Default = FND_API.G_FALSE
1082: -- p_commit IN VARCHAR2 Optional
1083: -- Default = FND_API.G_FALSE
1084: -- p_validation_level IN NUMBER Optional
1085: -- Default = FND_API.G_VALID_LEVEL_FULL
1086: -- p_rule_rec_type IN
1087: -- CN_RuleAttribute_PUB.rule_rec_type
1088: -- p_rule_attr_rec_type IN
1089: -- CN_RuleAttribute_PUB.rule_attr_rec_type

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

1108:
1109:
1110: PROCEDURE Delete_RuleAttribute
1111: ( p_api_version IN NUMBER,
1112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1113: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1115: x_return_status OUT NOCOPY VARCHAR2,
1116: x_msg_count OUT NOCOPY NUMBER,

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

1109:
1110: PROCEDURE Delete_RuleAttribute
1111: ( p_api_version IN NUMBER,
1112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1113: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1115: x_return_status OUT NOCOPY VARCHAR2,
1116: x_msg_count OUT NOCOPY NUMBER,
1117: x_msg_data OUT NOCOPY VARCHAR2,

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

1110: PROCEDURE Delete_RuleAttribute
1111: ( p_api_version IN NUMBER,
1112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1113: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1115: x_return_status OUT NOCOPY VARCHAR2,
1116: x_msg_count OUT NOCOPY NUMBER,
1117: x_msg_data OUT NOCOPY VARCHAR2,
1118: x_loading_status OUT NOCOPY VARCHAR2,

Line 1161: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1157:
1158: -- Standard Start of API savepoint
1159: SAVEPOINT Delete_RuleAttribute;
1160: -- Standard call to check for call compatibility.
1161: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1162: p_api_version,
1163: l_api_name,
1164: G_PKG_NAME )
1165: THEN

Line 1166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1162: p_api_version,
1163: l_api_name,
1164: G_PKG_NAME )
1165: THEN
1166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1167: END IF;
1168:
1169: -- Initialize message list if p_init_msg_list is set to TRUE.
1170: IF FND_API.to_Boolean( p_init_msg_list )

Line 1170: IF FND_API.to_Boolean( p_init_msg_list )

1166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1167: END IF;
1168:
1169: -- Initialize message list if p_init_msg_list is set to TRUE.
1170: IF FND_API.to_Boolean( p_init_msg_list )
1171: THEN
1172: FND_MSG_PUB.initialize;
1173: END IF;
1174:

Line 1176: x_return_status := FND_API.G_RET_STS_SUCCESS;

1172: FND_MSG_PUB.initialize;
1173: END IF;
1174:
1175: -- Initialize API return status to success
1176: x_return_status := FND_API.G_RET_STS_SUCCESS;
1177:
1178:
1179: --
1180: -- Assign the parameter to a local variable

Line 1206: IF x_return_status = fnd_api.g_ret_sts_error

1202: x_msg_data => x_msg_data,
1203: x_loading_status => x_loading_status,
1204: p_ruleattribute_rec => l_ruleattribute_rec);
1205:
1206: IF x_return_status = fnd_api.g_ret_sts_error
1207: THEN
1208: RAISE fnd_api.g_exc_error;
1209: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1210: THEN

Line 1208: RAISE fnd_api.g_exc_error;

1204: p_ruleattribute_rec => l_ruleattribute_rec);
1205:
1206: IF x_return_status = fnd_api.g_ret_sts_error
1207: THEN
1208: RAISE fnd_api.g_exc_error;
1209: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1210: THEN
1211: RAISE fnd_api.g_exc_unexpected_error;
1212: END IF;

Line 1209: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

1205:
1206: IF x_return_status = fnd_api.g_ret_sts_error
1207: THEN
1208: RAISE fnd_api.g_exc_error;
1209: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1210: THEN
1211: RAISE fnd_api.g_exc_unexpected_error;
1212: END IF;
1213: END IF;

Line 1211: RAISE fnd_api.g_exc_unexpected_error;

1207: THEN
1208: RAISE fnd_api.g_exc_error;
1209: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1210: THEN
1211: RAISE fnd_api.g_exc_unexpected_error;
1212: END IF;
1213: END IF;
1214:
1215: -- vertical industry pre-processing section

Line 1232: IF x_return_status = fnd_api.g_ret_sts_error

1228: x_msg_data => x_msg_data,
1229: x_loading_status => x_loading_status,
1230: p_ruleattribute_rec => l_ruleattribute_rec);
1231:
1232: IF x_return_status = fnd_api.g_ret_sts_error
1233: THEN
1234: RAISE fnd_api.g_exc_error;
1235: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1236: THEN

Line 1234: RAISE fnd_api.g_exc_error;

1230: p_ruleattribute_rec => l_ruleattribute_rec);
1231:
1232: IF x_return_status = fnd_api.g_ret_sts_error
1233: THEN
1234: RAISE fnd_api.g_exc_error;
1235: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1236: THEN
1237: RAISE fnd_api.g_exc_unexpected_error;
1238: END IF;

Line 1235: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

1231:
1232: IF x_return_status = fnd_api.g_ret_sts_error
1233: THEN
1234: RAISE fnd_api.g_exc_error;
1235: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1236: THEN
1237: RAISE fnd_api.g_exc_unexpected_error;
1238: END IF;
1239: END IF;

Line 1237: RAISE fnd_api.g_exc_unexpected_error;

1233: THEN
1234: RAISE fnd_api.g_exc_error;
1235: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1236: THEN
1237: RAISE fnd_api.g_exc_unexpected_error;
1238: END IF;
1239: END IF;
1240:
1241:

Line 1250: x_loading_status) = FND_API.G_TRUE )

1246: IF (cn_api.chk_miss_null_char_para
1247: ( l_RuleAttribute_rec.ruleset_name,
1248: cn_api.get_lkup_meaning('RULESET_NAME', 'RULESET_TYPE'),
1249: x_loading_status,
1250: x_loading_status) = FND_API.G_TRUE )
1251: THEN
1252: RAISE fnd_api.g_exc_error;
1253: END IF;
1254:

Line 1252: RAISE fnd_api.g_exc_error;

1248: cn_api.get_lkup_meaning('RULESET_NAME', 'RULESET_TYPE'),
1249: x_loading_status,
1250: x_loading_status) = FND_API.G_TRUE )
1251: THEN
1252: RAISE fnd_api.g_exc_error;
1253: END IF;
1254:
1255: IF (cn_api.chk_miss_null_date_para
1256: ( l_RuleAttribute_rec.start_date,

Line 1259: x_loading_status) = FND_API.G_TRUE )

1255: IF (cn_api.chk_miss_null_date_para
1256: ( l_RuleAttribute_rec.start_date,
1257: cn_api.get_lkup_meaning('START_DATE', 'RULESET_TYPE'),
1258: x_loading_status,
1259: x_loading_status) = FND_API.G_TRUE )
1260: THEN
1261: RAISE fnd_api.g_exc_error;
1262: END IF;
1263:

Line 1261: RAISE fnd_api.g_exc_error;

1257: cn_api.get_lkup_meaning('START_DATE', 'RULESET_TYPE'),
1258: x_loading_status,
1259: x_loading_status) = FND_API.G_TRUE )
1260: THEN
1261: RAISE fnd_api.g_exc_error;
1262: END IF;
1263:
1264: IF (cn_api.chk_miss_null_date_para
1265: ( l_RuleAttribute_rec.end_date,

Line 1268: x_loading_status) = FND_API.G_TRUE )

1264: IF (cn_api.chk_miss_null_date_para
1265: ( l_RuleAttribute_rec.end_date,
1266: cn_api.get_lkup_meaning('END_DATE', 'RULESET_TYPE'),
1267: x_loading_status,
1268: x_loading_status) = FND_API.G_TRUE )
1269: THEN
1270: RAISE fnd_api.g_exc_error;
1271: END IF;
1272:

Line 1270: RAISE fnd_api.g_exc_error;

1266: cn_api.get_lkup_meaning('END_DATE', 'RULESET_TYPE'),
1267: x_loading_status,
1268: x_loading_status) = FND_API.G_TRUE )
1269: THEN
1270: RAISE fnd_api.g_exc_error;
1271: END IF;
1272:
1273: IF (cn_api.chk_miss_null_char_para
1274: ( l_RuleAttribute_rec.rule_name,

Line 1277: x_loading_status) = FND_API.G_TRUE )

1273: IF (cn_api.chk_miss_null_char_para
1274: ( l_RuleAttribute_rec.rule_name,
1275: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),
1276: x_loading_status,
1277: x_loading_status) = FND_API.G_TRUE )
1278: THEN
1279: RAISE fnd_api.g_exc_error;
1280: END IF;
1281:

Line 1279: RAISE fnd_api.g_exc_error;

1275: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),
1276: x_loading_status,
1277: x_loading_status) = FND_API.G_TRUE )
1278: THEN
1279: RAISE fnd_api.g_exc_error;
1280: END IF;
1281:
1282: IF (cn_api.chk_null_char_para
1283: ( l_RuleAttribute_rec.object_name,

Line 1286: x_loading_status) = FND_API.G_TRUE )

1282: IF (cn_api.chk_null_char_para
1283: ( l_RuleAttribute_rec.object_name,
1284: cn_api.get_lkup_meaning('OBJECT_NAME', 'RULESET_TYPE'),
1285: x_loading_status,
1286: x_loading_status) = FND_API.G_TRUE )
1287: THEN
1288: RAISE fnd_api.g_exc_error;
1289: END IF;
1290:

Line 1288: RAISE fnd_api.g_exc_error;

1284: cn_api.get_lkup_meaning('OBJECT_NAME', 'RULESET_TYPE'),
1285: x_loading_status,
1286: x_loading_status) = FND_API.G_TRUE )
1287: THEN
1288: RAISE fnd_api.g_exc_error;
1289: END IF;
1290:
1291: IF (cn_api.chk_null_char_para
1292: ( l_RuleAttribute_rec.data_flag,

Line 1295: x_loading_status) = FND_API.G_TRUE )

1291: IF (cn_api.chk_null_char_para
1292: ( l_RuleAttribute_rec.data_flag,
1293: cn_api.get_lkup_meaning('DATA_FLAG', 'RULESET_TYPE'),
1294: x_loading_status,
1295: x_loading_status) = FND_API.G_TRUE )
1296: THEN
1297: RAISE fnd_api.g_exc_error;
1298: END IF;
1299:

Line 1297: RAISE fnd_api.g_exc_error;

1293: cn_api.get_lkup_meaning('DATA_FLAG', 'RULESET_TYPE'),
1294: x_loading_status,
1295: x_loading_status) = FND_API.G_TRUE )
1296: THEN
1297: RAISE fnd_api.g_exc_error;
1298: END IF;
1299:
1300: -- l_ruleattribute_rec.object_name := p_ruleattribute_rec.object_name;
1301: SELECT object_id

Line 1326: RAISE FND_API.G_EXC_ERROR;

1322: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
1323: fnd_msg_pub.add;
1324: END IF;
1325: x_loading_status := 'CN_INVALID_RULESET';
1326: RAISE FND_API.G_EXC_ERROR;
1327: ELSE
1328: SELECT ruleset_id
1329: INTO l_ruleattribute_rec_pvt.ruleset_id
1330: FROM cn_rulesets

Line 1378: IF x_return_status = fnd_api.g_ret_sts_error

1374: p_rule_id => l_ruleattribute_rec_pvt.rule_id,
1375: p_object_version_number => l_ruleattribute_rec_pvt.object_version_number,
1376: p_attribute_rule_id => l_ruleattribute_rec_pvt.attribute_rule_id);
1377:
1378: IF x_return_status = fnd_api.g_ret_sts_error
1379: THEN
1380: RAISE fnd_api.g_exc_error;
1381: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1382: THEN

Line 1380: RAISE fnd_api.g_exc_error;

1376: p_attribute_rule_id => l_ruleattribute_rec_pvt.attribute_rule_id);
1377:
1378: IF x_return_status = fnd_api.g_ret_sts_error
1379: THEN
1380: RAISE fnd_api.g_exc_error;
1381: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1382: THEN
1383: RAISE fnd_api.g_exc_unexpected_error;
1384: END IF;

Line 1381: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

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

Line 1383: RAISE fnd_api.g_exc_unexpected_error;

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

Line 1416: IF x_return_status = fnd_api.g_ret_sts_error

1412: x_msg_data => x_msg_data,
1413: x_loading_status => x_loading_status,
1414: p_ruleattribute_rec => l_ruleattribute_rec);
1415:
1416: IF x_return_status = fnd_api.g_ret_sts_error
1417: THEN
1418: RAISE fnd_api.g_exc_error;
1419: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1420: THEN

Line 1418: RAISE fnd_api.g_exc_error;

1414: p_ruleattribute_rec => l_ruleattribute_rec);
1415:
1416: IF x_return_status = fnd_api.g_ret_sts_error
1417: THEN
1418: RAISE fnd_api.g_exc_error;
1419: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1420: THEN
1421: RAISE fnd_api.g_exc_unexpected_error;
1422: END IF;

Line 1419: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

1415:
1416: IF x_return_status = fnd_api.g_ret_sts_error
1417: THEN
1418: RAISE fnd_api.g_exc_error;
1419: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1420: THEN
1421: RAISE fnd_api.g_exc_unexpected_error;
1422: END IF;
1423: END IF;

Line 1421: RAISE fnd_api.g_exc_unexpected_error;

1417: THEN
1418: RAISE fnd_api.g_exc_error;
1419: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1420: THEN
1421: RAISE fnd_api.g_exc_unexpected_error;
1422: END IF;
1423: END IF;
1424:
1425: -- customer post processing section

Line 1442: IF x_return_status = fnd_api.g_ret_sts_error

1438: x_msg_data => x_msg_data,
1439: x_loading_status => x_loading_status,
1440: p_ruleattribute_rec => l_ruleattribute_rec);
1441:
1442: IF x_return_status = fnd_api.g_ret_sts_error
1443: THEN
1444: RAISE fnd_api.g_exc_error;
1445: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1446: THEN

Line 1444: RAISE fnd_api.g_exc_error;

1440: p_ruleattribute_rec => l_ruleattribute_rec);
1441:
1442: IF x_return_status = fnd_api.g_ret_sts_error
1443: THEN
1444: RAISE fnd_api.g_exc_error;
1445: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1446: THEN
1447: RAISE fnd_api.g_exc_unexpected_error;
1448: END IF;

Line 1445: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error

1441:
1442: IF x_return_status = fnd_api.g_ret_sts_error
1443: THEN
1444: RAISE fnd_api.g_exc_error;
1445: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1446: THEN
1447: RAISE fnd_api.g_exc_unexpected_error;
1448: END IF;
1449: END IF;

Line 1447: RAISE fnd_api.g_exc_unexpected_error;

1443: THEN
1444: RAISE fnd_api.g_exc_error;
1445: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error
1446: THEN
1447: RAISE fnd_api.g_exc_unexpected_error;
1448: END IF;
1449: END IF;
1450:
1451: -- Message generation section.

Line 1480: IF (l_return_code = FND_API.G_RET_STS_ERROR)

1476: p_action_code => 'D',
1477: p_bind_data_id => l_bind_data_id,
1478: x_return_code => l_return_code) ;
1479:
1480: IF (l_return_code = FND_API.G_RET_STS_ERROR)
1481: THEN
1482: RAISE FND_API.G_EXC_ERROR;
1483: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
1484: THEN

Line 1482: RAISE FND_API.G_EXC_ERROR;

1478: x_return_code => l_return_code) ;
1479:
1480: IF (l_return_code = FND_API.G_RET_STS_ERROR)
1481: THEN
1482: RAISE FND_API.G_EXC_ERROR;
1483: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
1484: THEN
1485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1486: END IF;

Line 1483: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )

1479:
1480: IF (l_return_code = FND_API.G_RET_STS_ERROR)
1481: THEN
1482: RAISE FND_API.G_EXC_ERROR;
1483: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
1484: THEN
1485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1486: END IF;
1487:

Line 1485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1481: THEN
1482: RAISE FND_API.G_EXC_ERROR;
1483: ELSIF (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR )
1484: THEN
1485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1486: END IF;
1487:
1488: /*
1489: -- Message generation API

Line 1499: IF (x_return_status = FND_API.G_RET_STS_ERROR)

1495: p_oai_param => null,
1496: p_oai_array => l_oai_array,
1497: x_return_code => x_return_status) ;
1498:
1499: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1500: THEN
1501: RAISE FND_API.G_EXC_ERROR;
1502: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1503: THEN

Line 1501: RAISE FND_API.G_EXC_ERROR;

1497: x_return_code => x_return_status) ;
1498:
1499: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1500: THEN
1501: RAISE FND_API.G_EXC_ERROR;
1502: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1503: THEN
1504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1505: END IF;

Line 1502: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1498:
1499: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1500: THEN
1501: RAISE FND_API.G_EXC_ERROR;
1502: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1503: THEN
1504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1505: END IF;
1506: */

Line 1504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1500: THEN
1501: RAISE FND_API.G_EXC_ERROR;
1502: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1503: THEN
1504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1505: END IF;
1506: */
1507: END IF;
1508: END IF;

Line 1512: IF FND_API.To_Boolean( p_commit )

1508: END IF;
1509:
1510:
1511: -- Standard check of p_commit.
1512: IF FND_API.To_Boolean( p_commit )
1513: THEN
1514: COMMIT WORK;
1515: END IF;
1516:

Line 1523: WHEN FND_API.G_EXC_ERROR THEN

1519: (p_count => x_msg_count,
1520: p_data => x_msg_data
1521: );
1522: EXCEPTION
1523: WHEN FND_API.G_EXC_ERROR THEN
1524: ROLLBACK TO Delete_RuleAttribute;
1525: x_return_status := FND_API.G_RET_STS_ERROR ;
1526: FND_MSG_PUB.Count_And_Get
1527: (p_count => x_msg_count,

Line 1525: x_return_status := FND_API.G_RET_STS_ERROR ;

1521: );
1522: EXCEPTION
1523: WHEN FND_API.G_EXC_ERROR THEN
1524: ROLLBACK TO Delete_RuleAttribute;
1525: x_return_status := FND_API.G_RET_STS_ERROR ;
1526: FND_MSG_PUB.Count_And_Get
1527: (p_count => x_msg_count,
1528: p_data => x_msg_data
1529: );

Line 1530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1526: FND_MSG_PUB.Count_And_Get
1527: (p_count => x_msg_count,
1528: p_data => x_msg_data
1529: );
1530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1531: ROLLBACK TO Delete_RuleAttribute;
1532: x_loading_status := 'UNEXPECTED_ERR';
1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1534: FND_MSG_PUB.Count_And_Get

Line 1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1529: );
1530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1531: ROLLBACK TO Delete_RuleAttribute;
1532: x_loading_status := 'UNEXPECTED_ERR';
1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1534: FND_MSG_PUB.Count_And_Get
1535: (p_count => x_msg_count,
1536: p_data => x_msg_data,
1537: p_encoded => fnd_api.g_false

Line 1537: p_encoded => fnd_api.g_false

1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1534: FND_MSG_PUB.Count_And_Get
1535: (p_count => x_msg_count,
1536: p_data => x_msg_data,
1537: p_encoded => fnd_api.g_false
1538: );
1539: WHEN OTHERS THEN
1540: ROLLBACK TO Delete_RuleAttribute;
1541: x_loading_status := 'UNEXPECTED_ERR';

Line 1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1538: );
1539: WHEN OTHERS THEN
1540: ROLLBACK TO Delete_RuleAttribute;
1541: x_loading_status := 'UNEXPECTED_ERR';
1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1543: IF FND_MSG_PUB.Check_Msg_Level
1544: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1545: THEN
1546: FND_MSG_PUB.Add_Exc_Msg

Line 1554: p_encoded => fnd_api.g_false

1550: END IF;
1551: FND_MSG_PUB.Count_And_Get
1552: (p_count => x_msg_count,
1553: p_data => x_msg_data,
1554: p_encoded => fnd_api.g_false
1555: );
1556: END;
1557: END CN_RuleAttribute_PUB;