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.OZF_ACT_OFFERS_PVT dependencies on OZF_UTILITY_PVT

Line 759: WHEN OZF_Utility_PVT.resource_locked THEN

755: p_data => x_msg_data
756: );
757:
758: EXCEPTION
759: WHEN OZF_Utility_PVT.resource_locked THEN
760: x_return_status := FND_API.g_ret_sts_error;
761: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
762: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
763: FND_MSG_PUB.add;

Line 1028: l_uk_flag := OZF_Utility_PVT.check_uniqueness

1024: -- check PK, if activity_offer_id is passed in, must check if it is duplicate
1025: IF p_validation_mode = JTF_PLSQL_API.g_create
1026: -- AND p_act_offer_rec.activity_offer_id IS NOT NULL
1027: THEN
1028: l_uk_flag := OZF_Utility_PVT.check_uniqueness
1029: (
1030: 'OZF_ACT_OFFERS',
1031: ' qp_list_header_id = ' || p_act_offer_rec.qp_list_header_id ||
1032: ' AND act_offer_used_by_id = ' || p_act_offer_rec.act_offer_used_by_id ||

Line 1038: l_uk_flag := OZF_Utility_PVT.check_uniqueness

1034: );
1035: ELSIF p_validation_mode = JTF_PLSQL_API.g_update
1036: AND p_act_offer_rec.activity_offer_id IS NOT NULL
1037: THEN
1038: l_uk_flag := OZF_Utility_PVT.check_uniqueness
1039: (
1040: 'OZF_ACT_OFFERS',
1041: ' activity_offer_id <> '|| p_act_offer_rec.activity_offer_id ||
1042: ' AND qp_list_header_id = ' || p_act_offer_rec.qp_list_header_id ||

Line 1063: l_uk_flag := OZF_Utility_PVT.check_uniqueness

1059: /*
1060: -- check offer_code
1061: IF p_act_offer_rec.offer_code IS NOT NULL THEN
1062: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1063: l_uk_flag := OZF_Utility_PVT.check_uniqueness
1064: (
1065: 'AMS_SOURCE_CODES',
1066: 'source_code = ''' || p_act_offer_rec.offer_code || ''''
1067: );

Line 1069: l_uk_flag := OZF_Utility_PVT.check_uniqueness

1065: 'AMS_SOURCE_CODES',
1066: 'source_code = ''' || p_act_offer_rec.offer_code || ''''
1067: );
1068: ELSE
1069: l_uk_flag := OZF_Utility_PVT.check_uniqueness
1070: (
1071: 'AMS_SOURCE_CODES',
1072: 'source_code_for_id <> ' || p_act_offer_rec.activity_offer_id || ' AND '
1073: || 'source_code = ''' || p_act_offer_rec.offer_code || ''''

Line 1122: l_fk_flag := OZF_Utility_PVT.check_fk_exists

1118: AND
1119: p_act_offer_rec.act_offer_used_by_id IS NOT NULL
1120: THEN
1121: IF p_act_offer_rec.arc_act_offer_used_by = 'CAMP' THEN
1122: l_fk_flag := OZF_Utility_PVT.check_fk_exists
1123: (
1124: 'AMS_CAMPAIGNS_VL',
1125: 'campaign_id',
1126: p_act_offer_rec.act_offer_used_by_id

Line 1130: l_fk_flag := OZF_Utility_PVT.check_fk_exists

1126: p_act_offer_rec.act_offer_used_by_id
1127: );
1128: ELSE
1129: IF p_act_offer_rec.arc_act_offer_used_by = 'CSCH' THEN
1130: l_fk_flag := OZF_Utility_PVT.check_fk_exists
1131: (
1132: 'AMS_CAMPAIGN_SCHEDULES_VL',
1133: 'schedule_id',
1134: p_act_offer_rec.act_offer_used_by_id

Line 1154: l_fk_flag := OZF_Utility_PVT.check_fk_exists

1150: -- Following Code has been modified by ptendulk
1151: -- Validate against QP_LIST_HEADERS_VL
1152: -- check qp_list_header_id
1153: IF p_act_offer_rec.qp_list_header_id <> FND_API.g_miss_num THEN
1154: l_fk_flag := OZF_Utility_PVT.check_fk_exists
1155: (
1156: 'QP_LIST_HEADERS_VL',
1157: 'list_header_id',
1158: p_act_offer_rec.qp_list_header_id

Line 1203: --OZF_UTILITY_PVT.debug_message(g_pkg_name||': check used_by');

1199: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1200: -- FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_USED_BY');
1201: -- FND_MSG_PUB.add;
1202: -- END IF;
1203: --OZF_UTILITY_PVT.debug_message(g_pkg_name||': check used_by');
1204: --OZF_UTILITY_PVT.debug_message('used by: ' || p_act_offer_rec.arc_act_offer_used_by);
1205: IF p_act_offer_rec.arc_act_offer_used_by <> FND_API.g_miss_char
1206: AND (p_act_offer_rec.arc_act_offer_used_by <> 'CAMP'
1207: AND p_act_offer_rec.arc_act_offer_used_by <> 'CSCH')

Line 1204: --OZF_UTILITY_PVT.debug_message('used by: ' || p_act_offer_rec.arc_act_offer_used_by);

1200: -- FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_USED_BY');
1201: -- FND_MSG_PUB.add;
1202: -- END IF;
1203: --OZF_UTILITY_PVT.debug_message(g_pkg_name||': check used_by');
1204: --OZF_UTILITY_PVT.debug_message('used by: ' || p_act_offer_rec.arc_act_offer_used_by);
1205: IF p_act_offer_rec.arc_act_offer_used_by <> FND_API.g_miss_char
1206: AND (p_act_offer_rec.arc_act_offer_used_by <> 'CAMP'
1207: AND p_act_offer_rec.arc_act_offer_used_by <> 'CSCH')
1208: THEN

Line 1223: IF OZF_Utility_PVT.check_lookup_exists(

1219: -- check offer_type
1220: IF p_act_offer_rec.offer_type <> FND_API.g_miss_char
1221: AND p_act_offer_rec.offer_type IS NOT NULL
1222: THEN
1223: IF OZF_Utility_PVT.check_lookup_exists(
1224: p_lookup_type => 'OZF_OFFER_TYPE',
1225: p_lookup_code => p_act_offer_rec.offer_type
1226: ) = FND_API.g_false
1227: THEN

Line 1242: IF OZF_Utility_PVT.check_lookup_exists(

1238: -- check status_code
1239: IF p_act_offer_rec.status_code <> FND_API.g_miss_char
1240: AND p_act_offer_rec.status_code IS NOT NULL
1241: THEN
1242: IF OZF_Utility_PVT.check_lookup_exists(
1243: p_lookup_type => 'OZF_OFFER_STATUS',
1244: p_lookup_code => p_act_offer_rec.status_code
1245: ) = FND_API.g_false
1246: THEN

Line 1261: IF OZF_Utility_PVT.check_lookup_exists(

1257: -- check lumpsum_payment_type
1258: IF p_act_offer_rec.lumpsum_payment_type <> FND_API.g_miss_char
1259: AND p_act_offer_rec.lumpsum_payment_type IS NOT NULL
1260: THEN
1261: IF OZF_Utility_PVT.check_lookup_exists(
1262: p_lookup_type => 'OZF_OFFER_LUMPSUM_PAYMENT',
1263: p_lookup_code => p_act_offer_rec.lumpsum_payment_type
1264: ) = FND_API.g_false
1265: THEN

Line 1788: OZF_Utility_Pvt.Debug_Message('Created List Header for the offers');

1784: x_message_type := 'OE' ;
1785: RAISE FND_API.g_exc_unexpected_error;
1786: END IF;
1787:
1788: OZF_Utility_Pvt.Debug_Message('Created List Header for the offers');
1789:
1790: --===================================================================
1791: -- Following line of code is commented by ptendulk on 16th May
1792: -- Create the Offer line in detail page

Line 1829: OZF_Utility_Pvt.Debug_Message('Create Activity Offer');

1825: -- END IF;
1826: --
1827: -- Create the record in Activity Offers
1828: --
1829: OZF_Utility_Pvt.Debug_Message('Create Activity Offer');
1830: l_act_offer_rec.qp_list_header_id := l_list_header_id ;
1831:
1832: Create_Act_Offer
1833: (

Line 1881: OZF_Utility_PVT.debug_message(l_full_name ||': end');

1877: p_data => x_msg_data,
1878: p_encoded => FND_API.G_FALSE
1879: );
1880:
1881: OZF_Utility_PVT.debug_message(l_full_name ||': end');
1882:
1883: EXCEPTION
1884:
1885: WHEN FND_API.G_EXC_ERROR THEN

Line 2064: OZF_Utility_Pvt.Debug_Message('Update Activity Offer');

2060:
2061: --
2062: -- Create the record in Activity Offers
2063: --
2064: OZF_Utility_Pvt.Debug_Message('Update Activity Offer');
2065: Update_Act_Offer
2066: (
2067: p_api_version => p_api_version,
2068: p_init_msg_list => p_init_msg_list,

Line 2112: OZF_Utility_PVT.debug_message(l_full_name ||': end');

2108: p_data => x_msg_data,
2109: p_encoded => FND_API.G_FALSE
2110: );
2111:
2112: OZF_Utility_PVT.debug_message(l_full_name ||': end');
2113:
2114: EXCEPTION
2115:
2116: WHEN FND_API.G_EXC_ERROR THEN

Line 2295: OZF_Utility_Pvt.Debug_Message('Delete Activity Offer');

2291:
2292: --
2293: -- Delete the record in Activity Offers
2294: --
2295: OZF_Utility_Pvt.Debug_Message('Delete Activity Offer');
2296: Delete_Act_Offer
2297: (
2298: p_api_version => p_api_version,
2299: p_init_msg_list => p_init_msg_list,

Line 2343: OZF_Utility_PVT.debug_message(l_full_name ||': end');

2339: p_data => x_msg_data,
2340: p_encoded => FND_API.G_FALSE
2341: );
2342:
2343: OZF_Utility_PVT.debug_message(l_full_name ||': end');
2344:
2345: EXCEPTION
2346:
2347: WHEN FND_API.G_EXC_ERROR THEN