DBA Data[Home] [Help]

APPS.FUN_RULE_CRITERIA_PUB dependencies on FND_MSG_PUB

Line 142: FND_MSG_PUB.ADD;

138: THEN
139:
140: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_RECORD_CHANGED');
141: FND_MESSAGE.SET_TOKEN('TABLE', 'FUN_RULE_OBJECTS');
142: FND_MSG_PUB.ADD;
143: RAISE FND_API.G_EXC_ERROR;
144: END IF;
145:
146: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 152: FND_MSG_PUB.ADD;

148: EXCEPTION WHEN NO_DATA_FOUND THEN
149: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_NO_RECORD');
150: FND_MESSAGE.SET_TOKEN('RECORD', 'FUN_RULE_OBJECTS');
151: FND_MESSAGE.SET_TOKEN('VALUE', 'rule_object_name');
152: FND_MSG_PUB.ADD;
153: RAISE FND_API.G_EXC_ERROR;
154: END;
155:
156:

Line 230: FND_MSG_PUB.initialize;

226: SAVEPOINT create_rule_criteria;
227:
228: -- initialize message list if p_init_msg_list is set to TRUE.
229: IF FND_API.to_Boolean(p_init_msg_list) THEN
230: FND_MSG_PUB.initialize;
231: END IF;
232:
233: -- initialize API return status to success.
234: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 243: FND_MSG_PUB.Count_And_Get(

239: x_criteria_id,
240: x_return_status);
241:
242: -- standard call to get message count and if count is 1, get message info.
243: FND_MSG_PUB.Count_And_Get(
244: p_encoded => FND_API.G_FALSE,
245: p_count => x_msg_count,
246: p_data => x_msg_data);
247:

Line 252: FND_MSG_PUB.Count_And_Get(

248: EXCEPTION
249: WHEN FND_API.G_EXC_ERROR THEN
250: ROLLBACK TO create_rule_criteria;
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: FND_MSG_PUB.Count_And_Get(
253: p_encoded => FND_API.G_FALSE,
254: p_count => x_msg_count,
255: p_data => x_msg_data);
256:

Line 260: FND_MSG_PUB.Count_And_Get(

256:
257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
258: ROLLBACK TO create_rule_criteria;
259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260: FND_MSG_PUB.Count_And_Get(
261: p_encoded => FND_API.G_FALSE,
262: p_count => x_msg_count,
263: p_data => x_msg_data);
264:

Line 270: FND_MSG_PUB.ADD;

266: ROLLBACK TO create_rule_criteria;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
269: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
270: FND_MSG_PUB.ADD;
271: FND_MSG_PUB.Count_And_Get(
272: p_encoded => FND_API.G_FALSE,
273: p_count => x_msg_count,
274: p_data => x_msg_data);

Line 271: FND_MSG_PUB.Count_And_Get(

267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
269: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
270: FND_MSG_PUB.ADD;
271: FND_MSG_PUB.Count_And_Get(
272: p_encoded => FND_API.G_FALSE,
273: p_count => x_msg_count,
274: p_data => x_msg_data);
275: END create_rule_criteria;

Line 326: FND_MSG_PUB.initialize;

322: SAVEPOINT update_rule_criteria;
323:
324: -- initialize message list if p_init_msg_list is set to TRUE.
325: IF FND_API.to_Boolean(p_init_msg_list) THEN
326: FND_MSG_PUB.initialize;
327: END IF;
328: -- initialize API return status to success.
329: x_return_status := FND_API.G_RET_STS_SUCCESS;
330:

Line 356: FND_MSG_PUB.Count_And_Get(

352:
353: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
354:
355: -- standard call to get message count and if count is 1, get message info.
356: FND_MSG_PUB.Count_And_Get(
357: p_encoded => FND_API.G_FALSE,
358: p_count => x_msg_count,
359: p_data => x_msg_data);
360: END IF;

Line 366: FND_MSG_PUB.Count_And_Get(

362: EXCEPTION
363: WHEN FND_API.G_EXC_ERROR THEN
364: ROLLBACK TO update_rule_criteria;
365: x_return_status := FND_API.G_RET_STS_ERROR;
366: FND_MSG_PUB.Count_And_Get(
367: p_encoded => FND_API.G_FALSE,
368: p_count => x_msg_count,
369: p_data => x_msg_data);
370:

Line 374: FND_MSG_PUB.Count_And_Get(

370:
371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
372: ROLLBACK TO update_rule_criteria;
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
374: FND_MSG_PUB.Count_And_Get(
375: p_encoded => FND_API.G_FALSE,
376: p_count => x_msg_count,
377: p_data => x_msg_data);
378:

Line 384: FND_MSG_PUB.ADD;

380: ROLLBACK TO update_rule_criteria;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
383: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
384: FND_MSG_PUB.ADD;
385: FND_MSG_PUB.Count_And_Get(
386: p_encoded => FND_API.G_FALSE,
387: p_count => x_msg_count,
388: p_data => x_msg_data);

Line 385: FND_MSG_PUB.Count_And_Get(

381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
383: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
384: FND_MSG_PUB.ADD;
385: FND_MSG_PUB.Count_And_Get(
386: p_encoded => FND_API.G_FALSE,
387: p_count => x_msg_count,
388: p_data => x_msg_data);
389: END update_rule_criteria;

Line 438: FND_MSG_PUB.initialize;

434:
435: BEGIN
436: --Initialize message list if p_init_msg_list is set to TRUE.
437: IF FND_API.to_Boolean(p_init_msg_list) THEN
438: FND_MSG_PUB.initialize;
439: END IF;
440:
441: --Initialize API return status to success.
442: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 449: FND_MSG_PUB.ADD;

445: IF p_criteria_id IS NULL OR
446: p_criteria_id = FND_API.G_MISS_NUM THEN
447: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_MISSING_COLUMN' );
448: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'criteria_id' );
449: FND_MSG_PUB.ADD;
450: RAISE FND_API.G_EXC_ERROR;
451: END IF;
452:
453: x_rule_criteria_rec.criteria_id := p_criteria_id;

Line 470: FND_MSG_PUB.Count_And_Get(

466: );
467:
468:
469: --Standard call to get message count and if count is 1, get message info.
470: FND_MSG_PUB.Count_And_Get(
471: p_encoded => FND_API.G_FALSE,
472: p_count => x_msg_count,
473: p_data => x_msg_data );
474:

Line 479: FND_MSG_PUB.Count_And_Get(

475: EXCEPTION
476: WHEN FND_API.G_EXC_ERROR THEN
477: x_return_status := FND_API.G_RET_STS_ERROR;
478:
479: FND_MSG_PUB.Count_And_Get(
480: p_encoded => FND_API.G_FALSE,
481: p_count => x_msg_count,
482: p_data => x_msg_data );
483:

Line 486: FND_MSG_PUB.Count_And_Get(

482: p_data => x_msg_data );
483:
484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: FND_MSG_PUB.Count_And_Get(
487: p_encoded => FND_API.G_FALSE,
488: p_count => x_msg_count,
489: p_data => x_msg_data );
490:

Line 495: FND_MSG_PUB.ADD;

491: WHEN OTHERS THEN
492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
493: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_OTHERS_EXCEP' );
494: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
495: FND_MSG_PUB.ADD;
496:
497: FND_MSG_PUB.Count_And_Get(
498: p_encoded => FND_API.G_FALSE,
499: p_count => x_msg_count,

Line 497: FND_MSG_PUB.Count_And_Get(

493: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_OTHERS_EXCEP' );
494: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
495: FND_MSG_PUB.ADD;
496:
497: FND_MSG_PUB.Count_And_Get(
498: p_encoded => FND_API.G_FALSE,
499: p_count => x_msg_count,
500: p_data => x_msg_data );
501:

Line 553: FND_MSG_PUB.initialize;

549: SAVEPOINT delete_rule_criteria;
550:
551: -- initialize message list if p_init_msg_list is set to TRUE.
552: IF FND_API.to_Boolean(p_init_msg_list) THEN
553: FND_MSG_PUB.initialize;
554: END IF;
555:
556: -- initialize API return status to success.
557: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 566: FND_MSG_PUB.Count_And_Get(

562: );
563:
564:
565: -- standard call to get message count and if count is 1, get message info.
566: FND_MSG_PUB.Count_And_Get(
567: p_encoded => FND_API.G_FALSE,
568: p_count => x_msg_count,
569: p_data => x_msg_data);
570:

Line 576: FND_MSG_PUB.Count_And_Get(

572: EXCEPTION
573: WHEN FND_API.G_EXC_ERROR THEN
574: ROLLBACK TO delete_rule_criteria;
575: x_return_status := FND_API.G_RET_STS_ERROR;
576: FND_MSG_PUB.Count_And_Get(
577: p_encoded => FND_API.G_FALSE,
578: p_count => x_msg_count,
579: p_data => x_msg_data);
580:

Line 584: FND_MSG_PUB.Count_And_Get(

580:
581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
582: ROLLBACK TO delete_rule_criteria;
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
584: FND_MSG_PUB.Count_And_Get(
585: p_encoded => FND_API.G_FALSE,
586: p_count => x_msg_count,
587: p_data => x_msg_data);
588:

Line 594: FND_MSG_PUB.ADD;

590: ROLLBACK TO delete_rule_criteria;
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
594: FND_MSG_PUB.ADD;
595: FND_MSG_PUB.Count_And_Get(
596: p_encoded => FND_API.G_FALSE,
597: p_count => x_msg_count,
598: p_data => x_msg_data);

Line 595: FND_MSG_PUB.Count_And_Get(

591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
594: FND_MSG_PUB.ADD;
595: FND_MSG_PUB.Count_And_Get(
596: p_encoded => FND_API.G_FALSE,
597: p_count => x_msg_count,
598: p_data => x_msg_data);
599: END delete_rule_criteria;