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.HZ_UTILITY_V2PUB dependencies on FND_API

Line 511: RAISE FND_API.G_EXC_ERROR;

507: FND_MESSAGE.SET_TOKEN( 'FILE_DIR', G_FILE_PATH );
508: FND_MSG_PUB.ADD;
509: G_FILE_DEBUG := FALSE;
510: G_COUNT := 0;
511: RAISE FND_API.G_EXC_ERROR;
512:
513: WHEN UTL_FILE.INVALID_MODE THEN
514: FND_MESSAGE.SET_NAME( 'FND', 'CONC-TEMPFILE_INVALID_MODE' );
515: FND_MESSAGE.SET_TOKEN( 'TEMP_FILE', G_FILE_NAME );

Line 520: RAISE FND_API.G_EXC_ERROR;

516: FND_MESSAGE.SET_TOKEN( 'FILE_MODE', 'w' );
517: FND_MSG_PUB.ADD;
518: G_FILE_DEBUG := FALSE;
519: G_COUNT := 0;
520: RAISE FND_API.G_EXC_ERROR;
521:
522: WHEN UTL_FILE.INVALID_OPERATION THEN
523: FND_MESSAGE.SET_NAME( 'FND', 'CONC-TEMPFILE_INVALID_OPERATN' );
524: FND_MESSAGE.SET_TOKEN( 'TEMP_FILE', G_FILE_NAME );

Line 529: RAISE FND_API.G_EXC_ERROR;

525: FND_MESSAGE.SET_TOKEN( 'TEMP_DIR', G_FILE_PATH );
526: FND_MSG_PUB.ADD;
527: G_FILE_DEBUG := FALSE;
528: G_COUNT := 0;
529: RAISE FND_API.G_EXC_ERROR;
530:
531: END enable_file_debug;
532:
533: --------------------------------------

Line 582: p_column_value = FND_API.G_MISS_CHAR ) ) OR

578:
579: IF p_restricted = 'N' THEN
580: IF ( p_create_update_flag = 'C' AND
581: ( p_column_value IS NULL OR
582: p_column_value = FND_API.G_MISS_CHAR ) ) OR
583: ( p_create_update_flag = 'U' AND
584: p_column_value = FND_API.G_MISS_CHAR )
585: THEN
586: l_error := TRUE;

Line 584: p_column_value = FND_API.G_MISS_CHAR )

580: IF ( p_create_update_flag = 'C' AND
581: ( p_column_value IS NULL OR
582: p_column_value = FND_API.G_MISS_CHAR ) ) OR
583: ( p_create_update_flag = 'U' AND
584: p_column_value = FND_API.G_MISS_CHAR )
585: THEN
586: l_error := TRUE;
587: END IF;
588: ELSE

Line 590: p_column_value = FND_API.G_MISS_CHAR )

586: l_error := TRUE;
587: END IF;
588: ELSE
589: IF ( p_column_value IS NULL OR
590: p_column_value = FND_API.G_MISS_CHAR )
591: THEN
592: l_error := TRUE;
593: END IF;
594: END IF;

Line 600: x_return_status := FND_API.G_RET_STS_ERROR;

596: IF l_error THEN
597: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
598: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
599: FND_MSG_PUB.ADD;
600: x_return_status := FND_API.G_RET_STS_ERROR;
601: END IF;
602:
603: END validate_mandatory;
604:

Line 620: p_column_value = FND_API.G_MISS_NUM ) ) OR

616:
617: IF p_restricted = 'N' THEN
618: IF ( p_create_update_flag = 'C' AND
619: ( p_column_value IS NULL OR
620: p_column_value = FND_API.G_MISS_NUM ) ) OR
621: ( p_create_update_flag = 'U' AND
622: p_column_value = FND_API.G_MISS_NUM )
623: THEN
624: l_error := TRUE;

Line 622: p_column_value = FND_API.G_MISS_NUM )

618: IF ( p_create_update_flag = 'C' AND
619: ( p_column_value IS NULL OR
620: p_column_value = FND_API.G_MISS_NUM ) ) OR
621: ( p_create_update_flag = 'U' AND
622: p_column_value = FND_API.G_MISS_NUM )
623: THEN
624: l_error := TRUE;
625: END IF;
626: ELSE

Line 628: p_column_value = FND_API.G_MISS_NUM )

624: l_error := TRUE;
625: END IF;
626: ELSE
627: IF ( p_column_value IS NULL OR
628: p_column_value = FND_API.G_MISS_NUM )
629: THEN
630: l_error := TRUE;
631: END IF;
632: END IF;

Line 638: x_return_status := FND_API.G_RET_STS_ERROR;

634: IF l_error THEN
635: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
636: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
637: FND_MSG_PUB.ADD;
638: x_return_status := FND_API.G_RET_STS_ERROR;
639: END IF;
640:
641: END validate_mandatory;
642:

Line 658: p_column_value = FND_API.G_MISS_DATE ) ) OR

654:
655: IF p_restricted = 'N' THEN
656: IF ( p_create_update_flag = 'C' AND
657: ( p_column_value IS NULL OR
658: p_column_value = FND_API.G_MISS_DATE ) ) OR
659: ( p_create_update_flag = 'U' AND
660: p_column_value = FND_API.G_MISS_DATE )
661: THEN
662: l_error := TRUE;

Line 660: p_column_value = FND_API.G_MISS_DATE )

656: IF ( p_create_update_flag = 'C' AND
657: ( p_column_value IS NULL OR
658: p_column_value = FND_API.G_MISS_DATE ) ) OR
659: ( p_create_update_flag = 'U' AND
660: p_column_value = FND_API.G_MISS_DATE )
661: THEN
662: l_error := TRUE;
663: END IF;
664: ELSE

Line 666: p_column_value = FND_API.G_MISS_DATE )

662: l_error := TRUE;
663: END IF;
664: ELSE
665: IF ( p_column_value IS NULL OR
666: p_column_value = FND_API.G_MISS_DATE )
667: THEN
668: l_error := TRUE;
669: END IF;
670: END IF;

Line 676: x_return_status := FND_API.G_RET_STS_ERROR;

672: IF l_error THEN
673: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
674: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
675: FND_MSG_PUB.ADD;
676: x_return_status := FND_API.G_RET_STS_ERROR;
677: END IF;
678:
679: END validate_mandatory;
680:

Line 736: l_old_column_value := NVL(p_old_column_value, FND_API.G_MISS_CHAR);

732:
733: BEGIN
734:
735: IF p_column_value IS NOT NULL THEN
736: l_old_column_value := NVL(p_old_column_value, FND_API.G_MISS_CHAR);
737:
738: IF p_restricted = 'Y' THEN
739: IF p_column_value <> l_old_column_value THEN
740: l_error := TRUE;

Line 743: IF l_old_column_value <> FND_API.G_MISS_CHAR AND

739: IF p_column_value <> l_old_column_value THEN
740: l_error := TRUE;
741: END IF;
742: ELSE
743: IF l_old_column_value <> FND_API.G_MISS_CHAR AND
744: (p_column_value = FND_API.G_MISS_CHAR OR
745: p_column_value <> l_old_column_value)
746: THEN
747: l_error := TRUE;

Line 744: (p_column_value = FND_API.G_MISS_CHAR OR

740: l_error := TRUE;
741: END IF;
742: ELSE
743: IF l_old_column_value <> FND_API.G_MISS_CHAR AND
744: (p_column_value = FND_API.G_MISS_CHAR OR
745: p_column_value <> l_old_column_value)
746: THEN
747: l_error := TRUE;
748: END IF;

Line 756: x_return_status := FND_API.G_RET_STS_ERROR;

752: IF l_error THEN
753: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
754: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
755: FND_MSG_PUB.ADD;
756: x_return_status := FND_API.G_RET_STS_ERROR;
757: END IF;
758:
759: END validate_nonupdateable;
760:

Line 775: l_old_column_value := NVL(p_old_column_value, FND_API.G_MISS_NUM);

771:
772: BEGIN
773:
774: IF p_column_value IS NOT NULL THEN
775: l_old_column_value := NVL(p_old_column_value, FND_API.G_MISS_NUM);
776:
777: IF p_restricted = 'Y' THEN
778: IF p_column_value <> l_old_column_value THEN
779: l_error := TRUE;

Line 782: IF l_old_column_value <> FND_API.G_MISS_NUM AND

778: IF p_column_value <> l_old_column_value THEN
779: l_error := TRUE;
780: END IF;
781: ELSE
782: IF l_old_column_value <> FND_API.G_MISS_NUM AND
783: (p_column_value = FND_API.G_MISS_NUM OR
784: p_column_value <> l_old_column_value)
785: THEN
786: l_error := TRUE;

Line 783: (p_column_value = FND_API.G_MISS_NUM OR

779: l_error := TRUE;
780: END IF;
781: ELSE
782: IF l_old_column_value <> FND_API.G_MISS_NUM AND
783: (p_column_value = FND_API.G_MISS_NUM OR
784: p_column_value <> l_old_column_value)
785: THEN
786: l_error := TRUE;
787: END IF;

Line 795: x_return_status := FND_API.G_RET_STS_ERROR;

791: IF l_error THEN
792: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
793: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
794: FND_MSG_PUB.ADD;
795: x_return_status := FND_API.G_RET_STS_ERROR;
796: END IF;
797:
798: END validate_nonupdateable;
799:

Line 814: l_old_column_value := NVL(p_old_column_value, FND_API.G_MISS_DATE);

810:
811: BEGIN
812:
813: IF p_column_value IS NOT NULL THEN
814: l_old_column_value := NVL(p_old_column_value, FND_API.G_MISS_DATE);
815:
816: IF p_restricted = 'Y' THEN
817: IF p_column_value <> l_old_column_value THEN
818: l_error := TRUE;

Line 821: IF l_old_column_value <> FND_API.G_MISS_DATE AND

817: IF p_column_value <> l_old_column_value THEN
818: l_error := TRUE;
819: END IF;
820: ELSE
821: IF l_old_column_value <> FND_API.G_MISS_DATE AND
822: (p_column_value = FND_API.G_MISS_DATE OR
823: p_column_value <> l_old_column_value)
824: THEN
825: l_error := TRUE;

Line 822: (p_column_value = FND_API.G_MISS_DATE OR

818: l_error := TRUE;
819: END IF;
820: ELSE
821: IF l_old_column_value <> FND_API.G_MISS_DATE AND
822: (p_column_value = FND_API.G_MISS_DATE OR
823: p_column_value <> l_old_column_value)
824: THEN
825: l_error := TRUE;
826: END IF;

Line 834: x_return_status := FND_API.G_RET_STS_ERROR;

830: IF l_error THEN
831: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
832: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
833: FND_MSG_PUB.ADD;
834: x_return_status := FND_API.G_RET_STS_ERROR;
835: END IF;
836:
837: END validate_nonupdateable;
838:

Line 889: IF p_start_date = FND_API.G_MISS_DATE THEN

885: l_end_date := p_end_date;
886: ELSIF p_create_update_flag = 'U' THEN
887: IF p_start_date IS NOT NULL
888: THEN
889: IF p_start_date = FND_API.G_MISS_DATE THEN
890: l_start_date := NULL;
891: ELSE
892: l_start_date := p_start_date;
893: END IF;

Line 898: IF p_end_date = FND_API.G_MISS_DATE THEN

894: END IF;
895:
896: IF p_end_date IS NOT NULL
897: THEN
898: IF p_end_date = FND_API.G_MISS_DATE THEN
899: l_end_date := NULL;
900: ELSE
901: l_end_date := p_end_date;
902: END IF;

Line 907: l_end_date <> FND_API.G_MISS_DATE AND

903: END IF;
904: END IF;
905:
906: IF l_end_date IS NOT NULL AND
907: l_end_date <> FND_API.G_MISS_DATE AND
908: ( l_start_date IS NULL OR
909: l_start_date = FND_API.G_MISS_DATE OR
910: l_start_date > l_end_date )
911: THEN

Line 909: l_start_date = FND_API.G_MISS_DATE OR

905:
906: IF l_end_date IS NOT NULL AND
907: l_end_date <> FND_API.G_MISS_DATE AND
908: ( l_start_date IS NULL OR
909: l_start_date = FND_API.G_MISS_DATE OR
910: l_start_date > l_end_date )
911: THEN
912: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DATE_GREATER' );
913: FND_MESSAGE.SET_TOKEN( 'DATE2', p_end_date_column_name );

Line 916: x_return_status := FND_API.G_RET_STS_ERROR;

912: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DATE_GREATER' );
913: FND_MESSAGE.SET_TOKEN( 'DATE2', p_end_date_column_name );
914: FND_MESSAGE.SET_TOKEN( 'DATE1', p_start_date_column_name );
915: FND_MSG_PUB.ADD;
916: x_return_status := FND_API.G_RET_STS_ERROR;
917: END IF;
918:
919: END validate_start_end_date;
920:

Line 959: IF p_column_value = FND_API.G_MISS_CHAR THEN

955: ) IS
956:
957: BEGIN
958:
959: IF p_column_value = FND_API.G_MISS_CHAR THEN
960: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_TO_NULL' );
961: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
962: FND_MSG_PUB.ADD;
963: x_return_status := FND_API.G_RET_STS_ERROR;

Line 963: x_return_status := FND_API.G_RET_STS_ERROR;

959: IF p_column_value = FND_API.G_MISS_CHAR THEN
960: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_TO_NULL' );
961: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
962: FND_MSG_PUB.ADD;
963: x_return_status := FND_API.G_RET_STS_ERROR;
964: END IF;
965:
966: END validate_cannot_update_to_null;
967:

Line 976: IF p_column_value = FND_API.G_MISS_NUM THEN

972: ) IS
973:
974: BEGIN
975:
976: IF p_column_value = FND_API.G_MISS_NUM THEN
977: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_TO_NULL' );
978: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
979: FND_MSG_PUB.ADD;
980: x_return_status := FND_API.G_RET_STS_ERROR;

Line 980: x_return_status := FND_API.G_RET_STS_ERROR;

976: IF p_column_value = FND_API.G_MISS_NUM THEN
977: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_TO_NULL' );
978: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
979: FND_MSG_PUB.ADD;
980: x_return_status := FND_API.G_RET_STS_ERROR;
981: END IF;
982:
983: END validate_cannot_update_to_null;
984:

Line 993: IF p_column_value = FND_API.G_MISS_DATE THEN

989: ) IS
990:
991: BEGIN
992:
993: IF p_column_value = FND_API.G_MISS_DATE THEN
994: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_TO_NULL' );
995: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
996: FND_MSG_PUB.ADD;
997: x_return_status := FND_API.G_RET_STS_ERROR;

Line 997: x_return_status := FND_API.G_RET_STS_ERROR;

993: IF p_column_value = FND_API.G_MISS_DATE THEN
994: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_TO_NULL' );
995: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
996: FND_MSG_PUB.ADD;
997: x_return_status := FND_API.G_RET_STS_ERROR;
998: END IF;
999:
1000: END validate_cannot_update_to_null;
1001:

Line 1047: p_column_value <> FND_API.G_MISS_CHAR THEN

1043:
1044: BEGIN
1045:
1046: IF p_column_value IS NOT NULL AND
1047: p_column_value <> FND_API.G_MISS_CHAR THEN
1048:
1049: IF p_lookup_type = 'YES/NO' THEN
1050: IF p_column_value NOT IN ('Y', 'N') THEN
1051: l_error := TRUE;

Line 1067: x_return_status := FND_API.G_RET_STS_ERROR;

1063: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
1064: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
1065: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', p_lookup_type );
1066: FND_MSG_PUB.ADD;
1067: x_return_status := FND_API.G_RET_STS_ERROR;
1068: END IF;
1069: END IF;
1070:
1071: END validate_lookup;

Line 1164: RAISE FND_API.G_EXC_ERROR;

1160: FND_MESSAGE.SET_TOKEN( 'TEMP_FILE', G_FILE_NAME );
1161: FND_MSG_PUB.ADD;
1162: G_FILE_DEBUG := FALSE;
1163: G_COUNT := 0;
1164: RAISE FND_API.G_EXC_ERROR;
1165:
1166: WHEN UTL_FILE.WRITE_ERROR THEN
1167: FND_MESSAGE.SET_NAME( 'FND', 'CONC-TEMPFILE_WRITE_ERROR' );
1168: FND_MESSAGE.SET_TOKEN( 'TEMP_FILE', G_FILE_NAME );

Line 1172: RAISE FND_API.G_EXC_ERROR;

1168: FND_MESSAGE.SET_TOKEN( 'TEMP_FILE', G_FILE_NAME );
1169: FND_MSG_PUB.ADD;
1170: G_FILE_DEBUG := FALSE;
1171: G_COUNT := 0;
1172: RAISE FND_API.G_EXC_ERROR;
1173: END;
1174: END IF;
1175: /*
1176: ELSIF G_DBMS_DEBUG THEN

Line 1306: debug( FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE ), p_msg_type,p_msg_level,p_module_prefix,p_module);

1302: IF p_msg_count = 1 THEN
1303: debug( p_msg_data, p_msg_type,p_msg_level,p_module_prefix,p_module);
1304: ELSE
1305: FOR i IN 1..p_msg_count LOOP
1306: debug( FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE ), p_msg_type,p_msg_level,p_module_prefix,p_module);
1307: END LOOP;
1308: END IF;
1309:
1310: END debug_return_messages;

Line 1522: p_relationship_type <> FND_API.G_MISS_CHAR THEN

1518:
1519: BEGIN
1520:
1521: IF p_relationship_type IS NOT NULL AND
1522: p_relationship_type <> FND_API.G_MISS_CHAR THEN
1523:
1524: IF NOT search(p_relationship_type || G_SPECIAL_STRING,
1525: 'RELATIONSHIP_TYPE')
1526: THEN

Line 1544: * The function will raise fnd_api.g_exc_unexpected_error if

1540: * FUNCTION Get_SchemaName
1541: *
1542: * DESCRIPTION
1543: * Return Schema's Name By Given The Application's Short Name.
1544: * The function will raise fnd_api.g_exc_unexpected_error if
1545: * the short name can not be found in installation and put a
1546: * message ' is not a valid oracle schema name.'
1547: * in the message stack.
1548: *

Line 1581: RAISE fnd_api.g_exc_unexpected_error;

1577: IF l_schema_name IS NULL THEN
1578: fnd_message.set_name('FND','FND_NO_SCHEMA_NAME');
1579: fnd_message.set_token('SCHEMA_NAME',p_app_short_name);
1580: fnd_msg_pub.add;
1581: RAISE fnd_api.g_exc_unexpected_error;
1582: ELSE
1583: RETURN l_schema_name;
1584: END IF;
1585:

Line 1593: * The function will raise fnd_api.g_exc_unexpected_error if

1589: * FUNCTION Get_AppsSchemaName
1590: *
1591: * DESCRIPTION
1592: * Return APPS Schema's Name
1593: * The function will raise fnd_api.g_exc_unexpected_error if
1594: * the 'FND' as a short name can not be found in installation.
1595: * and put a message 'FND is not a valid oracle schema name.'
1596: * in the message stack.
1597: *

Line 1692: * FND_API.G_MISS_XXX and for V2 API, we do

1688: * p_create_update_flag 'C' is for create. 'U' is for update.
1689: * p_column_value Value of the column.
1690: * p_default_value Default value of the column. Please note,
1691: * for V1 API, most columns are defaulted to
1692: * FND_API.G_MISS_XXX and for V2 API, we do
1693: * not have default value for most columns.
1694: * p_old_column_value Database value of the column. Only used
1695: * in update mode.
1696: *

Line 1719: l_column_value := NVL(p_column_value, FND_API.G_MISS_CHAR);

1715: l_old_column_value VARCHAR2(2000);
1716:
1717: BEGIN
1718:
1719: l_column_value := NVL(p_column_value, FND_API.G_MISS_CHAR);
1720:
1721: IF p_create_update_flag = 'C' AND
1722: l_column_value <> FND_API.G_MISS_CHAR AND
1723: l_column_value <> NVL(p_default_value, FND_API.G_MISS_CHAR)

Line 1722: l_column_value <> FND_API.G_MISS_CHAR AND

1718:
1719: l_column_value := NVL(p_column_value, FND_API.G_MISS_CHAR);
1720:
1721: IF p_create_update_flag = 'C' AND
1722: l_column_value <> FND_API.G_MISS_CHAR AND
1723: l_column_value <> NVL(p_default_value, FND_API.G_MISS_CHAR)
1724: THEN
1725: RETURN 'Y';
1726: ELSE

Line 1723: l_column_value <> NVL(p_default_value, FND_API.G_MISS_CHAR)

1719: l_column_value := NVL(p_column_value, FND_API.G_MISS_CHAR);
1720:
1721: IF p_create_update_flag = 'C' AND
1722: l_column_value <> FND_API.G_MISS_CHAR AND
1723: l_column_value <> NVL(p_default_value, FND_API.G_MISS_CHAR)
1724: THEN
1725: RETURN 'Y';
1726: ELSE
1727: l_old_column_value := NVL(p_old_column_value, FND_API.G_MISS_CHAR);

Line 1727: l_old_column_value := NVL(p_old_column_value, FND_API.G_MISS_CHAR);

1723: l_column_value <> NVL(p_default_value, FND_API.G_MISS_CHAR)
1724: THEN
1725: RETURN 'Y';
1726: ELSE
1727: l_old_column_value := NVL(p_old_column_value, FND_API.G_MISS_CHAR);
1728:
1729: IF l_column_value <> l_old_column_value AND
1730: l_column_value <> NVL(p_default_value, FND_API.G_MISS_CHAR)
1731: THEN

Line 1730: l_column_value <> NVL(p_default_value, FND_API.G_MISS_CHAR)

1726: ELSE
1727: l_old_column_value := NVL(p_old_column_value, FND_API.G_MISS_CHAR);
1728:
1729: IF l_column_value <> l_old_column_value AND
1730: l_column_value <> NVL(p_default_value, FND_API.G_MISS_CHAR)
1731: THEN
1732: RETURN 'Y';
1733: END IF;
1734: END IF;

Line 1753: l_column_value := NVL(p_column_value, FND_API.G_MISS_NUM);

1749: l_old_column_value NUMBER;
1750:
1751: BEGIN
1752:
1753: l_column_value := NVL(p_column_value, FND_API.G_MISS_NUM);
1754:
1755: IF p_create_update_flag = 'C' AND
1756: l_column_value <> FND_API.G_MISS_NUM AND
1757: l_column_value <> NVL(p_default_value, FND_API.G_MISS_NUM)

Line 1756: l_column_value <> FND_API.G_MISS_NUM AND

1752:
1753: l_column_value := NVL(p_column_value, FND_API.G_MISS_NUM);
1754:
1755: IF p_create_update_flag = 'C' AND
1756: l_column_value <> FND_API.G_MISS_NUM AND
1757: l_column_value <> NVL(p_default_value, FND_API.G_MISS_NUM)
1758: THEN
1759: RETURN 'Y';
1760: ELSE

Line 1757: l_column_value <> NVL(p_default_value, FND_API.G_MISS_NUM)

1753: l_column_value := NVL(p_column_value, FND_API.G_MISS_NUM);
1754:
1755: IF p_create_update_flag = 'C' AND
1756: l_column_value <> FND_API.G_MISS_NUM AND
1757: l_column_value <> NVL(p_default_value, FND_API.G_MISS_NUM)
1758: THEN
1759: RETURN 'Y';
1760: ELSE
1761: l_old_column_value := NVL(p_old_column_value, FND_API.G_MISS_NUM);

Line 1761: l_old_column_value := NVL(p_old_column_value, FND_API.G_MISS_NUM);

1757: l_column_value <> NVL(p_default_value, FND_API.G_MISS_NUM)
1758: THEN
1759: RETURN 'Y';
1760: ELSE
1761: l_old_column_value := NVL(p_old_column_value, FND_API.G_MISS_NUM);
1762:
1763: IF l_column_value <> l_old_column_value AND
1764: l_column_value <> NVL(p_default_value, FND_API.G_MISS_NUM)
1765: THEN

Line 1764: l_column_value <> NVL(p_default_value, FND_API.G_MISS_NUM)

1760: ELSE
1761: l_old_column_value := NVL(p_old_column_value, FND_API.G_MISS_NUM);
1762:
1763: IF l_column_value <> l_old_column_value AND
1764: l_column_value <> NVL(p_default_value, FND_API.G_MISS_NUM)
1765: THEN
1766: RETURN 'Y';
1767: END IF;
1768: END IF;

Line 1787: l_column_value := NVL(p_column_value, FND_API.G_MISS_DATE);

1783: l_old_column_value DATE;
1784:
1785: BEGIN
1786:
1787: l_column_value := NVL(p_column_value, FND_API.G_MISS_DATE);
1788:
1789: IF p_create_update_flag = 'C' AND
1790: l_column_value <> FND_API.G_MISS_DATE AND
1791: l_column_value <> NVL(p_default_value, FND_API.G_MISS_DATE)

Line 1790: l_column_value <> FND_API.G_MISS_DATE AND

1786:
1787: l_column_value := NVL(p_column_value, FND_API.G_MISS_DATE);
1788:
1789: IF p_create_update_flag = 'C' AND
1790: l_column_value <> FND_API.G_MISS_DATE AND
1791: l_column_value <> NVL(p_default_value, FND_API.G_MISS_DATE)
1792: THEN
1793: RETURN 'Y';
1794: ELSE

Line 1791: l_column_value <> NVL(p_default_value, FND_API.G_MISS_DATE)

1787: l_column_value := NVL(p_column_value, FND_API.G_MISS_DATE);
1788:
1789: IF p_create_update_flag = 'C' AND
1790: l_column_value <> FND_API.G_MISS_DATE AND
1791: l_column_value <> NVL(p_default_value, FND_API.G_MISS_DATE)
1792: THEN
1793: RETURN 'Y';
1794: ELSE
1795: l_old_column_value := NVL(p_old_column_value, FND_API.G_MISS_DATE);

Line 1795: l_old_column_value := NVL(p_old_column_value, FND_API.G_MISS_DATE);

1791: l_column_value <> NVL(p_default_value, FND_API.G_MISS_DATE)
1792: THEN
1793: RETURN 'Y';
1794: ELSE
1795: l_old_column_value := NVL(p_old_column_value, FND_API.G_MISS_DATE);
1796:
1797: IF l_column_value <> l_old_column_value AND
1798: l_column_value <> NVL(p_default_value, FND_API.G_MISS_DATE) AND
1799: ((p_api_version = 'V1' AND

Line 1798: l_column_value <> NVL(p_default_value, FND_API.G_MISS_DATE) AND

1794: ELSE
1795: l_old_column_value := NVL(p_old_column_value, FND_API.G_MISS_DATE);
1796:
1797: IF l_column_value <> l_old_column_value AND
1798: l_column_value <> NVL(p_default_value, FND_API.G_MISS_DATE) AND
1799: ((p_api_version = 'V1' AND
1800: (p_column_value IS NULL)) OR
1801: (p_api_version = 'V2' AND
1802: p_column_value IS NOT NULL))

Line 1817: * Set x_return_status to FND_API.G_RET_STS_ERROR when

1813: * FUNCTION Check_ObsoleteColumn
1814: *
1815: * DESCRIPTION
1816: * Internal use only!!
1817: * Set x_return_status to FND_API.G_RET_STS_ERROR when
1818: * user is trying to pass value into an obsolete column
1819: * in development site.
1820: *
1821: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 1831: * FND_API.G_MISS_XXX and for V2 API, we do

1827: * p_column Column name.
1828: * p_column_value Value of the column.
1829: * p_default_value Default value of the column. Please note,
1830: * for V1 API, most columns are defaulted to
1831: * FND_API.G_MISS_XXX and for V2 API, we do
1832: * not have default value for most columns.
1833: * p_old_column_value Database value of the column. Only used
1834: * in update mode.
1835: * OUT:

Line 1836: * x_return_status Return FND_API.G_RET_STS_ERROR if user

1832: * not have default value for most columns.
1833: * p_old_column_value Database value of the column. Only used
1834: * in update mode.
1835: * OUT:
1836: * x_return_status Return FND_API.G_RET_STS_ERROR if user
1837: * is trying to pass value into an obsolete
1838: * column in development site.
1839: *
1840: * NOTES

Line 1872: x_return_status := FND_API.G_RET_STS_ERROR;

1868: THEN
1869: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OBSOLETE_COLUMN' );
1870: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
1871: FND_MSG_PUB.ADD;
1872: x_return_status := FND_API.G_RET_STS_ERROR;
1873: END IF;
1874:
1875: END Check_ObsoleteColumn;
1876:

Line 2441: p_display_purpose IN VARCHAR2 := fnd_api.g_true)

2437: **/
2438:
2439: function get_primary_phone (
2440: p_party_id IN NUMBER,
2441: p_display_purpose IN VARCHAR2 := fnd_api.g_true)
2442: RETURN VARCHAR2 IS
2443: l_contact_point_id NUMBER;
2444: BEGIN
2445:

Line 3105: p_created_by_module <> fnd_api.g_miss_char AND

3101: END IF;
3102:
3103: -- created_by_module is lookup code in lookup type HZ_CREATED_BY_MODULES
3104: IF p_created_by_module IS NOT NULL AND
3105: p_created_by_module <> fnd_api.g_miss_char AND
3106: (p_create_update_flag = 'C' OR
3107: (p_create_update_flag = 'U' AND
3108: (p_old_created_by_module IS NULL OR
3109: p_created_by_module <> p_old_created_by_module)))