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

Line 116: p_validation_mode => JTF_PLSQL_API.g_create,

112: Validate_adj_new_prod(
113: p_api_version_number => 1.0,
114: p_init_msg_list => FND_API.G_FALSE,
115: p_validation_level => p_validation_level,
116: p_validation_mode => JTF_PLSQL_API.g_create,
117: p_adj_new_prod_rec => p_adj_new_prod_rec,
118: x_return_status => x_return_status,
119: x_msg_count => x_msg_count,
120: x_msg_data => x_msg_data);

Line 302: p_validation_mode => JTF_PLSQL_API.g_update,

298: Validate_adj_new_prod(
299: p_api_version_number => 1.0,
300: p_init_msg_list => FND_API.G_FALSE,
301: p_validation_level => p_validation_level,
302: p_validation_mode => JTF_PLSQL_API.g_update,
303: p_adj_new_prod_rec => p_adj_new_prod_rec,
304: x_return_status => x_return_status,
305: x_msg_count => x_msg_count,
306: x_msg_data => x_msg_data);

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

601:
602:
603: PROCEDURE check_adj_new_prod_uk_items(
604: p_adj_new_prod_rec IN adj_new_prod_rec_type,
605: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
606: x_return_status OUT NOCOPY VARCHAR2)
607: IS
608: l_valid_flag VARCHAR2(1);
609:

Line 612: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

608: l_valid_flag VARCHAR2(1);
609:
610: BEGIN
611: x_return_status := FND_API.g_ret_sts_success;
612: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
613: l_valid_flag := OZF_UTILITY_PVT.check_uniqueness(
614: 'OZF_OFFER_ADJ_NEW_PRODUCTS',
615: 'OFFER_ADJ_NEW_PRODUCT_ID = ''' || p_adj_new_prod_rec.OFFER_ADJ_NEW_PRODUCT_ID ||''''
616: );

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

631: END check_adj_new_prod_uk_items;
632:
633: PROCEDURE check_adj_new_prod_req_items(
634: p_adj_new_prod_rec IN adj_new_prod_rec_type,
635: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
636: x_return_status OUT NOCOPY VARCHAR2
637: )
638: IS
639: BEGIN

Line 641: ozf_utility_pvt.debug_message('Validation Mode is:'||p_validation_mode||' : '||JTF_PLSQL_API.g_create);

637: )
638: IS
639: BEGIN
640: x_return_status := FND_API.g_ret_sts_success;
641: ozf_utility_pvt.debug_message('Validation Mode is:'||p_validation_mode||' : '||JTF_PLSQL_API.g_create);
642: ozf_utility_pvt.debug_message('Product Ctx is :'||p_adj_new_prod_rec.product_context);
643: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
644: IF p_adj_new_prod_rec.offer_adj_new_line_id = FND_API.g_miss_num OR p_adj_new_prod_rec.offer_adj_new_line_id IS NULL THEN
645: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'offer_adj_new_line_id' );

Line 643: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

639: BEGIN
640: x_return_status := FND_API.g_ret_sts_success;
641: ozf_utility_pvt.debug_message('Validation Mode is:'||p_validation_mode||' : '||JTF_PLSQL_API.g_create);
642: ozf_utility_pvt.debug_message('Product Ctx is :'||p_adj_new_prod_rec.product_context);
643: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
644: IF p_adj_new_prod_rec.offer_adj_new_line_id = FND_API.g_miss_num OR p_adj_new_prod_rec.offer_adj_new_line_id IS NULL THEN
645: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'offer_adj_new_line_id' );
646: x_return_status := FND_API.g_ret_sts_error;
647: RETURN;

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

836: END check_adj_prod_Lkup_items;
837:
838: PROCEDURE Check_adj_new_prod_inter_attr(
839: p_adj_new_prod_rec IN adj_new_prod_rec_type
840: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
841: , x_return_status OUT NOCOPY VARCHAR2
842: )
843: IS
844:

Line 861: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

857: OPEN c_volumeType(p_adj_new_prod_rec.offer_adj_new_line_id);
858: FETCH c_volumeType INTO l_volumeType;
859: CLOSE c_volumeType;
860: IF l_volumeType.parent_adj_line_id IS NULL AND l_volumeType.volume_type = 'PRICING_ATTRIBUTE10' THEN
861: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
862: IF p_adj_new_prod_rec.uom_code = FND_API.G_MISS_CHAR OR p_adj_new_prod_rec.uom_code IS NULL
863: THEN
864: OZF_Utility_PVT.Error_Message('OZF_UOM_QTY_REQD' );
865: x_return_status := FND_API.g_ret_sts_error;

Line 868: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN

864: OZF_Utility_PVT.Error_Message('OZF_UOM_QTY_REQD' );
865: x_return_status := FND_API.g_ret_sts_error;
866: return;
867: END IF;
868: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN
869: IF p_adj_new_prod_rec.uom_code = FND_API.G_MISS_CHAR THEN
870: OZF_Utility_PVT.Error_Message('OZF_UOM_QTY_REQD' );
871: x_return_status := FND_API.g_ret_sts_error;
872: return;

Line 885: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

881: END IF;
882: CLOSE c_listLineType;
883:
884: IF l_listLineType = 'PBH' THEN
885: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
886: IF p_adj_new_prod_rec.uom_code = FND_API.G_MISS_CHAR OR p_adj_new_prod_rec.uom_code IS NULL THEN
887: OZF_Utility_PVT.Error_Message('OZF_PBH_UOM_REQD' );
888: x_return_status := FND_API.g_ret_sts_error;
889: return;

Line 891: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN

887: OZF_Utility_PVT.Error_Message('OZF_PBH_UOM_REQD' );
888: x_return_status := FND_API.g_ret_sts_error;
889: return;
890: END IF;
891: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN
892: IF p_adj_new_prod_rec.uom_code = FND_API.G_MISS_CHAR THEN
893: OZF_Utility_PVT.Error_Message('OZF_PBH_UOM_REQD' );
894: x_return_status := FND_API.g_ret_sts_error;
895: return;

Line 1109: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_update,

1105: PROCEDURE Validate_adj_new_prod(
1106: p_api_version_number IN NUMBER,
1107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1109: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_update,
1110: p_adj_new_prod_rec IN adj_new_prod_rec_type,
1111: x_return_status OUT NOCOPY VARCHAR2,
1112: x_msg_count OUT NOCOPY NUMBER,
1113: x_msg_data OUT NOCOPY VARCHAR2

Line 1139: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1135: IF FND_API.to_Boolean( p_init_msg_list )
1136: THEN
1137: FND_MSG_PUB.initialize;
1138: END IF;
1139: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1140: Check_adj_new_prod_Items(
1141: p_adj_new_prod_rec => p_adj_new_prod_rec,
1142: p_validation_mode => p_validation_mode,
1143: x_return_status => x_return_status

Line 1158: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1154: p_adj_new_prod_rec => p_adj_new_prod_rec,
1155: x_complete_rec => l_adj_new_prod_rec
1156: );
1157:
1158: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1159: Validate_adj_new_prod_Rec(
1160: p_api_version_number => 1.0,
1161: p_init_msg_list => FND_API.G_FALSE,
1162: x_return_status => x_return_status,