DBA Data[Home] [Help]

APPS.FUN_RULE_VALIDATE_PKG dependencies on FND_MESSAGE

Line 299: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');

295: x_return_status IN OUT NOCOPY VARCHAR2)
296: IS
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;

Line 300: fnd_message.set_token('COLUMN', p_col_name);

296: IS
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;

Line 310: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');

306: IF (create_update_flag = 'C') THEN
307: IF ((NOT p_miss_allowed_in_c) AND
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;

Line 311: fnd_message.set_token('COLUMN', p_col_name);

307: IF ((NOT p_miss_allowed_in_c) AND
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

Line 319: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');

315: ELSE
316: IF ((NOT p_miss_allowed_in_u) AND
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;

Line 320: fnd_message.set_token('COLUMN', p_col_name);

316: IF ((NOT p_miss_allowed_in_u) AND
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;

Line 345: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');

341: x_return_status IN OUT NOCOPY VARCHAR2)
342: IS
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;

Line 346: fnd_message.set_token('COLUMN', p_col_name);

342: IS
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;

Line 356: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');

352: IF (create_update_flag = 'C') THEN
353: IF ((NOT p_miss_allowed_in_c) AND
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;

Line 357: fnd_message.set_token('COLUMN', p_col_name);

353: IF ((NOT p_miss_allowed_in_c) AND
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

Line 365: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');

361: ELSE
362: IF ((NOT p_miss_allowed_in_u) AND
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;

Line 366: fnd_message.set_token('COLUMN', p_col_name);

362: IF ((NOT p_miss_allowed_in_u) AND
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;

Line 391: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');

387: x_return_status IN OUT NOCOPY VARCHAR2)
388: IS
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;

Line 392: fnd_message.set_token('COLUMN', p_col_name);

388: IS
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;

Line 402: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');

398: IF (create_update_flag = 'C') THEN
399: IF ((NOT p_miss_allowed_in_c) AND
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;

Line 403: fnd_message.set_token('COLUMN', p_col_name);

399: IF ((NOT p_miss_allowed_in_c) AND
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

Line 411: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');

407: ELSE
408: IF ((NOT p_miss_allowed_in_u) AND
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;

Line 412: fnd_message.set_token('COLUMN', p_col_name);

408: IF ((NOT p_miss_allowed_in_u) AND
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;

Line 500: fnd_message.set_name('FUN','FUN_RULE_API_INVALID_LOOKUP');

496: AND p_column_value <> fnd_api.g_miss_char ) THEN
497: OPEN c1;
498: FETCH c1 INTO l_exist;
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;

Line 501: fnd_message.set_token('COLUMN',p_column);

497: OPEN c1;
498: FETCH c1 INTO l_exist;
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;

Line 502: fnd_message.set_token('LOOKUP_TYPE',p_lookup_type);

498: FETCH c1 INTO l_exist;
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;

Line 532: fnd_message.set_name('FUN','FUN_RULE_API_INVALID_FK');

528: BEGIN
529: OPEN c_exist_rules_object(p_rule_object_name,p_application_id);
530: FETCH c_exist_rules_object INTO l_exist;
531: IF c_exist_rules_object%NOTFOUND THEN
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;

Line 533: fnd_message.set_token('FK','CUSTOM_OBJECT_NAME');

529: OPEN c_exist_rules_object(p_rule_object_name,p_application_id);
530: FETCH c_exist_rules_object INTO l_exist;
531: IF c_exist_rules_object%NOTFOUND THEN
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;

Line 534: fnd_message.set_token('COLUMN','CUSTOM_OBJECT_NAME');

530: FETCH c_exist_rules_object INTO l_exist;
531: IF c_exist_rules_object%NOTFOUND THEN
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;

Line 535: fnd_message.set_token('TABLE','FUN_RULES_OBJECTS');

531: IF c_exist_rules_object%NOTFOUND THEN
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;

Line 670: fnd_message.set_name('FUN', 'FUN_RULE_API_ALREADY_EXISTING');

666: l_present := 0;
667: END;
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;

Line 671: fnd_message.set_token('OBJECT', p_rule_objects_rec.rule_object_name);

667: END;
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:

Line 751: fnd_message.set_name('FUN', 'FUN_RULE_NO_DFF_INFO');

747: IF (p_rule_objects_rec.result_type = 'MULTIVALUE') THEN
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);

Line 757: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_DFF_NAME');

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
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;

Line 769: fnd_message.set_name('FUN', 'FUN_RULE_NO_VALUESET_INFO');

765: -- If RESULT_TYPE is VALUESET, then user must provide flex_value_set_id
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.

Line 776: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_VALUESET');

772: ELSE
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.

Line 860: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_APPL_ID');

856: --Validate Application Id
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;

Line 869: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_APPL_ID');

865:
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;

Line 949: fnd_message.set_name('FUN', 'FUN_RULE_API_ALREADY_EXISTING');

945: l_present := 0;
946: END;
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;

Line 950: fnd_message.set_token('OBJECT', p_rule_object_instance_rec.instance_label);

946: END;
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:

Line 984: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_ORG_ID');

980:
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;

Line 1076: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_ROB');

1072: SELECT RULE_OBJECT_ID INTO l_rule_object_id
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:

Line 1300: fnd_message.set_name('FUN', 'FUN_RULE_API_INVALID_RULE');

1296: FROM FUN_RULE_OBJECTS_B
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;

Line 1341: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_APPL_ID');

1337:
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;

Line 1581: fnd_message.set_name('FUN', 'FUN_RULE_API_ALREADY_EXISTING');

1577: l_present := 0;
1578: END;
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;

Line 1582: fnd_message.set_token('OBJECT', p_rich_messages_rec.message_name);

1578: END;
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:

Line 1690: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');

1686: END IF;
1687: END IF;
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;

Line 1691: fnd_message.set_token('COLUMN', p_column);

1687: END IF;
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:

Line 1728: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');

1724: END IF;
1725: END IF;
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;

Line 1729: fnd_message.set_token('COLUMN', p_column);

1725: END IF;
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:

Line 1767: fnd_message.set_name('FUN', 'FUN_RULE_API_MISSING_COLUMN');

1763: END IF;
1764: END IF;
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;

Line 1768: fnd_message.set_token('COLUMN', p_column);

1764: END IF;
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:

Line 1810: fnd_message.set_name('FUN', 'FUN_RULE_API_NONUPDATE_COLUMN');

1806: END IF;
1807: END IF;
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;

Line 1811: fnd_message.set_token('COLUMN', p_column);

1807: END IF;
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;

Line 1853: fnd_message.set_name('FUN', 'FUN_RULE_API_NONUPDATE_COLUMN');

1849: END IF;
1850:
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;

Line 1854: fnd_message.set_token('COLUMN', p_column);

1850:
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;

Line 1892: fnd_message.set_name('FUN', 'FUN_RULE_API_INVALID_LOOKUP');

1888: END IF;
1889: END IF;
1890:
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;

Line 1893: fnd_message.set_token('COLUMN', p_column);

1889: END IF;
1890:
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;

Line 1894: fnd_message.set_token('LOOKUP_TYPE', p_lookup_type);

1890:
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;

Line 1988: fnd_message.set_name('FUN', 'FUN_RULE_API_ALREADY_EXISTING');

1984: l_present := 0;
1985: END;
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;

Line 1989: fnd_message.set_token('OBJECT', p_rich_messages_rec.message_name);

1985: END;
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: