APPS.AMS_LISTHEADER_PVT dependencies on JTF_PLSQL_API

Line 471: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

467: -- 10/12/99 tdonohoe Created.
468: ---------------------------------------------------------------------
469: PROCEDURE check_list_uk_items(
470: p_listheader_rec IN list_header_rec_type,
471: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
472: x_return_status OUT NOCOPY VARCHAR2
473: )
474: IS
475: l_valid_flag VARCHAR2(1);

Line 512: IF ( p_validation_mode = JTF_PLSQL_API.g_create

508: -----------------------------------------------------------------
509: -- For create_listheader, when list_header_id is passed in,
510: -- we need to check if this list_header_id is unique.
511: -----------------------------------------------------------------
512: IF ( p_validation_mode = JTF_PLSQL_API.g_create
513: AND p_listheader_rec.list_header_id IS NOT NULL) THEN
514:
515: IF AMS_Utility_PVT.check_uniqueness(
516: 'ams_list_headers_all',

Line 537: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

533: -- update differently.
534: -----------------------------------------------------------------
535: IF (p_listheader_rec.view_application_id <> 522
536: and p_listheader_rec.view_application_id <> 691 )then
537: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
538: open c_check_create_mode;
539: fetch c_check_create_mode into l_valid_flag ;
540: close c_check_create_mode;
541: ELSE

Line 547: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

543: fetch c_check_update_mode into l_valid_flag ;
544: close c_check_update_mode;
545: END IF;
546: ELSE
547: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
548: open c_check_create_mode_02 ;
549: fetch c_check_create_mode_02 into l_valid_flag ;
550: close c_check_create_mode_02 ;
551: ELSE

Line 947: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

943:
944:
945: PROCEDURE Validate_List_Items
946: ( p_listheader_rec IN list_header_rec_type,
947: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
948: x_return_status OUT NOCOPY VARCHAR2
949: ) IS
950:
951: BEGIN

Line 1068: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1064: --
1065:
1066: -- Step 1.
1067: -- Validate all non missing attributes (Item level validation)
1068: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1069: Validate_List_Items
1070: ( p_listheader_rec => l_listheader_rec,
1071: p_validation_mode => JTF_PLSQL_API.g_update,
1072: x_return_status => x_return_status

Line 1071: p_validation_mode => JTF_PLSQL_API.g_update,

1067: -- Validate all non missing attributes (Item level validation)
1068: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1069: Validate_List_Items
1070: ( p_listheader_rec => l_listheader_rec,
1071: p_validation_mode => JTF_PLSQL_API.g_update,
1072: x_return_status => x_return_status
1073: );
1074: -- If any errors happen abort API.
1075: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1086: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1082:
1083: -- Step 2.
1084: -- Perform cross attribute validation and missing attribute checks. Record
1085: -- level validation.
1086: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1087:
1088: Validate_List_Record
1089: ( p_listheader_rec => p_listheader_rec,
1090: p_complete_rec => l_listheader_rec,

Line 1804: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1800:
1801:
1802:
1803: ----------------------- validate ----------------------
1804: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1805: Validate_list_items(
1806: p_listheader_rec => l_listheader_rec,
1807: p_validation_mode => JTF_PLSQL_API.g_update,
1808: x_return_status => x_return_status

Line 1807: p_validation_mode => JTF_PLSQL_API.g_update,

1803: ----------------------- validate ----------------------
1804: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1805: Validate_list_items(
1806: p_listheader_rec => l_listheader_rec,
1807: p_validation_mode => JTF_PLSQL_API.g_update,
1808: x_return_status => x_return_status
1809: );
1810:
1811: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1830: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1826: AMS_Utility_PVT.debug_message('AMS_ListHeaders_PVT.Update_listheaders: Item level validation');
1827: END IF;
1828:
1829:
1830: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1831: Validate_list_record(
1832: p_listheader_rec => p_listheader_rec,
1833: p_complete_rec => l_listheader_rec,
1834: x_return_status => x_return_status