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

Line 276: IF AMS_Utility_PVT.check_uniqueness(

272: -- check if this action_id is unique.
273: IF p_validation_mode = JTF_PLSQL_API.g_create
274: AND p_action_rec.list_select_action_id IS NOT NULL
275: THEN
276: IF AMS_Utility_PVT.check_uniqueness(
277: 'ams_list_select_actions',
278: 'list_select_action_id = ' || p_action_rec.list_select_action_id
279: ) = FND_API.g_false
280: THEN

Line 293: IF AMS_Utility_PVT.check_uniqueness(

289:
290: IF p_validation_mode = JTF_PLSQL_API.g_create
291: AND p_action_rec.order_number IS NOT NULL
292: THEN
293: IF AMS_Utility_PVT.check_uniqueness(
294: 'ams_list_select_actions',
295: 'order_number = ' || p_action_rec.order_number||
296: ' and action_used_by_id = '||p_action_rec.action_used_by_id
297: ||' and arc_action_used_by = '||p_action_rec.arc_action_used_by

Line 312: IF AMS_Utility_PVT.check_uniqueness(

308:
309: IF p_validation_mode = JTF_PLSQL_API.g_create
310: AND p_action_rec.rank IS NOT NULL
311: THEN
312: IF AMS_Utility_PVT.check_uniqueness(
313: 'ams_list_select_actions',
314: 'rank = ' || p_action_rec.rank||
315: ' and action_used_by_id = '||
316: p_action_rec.action_used_by_id

Line 355: AMS_Utility_PVT.get_qual_table_name_and_pk(

351: x_return_status := FND_API.g_ret_sts_success;
352:
353: IF p_action_rec.arc_action_used_by <> FND_API.g_miss_char THEN
354:
355: AMS_Utility_PVT.get_qual_table_name_and_pk(
356: p_sys_qual => p_action_rec.arc_action_used_by,
357: x_return_status => x_return_status,
358: x_table_name => l_table_name,
359: x_pk_name => l_pk_name

Line 367: IF ( AMS_Utility_PVT.Check_FK_Exists(l_table_name

363: RETURN;
364: END IF;
365:
366: IF p_action_rec.action_used_by_id <> FND_API.g_miss_num THEN
367: IF ( AMS_Utility_PVT.Check_FK_Exists(l_table_name
368: , l_pk_name
369: , p_action_rec.action_used_by_id)
370: = FND_API.G_TRUE)
371: THEN

Line 382: END IF; -- end AMS_Utility_PVT.Check_FK_Exists

378: FND_MSG_PUB.Add;
379: END IF;
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: RAISE FND_API.G_EXC_ERROR;
382: END IF; -- end AMS_Utility_PVT.Check_FK_Exists
383: END IF; -- end p_action_rec.action_used_by_id
384: END IF; --end p_action_rec.arc_action_used_by <> FND_API.g_miss_char
385:
386: IF p_action_rec.arc_incl_object_from <> FND_API.g_miss_char THEN

Line 395: AMS_Utility_PVT.get_qual_table_name_and_pk(

391: l_arc_incl_object_from := 'LIST';
392: else
393: l_arc_incl_object_from := p_action_rec.arc_incl_object_from;
394: end if;
395: AMS_Utility_PVT.get_qual_table_name_and_pk(
396: p_sys_qual => l_arc_incl_object_from,
397: x_return_status => x_return_status,
398: x_table_name => l_table_name,
399: x_pk_name => l_pk_name

Line 407: IF ( AMS_Utility_PVT.Check_FK_Exists(l_table_name

403: RETURN;
404: END IF;
405:
406: IF p_action_rec.incl_object_id <> FND_API.g_miss_num THEN
407: IF ( AMS_Utility_PVT.Check_FK_Exists(l_table_name
408: , l_pk_name
409: , p_action_rec.incl_object_id)
410: = FND_API.G_TRUE)
411: THEN

Line 423: END IF; -- end AMS_Utility_PVT.Check_FK_Exists

419: FND_MSG_PUB.Add;
420: END IF;
421: x_return_status := FND_API.G_RET_STS_ERROR;
422: RAISE FND_API.G_EXC_ERROR;
423: END IF; -- end AMS_Utility_PVT.Check_FK_Exists
424: END IF; -- p_action_rec.incl_object_id <> FND_API.g_miss_num
425: END IF; --end p_action_rec.arc_incl_object_from <> FND_API.g_miss_char
426: -- check other fk items
427: END check_action_fk_items;

Line 498: IF AMS_Utility_PVT.is_Y_or_N(p_action_rec.incl_control_group) = FND_API.g_false THEN

494: END IF;
495:
496: IF p_action_rec.incl_control_group <> FND_API.g_miss_char
497: AND p_action_rec.incl_control_group IS NOT NULL THEN
498: IF AMS_Utility_PVT.is_Y_or_N(p_action_rec.incl_control_group) = FND_API.g_false THEN
499: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
500: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_FLAG');
501: FND_MSG_PUB.add;
502: END IF;

Line 529: IF AMS_Utility_PVT.check_lookup_exists(

525: x_return_status := FND_API.g_ret_sts_success;
526:
527: ----------------------- arc_action_used_by ------------------------
528: IF p_action_rec.arc_action_used_by <> FND_API.g_miss_char THEN
529: IF AMS_Utility_PVT.check_lookup_exists(
530: p_lookup_type => 'AMS_SELECT_ACTION_USED_BY',
531: p_lookup_code => p_action_rec.arc_action_used_by
532: ) = FND_API.g_false
533: THEN

Line 548: IF AMS_Utility_PVT.check_lookup_exists(

544: END IF;
545:
546: ----------------------- list_action_type ------------------------
547: IF p_action_rec.list_action_type <> FND_API.g_miss_char THEN
548: IF AMS_Utility_PVT.check_lookup_exists(
549: p_lookup_type => 'AMS_LIST_SELECT_ACTION',
550: p_lookup_code => p_action_rec.list_action_type
551: ) = FND_API.g_false
552: THEN

Line 567: IF AMS_Utility_PVT.check_lookup_exists(

563:
564: ----------------------- arc_incl_object_type ------------------------
565: IF p_action_rec.arc_incl_object_from <> FND_API.g_miss_char THEN
566: IF p_action_rec.arc_action_used_by NOT IN ('MODL', 'SCOR') THEN
567: IF AMS_Utility_PVT.check_lookup_exists(
568: p_lookup_type => 'AMS_LIST_SELECT_TYPE',
569: p_lookup_code => p_action_rec.arc_incl_object_from
570: ) = FND_API.g_false
571: THEN

Line 586: IF AMS_Utility_PVT.check_lookup_exists(

582: ELSE -- use different lookup for model and score
583: -- CSCH included in the lookup breaks the rendering
584: -- of the loyalty selection screen.
585: IF p_action_rec.arc_incl_object_from <> 'CSCH' THEN
586: IF AMS_Utility_PVT.check_lookup_exists(
587: p_lookup_type => 'AMS_DM_SOURCE_TYPE',
588: p_lookup_code => p_action_rec.arc_incl_object_from
589: ) = FND_API.g_false
590: THEN

Line 837: AMS_Utility_PVT.debug_message(l_api_name||': Start ');

833: FND_MSG_PUB.Add;
834: END IF; */
835:
836: IF (AMS_DEBUG_HIGH_ON) THEN
837: AMS_Utility_PVT.debug_message(l_api_name||': Start ');
838: END IF;
839:
840:
841:

Line 913: AMS_Utility_PVT.debug_message(l_api_name||': End ');

909: END IF; */
910:
911:
912: IF (AMS_DEBUG_HIGH_ON) THEN
913: AMS_Utility_PVT.debug_message(l_api_name||': End ');
914: END IF;
915:
916:
917: -- Standard call to get message count AND IF count is 1, get message info.

Line 1046: AMS_Utility_PVT.debug_message(l_api_name||': Start ');

1042: FND_MSG_PUB.Add;
1043: END IF; */
1044:
1045: IF (AMS_DEBUG_HIGH_ON) THEN
1046: AMS_Utility_PVT.debug_message(l_api_name||': Start ');
1047: END IF;
1048:
1049:
1050: -- Initialize API return status to success

Line 1321: AMS_Utility_PVT.debug_message(l_api_name||': Start ');

1317: END IF; */
1318:
1319:
1320: IF (AMS_DEBUG_HIGH_ON) THEN
1321: AMS_Utility_PVT.debug_message(l_api_name||': Start ');
1322: END IF;
1323:
1324:
1325: init_action_rec(x_action_rec => l_action_rec);

Line 1370: AMS_Utility_PVT.Create_Log (

1366: -- choang 07-jan-2000
1367: -- Replace the dbms_output with create_log
1368: -- due to problem with adchkdrv.
1369: -------------------------------------------
1370: AMS_Utility_PVT.Create_Log (
1371: x_return_status => l_return_status,
1372: p_arc_log_used_by => 'LISTACTION',
1373: p_log_used_by_id => TO_CHAR(l_action_rec.list_select_action_id),
1374: p_msg_data => G_PKG_NAME || ' - Update ams_list_actions'

Line 1598: AMS_Utility_PVT.debug_message(l_api_name||': Start ');

1594: FND_MSG_PUB.Add;
1595: END IF; */
1596:
1597: IF (AMS_DEBUG_HIGH_ON) THEN
1598: AMS_Utility_PVT.debug_message(l_api_name||': Start ');
1599: END IF;
1600:
1601:
1602: -- Initialize API return status to success

Line 1839: AMS_Utility_PVT.debug_message(l_api_name||': Start ');

1835: FND_MSG_PUB.Add;
1836: END IF; */
1837:
1838: IF (AMS_DEBUG_HIGH_ON) THEN
1839: AMS_Utility_PVT.debug_message(l_api_name||': Start ');
1840: END IF;
1841:
1842: -- Initialize API return status to success
1843: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1907: WHEN AMS_Utility_PVT.RESOURCE_LOCKED THEN

1903: p_data => x_msg_data,
1904: p_encoded => FND_API.G_FALSE
1905: );
1906:
1907: WHEN AMS_Utility_PVT.RESOURCE_LOCKED THEN
1908:
1909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1910:
1911: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)