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_CAMPAIGN_PVT dependencies on JTF_PLSQL_API

Line 1116: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1112: IF (AMS_DEBUG_HIGH_ON) THEN
1113:
1114: AMS_Utility_PVT.debug_message(l_full_name ||': check items');
1115: END IF;
1116: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1117: check_camp_items(
1118: p_camp_rec => p_camp_rec,
1119: p_validation_mode => JTF_PLSQL_API.g_update,
1120: x_return_status => l_return_status

Line 1119: p_validation_mode => JTF_PLSQL_API.g_update,

1115: END IF;
1116: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1117: check_camp_items(
1118: p_camp_rec => p_camp_rec,
1119: p_validation_mode => JTF_PLSQL_API.g_update,
1120: x_return_status => l_return_status
1121: );
1122: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1123: RAISE FND_API.g_exc_unexpected_error;

Line 1134: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1130: IF (AMS_DEBUG_HIGH_ON) THEN
1131:
1132: AMS_Utility_PVT.debug_message(l_full_name ||': check record');
1133: END IF;
1134: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1135: check_camp_record(
1136: p_camp_rec => p_camp_rec,
1137: p_complete_rec => l_camp_rec,
1138: x_return_status => l_return_status

Line 1152: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_inter_entity THEN

1148: IF (AMS_DEBUG_HIGH_ON) THEN
1149:
1150: AMS_Utility_PVT.debug_message(l_full_name ||': check inter-entity');
1151: END IF;
1152: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_inter_entity THEN
1153: check_camp_inter_entity(
1154: p_camp_rec => p_camp_rec,
1155: p_complete_rec => l_camp_rec,
1156: p_validation_mode => JTF_PLSQL_API.g_update,

Line 1156: p_validation_mode => JTF_PLSQL_API.g_update,

1152: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_inter_entity THEN
1153: check_camp_inter_entity(
1154: p_camp_rec => p_camp_rec,
1155: p_complete_rec => l_camp_rec,
1156: p_validation_mode => JTF_PLSQL_API.g_update,
1157: x_return_status => l_return_status
1158: );
1159: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1160: RAISE FND_API.g_exc_unexpected_error;

Line 1612: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1608:
1609: AMS_Utility_PVT.debug_message(l_full_name||': check items');
1610: END IF;
1611:
1612: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1613: check_camp_items(
1614: p_camp_rec => p_camp_rec,
1615: p_validation_mode => JTF_PLSQL_API.g_create,
1616: x_return_status => l_return_status

Line 1615: p_validation_mode => JTF_PLSQL_API.g_create,

1611:
1612: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1613: check_camp_items(
1614: p_camp_rec => p_camp_rec,
1615: p_validation_mode => JTF_PLSQL_API.g_create,
1616: x_return_status => l_return_status
1617: );
1618: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1619: RAISE FND_API.g_exc_unexpected_error;

Line 1633: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1629: AMS_Utility_PVT.debug_message(l_full_name||': check record');
1630:
1631: END IF;
1632:
1633: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1634: check_camp_record(
1635: p_camp_rec => p_camp_rec,
1636: p_complete_rec => p_camp_rec,
1637: x_return_status => l_return_status

Line 1654: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_inter_entity THEN

1650: AMS_Utility_PVT.debug_message(l_full_name||': check inter-entity');
1651:
1652: END IF;
1653:
1654: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_inter_entity THEN
1655: check_camp_inter_entity(
1656: p_camp_rec => p_camp_rec,
1657: p_complete_rec => p_camp_rec,
1658: p_validation_mode => JTF_PLSQL_API.g_create,

Line 1658: p_validation_mode => JTF_PLSQL_API.g_create,

1654: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_inter_entity THEN
1655: check_camp_inter_entity(
1656: p_camp_rec => p_camp_rec,
1657: p_complete_rec => p_camp_rec,
1658: p_validation_mode => JTF_PLSQL_API.g_create,
1659: x_return_status => l_return_status
1660: );
1661: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1662: RAISE FND_API.g_exc_unexpected_error;

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

1811: -- 07-Mar-2001 ptendulk Moved the source code unique test in inter entitiy.
1812: ---------------------------------------------------------------------
1813: PROCEDURE Check_Camp_Uk_Items(
1814: p_camp_rec IN camp_rec_type,
1815: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1816: x_return_status OUT NOCOPY VARCHAR2
1817: )
1818: IS
1819: l_valid_flag VARCHAR2(1);

Line 1826: IF p_validation_mode = JTF_PLSQL_API.g_create

1822: x_return_status := FND_API.g_ret_sts_success;
1823:
1824: -- For create_campaign, when campaign_id is passed in, we need to
1825: -- check if this campaign_id is unique.
1826: IF p_validation_mode = JTF_PLSQL_API.g_create
1827: AND p_camp_rec.campaign_id IS NOT NULL
1828: THEN
1829: IF AMS_Utility_PVT.check_uniqueness(
1830: 'ams_campaigns_all_b',

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

2282: -- 10/01/99 holiu Created.
2283: ---------------------------------------------------------------------
2284: PROCEDURE Check_Camp_Items(
2285: p_camp_rec IN camp_rec_type,
2286: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2287: x_return_status OUT NOCOPY VARCHAR2
2288: )
2289: IS
2290: BEGIN

Line 2505: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

2501:
2502: BEGIN
2503:
2504: -- For creating, check if source_code is unique in ams_source_codes.
2505: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2506: IF p_complete_rec.rollup_type = 'RCAM' THEN
2507: IF p_camp_rec.source_code IS NULL THEN
2508: AMS_Utility_PVT.Error_Message('AMS_CAMP_NO_PROG_CODE');
2509: x_return_status := FND_API.g_ret_sts_error;

Line 2561: --IF p_validation_mode = JTF_PLSQL_API.g_create THEN

2557: -- Program name have to be unique.
2558: -- Please refer to bug #1783583
2559: -------------------------Program Name ---------------------------------
2560: IF p_complete_rec.rollup_type = 'RCAM' THEN
2561: --IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2562: -- IF AMS_Utility_PVT.check_uniqueness(
2563: -- 'ams_campaigns_vl',
2564: -- 'campaign_name = ''' || p_camp_rec.campaign_name ||
2565: -- ''' AND rollup_type = ''RCAM'''

Line 2585: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

2581: -- x_return_status := FND_API.g_ret_sts_error;
2582: -- RETURN;
2583: -- END IF;
2584: --END IF ;
2585: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2586: OPEN c_prog_name ;
2587: FETCH c_prog_name INTO l_dummy;
2588: CLOSE c_prog_name ;
2589: ELSE

Line 2853: IF p_validation_mode = JTF_PLSQL_API.g_update AND

2849: RETURN ;
2850: END IF;
2851:
2852:
2853: IF p_validation_mode = JTF_PLSQL_API.g_update AND
2854: p_complete_rec.rollup_type = 'RCAM'
2855: THEN
2856: AMS_CampaignRules_PVT.check_camp_dates_vs_child(
2857: p_complete_rec.campaign_id,

Line 2868: IF p_validation_mode = JTF_PLSQL_API.g_update

2864: RETURN;
2865: END IF;
2866: END IF;
2867:
2868: IF p_validation_mode = JTF_PLSQL_API.g_update
2869: AND p_complete_rec.rollup_type <> 'RCAM'
2870: THEN
2871: AMS_CampaignRules_PVT.check_camp_dates_vs_csch(
2872: p_complete_rec.campaign_id,

Line 2883: IF p_validation_mode = JTF_PLSQL_API.g_update THEN

2879: RETURN ;
2880: END IF;
2881: END IF;
2882:
2883: IF p_validation_mode = JTF_PLSQL_API.g_update THEN
2884: IF p_complete_rec.rollup_type = 'RCAM' THEN
2885: AMS_CampaignRules_PVT.Check_Prog_Dates_Vs_Eveh(
2886: p_complete_rec.campaign_id,
2887: p_complete_rec.actual_exec_start_date,