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_VALIDATE_PKG dependencies on FND_API

Line 298: IF (p_col_val = FND_API.G_MISS_CHAR) THEN

294: p_miss_allowed_in_u IN BOOLEAN,
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;

Line 302: x_return_status := fnd_api.g_ret_sts_error;

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:
306: IF (create_update_flag = 'C') THEN

Line 313: x_return_status := fnd_api.g_ret_sts_error;

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
317: p_col_val IS NULL )

Line 322: x_return_status := fnd_api.g_ret_sts_error;

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

Line 344: IF (p_col_val = FND_API.G_MISS_DATE) THEN

340: p_miss_allowed_in_u IN BOOLEAN,
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;

Line 348: x_return_status := fnd_api.g_ret_sts_error;

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:
352: IF (create_update_flag = 'C') THEN

Line 359: x_return_status := fnd_api.g_ret_sts_error;

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
363: p_col_val IS NULL )

Line 368: x_return_status := fnd_api.g_ret_sts_error;

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

Line 390: IF (p_col_val = FND_API.G_MISS_NUM) THEN

386: p_miss_allowed_in_u IN BOOLEAN,
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;

Line 394: x_return_status := fnd_api.g_ret_sts_error;

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:
398: IF (create_update_flag = 'C') THEN

Line 405: x_return_status := fnd_api.g_ret_sts_error;

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
409: p_col_val IS NULL )

Line 414: x_return_status := fnd_api.g_ret_sts_error;

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

Line 429: IF ((ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) AND (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE)) THEN

425: ldate2 date;
426: BEGIN
427: ldate1 := date1;
428: ldate2 := date2;
429: IF ((ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) AND (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE)) THEN
430: RETURN 0;
431: ELSIF (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE) THEN
432: RETURN -1;
433: ELSIF (ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) THEN

Line 431: ELSIF (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE) THEN

427: ldate1 := date1;
428: ldate2 := date2;
429: IF ((ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) AND (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE)) THEN
430: RETURN 0;
431: ELSIF (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE) THEN
432: RETURN -1;
433: ELSIF (ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) THEN
434: RETURN 1;
435: ELSIF ( ldate1 = ldate2 ) THEN

Line 433: ELSIF (ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) THEN

429: IF ((ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) AND (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE)) THEN
430: RETURN 0;
431: ELSIF (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE) THEN
432: RETURN -1;
433: ELSIF (ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) THEN
434: RETURN 1;
435: ELSIF ( ldate1 = ldate2 ) THEN
436: RETURN 0;
437: ELSIF ( ldate1 > ldate2 ) THEN

Line 496: AND p_column_value <> fnd_api.g_miss_char ) THEN

492:
493: l_exist VARCHAR2(1);
494: BEGIN
495: IF ( p_column_value IS NOT NULL
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');

Line 504: x_return_status := fnd_api.g_ret_sts_error;

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;
508: END validate_fnd_lookup;

Line 537: x_return_status := fnd_api.g_ret_sts_error;

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

Line 547: IF x_return_status = fnd_api.g_ret_sts_error

543: procedure check_err(
544: x_return_status IN VARCHAR2
545: ) IS
546: BEGIN
547: IF x_return_status = fnd_api.g_ret_sts_error
548: THEN
549: RAISE g_ex_invalid_param;
550: END IF;
551: END;

Line 574: * be FND_API.G_RET_STS_SUCCESS (success),

570: * p_location_rec Location record.
571: * p_rowid Rowid of the record (used only in update mode).
572: * IN/OUT:
573: * x_return_status Return status after the call. The status can
574: * be FND_API.G_RET_STS_SUCCESS (success),
575: * fnd_api.g_ret_sts_error (error),
576: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
577: *
578: * NOTES

Line 575: * fnd_api.g_ret_sts_error (error),

571: * p_rowid Rowid of the record (used only in update mode).
572: * IN/OUT:
573: * x_return_status Return status after the call. The status can
574: * be FND_API.G_RET_STS_SUCCESS (success),
575: * fnd_api.g_ret_sts_error (error),
576: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
577: *
578: * NOTES
579: *

Line 576: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

572: * IN/OUT:
573: * x_return_status Return status after the call. The status can
574: * be FND_API.G_RET_STS_SUCCESS (success),
575: * fnd_api.g_ret_sts_error (error),
576: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
577: *
578: * NOTES
579: *
580: * MODIFICATION HISTORY

Line 673: x_return_status := fnd_api.g_ret_sts_error;

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: --------------------
677: -- validate RULE_OBJECT_NAME

Line 753: x_return_status := fnd_api.g_ret_sts_error;

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
757: fnd_message.set_name('FUN', 'FUN_RULE_INVALID_DFF_NAME');

Line 759: x_return_status := fnd_api.g_ret_sts_error;

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

Line 771: x_return_status := fnd_api.g_ret_sts_error;

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
775: NOT validate_flex_value_set_id(p_rule_objects_rec.flex_value_set_id)) THEN

Line 778: x_return_status := fnd_api.g_ret_sts_error;

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.
782: l_dataType := FUN_RULE_UTILITY_PKG.getValueSetDataType(p_rule_objects_rec.flex_value_set_id);

Line 862: x_return_status := fnd_api.g_ret_sts_error;

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:
866: --Validate Default Application Id

Line 871: x_return_status := fnd_api.g_ret_sts_error;

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:
875: END validate_rule_objects;

Line 898: * be FND_API.G_RET_STS_SUCCESS (success),

894: * p_location_rec Location record.
895: * p_rowid Rowid of the record (used only in update mode).
896: * IN/OUT:
897: * x_return_status Return status after the call. The status can
898: * be FND_API.G_RET_STS_SUCCESS (success),
899: * fnd_api.g_ret_sts_error (error),
900: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
901: *
902: * NOTES

Line 899: * fnd_api.g_ret_sts_error (error),

895: * p_rowid Rowid of the record (used only in update mode).
896: * IN/OUT:
897: * x_return_status Return status after the call. The status can
898: * be FND_API.G_RET_STS_SUCCESS (success),
899: * fnd_api.g_ret_sts_error (error),
900: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
901: *
902: * NOTES
903: *

Line 900: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

896: * IN/OUT:
897: * x_return_status Return status after the call. The status can
898: * be FND_API.G_RET_STS_SUCCESS (success),
899: * fnd_api.g_ret_sts_error (error),
900: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
901: *
902: * NOTES
903: *
904: * MODIFICATION HISTORY

Line 952: x_return_status := fnd_api.g_ret_sts_error;

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.
956:

Line 986: x_return_status := fnd_api.g_ret_sts_error;

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:
990: -- validate the input record for Rule Object Data

Line 998: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

994: p_rowid,
995: x_return_status
996: );
997:
998: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
999: RAISE FND_API.G_EXC_ERROR;
1000: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1002: END IF;

Line 999: RAISE FND_API.G_EXC_ERROR;

995: x_return_status
996: );
997:
998: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
999: RAISE FND_API.G_EXC_ERROR;
1000: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1002: END IF;
1003: END validate_rule_object_instance;

Line 1000: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

996: );
997:
998: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
999: RAISE FND_API.G_EXC_ERROR;
1000: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1002: END IF;
1003: END validate_rule_object_instance;
1004:

Line 1001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

997:
998: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
999: RAISE FND_API.G_EXC_ERROR;
1000: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1002: END IF;
1003: END validate_rule_object_instance;
1004:
1005:

Line 1027: * be FND_API.G_RET_STS_SUCCESS (success),

1023: * p_rule_crit_params_rec Location record.
1024: * p_rowid Rowid of the record (used only in update mode).
1025: * IN/OUT:
1026: * x_return_status Return status after the call. The status can
1027: * be FND_API.G_RET_STS_SUCCESS (success),
1028: * fnd_api.g_ret_sts_error (error),
1029: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1030: *
1031: * NOTES

Line 1028: * fnd_api.g_ret_sts_error (error),

1024: * p_rowid Rowid of the record (used only in update mode).
1025: * IN/OUT:
1026: * x_return_status Return status after the call. The status can
1027: * be FND_API.G_RET_STS_SUCCESS (success),
1028: * fnd_api.g_ret_sts_error (error),
1029: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1030: *
1031: * NOTES
1032: *

Line 1029: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

1025: * IN/OUT:
1026: * x_return_status Return status after the call. The status can
1027: * be FND_API.G_RET_STS_SUCCESS (success),
1028: * fnd_api.g_ret_sts_error (error),
1029: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1030: *
1031: * NOTES
1032: *
1033: * MODIFICATION HISTORY

Line 1078: x_return_status := fnd_api.g_ret_sts_error;

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:
1082: --------------------

Line 1182: * be FND_API.G_RET_STS_SUCCESS (success),

1178: * p_rule_details_rec Location record.
1179: * p_rowid Rowid of the record (used only in update mode).
1180: * IN/OUT:
1181: * x_return_status Return status after the call. The status can
1182: * be FND_API.G_RET_STS_SUCCESS (success),
1183: * fnd_api.g_ret_sts_error (error),
1184: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1185: *
1186: * NOTES

Line 1183: * fnd_api.g_ret_sts_error (error),

1179: * p_rowid Rowid of the record (used only in update mode).
1180: * IN/OUT:
1181: * x_return_status Return status after the call. The status can
1182: * be FND_API.G_RET_STS_SUCCESS (success),
1183: * fnd_api.g_ret_sts_error (error),
1184: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1185: *
1186: * NOTES
1187: *

Line 1184: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

1180: * IN/OUT:
1181: * x_return_status Return status after the call. The status can
1182: * be FND_API.G_RET_STS_SUCCESS (success),
1183: * fnd_api.g_ret_sts_error (error),
1184: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1185: *
1186: * NOTES
1187: *
1188: * MODIFICATION HISTORY

Line 1291: p_rule_details_rec.rule_object_id <> fnd_api.g_miss_num

1287:
1288: -- RULE_OBJECT_ID has foreign key FUN_RULE_OBJECTS.RULE_OBJECT_ID
1289: IF p_rule_details_rec.rule_object_id IS NOT NULL
1290: AND
1291: p_rule_details_rec.rule_object_id <> fnd_api.g_miss_num
1292: THEN
1293: BEGIN
1294: SELECT 'Y'
1295: INTO l_dummy

Line 1302: x_return_status := fnd_api.g_ret_sts_error;

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:
1306: --------------------------------------

Line 1343: x_return_status := fnd_api.g_ret_sts_error;

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:
1347:

Line 1372: * be FND_API.G_RET_STS_SUCCESS (success),

1368: * p_criteria_rec Location record.
1369: * p_rowid Rowid of the record (used only in update mode).
1370: * IN/OUT:
1371: * x_return_status Return status after the call. The status can
1372: * be FND_API.G_RET_STS_SUCCESS (success),
1373: * fnd_api.g_ret_sts_error (error),
1374: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1375: *
1376: * NOTES

Line 1373: * fnd_api.g_ret_sts_error (error),

1369: * p_rowid Rowid of the record (used only in update mode).
1370: * IN/OUT:
1371: * x_return_status Return status after the call. The status can
1372: * be FND_API.G_RET_STS_SUCCESS (success),
1373: * fnd_api.g_ret_sts_error (error),
1374: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1375: *
1376: * NOTES
1377: *

Line 1374: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

1370: * IN/OUT:
1371: * x_return_status Return status after the call. The status can
1372: * be FND_API.G_RET_STS_SUCCESS (success),
1373: * fnd_api.g_ret_sts_error (error),
1374: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1375: *
1376: * NOTES
1377: *
1378: * MODIFICATION HISTORY

Line 1512: * be FND_API.G_RET_STS_SUCCESS (success),

1508: * p_rich_messages_rec Rich Messages record.
1509: * p_rowid Rowid of the record (used only in update mode).
1510: * IN/OUT:
1511: * x_return_status Return status after the call. The status can
1512: * be FND_API.G_RET_STS_SUCCESS (success),
1513: * fnd_api.g_ret_sts_error (error),
1514: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1515: *
1516: * NOTES

Line 1513: * fnd_api.g_ret_sts_error (error),

1509: * p_rowid Rowid of the record (used only in update mode).
1510: * IN/OUT:
1511: * x_return_status Return status after the call. The status can
1512: * be FND_API.G_RET_STS_SUCCESS (success),
1513: * fnd_api.g_ret_sts_error (error),
1514: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1515: *
1516: * NOTES
1517: *

Line 1514: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

1510: * IN/OUT:
1511: * x_return_status Return status after the call. The status can
1512: * be FND_API.G_RET_STS_SUCCESS (success),
1513: * fnd_api.g_ret_sts_error (error),
1514: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1515: *
1516: * NOTES
1517: *
1518: * MODIFICATION HISTORY

Line 1584: x_return_status := fnd_api.g_ret_sts_error;

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:
1588: --------------------

Line 1675: p_column_value = FND_API.G_MISS_CHAR)) OR

1671:
1672: IF p_restricted = 'N' THEN
1673: IF (p_create_update_flag = 'C' AND
1674: (p_column_value IS NULL OR
1675: p_column_value = FND_API.G_MISS_CHAR)) OR
1676: (p_create_update_flag = 'U' AND
1677: p_column_value = FND_API.G_MISS_CHAR)
1678: THEN
1679: l_error := TRUE;

Line 1677: p_column_value = FND_API.G_MISS_CHAR)

1673: IF (p_create_update_flag = 'C' AND
1674: (p_column_value IS NULL OR
1675: p_column_value = FND_API.G_MISS_CHAR)) OR
1676: (p_create_update_flag = 'U' AND
1677: p_column_value = FND_API.G_MISS_CHAR)
1678: THEN
1679: l_error := TRUE;
1680: END IF;
1681: ELSE

Line 1683: p_column_value = FND_API.G_MISS_CHAR)

1679: l_error := TRUE;
1680: END IF;
1681: ELSE
1682: IF (p_column_value IS NULL OR
1683: p_column_value = FND_API.G_MISS_CHAR)
1684: THEN
1685: l_error := TRUE;
1686: END IF;
1687: END IF;

Line 1693: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1713: p_column_value = FND_API.G_MISS_NUM)) OR

1709:
1710: IF p_restricted = 'N' THEN
1711: IF (p_create_update_flag = 'C' AND
1712: (p_column_value IS NULL OR
1713: p_column_value = FND_API.G_MISS_NUM)) OR
1714: (p_create_update_flag = 'U' AND
1715: p_column_value = FND_API.G_MISS_NUM)
1716: THEN
1717: l_error := TRUE;

Line 1715: p_column_value = FND_API.G_MISS_NUM)

1711: IF (p_create_update_flag = 'C' AND
1712: (p_column_value IS NULL OR
1713: p_column_value = FND_API.G_MISS_NUM)) OR
1714: (p_create_update_flag = 'U' AND
1715: p_column_value = FND_API.G_MISS_NUM)
1716: THEN
1717: l_error := TRUE;
1718: END IF;
1719: ELSE

Line 1721: p_column_value = FND_API.G_MISS_NUM)

1717: l_error := TRUE;
1718: END IF;
1719: ELSE
1720: IF (p_column_value IS NULL OR
1721: p_column_value = FND_API.G_MISS_NUM)
1722: THEN
1723: l_error := TRUE;
1724: END IF;
1725: END IF;

Line 1731: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1752: p_column_value = FND_API.G_MISS_DATE)) OR

1748:
1749: IF p_restricted = 'N' THEN
1750: IF (p_create_update_flag = 'C' AND
1751: (p_column_value IS NULL OR
1752: p_column_value = FND_API.G_MISS_DATE)) OR
1753: (p_create_update_flag = 'U' AND
1754: p_column_value = FND_API.G_MISS_DATE)
1755: THEN
1756: l_error := TRUE;

Line 1754: p_column_value = FND_API.G_MISS_DATE)

1750: IF (p_create_update_flag = 'C' AND
1751: (p_column_value IS NULL OR
1752: p_column_value = FND_API.G_MISS_DATE)) OR
1753: (p_create_update_flag = 'U' AND
1754: p_column_value = FND_API.G_MISS_DATE)
1755: THEN
1756: l_error := TRUE;
1757: END IF;
1758: ELSE

Line 1760: p_column_value = FND_API.G_MISS_DATE)

1756: l_error := TRUE;
1757: END IF;
1758: ELSE
1759: IF (p_column_value IS NULL OR
1760: p_column_value = FND_API.G_MISS_DATE)
1761: THEN
1762: l_error := TRUE;
1763: END IF;
1764: END IF;

Line 1770: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1790: IF (p_column_value <> fnd_api.g_miss_char OR

1786: BEGIN
1787:
1788: IF p_column_value IS NOT NULL THEN
1789: IF p_restricted = 'Y' THEN
1790: IF (p_column_value <> fnd_api.g_miss_char OR
1791: p_old_column_value IS NOT NULL) AND
1792: (p_old_column_value IS NULL OR
1793: p_column_value <> p_old_column_value)
1794: THEN

Line 1799: p_old_column_value <> FND_API.G_MISS_CHAR)

1795: l_error := TRUE;
1796: END IF;
1797: ELSE
1798: IF (p_old_column_value IS NOT NULL AND -- BUG 3367582.
1799: p_old_column_value <> FND_API.G_MISS_CHAR)
1800: AND
1801: (p_column_value = fnd_api.g_miss_char OR
1802: p_column_value <> p_old_column_value)
1803: THEN

Line 1801: (p_column_value = fnd_api.g_miss_char OR

1797: ELSE
1798: IF (p_old_column_value IS NOT NULL AND -- BUG 3367582.
1799: p_old_column_value <> FND_API.G_MISS_CHAR)
1800: AND
1801: (p_column_value = fnd_api.g_miss_char OR
1802: p_column_value <> p_old_column_value)
1803: THEN
1804: l_error := TRUE;
1805: END IF;

Line 1814: x_return_status := fnd_api.g_ret_sts_error;

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:
1817: END validate_nonupdateable;
1818:

Line 1833: IF (p_column_value <> fnd_api.g_miss_char OR

1829: l_error BOOLEAN := FALSE;
1830:
1831: BEGIN
1832: IF p_restricted = 'Y' THEN
1833: IF (p_column_value <> fnd_api.g_miss_char OR
1834: p_old_column_value IS NOT NULL) AND
1835: (p_old_column_value IS NULL OR
1836: p_column_value <> p_old_column_value)
1837: THEN

Line 1842: p_old_column_value <> FND_API.G_MISS_CHAR)

1838: l_error := TRUE;
1839: END IF;
1840: ELSE
1841: IF (p_old_column_value IS NOT NULL AND -- BUG 3367582.
1842: p_old_column_value <> FND_API.G_MISS_CHAR)
1843: AND
1844: (p_column_value = fnd_api.g_miss_char OR
1845: p_column_value <> p_old_column_value)
1846: THEN

Line 1844: (p_column_value = fnd_api.g_miss_char OR

1840: ELSE
1841: IF (p_old_column_value IS NOT NULL AND -- BUG 3367582.
1842: p_old_column_value <> FND_API.G_MISS_CHAR)
1843: AND
1844: (p_column_value = fnd_api.g_miss_char OR
1845: p_column_value <> p_old_column_value)
1846: THEN
1847: l_error := TRUE;
1848: END IF;

Line 1857: x_return_status := fnd_api.g_ret_sts_error;

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:
1860: END validate_nonupdateable_atall;
1861:

Line 1876: p_column_value <> fnd_api.g_miss_char THEN

1872:
1873: BEGIN
1874:
1875: IF p_column_value IS NOT NULL AND
1876: p_column_value <> fnd_api.g_miss_char THEN
1877:
1878: IF p_lookup_type = 'YES/NO' THEN
1879: IF p_column_value NOT IN ('Y', 'N') THEN
1880: l_error := TRUE;

Line 1896: x_return_status := fnd_api.g_ret_sts_error;

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:
1900: END validate_lookup;

Line 1923: * be FND_API.G_RET_STS_SUCCESS (success),

1919: * p_rich_messages_rec Rich Messages record.
1920: * p_rowid Rowid of the record (used only in update mode).
1921: * IN/OUT:
1922: * x_return_status Return status after the call. The status can
1923: * be FND_API.G_RET_STS_SUCCESS (success),
1924: * fnd_api.g_ret_sts_error (error),
1925: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1926: *
1927: * NOTES

Line 1924: * fnd_api.g_ret_sts_error (error),

1920: * p_rowid Rowid of the record (used only in update mode).
1921: * IN/OUT:
1922: * x_return_status Return status after the call. The status can
1923: * be FND_API.G_RET_STS_SUCCESS (success),
1924: * fnd_api.g_ret_sts_error (error),
1925: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1926: *
1927: * NOTES
1928: *

Line 1925: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

1921: * IN/OUT:
1922: * x_return_status Return status after the call. The status can
1923: * be FND_API.G_RET_STS_SUCCESS (success),
1924: * fnd_api.g_ret_sts_error (error),
1925: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1926: *
1927: * NOTES
1928: *
1929: * MODIFICATION HISTORY

Line 1991: x_return_status := fnd_api.g_ret_sts_error;

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:
1995: --------------------