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.QP_VALIDATE_SEG dependencies on FND_API

Line 17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

13: , p_old_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type :=
14: QP_Attributes_PUB.G_MISS_SEG_REC
15: )
16: IS
17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: BEGIN
19:
20: -- Check required attributes.
21:

Line 25: l_return_status := FND_API.G_RET_STS_ERROR;

21:
22: IF p_SEG_rec.segment_id IS NULL
23: THEN
24:
25: l_return_status := FND_API.G_RET_STS_ERROR;
26:
27: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
28: THEN
29:

Line 45: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

41:
42:
43: -- Return Error if a required attribute is missing.
44:
45: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
46:
47: RAISE FND_API.G_EXC_ERROR;
48:
49: END IF;

Line 47: RAISE FND_API.G_EXC_ERROR;

43: -- Return Error if a required attribute is missing.
44:
45: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
46:
47: RAISE FND_API.G_EXC_ERROR;
48:
49: END IF;
50:
51: --

Line 67: WHEN FND_API.G_EXC_ERROR THEN

63: x_return_status := l_return_status;
64:
65: EXCEPTION
66:
67: WHEN FND_API.G_EXC_ERROR THEN
68:
69: x_return_status := FND_API.G_RET_STS_ERROR;
70:
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 69: x_return_status := FND_API.G_RET_STS_ERROR;

65: EXCEPTION
66:
67: WHEN FND_API.G_EXC_ERROR THEN
68:
69: x_return_status := FND_API.G_RET_STS_ERROR;
70:
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
72:
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

67: WHEN FND_API.G_EXC_ERROR THEN
68:
69: x_return_status := FND_API.G_RET_STS_ERROR;
70:
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
72:
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
74:
75: WHEN OTHERS THEN

Line 73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

69: x_return_status := FND_API.G_RET_STS_ERROR;
70:
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
72:
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
74:
75: WHEN OTHERS THEN
76:
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
74:
75: WHEN OTHERS THEN
76:
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78:
79: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
80: THEN
81: OE_MSG_PUB.Add_Exc_Msg

Line 100: x_return_status := FND_API.G_RET_STS_SUCCESS;

96: )
97: IS
98: BEGIN
99:
100: x_return_status := FND_API.G_RET_STS_SUCCESS;
101:
102: -- Validate SEG attributes
103:
104: IF p_SEG_rec.availability_in_basic IS NOT NULL AND

Line 110: x_return_status := FND_API.G_RET_STS_ERROR;

106: p_old_SEG_rec.availability_in_basic OR
107: p_old_SEG_rec.availability_in_basic IS NULL )
108: THEN
109: IF NOT QP_Validate.Availability_In_Basic(p_SEG_rec.availability_in_basic) THEN
110: x_return_status := FND_API.G_RET_STS_ERROR;
111: END IF;
112: END IF;
113:
114: IF p_SEG_rec.created_by IS NOT NULL AND

Line 120: x_return_status := FND_API.G_RET_STS_ERROR;

116: p_old_SEG_rec.created_by OR
117: p_old_SEG_rec.created_by IS NULL )
118: THEN
119: IF NOT QP_Validate.Created_By(p_SEG_rec.created_by) THEN
120: x_return_status := FND_API.G_RET_STS_ERROR;
121: END IF;
122: END IF;
123:
124: IF p_SEG_rec.creation_date IS NOT NULL AND

Line 130: x_return_status := FND_API.G_RET_STS_ERROR;

126: p_old_SEG_rec.creation_date OR
127: p_old_SEG_rec.creation_date IS NULL )
128: THEN
129: IF NOT QP_Validate.Creation_Date(p_SEG_rec.creation_date) THEN
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: END IF;
132: END IF;
133:
134: IF p_SEG_rec.last_updated_by IS NOT NULL AND

Line 140: x_return_status := FND_API.G_RET_STS_ERROR;

136: p_old_SEG_rec.last_updated_by OR
137: p_old_SEG_rec.last_updated_by IS NULL )
138: THEN
139: IF NOT QP_Validate.Last_Updated_By(p_SEG_rec.last_updated_by) THEN
140: x_return_status := FND_API.G_RET_STS_ERROR;
141: END IF;
142: END IF;
143:
144: IF p_SEG_rec.last_update_date IS NOT NULL AND

Line 150: x_return_status := FND_API.G_RET_STS_ERROR;

146: p_old_SEG_rec.last_update_date OR
147: p_old_SEG_rec.last_update_date IS NULL )
148: THEN
149: IF NOT QP_Validate.Last_Update_Date(p_SEG_rec.last_update_date) THEN
150: x_return_status := FND_API.G_RET_STS_ERROR;
151: END IF;
152: END IF;
153:
154: IF p_SEG_rec.last_update_login IS NOT NULL AND

Line 160: x_return_status := FND_API.G_RET_STS_ERROR;

156: p_old_SEG_rec.last_update_login OR
157: p_old_SEG_rec.last_update_login IS NULL )
158: THEN
159: IF NOT QP_Validate.Last_Update_Login(p_SEG_rec.last_update_login) THEN
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: END IF;
162: END IF;
163:
164: IF p_SEG_rec.prc_context_id IS NOT NULL AND

Line 170: x_return_status := FND_API.G_RET_STS_ERROR;

166: p_old_SEG_rec.prc_context_id OR
167: p_old_SEG_rec.prc_context_id IS NULL )
168: THEN
169: IF NOT QP_Validate.Prc_Context(p_SEG_rec.prc_context_id) THEN
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: END IF;
172: END IF;
173:
174: IF p_SEG_rec.program_application_id IS NOT NULL AND

Line 180: x_return_status := FND_API.G_RET_STS_ERROR;

176: p_old_SEG_rec.program_application_id OR
177: p_old_SEG_rec.program_application_id IS NULL )
178: THEN
179: IF NOT QP_Validate.Program_Application(p_SEG_rec.program_application_id) THEN
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: END IF;
182: END IF;
183:
184: IF p_SEG_rec.program_id IS NOT NULL AND

Line 190: x_return_status := FND_API.G_RET_STS_ERROR;

186: p_old_SEG_rec.program_id OR
187: p_old_SEG_rec.program_id IS NULL )
188: THEN
189: IF NOT QP_Validate.Program(p_SEG_rec.program_id) THEN
190: x_return_status := FND_API.G_RET_STS_ERROR;
191: END IF;
192: END IF;
193:
194: IF p_SEG_rec.program_update_date IS NOT NULL AND

Line 200: x_return_status := FND_API.G_RET_STS_ERROR;

196: p_old_SEG_rec.program_update_date OR
197: p_old_SEG_rec.program_update_date IS NULL )
198: THEN
199: IF NOT QP_Validate.Program_Update_Date(p_SEG_rec.program_update_date) THEN
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: END IF;
202: END IF;
203:
204: IF p_SEG_rec.seeded_flag IS NOT NULL AND

Line 210: x_return_status := FND_API.G_RET_STS_ERROR;

206: p_old_SEG_rec.seeded_flag OR
207: p_old_SEG_rec.seeded_flag IS NULL )
208: THEN
209: IF NOT QP_Validate.Seeded(p_SEG_rec.seeded_flag) THEN
210: x_return_status := FND_API.G_RET_STS_ERROR;
211: END IF;
212: END IF;
213:
214: IF p_SEG_rec.seeded_format_type IS NOT NULL AND

Line 220: x_return_status := FND_API.G_RET_STS_ERROR;

216: p_old_SEG_rec.seeded_format_type OR
217: p_old_SEG_rec.seeded_format_type IS NULL )
218: THEN
219: IF NOT QP_Validate.Seeded_Format_Type(p_SEG_rec.seeded_format_type) THEN
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: END IF;
222: END IF;
223:
224: IF p_SEG_rec.seeded_precedence IS NOT NULL AND

Line 230: x_return_status := FND_API.G_RET_STS_ERROR;

226: p_old_SEG_rec.seeded_precedence OR
227: p_old_SEG_rec.seeded_precedence IS NULL )
228: THEN
229: IF NOT QP_Validate.Seeded_Precedence(p_SEG_rec.seeded_precedence) THEN
230: x_return_status := FND_API.G_RET_STS_ERROR;
231: END IF;
232: END IF;
233:
234: IF p_SEG_rec.seeded_segment_name IS NOT NULL AND

Line 240: x_return_status := FND_API.G_RET_STS_ERROR;

236: p_old_SEG_rec.seeded_segment_name OR
237: p_old_SEG_rec.seeded_segment_name IS NULL )
238: THEN
239: IF NOT QP_Validate.Seeded_Segment_Name(p_SEG_rec.seeded_segment_name) THEN
240: x_return_status := FND_API.G_RET_STS_ERROR;
241: END IF;
242: END IF;
243:
244: IF p_SEG_rec.seeded_valueset_id IS NOT NULL AND

Line 250: x_return_status := FND_API.G_RET_STS_ERROR;

246: p_old_SEG_rec.seeded_valueset_id OR
247: p_old_SEG_rec.seeded_valueset_id IS NULL )
248: THEN
249: IF NOT QP_Validate.Seeded_Valueset(p_SEG_rec.seeded_valueset_id) THEN
250: x_return_status := FND_API.G_RET_STS_ERROR;
251: END IF;
252: END IF;
253:
254: IF p_SEG_rec.segment_code IS NOT NULL AND

Line 260: x_return_status := FND_API.G_RET_STS_ERROR;

256: p_old_SEG_rec.segment_code OR
257: p_old_SEG_rec.segment_code IS NULL )
258: THEN
259: IF NOT QP_Validate.Segment_code(p_SEG_rec.segment_code) THEN
260: x_return_status := FND_API.G_RET_STS_ERROR;
261: END IF;
262: END IF;
263:
264: IF p_SEG_rec.segment_id IS NOT NULL AND

Line 270: x_return_status := FND_API.G_RET_STS_ERROR;

266: p_old_SEG_rec.segment_id OR
267: p_old_SEG_rec.segment_id IS NULL )
268: THEN
269: IF NOT QP_Validate.Segment(p_SEG_rec.segment_id) THEN
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: END IF;
272: END IF;
273: -- Added Application_Id : Abhijit
274: IF p_SEG_rec.application_id IS NOT NULL AND

Line 280: x_return_status := FND_API.G_RET_STS_ERROR;

276: p_old_SEG_rec.application_id OR
277: p_old_SEG_rec.application_id IS NULL )
278: THEN
279: IF NOT QP_Validate.application_id(p_SEG_rec.application_id) THEN
280: x_return_status := FND_API.G_RET_STS_ERROR;
281: END IF;
282: END IF;
283:
284: IF p_SEG_rec.segment_mapping_column IS NOT NULL AND

Line 290: x_return_status := FND_API.G_RET_STS_ERROR;

286: p_old_SEG_rec.segment_mapping_column OR
287: p_old_SEG_rec.segment_mapping_column IS NULL )
288: THEN
289: IF NOT QP_Validate.Segment_Mapping_Column(p_SEG_rec.segment_mapping_column) THEN
290: x_return_status := FND_API.G_RET_STS_ERROR;
291: END IF;
292: END IF;
293:
294: IF p_SEG_rec.user_format_type IS NOT NULL AND

Line 300: x_return_status := FND_API.G_RET_STS_ERROR;

296: p_old_SEG_rec.user_format_type OR
297: p_old_SEG_rec.user_format_type IS NULL )
298: THEN
299: IF NOT QP_Validate.User_Format_Type(p_SEG_rec.user_format_type) THEN
300: x_return_status := FND_API.G_RET_STS_ERROR;
301: END IF;
302: END IF;
303:
304: IF p_SEG_rec.user_precedence IS NOT NULL AND

Line 310: x_return_status := FND_API.G_RET_STS_ERROR;

306: p_old_SEG_rec.user_precedence OR
307: p_old_SEG_rec.user_precedence IS NULL )
308: THEN
309: IF NOT QP_Validate.User_Precedence(p_SEG_rec.user_precedence) THEN
310: x_return_status := FND_API.G_RET_STS_ERROR;
311: END IF;
312: END IF;
313:
314: IF p_SEG_rec.user_segment_name IS NOT NULL AND

Line 320: x_return_status := FND_API.G_RET_STS_ERROR;

316: p_old_SEG_rec.user_segment_name OR
317: p_old_SEG_rec.user_segment_name IS NULL )
318: THEN
319: IF NOT QP_Validate.User_Segment_Name(p_SEG_rec.user_segment_name) THEN
320: x_return_status := FND_API.G_RET_STS_ERROR;
321: END IF;
322: END IF;
323:
324: IF p_SEG_rec.user_valueset_id IS NOT NULL AND

Line 330: x_return_status := FND_API.G_RET_STS_ERROR;

326: p_old_SEG_rec.user_valueset_id OR
327: p_old_SEG_rec.user_valueset_id IS NULL )
328: THEN
329: IF NOT QP_Validate.User_Valueset(p_SEG_rec.user_valueset_id) THEN
330: x_return_status := FND_API.G_RET_STS_ERROR;
331: END IF;
332: END IF;
333:
334: IF p_SEG_rec.seeded_description IS NOT NULL AND

Line 340: x_return_status := FND_API.G_RET_STS_ERROR;

336: p_old_SEG_rec.seeded_description OR
337: p_old_SEG_rec.seeded_description IS NULL )
338: THEN
339: IF NOT QP_Validate.Seeded_Description_Seg(p_SEG_rec.seeded_description) THEN
340: x_return_status := FND_API.G_RET_STS_ERROR;
341: END IF;
342: END IF;
343:
344: IF p_SEG_rec.user_description IS NOT NULL AND

Line 351: x_return_status := FND_API.G_RET_STS_ERROR;

347: p_old_SEG_rec.user_description IS NULL )
348: THEN
349: IF NOT QP_Validate.User_Description_Seg(p_SEG_rec.user_description)
350: THEN
351: x_return_status := FND_API.G_RET_STS_ERROR;
352: END IF;
353: END IF;
354:
355: IF p_SEG_rec.required_flag IS NOT NULL AND

Line 361: x_return_status := FND_API.G_RET_STS_ERROR;

357: p_old_SEG_rec.required_flag OR
358: p_old_SEG_rec.required_flag IS NULL )
359: THEN
360: IF NOT QP_Validate.required_flag(p_SEG_rec.required_flag) THEN
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: END IF;
363: END IF;
364: -- Added for TCA
365: IF p_SEG_rec.party_hierarchy_enabled_flag IS NOT NULL AND

Line 371: x_return_status := FND_API.G_RET_STS_ERROR;

367: p_old_SEG_rec.party_hierarchy_enabled_flag OR
368: p_old_SEG_rec.party_hierarchy_enabled_flag IS NULL )
369: THEN
370: IF NOT QP_Validate.party_hierarchy_enabled_flag(p_SEG_rec.party_hierarchy_enabled_flag) THEN
371: x_return_status := FND_API.G_RET_STS_ERROR;
372: END IF;
373: END IF;
374:
375: IF (p_SEG_rec.attribute1 IS NOT NULL AND

Line 513: x_return_status := FND_API.G_RET_STS_ERROR;

509:
510: -- Validate descriptive flexfield.
511:
512: IF NOT QP_Validate.Desc_Flex( 'SEG' ) THEN
513: x_return_status := FND_API.G_RET_STS_ERROR;
514: END IF;
515:
516: END IF;
517:

Line 522: WHEN FND_API.G_EXC_ERROR THEN

518: -- Done validating attributes
519:
520: EXCEPTION
521:
522: WHEN FND_API.G_EXC_ERROR THEN
523:
524: x_return_status := FND_API.G_RET_STS_ERROR;
525:
526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 524: x_return_status := FND_API.G_RET_STS_ERROR;

520: EXCEPTION
521:
522: WHEN FND_API.G_EXC_ERROR THEN
523:
524: x_return_status := FND_API.G_RET_STS_ERROR;
525:
526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
527:
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

522: WHEN FND_API.G_EXC_ERROR THEN
523:
524: x_return_status := FND_API.G_RET_STS_ERROR;
525:
526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
527:
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529:
530: WHEN OTHERS THEN

Line 528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

524: x_return_status := FND_API.G_RET_STS_ERROR;
525:
526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
527:
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529:
530: WHEN OTHERS THEN
531:
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529:
530: WHEN OTHERS THEN
531:
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
533:
534: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
535: THEN
536: OE_MSG_PUB.Add_Exc_Msg

Line 553: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

549: )
550: IS
551: l_context_code varchar2(30);
552: is_attribute_used varchar2(1) := 'N';
553: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
554: BEGIN
555: -- Validate entity delete.
556: begin
557: select prc_context_code

Line 637: l_return_status := FND_API.G_RET_STS_ERROR;

633: end;
634: end if;
635: --
636: if is_attribute_used = 'Y' then
637: l_return_status := FND_API.G_RET_STS_ERROR;
638: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_DELETE_SEGMENT');
639: OE_MSG_PUB.Add;
640: raise fnd_api.g_exc_error;
641: end if;

Line 640: raise fnd_api.g_exc_error;

636: if is_attribute_used = 'Y' then
637: l_return_status := FND_API.G_RET_STS_ERROR;
638: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_DELETE_SEGMENT');
639: OE_MSG_PUB.Add;
640: raise fnd_api.g_exc_error;
641: end if;
642: --
643: x_return_status := l_return_status;
644:

Line 647: WHEN FND_API.G_EXC_ERROR THEN

643: x_return_status := l_return_status;
644:
645: EXCEPTION
646:
647: WHEN FND_API.G_EXC_ERROR THEN
648:
649: x_return_status := FND_API.G_RET_STS_ERROR;
650:
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 649: x_return_status := FND_API.G_RET_STS_ERROR;

645: EXCEPTION
646:
647: WHEN FND_API.G_EXC_ERROR THEN
648:
649: x_return_status := FND_API.G_RET_STS_ERROR;
650:
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
652:
653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

647: WHEN FND_API.G_EXC_ERROR THEN
648:
649: x_return_status := FND_API.G_RET_STS_ERROR;
650:
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
652:
653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654:
655: WHEN OTHERS THEN

Line 653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

649: x_return_status := FND_API.G_RET_STS_ERROR;
650:
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
652:
653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654:
655: WHEN OTHERS THEN
656:
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654:
655: WHEN OTHERS THEN
656:
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
658:
659: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
660: THEN
661: OE_MSG_PUB.Add_Exc_Msg