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

Line 294: IF AMS_Utility_PVT.check_fk_exists(

290:
291:
292: -------------------------- Party_Id ------------------------
293: IF p_entry_rec.party_id <> FND_API.g_miss_num AND p_entry_rec.party_id IS NOT NULL THEN
294: IF AMS_Utility_PVT.check_fk_exists(
295: 'hz_parties',
296: 'party_id',
297: p_entry_rec.party_id
298: ) = FND_API.g_false

Line 313: IF AMS_Utility_PVT.check_fk_exists(

309: END IF;
310:
311: --------------------------Parent_Party_Id ------------------------
312: IF p_entry_rec.parent_party_id <> FND_API.g_miss_num AND p_entry_rec.parent_party_id IS NOT NULL THEN
313: IF AMS_Utility_PVT.check_fk_exists(
314: 'hz_parties',
315: 'party_id',
316: p_entry_rec.parent_party_id
317: ) = FND_API.g_false

Line 332: IF AMS_Utility_PVT.check_fk_exists(

328: END IF;
329:
330: -------------------------- List Header Id ------------------------
331: IF p_entry_rec.list_header_id <> FND_API.g_miss_num THEN
332: IF AMS_Utility_PVT.check_fk_exists(
333: 'ams_list_headers_all',
334: 'list_header_id',
335: p_entry_rec.list_header_id
336: ) = FND_API.g_false

Line 355: IF ( AMS_UTILITY_PVT.Check_FK_Exists('AMS_CELLS_ALL_B',

351: (p_entry_rec.cell_code <> NULL)
352: THEN
353:
354:
355: IF ( AMS_UTILITY_PVT.Check_FK_Exists('AMS_CELLS_ALL_B',
356: 'CELL_CODE',
357: p_entry_rec.CELL_CODE)= FND_API.G_FALSE)
358: THEN
359: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 422: IF AMS_Utility_PVT.is_Y_or_N(p_entry_rec.enabled_flag) = FND_API.g_false

418: ----------------------- enabled_flag ------------------------
419: IF p_entry_rec.enabled_flag <> FND_API.G_MISS_CHAR
420: AND p_entry_rec.enabled_flag IS NOT NULL
421: THEN
422: IF AMS_Utility_PVT.is_Y_or_N(p_entry_rec.enabled_flag) = FND_API.g_false
423: THEN
424: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
425: THEN
426: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ENT_BAD_ENABLED_FLAG');

Line 442: IF AMS_Utility_PVT.is_Y_or_N(p_entry_rec.PART_OF_CONTROL_GROUP_FLAG) = FND_API.g_false

438: ----------------------- PART_OF_CONTROL_GROUP_FLAG ------------------------
439: IF p_entry_rec.PART_OF_CONTROL_GROUP_FLAG <> FND_API.g_miss_char
440: AND p_entry_rec.PART_OF_CONTROL_GROUP_FLAG IS NOT NULL
441: THEN
442: IF AMS_Utility_PVT.is_Y_or_N(p_entry_rec.PART_OF_CONTROL_GROUP_FLAG) = FND_API.g_false
443: THEN
444: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
445: THEN
446: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ENT_BAD_CONTROL_FLAG');

Line 459: IF AMS_Utility_PVT.is_Y_or_N(p_entry_rec.MARKED_AS_RANDOM_FLAG) = FND_API.g_false

455: ----------------------- MARKED_AS_RANDOM_FLAG ------------------------
456: IF p_entry_rec.MARKED_AS_RANDOM_FLAG <> FND_API.g_miss_char
457: AND p_entry_rec.MARKED_AS_RANDOM_FLAG IS NOT NULL
458: THEN
459: IF AMS_Utility_PVT.is_Y_or_N(p_entry_rec.MARKED_AS_RANDOM_FLAG) = FND_API.g_false
460: THEN
461: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
462: THEN
463: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ENT_BAD_RANDOM_FLAG');

Line 476: IF AMS_Utility_PVT.is_Y_or_N(p_entry_rec.MARKED_AS_DUPLICATE_FLAG) = FND_API.g_false

472: ----------------------- MARKED_AS_DUPLICATE_FLAG ------------------------
473: IF p_entry_rec.MARKED_AS_DUPLICATE_FLAG<> FND_API.g_miss_char
474: AND p_entry_rec.MARKED_AS_DUPLICATE_FLAG IS NOT NULL
475: THEN
476: IF AMS_Utility_PVT.is_Y_or_N(p_entry_rec.MARKED_AS_DUPLICATE_FLAG) = FND_API.g_false
477: THEN
478: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
479: THEN
480: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ENT_BAD_DUPE_FLAG');

Line 493: IF AMS_Utility_PVT.is_Y_or_N(p_entry_rec.MANUALLY_ENTERED_FLAG) = FND_API.g_false

489: ----------------------- MANUALLY ENTERED FLAG ------------------------
490: IF p_entry_rec.MANUALLY_ENTERED_FLAG <> FND_API.g_miss_char
491: AND p_entry_rec.MANUALLY_ENTERED_FLAG IS NOT NULL
492: THEN
493: IF AMS_Utility_PVT.is_Y_or_N(p_entry_rec.MANUALLY_ENTERED_FLAG) = FND_API.g_false
494: THEN
495: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
496: THEN
497: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ENT_BAD_MANUAL_FLAG');

Line 2579: WHEN AMS_Utility_PVT.RESOURCE_LOCKED THEN

2575: p_data => x_msg_data,
2576: p_encoded => FND_API.G_FALSE
2577: );
2578:
2579: WHEN AMS_Utility_PVT.RESOURCE_LOCKED THEN
2580:
2581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2582:
2583: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 4791: ams_utility_pvt.get_source_code(

4787: end if;
4788:
4789: if(l_arc_list_used_by <> 'NONE')then
4790: if l_source_code_flag = 'Y' then
4791: ams_utility_pvt.get_source_code(
4792: p_activity_type => 'CAMP',
4793: p_activity_id => l_campaign_id,
4794: x_return_status => l_return_status,
4795: x_source_code => l_source_code,

Line 4798: ams_utility_pvt.get_source_code(

4794: x_return_status => l_return_status,
4795: x_source_code => l_source_code,
4796: x_source_id => l_source_id);
4797: else
4798: ams_utility_pvt.get_source_code(
4799: p_activity_type => l_arc_list_used_by,
4800: p_activity_id => l_list_used_by_id,
4801: x_return_status => l_return_status,
4802: x_source_code => l_source_code,

Line 4866: WHEN AMS_Utility_PVT.RESOURCE_LOCKED THEN

4862: p_data => x_msg_data,
4863: p_encoded => FND_API.G_FALSE
4864: );
4865:
4866: WHEN AMS_Utility_PVT.RESOURCE_LOCKED THEN
4867:
4868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4869:
4870: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)