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

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

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

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

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

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

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

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

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

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

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

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

Line 486: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

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

Line 498: IF p_validation_mode = JTF_PLSQL_API.g_update THEN

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

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

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

Line 698: , p_validation_mode => JTF_PLSQL_API.g_create

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

Line 901: , p_validation_mode => JTF_PLSQL_API.g_update

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