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

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

41: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
42: QP_Attr_Map_PUB.G_MISS_FNA_REC
43: )
44: IS
45: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
46: l_fnarea VARCHAR2(80);
47: l_pte VARCHAR2(30);
48: l_ss VARCHAR2(30);
49: l_seed_err BOOLEAN := FALSE;

Line 58: l_return_status := FND_API.G_RET_STS_ERROR;

54:
55: IF p_FNA_rec.pte_sourcesystem_fnarea_id IS NULL
56: THEN
57:
58: l_return_status := FND_API.G_RET_STS_ERROR;
59:
60: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
61: THEN
62:

Line 78: l_return_status := FND_API.G_RET_STS_ERROR;

74:
75: IF p_FNA_rec.pte_source_system_id IS NULL
76: THEN
77:
78: l_return_status := FND_API.G_RET_STS_ERROR;
79:
80: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
81: THEN
82:

Line 94: l_return_status := FND_API.G_RET_STS_ERROR;

90:
91: IF p_FNA_rec.functional_area_id IS NULL
92: THEN
93:
94: l_return_status := FND_API.G_RET_STS_ERROR;
95:
96: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
97: THEN
98:

Line 109: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

105: END IF;
106:
107: -- Return Error if a required attribute is missing.
108:
109: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
110:
111: RAISE FND_API.G_EXC_ERROR;
112:
113: END IF;

Line 111: RAISE FND_API.G_EXC_ERROR;

107: -- Return Error if a required attribute is missing.
108:
109: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
110:
111: RAISE FND_API.G_EXC_ERROR;
112:
113: END IF;
114:
115: --

Line 136: l_return_status := FND_API.G_RET_STS_ERROR;

132: FROM mtl_default_category_sets
133: WHERE functional_area_id = p_fna_rec.functional_area_id;
134: EXCEPTION
135: WHEN NO_DATA_FOUND THEN
136: l_return_status := FND_API.G_RET_STS_ERROR;
137:
138: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
139: THEN
140: select pte_code, application_short_name

Line 159: l_return_status := FND_API.G_RET_STS_ERROR;

155: IF Check_Duplicate_Fnarea(p_FNA_rec.pte_sourcesystem_fnarea_id,
156: p_FNA_rec.functional_area_id,
157: p_FNA_rec.pte_source_system_id) THEN
158:
159: l_return_status := FND_API.G_RET_STS_ERROR;
160:
161: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
162: THEN
163: select pte_code, application_short_name

Line 224: l_return_status := FND_API.G_RET_STS_ERROR;

220:
221:
222: IF l_seed_err AND OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
223: THEN
224: l_return_status := FND_API.G_RET_STS_ERROR;
225: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_SEED_FUNC_AREAS');
226: OE_MSG_PUB.Add;
227: END IF;
228: END IF;

Line 233: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

229:
230:
231:
232:
233: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
234:
235: RAISE FND_API.G_EXC_ERROR;
236:
237: END IF;

Line 235: RAISE FND_API.G_EXC_ERROR;

231:
232:
233: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
234:
235: RAISE FND_API.G_EXC_ERROR;
236:
237: END IF;
238:
239: -- Done validating entity

Line 245: WHEN FND_API.G_EXC_ERROR THEN

241: x_return_status := l_return_status;
242:
243: EXCEPTION
244:
245: WHEN FND_API.G_EXC_ERROR THEN
246:
247: x_return_status := FND_API.G_RET_STS_ERROR;
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 247: x_return_status := FND_API.G_RET_STS_ERROR;

243: EXCEPTION
244:
245: WHEN FND_API.G_EXC_ERROR THEN
246:
247: x_return_status := FND_API.G_RET_STS_ERROR;
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250:
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

245: WHEN FND_API.G_EXC_ERROR THEN
246:
247: x_return_status := FND_API.G_RET_STS_ERROR;
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250:
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252:
253: WHEN OTHERS THEN

Line 251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

247: x_return_status := FND_API.G_RET_STS_ERROR;
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250:
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252:
253: WHEN OTHERS THEN
254:
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252:
253: WHEN OTHERS THEN
254:
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
256:
257: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
258: THEN
259: OE_MSG_PUB.Add_Exc_Msg

Line 279: x_return_status := FND_API.G_RET_STS_SUCCESS;

275: IS
276: l_pte VARCHAR2(30);
277: l_ss VARCHAR2(30);
278: BEGIN
279: x_return_status := FND_API.G_RET_STS_SUCCESS;
280:
281: -- Validate FNA attributes
282:
283: IF p_FNA_rec.created_by IS NOT NULL AND

Line 289: x_return_status := FND_API.G_RET_STS_ERROR;

285: p_old_FNA_rec.created_by OR
286: p_old_FNA_rec.created_by IS NULL )
287: THEN
288: IF NOT QP_Validate.Created_By(p_FNA_rec.created_by) THEN
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: END IF;
291: END IF;
292:
293: IF p_FNA_rec.creation_date IS NOT NULL AND

Line 299: x_return_status := FND_API.G_RET_STS_ERROR;

295: p_old_FNA_rec.creation_date OR
296: p_old_FNA_rec.creation_date IS NULL )
297: THEN
298: IF NOT QP_Validate.Creation_Date(p_FNA_rec.creation_date) THEN
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: END IF;
301: END IF;
302:
303: IF p_FNA_rec.enabled_flag IS NOT NULL AND

Line 309: x_return_status := FND_API.G_RET_STS_ERROR;

305: p_old_FNA_rec.enabled_flag OR
306: p_old_FNA_rec.enabled_flag IS NULL )
307: THEN
308: IF NOT QP_Validate.Enabled(p_FNA_rec.enabled_flag) THEN
309: x_return_status := FND_API.G_RET_STS_ERROR;
310: END IF;
311: END IF;
312:
313: IF p_FNA_rec.functional_area_id IS NOT NULL AND

Line 319: x_return_status := FND_API.G_RET_STS_ERROR;

315: p_old_FNA_rec.functional_area_id OR
316: p_old_FNA_rec.functional_area_id IS NULL )
317: THEN
318: IF NOT QP_Validate.Functional_Area(p_FNA_rec.functional_area_id) THEN
319: x_return_status := FND_API.G_RET_STS_ERROR;
320: END IF;
321: END IF;
322:
323: IF p_FNA_rec.last_updated_by IS NOT NULL AND

Line 329: x_return_status := FND_API.G_RET_STS_ERROR;

325: p_old_FNA_rec.last_updated_by OR
326: p_old_FNA_rec.last_updated_by IS NULL )
327: THEN
328: IF NOT QP_Validate.Last_Updated_By(p_FNA_rec.last_updated_by) THEN
329: x_return_status := FND_API.G_RET_STS_ERROR;
330: END IF;
331: END IF;
332:
333: IF p_FNA_rec.last_update_date IS NOT NULL AND

Line 339: x_return_status := FND_API.G_RET_STS_ERROR;

335: p_old_FNA_rec.last_update_date OR
336: p_old_FNA_rec.last_update_date IS NULL )
337: THEN
338: IF NOT QP_Validate.Last_Update_Date(p_FNA_rec.last_update_date) THEN
339: x_return_status := FND_API.G_RET_STS_ERROR;
340: END IF;
341: END IF;
342:
343: IF p_FNA_rec.last_update_login IS NOT NULL AND

Line 349: x_return_status := FND_API.G_RET_STS_ERROR;

345: p_old_FNA_rec.last_update_login OR
346: p_old_FNA_rec.last_update_login IS NULL )
347: THEN
348: IF NOT QP_Validate.Last_Update_Login(p_FNA_rec.last_update_login) THEN
349: x_return_status := FND_API.G_RET_STS_ERROR;
350: END IF;
351: END IF;
352:
353: IF p_FNA_rec.program_application_id IS NOT NULL AND

Line 359: x_return_status := FND_API.G_RET_STS_ERROR;

355: p_old_FNA_rec.program_application_id OR
356: p_old_FNA_rec.program_application_id IS NULL )
357: THEN
358: IF NOT QP_Validate.Program_Application(p_FNA_rec.program_application_id) THEN
359: x_return_status := FND_API.G_RET_STS_ERROR;
360: END IF;
361: END IF;
362:
363: IF p_FNA_rec.program_id IS NOT NULL AND

Line 369: x_return_status := FND_API.G_RET_STS_ERROR;

365: p_old_FNA_rec.program_id OR
366: p_old_FNA_rec.program_id IS NULL )
367: THEN
368: IF NOT QP_Validate.Program(p_FNA_rec.program_id) THEN
369: x_return_status := FND_API.G_RET_STS_ERROR;
370: END IF;
371: END IF;
372:
373: IF p_FNA_rec.program_update_date IS NOT NULL AND

Line 379: x_return_status := FND_API.G_RET_STS_ERROR;

375: p_old_FNA_rec.program_update_date OR
376: p_old_FNA_rec.program_update_date IS NULL )
377: THEN
378: IF NOT QP_Validate.Program_Update_Date(p_FNA_rec.program_update_date) THEN
379: x_return_status := FND_API.G_RET_STS_ERROR;
380: END IF;
381: END IF;
382:
383: IF p_FNA_rec.pte_sourcesystem_fnarea_id IS NOT NULL AND

Line 389: x_return_status := FND_API.G_RET_STS_ERROR;

385: p_old_FNA_rec.pte_sourcesystem_fnarea_id OR
386: p_old_FNA_rec.pte_sourcesystem_fnarea_id IS NULL )
387: THEN
388: IF NOT QP_Validate.Pte_Sourcesystem_Fnarea(p_FNA_rec.pte_sourcesystem_fnarea_id) THEN
389: x_return_status := FND_API.G_RET_STS_ERROR;
390: END IF;
391: END IF;
392:
393: IF p_FNA_rec.pte_source_system_id IS NOT NULL AND

Line 399: x_return_status := FND_API.G_RET_STS_ERROR;

395: p_old_FNA_rec.pte_source_system_id OR
396: p_old_FNA_rec.pte_source_system_id IS NULL )
397: THEN
398: IF NOT QP_Validate.Pte_Source_System(p_FNA_rec.pte_source_system_id) THEN
399: x_return_status := FND_API.G_RET_STS_ERROR;
400: END IF;
401: END IF;
402:
403: IF p_FNA_rec.request_id IS NOT NULL AND

Line 409: x_return_status := FND_API.G_RET_STS_ERROR;

405: p_old_FNA_rec.request_id OR
406: p_old_FNA_rec.request_id IS NULL )
407: THEN
408: IF NOT QP_Validate.Request(p_FNA_rec.request_id) THEN
409: x_return_status := FND_API.G_RET_STS_ERROR;
410: END IF;
411: END IF;
412:
413: IF p_FNA_rec.seeded_flag IS NOT NULL AND

Line 419: x_return_status := FND_API.G_RET_STS_ERROR;

415: p_old_FNA_rec.seeded_flag OR
416: p_old_FNA_rec.seeded_flag IS NULL )
417: THEN
418: IF NOT QP_Validate.Seeded(p_FNA_rec.seeded_flag) THEN
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: END IF;
421: END IF;
422:
423: IF (p_FNA_rec.attribute1 IS NOT NULL AND

Line 561: x_return_status := FND_API.G_RET_STS_ERROR;

557:
558: -- Validate descriptive flexfield.
559:
560: IF NOT QP_Validate.Desc_Flex( 'FNA' ) THEN
561: x_return_status := FND_API.G_RET_STS_ERROR;
562: END IF;
563:
564: END IF;
565:

Line 570: WHEN FND_API.G_EXC_ERROR THEN

566: -- Done validating attributes
567:
568: EXCEPTION
569:
570: WHEN FND_API.G_EXC_ERROR THEN
571:
572: x_return_status := FND_API.G_RET_STS_ERROR;
573:
574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 572: x_return_status := FND_API.G_RET_STS_ERROR;

568: EXCEPTION
569:
570: WHEN FND_API.G_EXC_ERROR THEN
571:
572: x_return_status := FND_API.G_RET_STS_ERROR;
573:
574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
575:
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

570: WHEN FND_API.G_EXC_ERROR THEN
571:
572: x_return_status := FND_API.G_RET_STS_ERROR;
573:
574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
575:
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
577:
578: WHEN OTHERS THEN

Line 576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

572: x_return_status := FND_API.G_RET_STS_ERROR;
573:
574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
575:
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
577:
578: WHEN OTHERS THEN
579:
580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
577:
578: WHEN OTHERS THEN
579:
580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
581:
582: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
583: THEN
584: OE_MSG_PUB.Add_Exc_Msg

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

595: ( x_return_status OUT NOCOPY VARCHAR2
596: , p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
597: )
598: IS
599: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
600: l_fnarea VARCHAR2(80);
601: l_pte VARCHAR2(30);
602: l_ss VARCHAR2(30);
603: BEGIN

Line 608: l_return_status := FND_API.G_RET_STS_ERROR;

604:
605: -- Validate entity delete.
606:
607: IF p_FNA_rec.seeded_flag = 'Y' THEN
608: l_return_status := FND_API.G_RET_STS_ERROR;
609:
610: select pte_code, application_short_name
611: into l_pte, l_ss
612: from qp_pte_source_systems

Line 637: WHEN FND_API.G_EXC_ERROR THEN

633: x_return_status := l_return_status;
634:
635: EXCEPTION
636:
637: WHEN FND_API.G_EXC_ERROR THEN
638:
639: x_return_status := FND_API.G_RET_STS_ERROR;
640:
641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 639: x_return_status := FND_API.G_RET_STS_ERROR;

635: EXCEPTION
636:
637: WHEN FND_API.G_EXC_ERROR THEN
638:
639: x_return_status := FND_API.G_RET_STS_ERROR;
640:
641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
642:
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

637: WHEN FND_API.G_EXC_ERROR THEN
638:
639: x_return_status := FND_API.G_RET_STS_ERROR;
640:
641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
642:
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644:
645: WHEN OTHERS THEN

Line 643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

639: x_return_status := FND_API.G_RET_STS_ERROR;
640:
641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
642:
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644:
645: WHEN OTHERS THEN
646:
647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644:
645: WHEN OTHERS THEN
646:
647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
648:
649: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
650: THEN
651: OE_MSG_PUB.Add_Exc_Msg