APPS.AMS_IBA_PL_STYLESHEETS_PVT dependencies on JTF_PLSQL_API

Line 159: , p_validation_mode => JTF_PLSQL_API.g_create

155: , p_iba_pl_stylesheets_rec => p_iba_pl_stylesheets_rec
156: , x_return_status => x_return_status
157: , x_msg_count => x_msg_count
158: , x_msg_data => x_msg_data
159: , p_validation_mode => JTF_PLSQL_API.g_create
160: );
161: END IF;
162:
163: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

Line 382: , p_validation_mode => JTF_PLSQL_API.g_update

378: , p_iba_pl_stylesheets_rec => p_iba_pl_stylesheets_rec
379: , x_return_status => x_return_status
380: , x_msg_count => x_msg_count
381: , x_msg_data => x_msg_data
382: , p_validation_mode => JTF_PLSQL_API.g_update
383: );
384:
385: END IF;
386:

Line 535: , p_validation_mode => JTF_PLSQL_API.g_update

531:
532: --Check if the style to be deleted is being used in any of placements, if so, it should not be deleted.
533: l_style_placements := check_style_placements(
534: p_STYLESHEET_ID => p_STYLESHEET_ID
535: , p_validation_mode => JTF_PLSQL_API.g_update
536: , x_return_status => x_return_status
537: );
538:
539: IF (l_style_placements <> 0)

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

744:
745:
746: PROCEDURE check_iba_pl_style_uk_items(
747: p_iba_pl_stylesheets_rec IN iba_pl_stylesheets_rec_type,
748: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
749: x_return_status OUT NOCOPY VARCHAR2)
750: IS
751: l_valid_flag VARCHAR2(1);
752: l_style_name_flag VARCHAR2(1);

Line 758: if p_validation_mode = JTF_PLSQL_API.g_create then

754:
755: BEGIN
756: x_return_status := FND_API.g_ret_sts_success;
757: --If Validation_mode is create, check uniqueness of style name, stylesheet filename
758: if p_validation_mode = JTF_PLSQL_API.g_create then
759: -- Checking if the style name passed is unique
760: l_style_name_flag := ams_utility_pvt.check_uniqueness(
761: 'ams_iba_pl_styleshts_vl'
762: , 'name = ''' || p_iba_pl_stylesheets_rec.name ||''' and content_type = ''' || p_iba_pl_stylesheets_rec.content_type || ''''

Line 784: if p_validation_mode = JTF_PLSQL_API.g_update then

780: end if;
781: end if;
782:
783: --If Validation_mode is update, check uniqueness of style name, stylesheet filename
784: if p_validation_mode = JTF_PLSQL_API.g_update then
785: -- Checking if the style name passed is unique
786: l_style_name_flag := ams_utility_pvt.check_uniqueness(
787: 'ams_iba_pl_styleshts_vl'
788: , 'name = ''' || p_iba_pl_stylesheets_rec.name ||''' and STYLESHEET_ID <> ' || p_iba_pl_stylesheets_rec.STYLESHEET_ID || ' and CONTENT_TYPE = ''' || p_iba_pl_stylesheets_rec.CONTENT_TYPE || ''''

Line 813: -- IF p_validation_mode = JTF_PLSQL_API.g_create THEN

809: end if;
810: end if;
811:
812:
813: -- IF p_validation_mode = JTF_PLSQL_API.g_create THEN
814: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness(
815: -- 'AMS_IBA_PL_STYLESHTS_B',
816: -- 'STYLESHEET_ID = ''' || p_iba_pl_stylesheets_rec.STYLESHEET_ID ||''''
817: -- );

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

832: END check_iba_pl_style_uk_items;
833:
834: PROCEDURE check_iba_pl_style_req_items(
835: p_iba_pl_stylesheets_rec IN iba_pl_stylesheets_rec_type,
836: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
837: x_return_status OUT NOCOPY VARCHAR2
838: )
839: IS
840: BEGIN

Line 843: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

839: IS
840: BEGIN
841: x_return_status := FND_API.g_ret_sts_success;
842:
843: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
844:
845:
846: IF p_iba_pl_stylesheets_rec.stylesheet_id = FND_API.g_miss_num OR p_iba_pl_stylesheets_rec.stylesheet_id IS NULL THEN
847: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_stylesheets_NO_stylesheet_id');

Line 1123: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1119: IF FND_API.to_Boolean( p_init_msg_list )
1120: THEN
1121: FND_MSG_PUB.initialize;
1122: END IF;
1123: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1124: Check_iba_pl_style_Items(
1125: p_iba_pl_stylesheets_rec => p_iba_pl_stylesheets_rec,
1126: p_validation_mode => p_validation_mode,
1127: x_return_status => x_return_status

Line 1142: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1138: p_iba_pl_stylesheets_rec => p_iba_pl_stylesheets_rec,
1139: x_complete_rec => l_iba_pl_stylesheets_rec
1140: );
1141:
1142: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1143: Validate_iba_pl_style_rec(
1144: p_api_version_number => 1.0,
1145: p_init_msg_list => FND_API.G_FALSE,
1146: x_return_status => x_return_status,