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 236: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

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

Line 330: WHEN OZF_Utility_PVT.resource_locked THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 746: WHEN OZF_Utility_PVT.resource_locked THEN

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

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

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

Line 897: WHEN OZF_Utility_PVT.resource_locked THEN

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

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

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

Line 1031: WHEN OZF_Utility_PVT.resource_locked THEN

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

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

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

Line 1103: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

1099: BEGIN
1100: x_return_status := FND_API.g_ret_sts_success;
1101: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1102: OZF_Offer_Adj_Line_PVT.debug_message('Inside Uk_Items::Create');
1103: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1104: ' ozf_offer_adjustments_vl ',
1105: ' list_header_id = '||' '|| p_offer_adj_rec.list_header_id ||
1106: ' AND offer_adjustment_name ='||' '|| p_offer_adj_rec.offer_adjustment_name||''
1107: );

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

1106: ' AND offer_adjustment_name ='||' '|| p_offer_adj_rec.offer_adjustment_name||''
1107: );
1108: -- Check for, 2 adjustments with same effective date -sangara
1109:
1110: -- l_dup_effective_dt := OZF_Utility_PVT.check_uniqueness(
1111: -- 'ozf_offer_adjustments_b',
1112: -- ' list_header_id = '||' '|| p_offer_adj_rec.list_header_id ||''||
1113: -- ' AND status_code <> '||' '|| l_strTerminated ||''||
1114: -- ' OR status_code <> '||' '|| l_strClosed ||''||

Line 1123: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

1119: FETCH c_adj_exists_oncreate INTO l_dup_effective_dt ;
1120: CLOSE c_adj_exists_oncreate;
1121:
1122: ELSE
1123: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1124: ' ozf_offer_adjustments_vl ',
1125: ' list_header_id = '||' '|| p_offer_adj_rec.list_header_id ||
1126: ' AND offer_adjustment_id <> '||' '|| p_offer_adj_rec.offer_adjustment_id||' '||
1127: ' AND offer_adjustment_name ='||' '|| p_offer_adj_rec.offer_adjustment_name||''

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

1126: ' AND offer_adjustment_id <> '||' '|| p_offer_adj_rec.offer_adjustment_id||' '||
1127: ' AND offer_adjustment_name ='||' '|| p_offer_adj_rec.offer_adjustment_name||''
1128: );
1129: -- Check for, 2 adjustments with same effective date -sangara
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 offer_adjustment_id <> '||' '|| p_offer_adj_rec.offer_adjustment_id||' '||
1134: -- ' AND status_code <> '||' '|| l_strTerminated ||''||

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

1144: END IF;
1145:
1146:
1147: IF l_valid_flag = FND_API.g_false THEN
1148: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_ADJ_NAME_DUP');
1149: x_return_status := FND_API.g_ret_sts_error;
1150: END IF;
1151:
1152: OZF_Offer_Adj_Line_PVT.debug_message('check_Offer_Adj_Uk_Items :: l_dup_effective_dt ' || l_dup_effective_dt );

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

1152: OZF_Offer_Adj_Line_PVT.debug_message('check_Offer_Adj_Uk_Items :: l_dup_effective_dt ' || l_dup_effective_dt );
1153:
1154: IF l_dup_effective_dt IS NOT NULL THEN
1155: IF l_dup_effective_dt = 1 THEN -- Show error, if 2 adjs. with same eff date exists. - sangara
1156: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFADJ_DUP_EFFDT');
1157: x_return_status := FND_API.g_ret_sts_error;
1158: END IF;
1159: END IF;
1160:

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

1174: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1175:
1176:
1177: -- IF p_offer_adj_rec.offer_adjustment_id = FND_API.G_MISS_NUM OR p_offer_adj_rec.offer_adjustment_id IS NULL THEN
1178: -- OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
1179: -- x_return_status := FND_API.g_ret_sts_error;
1180: -- END IF;
1181:
1182: -- List Header Id check

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

1180: -- END IF;
1181:
1182: -- List Header Id check
1183: IF p_offer_adj_rec.list_header_id = FND_API.G_MISS_NUM OR p_offer_adj_rec.list_header_id IS NULL THEN
1184: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_HEADER_ID' );
1185: x_return_status := FND_API.g_ret_sts_error;
1186: END IF;
1187:
1188: -- Adjustment Name check

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

1186: END IF;
1187:
1188: -- Adjustment Name check
1189: IF p_offer_adj_rec.offer_adjustment_name = FND_API.G_MISS_CHAR OR p_offer_adj_rec.offer_adjustment_name IS NULL THEN
1190: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_NAME' );
1191: x_return_status := FND_API.g_ret_sts_error;
1192: END IF;
1193:
1194: -- Status Code check

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

1192: END IF;
1193:
1194: -- Status Code check
1195: IF p_offer_adj_rec.status_code = FND_API.G_MISS_CHAR OR p_offer_adj_rec.offer_adjustment_name IS NULL THEN
1196: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'STATUS_CODE' );
1197: x_return_status := FND_API.g_ret_sts_error;
1198: END IF;
1199:
1200: -- Effective Date check

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

1198: END IF;
1199:
1200: -- Effective Date check
1201: IF p_offer_adj_rec.effective_date = FND_API.G_MISS_DATE OR p_offer_adj_rec.effective_date IS NULL THEN
1202: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'EFFECTIVE_DATE' );
1203: x_return_status := FND_API.g_ret_sts_error;
1204: END IF;
1205:
1206: ELSE

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

1205:
1206: ELSE
1207:
1208: IF p_offer_adj_rec.offer_adjustment_id = FND_API.G_MISS_NUM THEN
1209: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
1210: x_return_status := FND_API.g_ret_sts_error;
1211: END IF;
1212:
1213:

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

1211: END IF;
1212:
1213:
1214: IF p_offer_adj_rec.list_header_id = FND_API.G_MISS_NUM THEN
1215: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_HEADER_ID' );
1216: x_return_status := FND_API.g_ret_sts_error;
1217: END IF;
1218:
1219: END IF;

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

1554: );
1555:
1556: -- If the Effective date is before the start date of any of the budgets dont create or update adjustments
1557: 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
1558: ozf_utility_pvt.error_message('OZF_OFFR_ADJ_DT_LT_BUDGET_DT');
1559: RAISE FND_API.G_EXC_ERROR;
1560: END IF;
1561:
1562: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 1599: WHEN OZF_Utility_PVT.resource_locked THEN

1595: p_data => x_msg_data
1596: );
1597: EXCEPTION
1598:
1599: WHEN OZF_Utility_PVT.resource_locked THEN
1600: x_return_status := FND_API.g_ret_sts_error;
1601: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1602:
1603: WHEN FND_API.G_EXC_ERROR THEN

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

1597: EXCEPTION
1598:
1599: WHEN OZF_Utility_PVT.resource_locked THEN
1600: x_return_status := FND_API.g_ret_sts_error;
1601: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1602:
1603: WHEN FND_API.G_EXC_ERROR THEN
1604: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1605: x_return_status := FND_API.G_RET_STS_ERROR;