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_SOU dependencies on FND_API

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

13: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_SOU_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_SOU_rec.attribute_sourcing_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 SOU attributes
103:
104: IF p_SOU_rec.attribute_sourcing_id IS NOT NULL AND

Line 110: x_return_status := FND_API.G_RET_STS_ERROR;

106: p_old_SOU_rec.attribute_sourcing_id OR
107: p_old_SOU_rec.attribute_sourcing_id IS NULL )
108: THEN
109: IF NOT QP_Validate.Attribute_Sourcing(p_SOU_rec.attribute_sourcing_id) THEN
110: x_return_status := FND_API.G_RET_STS_ERROR;
111: END IF;
112: END IF;
113:
114: IF p_SOU_rec.attribute_sourcing_level IS NOT NULL AND

Line 120: x_return_status := FND_API.G_RET_STS_ERROR;

116: p_old_SOU_rec.attribute_sourcing_level OR
117: p_old_SOU_rec.attribute_sourcing_level IS NULL )
118: THEN
119: IF NOT QP_Validate.Attribute_Sourcing_Level(p_SOU_rec.attribute_sourcing_level) THEN
120: x_return_status := FND_API.G_RET_STS_ERROR;
121: END IF;
122: END IF;
123:
124: IF p_SOU_rec.application_id IS NOT NULL AND

Line 130: x_return_status := FND_API.G_RET_STS_ERROR;

126: p_old_SOU_rec.application_id OR
127: p_old_SOU_rec.application_id IS NULL )
128: THEN
129: IF NOT QP_Validate.application_id(p_SOU_rec.application_id) THEN
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: END IF;
132: END IF;
133:
134: IF p_SOU_rec.created_by IS NOT NULL AND

Line 140: x_return_status := FND_API.G_RET_STS_ERROR;

136: p_old_SOU_rec.created_by OR
137: p_old_SOU_rec.created_by IS NULL )
138: THEN
139: IF NOT QP_Validate.Created_By(p_SOU_rec.created_by) THEN
140: x_return_status := FND_API.G_RET_STS_ERROR;
141: END IF;
142: END IF;
143:
144: IF p_SOU_rec.creation_date IS NOT NULL AND

Line 150: x_return_status := FND_API.G_RET_STS_ERROR;

146: p_old_SOU_rec.creation_date OR
147: p_old_SOU_rec.creation_date IS NULL )
148: THEN
149: IF NOT QP_Validate.Creation_Date(p_SOU_rec.creation_date) THEN
150: x_return_status := FND_API.G_RET_STS_ERROR;
151: END IF;
152: END IF;
153:
154: IF p_SOU_rec.enabled_flag IS NOT NULL AND

Line 160: x_return_status := FND_API.G_RET_STS_ERROR;

156: p_old_SOU_rec.enabled_flag OR
157: p_old_SOU_rec.enabled_flag IS NULL )
158: THEN
159: IF NOT QP_Validate.Enabled(p_SOU_rec.enabled_flag) THEN
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: END IF;
162: END IF;
163:
164: IF p_SOU_rec.last_updated_by IS NOT NULL AND

Line 170: x_return_status := FND_API.G_RET_STS_ERROR;

166: p_old_SOU_rec.last_updated_by OR
167: p_old_SOU_rec.last_updated_by IS NULL )
168: THEN
169: IF NOT QP_Validate.Last_Updated_By(p_SOU_rec.last_updated_by) THEN
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: END IF;
172: END IF;
173:
174: IF p_SOU_rec.last_update_date IS NOT NULL AND

Line 180: x_return_status := FND_API.G_RET_STS_ERROR;

176: p_old_SOU_rec.last_update_date OR
177: p_old_SOU_rec.last_update_date IS NULL )
178: THEN
179: IF NOT QP_Validate.Last_Update_Date(p_SOU_rec.last_update_date) THEN
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: END IF;
182: END IF;
183:
184: IF p_SOU_rec.last_update_login IS NOT NULL AND

Line 190: x_return_status := FND_API.G_RET_STS_ERROR;

186: p_old_SOU_rec.last_update_login OR
187: p_old_SOU_rec.last_update_login IS NULL )
188: THEN
189: IF NOT QP_Validate.Last_Update_Login(p_SOU_rec.last_update_login) THEN
190: x_return_status := FND_API.G_RET_STS_ERROR;
191: END IF;
192: END IF;
193:
194: IF p_SOU_rec.program_application_id IS NOT NULL AND

Line 200: x_return_status := FND_API.G_RET_STS_ERROR;

196: p_old_SOU_rec.program_application_id OR
197: p_old_SOU_rec.program_application_id IS NULL )
198: THEN
199: IF NOT QP_Validate.Program_Application(p_SOU_rec.program_application_id) THEN
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: END IF;
202: END IF;
203:
204: IF p_SOU_rec.program_id IS NOT NULL AND

Line 210: x_return_status := FND_API.G_RET_STS_ERROR;

206: p_old_SOU_rec.program_id OR
207: p_old_SOU_rec.program_id IS NULL )
208: THEN
209: IF NOT QP_Validate.Program(p_SOU_rec.program_id) THEN
210: x_return_status := FND_API.G_RET_STS_ERROR;
211: END IF;
212: END IF;
213:
214: IF p_SOU_rec.program_update_date IS NOT NULL AND

Line 220: x_return_status := FND_API.G_RET_STS_ERROR;

216: p_old_SOU_rec.program_update_date OR
217: p_old_SOU_rec.program_update_date IS NULL )
218: THEN
219: IF NOT QP_Validate.Program_Update_Date(p_SOU_rec.program_update_date) THEN
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: END IF;
222: END IF;
223:
224: IF p_SOU_rec.request_type_code IS NOT NULL AND

Line 230: x_return_status := FND_API.G_RET_STS_ERROR;

226: p_old_SOU_rec.request_type_code OR
227: p_old_SOU_rec.request_type_code IS NULL )
228: THEN
229: IF NOT QP_Validate.Request_Type(p_SOU_rec.request_type_code) THEN
230: x_return_status := FND_API.G_RET_STS_ERROR;
231: END IF;
232: END IF;
233:
234: IF p_SOU_rec.seeded_flag IS NOT NULL AND

Line 240: x_return_status := FND_API.G_RET_STS_ERROR;

236: p_old_SOU_rec.seeded_flag OR
237: p_old_SOU_rec.seeded_flag IS NULL )
238: THEN
239: IF NOT QP_Validate.Seeded(p_SOU_rec.seeded_flag) THEN
240: x_return_status := FND_API.G_RET_STS_ERROR;
241: END IF;
242: END IF;
243:
244: IF p_SOU_rec.seeded_sourcing_type IS NOT NULL AND

Line 250: x_return_status := FND_API.G_RET_STS_ERROR;

246: p_old_SOU_rec.seeded_sourcing_type OR
247: p_old_SOU_rec.seeded_sourcing_type IS NULL )
248: THEN
249: IF NOT QP_Validate.Seeded_Sourcing_Type(p_SOU_rec.seeded_sourcing_type) THEN
250: x_return_status := FND_API.G_RET_STS_ERROR;
251: END IF;
252: END IF;
253:
254: IF p_SOU_rec.seeded_value_string IS NOT NULL AND

Line 260: x_return_status := FND_API.G_RET_STS_ERROR;

256: p_old_SOU_rec.seeded_value_string OR
257: p_old_SOU_rec.seeded_value_string IS NULL )
258: THEN
259: IF NOT QP_Validate.Seeded_Value_String(p_SOU_rec.seeded_value_string) THEN
260: x_return_status := FND_API.G_RET_STS_ERROR;
261: END IF;
262: END IF;
263:
264: IF p_SOU_rec.segment_id IS NOT NULL AND

Line 270: x_return_status := FND_API.G_RET_STS_ERROR;

266: p_old_SOU_rec.segment_id OR
267: p_old_SOU_rec.segment_id IS NULL )
268: THEN
269: IF NOT QP_Validate.Segment(p_SOU_rec.segment_id) THEN
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: END IF;
272: END IF;
273:
274: IF p_SOU_rec.user_sourcing_type IS NOT NULL AND

Line 280: x_return_status := FND_API.G_RET_STS_ERROR;

276: p_old_SOU_rec.user_sourcing_type OR
277: p_old_SOU_rec.user_sourcing_type IS NULL )
278: THEN
279: IF NOT QP_Validate.User_Sourcing_Type(p_SOU_rec.user_sourcing_type) THEN
280: x_return_status := FND_API.G_RET_STS_ERROR;
281: END IF;
282: END IF;
283:
284: IF p_SOU_rec.user_value_string IS NOT NULL AND

Line 290: x_return_status := FND_API.G_RET_STS_ERROR;

286: p_old_SOU_rec.user_value_string OR
287: p_old_SOU_rec.user_value_string IS NULL )
288: THEN
289: IF NOT QP_Validate.User_Value_String(p_SOU_rec.user_value_string) THEN
290: x_return_status := FND_API.G_RET_STS_ERROR;
291: END IF;
292: END IF;
293:
294: IF (p_SOU_rec.attribute1 IS NOT NULL AND

Line 432: x_return_status := FND_API.G_RET_STS_ERROR;

428:
429: -- Validate descriptive flexfield.
430:
431: IF NOT QP_Validate.Desc_Flex( 'SOU' ) THEN
432: x_return_status := FND_API.G_RET_STS_ERROR;
433: END IF;
434:
435: END IF;
436:

Line 441: WHEN FND_API.G_EXC_ERROR THEN

437: -- Done validating attributes
438:
439: EXCEPTION
440:
441: WHEN FND_API.G_EXC_ERROR THEN
442:
443: x_return_status := FND_API.G_RET_STS_ERROR;
444:
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 443: x_return_status := FND_API.G_RET_STS_ERROR;

439: EXCEPTION
440:
441: WHEN FND_API.G_EXC_ERROR THEN
442:
443: x_return_status := FND_API.G_RET_STS_ERROR;
444:
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446:
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

441: WHEN FND_API.G_EXC_ERROR THEN
442:
443: x_return_status := FND_API.G_RET_STS_ERROR;
444:
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446:
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448:
449: WHEN OTHERS THEN

Line 447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

443: x_return_status := FND_API.G_RET_STS_ERROR;
444:
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446:
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448:
449: WHEN OTHERS THEN
450:
451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448:
449: WHEN OTHERS THEN
450:
451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
452:
453: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
454: THEN
455: OE_MSG_PUB.Add_Exc_Msg

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

466: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
467: , p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
468: )
469: IS
470: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
471: BEGIN
472:
473: -- Validate entity delete.
474:

Line 483: WHEN FND_API.G_EXC_ERROR THEN

479: x_return_status := l_return_status;
480:
481: EXCEPTION
482:
483: WHEN FND_API.G_EXC_ERROR THEN
484:
485: x_return_status := FND_API.G_RET_STS_ERROR;
486:
487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 485: x_return_status := FND_API.G_RET_STS_ERROR;

481: EXCEPTION
482:
483: WHEN FND_API.G_EXC_ERROR THEN
484:
485: x_return_status := FND_API.G_RET_STS_ERROR;
486:
487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
488:
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

483: WHEN FND_API.G_EXC_ERROR THEN
484:
485: x_return_status := FND_API.G_RET_STS_ERROR;
486:
487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
488:
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490:
491: WHEN OTHERS THEN

Line 489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

485: x_return_status := FND_API.G_RET_STS_ERROR;
486:
487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
488:
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490:
491: WHEN OTHERS THEN
492:
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490:
491: WHEN OTHERS THEN
492:
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
494:
495: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
496: THEN
497: OE_MSG_PUB.Add_Exc_Msg