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.FUN_RULE_CRIT_PARAMS_PUB dependencies on FND_MSG_PUB

Line 164: fnd_msg_pub.add;

160: FROM FUN_RULE_OBJECTS_B WHERE RULE_OBJECT_ID = p_to_rule_object_id;
161: EXCEPTION
162: WHEN NO_DATA_FOUND THEN
163: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_ROB');
164: fnd_msg_pub.add;
165: x_return_status := fnd_api.g_ret_sts_error;
166: END;
167:
168: FOR C_REC IN RULE_CRIT_PARAMS_VL_CUR LOOP

Line 202: FND_MSG_PUB.Count_And_Get(

198:
199: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
200:
201: -- standard call to get message count and if count is 1, get message info.
202: FND_MSG_PUB.Count_And_Get(
203: p_encoded => FND_API.G_FALSE,
204: p_count => x_msg_count,
205: p_data => x_msg_data);
206: END IF;

Line 219: FND_MSG_PUB.ADD;

215: WHEN NO_DATA_FOUND THEN
216:
217: x_return_status := FND_API.G_RET_STS_ERROR;
218: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_INVALID_ROB');
219: FND_MSG_PUB.ADD;
220: FND_MSG_PUB.Count_And_Get(
221: p_encoded => FND_API.G_FALSE,
222: p_count => x_msg_count,
223: p_data => x_msg_data);

Line 220: FND_MSG_PUB.Count_And_Get(

216:
217: x_return_status := FND_API.G_RET_STS_ERROR;
218: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_INVALID_ROB');
219: FND_MSG_PUB.ADD;
220: FND_MSG_PUB.Count_And_Get(
221: p_encoded => FND_API.G_FALSE,
222: p_count => x_msg_count,
223: p_data => x_msg_data);
224: RAISE FND_API.G_EXC_ERROR;

Line 282: FND_MSG_PUB.ADD;

278: OR (p_object_version_number = l_object_version_number))
279: THEN
280: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_RECORD_CHANGED');
281: FND_MESSAGE.SET_TOKEN('TABLE', 'FUN_RULE_CRIT_PARAMS');
282: FND_MSG_PUB.ADD;
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;
285:
286: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 292: FND_MSG_PUB.ADD;

288: EXCEPTION WHEN NO_DATA_FOUND THEN
289: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_NO_RECORD');
290: FND_MESSAGE.SET_TOKEN('RECORD', 'FUN_RULE_CRIT_PARAMS');
291: FND_MESSAGE.SET_TOKEN('VALUE', 'param_name');
292: FND_MSG_PUB.ADD;
293: RAISE FND_API.G_EXC_ERROR;
294: END;
295:
296:

Line 311: FND_MSG_PUB.ADD;

307: END;
308:
309: IF(l_dummy = 'N') THEN
310: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_NO_UPDATE_PARAM');
311: FND_MSG_PUB.ADD;
312: RAISE FND_API.G_EXC_ERROR;
313: END IF;
314:
315:

Line 393: FND_MSG_PUB.initialize;

389: SAVEPOINT create_rule_crit_param;
390:
391: -- initialize message list if p_init_msg_list is set to TRUE.
392: IF FND_API.to_Boolean(p_init_msg_list) THEN
393: FND_MSG_PUB.initialize;
394: END IF;
395:
396: -- initialize API return status to success.
397: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 404: fnd_msg_pub.add;

400: IF(l_rule_crit_param_rec.flex_value_set_id IS NOT NULL) THEN
401: --Validate if the flex_calue_set_id is Valid or not.
402: IF (NOT FUN_RULE_VALIDATE_PKG.validate_flex_value_set_id (l_rule_crit_param_rec.flex_value_set_id)) THEN
403: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_VALUESET');
404: fnd_msg_pub.add;
405: x_return_status := fnd_api.g_ret_sts_error;
406: ELSE
407: l_rule_crit_param_rec.data_type := FUN_RULE_UTILITY_PKG.getValueSetDataType(l_rule_crit_param_rec.flex_value_set_id);
408: END IF;

Line 423: FND_MSG_PUB.Count_And_Get(

419: x_criteria_param_id,
420: x_return_status);
421:
422: -- standard call to get message count and if count is 1, get message info.
423: FND_MSG_PUB.Count_And_Get(
424: p_encoded => FND_API.G_FALSE,
425: p_count => x_msg_count,
426: p_data => x_msg_data);
427:

Line 434: FND_MSG_PUB.Count_And_Get(

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

Line 442: FND_MSG_PUB.Count_And_Get(

438:
439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
440: ROLLBACK TO create_rule_crit_param;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
442: FND_MSG_PUB.Count_And_Get(
443: p_encoded => FND_API.G_FALSE,
444: p_count => x_msg_count,
445: p_data => x_msg_data);
446:

Line 452: FND_MSG_PUB.ADD;

448: ROLLBACK TO create_rule_crit_param;
449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
450: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
451: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
452: FND_MSG_PUB.ADD;
453: FND_MSG_PUB.Count_And_Get(
454: p_encoded => FND_API.G_FALSE,
455: p_count => x_msg_count,
456: p_data => x_msg_data);

Line 453: FND_MSG_PUB.Count_And_Get(

449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
450: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
451: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
452: FND_MSG_PUB.ADD;
453: FND_MSG_PUB.Count_And_Get(
454: p_encoded => FND_API.G_FALSE,
455: p_count => x_msg_count,
456: p_data => x_msg_data);
457: END create_rule_crit_param;

Line 489: FND_MSG_PUB.initialize;

485: SAVEPOINT create_rule_dup_crit_param;
486:
487: -- initialize message list if p_init_msg_list is set to TRUE.
488: IF FND_API.to_Boolean(p_init_msg_list) THEN
489: FND_MSG_PUB.initialize;
490: END IF;
491:
492: -- initialize API return status to success.
493: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 502: FND_MSG_PUB.Count_And_Get(

498: p_to_rule_object_id,
499: x_return_status);
500:
501: -- standard call to get message count and if count is 1, get message info.
502: FND_MSG_PUB.Count_And_Get(
503: p_encoded => FND_API.G_FALSE,
504: p_count => x_msg_count,
505: p_data => x_msg_data);
506:

Line 513: FND_MSG_PUB.Count_And_Get(

509: EXCEPTION
510: WHEN FND_API.G_EXC_ERROR THEN
511: ROLLBACK TO create_rule_dup_crit_param;
512: x_return_status := FND_API.G_RET_STS_ERROR;
513: FND_MSG_PUB.Count_And_Get(
514: p_encoded => FND_API.G_FALSE,
515: p_count => x_msg_count,
516: p_data => x_msg_data);
517:

Line 521: FND_MSG_PUB.Count_And_Get(

517:
518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
519: ROLLBACK TO create_rule_dup_crit_param;
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521: FND_MSG_PUB.Count_And_Get(
522: p_encoded => FND_API.G_FALSE,
523: p_count => x_msg_count,
524: p_data => x_msg_data);
525:

Line 531: FND_MSG_PUB.ADD;

527: ROLLBACK TO create_rule_dup_crit_param;
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
530: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
531: FND_MSG_PUB.ADD;
532: FND_MSG_PUB.Count_And_Get(
533: p_encoded => FND_API.G_FALSE,
534: p_count => x_msg_count,
535: p_data => x_msg_data);

Line 532: FND_MSG_PUB.Count_And_Get(

528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
530: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
531: FND_MSG_PUB.ADD;
532: FND_MSG_PUB.Count_And_Get(
533: p_encoded => FND_API.G_FALSE,
534: p_count => x_msg_count,
535: p_data => x_msg_data);
536:

Line 589: FND_MSG_PUB.initialize;

585: SAVEPOINT update_rule_crit_param;
586:
587: -- initialize message list if p_init_msg_list is set to TRUE.
588: IF FND_API.to_Boolean(p_init_msg_list) THEN
589: FND_MSG_PUB.initialize;
590: END IF;
591:
592: -- initialize API return status to success.
593: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 629: FND_MSG_PUB.Count_And_Get(

625:
626: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
627:
628: -- standard call to get message count and if count is 1, get message info.
629: FND_MSG_PUB.Count_And_Get(
630: p_encoded => FND_API.G_FALSE,
631: p_count => x_msg_count,
632: p_data => x_msg_data);
633: END IF;

Line 641: FND_MSG_PUB.Count_And_Get(

637: EXCEPTION
638: WHEN FND_API.G_EXC_ERROR THEN
639: ROLLBACK TO update_rule_crit_param;
640: x_return_status := FND_API.G_RET_STS_ERROR;
641: FND_MSG_PUB.Count_And_Get(
642: p_encoded => FND_API.G_FALSE,
643: p_count => x_msg_count,
644: p_data => x_msg_data);
645:

Line 649: FND_MSG_PUB.Count_And_Get(

645:
646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
647: ROLLBACK TO update_rule_crit_param;
648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
649: FND_MSG_PUB.Count_And_Get(
650: p_encoded => FND_API.G_FALSE,
651: p_count => x_msg_count,
652: p_data => x_msg_data);
653:

Line 659: FND_MSG_PUB.ADD;

655: ROLLBACK TO update_rule_crit_param;
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
657: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
659: FND_MSG_PUB.ADD;
660: FND_MSG_PUB.Count_And_Get(
661: p_encoded => FND_API.G_FALSE,
662: p_count => x_msg_count,
663: p_data => x_msg_data);

Line 660: FND_MSG_PUB.Count_And_Get(

656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
657: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
659: FND_MSG_PUB.ADD;
660: FND_MSG_PUB.Count_And_Get(
661: p_encoded => FND_API.G_FALSE,
662: p_count => x_msg_count,
663: p_data => x_msg_data);
664: END update_rule_crit_param;

Line 713: FND_MSG_PUB.initialize;

709: BEGIN
710:
711: --Initialize message list if p_init_msg_list is set to TRUE.
712: IF FND_API.to_Boolean(p_init_msg_list) THEN
713: FND_MSG_PUB.initialize;
714: END IF;
715:
716: --Initialize API return status to success.
717: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 740: FND_MSG_PUB.Count_And_Get(

736: X_CREATED_BY_MODULE =>x_rule_crit_param_rec.created_by_module
737: );
738:
739: --Standard call to get message count and if count is 1, get message info.
740: FND_MSG_PUB.Count_And_Get(
741: p_encoded => FND_API.G_FALSE,
742: p_count => x_msg_count,
743: p_data => x_msg_data );
744:

Line 750: FND_MSG_PUB.Count_And_Get(

746: EXCEPTION
747: WHEN FND_API.G_EXC_ERROR THEN
748: x_return_status := FND_API.G_RET_STS_ERROR;
749:
750: FND_MSG_PUB.Count_And_Get(
751: p_encoded => FND_API.G_FALSE,
752: p_count => x_msg_count,
753: p_data => x_msg_data );
754:

Line 758: FND_MSG_PUB.Count_And_Get(

754:
755: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757:
758: FND_MSG_PUB.Count_And_Get(
759: p_encoded => FND_API.G_FALSE,
760: p_count => x_msg_count,
761: p_data => x_msg_data );
762:

Line 768: FND_MSG_PUB.ADD;

764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
765:
766: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_OTHERS_EXCEP' );
767: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
768: FND_MSG_PUB.ADD;
769:
770: FND_MSG_PUB.Count_And_Get(
771: p_encoded => FND_API.G_FALSE,
772: p_count => x_msg_count,

Line 770: FND_MSG_PUB.Count_And_Get(

766: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_OTHERS_EXCEP' );
767: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
768: FND_MSG_PUB.ADD;
769:
770: FND_MSG_PUB.Count_And_Get(
771: p_encoded => FND_API.G_FALSE,
772: p_count => x_msg_count,
773: p_data => x_msg_data );
774:

Line 826: FND_MSG_PUB.initialize;

822: SAVEPOINT delete_rule_crit_param;
823:
824: -- initialize message list if p_init_msg_list is set to TRUE.
825: IF FND_API.to_Boolean(p_init_msg_list) THEN
826: FND_MSG_PUB.initialize;
827: END IF;
828:
829: -- initialize API return status to success.
830: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 839: FND_MSG_PUB.Count_And_Get(

835: );
836:
837:
838: -- standard call to get message count and if count is 1, get message info.
839: FND_MSG_PUB.Count_And_Get(
840: p_encoded => FND_API.G_FALSE,
841: p_count => x_msg_count,
842: p_data => x_msg_data);
843:

Line 849: FND_MSG_PUB.Count_And_Get(

845: EXCEPTION
846: WHEN FND_API.G_EXC_ERROR THEN
847: ROLLBACK TO delete_rule_crit_param;
848: x_return_status := FND_API.G_RET_STS_ERROR;
849: FND_MSG_PUB.Count_And_Get(
850: p_encoded => FND_API.G_FALSE,
851: p_count => x_msg_count,
852: p_data => x_msg_data);
853:

Line 857: FND_MSG_PUB.Count_And_Get(

853:
854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
855: ROLLBACK TO delete_rule_crit_param;
856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
857: FND_MSG_PUB.Count_And_Get(
858: p_encoded => FND_API.G_FALSE,
859: p_count => x_msg_count,
860: p_data => x_msg_data);
861:

Line 867: FND_MSG_PUB.ADD;

863: ROLLBACK TO delete_rule_crit_param;
864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
865: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
866: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
867: FND_MSG_PUB.ADD;
868: FND_MSG_PUB.Count_And_Get(
869: p_encoded => FND_API.G_FALSE,
870: p_count => x_msg_count,
871: p_data => x_msg_data);

Line 868: FND_MSG_PUB.Count_And_Get(

864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
865: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
866: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
867: FND_MSG_PUB.ADD;
868: FND_MSG_PUB.Count_And_Get(
869: p_encoded => FND_API.G_FALSE,
870: p_count => x_msg_count,
871: p_data => x_msg_data);
872: END delete_rule_crit_param;