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

Line 11: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_CREATE

7:
8:
9: PROCEDURE check_qual_mo_uk_items(
10: p_qual_mo_rec IN qual_mo_rec_type
11: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_CREATE
12: , x_return_status OUT NOCOPY VARCHAR2
13: )
14: IS
15: BEGIN

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

17: END check_qual_mo_uk_items;
18:
19: PROCEDURE check_qual_mo_req_items(
20: p_qual_mo_rec IN qual_mo_rec_type
21: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
22: , x_return_status OUT NOCOPY VARCHAR2
23: )
24: IS
25: BEGIN

Line 28: ozf_utility_pvt.debug_message('Mode is : '||p_validation_mode || ' : '||JTF_PLSQL_API.g_create);

24: IS
25: BEGIN
26: x_return_status := FND_API.G_RET_STS_SUCCESS;
27:
28: ozf_utility_pvt.debug_message('Mode is : '||p_validation_mode || ' : '||JTF_PLSQL_API.g_create);
29: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
30: IF p_qual_mo_rec.offer_market_option_id IS NULL OR p_qual_mo_rec.offer_market_option_id = FND_API.G_MISS_NUM THEN
31: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_market_option_id');
32: x_return_status := FND_API.g_ret_sts_error;

Line 29: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

25: BEGIN
26: x_return_status := FND_API.G_RET_STS_SUCCESS;
27:
28: ozf_utility_pvt.debug_message('Mode is : '||p_validation_mode || ' : '||JTF_PLSQL_API.g_create);
29: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
30: IF p_qual_mo_rec.offer_market_option_id IS NULL OR p_qual_mo_rec.offer_market_option_id = FND_API.G_MISS_NUM THEN
31: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_market_option_id');
32: x_return_status := FND_API.g_ret_sts_error;
33: END IF;

Line 40: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN

36: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','qp_qualifier_id');
37: x_return_status := FND_API.g_ret_sts_error;
38: END IF;
39:
40: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN
41:
42: IF p_qual_mo_rec.qualifier_market_option_id = FND_API.G_MISS_NUM THEN
43: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','qualifier_market_option_id');
44: x_return_status := FND_API.g_ret_sts_error;

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

63: END check_qual_mo_req_items;
64:
65: PROCEDURE check_qual_mo_fk_items(
66: p_qual_mo_rec IN qual_mo_rec_type
67: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
68: , x_return_status OUT NOCOPY VARCHAR2
69: )
70: IS
71:

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

93: END check_qual_mo_fk_items;
94:
95: PROCEDURE check_qual_mo_lkup_items(
96: p_qual_mo_rec IN qual_mo_rec_type
97: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
98: , x_return_status OUT NOCOPY VARCHAR2
99: )
100: IS
101: BEGIN

Line 107: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_CREATE

103: END check_qual_mo_lkup_items;
104:
105: PROCEDURE check_qual_mo_attr(
106: p_qual_mo_rec IN qual_mo_rec_type
107: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_CREATE
108: , x_return_status OUT NOCOPY VARCHAR2
109: )
110: IS
111: BEGIN

Line 117: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_CREATE

113: END check_qual_mo_attr;
114:
115: PROCEDURE check_qual_mo_inter_attr(
116: p_qual_mo_rec IN qual_mo_rec_type
117: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_CREATE
118: , x_return_status OUT NOCOPY VARCHAR2
119: )
120: IS
121: BEGIN

Line 127: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_CREATE

123: END check_qual_mo_inter_attr;
124:
125: PROCEDURE check_qual_mo_entity(
126: p_qual_mo_rec IN qual_mo_rec_type
127: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_CREATE
128: , x_return_status OUT NOCOPY VARCHAR2
129: )
130: IS
131: BEGIN

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

137:
138:
139: PROCEDURE Check_qual_mo_Items(
140: p_qual_mo_rec IN qual_mo_rec_type
141: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
142: , x_return_status OUT NOCOPY VARCHAR2
143: )
144: IS
145: BEGIN

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

228: (
229: p_api_version_number NUMBER
230: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
231: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
232: , p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
233: , x_return_status OUT NOCOPY VARCHAR2
234: , x_msg_count OUT NOCOPY VARCHAR2
235: , x_msg_data OUT NOCOPY VARCHAR2
236: , p_qual_mo_rec IN qual_mo_rec_type

Line 267: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

263:
264: -- Initialize API return status to SUCCESS
265: x_return_status := FND_API.G_RET_STS_SUCCESS;
266: -- check
267: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
268: Check_qual_mo_Items(
269: p_qual_mo_rec => p_qual_mo_rec,
270: p_validation_mode => p_validation_mode,
271: x_return_status => x_return_status

Line 279: IF p_validation_mode = JTF_PLSQL_API.g_update THEN

275: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: END IF;
278: END IF;
279: IF p_validation_mode = JTF_PLSQL_API.g_update THEN
280: /* Complete_mo_Rec(
281: p_vo_disc_rec => l_vo_disc_rec,
282: x_complete_rec => l_vo_disc_rec
283: );

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

282: x_complete_rec => l_vo_disc_rec
283: );
284: */
285: -- END IF;
286: /* IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
287: Validate_vo_discounts_rec(
288: p_api_version_number => 1.0,
289: p_init_msg_list => FND_API.G_FALSE,
290: x_return_status => x_return_status,

Line 477: , p_validation_mode => JTF_PLSQL_API.g_create

473: (
474: p_api_version_number => p_api_version_number
475: , p_init_msg_list => p_init_msg_list
476: , p_validation_level => p_validation_level
477: , p_validation_mode => JTF_PLSQL_API.g_create
478: , x_return_status => x_return_status
479: , x_msg_count => x_msg_count
480: , x_msg_data => x_msg_data
481: , p_qual_mo_rec => l_qual_mo_rec

Line 639: , p_validation_mode => JTF_PLSQL_API.g_update

635: (
636: p_api_version_number => p_api_version_number
637: , p_init_msg_list => p_init_msg_list
638: , p_validation_level => p_validation_level
639: , p_validation_mode => JTF_PLSQL_API.g_update
640: , x_return_status => x_return_status
641: , x_msg_count => x_msg_count
642: , x_msg_data => x_msg_data
643: , p_qual_mo_rec => p_qual_mo_rec