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 AMS_UTILITY_PVT

Line 49: AMS_Utility_PVT.debug_message(l_full_name || ': start');

45: BEGIN
46: -- initialize
47: SAVEPOINT create_market_segments;
48:
49: AMS_Utility_PVT.debug_message(l_full_name || ': start');
50:
51: IF FND_API.to_boolean(p_init_msg_list) THEN
52: FND_MSG_PUB.initialize;
53: END IF;

Line 73: AMS_Utility_PVT.debug_message(l_full_name || ': 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: (
77: p_api_version => l_api_version,

Line 96: AMS_Utility_PVT.debug_message(l_full_name || ': insert');

92: END IF;
93: -- END IF;
94:
95: -- insert
96: AMS_Utility_PVT.debug_message(l_full_name || ': insert');
97:
98: IF l_mks_rec.activity_market_segment_id IS NULL THEN
99: LOOP
100: OPEN c_mks_seq;

Line 217: AMS_Utility_PVT.debug_message(l_full_name || ': end');

213: p_count => x_msg_count,
214: p_data => x_msg_data
215: );
216:
217: AMS_Utility_PVT.debug_message(l_full_name || ': end');
218:
219: EXCEPTION
220:
221: WHEN FND_API.g_exc_error THEN

Line 288: AMS_Utility_PVT.debug_message(l_full_name || ': start');

284:
285: -- initialize
286: SAVEPOINT update_market_segments;
287:
288: AMS_Utility_PVT.debug_message(l_full_name || ': start');
289:
290: IF FND_API.to_boolean(p_init_msg_list) THEN
291: FND_MSG_PUB.initialize;
292: END IF;

Line 309: AMS_Utility_PVT.debug_message(l_full_name || ': validate');

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,
313: p_validation_mode => JTF_PLSQL_API.g_update,

Line 365: AMS_Utility_PVT.debug_message(l_full_name||': update');

361: /* End Of Code added by ptendulk */
362:
363:
364: -- update
365: AMS_Utility_PVT.debug_message(l_full_name||': update');
366:
367: UPDATE AMS_ACT_MARKET_SEGMENTS SET
368: last_update_date = SYSDATE,
369: last_updated_by = FND_GLOBAL.user_id,

Line 417: AMS_Utility_PVT.debug_message(l_full_name || ': end');

413: p_count => x_msg_count,
414: p_data => x_msg_data
415: );
416:
417: AMS_Utility_PVT.debug_message(l_full_name || ': end');
418:
419: EXCEPTION
420:
421: WHEN FND_API.g_exc_error THEN

Line 501: AMS_Utility_PVT.debug_message(l_full_name || ': start');

497: BEGIN
498: -- initialize
499: SAVEPOINT delete_market_segments;
500:
501: AMS_Utility_PVT.debug_message(l_full_name || ': start');
502:
503: IF FND_API.to_boolean(p_init_msg_list) THEN
504: FND_MSG_PUB.initialize;
505: END IF;

Line 521: AMS_Utility_PVT.debug_message(l_full_name || ': delete');

517:
518: x_return_status := FND_API.g_ret_sts_success;
519:
520: -- delete
521: AMS_Utility_PVT.debug_message(l_full_name || ': delete');
522:
523: -- Following code is added by ptendulk on 14th Feb 2000
524: -- to update Attribute after deletion
525: -- indicate if there is any other schedule for this campaign

Line 588: AMS_Utility_PVT.debug_message(l_full_name || ': end');

584: p_count => x_msg_count,
585: p_data => x_msg_data
586: );
587:
588: AMS_Utility_PVT.debug_message(l_full_name || ': end');
589:
590: EXCEPTION
591:
592: WHEN FND_API.g_exc_error THEN

Line 662: AMS_Utility_PVT.debug_message(l_full_name || ': start');

658: FOR UPDATE NOWAIT;
659:
660: BEGIN
661: -- initialize
662: AMS_Utility_PVT.debug_message(l_full_name || ': start');
663:
664: IF FND_API.to_boolean(p_init_msg_list) THEN
665: FND_MSG_PUB.initialize;
666: END IF;

Line 682: AMS_Utility_PVT.debug_message(l_full_name || ': lock');

678:
679: x_return_status := FND_API.g_ret_sts_success;
680:
681: -- lock
682: AMS_Utility_PVT.debug_message(l_full_name || ': lock');
683:
684: OPEN c_obj;
685: FETCH c_obj INTO l_mks_id;
686: IF (c_obj%NOTFOUND) THEN

Line 704: AMS_Utility_PVT.debug_message(l_full_name || ': end');

700: p_count => x_msg_count,
701: p_data => x_msg_data
702: );
703:
704: AMS_Utility_PVT.debug_message(l_full_name || ': end');
705:
706: EXCEPTION
707:
708: WHEN AMS_Utility_PVT.resource_locked THEN

Line 708: WHEN AMS_Utility_PVT.resource_locked THEN

704: AMS_Utility_PVT.debug_message(l_full_name || ': end');
705:
706: EXCEPTION
707:
708: WHEN AMS_Utility_PVT.resource_locked THEN
709: x_return_status := FND_API.g_ret_sts_error;
710: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
711: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
712: FND_MSG_PUB.add;

Line 784: AMS_Utility_PVT.debug_message(l_full_name || ': start');

780: l_return_status VARCHAR2(1);
781:
782: BEGIN
783: -- initialize
784: AMS_Utility_PVT.debug_message(l_full_name || ': start');
785:
786: IF FND_API.to_boolean(p_init_msg_list) THEN
787: FND_MSG_PUB.initialize;
788: END IF;

Line 804: AMS_Utility_PVT.debug_message(l_full_name || ': check required items');

800:
801: x_return_status := FND_API.g_ret_sts_success;
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,

Line 825: AMS_Utility_PVT.debug_message(l_full_name||': check cross Entity');

821: ---------------------- validate Segment Cross Entity Records ------------------------
822: --
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(

Line 848: AMS_Utility_PVT.debug_message(l_full_name||': check record');

844: --
845: -- Debug Message
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,

Line 871: AMS_Utility_PVT.debug_message(l_full_name ||': end');

867: p_count => x_msg_count,
868: p_data => x_msg_data
869: );
870:
871: AMS_Utility_PVT.debug_message(l_full_name ||': end');
872:
873: EXCEPTION
874:
875: WHEN FND_API.g_exc_error THEN

Line 1043: -- l_fk_flag := AMS_Utility_PVT.check_fk_exists

1039: -- we need to account for G_MISS_NUM /CHAR for arc_act_market_segment_used_by
1040: -- Checking of act_market_segment_used_by_id will be done is Validate record
1041: --
1042: -- IF UPPER(p_mks_rec.arc_act_market_segment_used_by) = 'CAMP' THEN
1043: -- l_fk_flag := AMS_Utility_PVT.check_fk_exists
1044: -- (
1045: -- 'AMS_CAMPAIGNS_VL',
1046: -- 'campaign_id',
1047: -- p_mks_rec.act_market_segment_used_by_id

Line 1050: -- l_fk_flag := AMS_Utility_PVT.check_fk_exists

1046: -- 'campaign_id',
1047: -- p_mks_rec.act_market_segment_used_by_id
1048: -- );
1049: -- ELSIF UPPER(p_mks_rec.arc_act_market_segment_used_by) = 'EVEH' THEN
1050: -- l_fk_flag := AMS_Utility_PVT.check_fk_exists
1051: -- (
1052: -- 'AMS_EVENT_HEADERS_VL',
1053: -- 'event_header_id',
1054: -- p_mks_rec.act_market_segment_used_by_id

Line 1057: -- l_fk_flag := AMS_Utility_PVT.check_fk_exists

1053: -- 'event_header_id',
1054: -- p_mks_rec.act_market_segment_used_by_id
1055: -- );
1056: -- ELSIF UPPER(p_mks_rec.arc_act_market_segment_used_by) = 'EVEO' THEN
1057: -- l_fk_flag := AMS_Utility_PVT.check_fk_exists
1058: -- (
1059: -- 'AMS_EVENT_OFFERS_VL',
1060: -- 'event_offer_id',
1061: -- p_mks_rec.act_market_segment_used_by_id

Line 1138: IF AMS_Utility_PVT.check_uniqueness(

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',
1140: 'activity_market_segment_id = ' || p_mks_rec.activity_market_segment_id
1141: ) = FND_API.g_false
1142: THEN

Line 1176: l_lookup_flag := AMS_Utility_PVT.check_lookup_exists

1172: x_return_status := FND_API.g_ret_sts_success;
1173: /* removed by julou. there is no segment type any more
1174: IF p_mks_rec.segment_type IS NOT NULL
1175: AND p_mks_rec.segment_type <> FND_API.g_miss_char THEN
1176: l_lookup_flag := AMS_Utility_PVT.check_lookup_exists
1177: (
1178: p_lookup_type => 'AMS_MKT_SEGMENT_TYPE',
1179: p_lookup_code => p_mks_rec.segment_type
1180: );

Line 1195: l_lookup_flag := AMS_Utility_PVT.check_lookup_exists

1191: END IF;
1192: */
1193: /*IF p_mks_rec.exclude_flag IS NOT NULL
1194: AND p_mks_rec.exclude_flag <> FND_API.g_miss_char THEN
1195: l_lookup_flag := AMS_Utility_PVT.check_lookup_exists
1196: (
1197: p_lookup_type => 'AMS_SEGMENT_CONDITIONS',
1198: p_lookup_code => p_mks_rec.exclude_flag
1199: );

Line 1339: IF AMS_Utility_PVT.Check_Uniqueness(

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(
1340: p_table_name => 'ams_act_market_segments',
1341: p_where_clause => l_where_clause
1342: ) = FND_API.g_false
1343: THEN

Line 1399: -- l_fk_flag := AMS_Utility_PVT.check_fk_exists

1395: --
1396: x_return_status := FND_API.g_ret_sts_success;
1397:
1398: -- ELSIF UPPER(p_mks_rec.arc_act_market_segment_used_by) = 'EVEO' THEN
1399: -- l_fk_flag := AMS_Utility_PVT.check_fk_exists
1400: -- (
1401: -- 'AMS_EVENT_OFFERS_VL',
1402: -- 'event_offer_id',
1403: -- p_mks_rec.act_market_segment_used_by_id

Line 1423: AMS_Utility_PVT.Get_Qual_Table_Name_And_PK (

1419: END IF;
1420:
1421:
1422: -- Get table_name and pk_name for the ARC qualifier.
1423: AMS_Utility_PVT.Get_Qual_Table_Name_And_PK (
1424: p_sys_qual => l_mks_used_by,
1425: x_return_status => x_return_status,
1426: x_table_name => l_table_name,
1427: x_pk_name => l_pk_name

Line 1431: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;

1427: x_pk_name => l_pk_name
1428: );
1429:
1430: l_pk_value := l_mks_used_by_id;
1431: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
1432: l_additional_where_clause := NULL;
1433:
1434:
1435: IF AMS_Utility_PVT.Check_FK_Exists (

Line 1435: IF AMS_Utility_PVT.Check_FK_Exists (

1431: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
1432: l_additional_where_clause := NULL;
1433:
1434:
1435: IF AMS_Utility_PVT.Check_FK_Exists (
1436: p_table_name => l_table_name
1437: ,p_pk_name => l_pk_name
1438: ,p_pk_value => l_pk_value
1439: ,p_pk_data_type => l_pk_data_type

Line 1479: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;

1475:
1476: l_table_name := 'AMS_CELLS_VL';
1477: l_pk_name := 'CELL_ID';
1478: l_pk_value := l_market_segment_id;
1479: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
1480: /*
1481: IF AMS_Utility_PVT.Check_FK_Exists (
1482: p_table_name => l_table_name
1483: ,p_pk_name => l_pk_name

Line 1481: IF AMS_Utility_PVT.Check_FK_Exists (

1477: l_pk_name := 'CELL_ID';
1478: l_pk_value := l_market_segment_id;
1479: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
1480: /*
1481: IF AMS_Utility_PVT.Check_FK_Exists (
1482: p_table_name => l_table_name
1483: ,p_pk_name => l_pk_name
1484: ,p_pk_value => l_pk_value
1485: ,p_pk_data_type => l_pk_data_type