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

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

86:
87:
88: PROCEDURE check_vo_discounts_Uk_Items(
89: p_vo_disc_rec IN vo_disc_rec_type,
90: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
91: x_return_status OUT NOCOPY VARCHAR2)
92: IS
93: l_valid_flag VARCHAR2(1);
94: CURSOR c_name(p_name IN VARCHAR2 , p_offer_id IN NUMBER)

Line 110: IF p_validation_mode = JTF_PLSQL_API.g_create

106: BEGIN
107:
108: x_return_status := FND_API.g_ret_sts_success;
109:
110: IF p_validation_mode = JTF_PLSQL_API.g_create
111: AND p_vo_disc_rec.offer_discount_line_id IS NOT NULL
112: THEN
113: IF OZF_Utility_PVT.check_uniqueness('ozf_offer_discount_lines','offer_discount_line_id = ''' || p_vo_disc_rec.offer_discount_line_id ||'''') = FND_API.g_false THEN
114: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_DISC_LINE_ID_DUP');

Line 119: IF p_validation_mode = JTF_PLSQL_API.g_create

115: x_return_status := FND_API.g_ret_sts_error;
116: END IF;
117: END IF;
118:
119: IF p_validation_mode = JTF_PLSQL_API.g_create
120: AND p_vo_disc_rec.offr_disc_struct_name_id IS NOT NULL
121: THEN
122: IF OZF_Utility_PVT.check_uniqueness('ozf_offr_disc_struct_name_b','OFFR_DISC_STRUCT_NAME_ID = ''' || p_vo_disc_rec.offr_disc_struct_name_id ||'''') = FND_API.g_false THEN
123: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_DISC_NAME_ID_DUP');

Line 128: IF p_validation_mode = JTF_PLSQL_API.g_create

124: x_return_status := FND_API.g_ret_sts_error;
125: END IF;
126: END IF;
127:
128: IF p_validation_mode = JTF_PLSQL_API.g_create
129: AND p_vo_disc_rec.name IS NOT NULL
130: THEN
131: OPEN c_name(p_vo_disc_rec.name, p_vo_disc_rec.offer_id);
132: FETCH c_name INTO l_name;

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

170: -- ==============================================================================
171:
172: PROCEDURE check_PBH_req_items(
173: p_vo_disc_rec IN vo_disc_rec_type,
174: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
175: x_return_status OUT NOCOPY VARCHAR2
176: )
177: IS
178: l_api_name CONSTANT VARCHAR2(30) := 'check_PBH_req_items';

Line 212: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

208: x_return_status := FND_API.g_ret_sts_error;
209: END IF;
210:
211: -- get volume_type for the discount line
212: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
213: l_volume_type := p_vo_disc_rec.volume_type;
214: ELSIF p_validation_mode = JTF_PLSQL_API.g_update then
215: IF p_vo_disc_rec.volume_type IS NULL OR p_vo_disc_rec.volume_type = FND_API.G_MISS_CHAR THEN
216: OPEN c_volume_type(p_vo_disc_rec.offer_discount_line_id);

Line 214: ELSIF p_validation_mode = JTF_PLSQL_API.g_update then

210:
211: -- get volume_type for the discount line
212: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
213: l_volume_type := p_vo_disc_rec.volume_type;
214: ELSIF p_validation_mode = JTF_PLSQL_API.g_update then
215: IF p_vo_disc_rec.volume_type IS NULL OR p_vo_disc_rec.volume_type = FND_API.G_MISS_CHAR THEN
216: OPEN c_volume_type(p_vo_disc_rec.offer_discount_line_id);
217: FETCH c_volume_type INTO l_volume_type ;
218: CLOSE c_volume_type;

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

263: -- ==============================================================================
264:
265: PROCEDURE check_dis_req_items(
266: p_vo_disc_rec IN vo_disc_rec_type,
267: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
268: x_return_status OUT NOCOPY VARCHAR2
269: )
270: IS
271: l_api_name CONSTANT VARCHAR2(30) := 'check_dis_req_items';

Line 281: IF p_validation_mode = jtf_plsql_api.g_create THEN

277: l_discStr := OZF_UTILITY_PVT.getAttributeName(p_attributeCode => 'OZF_DISCOUNT' );
278: l_discStr := l_discStr || ' ' || OZF_UTILITY_PVT.getAttributeName(p_attributeCode =>'IEC_ALG_OR' , p_applicationId => 545) ;
279: l_discStr := l_discStr || ' '|| OZF_UTILITY_PVT.getAttributeName(p_attributeCode => 'OZF_FORMULA');
280:
281: IF p_validation_mode = jtf_plsql_api.g_create THEN
282: --parent discount line id is required
283: IF p_vo_disc_rec.parent_discount_line_id = FND_API.G_MISS_NUM OR p_vo_disc_rec.parent_discount_line_id IS NULL THEN
284: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'PARENT_DISCOUNT_LINE_ID' );
285: x_return_status := FND_API.g_ret_sts_error;

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

400: -- End of Comments
401: -- ==============================================================================
402: PROCEDURE check_vo_req_items(
403: p_vo_disc_rec IN vo_disc_rec_type,
404: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
405: x_return_status OUT NOCOPY VARCHAR2
406: )
407: IS
408: CURSOR c_offer_type(p_offer_id NUMBER) IS

Line 435: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

431: OZF_Offer_Adj_Line_PVT.debug_message('Offer Type is ' || l_offer_type || 'Offer Id is :'|| p_vo_disc_rec.offer_id);
432: -- if offer_type is not volume_offer return error message
433: IF l_offer_type = 'VOLUME_OFFER' THEN
434: -- get tier_type for the line either from db or from record itself
435: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
436: l_tier_type := p_vo_disc_rec.tier_type;
437: ELSIF p_validation_mode = JTF_PLSQL_API.g_update then
438: IF p_vo_disc_rec.tier_type IS NULL OR p_vo_disc_rec.tier_type = FND_API.G_MISS_CHAR THEN
439: OPEN c_tier_type(p_vo_disc_rec.offer_discount_line_id);

Line 437: ELSIF p_validation_mode = JTF_PLSQL_API.g_update then

433: IF l_offer_type = 'VOLUME_OFFER' THEN
434: -- get tier_type for the line either from db or from record itself
435: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
436: l_tier_type := p_vo_disc_rec.tier_type;
437: ELSIF p_validation_mode = JTF_PLSQL_API.g_update then
438: IF p_vo_disc_rec.tier_type IS NULL OR p_vo_disc_rec.tier_type = FND_API.G_MISS_CHAR THEN
439: OPEN c_tier_type(p_vo_disc_rec.offer_discount_line_id);
440: FETCH c_tier_type INTO l_tier_type ;
441: CLOSE c_tier_type;

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

507: -- End of Comments
508: -- ==============================================================================
509: PROCEDURE check_vo_discounts_req_items(
510: p_vo_disc_rec IN vo_disc_rec_type,
511: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
512: x_return_status OUT NOCOPY VARCHAR2
513: )
514: IS
515: l_api_name CONSTANT VARCHAR2(30) := 'check_vo_discounts_req_items';

Line 522: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

518: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');
519:
520: x_return_status := FND_API.g_ret_sts_success;
521: -- check required items
522: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
523: /*
524: IF p_vo_disc_rec.offer_discount_line_id = FND_API.G_MISS_NUM OR p_vo_disc_rec.offer_discount_line_id IS NULL THEN
525: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_DISCOUNT_LINE_ID' );
526: x_return_status := FND_API.g_ret_sts_error;

Line 1430: /*IF p_validation_mode <> JTF_PLSQL_API.g_create THEN

1426: x_return_status := FND_API.G_RET_STS_SUCCESS;
1427:
1428: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'Return status is : '|| x_return_status);
1429:
1430: /*IF p_validation_mode <> JTF_PLSQL_API.g_create THEN
1431: Complete_vo_discount_Rec(
1432: p_vo_disc_rec => px_vo_disc_rec,
1433: x_complete_rec => px_vo_disc_rec
1434: );

Line 1436: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1432: p_vo_disc_rec => px_vo_disc_rec,
1433: x_complete_rec => px_vo_disc_rec
1434: );
1435: END IF;*/
1436: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1437: Check_vo_discount_Items(
1438: p_vo_disc_rec => px_vo_disc_rec,
1439: p_validation_mode => p_validation_mode,
1440: x_return_status => x_return_status

Line 1449: -- IF p_validation_mode = JTF_PLSQL_API.g_update THEN

1445: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1447: END IF;
1448: END IF;
1449: -- IF p_validation_mode = JTF_PLSQL_API.g_update THEN
1450:
1451: -- END IF;
1452: /* IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1453: Validate_vo_discounts_rec(

Line 1452: /* IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1448: END IF;
1449: -- IF p_validation_mode = JTF_PLSQL_API.g_update THEN
1450:
1451: -- END IF;
1452: /* IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1453: Validate_vo_discounts_rec(
1454: p_api_version_number => 1.0,
1455: p_init_msg_list => FND_API.G_FALSE,
1456: x_return_status => x_return_status,

Line 2111: , p_validation_mode => JTF_PLSQL_API.g_create

2107: p_api_version_number => p_api_version_number
2108: , p_init_msg_list => p_init_msg_list
2109: , p_validation_level => p_validation_level
2110: , px_vo_disc_rec => l_vo_discount_rec
2111: , p_validation_mode => JTF_PLSQL_API.g_create
2112: , x_return_status => x_return_status
2113: , x_msg_count => x_msg_count
2114: , x_msg_data => x_msg_data
2115: );

Line 2369: , p_validation_mode => JTF_PLSQL_API.g_update

2365: p_api_version_number => p_api_version_number
2366: , p_init_msg_list => p_init_msg_list
2367: , p_validation_level => p_validation_level
2368: , px_vo_disc_rec => l_tar_vo_disc_line_rec
2369: , p_validation_mode => JTF_PLSQL_API.g_update
2370: , x_return_status => x_return_status
2371: , x_msg_count => x_msg_count
2372: , x_msg_data => x_msg_data
2373: );

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

2528: -- ==============================================================================
2529:
2530: PROCEDURE check_vo_product_Uk_Items(
2531: p_vo_prod_rec IN vo_prod_rec_type
2532: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
2533: , x_return_status OUT NOCOPY VARCHAR2
2534: )
2535: IS
2536: l_valid_flag VARCHAR2(1);

Line 2541: IF p_validation_mode = JTF_PLSQL_API.g_create

2537: l_api_name CONSTANT VARCHAR2(30) := 'check_vo_product_Uk_Items';
2538: BEGIN
2539: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');
2540: x_return_status := FND_API.g_ret_sts_success;
2541: IF p_validation_mode = JTF_PLSQL_API.g_create
2542: AND (p_vo_prod_rec.off_discount_product_id IS NOT NULL AND p_vo_prod_rec.off_discount_product_id <> FND_API.g_miss_num)
2543: THEN
2544: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
2545: 'ozf_offer_discount_products',

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

2603: -- ==============================================================================
2604:
2605: PROCEDURE check_vo_product_req_items(
2606: p_vo_prod_rec IN vo_prod_rec_type
2607: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
2608: , x_return_status OUT NOCOPY VARCHAR2
2609: )
2610: IS
2611: l_api_name CONSTANT VARCHAR2(30) := 'check_vo_product_req_items';

Line 2614: OZF_Offer_Adj_Line_PVT.debug_message('Validation Mode is : ' || p_validation_mode || ' '|| JTF_PLSQL_API.g_create);

2610: IS
2611: l_api_name CONSTANT VARCHAR2(30) := 'check_vo_product_req_items';
2612: BEGIN
2613: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');
2614: OZF_Offer_Adj_Line_PVT.debug_message('Validation Mode is : ' || p_validation_mode || ' '|| JTF_PLSQL_API.g_create);
2615: x_return_status := FND_API.g_ret_sts_success;
2616: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2617: IF p_vo_prod_rec.off_discount_product_id = FND_API.G_MISS_NUM OR p_vo_prod_rec.off_discount_product_id IS NULL THEN
2618: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'off_discount_product_id' );

Line 2616: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

2612: BEGIN
2613: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');
2614: OZF_Offer_Adj_Line_PVT.debug_message('Validation Mode is : ' || p_validation_mode || ' '|| JTF_PLSQL_API.g_create);
2615: x_return_status := FND_API.g_ret_sts_success;
2616: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2617: IF p_vo_prod_rec.off_discount_product_id = FND_API.G_MISS_NUM OR p_vo_prod_rec.off_discount_product_id IS NULL THEN
2618: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'off_discount_product_id' );
2619: x_return_status := FND_API.g_ret_sts_error;
2620: return;

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

3047: -- End of Comments
3048: -- ==============================================================================
3049: PROCEDURE Check_vo_product_Items(
3050: p_vo_prod_rec IN vo_prod_rec_type
3051: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
3052: , x_return_status OUT NOCOPY VARCHAR2
3053: )
3054: IS
3055: l_api_name CONSTANT VARCHAR2(30) := 'Check_vo_Product_Items';

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

3179: p_api_version_number IN NUMBER
3180: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3181: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3182: , p_vo_prod_rec IN vo_prod_rec_type
3183: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
3184: , x_return_status OUT NOCOPY VARCHAR2
3185: , x_msg_count OUT NOCOPY NUMBER
3186: , x_msg_data OUT NOCOPY VARCHAR2
3187: )

Line 3219: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

3215: x_return_status := FND_API.G_RET_STS_SUCCESS;
3216:
3217: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'Return status is : '|| x_return_status);
3218:
3219: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
3220: Check_vo_product_Items(
3221: p_vo_prod_rec => p_vo_prod_rec,
3222: p_validation_mode => p_validation_mode,
3223: x_return_status => x_return_status

Line 3231: -- IF p_validation_mode = JTF_PLSQL_API.g_update THEN

3227: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3229: END IF;
3230: END IF;
3231: -- IF p_validation_mode = JTF_PLSQL_API.g_update THEN
3232: /* Complete_vo_discount_Rec(
3233: p_vo_disc_rec => l_vo_disc_rec,
3234: x_complete_rec => l_vo_disc_rec
3235: );

Line 3238: /* IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

3234: x_complete_rec => l_vo_disc_rec
3235: );
3236: */
3237: -- END IF;
3238: /* IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
3239: Validate_vo_discounts_rec(
3240: p_api_version_number => 1.0,
3241: p_init_msg_list => FND_API.G_FALSE,
3242: x_return_status => x_return_status,

Line 3437: , p_validation_mode => JTF_PLSQL_API.g_create

3433: p_api_version_number => p_api_version_number
3434: , p_init_msg_list => p_init_msg_list
3435: , p_validation_level => p_validation_level
3436: , p_vo_prod_rec => l_vo_prod_rec
3437: , p_validation_mode => JTF_PLSQL_API.g_create
3438: , x_return_status => x_return_status
3439: , x_msg_count => x_msg_count
3440: , x_msg_data => x_msg_data
3441: );

Line 3631: , p_validation_mode => JTF_PLSQL_API.g_update

3627: p_api_version_number => p_api_version_number
3628: , p_init_msg_list => p_init_msg_list
3629: , p_validation_level => p_validation_level
3630: , p_vo_prod_rec => p_vo_prod_rec
3631: , p_validation_mode => JTF_PLSQL_API.g_update
3632: , x_return_status => x_return_status
3633: , x_msg_count => x_msg_count
3634: , x_msg_data => x_msg_data
3635: );