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_OBJECTS_PUB dependencies on FND_MSG_PUB

Line 182: fnd_msg_pub.add;

178: --If not, then we will raise user defined exception and come out.
179:
180: IF (NOT UPPER(l_orig_rule_object_rec.use_instance_flag) = 'Y') THEN
181: fnd_message.set_name('FUN', 'FUN_RULE_NO_CREATE_ROB_INST');
182: fnd_msg_pub.add;
183: x_return_status := fnd_api.g_ret_sts_error;
184: RAISE FND_API.G_EXC_ERROR;
185: END IF;
186:

Line 255: fnd_msg_pub.add;

251:
252: EXCEPTION
253: WHEN NO_DATA_FOUND THEN
254: fnd_message.set_name('FUN', 'FUN_RULE_API_INVALID_ROB');
255: fnd_msg_pub.add;
256: x_return_status := fnd_api.g_ret_sts_error;
257: END;
258:
259: /**************************************************************************************

Line 337: FND_MSG_PUB.ADD;

333: THEN
334:
335: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_RECORD_CHANGED');
336: FND_MESSAGE.SET_TOKEN('TABLE', 'FUN_RULE_OBJECTS');
337: FND_MSG_PUB.ADD;
338: RAISE FND_API.G_EXC_ERROR;
339: END IF;
340:
341: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 347: FND_MSG_PUB.ADD;

343: EXCEPTION WHEN NO_DATA_FOUND THEN
344: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_NO_RECORD');
345: FND_MESSAGE.SET_TOKEN('RECORD', 'FUN_RULE_OBJECTS');
346: FND_MESSAGE.SET_TOKEN('VALUE', 'rule_object_id'||to_char(p_rule_object_rec.rule_object_id));
347: FND_MSG_PUB.ADD;
348: RAISE FND_API.G_EXC_ERROR;
349: END;
350:
351: -- call for validations.

Line 448: FND_MSG_PUB.initialize;

444: SAVEPOINT create_rule_objects;
445:
446: -- initialize message list if p_init_msg_list is set to TRUE.
447: IF FND_API.to_Boolean(p_init_msg_list) THEN
448: FND_MSG_PUB.initialize;
449: END IF;
450:
451: -- initialize API return status to success.
452: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 462: FND_MSG_PUB.Count_And_Get(

458: l_rule_object_rec.rule_object_id,
459: x_return_status);
460:
461: -- standard call to get message count and if count is 1, get message info.
462: FND_MSG_PUB.Count_And_Get(
463: p_encoded => FND_API.G_FALSE,
464: p_count => x_msg_count,
465: p_data => x_msg_data);
466:

Line 471: FND_MSG_PUB.Count_And_Get(

467: EXCEPTION
468: WHEN FND_API.G_EXC_ERROR THEN
469: ROLLBACK TO create_rule_objects;
470: x_return_status := FND_API.G_RET_STS_ERROR;
471: FND_MSG_PUB.Count_And_Get(
472: p_encoded => FND_API.G_FALSE,
473: p_count => x_msg_count,
474: p_data => x_msg_data);
475: x_msg_data := FND_MSG_PUB.Get_Detail;

Line 475: x_msg_data := FND_MSG_PUB.Get_Detail;

471: FND_MSG_PUB.Count_And_Get(
472: p_encoded => FND_API.G_FALSE,
473: p_count => x_msg_count,
474: p_data => x_msg_data);
475: x_msg_data := FND_MSG_PUB.Get_Detail;
476:
477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
478: ROLLBACK TO create_rule_objects;
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 480: FND_MSG_PUB.Count_And_Get(

476:
477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
478: ROLLBACK TO create_rule_objects;
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480: FND_MSG_PUB.Count_And_Get(
481: p_encoded => FND_API.G_FALSE,
482: p_count => x_msg_count,
483: p_data => x_msg_data);
484: x_msg_data := FND_MSG_PUB.Get_Detail;

Line 484: x_msg_data := FND_MSG_PUB.Get_Detail;

480: FND_MSG_PUB.Count_And_Get(
481: p_encoded => FND_API.G_FALSE,
482: p_count => x_msg_count,
483: p_data => x_msg_data);
484: x_msg_data := FND_MSG_PUB.Get_Detail;
485: WHEN OTHERS THEN
486: ROLLBACK TO create_rule_objects;
487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
488: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');

Line 490: FND_MSG_PUB.ADD;

486: ROLLBACK TO create_rule_objects;
487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
488: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
489: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
490: FND_MSG_PUB.ADD;
491: FND_MSG_PUB.Count_And_Get(
492: p_encoded => FND_API.G_FALSE,
493: p_count => x_msg_count,
494: p_data => x_msg_data);

Line 491: FND_MSG_PUB.Count_And_Get(

487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
488: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
489: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
490: FND_MSG_PUB.ADD;
491: FND_MSG_PUB.Count_And_Get(
492: p_encoded => FND_API.G_FALSE,
493: p_count => x_msg_count,
494: p_data => x_msg_data);
495: x_msg_data := FND_MSG_PUB.Get_Detail;

Line 495: x_msg_data := FND_MSG_PUB.Get_Detail;

491: FND_MSG_PUB.Count_And_Get(
492: p_encoded => FND_API.G_FALSE,
493: p_count => x_msg_count,
494: p_data => x_msg_data);
495: x_msg_data := FND_MSG_PUB.Get_Detail;
496: END create_rule_object;
497:
498: /**
499: * Use this routine to create a rule object instance to be used for rule partitioning.

Line 535: FND_MSG_PUB.initialize;

531: SAVEPOINT create_rule_object_instance;
532:
533: -- initialize message list if p_init_msg_list is set to TRUE.
534: IF FND_API.to_Boolean(p_init_msg_list) THEN
535: FND_MSG_PUB.initialize;
536: END IF;
537:
538: -- initialize API return status to success.
539: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 576: FND_MSG_PUB.Count_And_Get(

572: x_rule_object_id,
573: x_return_status);
574: END IF;
575: -- standard call to get message count and if count is 1, get message info.
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: EXCEPTION

Line 584: FND_MSG_PUB.Count_And_Get(

580: EXCEPTION
581: WHEN FND_API.G_EXC_ERROR THEN
582: ROLLBACK TO create_rule_object_instance;
583: x_return_status := FND_API.G_RET_STS_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: x_msg_data := FND_MSG_PUB.Get_Detail;

Line 588: x_msg_data := FND_MSG_PUB.Get_Detail;

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: x_msg_data := FND_MSG_PUB.Get_Detail;
589:
590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
591: ROLLBACK TO create_rule_object_instance;
592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 593: FND_MSG_PUB.Count_And_Get(

589:
590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
591: ROLLBACK TO create_rule_object_instance;
592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
593: FND_MSG_PUB.Count_And_Get(
594: p_encoded => FND_API.G_FALSE,
595: p_count => x_msg_count,
596: p_data => x_msg_data);
597: x_msg_data := FND_MSG_PUB.Get_Detail;

Line 597: x_msg_data := FND_MSG_PUB.Get_Detail;

593: FND_MSG_PUB.Count_And_Get(
594: p_encoded => FND_API.G_FALSE,
595: p_count => x_msg_count,
596: p_data => x_msg_data);
597: x_msg_data := FND_MSG_PUB.Get_Detail;
598: WHEN OTHERS THEN
599: ROLLBACK TO create_rule_object_instance;
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');

Line 603: FND_MSG_PUB.ADD;

599: ROLLBACK TO create_rule_object_instance;
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
603: FND_MSG_PUB.ADD;
604: FND_MSG_PUB.Count_And_Get(
605: p_encoded => FND_API.G_FALSE,
606: p_count => x_msg_count,
607: p_data => x_msg_data);

Line 604: FND_MSG_PUB.Count_And_Get(

600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
603: FND_MSG_PUB.ADD;
604: FND_MSG_PUB.Count_And_Get(
605: p_encoded => FND_API.G_FALSE,
606: p_count => x_msg_count,
607: p_data => x_msg_data);
608: x_msg_data := FND_MSG_PUB.Get_Detail;

Line 608: x_msg_data := FND_MSG_PUB.Get_Detail;

604: FND_MSG_PUB.Count_And_Get(
605: p_encoded => FND_API.G_FALSE,
606: p_count => x_msg_count,
607: p_data => x_msg_data);
608: x_msg_data := FND_MSG_PUB.Get_Detail;
609:
610: END create_rule_object_instance;
611:
612: /**

Line 690: FND_MSG_PUB.initialize;

686: SAVEPOINT update_rule_objects;
687:
688: -- initialize message list if p_init_msg_list is set to TRUE.
689: IF FND_API.to_Boolean(p_init_msg_list) THEN
690: FND_MSG_PUB.initialize;
691: END IF;
692:
693: -- initialize API return status to success.
694: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 727: FND_MSG_PUB.Count_And_Get(

723:
724: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
725:
726: -- standard call to get message count and if count is 1, get message info.
727: FND_MSG_PUB.Count_And_Get(
728: p_encoded => FND_API.G_FALSE,
729: p_count => x_msg_count,
730: p_data => x_msg_data);
731: END IF;

Line 782: FND_MSG_PUB.Count_And_Get(

778:
779: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
780:
781: -- standard call to get message count and if count is 1, get message info.
782: FND_MSG_PUB.Count_And_Get(
783: p_encoded => FND_API.G_FALSE,
784: p_count => x_msg_count,
785: p_data => x_msg_data);
786: END IF;

Line 796: FND_MSG_PUB.Count_And_Get(

792: EXCEPTION
793: WHEN FND_API.G_EXC_ERROR THEN
794: ROLLBACK TO update_rule_objects;
795: x_return_status := FND_API.G_RET_STS_ERROR;
796: FND_MSG_PUB.Count_And_Get(
797: p_encoded => FND_API.G_FALSE,
798: p_count => x_msg_count,
799: p_data => x_msg_data);
800:

Line 804: FND_MSG_PUB.Count_And_Get(

800:
801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
802: ROLLBACK TO update_rule_objects;
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
804: FND_MSG_PUB.Count_And_Get(
805: p_encoded => FND_API.G_FALSE,
806: p_count => x_msg_count,
807: p_data => x_msg_data);
808:

Line 814: FND_MSG_PUB.ADD;

810: ROLLBACK TO update_rule_objects;
811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
812: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
813: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
814: FND_MSG_PUB.ADD;
815: FND_MSG_PUB.Count_And_Get(
816: p_encoded => FND_API.G_FALSE,
817: p_count => x_msg_count,
818: p_data => x_msg_data);

Line 815: FND_MSG_PUB.Count_And_Get(

811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
812: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
813: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
814: FND_MSG_PUB.ADD;
815: FND_MSG_PUB.Count_And_Get(
816: p_encoded => FND_API.G_FALSE,
817: p_count => x_msg_count,
818: p_data => x_msg_data);
819: END update_rule_object;

Line 870: FND_MSG_PUB.initialize;

866: BEGIN
867:
868: --Initialize message list if p_init_msg_list is set to TRUE.
869: IF FND_API.to_Boolean(p_init_msg_list) THEN
870: FND_MSG_PUB.initialize;
871: END IF;
872:
873: --Initialize API return status to success.
874: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 881: FND_MSG_PUB.ADD;

877: IF p_rule_object_name IS NULL OR
878: p_rule_object_name = FND_API.G_MISS_CHAR THEN
879: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_MISSING_COLUMN' );
880: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'rule_object_name' );
881: FND_MSG_PUB.ADD;
882: RAISE FND_API.G_EXC_ERROR;
883: END IF;
884:
885:

Line 915: FND_MSG_PUB.Count_And_Get(

911: );
912:
913:
914: --Standard call to get message count and if count is 1, get message info.
915: FND_MSG_PUB.Count_And_Get(
916: p_encoded => FND_API.G_FALSE,
917: p_count => x_msg_count,
918: p_data => x_msg_data );
919:

Line 924: FND_MSG_PUB.Count_And_Get(

920: EXCEPTION
921: WHEN FND_API.G_EXC_ERROR THEN
922: x_return_status := FND_API.G_RET_STS_ERROR;
923:
924: FND_MSG_PUB.Count_And_Get(
925: p_encoded => FND_API.G_FALSE,
926: p_count => x_msg_count,
927: p_data => x_msg_data );
928:

Line 932: FND_MSG_PUB.Count_And_Get(

928:
929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
931:
932: FND_MSG_PUB.Count_And_Get(
933: p_encoded => FND_API.G_FALSE,
934: p_count => x_msg_count,
935: p_data => x_msg_data );
936:

Line 942: FND_MSG_PUB.ADD;

938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
939:
940: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_OTHERS_EXCEP' );
941: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
942: FND_MSG_PUB.ADD;
943:
944: FND_MSG_PUB.Count_And_Get(
945: p_encoded => FND_API.G_FALSE,
946: p_count => x_msg_count,

Line 944: FND_MSG_PUB.Count_And_Get(

940: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_OTHERS_EXCEP' );
941: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
942: FND_MSG_PUB.ADD;
943:
944: FND_MSG_PUB.Count_And_Get(
945: p_encoded => FND_API.G_FALSE,
946: p_count => x_msg_count,
947: p_data => x_msg_data );
948:

Line 996: FND_MSG_PUB.initialize;

992: BEGIN
993:
994: --Initialize message list if p_init_msg_list is set to TRUE.
995: IF FND_API.to_Boolean(p_init_msg_list) THEN
996: FND_MSG_PUB.initialize;
997: END IF;
998:
999: --Initialize API return status to success.
1000: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1007: FND_MSG_PUB.ADD;

1003: IF p_rule_object_id IS NULL OR
1004: p_rule_object_id = FND_API.G_MISS_NUM THEN
1005: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_MISSING_COLUMN' );
1006: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'rule_object_id' );
1007: FND_MSG_PUB.ADD;
1008: RAISE FND_API.G_EXC_ERROR;
1009: END IF;
1010:
1011:

Line 1038: FND_MSG_PUB.Count_And_Get(

1034: );
1035:
1036:
1037: --Standard call to get message count and if count is 1, get message info.
1038: FND_MSG_PUB.Count_And_Get(
1039: p_encoded => FND_API.G_FALSE,
1040: p_count => x_msg_count,
1041: p_data => x_msg_data );
1042:

Line 1047: FND_MSG_PUB.Count_And_Get(

1043: EXCEPTION
1044: WHEN FND_API.G_EXC_ERROR THEN
1045: x_return_status := FND_API.G_RET_STS_ERROR;
1046:
1047: FND_MSG_PUB.Count_And_Get(
1048: p_encoded => FND_API.G_FALSE,
1049: p_count => x_msg_count,
1050: p_data => x_msg_data );
1051:

Line 1055: FND_MSG_PUB.Count_And_Get(

1051:
1052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1054:
1055: FND_MSG_PUB.Count_And_Get(
1056: p_encoded => FND_API.G_FALSE,
1057: p_count => x_msg_count,
1058: p_data => x_msg_data );
1059:

Line 1065: FND_MSG_PUB.ADD;

1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1062:
1063: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_OTHERS_EXCEP' );
1064: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1065: FND_MSG_PUB.ADD;
1066:
1067: FND_MSG_PUB.Count_And_Get(
1068: p_encoded => FND_API.G_FALSE,
1069: p_count => x_msg_count,

Line 1067: FND_MSG_PUB.Count_And_Get(

1063: FND_MESSAGE.SET_NAME( 'FUN', 'FUN_RULE_API_OTHERS_EXCEP' );
1064: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1065: FND_MSG_PUB.ADD;
1066:
1067: FND_MSG_PUB.Count_And_Get(
1068: p_encoded => FND_API.G_FALSE,
1069: p_count => x_msg_count,
1070: p_data => x_msg_data );
1071:

Line 1148: FND_MSG_PUB.ADD;

1144:
1145: EXCEPTION
1146: WHEN NO_DATA_FOUND THEN
1147: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_INVALID_ROB');
1148: FND_MSG_PUB.ADD;
1149: RAISE FND_API.G_EXC_ERROR;
1150: END;
1151:
1152: --Instead of calling the delete apis of the tables for each record, from performance point of view

Line 1216: FND_MSG_PUB.initialize;

1212: RULE_OBJECT_NAME = P_RULE_OBJECT_NAME);
1213:
1214: -- initialize message list if p_init_msg_list is set to TRUE.
1215: IF FND_API.to_Boolean(p_init_msg_list) THEN
1216: FND_MSG_PUB.initialize;
1217: END IF;
1218:
1219: -- initialize API return status to success.
1220: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1251: FND_MSG_PUB.Count_And_Get(

1247:
1248: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1249:
1250: -- standard call to get message count and if count is 1, get message info.
1251: FND_MSG_PUB.Count_And_Get(
1252: p_encoded => FND_API.G_FALSE,
1253: p_count => x_msg_count,
1254: p_data => x_msg_data);
1255: END IF;

Line 1260: FND_MSG_PUB.Count_And_Get(

1256:
1257: END LOOP;
1258:
1259: -- standard call to get message count and if count is 1, get message info.
1260: FND_MSG_PUB.Count_And_Get(
1261: p_encoded => FND_API.G_FALSE,
1262: p_count => x_msg_count,
1263: p_data => x_msg_data);
1264:

Line 1269: FND_MSG_PUB.Count_And_Get(

1265: EXCEPTION
1266: WHEN FND_API.G_EXC_ERROR THEN
1267: ROLLBACK TO delete_rule_object;
1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: FND_MSG_PUB.Count_And_Get(
1270: p_encoded => FND_API.G_FALSE,
1271: p_count => x_msg_count,
1272: p_data => x_msg_data);
1273:

Line 1277: FND_MSG_PUB.Count_And_Get(

1273:
1274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1275: ROLLBACK TO delete_rule_object;
1276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1277: FND_MSG_PUB.Count_And_Get(
1278: p_encoded => FND_API.G_FALSE,
1279: p_count => x_msg_count,
1280: p_data => x_msg_data);
1281:

Line 1287: FND_MSG_PUB.ADD;

1283: ROLLBACK TO delete_rule_object;
1284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1285: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
1286: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1287: FND_MSG_PUB.ADD;
1288: FND_MSG_PUB.Count_And_Get(
1289: p_encoded => FND_API.G_FALSE,
1290: p_count => x_msg_count,
1291: p_data => x_msg_data);

Line 1288: FND_MSG_PUB.Count_And_Get(

1284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1285: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
1286: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1287: FND_MSG_PUB.ADD;
1288: FND_MSG_PUB.Count_And_Get(
1289: p_encoded => FND_API.G_FALSE,
1290: p_count => x_msg_count,
1291: p_data => x_msg_data);
1292: END delete_rule_object;

Line 1347: FND_MSG_PUB.ADD;

1343: EXCEPTION
1344: WHEN NO_DATA_FOUND THEN
1345: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_NO_INSTANCE');
1346: FND_MESSAGE.SET_TOKEN('INSTANCE_LABEL' ,p_instance_label);
1347: FND_MSG_PUB.ADD;
1348: RAISE FND_API.G_EXC_ERROR;
1349: END;
1350:
1351: --Instead of calling the delete apis of the tables for each record, from performance point of view

Line 1484: FND_MSG_PUB.initialize;

1480:
1481:
1482: -- initialize message list if p_init_msg_list is set to TRUE.
1483: IF FND_API.to_Boolean(p_init_msg_list) THEN
1484: FND_MSG_PUB.initialize;
1485: END IF;
1486:
1487: -- initialize API return status to success.
1488: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1496: FND_MSG_PUB.Count_And_Get(

1492: X_RULE_OBJECT_ID =>l_rule_object_id
1493: );
1494:
1495: -- standard call to get message count and if count is 1, get message info.
1496: FND_MSG_PUB.Count_And_Get(
1497: p_encoded => FND_API.G_FALSE,
1498: p_count => x_msg_count,
1499: p_data => x_msg_data);
1500:

Line 1505: FND_MSG_PUB.Count_And_Get(

1501: EXCEPTION
1502: WHEN FND_API.G_EXC_ERROR THEN
1503: ROLLBACK TO delete_rule_object_instance;
1504: x_return_status := FND_API.G_RET_STS_ERROR;
1505: FND_MSG_PUB.Count_And_Get(
1506: p_encoded => FND_API.G_FALSE,
1507: p_count => x_msg_count,
1508: p_data => x_msg_data);
1509:

Line 1513: FND_MSG_PUB.Count_And_Get(

1509:
1510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1511: ROLLBACK TO delete_rule_object_instance;
1512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1513: FND_MSG_PUB.Count_And_Get(
1514: p_encoded => FND_API.G_FALSE,
1515: p_count => x_msg_count,
1516: p_data => x_msg_data);
1517:

Line 1523: FND_MSG_PUB.ADD;

1519: ROLLBACK TO delete_rule_object_instance;
1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1521: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
1522: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1523: FND_MSG_PUB.ADD;
1524: FND_MSG_PUB.Count_And_Get(
1525: p_encoded => FND_API.G_FALSE,
1526: p_count => x_msg_count,
1527: p_data => x_msg_data);

Line 1524: FND_MSG_PUB.Count_And_Get(

1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1521: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
1522: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1523: FND_MSG_PUB.ADD;
1524: FND_MSG_PUB.Count_And_Get(
1525: p_encoded => FND_API.G_FALSE,
1526: p_count => x_msg_count,
1527: p_data => x_msg_data);
1528: END delete_rule_object_instance;

Line 1786: FND_MSG_PUB.initialize;

1782: SAVEPOINT convert_use_instance;
1783:
1784: -- initialize message list if p_init_msg_list is set to TRUE.
1785: IF FND_API.to_Boolean(p_init_msg_list) THEN
1786: FND_MSG_PUB.initialize;
1787: END IF;
1788:
1789: -- initialize API return status to success.
1790: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1798: fnd_msg_pub.add;

1794: */
1795:
1796: IF (FUN_RULE_UTILITY_PKG.IS_USE_INSTANCE(p_rule_object_id)) THEN
1797: fnd_message.set_name('FUN', 'FUN_RULE_NO_CONV_ROB_INST');
1798: fnd_msg_pub.add;
1799: x_return_status := fnd_api.g_ret_sts_error;
1800: RAISE FND_API.G_EXC_ERROR;
1801: END IF;
1802:

Line 1910: fnd_msg_pub.add;

1906: ELSE
1907: --Invalid P_USE_INSTANCE_FLAG
1908:
1909: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_INST_FLAG');
1910: fnd_msg_pub.add;
1911: x_return_status := fnd_api.g_ret_sts_error;
1912: RAISE FND_API.G_EXC_ERROR;
1913: END IF;
1914:

Line 1919: FND_MSG_PUB.Count_And_Get(

1915: EXCEPTION
1916: WHEN FND_API.G_EXC_ERROR THEN
1917: ROLLBACK TO convert_use_instance;
1918: x_return_status := FND_API.G_RET_STS_ERROR;
1919: FND_MSG_PUB.Count_And_Get(
1920: p_encoded => FND_API.G_FALSE,
1921: p_count => x_msg_count,
1922: p_data => x_msg_data);
1923: x_msg_data := FND_MSG_PUB.Get_Detail;

Line 1923: x_msg_data := FND_MSG_PUB.Get_Detail;

1919: FND_MSG_PUB.Count_And_Get(
1920: p_encoded => FND_API.G_FALSE,
1921: p_count => x_msg_count,
1922: p_data => x_msg_data);
1923: x_msg_data := FND_MSG_PUB.Get_Detail;
1924:
1925: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1926: ROLLBACK TO convert_use_instance;
1927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1928: FND_MSG_PUB.Count_And_Get(

1924:
1925: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1926: ROLLBACK TO convert_use_instance;
1927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1928: FND_MSG_PUB.Count_And_Get(
1929: p_encoded => FND_API.G_FALSE,
1930: p_count => x_msg_count,
1931: p_data => x_msg_data);
1932: x_msg_data := FND_MSG_PUB.Get_Detail;

Line 1932: x_msg_data := FND_MSG_PUB.Get_Detail;

1928: FND_MSG_PUB.Count_And_Get(
1929: p_encoded => FND_API.G_FALSE,
1930: p_count => x_msg_count,
1931: p_data => x_msg_data);
1932: x_msg_data := FND_MSG_PUB.Get_Detail;
1933: WHEN OTHERS THEN
1934: ROLLBACK TO convert_use_instance;
1935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1936: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');

Line 1938: FND_MSG_PUB.ADD;

1934: ROLLBACK TO convert_use_instance;
1935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1936: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
1937: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1938: FND_MSG_PUB.ADD;
1939: FND_MSG_PUB.Count_And_Get(
1940: p_encoded => FND_API.G_FALSE,
1941: p_count => x_msg_count,
1942: p_data => x_msg_data);

Line 1939: FND_MSG_PUB.Count_And_Get(

1935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1936: FND_MESSAGE.SET_NAME('FUN', 'FUN_RULE_API_OTHERS_EXCEP');
1937: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1938: FND_MSG_PUB.ADD;
1939: FND_MSG_PUB.Count_And_Get(
1940: p_encoded => FND_API.G_FALSE,
1941: p_count => x_msg_count,
1942: p_data => x_msg_data);
1943: x_msg_data := FND_MSG_PUB.Get_Detail;

Line 1943: x_msg_data := FND_MSG_PUB.Get_Detail;

1939: FND_MSG_PUB.Count_And_Get(
1940: p_encoded => FND_API.G_FALSE,
1941: p_count => x_msg_count,
1942: p_data => x_msg_data);
1943: x_msg_data := FND_MSG_PUB.Get_Detail;
1944: END convert_use_instance;
1945:
1946: END FUN_RULE_OBJECTS_PUB;