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

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

189:
190:
191: PROCEDURE check_Ozf_Offer_Line_Uk_Items(
192: p_ozf_offer_line_rec IN ozf_offer_line_rec_type,
193: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
194: x_return_status OUT NOCOPY VARCHAR2)
195: IS
196: l_valid_flag VARCHAR2(1);
197:

Line 200: IF p_validation_mode = JTF_PLSQL_API.g_create

196: l_valid_flag VARCHAR2(1);
197:
198: BEGIN
199: x_return_status := FND_API.g_ret_sts_success;
200: IF p_validation_mode = JTF_PLSQL_API.g_create
201: AND p_ozf_offer_line_rec.offer_discount_line_id IS NOT NULL
202: THEN
203: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
204: 'ozf_offer_discount_lines',

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

222: 4)If Tier Level is header then Volume To is required
223: */
224: PROCEDURE check_volume_req_items(
225: p_ozf_offer_line_rec IN ozf_offer_line_rec_type,
226: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
227: x_return_status OUT NOCOPY VARCHAR2
228: )
229: IS
230: CURSOR c_tier_level(p_offer_id NUMBER) IS

Line 239: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

235: BEGIN
236: open c_tier_level(p_ozf_offer_line_rec.offer_id);
237: fetch c_tier_level into l_tier_level;
238: close c_tier_level;
239: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
240: IF p_ozf_offer_line_rec.volume_from IS NOT NULL OR p_ozf_offer_line_rec.volume_from <> FND_API.G_MISS_NUM THEN
241: IF p_ozf_offer_line_rec.volume_type IS NULL OR p_ozf_offer_line_rec.volume_type = FND_API.G_MISS_CHAR THEN
242: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'VOLUME_TYPE' );
243: x_return_status := FND_API.g_ret_sts_error;

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

312: END check_volume_req_items;
313:
314: PROCEDURE check_Ozf_Offer_Line_Req_Items(
315: p_ozf_offer_line_rec IN ozf_offer_line_rec_type,
316: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
317: x_return_status OUT NOCOPY VARCHAR2
318: )
319: IS
320: BEGIN

Line 323: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

319: IS
320: BEGIN
321: x_return_status := FND_API.g_ret_sts_success;
322:
323: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
324:
325:
326: IF p_ozf_offer_line_rec.offer_discount_line_id = FND_API.G_MISS_NUM OR p_ozf_offer_line_rec.offer_discount_line_id IS NULL THEN
327: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_DISCOUNT_LINE_ID' );

Line 803: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

799:
800: -- Initialize API return status to SUCCESS
801: x_return_status := FND_API.G_RET_STS_SUCCESS;
802:
803: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
804: Check_ozf_offer_line_Items(
805: p_ozf_offer_line_rec => p_ozf_offer_line_rec,
806: p_validation_mode => p_validation_mode,
807: x_return_status => x_return_status

Line 816: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

812: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
814: END IF;
815: END IF;
816: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
817: Default_Ozf_Offer_Line_Items (p_ozf_offer_line_rec => p_ozf_offer_line_rec ,
818: x_ozf_offer_line_rec => l_ozf_offer_line_rec) ;
819: END IF ;
820:

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

818: x_ozf_offer_line_rec => l_ozf_offer_line_rec) ;
819: END IF ;
820:
821:
822: -- IF p_validation_mode = JTF_PLSQL_API.g_update THEN
823: Complete_ozf_offer_line_Rec(
824: p_ozf_offer_line_rec => l_ozf_offer_line_rec,
825: x_complete_rec => l_ozf_offer_line_rec
826: );

Line 828: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

824: p_ozf_offer_line_rec => l_ozf_offer_line_rec,
825: x_complete_rec => l_ozf_offer_line_rec
826: );
827: -- END IF;
828: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
829: Validate_ozf_offer_line_Rec(
830: p_api_version_number => 1.0,
831: p_init_msg_list => FND_API.G_FALSE,
832: x_return_status => x_return_status,

Line 1041: p_validation_mode => JTF_PLSQL_API.g_create,

1037: Validate_ozf_disc_line(
1038: p_api_version_number => 1.0,
1039: p_init_msg_list => FND_API.G_FALSE,
1040: p_validation_level => p_validation_level,
1041: p_validation_mode => JTF_PLSQL_API.g_create,
1042: p_ozf_offer_line_rec => l_ozf_offer_line_rec,
1043: x_return_status => x_return_status,
1044: x_msg_count => x_msg_count,
1045: x_msg_data => x_msg_data);

Line 1304: p_validation_mode => JTF_PLSQL_API.g_update,

1300: Validate_ozf_disc_line(
1301: p_api_version_number => 1.0,
1302: p_init_msg_list => FND_API.G_FALSE,
1303: p_validation_level => p_validation_level,
1304: p_validation_mode => JTF_PLSQL_API.g_update,
1305: p_ozf_offer_line_rec => p_ozf_offer_line_rec,
1306: x_return_status => x_return_status,
1307: x_msg_count => x_msg_count,
1308: x_msg_data => x_msg_data);

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

1736: END check_item_exists;
1737:
1738: PROCEDURE check_Ozf_Prod_Uk_Items(
1739: p_ozf_prod_rec IN ozf_prod_rec_type,
1740: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1741: x_return_status OUT NOCOPY VARCHAR2)
1742: IS
1743: l_valid_flag VARCHAR2(1);
1744: BEGIN

Line 1746: IF p_validation_mode = JTF_PLSQL_API.g_create

1742: IS
1743: l_valid_flag VARCHAR2(1);
1744: BEGIN
1745: x_return_status := FND_API.g_ret_sts_success;
1746: IF p_validation_mode = JTF_PLSQL_API.g_create
1747: AND p_ozf_prod_rec.off_discount_product_id IS NOT NULL
1748: THEN
1749: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1750: 'ozf_offer_discount_products',

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

1761:
1762:
1763: PROCEDURE check_Ozf_Prod_Req_Items(
1764: p_ozf_prod_rec IN ozf_prod_rec_type,
1765: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1766: x_return_status OUT NOCOPY VARCHAR2
1767: )
1768: IS
1769: BEGIN

Line 1772: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1768: IS
1769: BEGIN
1770: x_return_status := FND_API.g_ret_sts_success;
1771:
1772: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1773:
1774:
1775: IF p_ozf_prod_rec.offer_id = FND_API.G_MISS_NUM OR p_ozf_prod_rec.offer_id IS NULL THEN
1776: OZF_Utility_PVT.Error_Message('OZF_API_MISSING' , 'MISS_FIELD','OFFER_ID');

Line 2178: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

2174: -- Initialize API return status to SUCCESS
2175: x_return_status := FND_API.G_RET_STS_SUCCESS;
2176:
2177:
2178: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2179: Check_ozf_prod_Items(
2180: p_ozf_prod_rec => p_ozf_prod_rec,
2181: p_validation_mode => p_validation_mode,
2182: x_return_status => x_return_status

Line 2191: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

2187: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2189: END IF;
2190: END IF;
2191: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2192: Default_Ozf_Prod_Items (p_ozf_prod_rec => p_ozf_prod_rec ,
2193: x_ozf_prod_rec => l_ozf_prod_rec) ;
2194: END IF ;
2195:

Line 2200: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

2196: Complete_ozf_prod_Rec(
2197: p_ozf_prod_rec => l_ozf_prod_rec,
2198: x_complete_rec => l_ozf_prod_rec
2199: );
2200: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2201: Validate_ozf_prod_Rec(
2202: p_api_version_number => 1.0,
2203: p_init_msg_list => FND_API.G_FALSE,
2204: x_return_status => x_return_status,

Line 2408: p_validation_mode => JTF_PLSQL_API.g_create,

2404: Validate_create_ozf_prod_line(
2405: p_api_version_number => 1.0,
2406: p_init_msg_list => FND_API.G_FALSE,
2407: p_validation_level => p_validation_level,
2408: p_validation_mode => JTF_PLSQL_API.g_create,
2409: p_ozf_prod_rec => l_ozf_prod_rec,
2410: x_return_status => x_return_status,
2411: x_msg_count => x_msg_count,
2412: x_msg_data => x_msg_data);

Line 2647: p_validation_mode => JTF_PLSQL_API.g_update,

2643: Validate_create_ozf_prod_line(
2644: p_api_version_number => 1.0,
2645: p_init_msg_list => FND_API.G_FALSE,
2646: p_validation_level => p_validation_level,
2647: p_validation_mode => JTF_PLSQL_API.g_update,
2648: p_ozf_prod_rec => p_ozf_prod_rec,
2649: x_return_status => x_return_status,
2650: x_msg_count => x_msg_count,
2651: x_msg_data => x_msg_data);

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

3122:
3123:
3124: PROCEDURE check_Prod_Reln_Uk_Items(
3125: p_prod_reln_rec IN prod_reln_rec_type,
3126: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
3127: x_return_status OUT NOCOPY VARCHAR2)
3128: IS
3129: l_valid_flag VARCHAR2(10);
3130: BEGIN

Line 3132: IF p_validation_mode = JTF_PLSQL_API.g_create

3128: IS
3129: l_valid_flag VARCHAR2(10);
3130: BEGIN
3131: x_return_status := FND_API.g_ret_sts_success;
3132: IF p_validation_mode = JTF_PLSQL_API.g_create
3133: AND p_prod_reln_rec.discount_product_reln_id IS NOT NULL
3134: THEN
3135: IF OZF_Utility_PVT.check_uniqueness(
3136: 'ozf_discount_product_reln',

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

3156:
3157:
3158: PROCEDURE check_Prod_Reln_Req_Items(
3159: p_prod_reln_rec IN prod_reln_rec_type,
3160: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
3161: x_return_status OUT NOCOPY VARCHAR2
3162: )
3163: IS
3164: BEGIN

Line 3167: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

3163: IS
3164: BEGIN
3165: x_return_status := FND_API.g_ret_sts_success;
3166:
3167: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
3168:
3169:
3170: IF p_prod_reln_rec.discount_product_reln_id = FND_API.G_MISS_NUM OR p_prod_reln_rec.discount_product_reln_id IS NULL THEN
3171: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DISCOUNT_PRODUCT_RELN_ID' );

Line 3463: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

3459: THEN
3460: FND_MSG_PUB.initialize;
3461: END IF;
3462:
3463: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
3464: Check_prod_reln_Items(
3465: p_prod_reln_rec => p_prod_reln_rec,
3466: p_validation_mode => p_validation_mode,
3467: x_return_status => x_return_status

Line 3477: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

3473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3474: END IF;
3475: END IF;
3476:
3477: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
3478: Default_Prod_Reln_Items (p_prod_reln_rec => p_prod_reln_rec ,
3479: x_prod_reln_rec => l_prod_reln_rec) ;
3480: END IF ;
3481:

Line 3488: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

3484: p_prod_reln_rec => l_prod_reln_rec,
3485: x_complete_rec => l_prod_reln_rec
3486: );
3487:
3488: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
3489: Validate_prod_reln_Rec(
3490: p_api_version_number => 1.0,
3491: p_init_msg_list => FND_API.G_FALSE,
3492: x_return_status => x_return_status,

Line 3707: p_validation_mode => JTF_PLSQL_API.g_create,

3703: Validate_prod_reln(
3704: p_api_version_number => 1.0,
3705: p_init_msg_list => FND_API.G_FALSE,
3706: p_validation_level => p_validation_level,
3707: p_validation_mode => JTF_PLSQL_API.g_create,
3708: p_prod_reln_rec => l_prod_reln_rec,
3709: x_return_status => x_return_status,
3710: x_msg_count => x_msg_count,
3711: x_msg_data => x_msg_data);

Line 3939: p_validation_mode => JTF_PLSQL_API.g_update,

3935: Validate_prod_reln(
3936: p_api_version_number => 1.0,
3937: p_init_msg_list => FND_API.G_FALSE,
3938: p_validation_level => p_validation_level,
3939: p_validation_mode => JTF_PLSQL_API.g_update,
3940: p_prod_reln_rec => p_prod_reln_rec,
3941: x_return_status => x_return_status,
3942: x_msg_count => x_msg_count,
3943: x_msg_data => x_msg_data);

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

6325:
6326:
6327: PROCEDURE check_line_level_tiers(
6328: p_tier_rec IN ozf_offer_tier_rec_type,
6329: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
6330: x_return_status OUT NOCOPY VARCHAR2
6331: )
6332: IS
6333: CURSOR c_tier_level(p_offer_id NUMBER) IS

Line 6350: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

6346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6347: End If;
6348:
6349: IF l_tier_level <> 'HEADER' THEN
6350: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
6351: IF p_tier_rec.parent_discount_line_id = FND_API.g_miss_num OR p_tier_rec.parent_discount_line_id IS NULL THEN -- change check for parent tiers
6352: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'PARENT_DISCOUNT_LINE_ID' );
6353: x_return_status := FND_API.g_ret_sts_error;
6354: END IF;

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

6363: END check_line_level_tiers;
6364:
6365: PROCEDURE check_tier_Req_Items(
6366: p_tier_rec IN ozf_offer_tier_rec_type,
6367: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
6368: x_return_status OUT NOCOPY VARCHAR2
6369: )
6370: IS
6371: BEGIN

Line 6374: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

6370: IS
6371: BEGIN
6372: x_return_status := FND_API.g_ret_sts_success;
6373:
6374: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
6375:
6376: IF p_tier_rec.volume_from = FND_API.g_miss_num OR p_tier_rec.volume_from IS NULL THEN
6377: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'VOLUME_FROM' );
6378: x_return_status := FND_API.g_ret_sts_error;

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

6431: END check_tier_Req_Items;
6432:
6433: PROCEDURE check_uom(
6434: p_tier_rec IN ozf_offer_tier_rec_type,
6435: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
6436: x_return_status OUT NOCOPY VARCHAR2
6437: )
6438: IS
6439: g_qty VARCHAR2(30):= 'PRICING_ATTRIBUTE10';

Line 6443: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

6439: g_qty VARCHAR2(30):= 'PRICING_ATTRIBUTE10';
6440: g_amt VARCHAR2(30):= 'PRICING_ATTRIBUTE12';
6441: BEGIN
6442: x_return_status := FND_API.G_RET_STS_SUCCESS;
6443: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
6444: IF p_tier_rec.volume_type = g_qty THEN
6445: IF p_tier_rec.uom_code IS NULL OR p_tier_rec.uom_code = FND_API.G_MISS_CHAR THEN
6446: OZF_Utility_PVT.Error_Message('OZF_ACT_PRD_NO_UOM' );
6447: x_return_status := FND_API.g_ret_sts_error;

Line 6527: p_validation_mode => JTF_PLSQL_API.g_create,

6523: RAISE FND_API.G_EXC_ERROR;
6524: END IF;
6525: check_tier_Req_Items(-- change for header level tiers
6526: p_tier_rec => l_tier_rec,
6527: p_validation_mode => JTF_PLSQL_API.g_create,
6528: x_return_status => x_return_status
6529: );
6530: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6531: RAISE FND_API.G_EXC_ERROR;

Line 6535: p_validation_mode => JTF_PLSQL_API.g_create,

6531: RAISE FND_API.G_EXC_ERROR;
6532: END IF;
6533: check_uom(
6534: p_tier_rec => l_tier_rec,
6535: p_validation_mode => JTF_PLSQL_API.g_create,
6536: x_return_status => x_return_status
6537: );
6538:
6539: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 6666: p_validation_mode => JTF_PLSQL_API.g_update,

6662: -- end comment
6663:
6664: check_tier_Req_Items(
6665: p_tier_rec => l_tier_rec,
6666: p_validation_mode => JTF_PLSQL_API.g_update,
6667: x_return_status => x_return_status
6668: );
6669: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6670: RAISE FND_API.G_EXC_ERROR;

Line 6674: p_validation_mode => JTF_PLSQL_API.g_update,

6670: RAISE FND_API.G_EXC_ERROR;
6671: END IF;
6672: check_uom(
6673: p_tier_rec => l_tier_rec,
6674: p_validation_mode => JTF_PLSQL_API.g_update,
6675: x_return_status => x_return_status
6676: );
6677:
6678: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN