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_LISTHEADER_PVT dependencies on AMS_UTILITY_PVT

Line 105: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.ENABLE_LOG_FLAG) = FND_API.g_false THEN

101:
102: ----------------------- ENABLE_LOG_FLAG ------------------------
103: IF p_listheader_rec.ENABLE_LOG_FLAG <> FND_API.g_miss_char
104: AND p_listheader_rec.ENABLE_LOG_FLAG IS NOT NULL THEN
105: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.ENABLE_LOG_FLAG) = FND_API.g_false THEN
106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
107: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_LOG_FLAG');
108: FND_MSG_PUB.add;
109: END IF;

Line 118: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.ENABLE_WORD_REPLACEMENT_FLAG) = FND_API.g_false THEN

114:
115: ----------------------- ENABLE_WORD_REPLACEMENT_FLAG------------------------
116: IF p_listheader_rec.ENABLE_WORD_REPLACEMENT_FLAG <> FND_API.g_miss_char
117: AND p_listheader_rec.ENABLE_WORD_REPLACEMENT_FLAG IS NOT NULL THEN
118: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.ENABLE_WORD_REPLACEMENT_FLAG) = FND_API.g_false THEN
119: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
120: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_WORD_FLAG');
121: FND_MSG_PUB.add;
122: END IF;

Line 132: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.ENABLE_PARALLEL_DML_FLAG) = FND_API.g_false THEN

128:
129: ----------------------- ENABLE_PARALLEL_DML_FLAG------------------------
130: IF p_listheader_rec.ENABLE_PARALLEL_DML_FLAG <> FND_API.g_miss_char
131: AND p_listheader_rec.ENABLE_PARALLEL_DML_FLAG IS NOT NULL THEN
132: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.ENABLE_PARALLEL_DML_FLAG) = FND_API.g_false THEN
133: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
134: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_DML_FLAG');
135: FND_MSG_PUB.add;
136: END IF;

Line 146: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.DEDUPE_DURING_GENERATION_FLAG) = FND_API.g_false THEN

142:
143: ----------------------- DEDUPE_DURING_GENERATION_FLAG ------------------------
144: IF p_listheader_rec.DEDUPE_DURING_GENERATION_FLAG <> FND_API.g_miss_char
145: AND p_listheader_rec.DEDUPE_DURING_GENERATION_FLAG IS NOT NULL THEN
146: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.DEDUPE_DURING_GENERATION_FLAG) = FND_API.g_false THEN
147: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
148: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_DEDUPE_FLAG');
149: FND_MSG_PUB.add;
150: END IF;

Line 160: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.GENERATE_CONTROL_GROUP_FLAG) = FND_API.g_false

156:
157: ----------------------- GENERATE_CONTROL_GROUP_FLAG ------------------------
158: IF p_listheader_rec.GENERATE_CONTROL_GROUP_FLAG <> FND_API.g_miss_char
159: AND p_listheader_rec.GENERATE_CONTROL_GROUP_FLAG IS NOT NULL THEN
160: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.GENERATE_CONTROL_GROUP_FLAG) = FND_API.g_false
161: THEN
162: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
163: THEN
164: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_CONTROL_FLAG');

Line 178: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.LAST_GENERATION_SUCCESS_FLAG ) = FND_API.g_false

174:
175: IF p_listheader_rec.LAST_GENERATION_SUCCESS_FLAG <> FND_API.g_miss_char
176: AND p_listheader_rec.LAST_GENERATION_SUCCESS_FLAG IS NOT NULL
177: THEN
178: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.LAST_GENERATION_SUCCESS_FLAG ) = FND_API.g_false
179: THEN
180: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
181: THEN
182: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_GEN_FLAG');

Line 197: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.ENABLED_FLAG ) = FND_API.g_false

193:
194: IF p_listheader_rec.ENABLED_FLAG <> FND_API.g_miss_char
195: AND p_listheader_rec.ENABLED_FLAG IS NOT NULL
196: THEN
197: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.ENABLED_FLAG ) = FND_API.g_false
198: THEN
199: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
200: THEN
201: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_ENABLED_FLAG');

Line 216: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.PURGE_FLAG ) = FND_API.g_false

212:
213: IF p_listheader_rec.PURGE_FLAG <> FND_API.g_miss_char
214: AND p_listheader_rec.PURGE_FLAG IS NOT NULL
215: THEN
216: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.PURGE_FLAG ) = FND_API.g_false
217: THEN
218: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
219: THEN
220: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_PURGE_FLAG');

Line 278: IF AMS_Utility_PVT.check_lookup_exists(

274:
275: ----------------------- STATUS_CODE ------------------------
276: IF p_listheader_rec.status_code <> FND_API.g_miss_char
277: AND p_listheader_rec.status_code IS NOT NULL THEN
278: IF AMS_Utility_PVT.check_lookup_exists(
279: p_lookup_type => 'AMS_LIST_STATUS',
280: p_lookup_code => p_listheader_rec.status_code
281: ) = FND_API.g_false THEN
282: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 296: IF AMS_Utility_PVT.check_lookup_exists(

292: ----------------------- GENERATION_TYPE ------------------------
293: IF p_listheader_rec.generation_type <> FND_API.g_miss_char
294: AND p_listheader_rec.generation_type IS NOT NULL THEN
295:
296: IF AMS_Utility_PVT.check_lookup_exists(
297: p_lookup_type => 'AMS_LIST_GENERATION_TYPE',
298: p_lookup_code => p_listheader_rec.generation_type
299: ) = FND_API.g_false THEN
300: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 312: IF AMS_Utility_PVT.check_lookup_exists(

308:
309: ----------------------- ROW_SELECTION_TYPE -------------------------
310: IF p_listheader_rec.row_selection_type <> FND_API.g_miss_char
311: AND p_listheader_rec.row_selection_type IS NOT NULL THEN
312: IF AMS_Utility_PVT.check_lookup_exists(
313: p_lookup_type => 'AMS_LIST_ROW_SELECT_TYPE',
314: p_lookup_code => p_listheader_rec.row_selection_type
315: ) = FND_API.g_false THEN
316: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 328: IF AMS_Utility_PVT.check_lookup_exists(

324:
325: ----------------------- LIST TYPE ------------------------
326: IF p_listheader_rec.list_type <> FND_API.g_miss_char
327: AND p_listheader_rec.list_type IS NOT NULL THEN
328: IF AMS_Utility_PVT.check_lookup_exists(
329: p_lookup_type => 'AMS_LIST_TYPE',
330: p_lookup_code => p_listheader_rec.list_type
331: ) = FND_API.g_false THEN
332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 367: IF AMS_Utility_PVT.check_lookup_exists(

363:
364: ----------------------- PURPOSE_CODE ------------------------
365: IF p_listheader_rec.purpose_code <> FND_API.g_miss_char
366: AND p_listheader_rec.purpose_code IS NOT NULL THEN
367: IF AMS_Utility_PVT.check_lookup_exists(
368: p_lookup_type => 'AMS_ACTIVITY_PURPOSES',
369: p_lookup_code => p_listheader_rec.purpose_code
370: ) = FND_API.g_false THEN
371: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 403: IF AMS_Utility_PVT.check_fk_exists(

399:
400: ----------------------- TIMEZONE_ID ------------------------
401: IF p_listheader_rec.timezone_id <> FND_API.g_miss_num
402: AND p_listheader_rec.timezone_id IS NOT NULL THEN
403: IF AMS_Utility_PVT.check_fk_exists(
404: 'fnd_timezones_b',
405: 'upgrade_tz_id',
406: p_listheader_rec.timezone_id
407: ) = FND_API.g_false THEN

Line 419: IF AMS_Utility_PVT.check_fk_exists(

415: RETURN;
416: END IF;
417: END IF;
418: IF p_listheader_rec.owner_user_id <> FND_API.g_miss_num THEN
419: IF AMS_Utility_PVT.check_fk_exists(
420: 'jtf_rs_resource_extns',
421: 'resource_id',
422: p_listheader_rec.owner_user_id
423: ) = FND_API.g_false

Line 425: AMS_Utility_PVT.Error_Message('AMS_LIST_BAD_OWNER_USER_ID');

421: 'resource_id',
422: p_listheader_rec.owner_user_id
423: ) = FND_API.g_false
424: THEN
425: AMS_Utility_PVT.Error_Message('AMS_LIST_BAD_OWNER_USER_ID');
426: x_return_status := FND_API.g_ret_sts_error;
427: RETURN;
428: END IF;
429: END IF;

Line 433: IF AMS_Utility_PVT.check_fk_exists(

429: END IF;
430:
431: --------------------- view application_id ------------------------
432: IF p_listheader_rec.view_application_id <> FND_API.g_miss_num THEN
433: IF AMS_Utility_PVT.check_fk_exists(
434: 'fnd_application',
435: 'application_id',
436: p_listheader_rec.view_application_id
437: ) = FND_API.g_false

Line 439: AMS_Utility_PVT.Error_Message('AMS_LIST_BAD_APPLICATION_ID');

435: 'application_id',
436: p_listheader_rec.view_application_id
437: ) = FND_API.g_false
438: THEN
439: AMS_Utility_PVT.Error_Message('AMS_LIST_BAD_APPLICATION_ID');
440: x_return_status := FND_API.g_ret_sts_error;
441: RETURN;
442: END IF;
443: END IF;

Line 447: IF AMS_Utility_PVT.check_fk_exists(

443: END IF;
444:
445: --------------------- program application_id ------------------------
446: IF p_listheader_rec.program_application_id <> FND_API.g_miss_num THEN
447: IF AMS_Utility_PVT.check_fk_exists(
448: 'fnd_application',
449: 'application_id',
450: p_listheader_rec.program_application_id
451: ) = FND_API.g_false

Line 453: AMS_Utility_PVT.Error_Message('AMS_LIST_BAD_APPLICATION_ID');

449: 'application_id',
450: p_listheader_rec.program_application_id
451: ) = FND_API.g_false
452: THEN
453: AMS_Utility_PVT.Error_Message('AMS_LIST_BAD_APPLICATION_ID');
454: x_return_status := FND_API.g_ret_sts_error;
455: RETURN;
456: END IF;
457: END IF;

Line 515: IF AMS_Utility_PVT.check_uniqueness(

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',
517: 'list_header_id = ' || p_listheader_rec.list_header_id
518: ) = FND_API.g_false
519: THEN

Line 727: AMS_Utility_PVT.debug_message('AMS_ListHeader_PVT.Validate_List_Record: Start');

723: END IF; */
724:
725:
726: IF (AMS_DEBUG_HIGH_ON) THEN
727: AMS_Utility_PVT.debug_message('AMS_ListHeader_PVT.Validate_List_Record: Start');
728: END IF;
729:
730:
731: -- Initialize API return status to success

Line 804: AMS_UTILITY_PVT.get_qual_table_name_and_pk

800: --The List must be associated to a valid Marketing Activity.
801: -----------------------------------------------------------------------
802: IF(p_listheader_rec.arc_list_used_by <> FND_API.g_miss_char) THEN
803: IF(l_listheader_rec.arc_list_used_by <> 'NONE')THEN
804: AMS_UTILITY_PVT.get_qual_table_name_and_pk
805: (p_sys_qual => l_listheader_rec.arc_list_used_by,
806: x_return_status => x_return_status,
807: x_table_name => l_table_name,
808: x_pk_name => l_pk_name);

Line 811: IF(AMS_UTILITY_PVT.Check_FK_Exists(l_table_name,l_pk_name,p_listheader_rec.list_used_by_id) = FND_API.G_FALSE)THEN

807: x_table_name => l_table_name,
808: x_pk_name => l_pk_name);
809:
810: IF((l_table_name is not null) and (l_pk_name is not null))THEN
811: IF(AMS_UTILITY_PVT.Check_FK_Exists(l_table_name,l_pk_name,p_listheader_rec.list_used_by_id) = FND_API.G_FALSE)THEN
812: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
813: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACTIVITY_INVALID');
814: FND_MESSAGE.Set_Token('LIST_ACTIVITY_CODE',p_listheader_rec.arc_list_used_by);
815: FND_MSG_PUB.Add;

Line 1055: AMS_Utility_PVT.debug_message('AMS_ListHeaders_PVT.Validate_listheaders: Start');

1051: FND_MSG_PUB.Add;
1052: END IF; */
1053:
1054: IF (AMS_DEBUG_HIGH_ON) THEN
1055: AMS_Utility_PVT.debug_message('AMS_ListHeaders_PVT.Validate_listheaders: Start');
1056: END IF;
1057:
1058:
1059:

Line 1265: AMS_Utility_PVT.debug_message('AMS_ListHeaders_PVT.Create_listheaders: Start');

1261: FND_MSG_PUB.Add;
1262: END IF; */
1263:
1264: IF (AMS_DEBUG_HIGH_ON) THEN
1265: AMS_Utility_PVT.debug_message('AMS_ListHeaders_PVT.Create_listheaders: Start');
1266: END IF;
1267:
1268:
1269: -- Initialize API return status to success

Line 1291: AMS_UTILITY_PVT.Convert_Timezone(

1287: IF (l_listheader_rec.USER_ENTERED_START_TIME IS NOT NULL
1288: AND l_listheader_rec.TIMEZONE_ID IS NOT NULL
1289: AND l_listheader_rec.TIMEZONE_ID <> FND_API.g_miss_num) THEN
1290:
1291: AMS_UTILITY_PVT.Convert_Timezone(
1292: p_init_msg_list => l_init_msg_list,
1293: x_return_status => x_return_status,
1294: x_msg_count => x_msg_count,
1295: x_msg_data => x_msg_data,

Line 1752: AMS_Utility_PVT.debug_message('AMS_ListHeaders_PVT.Update_listheaders: Start');

1748: FND_MSG_PUB.Add;
1749: END IF; */
1750:
1751: IF (AMS_DEBUG_HIGH_ON) THEN
1752: AMS_Utility_PVT.debug_message('AMS_ListHeaders_PVT.Update_listheaders: Start');
1753: END IF;
1754:
1755:
1756: ----------------------------------------------------------

Line 1771: AMS_UTILITY_PVT.Convert_Timezone(

1767: AND p_listheader_rec.USER_ENTERED_START_TIME is not null)THEN
1768:
1769: if (p_listheader_rec.timezone_id is not null AND
1770: p_listheader_rec.timezone_id <> FND_API.g_miss_num ) then
1771: AMS_UTILITY_PVT.Convert_Timezone(
1772: p_init_msg_list => p_init_msg_list,
1773: x_return_status => x_return_status,
1774: x_msg_count => x_msg_count,
1775: x_msg_data => x_msg_data,

Line 1798: AMS_Utility_PVT.debug_message('AMS_ListHeaders_PVT.Update_listheaders: Done timezone');

1794: FND_MSG_PUB.Add;
1795: END IF; */
1796:
1797: IF (AMS_DEBUG_HIGH_ON) THEN
1798: AMS_Utility_PVT.debug_message('AMS_ListHeaders_PVT.Update_listheaders: Done timezone');
1799: END IF;
1800:
1801:
1802:

Line 1826: AMS_Utility_PVT.debug_message('AMS_ListHeaders_PVT.Update_listheaders: Item level validation');

1822: FND_MSG_PUB.Add;
1823: END IF; */
1824:
1825: IF (AMS_DEBUG_HIGH_ON) 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

Line 1852: AMS_Utility_PVT.debug_message('AMS_ListHeaders_PVT.update ams_listheaders');

1848: FND_MSG_PUB.Add;
1849: END IF; */
1850:
1851: IF (AMS_DEBUG_LOW_ON) THEN
1852: AMS_Utility_PVT.debug_message('AMS_ListHeaders_PVT.update ams_listheaders');
1853: END IF;
1854:
1855:
1856: IF (l_listheader_rec.STATUS_CODE ='DRAFT' OR

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

2340:
2341: -------------------- initialize ------------------------
2342: IF (AMS_DEBUG_HIGH_ON) THEN
2343:
2344: AMS_Utility_PVT.debug_message(l_full_name||': start');
2345: END IF;
2346:
2347: IF FND_API.to_boolean(p_init_msg_list) THEN
2348: FND_MSG_PUB.initialize;

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

2361:
2362: ------------------------ lock -------------------------
2363: IF (AMS_DEBUG_HIGH_ON) THEN
2364:
2365: AMS_Utility_PVT.debug_message(l_full_name||': lock');
2366: END IF;
2367:
2368: OPEN c_list_header_id;
2369: FETCH c_list_header_id INTO l_list_header_id;

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

2387: IF (AMS_DEBUG_HIGH_ON) THEN
2388:
2389:
2390:
2391: AMS_Utility_PVT.debug_message(l_full_name ||': end');
2392:
2393: END IF;
2394:
2395: EXCEPTION

Line 2397: WHEN AMS_Utility_PVT.resource_locked THEN

2393: END IF;
2394:
2395: EXCEPTION
2396:
2397: WHEN AMS_Utility_PVT.resource_locked THEN
2398: x_return_status := FND_API.g_ret_sts_error;
2399: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2400: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
2401: FND_MSG_PUB.add;

Line 2930: x_complete_rec.status_code := AMS_Utility_PVT.get_system_status_code(

2926: IF p_listheader_rec.APPLY_TRAFFIC_COP = FND_API.g_miss_char THEN
2927: x_complete_rec.APPLY_TRAFFIC_COP := l_listheader_rec.APPLY_TRAFFIC_COP ;
2928: END IF;
2929:
2930: x_complete_rec.status_code := AMS_Utility_PVT.get_system_status_code(
2931: x_complete_rec.user_status_id );
2932:
2933:
2934: -- ckapoor R12 copy target group changes

Line 3060: AMS_Utility_PVT.debug_message('AMS_LIST_HEADER_UPDATE: END');

3056: END IF;
3057:
3058:
3059: IF (AMS_DEBUG_HIGH_ON) THEN
3060: AMS_Utility_PVT.debug_message('AMS_LIST_HEADER_UPDATE: END');
3061: END IF;
3062:
3063:
3064: FND_MSG_PUB.count_and_get(

Line 3335: AMS_Utility_PVT.debug_message('AMS_ListHeader_PVT.Copy_List: Start');

3331: FND_MSG_PUB.Add;
3332: END IF; */
3333:
3334: IF (AMS_DEBUG_HIGH_ON) THEN
3335: AMS_Utility_PVT.debug_message('AMS_ListHeader_PVT.Copy_List: Start');
3336: END IF;
3337:
3338: -- Initialize API return status to success
3339: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3359: l_trg_listheader_rec.user_status_id := AMS_Utility_PVT.get_default_user_status('AMS_LIST_STATUS','AVAILABLE');

3355: l_trg_listheader_rec.program_application_id := NULL;
3356: l_trg_listheader_rec.program_update_date := NULL;
3357:
3358:
3359: l_trg_listheader_rec.user_status_id := AMS_Utility_PVT.get_default_user_status('AMS_LIST_STATUS','AVAILABLE');
3360: l_trg_listheader_rec.status_code := 'AVAILABLE';
3361: l_trg_listheader_rec.status_date := SYSDATE;
3362:
3363: -- ----------------------------