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

Line 46: OZF_UTILITY_PVT.debug_message(p_message_text);

42: )
43: IS
44: BEGIN
45: IF OZF_DEBUG_HIGH_ON THEN
46: OZF_UTILITY_PVT.debug_message(p_message_text);
47: END IF;
48: END debug_message;
49:
50:

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

164: -- =========================================================================
165:
166: IF FND_GLOBAL.USER_ID IS NULL
167: THEN
168: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
169: RAISE FND_API.G_EXC_ERROR;
170: END IF;
171:
172:

Line 240: WHEN OZF_Utility_PVT.resource_locked THEN

236: p_data => x_msg_data
237: );
238: EXCEPTION
239:
240: WHEN OZF_Utility_PVT.resource_locked THEN
241: x_return_status := FND_API.g_ret_sts_error;
242: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
243:
244: WHEN FND_API.G_EXC_ERROR THEN

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

238: EXCEPTION
239:
240: WHEN OZF_Utility_PVT.resource_locked THEN
241: x_return_status := FND_API.g_ret_sts_error;
242: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
243:
244: WHEN FND_API.G_EXC_ERROR THEN
245: ROLLBACK TO CREATE_Vol_Offr_PVT;
246: x_return_status := FND_API.G_RET_STS_ERROR;

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

380:
381: FETCH c_get_Vol_Offr INTO l_ref_vol_offr_tier_rec ;
382:
383: If ( c_get_Vol_Offr%NOTFOUND) THEN
384: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
385: p_token_name => 'INFO',
386: p_token_value => 'Vol_Offr') ;
387: RAISE FND_API.G_EXC_ERROR;
388: END IF;

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

392:
393:
394: If (l_tar_vol_offr_tier_rec.object_version_number is NULL or
395: l_tar_vol_offr_tier_rec.object_version_number = FND_API.G_MISS_NUM ) Then
396: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
397: p_token_name => 'COLUMN',
398: p_token_value => 'Last_Update_Date') ;
399: raise FND_API.G_EXC_ERROR;
400: End if;

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

399: raise FND_API.G_EXC_ERROR;
400: End if;
401: -- Check Whether record has been changed by someone else
402: If (l_tar_vol_offr_tier_rec.object_version_number <> l_ref_vol_offr_tier_rec.object_version_number) Then
403: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
404: p_token_name => 'INFO',
405: p_token_value => 'Vol_Offr') ;
406: raise FND_API.G_EXC_ERROR;
407: End if;

Line 471: WHEN OZF_Utility_PVT.resource_locked THEN

467: p_data => x_msg_data
468: );
469: EXCEPTION
470:
471: WHEN OZF_Utility_PVT.resource_locked THEN
472: x_return_status := FND_API.g_ret_sts_error;
473: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
474:
475: WHEN FND_API.G_EXC_ERROR THEN

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

469: EXCEPTION
470:
471: WHEN OZF_Utility_PVT.resource_locked THEN
472: x_return_status := FND_API.g_ret_sts_error;
473: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
474:
475: WHEN FND_API.G_EXC_ERROR THEN
476: ROLLBACK TO UPDATE_Vol_Offr_PVT;
477: x_return_status := FND_API.G_RET_STS_ERROR;

Line 624: WHEN OZF_Utility_PVT.resource_locked THEN

620: p_data => x_msg_data
621: );
622: EXCEPTION
623:
624: WHEN OZF_Utility_PVT.resource_locked THEN
625: x_return_status := FND_API.g_ret_sts_error;
626: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
627:
628: WHEN FND_API.G_EXC_ERROR THEN

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

622: EXCEPTION
623:
624: WHEN OZF_Utility_PVT.resource_locked THEN
625: x_return_status := FND_API.g_ret_sts_error;
626: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
627:
628: WHEN FND_API.G_EXC_ERROR THEN
629: ROLLBACK TO DELETE_Vol_Offr_PVT;
630: x_return_status := FND_API.G_RET_STS_ERROR;

Line 758: WHEN OZF_Utility_PVT.resource_locked THEN

754: p_data => x_msg_data);
755: debug_message(l_full_name ||': end');
756: EXCEPTION
757:
758: WHEN OZF_Utility_PVT.resource_locked THEN
759: x_return_status := FND_API.g_ret_sts_error;
760: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
761:
762: WHEN FND_API.G_EXC_ERROR THEN

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

756: EXCEPTION
757:
758: WHEN OZF_Utility_PVT.resource_locked THEN
759: x_return_status := FND_API.g_ret_sts_error;
760: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
761:
762: WHEN FND_API.G_EXC_ERROR THEN
763: ROLLBACK TO LOCK_Vol_Offr_PVT;
764: x_return_status := FND_API.G_RET_STS_ERROR;

Line 810: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

806:
807: BEGIN
808: x_return_status := FND_API.g_ret_sts_success;
809: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
810: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
811: 'ozf_volume_offer_tiers',
812: 'volume_offer_tiers_id = ''' || p_vol_offr_tier_rec.volume_offer_tiers_id ||''''
813: );
814: ELSE

Line 815: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

811: 'ozf_volume_offer_tiers',
812: 'volume_offer_tiers_id = ''' || p_vol_offr_tier_rec.volume_offer_tiers_id ||''''
813: );
814: ELSE
815: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
816: 'ozf_volume_offer_tiers',
817: 'volume_offer_tiers_id = ''' || p_vol_offr_tier_rec.volume_offer_tiers_id ||
818: ''' AND volume_offer_tiers_id <> ' || p_vol_offr_tier_rec.volume_offer_tiers_id
819: );

Line 823: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_VOLUME_OFFER_TIERS_ID_DUP');

819: );
820: END IF;
821:
822: IF l_valid_flag = FND_API.g_false THEN
823: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_VOLUME_OFFER_TIERS_ID_DUP');
824: x_return_status := FND_API.g_ret_sts_error;
825: END IF;
826:
827: END check_Vol_Offr_Tier_Uk_Items;

Line 932: OZF_Utility_PVT.check_fk_exists(

928:
929: IF p_vol_offr_tier_rec.qp_list_header_id <> FND_API.g_miss_num
930: AND p_vol_offr_tier_rec.qp_list_header_id IS NOT NULL THEN
931: IF
932: OZF_Utility_PVT.check_fk_exists(
933: p_table_name => 'OZF_OFFERS'
934: , p_pk_name => 'qp_list_header_id'
935: , p_pk_value => p_vol_offr_tier_rec.qp_list_header_id
936: , p_pk_data_type => OZF_Utility_PVT.g_number

Line 936: , p_pk_data_type => OZF_Utility_PVT.g_number

932: OZF_Utility_PVT.check_fk_exists(
933: p_table_name => 'OZF_OFFERS'
934: , p_pk_name => 'qp_list_header_id'
935: , p_pk_value => p_vol_offr_tier_rec.qp_list_header_id
936: , p_pk_data_type => OZF_Utility_PVT.g_number
937: , p_additional_where_clause => NULL
938: ) = FND_API.g_false
939: THEN
940: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_VO_BAD_LIST_HEADER_ID');

Line 940: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_VO_BAD_LIST_HEADER_ID');

936: , p_pk_data_type => OZF_Utility_PVT.g_number
937: , p_additional_where_clause => NULL
938: ) = FND_API.g_false
939: THEN
940: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_VO_BAD_LIST_HEADER_ID');
941: x_return_status := FND_API.g_ret_sts_error;
942: RETURN ;
943: END IF;
944: END IF;

Line 961: IF OZF_Utility_PVT.Check_Lookup_Exists

957:
958: IF p_vol_offr_tier_rec.discount_type_code <> FND_API.G_MISS_CHAR AND p_vol_offr_tier_rec.discount_type_code IS NOT NULL
959: THEN
960: debug_message(' LookUp type lookup code = '''|| p_vol_offr_tier_rec.discount_type_code);
961: IF OZF_Utility_PVT.Check_Lookup_Exists
962: ( p_lookup_table_name => 'OZF_LOOKUPS'
963: ,p_lookup_type => 'OZF_QP_ARITHMETIC_OPERATOR'
964: ,p_lookup_code => p_vol_offr_tier_rec.discount_type_code
965: ) = FND_API.G_FALSE then

Line 966: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_INVALID_DISCOUNT_TYPE');

962: ( p_lookup_table_name => 'OZF_LOOKUPS'
963: ,p_lookup_type => 'OZF_QP_ARITHMETIC_OPERATOR'
964: ,p_lookup_code => p_vol_offr_tier_rec.discount_type_code
965: ) = FND_API.G_FALSE then
966: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_INVALID_DISCOUNT_TYPE');
967: x_return_status := FND_API.G_RET_STS_ERROR;
968: -- If any errors happen abort API/Procedure.
969: RETURN;
970: END IF;

Line 975: IF OZF_Utility_PVT.Check_Lookup_Exists

971: END IF;
972: IF p_vol_offr_tier_rec.break_type_code <> FND_API.G_MISS_CHAR AND p_vol_offr_tier_rec.break_type_code IS NOT NULL
973: THEN
974: debug_message(' LookUp type lookup code = '''|| p_vol_offr_tier_rec.break_type_code);
975: IF OZF_Utility_PVT.Check_Lookup_Exists
976: ( p_lookup_table_name => 'QP_LOOKUPS'
977: ,p_lookup_type => 'PRICE_BREAK_TYPE_CODE'
978: ,p_lookup_code => p_vol_offr_tier_rec.break_type_code
979: ) = FND_API.G_FALSE then

Line 980: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_INVALID_BREAK_TYPE_TYPE');

976: ( p_lookup_table_name => 'QP_LOOKUPS'
977: ,p_lookup_type => 'PRICE_BREAK_TYPE_CODE'
978: ,p_lookup_code => p_vol_offr_tier_rec.break_type_code
979: ) = FND_API.G_FALSE then
980: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_INVALID_BREAK_TYPE_TYPE');
981: x_return_status := FND_API.G_RET_STS_ERROR;
982: -- If any errors happen abort API/Procedure.
983: RETURN;
984: END IF;

Line 989: IF OZF_Utility_PVT.Check_Lookup_Exists

985: END IF;
986: IF p_vol_offr_tier_rec.volume_type <> FND_API.G_MISS_CHAR AND p_vol_offr_tier_rec.volume_type IS NOT NULL
987: THEN
988: debug_message(' LookUp type lookup code = '''|| p_vol_offr_tier_rec.volume_type);
989: IF OZF_Utility_PVT.Check_Lookup_Exists
990: ( p_lookup_table_name => 'OZF_LOOKUPS'
991: ,p_lookup_type => 'OZF_QP_VOLUME_TYPE'
992: ,p_lookup_code => p_vol_offr_tier_rec.volume_type
993: ) = FND_API.G_FALSE then

Line 994: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_INVALID_VOLUME_TYPE');

990: ( p_lookup_table_name => 'OZF_LOOKUPS'
991: ,p_lookup_type => 'OZF_QP_VOLUME_TYPE'
992: ,p_lookup_code => p_vol_offr_tier_rec.volume_type
993: ) = FND_API.G_FALSE then
994: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_INVALID_VOLUME_TYPE');
995: x_return_status := FND_API.G_RET_STS_ERROR;
996: -- If any errors happen abort API/Procedure.
997: RETURN;
998: END IF;

Line 1257: WHEN OZF_Utility_PVT.resource_locked THEN

1253: p_data => x_msg_data
1254: );
1255: EXCEPTION
1256:
1257: WHEN OZF_Utility_PVT.resource_locked THEN
1258: x_return_status := FND_API.g_ret_sts_error;
1259: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1260:
1261: WHEN FND_API.G_EXC_ERROR THEN

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

1255: EXCEPTION
1256:
1257: WHEN OZF_Utility_PVT.resource_locked THEN
1258: x_return_status := FND_API.g_ret_sts_error;
1259: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1260:
1261: WHEN FND_API.G_EXC_ERROR THEN
1262: ROLLBACK TO VALIDATE_Vol_Offr_;
1263: x_return_status := FND_API.G_RET_STS_ERROR;