DBA Data[Home] [Help]

APPS.FUN_RULE_VALIDATE_PKG dependencies on FND_MSG_PUB

Line 301: fnd_msg_pub.add;

297: BEGIN
298: IF (p_col_val = FND_API.G_MISS_CHAR) THEN
299: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');
300: fnd_message.set_token('COLUMN', p_col_name);
301: fnd_msg_pub.add;
302: x_return_status := fnd_api.g_ret_sts_error;
303: RETURN;
304: END IF;
305:

Line 312: fnd_msg_pub.add;

308: p_col_val IS NULL )
309: THEN
310: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');
311: fnd_message.set_token('COLUMN', p_col_name);
312: fnd_msg_pub.add;
313: x_return_status := fnd_api.g_ret_sts_error;
314: END IF;
315: ELSE
316: IF ((NOT p_miss_allowed_in_u) AND

Line 321: fnd_msg_pub.add;

317: p_col_val IS NULL )
318: THEN
319: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');
320: fnd_message.set_token('COLUMN', p_col_name);
321: fnd_msg_pub.add;
322: x_return_status := fnd_api.g_ret_sts_error;
323: END IF;
324: END IF;
325: END check_mandatory_str_col;

Line 347: fnd_msg_pub.add;

343: BEGIN
344: IF (p_col_val = FND_API.G_MISS_DATE) THEN
345: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');
346: fnd_message.set_token('COLUMN', p_col_name);
347: fnd_msg_pub.add;
348: x_return_status := fnd_api.g_ret_sts_error;
349: RETURN;
350: END IF;
351:

Line 358: fnd_msg_pub.add;

354: p_col_val IS NULL )
355: THEN
356: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');
357: fnd_message.set_token('COLUMN', p_col_name);
358: fnd_msg_pub.add;
359: x_return_status := fnd_api.g_ret_sts_error;
360: END IF;
361: ELSE
362: IF ((NOT p_miss_allowed_in_u) AND

Line 367: fnd_msg_pub.add;

363: p_col_val IS NULL )
364: THEN
365: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');
366: fnd_message.set_token('COLUMN', p_col_name);
367: fnd_msg_pub.add;
368: x_return_status := fnd_api.g_ret_sts_error;
369: END IF;
370: END IF;
371: END check_mandatory_date_col;

Line 393: fnd_msg_pub.add;

389: BEGIN
390: IF (p_col_val = FND_API.G_MISS_NUM) THEN
391: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');
392: fnd_message.set_token('COLUMN', p_col_name);
393: fnd_msg_pub.add;
394: x_return_status := fnd_api.g_ret_sts_error;
395: RETURN;
396: END IF;
397:

Line 404: fnd_msg_pub.add;

400: p_col_val IS NULL )
401: THEN
402: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');
403: fnd_message.set_token('COLUMN', p_col_name);
404: fnd_msg_pub.add;
405: x_return_status := fnd_api.g_ret_sts_error;
406: END IF;
407: ELSE
408: IF ((NOT p_miss_allowed_in_u) AND

Line 413: fnd_msg_pub.add;

409: p_col_val IS NULL )
410: THEN
411: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');
412: fnd_message.set_token('COLUMN', p_col_name);
413: fnd_msg_pub.add;
414: x_return_status := fnd_api.g_ret_sts_error;
415: END IF;
416: END IF;
417: END check_mandatory_num_col;

Line 503: fnd_msg_pub.add;

499: IF c1%NOTFOUND THEN
500: fnd_message.set_name('FUN','FUN_RULE_API_INVALID_LOOKUP');
501: fnd_message.set_token('COLUMN',p_column);
502: fnd_message.set_token('LOOKUP_TYPE',p_lookup_type);
503: fnd_msg_pub.add;
504: x_return_status := fnd_api.g_ret_sts_error;
505: END IF;
506: CLOSE c1;
507: END IF;

Line 536: fnd_msg_pub.add;

532: fnd_message.set_name('FUN','FUN_RULE_API_INVALID_FK');
533: fnd_message.set_token('FK','CUSTOM_OBJECT_NAME');
534: fnd_message.set_token('COLUMN','CUSTOM_OBJECT_NAME');
535: fnd_message.set_token('TABLE','FUN_RULES_OBJECTS');
536: fnd_msg_pub.add;
537: x_return_status := fnd_api.g_ret_sts_error;
538: END IF;
539: CLOSE c_exist_rules_object;
540: END check_existence_rules_object;

Line 672: fnd_msg_pub.add;

668:
669: IF l_present > 0 THEN
670: fnd_message.set_name('FUN', 'FUN_RULE_API_ALREADY_EXISTING');
671: fnd_message.set_token('OBJECT', p_rule_objects_rec.rule_object_name);
672: fnd_msg_pub.add;
673: x_return_status := fnd_api.g_ret_sts_error;
674: END IF;
675:
676: --------------------

Line 752: fnd_msg_pub.add;

748: IF(p_rule_objects_rec.flexfield_name IS NULL OR p_rule_objects_rec.flexfield_name = '' OR
749: p_rule_objects_rec.flexfield_app_short_name IS NULL OR p_rule_objects_rec.flexfield_app_short_name = '')
750: THEN
751: fnd_message.set_name('FUN', 'FUN_RULE_NO_DFF_INFO');
752: fnd_msg_pub.add;
753: x_return_status := fnd_api.g_ret_sts_error;
754: ELSE
755: l_isFlexFieldValid := isFlexFieldValid(p_rule_objects_rec.flexfield_name , p_rule_objects_rec.flexfield_app_short_name);
756: IF(NOT l_isFlexFieldValid) THEN

Line 758: fnd_msg_pub.add;

754: ELSE
755: l_isFlexFieldValid := isFlexFieldValid(p_rule_objects_rec.flexfield_name , p_rule_objects_rec.flexfield_app_short_name);
756: IF(NOT l_isFlexFieldValid) THEN
757: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_DFF_NAME');
758: fnd_msg_pub.add;
759: x_return_status := fnd_api.g_ret_sts_error;
760: END IF;
761: END IF;
762: END IF;

Line 770: fnd_msg_pub.add;

766: IF (p_rule_objects_rec.result_type = 'VALUESET'
767: AND (p_rule_objects_rec.flex_value_set_id IS NULL OR p_rule_objects_rec.flex_value_set_id = '')
768: ) THEN
769: fnd_message.set_name('FUN', 'FUN_RULE_NO_VALUESET_INFO');
770: fnd_msg_pub.add;
771: x_return_status := fnd_api.g_ret_sts_error;
772: ELSE
773: --Validate if the flex_value_set_id is Valid or not.
774: IF (p_rule_objects_rec.result_type = 'VALUESET' AND

Line 777: fnd_msg_pub.add;

773: --Validate if the flex_value_set_id is Valid or not.
774: IF (p_rule_objects_rec.result_type = 'VALUESET' AND
775: NOT validate_flex_value_set_id(p_rule_objects_rec.flex_value_set_id)) THEN
776: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_VALUESET');
777: fnd_msg_pub.add;
778: x_return_status := fnd_api.g_ret_sts_error;
779: ELSE
780: --This call is to validate the DataType of the Valueset.
781: --Valueset should not be of TIME format.

Line 861: fnd_msg_pub.add;

857:
858: IF(p_rule_objects_rec.application_id IS NOT NULL) THEN
859: IF(NOT validate_application_id (p_rule_objects_rec.application_id)) THEN
860: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_APPL_ID');
861: fnd_msg_pub.add;
862: x_return_status := fnd_api.g_ret_sts_error;
863: END IF;
864: END IF;
865:

Line 870: fnd_msg_pub.add;

866: --Validate Default Application Id
867: IF(p_rule_objects_rec.default_application_id IS NOT NULL) THEN
868: IF(NOT validate_application_id (p_rule_objects_rec.default_application_id)) THEN
869: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_APPL_ID');
870: fnd_msg_pub.add;
871: x_return_status := fnd_api.g_ret_sts_error;
872: END IF;
873: END IF;
874:

Line 951: fnd_msg_pub.add;

947:
948: IF l_present > 0 THEN
949: fnd_message.set_name('FUN', 'FUN_RULE_API_ALREADY_EXISTING');
950: fnd_message.set_token('OBJECT', p_rule_object_instance_rec.instance_label);
951: fnd_msg_pub.add;
952: x_return_status := fnd_api.g_ret_sts_error;
953: END IF;
954:
955: --Now validate for the Rule Object Instance COlumns.

Line 985: fnd_msg_pub.add;

981:
982: IF(p_rule_object_instance_rec.org_id IS NOT NULL) THEN
983: IF(NOT validate_org_id (p_rule_object_instance_rec.org_id)) THEN
984: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_ORG_ID');
985: fnd_msg_pub.add;
986: x_return_status := fnd_api.g_ret_sts_error;
987: END IF;
988: END IF;
989:

Line 1077: fnd_msg_pub.add;

1073: FROM FUN_RULE_OBJECTS_B WHERE RULE_OBJECT_ID = p_rule_crit_params_rec.rule_object_id;
1074: EXCEPTION
1075: WHEN NO_DATA_FOUND THEN
1076: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_ROB');
1077: fnd_msg_pub.add;
1078: x_return_status := fnd_api.g_ret_sts_error;
1079: END;
1080:
1081:

Line 1301: fnd_msg_pub.add;

1297: WHERE RULE_OBJECT_ID = p_rule_details_rec.rule_object_id;
1298: EXCEPTION
1299: WHEN NO_DATA_FOUND THEN
1300: fnd_message.set_name('FUN', 'FUN_RULE_API_INVALID_RULE');
1301: fnd_msg_pub.add;
1302: x_return_status := fnd_api.g_ret_sts_error;
1303: END;
1304: END IF;
1305:

Line 1342: fnd_msg_pub.add;

1338: --Validate Default Application Id
1339: IF(p_rule_details_rec.result_application_id IS NOT NULL) THEN
1340: IF(NOT validate_application_id (p_rule_details_rec.result_application_id)) THEN
1341: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_APPL_ID');
1342: fnd_msg_pub.add;
1343: x_return_status := fnd_api.g_ret_sts_error;
1344: END IF;
1345: END IF;
1346:

Line 1583: fnd_msg_pub.add;

1579:
1580: IF l_present > 0 THEN
1581: fnd_message.set_name('FUN', 'FUN_RULE_API_ALREADY_EXISTING');
1582: fnd_message.set_token('OBJECT', p_rich_messages_rec.message_name);
1583: fnd_msg_pub.add;
1584: x_return_status := fnd_api.g_ret_sts_error;
1585: END IF;
1586:
1587:

Line 1692: fnd_msg_pub.add;

1688:
1689: IF l_error THEN
1690: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');
1691: fnd_message.set_token('COLUMN', p_column);
1692: fnd_msg_pub.add;
1693: x_return_status := fnd_api.g_ret_sts_error;
1694: END IF;
1695:
1696: END validate_mandatory;

Line 1730: fnd_msg_pub.add;

1726:
1727: IF l_error THEN
1728: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');
1729: fnd_message.set_token('COLUMN', p_column);
1730: fnd_msg_pub.add;
1731: x_return_status := fnd_api.g_ret_sts_error;
1732: END IF;
1733:
1734: END validate_mandatory;

Line 1769: fnd_msg_pub.add;

1765:
1766: IF l_error THEN
1767: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');
1768: fnd_message.set_token('COLUMN', p_column);
1769: fnd_msg_pub.add;
1770: x_return_status := fnd_api.g_ret_sts_error;
1771: END IF;
1772:
1773: END validate_mandatory;

Line 1812: fnd_msg_pub.add;

1808: IF l_error THEN
1809: IF p_raise_error = 'Y' THEN
1810: fnd_message.set_name('FUN', 'FUN_RULE_API_NONUPDATE_COLUMN');
1811: fnd_message.set_token('COLUMN', p_column);
1812: fnd_msg_pub.add;
1813: END IF;
1814: x_return_status := fnd_api.g_ret_sts_error;
1815: END IF;
1816:

Line 1855: fnd_msg_pub.add;

1851: IF l_error THEN
1852: IF p_raise_error = 'Y' THEN
1853: fnd_message.set_name('FUN', 'FUN_RULE_API_NONUPDATE_COLUMN');
1854: fnd_message.set_token('COLUMN', p_column);
1855: fnd_msg_pub.add;
1856: END IF;
1857: x_return_status := fnd_api.g_ret_sts_error;
1858: END IF;
1859:

Line 1895: fnd_msg_pub.add;

1891: IF l_error THEN
1892: fnd_message.set_name('FUN', 'FUN_RULE_API_INVALID_LOOKUP');
1893: fnd_message.set_token('COLUMN', p_column);
1894: fnd_message.set_token('LOOKUP_TYPE', p_lookup_type);
1895: fnd_msg_pub.add;
1896: x_return_status := fnd_api.g_ret_sts_error;
1897: END IF;
1898: END IF;
1899:

Line 1990: fnd_msg_pub.add;

1986:
1987: IF l_present > 0 THEN
1988: fnd_message.set_name('FUN', 'FUN_RULE_API_ALREADY_EXISTING');
1989: fnd_message.set_token('OBJECT', p_rich_messages_rec.message_name);
1990: fnd_msg_pub.add;
1991: x_return_status := fnd_api.g_ret_sts_error;
1992: END IF;
1993:
1994: