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.AMS_ACT_MARKET_SEGMENTS_PVT dependencies on JTF_PLSQL_API

Line 72: -- IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

68: -- validate
69: -- Following code is Modified by ptendulk as the Validation level Check
70: -- is done in Validate API
71:
72: -- IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
73: AMS_Utility_PVT.debug_message(l_full_name || ': validate');
74:
75: validate_market_segments
76: (

Line 308: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

304:
305: x_return_status := FND_API.g_ret_sts_success;
306:
307: -- validate
308: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
309: AMS_Utility_PVT.debug_message(l_full_name || ': validate');
310:
311: check_mks_items(
312: p_mks_rec => p_mks_rec,

Line 313: p_validation_mode => JTF_PLSQL_API.g_update,

309: AMS_Utility_PVT.debug_message(l_full_name || ': validate');
310:
311: check_mks_items(
312: p_mks_rec => p_mks_rec,
313: p_validation_mode => JTF_PLSQL_API.g_update,
314: x_return_status => l_return_status
315: );
316:
317: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 331: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

327: );
328: /* Start Of Code added by ptendulk */
329:
330:
331: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
332: Validate_cross_ent_Rec(
333: p_mks_rec => p_mks_rec,
334: p_complete_rec => l_mks_rec,
335: p_validation_mode => JTF_PLSQL_API.g_update,

Line 335: p_validation_mode => JTF_PLSQL_API.g_update,

331: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
332: Validate_cross_ent_Rec(
333: p_mks_rec => p_mks_rec,
334: p_complete_rec => l_mks_rec,
335: p_validation_mode => JTF_PLSQL_API.g_update,
336: x_return_status => l_return_status
337: );
338:
339: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 347: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

343: END IF;
344: END IF;
345:
346:
347: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
348: check_mks_record(
349: p_mks_rec => p_mks_rec,
350: p_complete_rec => l_mks_rec,
351: x_return_status => l_return_status

Line 806: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

802:
803: ---------------------- validate Segment Items ------------------------
804: AMS_Utility_PVT.debug_message(l_full_name || ': check required items');
805:
806: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
807: Check_Mks_items(
808: p_mks_rec => p_mks_rec,
809: p_validation_mode => JTF_PLSQL_API.g_create,
810: x_return_status => l_return_status

Line 809: p_validation_mode => JTF_PLSQL_API.g_create,

805:
806: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
807: Check_Mks_items(
808: p_mks_rec => p_mks_rec,
809: p_validation_mode => JTF_PLSQL_API.g_create,
810: x_return_status => l_return_status
811: ) ;
812:
813: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 827: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

823: -- Debug Message
824: --
825: AMS_Utility_PVT.debug_message(l_full_name||': check cross Entity');
826:
827: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
828:
829: Validate_cross_ent_Rec(
830: p_mks_rec => p_mks_rec,
831: p_complete_rec => NULL,

Line 832: p_validation_mode => JTF_PLSQL_API.g_create,

828:
829: Validate_cross_ent_Rec(
830: p_mks_rec => p_mks_rec,
831: p_complete_rec => NULL,
832: p_validation_mode => JTF_PLSQL_API.g_create,
833: x_return_status => l_return_status
834: );
835:
836: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 850: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

846: --
847:
848: AMS_Utility_PVT.debug_message(l_full_name||': check record');
849:
850: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
851: Check_Mks_Record(
852: p_mks_rec => p_mks_rec,
853: p_complete_rec => NULL,
854: x_return_status => l_return_status

Line 928: -- AND p_validation_mode = JTF_PLSQL_API.g_update

924:
925: /* Start of code commented by ptendulk */
926: -- check activity_market_segment_id
927: -- IF p_mks_rec.activity_market_segment_id IS NULL
928: -- AND p_validation_mode = JTF_PLSQL_API.g_update
929: -- THEN
930: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
931: -- FND_MESSAGE.set_name('AMS', 'AMS_MKS_NO_ACT_MKS_ID');
932: -- FND_MSG_PUB.add;

Line 942: -- AND p_validation_mode = JTF_PLSQL_API.g_update

938:
939:
940: -- check object_version_number
941: -- IF p_mks_rec.object_version_number IS NULL
942: -- AND p_validation_mode = JTF_PLSQL_API.g_update
943: -- THEN
944: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
945: -- FND_MESSAGE.set_name('AMS', 'AMS_MKS_NO_OBJ_VER_NUM');
946: -- FND_MSG_PUB.add;

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

1119: -- End of Comments
1120:
1121: PROCEDURE Check_Mks_Uk_Items(
1122: p_mks_rec IN mks_rec_type,
1123: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1124: x_return_status OUT NOCOPY VARCHAR2
1125: )
1126: IS
1127: l_valid_flag VARCHAR2(1);

Line 1135: IF p_validation_mode = JTF_PLSQL_API.g_create

1131: x_return_status := FND_API.g_ret_sts_success;
1132:
1133: -- For create_market Segments, when ACTIVITY_MARKET_SEGMENT_ID is passed in, we need to
1134: -- check if this ACTIVITY_MARKET_SEGMENT_ID is unique.
1135: IF p_validation_mode = JTF_PLSQL_API.g_create
1136: AND p_mks_rec.activity_market_segment_id IS NOT NULL
1137: THEN
1138: IF AMS_Utility_PVT.check_uniqueness(
1139: 'ams_act_market_segments',

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

1225: -- End of Comments
1226:
1227: PROCEDURE check_Mks_items(
1228: p_mks_rec IN mks_rec_type,
1229: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1230: x_return_status OUT NOCOPY VARCHAR2
1231: )
1232: IS
1233: BEGIN

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

1287: -- End of Comments
1288: PROCEDURE Validate_cross_ent_Rec(
1289: p_mks_rec IN mks_rec_type,
1290: p_complete_rec IN mks_rec_type,
1291: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1292: x_return_status OUT NOCOPY VARCHAR2
1293: )
1294: IS
1295: l_mks_used_by_id NUMBER ;

Line 1335: IF p_validation_mode <> JTF_PLSQL_API.g_create THEN

1331: ' and arc_act_market_segment_used_by = '||''''||l_mks_used_by||'''' ;
1332:
1333:
1334: -- For Updates, must also check that uniqueness is not checked against the same record.
1335: IF p_validation_mode <> JTF_PLSQL_API.g_create THEN
1336: l_where_clause := l_where_clause || ' AND activity_market_segment_id <> ' || p_mks_rec.activity_market_segment_id;
1337: END IF;
1338:
1339: IF AMS_Utility_PVT.Check_Uniqueness(