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

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

73:
74:
75: PROCEDURE check_mo_uk_items(
76: p_mo_rec IN vo_mo_rec_type
77: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
78: , x_return_status OUT NOCOPY VARCHAR2
79: )
80: IS
81: l_dummy NUMBER:= -1;

Line 93: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN

89:
90: BEGIN
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92: OZF_Volume_Offer_disc_PVT.debug_message('Market optionId is : '|| p_mo_rec.offer_market_option_id);
93: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
94: IF p_mo_rec.offer_market_option_id IS NOT NULL AND p_mo_rec.offer_market_option_id <> FND_API.G_MISS_NUM THEN
95: OZF_Volume_Offer_disc_PVT.debug_message('Checking qunqieness for moid');
96: IF OZF_Utility_PVT.check_uniqueness('ozf_offr_market_options','offer_market_option_id = ''' || p_mo_rec.offer_market_option_id ||'''') = FND_API.g_false THEN
97: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFF_MO_ID_DUP');

Line 104: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

100: END IF;
101: END IF;
102: OZF_Volume_Offer_disc_PVT.debug_message('Val mode is : '|| p_validation_mode);
103: /*
104: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
105: OZF_Volume_Offer_disc_PVT.debug_message('Val mode is1 : '|| p_validation_mode);
106: OZF_Volume_Offer_disc_PVT.debug_message('Market OPtion Id is1 '|| p_mo_rec.offer_market_option_id);
107: IF (p_mo_rec.offer_id IS NOT NULL AND p_mo_rec.offer_id <> FND_API.G_MISS_NUM)
108: AND (p_mo_rec.group_number IS NOT NULL AND p_mo_rec.group_number <> FND_API.G_MISS_NUM)

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

129: END check_mo_uk_items;
130:
131: PROCEDURE check_mo_req_items(
132: p_mo_rec IN vo_mo_rec_type
133: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
134: , x_return_status OUT NOCOPY VARCHAR2
135: )
136: IS
137: l_api_name CONSTANT VARCHAR2(30) := 'check_mo_req_items';

Line 140: OZF_Volume_Offer_disc_PVT.debug_message('Validation Mode is : ' || p_validation_mode || ' '|| JTF_PLSQL_API.g_create);

136: IS
137: l_api_name CONSTANT VARCHAR2(30) := 'check_mo_req_items';
138: BEGIN
139: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'start');
140: OZF_Volume_Offer_disc_PVT.debug_message('Validation Mode is : ' || p_validation_mode || ' '|| JTF_PLSQL_API.g_create);
141:
142: x_return_status := FND_API.g_ret_sts_success;
143:
144: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 144: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

140: OZF_Volume_Offer_disc_PVT.debug_message('Validation Mode is : ' || p_validation_mode || ' '|| JTF_PLSQL_API.g_create);
141:
142: x_return_status := FND_API.g_ret_sts_success;
143:
144: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
145: IF p_mo_rec.offer_id = FND_API.G_MISS_NUM OR p_mo_rec.offer_id IS NULL THEN
146: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ID' );
147: x_return_status := FND_API.g_ret_sts_error;
148: END IF;

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

221: END check_mo_req_items;
222:
223: PROCEDURE check_mo_fk_items(
224: p_mo_rec IN vo_mo_rec_type
225: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
226: , x_return_status OUT NOCOPY VARCHAR2
227: )
228: IS
229: l_dummy number := -1;

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

269: END check_mo_fk_items;
270:
271: PROCEDURE check_mo_lkup_items(
272: p_mo_rec IN vo_mo_rec_type
273: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
274: , x_return_status OUT NOCOPY VARCHAR2
275: )
276: IS
277: BEGIN

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

293:
294:
295: PROCEDURE check_mo_attr(
296: p_mo_rec IN vo_mo_rec_type
297: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
298: , x_return_status OUT NOCOPY VARCHAR2
299: )
300: IS
301: BEGIN

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

318:
319:
320: PROCEDURE check_mo_inter_attr(
321: p_mo_rec IN vo_mo_rec_type
322: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
323: , x_return_status OUT NOCOPY VARCHAR2
324: )
325: IS
326: BEGIN

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

328: END check_mo_inter_attr;
329:
330: PROCEDURE check_mo_entity(
331: p_mo_rec IN vo_mo_rec_type
332: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
333: , x_return_status OUT NOCOPY VARCHAR2
334: )
335: IS
336: BEGIN

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

340:
341:
342: PROCEDURE Check_mo_Items(
343: p_mo_rec IN vo_mo_rec_type
344: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
345: , x_return_status OUT NOCOPY VARCHAR2
346: )
347: IS
348: BEGIN

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

445: (
446: p_api_version_number IN NUMBER
447: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
448: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
449: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
450: , x_return_status OUT NOCOPY VARCHAR2
451: , x_msg_count OUT NOCOPY NUMBER
452: , x_msg_data OUT NOCOPY VARCHAR2
453: , p_mo_rec IN vo_mo_rec_type

Line 485: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

481: -- Initialize API return status to SUCCESS
482: x_return_status := FND_API.G_RET_STS_SUCCESS;
483:
484: -- check items
485: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
486: Check_mo_Items(
487: p_mo_rec => p_mo_rec,
488: p_validation_mode => p_validation_mode,
489: x_return_status => x_return_status

Line 497: IF p_validation_mode = JTF_PLSQL_API.g_update THEN

493: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: END IF;
496: END IF;
497: IF p_validation_mode = JTF_PLSQL_API.g_update THEN
498: /* Complete_mo_Rec(
499: p_vo_disc_rec => l_vo_disc_rec,
500: x_complete_rec => l_vo_disc_rec
501: );

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

500: x_complete_rec => l_vo_disc_rec
501: );
502: */
503: -- END IF;
504: /* IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
505: Validate_vo_discounts_rec(
506: p_api_version_number => 1.0,
507: p_init_msg_list => FND_API.G_FALSE,
508: x_return_status => x_return_status,

Line 697: , p_validation_mode => JTF_PLSQL_API.g_create

693: (
694: p_api_version_number => p_api_version_number
695: , p_init_msg_list => p_init_msg_list
696: , p_validation_level => p_validation_level
697: , p_validation_mode => JTF_PLSQL_API.g_create
698: , x_return_status => x_return_status
699: , x_msg_count => x_msg_count
700: , x_msg_data => x_msg_data
701: , p_mo_rec => l_mo_rec

Line 900: , p_validation_mode => JTF_PLSQL_API.g_update

896: (
897: p_api_version_number => p_api_version_number
898: , p_init_msg_list => p_init_msg_list
899: , p_validation_level => p_validation_level
900: , p_validation_mode => JTF_PLSQL_API.g_update
901: , x_return_status => x_return_status
902: , x_msg_count => x_msg_count
903: , x_msg_data => x_msg_data
904: , p_mo_rec => l_tar_mo_rec