APPS.QP_VALIDATE_FNA dependencies on QP_VALIDATE

Line 1: PACKAGE BODY QP_Validate_Fna AS

1: PACKAGE BODY QP_Validate_Fna AS
2: /* $Header: QPXLFNAB.pls 120.2 2005/08/18 15:46:23 sfiresto noship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Validate_Fna';

2: /* $Header: QPXLFNAB.pls 120.2 2005/08/18 15:46:23 sfiresto noship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Validate_Fna';
7:
8: FUNCTION Check_Duplicate_Fnarea(p_pte_ss_fnarea_id varchar2,
9: p_fnarea_id varchar2,
10: p_pte_ss_id varchar2) RETURN BOOLEAN IS

Line 288: IF NOT QP_Validate.Created_By(p_FNA_rec.created_by) THEN

284: ( p_FNA_rec.created_by <>
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:

Line 298: IF NOT QP_Validate.Creation_Date(p_FNA_rec.creation_date) THEN

294: ( p_FNA_rec.creation_date <>
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:

Line 308: IF NOT QP_Validate.Enabled(p_FNA_rec.enabled_flag) THEN

304: ( p_FNA_rec.enabled_flag <>
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:

Line 318: IF NOT QP_Validate.Functional_Area(p_FNA_rec.functional_area_id) THEN

314: ( p_FNA_rec.functional_area_id <>
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:

Line 328: IF NOT QP_Validate.Last_Updated_By(p_FNA_rec.last_updated_by) THEN

324: ( p_FNA_rec.last_updated_by <>
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:

Line 338: IF NOT QP_Validate.Last_Update_Date(p_FNA_rec.last_update_date) THEN

334: ( p_FNA_rec.last_update_date <>
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:

Line 348: IF NOT QP_Validate.Last_Update_Login(p_FNA_rec.last_update_login) THEN

344: ( p_FNA_rec.last_update_login <>
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:

Line 358: IF NOT QP_Validate.Program_Application(p_FNA_rec.program_application_id) THEN

354: ( p_FNA_rec.program_application_id <>
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:

Line 368: IF NOT QP_Validate.Program(p_FNA_rec.program_id) THEN

364: ( p_FNA_rec.program_id <>
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:

Line 378: IF NOT QP_Validate.Program_Update_Date(p_FNA_rec.program_update_date) THEN

374: ( p_FNA_rec.program_update_date <>
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:

Line 388: IF NOT QP_Validate.Pte_Sourcesystem_Fnarea(p_FNA_rec.pte_sourcesystem_fnarea_id) THEN

384: ( p_FNA_rec.pte_sourcesystem_fnarea_id <>
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:

Line 398: IF NOT QP_Validate.Pte_Source_System(p_FNA_rec.pte_source_system_id) THEN

394: ( p_FNA_rec.pte_source_system_id <>
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:

Line 408: IF NOT QP_Validate.Request(p_FNA_rec.request_id) THEN

404: ( p_FNA_rec.request_id <>
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:

Line 418: IF NOT QP_Validate.Seeded(p_FNA_rec.seeded_flag) THEN

414: ( p_FNA_rec.seeded_flag <>
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:

Line 560: IF NOT QP_Validate.Desc_Flex( 'FNA' ) THEN

556: */
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;

Line 659: END QP_Validate_Fna;

655: END IF;
656:
657: END Entity_Delete;
658:
659: END QP_Validate_Fna;