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_OFFER_ADJUSTMENT_PVT dependencies on OZF_UTILITY_PVT

Line 237: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

233: -- =========================================================================
234:
235: IF FND_GLOBAL.USER_ID IS NULL
236: THEN
237: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
238: RAISE FND_API.G_EXC_ERROR;
239: END IF;
240:
241:

Line 331: WHEN OZF_Utility_PVT.resource_locked THEN

327: p_data => x_msg_data
328: );
329: EXCEPTION
330:
331: WHEN OZF_Utility_PVT.resource_locked THEN
332: x_return_status := FND_API.g_ret_sts_error;
333: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
334:
335: WHEN FND_API.G_EXC_ERROR THEN

Line 333: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

329: EXCEPTION
330:
331: WHEN OZF_Utility_PVT.resource_locked THEN
332: x_return_status := FND_API.g_ret_sts_error;
333: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
334:
335: WHEN FND_API.G_EXC_ERROR THEN
336: ROLLBACK TO CREATE_Offer_Adjustment_PVT;
337: x_return_status := FND_API.G_RET_STS_ERROR;

Line 537: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

533:
534: FETCH c_get_Offer_Adjustment INTO l_ref_offer_adj_rec ;
535:
536: If ( c_get_Offer_Adjustment%NOTFOUND) THEN
537: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
538: p_token_name => 'INFO',
539: p_token_value => 'Offer_Adjustment') ;
540: RAISE FND_API.G_EXC_ERROR;
541: END IF;

Line 550: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',

546:
547:
548: If (l_tar_offer_adj_rec.object_version_number is NULL or
549: l_tar_offer_adj_rec.object_version_number = FND_API.G_MISS_NUM ) Then
550: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
551: p_token_name => 'COLUMN',
552: p_token_value => 'Last_Update_Date') ;
553: raise FND_API.G_EXC_ERROR;
554: End if;

Line 560: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

556:
557: -- Check Whether record has been changed by someone else
558:
559: If (l_tar_offer_adj_rec.object_version_number <> l_ref_offer_adj_rec.object_version_number) Then
560: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
561: p_token_name => 'INFO',
562: p_token_value => 'Offer_Adjustment') ;
563: raise FND_API.G_EXC_ERROR;
564: End if;

Line 607: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFRADJ_DISCRULE');

603: FETCH c_if_lines_exist INTO l_if_lines_exist;
604: CLOSE c_if_lines_exist;
605:
606: IF l_if_lines_exist IS NULL THEN
607: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFRADJ_DISCRULE');
608:
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;
611:

Line 650: ,p_requester_userid => OZF_Utility_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1))

646: ,p_object_version_number =>p_offer_adj_rec.object_version_number
647: ,p_orig_stat_id => 0
648: ,p_new_stat_id => 0
649: ,p_reject_stat_id => 0
650: ,p_requester_userid => OZF_Utility_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1))
651: ,p_notes_from_requester => p_offer_adj_rec.description
652: ,p_workflowprocess => 'AMSGAPP'
653: ,p_item_type => 'AMSGAPP');
654:

Line 665: ,p_requester_userid => OZF_Utility_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1))

661: ,p_object_version_number =>p_offer_adj_rec.object_version_number
662: ,p_orig_stat_id => 0
663: ,p_new_stat_id => 0
664: ,p_reject_stat_id => 0
665: ,p_requester_userid => OZF_Utility_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1))
666: ,p_notes_from_requester => p_offer_adj_rec.description
667: ,p_workflowprocess => 'AMSGAPP'
668: ,p_item_type => 'AMSGAPP');
669:

Line 747: WHEN OZF_Utility_PVT.resource_locked THEN

743: END IF;
744: -- Debug Message
745: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');
746: EXCEPTION
747: WHEN OZF_Utility_PVT.resource_locked THEN
748: x_return_status := FND_API.g_ret_sts_error;
749: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
750: WHEN FND_API.G_EXC_ERROR THEN
751: ROLLBACK TO UPDATE_Offer_Adjustment_PVT;

Line 749: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

745: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');
746: EXCEPTION
747: WHEN OZF_Utility_PVT.resource_locked THEN
748: x_return_status := FND_API.g_ret_sts_error;
749: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
750: WHEN FND_API.G_EXC_ERROR THEN
751: ROLLBACK TO UPDATE_Offer_Adjustment_PVT;
752: x_return_status := FND_API.G_RET_STS_ERROR;
753: -- Standard call to get message count and if count=1, get the message

Line 898: WHEN OZF_Utility_PVT.resource_locked THEN

894: p_data => x_msg_data
895: );
896: EXCEPTION
897:
898: WHEN OZF_Utility_PVT.resource_locked THEN
899: x_return_status := FND_API.g_ret_sts_error;
900: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
901:
902: WHEN FND_API.G_EXC_ERROR THEN

Line 900: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

896: EXCEPTION
897:
898: WHEN OZF_Utility_PVT.resource_locked THEN
899: x_return_status := FND_API.g_ret_sts_error;
900: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
901:
902: WHEN FND_API.G_EXC_ERROR THEN
903: ROLLBACK TO DELETE_Offer_Adjustment_PVT;
904: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1032: WHEN OZF_Utility_PVT.resource_locked THEN

1028: p_data => x_msg_data);
1029: OZF_Offer_Adj_Line_PVT.debug_message(l_full_name ||': end');
1030: EXCEPTION
1031:
1032: WHEN OZF_Utility_PVT.resource_locked THEN
1033: x_return_status := FND_API.g_ret_sts_error;
1034: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1035:
1036: WHEN FND_API.G_EXC_ERROR THEN

Line 1034: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

1030: EXCEPTION
1031:
1032: WHEN OZF_Utility_PVT.resource_locked THEN
1033: x_return_status := FND_API.g_ret_sts_error;
1034: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1035:
1036: WHEN FND_API.G_EXC_ERROR THEN
1037: ROLLBACK TO LOCK_Offer_Adjustment_PVT;
1038: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1119: /*l_valid_flag := OZF_Utility_PVT.check_uniqueness(

1115: x_return_status := FND_API.g_ret_sts_success;
1116: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1117: OZF_Offer_Adj_Line_PVT.debug_message('Inside Uk_Items::Create');
1118: --nepanda : fix for bug 9149865
1119: /*l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1120: ' ozf_offer_adjustments_vl ',
1121: ' list_header_id = '||' '|| p_offer_adj_rec.list_header_id ||
1122: ' AND offer_adjustment_name ='||' '|| p_offer_adj_rec.offer_adjustment_name||''
1123: );*/

Line 1130: -- l_dup_effective_dt := OZF_Utility_PVT.check_uniqueness(

1126: FETCH c_check_uniqeness_create INTO l_valid_flag;
1127: CLOSE c_check_uniqeness_create;
1128: -- Check for, 2 adjustments with same effective date -sangara
1129:
1130: -- l_dup_effective_dt := OZF_Utility_PVT.check_uniqueness(
1131: -- 'ozf_offer_adjustments_b',
1132: -- ' list_header_id = '||' '|| p_offer_adj_rec.list_header_id ||''||
1133: -- ' AND status_code <> '||' '|| l_strTerminated ||''||
1134: -- ' OR status_code <> '||' '|| l_strClosed ||''||

Line 1144: /* l_valid_flag := OZF_Utility_PVT.check_uniqueness(

1140: CLOSE c_adj_exists_oncreate;
1141:
1142: ELSE
1143: --nepanda : fix for bug 9149865
1144: /* l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1145: ' ozf_offer_adjustments_vl ',
1146: ' list_header_id = '||' '|| p_offer_adj_rec.list_header_id ||
1147: ' AND offer_adjustment_id <> '||' '|| p_offer_adj_rec.offer_adjustment_id||' '||
1148: ' AND offer_adjustment_name ='||' '|| p_offer_adj_rec.offer_adjustment_name||''

Line 1156: -- l_dup_effective_dt := OZF_Utility_PVT.check_uniqueness(

1152: FETCH c_check_uniqeness_update INTO l_valid_flag;
1153: CLOSE c_check_uniqeness_update;
1154:
1155: -- Check for, 2 adjustments with same effective date -sangara
1156: -- l_dup_effective_dt := OZF_Utility_PVT.check_uniqueness(
1157: -- 'ozf_offer_adjustments_b',
1158: -- 'list_header_id =' || p_offer_adj_rec.list_header_id ||
1159: -- ' AND offer_adjustment_id <> '||' '|| p_offer_adj_rec.offer_adjustment_id||' '||
1160: -- ' AND status_code <> '||' '|| l_strTerminated ||''||

Line 1174: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_ADJ_NAME_DUP');

1170: END IF;
1171:
1172:
1173: IF l_valid_flag = 1 THEN --FND_API.g_false THEN
1174: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_ADJ_NAME_DUP');
1175: x_return_status := FND_API.g_ret_sts_error;
1176: END IF;
1177:
1178: OZF_Offer_Adj_Line_PVT.debug_message('check_Offer_Adj_Uk_Items :: l_dup_effective_dt ' || l_dup_effective_dt );

Line 1182: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFADJ_DUP_EFFDT');

1178: OZF_Offer_Adj_Line_PVT.debug_message('check_Offer_Adj_Uk_Items :: l_dup_effective_dt ' || l_dup_effective_dt );
1179:
1180: IF l_dup_effective_dt IS NOT NULL THEN
1181: IF l_dup_effective_dt = 1 THEN -- Show error, if 2 adjs. with same eff date exists. - sangara
1182: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFADJ_DUP_EFFDT');
1183: x_return_status := FND_API.g_ret_sts_error;
1184: END IF;
1185: END IF;
1186:

Line 1204: -- OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );

1200: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1201:
1202:
1203: -- IF p_offer_adj_rec.offer_adjustment_id = FND_API.G_MISS_NUM OR p_offer_adj_rec.offer_adjustment_id IS NULL THEN
1204: -- OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
1205: -- x_return_status := FND_API.g_ret_sts_error;
1206: -- END IF;
1207:
1208: -- List Header Id check

Line 1210: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_HEADER_ID' );

1206: -- END IF;
1207:
1208: -- List Header Id check
1209: IF p_offer_adj_rec.list_header_id = FND_API.G_MISS_NUM OR p_offer_adj_rec.list_header_id IS NULL THEN
1210: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_HEADER_ID' );
1211: x_return_status := FND_API.g_ret_sts_error;
1212: END IF;
1213:
1214: -- Adjustment Name check

Line 1216: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_NAME' );

1212: END IF;
1213:
1214: -- Adjustment Name check
1215: IF p_offer_adj_rec.offer_adjustment_name = FND_API.G_MISS_CHAR OR p_offer_adj_rec.offer_adjustment_name IS NULL THEN
1216: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_NAME' );
1217: x_return_status := FND_API.g_ret_sts_error;
1218: END IF;
1219:
1220: -- Status Code check

Line 1222: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'STATUS_CODE' );

1218: END IF;
1219:
1220: -- Status Code check
1221: IF p_offer_adj_rec.status_code = FND_API.G_MISS_CHAR OR p_offer_adj_rec.offer_adjustment_name IS NULL THEN
1222: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'STATUS_CODE' );
1223: x_return_status := FND_API.g_ret_sts_error;
1224: END IF;
1225:
1226: -- Effective Date check

Line 1228: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'EFFECTIVE_DATE' );

1224: END IF;
1225:
1226: -- Effective Date check
1227: IF p_offer_adj_rec.effective_date = FND_API.G_MISS_DATE OR p_offer_adj_rec.effective_date IS NULL THEN
1228: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'EFFECTIVE_DATE' );
1229: x_return_status := FND_API.g_ret_sts_error;
1230: END IF;
1231:
1232: ELSE

Line 1235: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );

1231:
1232: ELSE
1233:
1234: IF p_offer_adj_rec.offer_adjustment_id = FND_API.G_MISS_NUM THEN
1235: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
1236: x_return_status := FND_API.g_ret_sts_error;
1237: END IF;
1238:
1239:

Line 1241: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_HEADER_ID' );

1237: END IF;
1238:
1239:
1240: IF p_offer_adj_rec.list_header_id = FND_API.G_MISS_NUM THEN
1241: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_HEADER_ID' );
1242: x_return_status := FND_API.g_ret_sts_error;
1243: END IF;
1244:
1245: END IF;

Line 1584: ozf_utility_pvt.error_message('OZF_OFFR_ADJ_DT_LT_BUDGET_DT');

1580: );
1581:
1582: -- If the Effective date is before the start date of any of the budgets dont create or update adjustments
1583: IF l_offer_adj_rec.effective_date < get_budget_start_date(l_offer_adj_rec.list_header_id) AND isBudgetOffer(p_listHeaderId => l_offer_adj_rec.list_header_id) = 'N' THEN
1584: ozf_utility_pvt.error_message('OZF_OFFR_ADJ_DT_LT_BUDGET_DT');
1585: RAISE FND_API.G_EXC_ERROR;
1586: END IF;
1587:
1588: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 1625: WHEN OZF_Utility_PVT.resource_locked THEN

1621: p_data => x_msg_data
1622: );
1623: EXCEPTION
1624:
1625: WHEN OZF_Utility_PVT.resource_locked THEN
1626: x_return_status := FND_API.g_ret_sts_error;
1627: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1628:
1629: WHEN FND_API.G_EXC_ERROR THEN

Line 1627: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

1623: EXCEPTION
1624:
1625: WHEN OZF_Utility_PVT.resource_locked THEN
1626: x_return_status := FND_API.g_ret_sts_error;
1627: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1628:
1629: WHEN FND_API.G_EXC_ERROR THEN
1630: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1631: x_return_status := FND_API.G_RET_STS_ERROR;