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 194: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

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

Line 201: IF p_validation_mode = JTF_PLSQL_API.g_create

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

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

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

Line 240: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

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

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

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

Line 324: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

320: IS
321: BEGIN
322: x_return_status := FND_API.g_ret_sts_success;
323:
324: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
325:
326:
327: 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
328: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_DISCOUNT_LINE_ID' );

Line 804: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

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

Line 817: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

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

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

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

Line 829: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

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

Line 1042: p_validation_mode => JTF_PLSQL_API.g_create,

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

Line 1305: p_validation_mode => JTF_PLSQL_API.g_update,

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

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

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

Line 1747: IF p_validation_mode = JTF_PLSQL_API.g_create

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

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

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

Line 1773: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

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

Line 2179: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

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

Line 2192: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

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

Line 2201: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

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

Line 2409: p_validation_mode => JTF_PLSQL_API.g_create,

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

Line 2648: p_validation_mode => JTF_PLSQL_API.g_update,

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

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

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

Line 3133: IF p_validation_mode = JTF_PLSQL_API.g_create

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

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

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

Line 3168: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

3164: IS
3165: BEGIN
3166: x_return_status := FND_API.g_ret_sts_success;
3167:
3168: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
3169:
3170:
3171: 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
3172: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DISCOUNT_PRODUCT_RELN_ID' );

Line 3464: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

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

Line 3478: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

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

Line 3489: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

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

Line 3708: p_validation_mode => JTF_PLSQL_API.g_create,

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

Line 3940: p_validation_mode => JTF_PLSQL_API.g_update,

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

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

6362:
6363:
6364: PROCEDURE check_line_level_tiers(
6365: p_tier_rec IN ozf_offer_tier_rec_type,
6366: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
6367: x_return_status OUT NOCOPY VARCHAR2
6368: )
6369: IS
6370: CURSOR c_tier_level(p_offer_id NUMBER) IS

Line 6387: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

6383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6384: End If;
6385:
6386: IF l_tier_level <> 'HEADER' THEN
6387: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
6388: 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
6389: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'PARENT_DISCOUNT_LINE_ID' );
6390: x_return_status := FND_API.g_ret_sts_error;
6391: END IF;

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

6400: END check_line_level_tiers;
6401:
6402: PROCEDURE check_tier_Req_Items(
6403: p_tier_rec IN ozf_offer_tier_rec_type,
6404: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
6405: x_return_status OUT NOCOPY VARCHAR2
6406: )
6407: IS
6408: BEGIN

Line 6411: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

6407: IS
6408: BEGIN
6409: x_return_status := FND_API.g_ret_sts_success;
6410:
6411: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
6412:
6413: IF p_tier_rec.volume_from = FND_API.g_miss_num OR p_tier_rec.volume_from IS NULL THEN
6414: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'VOLUME_FROM' );
6415: x_return_status := FND_API.g_ret_sts_error;

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

6468: END check_tier_Req_Items;
6469:
6470: PROCEDURE check_uom(
6471: p_tier_rec IN ozf_offer_tier_rec_type,
6472: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
6473: x_return_status OUT NOCOPY VARCHAR2
6474: )
6475: IS
6476: g_qty VARCHAR2(30):= 'PRICING_ATTRIBUTE10';

Line 6480: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

6476: g_qty VARCHAR2(30):= 'PRICING_ATTRIBUTE10';
6477: g_amt VARCHAR2(30):= 'PRICING_ATTRIBUTE12';
6478: BEGIN
6479: x_return_status := FND_API.G_RET_STS_SUCCESS;
6480: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
6481: IF p_tier_rec.volume_type = g_qty THEN
6482: IF p_tier_rec.uom_code IS NULL OR p_tier_rec.uom_code = FND_API.G_MISS_CHAR THEN
6483: OZF_Utility_PVT.Error_Message('OZF_ACT_PRD_NO_UOM' );
6484: x_return_status := FND_API.g_ret_sts_error;

Line 6564: p_validation_mode => JTF_PLSQL_API.g_create,

6560: RAISE FND_API.G_EXC_ERROR;
6561: END IF;
6562: check_tier_Req_Items(-- change for header level tiers
6563: p_tier_rec => l_tier_rec,
6564: p_validation_mode => JTF_PLSQL_API.g_create,
6565: x_return_status => x_return_status
6566: );
6567: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6568: RAISE FND_API.G_EXC_ERROR;

Line 6572: p_validation_mode => JTF_PLSQL_API.g_create,

6568: RAISE FND_API.G_EXC_ERROR;
6569: END IF;
6570: check_uom(
6571: p_tier_rec => l_tier_rec,
6572: p_validation_mode => JTF_PLSQL_API.g_create,
6573: x_return_status => x_return_status
6574: );
6575:
6576: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 6703: p_validation_mode => JTF_PLSQL_API.g_update,

6699: -- end comment
6700:
6701: check_tier_Req_Items(
6702: p_tier_rec => l_tier_rec,
6703: p_validation_mode => JTF_PLSQL_API.g_update,
6704: x_return_status => x_return_status
6705: );
6706: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6707: RAISE FND_API.G_EXC_ERROR;

Line 6711: p_validation_mode => JTF_PLSQL_API.g_update,

6707: RAISE FND_API.G_EXC_ERROR;
6708: END IF;
6709: check_uom(
6710: p_tier_rec => l_tier_rec,
6711: p_validation_mode => JTF_PLSQL_API.g_update,
6712: x_return_status => x_return_status
6713: );
6714:
6715: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN