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

Line 59: p_seed_qual_rec.name = FND_API.G_MISS_CHAR OR

55: IS
56: BEGIN
57:
58: IF (p_seed_qual_rec.name IS NULL OR
59: p_seed_qual_rec.name = FND_API.G_MISS_CHAR OR
60: p_seed_qual_rec.description IS NULL OR
61: p_seed_qual_rec.description = FND_API.G_MISS_CHAR)
62: THEN
63: RETURN FND_API.G_TRUE;

Line 61: p_seed_qual_rec.description = FND_API.G_MISS_CHAR)

57:
58: IF (p_seed_qual_rec.name IS NULL OR
59: p_seed_qual_rec.name = FND_API.G_MISS_CHAR OR
60: p_seed_qual_rec.description IS NULL OR
61: p_seed_qual_rec.description = FND_API.G_MISS_CHAR)
62: THEN
63: RETURN FND_API.G_TRUE;
64: ELSE
65: RETURN FND_API.G_FALSE;

Line 63: RETURN FND_API.G_TRUE;

59: p_seed_qual_rec.name = FND_API.G_MISS_CHAR OR
60: p_seed_qual_rec.description IS NULL OR
61: p_seed_qual_rec.description = FND_API.G_MISS_CHAR)
62: THEN
63: RETURN FND_API.G_TRUE;
64: ELSE
65: RETURN FND_API.G_FALSE;
66: END IF;
67:

Line 65: RETURN FND_API.G_FALSE;

61: p_seed_qual_rec.description = FND_API.G_MISS_CHAR)
62: THEN
63: RETURN FND_API.G_TRUE;
64: ELSE
65: RETURN FND_API.G_FALSE;
66: END IF;
67:
68: END is_seed_qual_rec_missing;
69:

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

77: p_validation_mode IN VARCHAR2,
78: p_validation_level IN NUMBER,
79: x_return_status OUT NOCOPY VARCHAR2)
80: IS
81: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
82:
83: l_seed_qual_rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type := p_seed_qual_rec;
84:
85: BEGIN

Line 94: l_seed_qual_rec.seeded_qual_id = FND_API.G_MISS_NUM) )THEN

90:
91: /* If record is being updated, check that primary key is not null */
92: IF ( (p_validation_mode = JTF_CTM_UTILITY_PVT.G_UPDATE) AND
93: (l_seed_qual_rec.seeded_qual_id IS NULL OR
94: l_seed_qual_rec.seeded_qual_id = FND_API.G_MISS_NUM) )THEN
95:
96:
97: l_return_status := FND_API.G_RET_STS_ERROR;
98: END IF;

Line 97: l_return_status := FND_API.G_RET_STS_ERROR;

93: (l_seed_qual_rec.seeded_qual_id IS NULL OR
94: l_seed_qual_rec.seeded_qual_id = FND_API.G_MISS_NUM) )THEN
95:
96:
97: l_return_status := FND_API.G_RET_STS_ERROR;
98: END IF;
99:
100: -- IF ( p_validation_level >= JTF_CTM_UTILITY_PVT.G_VALID_LEVEL_RECORD ) THEN
101:

Line 103: IF (is_seed_qual_rec_missing (p_seed_qual_rec) = FND_API.G_TRUE) THEN

99:
100: -- IF ( p_validation_level >= JTF_CTM_UTILITY_PVT.G_VALID_LEVEL_RECORD ) THEN
101:
102: /* Check that all mandatory items exist in record */
103: IF (is_seed_qual_rec_missing (p_seed_qual_rec) = FND_API.G_TRUE) THEN
104:
105: l_return_status := FND_API.G_RET_STS_ERROR;
106:
107: /* Debug message */

Line 105: l_return_status := FND_API.G_RET_STS_ERROR;

101:
102: /* Check that all mandatory items exist in record */
103: IF (is_seed_qual_rec_missing (p_seed_qual_rec) = FND_API.G_TRUE) THEN
104:
105: l_return_status := FND_API.G_RET_STS_ERROR;
106:
107: /* Debug message */
108: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
109: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Miss req itms');

Line 143: l_seed_qual_out_rec.return_status := FND_API.G_RET_STS_SUCCESS;

139:
140: BEGIN
141:
142: -- Initialise API return status to success
143: l_seed_qual_out_rec.return_status := FND_API.G_RET_STS_SUCCESS;
144:
145: -- initialise local seeded qualifier record
146: l_seed_qual_rec := p_seed_qual_rec;
147:

Line 148: -- IF (l_seed_qual_rec.seeded_qual_id = FND_API.G_MISS_NUM) THEN

144:
145: -- initialise local seeded qualifier record
146: l_seed_qual_rec := p_seed_qual_rec;
147:
148: -- IF (l_seed_qual_rec.seeded_qual_id = FND_API.G_MISS_NUM) THEN
149: -- END IF;
150: -- check if qualifier with this name already exists
151: OPEN c_chk_qual_name (l_seed_qual_rec.name);
152: FETCH c_chk_qual_name INTO l_seeded_qual_id_csr;

Line 160: IF (l_seed_qual_rec.seeded_qual_id = FND_API.G_MISS_NUM) THEN

156:
157:
158: -- convert id to null, so that next value of sequence will
159: -- be selected in default table handler
160: IF (l_seed_qual_rec.seeded_qual_id = FND_API.G_MISS_NUM) THEN
161:
162: l_seed_qual_rec.seeded_qual_id := NULL;
163: END IF;
164:

Line 197: l_seed_qual_out_rec.return_status := FND_API.G_RET_STS_SUCCESS;

193:
194: CLOSE c_chk_qual_name;
195:
196:
197: l_seed_qual_out_rec.return_status := FND_API.G_RET_STS_SUCCESS;
198:
199: -- save id and status
200: x_seed_qual_out_rec := l_seed_qual_out_rec;
201:

Line 218: l_seed_qual_out_rec.return_status := FND_API.G_RET_STS_SUCCESS;

214: l_seed_qual_out_rec JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_OUT_REC;
215:
216: BEGIN
217: -- Initialise API return status to success
218: l_seed_qual_out_rec.return_status := FND_API.G_RET_STS_SUCCESS;
219:
220: -- initialise local seeded qualifier record
221: l_seed_qual_rec := p_seed_qual_rec;
222:

Line 239: l_seed_qual_out_rec.return_status := FND_API.G_RET_STS_SUCCESS;

235: );
236:
237:
238: l_seed_qual_out_rec.seeded_qual_id := l_seed_qual_rec.seeded_qual_id;
239: l_seed_qual_out_rec.return_status := FND_API.G_RET_STS_SUCCESS;
240:
241: -- save id and status
242: x_seed_qual_out_rec := l_seed_qual_out_rec;
243:

Line 261: l_return_status := FND_API.G_RET_STS_SUCCESS;

257:
258: BEGIN
259:
260: -- Initialise API return status to success
261: l_return_status := FND_API.G_RET_STS_SUCCESS;
262:
263: -- Call DELETE table handler
264: JTF_SEEDED_QUAL_PKG.DELETE_ROW ( X_SEEDED_QUAL_ID => p_seeded_qual_id);
265:

Line 365: IF (l_qual_usgs_rec.enabled_flag = FND_API.G_MISS_CHAR) THEN

361: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := p_qual_usgs_rec;
362:
363: BEGIN
364:
365: IF (l_qual_usgs_rec.enabled_flag = FND_API.G_MISS_CHAR) THEN
366: l_qual_usgs_rec.enabled_flag := 'N';
367: END IF;
368:
369:

Line 372: IF (l_qual_usgs_rec.qual_col1_datatype = FND_API.G_MISS_CHAR) THEN

368:
369:
370:
371:
372: IF (l_qual_usgs_rec.qual_col1_datatype = FND_API.G_MISS_CHAR) THEN
373: l_qual_usgs_rec.qual_col1_datatype := get_column_datatype( l_qual_usgs_rec.qual_col1,
374: l_qual_usgs_rec.qual_col1_table);
375: END IF;
376:

Line 377: IF (l_qual_usgs_rec.prim_int_cde_col_datatype = FND_API.G_MISS_CHAR) THEN

373: l_qual_usgs_rec.qual_col1_datatype := get_column_datatype( l_qual_usgs_rec.qual_col1,
374: l_qual_usgs_rec.qual_col1_table);
375: END IF;
376:
377: IF (l_qual_usgs_rec.prim_int_cde_col_datatype = FND_API.G_MISS_CHAR) THEN
378:
379: IF (l_qual_usgs_rec.prim_int_cde_col <> FND_API.G_MISS_CHAR
380: AND l_qual_usgs_rec.int_cde_col_table <> FND_API.G_MISS_CHAR) THEN
381:

Line 379: IF (l_qual_usgs_rec.prim_int_cde_col <> FND_API.G_MISS_CHAR

375: END IF;
376:
377: IF (l_qual_usgs_rec.prim_int_cde_col_datatype = FND_API.G_MISS_CHAR) THEN
378:
379: IF (l_qual_usgs_rec.prim_int_cde_col <> FND_API.G_MISS_CHAR
380: AND l_qual_usgs_rec.int_cde_col_table <> FND_API.G_MISS_CHAR) THEN
381:
382: l_qual_usgs_rec.prim_int_cde_col_datatype := get_column_datatype( l_qual_usgs_rec.prim_int_cde_col,
383: l_qual_usgs_rec.int_cde_col_table);

Line 380: AND l_qual_usgs_rec.int_cde_col_table <> FND_API.G_MISS_CHAR) THEN

376:
377: IF (l_qual_usgs_rec.prim_int_cde_col_datatype = FND_API.G_MISS_CHAR) THEN
378:
379: IF (l_qual_usgs_rec.prim_int_cde_col <> FND_API.G_MISS_CHAR
380: AND l_qual_usgs_rec.int_cde_col_table <> FND_API.G_MISS_CHAR) THEN
381:
382: l_qual_usgs_rec.prim_int_cde_col_datatype := get_column_datatype( l_qual_usgs_rec.prim_int_cde_col,
383: l_qual_usgs_rec.int_cde_col_table);
384: END IF;

Line 388: IF (l_qual_usgs_rec.sec_int_cde_col_datatype = FND_API.G_MISS_CHAR) THEN

384: END IF;
385:
386: END IF;
387:
388: IF (l_qual_usgs_rec.sec_int_cde_col_datatype = FND_API.G_MISS_CHAR) THEN
389:
390: IF (l_qual_usgs_rec.sec_int_cde_col <> FND_API.G_MISS_CHAR
391: AND l_qual_usgs_rec.int_cde_col_table <> FND_API.G_MISS_CHAR) THEN
392:

Line 390: IF (l_qual_usgs_rec.sec_int_cde_col <> FND_API.G_MISS_CHAR

386: END IF;
387:
388: IF (l_qual_usgs_rec.sec_int_cde_col_datatype = FND_API.G_MISS_CHAR) THEN
389:
390: IF (l_qual_usgs_rec.sec_int_cde_col <> FND_API.G_MISS_CHAR
391: AND l_qual_usgs_rec.int_cde_col_table <> FND_API.G_MISS_CHAR) THEN
392:
393: l_qual_usgs_rec.sec_int_cde_col_datatype := get_column_datatype( l_qual_usgs_rec.sec_int_cde_col,
394: l_qual_usgs_rec.int_cde_col_table);

Line 391: AND l_qual_usgs_rec.int_cde_col_table <> FND_API.G_MISS_CHAR) THEN

387:
388: IF (l_qual_usgs_rec.sec_int_cde_col_datatype = FND_API.G_MISS_CHAR) THEN
389:
390: IF (l_qual_usgs_rec.sec_int_cde_col <> FND_API.G_MISS_CHAR
391: AND l_qual_usgs_rec.int_cde_col_table <> FND_API.G_MISS_CHAR) THEN
392:
393: l_qual_usgs_rec.sec_int_cde_col_datatype := get_column_datatype( l_qual_usgs_rec.sec_int_cde_col,
394: l_qual_usgs_rec.int_cde_col_table);
395: END IF;

Line 416: p_qual_usgs_rec.qual_type_usg_id = FND_API.G_MISS_NUM OR

412: IS
413: BEGIN
414:
415: IF ( p_qual_usgs_rec.qual_type_usg_id IS NULL OR
416: p_qual_usgs_rec.qual_type_usg_id = FND_API.G_MISS_NUM OR
417: p_qual_usgs_rec.qual_col1 IS NULL OR
418: p_qual_usgs_rec.qual_col1 = FND_API.G_MISS_CHAR OR
419: p_qual_usgs_rec.qual_col1_alias IS NULL OR
420: p_qual_usgs_rec.qual_col1_alias = FND_API.G_MISS_CHAR OR

Line 418: p_qual_usgs_rec.qual_col1 = FND_API.G_MISS_CHAR OR

414:
415: IF ( p_qual_usgs_rec.qual_type_usg_id IS NULL OR
416: p_qual_usgs_rec.qual_type_usg_id = FND_API.G_MISS_NUM OR
417: p_qual_usgs_rec.qual_col1 IS NULL OR
418: p_qual_usgs_rec.qual_col1 = FND_API.G_MISS_CHAR OR
419: p_qual_usgs_rec.qual_col1_alias IS NULL OR
420: p_qual_usgs_rec.qual_col1_alias = FND_API.G_MISS_CHAR OR
421: p_qual_usgs_rec.qual_col1_datatype IS NULL OR
422: p_qual_usgs_rec.qual_col1_datatype = FND_API.G_MISS_CHAR OR

Line 420: p_qual_usgs_rec.qual_col1_alias = FND_API.G_MISS_CHAR OR

416: p_qual_usgs_rec.qual_type_usg_id = FND_API.G_MISS_NUM OR
417: p_qual_usgs_rec.qual_col1 IS NULL OR
418: p_qual_usgs_rec.qual_col1 = FND_API.G_MISS_CHAR OR
419: p_qual_usgs_rec.qual_col1_alias IS NULL OR
420: p_qual_usgs_rec.qual_col1_alias = FND_API.G_MISS_CHAR OR
421: p_qual_usgs_rec.qual_col1_datatype IS NULL OR
422: p_qual_usgs_rec.qual_col1_datatype = FND_API.G_MISS_CHAR OR
423: p_qual_usgs_rec.qual_col1_table IS NULL OR
424: p_qual_usgs_rec.qual_col1_table = FND_API.G_MISS_CHAR OR

Line 422: p_qual_usgs_rec.qual_col1_datatype = FND_API.G_MISS_CHAR OR

418: p_qual_usgs_rec.qual_col1 = FND_API.G_MISS_CHAR OR
419: p_qual_usgs_rec.qual_col1_alias IS NULL OR
420: p_qual_usgs_rec.qual_col1_alias = FND_API.G_MISS_CHAR OR
421: p_qual_usgs_rec.qual_col1_datatype IS NULL OR
422: p_qual_usgs_rec.qual_col1_datatype = FND_API.G_MISS_CHAR OR
423: p_qual_usgs_rec.qual_col1_table IS NULL OR
424: p_qual_usgs_rec.qual_col1_table = FND_API.G_MISS_CHAR OR
425: p_qual_usgs_rec.qual_col1_table_alias IS NULL OR
426: p_qual_usgs_rec.qual_col1_table_alias = FND_API.G_MISS_CHAR

Line 424: p_qual_usgs_rec.qual_col1_table = FND_API.G_MISS_CHAR OR

420: p_qual_usgs_rec.qual_col1_alias = FND_API.G_MISS_CHAR OR
421: p_qual_usgs_rec.qual_col1_datatype IS NULL OR
422: p_qual_usgs_rec.qual_col1_datatype = FND_API.G_MISS_CHAR OR
423: p_qual_usgs_rec.qual_col1_table IS NULL OR
424: p_qual_usgs_rec.qual_col1_table = FND_API.G_MISS_CHAR OR
425: p_qual_usgs_rec.qual_col1_table_alias IS NULL OR
426: p_qual_usgs_rec.qual_col1_table_alias = FND_API.G_MISS_CHAR
427: )
428: THEN

Line 426: p_qual_usgs_rec.qual_col1_table_alias = FND_API.G_MISS_CHAR

422: p_qual_usgs_rec.qual_col1_datatype = FND_API.G_MISS_CHAR OR
423: p_qual_usgs_rec.qual_col1_table IS NULL OR
424: p_qual_usgs_rec.qual_col1_table = FND_API.G_MISS_CHAR OR
425: p_qual_usgs_rec.qual_col1_table_alias IS NULL OR
426: p_qual_usgs_rec.qual_col1_table_alias = FND_API.G_MISS_CHAR
427: )
428: THEN
429: -- Debug message
430: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 439: RETURN FND_API.G_TRUE;

435: 'QUAL_COL1_TABLE, QUAL_COL1_TABLE_ALIAS');
436: FND_MSG_PUB.ADD;
437: END IF;
438:
439: RETURN FND_API.G_TRUE;
440: ELSE
441: RETURN FND_API.G_FALSE;
442: END IF;
443:

Line 441: RETURN FND_API.G_FALSE;

437: END IF;
438:
439: RETURN FND_API.G_TRUE;
440: ELSE
441: RETURN FND_API.G_FALSE;
442: END IF;
443:
444: END is_qual_usgs_rec_missing;
445:

Line 472: l_return_variable VARCHAR2(1) := FND_API.G_TRUE;

468: AND col.table_name = syn.table_name
469: AND col.column_name = UPPER(l_col_name);
470:
471: l_return_csr VARCHAR2(1);
472: l_return_variable VARCHAR2(1) := FND_API.G_TRUE;
473: l_apps_schema_name VARCHAR2(30);
474:
475: BEGIN
476:

Line 489: l_return_variable := FND_API.G_FALSE;

485: FETCH c_chk_table_exists INTO l_return_csr;
486:
487: IF c_chk_table_exists%NOTFOUND THEN
488:
489: l_return_variable := FND_API.G_FALSE;
490:
491: /* Debug message */
492: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
493: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Table dnot exist');

Line 512: l_return_variable := FND_API.G_FALSE;

508: FETCH c_chk_col_exists INTO l_return_csr;
509:
510: IF c_chk_col_exists%NOTFOUND THEN
511:
512: l_return_variable := FND_API.G_FALSE;
513:
514: /* Debug message */
515: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
516: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Column dnot exist');

Line 542: l_return_variable VARCHAR2(1) := FND_API.G_TRUE;

538: RETURN VARCHAR2
539: IS
540:
541: /* return varaible */
542: l_return_variable VARCHAR2(1) := FND_API.G_TRUE;
543:
544: /* local scratch record */
545: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type;
546:

Line 555: , 'FND_LOOKUPS') = FND_API.G_FALSE) THEN

551: l_qual_usgs_rec := p_qual_usgs_rec;
552:
553: IF ( JTF_CTM_UTILITY_PVT.lookup_code_is_valid ( l_qual_usgs_rec.seeded_flag
554: , 'FLAG'
555: , 'FND_LOOKUPS') = FND_API.G_FALSE) THEN
556: l_return_variable := FND_API.G_FALSE;
557: l_qual_usgs_rec.seeded_flag := 'N';
558: END IF;
559:

Line 556: l_return_variable := FND_API.G_FALSE;

552:
553: IF ( JTF_CTM_UTILITY_PVT.lookup_code_is_valid ( l_qual_usgs_rec.seeded_flag
554: , 'FLAG'
555: , 'FND_LOOKUPS') = FND_API.G_FALSE) THEN
556: l_return_variable := FND_API.G_FALSE;
557: l_qual_usgs_rec.seeded_flag := 'N';
558: END IF;
559:
560: IF ( JTF_CTM_UTILITY_PVT.lookup_code_is_valid ( l_qual_usgs_rec.display_type

Line 562: , 'FND_LOOKUPS') = FND_API.G_FALSE) THEN

558: END IF;
559:
560: IF ( JTF_CTM_UTILITY_PVT.lookup_code_is_valid ( l_qual_usgs_rec.display_type
561: , 'DISPLAY_TYPE'
562: , 'FND_LOOKUPS') = FND_API.G_FALSE) THEN
563: l_return_variable := FND_API.G_FALSE;
564: l_qual_usgs_rec.display_type := 'STANDARD';
565: END IF;
566:

Line 563: l_return_variable := FND_API.G_FALSE;

559:
560: IF ( JTF_CTM_UTILITY_PVT.lookup_code_is_valid ( l_qual_usgs_rec.display_type
561: , 'DISPLAY_TYPE'
562: , 'FND_LOOKUPS') = FND_API.G_FALSE) THEN
563: l_return_variable := FND_API.G_FALSE;
564: l_qual_usgs_rec.display_type := 'STANDARD';
565: END IF;
566:
567: RETURN l_return_variable;

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

589:
590: l_return_csr VARCHAR2(1);
591:
592: -- Initialise return status
593: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
594:
595: -- Initialise local Qualifer Usages record
596: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := p_qual_usgs_rec;
597:

Line 606: l_qual_usgs_rec.qual_usg_id = FND_API.G_MISS_NUM) ) THEN

602:
603: /* If record is being updated, check that primary key is not null */
604: IF ( (p_validation_mode = JTF_CTM_UTILITY_PVT.G_UPDATE) AND
605: ( l_qual_usgs_rec.qual_usg_id IS NULL OR
606: l_qual_usgs_rec.qual_usg_id = FND_API.G_MISS_NUM) ) THEN
607:
608: l_return_status := FND_API.G_RET_STS_ERROR;
609:
610: END IF;

Line 608: l_return_status := FND_API.G_RET_STS_ERROR;

604: IF ( (p_validation_mode = JTF_CTM_UTILITY_PVT.G_UPDATE) AND
605: ( l_qual_usgs_rec.qual_usg_id IS NULL OR
606: l_qual_usgs_rec.qual_usg_id = FND_API.G_MISS_NUM) ) THEN
607:
608: l_return_status := FND_API.G_RET_STS_ERROR;
609:
610: END IF;
611:
612:

Line 616: IF (is_qual_usgs_rec_missing (l_qual_usgs_rec) = FND_API.G_TRUE) THEN

612:
613: -- IF ( p_validation_level >= JTF_CTM_UTILITY_PVT.G_VALID_LEVEL_RECORD ) THEN
614:
615: /* Check that all mandatory items exist in record */
616: IF (is_qual_usgs_rec_missing (l_qual_usgs_rec) = FND_API.G_TRUE) THEN
617: l_return_status := FND_API.G_RET_STS_ERROR;
618: END IF;
619:
620:

Line 617: l_return_status := FND_API.G_RET_STS_ERROR;

613: -- IF ( p_validation_level >= JTF_CTM_UTILITY_PVT.G_VALID_LEVEL_RECORD ) THEN
614:
615: /* Check that all mandatory items exist in record */
616: IF (is_qual_usgs_rec_missing (l_qual_usgs_rec) = FND_API.G_TRUE) THEN
617: l_return_status := FND_API.G_RET_STS_ERROR;
618: END IF;
619:
620:
621:

Line 627: l_qual_usgs_rec.seeded_qual_id <> FND_API.G_MISS_NUM ) THEN

623: -- IF ( p_validation_level >= JTF_CTM_UTILITY_PVT.G_VALID_LEVEL_INTER_ENTITY ) THEN
624:
625: /* check FK reference to JTF_SEEDED_QUAL */
626: IF ( l_qual_usgs_rec.seeded_qual_id IS NOT NULL AND
627: l_qual_usgs_rec.seeded_qual_id <> FND_API.G_MISS_NUM ) THEN
628:
629: IF ( JTF_CTM_UTILITY_PVT.fk_id_is_valid (
630: l_qual_usgs_rec.seeded_qual_id,
631: 'SEEDED_QUAL_ID',

Line 632: 'JTF_SEEDED_QUAL') = FND_API.G_FALSE)

628:
629: IF ( JTF_CTM_UTILITY_PVT.fk_id_is_valid (
630: l_qual_usgs_rec.seeded_qual_id,
631: 'SEEDED_QUAL_ID',
632: 'JTF_SEEDED_QUAL') = FND_API.G_FALSE)
633: THEN
634: l_return_status := FND_API.G_RET_STS_ERROR;
635: END IF;
636: END IF;

Line 634: l_return_status := FND_API.G_RET_STS_ERROR;

630: l_qual_usgs_rec.seeded_qual_id,
631: 'SEEDED_QUAL_ID',
632: 'JTF_SEEDED_QUAL') = FND_API.G_FALSE)
633: THEN
634: l_return_status := FND_API.G_RET_STS_ERROR;
635: END IF;
636: END IF;
637:
638:

Line 645: l_qual_usgs_rec.qual_type_usg_id <> FND_API.G_MISS_NUM ) THEN

641: -- IF ( p_validation_level >= JTF_CTM_UTILITY_PVT.G_VALID_LEVEL_INTER_ENTITY ) THEN
642:
643: /* check FK reference to JTF_QUAL_TYPE_USGS */
644: IF ( l_qual_usgs_rec.qual_type_usg_id IS NOT NULL AND
645: l_qual_usgs_rec.qual_type_usg_id <> FND_API.G_MISS_NUM ) THEN
646:
647: IF ( JTF_CTM_UTILITY_PVT.fk_id_is_valid (
648: l_qual_usgs_rec.qual_type_usg_id,
649: 'QUAL_TYPE_USG_ID',

Line 650: 'JTF_QUAL_TYPE_USGS') = FND_API.G_FALSE)

646:
647: IF ( JTF_CTM_UTILITY_PVT.fk_id_is_valid (
648: l_qual_usgs_rec.qual_type_usg_id,
649: 'QUAL_TYPE_USG_ID',
650: 'JTF_QUAL_TYPE_USGS') = FND_API.G_FALSE)
651: THEN
652: l_return_status := FND_API.G_RET_STS_ERROR;
653: END IF;
654: END IF;

Line 652: l_return_status := FND_API.G_RET_STS_ERROR;

648: l_qual_usgs_rec.qual_type_usg_id,
649: 'QUAL_TYPE_USG_ID',
650: 'JTF_QUAL_TYPE_USGS') = FND_API.G_FALSE)
651: THEN
652: l_return_status := FND_API.G_RET_STS_ERROR;
653: END IF;
654: END IF;
655:
656:

Line 663: l_qual_usgs_rec.seeded_qual_id <> FND_API.G_MISS_NUM AND

659: IF (p_validation_mode = JTF_CTM_UTILITY_PVT.G_CREATE) THEN
660:
661: /* check that Unique Key constraint not violated */
662: IF ( l_qual_usgs_rec.seeded_qual_id IS NOT NULL AND
663: l_qual_usgs_rec.seeded_qual_id <> FND_API.G_MISS_NUM AND
664: l_qual_usgs_rec.qual_type_usg_id IS NOT NULL AND
665: l_qual_usgs_rec.qual_type_usg_id <> FND_API.G_MISS_NUM )THEN
666:
667: /* check if rec already exists */

Line 665: l_qual_usgs_rec.qual_type_usg_id <> FND_API.G_MISS_NUM )THEN

661: /* check that Unique Key constraint not violated */
662: IF ( l_qual_usgs_rec.seeded_qual_id IS NOT NULL AND
663: l_qual_usgs_rec.seeded_qual_id <> FND_API.G_MISS_NUM AND
664: l_qual_usgs_rec.qual_type_usg_id IS NOT NULL AND
665: l_qual_usgs_rec.qual_type_usg_id <> FND_API.G_MISS_NUM )THEN
666:
667: /* check if rec already exists */
668: OPEN c_chk_uk_violation ( l_qual_usgs_rec.seeded_qual_id
669: , l_qual_usgs_rec.qual_type_usg_id);

Line 674: l_return_status := FND_API.G_RET_STS_ERROR;

670: FETCH c_chk_uk_violation INTO l_return_csr;
671:
672: IF c_chk_uk_violation%FOUND THEN
673:
674: l_return_status := FND_API.G_RET_STS_ERROR;
675:
676: /* Debug message */
677: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
678: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:UK Violation');

Line 697: l_qual_usgs_rec.qual_col1_table <> FND_API.G_MISS_CHAR AND

693: -- IF ( p_validation_level >= JTF_CTM_UTILITY_PVT.G_VALID_LEVEL_RECORD ) THEN
694:
695: /* check qualifier column and table exists */
696: IF ( l_qual_usgs_rec.qual_col1_table IS NOT NULL AND
697: l_qual_usgs_rec.qual_col1_table <> FND_API.G_MISS_CHAR AND
698: l_qual_usgs_rec.qual_col1 IS NOT NULL AND
699: l_qual_usgs_rec.qual_col1 <> FND_API.G_MISS_CHAR ) THEN
700:
701: /* if qualifier has been defined as a special function, do

Line 699: l_qual_usgs_rec.qual_col1 <> FND_API.G_MISS_CHAR ) THEN

695: /* check qualifier column and table exists */
696: IF ( l_qual_usgs_rec.qual_col1_table IS NOT NULL AND
697: l_qual_usgs_rec.qual_col1_table <> FND_API.G_MISS_CHAR AND
698: l_qual_usgs_rec.qual_col1 IS NOT NULL AND
699: l_qual_usgs_rec.qual_col1 <> FND_API.G_MISS_CHAR ) THEN
700:
701: /* if qualifier has been defined as a special function, do
702: ** not check if table and column definitions exist
703: */

Line 707: l_qual_usgs_rec.qual_col1) = FND_API.G_FALSE)

703: */
704: IF (l_qual_usgs_rec.qual_col1_datatype <> 'SPECIAL_FUNCTION') THEN
705:
706: IF (table_col_is_valid ( l_qual_usgs_rec.qual_col1_table,
707: l_qual_usgs_rec.qual_col1) = FND_API.G_FALSE)
708: THEN
709: l_return_status := FND_API.G_RET_STS_ERROR;
710: END IF;
711:

Line 709: l_return_status := FND_API.G_RET_STS_ERROR;

705:
706: IF (table_col_is_valid ( l_qual_usgs_rec.qual_col1_table,
707: l_qual_usgs_rec.qual_col1) = FND_API.G_FALSE)
708: THEN
709: l_return_status := FND_API.G_RET_STS_ERROR;
710: END IF;
711:
712: END IF;
713: END IF;

Line 722: l_qual_usgs_rec.int_cde_col_table <> FND_API.G_MISS_CHAR AND

718: -- IF ( p_validation_level >= JTF_CTM_UTILITY_PVT.G_VALID_LEVEL_RECORD ) THEN
719:
720: /* check qualifier column and table exists */
721: IF ( l_qual_usgs_rec.int_cde_col_table IS NOT NULL AND
722: l_qual_usgs_rec.int_cde_col_table <> FND_API.G_MISS_CHAR AND
723: l_qual_usgs_rec.prim_int_cde_col IS NOT NULL AND
724: l_qual_usgs_rec.prim_int_cde_col <> FND_API.G_MISS_CHAR ) THEN
725:
726: IF (table_col_is_valid ( l_qual_usgs_rec.int_cde_col_table,

Line 724: l_qual_usgs_rec.prim_int_cde_col <> FND_API.G_MISS_CHAR ) THEN

720: /* check qualifier column and table exists */
721: IF ( l_qual_usgs_rec.int_cde_col_table IS NOT NULL AND
722: l_qual_usgs_rec.int_cde_col_table <> FND_API.G_MISS_CHAR AND
723: l_qual_usgs_rec.prim_int_cde_col IS NOT NULL AND
724: l_qual_usgs_rec.prim_int_cde_col <> FND_API.G_MISS_CHAR ) THEN
725:
726: IF (table_col_is_valid ( l_qual_usgs_rec.int_cde_col_table,
727: l_qual_usgs_rec.prim_int_cde_col) = FND_API.G_FALSE)
728: THEN

Line 727: l_qual_usgs_rec.prim_int_cde_col) = FND_API.G_FALSE)

723: l_qual_usgs_rec.prim_int_cde_col IS NOT NULL AND
724: l_qual_usgs_rec.prim_int_cde_col <> FND_API.G_MISS_CHAR ) THEN
725:
726: IF (table_col_is_valid ( l_qual_usgs_rec.int_cde_col_table,
727: l_qual_usgs_rec.prim_int_cde_col) = FND_API.G_FALSE)
728: THEN
729:
730: l_return_status := FND_API.G_RET_STS_ERROR;
731: END IF;

Line 730: l_return_status := FND_API.G_RET_STS_ERROR;

726: IF (table_col_is_valid ( l_qual_usgs_rec.int_cde_col_table,
727: l_qual_usgs_rec.prim_int_cde_col) = FND_API.G_FALSE)
728: THEN
729:
730: l_return_status := FND_API.G_RET_STS_ERROR;
731: END IF;
732:
733: END IF;
734:

Line 742: l_qual_usgs_rec.int_cde_col_table <> FND_API.G_MISS_CHAR AND

738: -- IF ( p_validation_level >= JTF_CTM_UTILITY_PVT.G_VALID_LEVEL_RECORD ) THEN
739:
740: /* check qualifier column and table exists */
741: IF ( l_qual_usgs_rec.int_cde_col_table IS NOT NULL AND
742: l_qual_usgs_rec.int_cde_col_table <> FND_API.G_MISS_CHAR AND
743: l_qual_usgs_rec.sec_int_cde_col IS NOT NULL AND
744: l_qual_usgs_rec.sec_int_cde_col <> FND_API.G_MISS_CHAR ) THEN
745:
746: IF (table_col_is_valid ( l_qual_usgs_rec.int_cde_col_table,

Line 744: l_qual_usgs_rec.sec_int_cde_col <> FND_API.G_MISS_CHAR ) THEN

740: /* check qualifier column and table exists */
741: IF ( l_qual_usgs_rec.int_cde_col_table IS NOT NULL AND
742: l_qual_usgs_rec.int_cde_col_table <> FND_API.G_MISS_CHAR AND
743: l_qual_usgs_rec.sec_int_cde_col IS NOT NULL AND
744: l_qual_usgs_rec.sec_int_cde_col <> FND_API.G_MISS_CHAR ) THEN
745:
746: IF (table_col_is_valid ( l_qual_usgs_rec.int_cde_col_table,
747: l_qual_usgs_rec.sec_int_cde_col) = FND_API.G_FALSE)
748: THEN

Line 747: l_qual_usgs_rec.sec_int_cde_col) = FND_API.G_FALSE)

743: l_qual_usgs_rec.sec_int_cde_col IS NOT NULL AND
744: l_qual_usgs_rec.sec_int_cde_col <> FND_API.G_MISS_CHAR ) THEN
745:
746: IF (table_col_is_valid ( l_qual_usgs_rec.int_cde_col_table,
747: l_qual_usgs_rec.sec_int_cde_col) = FND_API.G_FALSE)
748: THEN
749:
750: l_return_status := FND_API.G_RET_STS_ERROR;
751: END IF;

Line 750: l_return_status := FND_API.G_RET_STS_ERROR;

746: IF (table_col_is_valid ( l_qual_usgs_rec.int_cde_col_table,
747: l_qual_usgs_rec.sec_int_cde_col) = FND_API.G_FALSE)
748: THEN
749:
750: l_return_status := FND_API.G_RET_STS_ERROR;
751: END IF;
752:
753: END IF;
754:

Line 784: l_qual_usgs_out_rec.return_status := FND_API.G_RET_STS_SUCCESS;

780:
781: l_qual_usgs_rec := p_qual_usgs_rec;
782:
783: -- Initialise API return status to success
784: l_qual_usgs_out_rec.return_status := FND_API.G_RET_STS_SUCCESS;
785:
786: -- convert id to null, so that next value of sequence will
787: -- be selected
788: IF (l_qual_usgs_rec.qual_usg_id = FND_API.G_MISS_NUM) THEN

Line 788: IF (l_qual_usgs_rec.qual_usg_id = FND_API.G_MISS_NUM) THEN

784: l_qual_usgs_out_rec.return_status := FND_API.G_RET_STS_SUCCESS;
785:
786: -- convert id to null, so that next value of sequence will
787: -- be selected
788: IF (l_qual_usgs_rec.qual_usg_id = FND_API.G_MISS_NUM) THEN
789:
790:
791: l_qual_usgs_rec.qual_usg_id := NULL;
792: END IF;

Line 848: l_qual_usgs_out_rec.return_status := FND_API.G_RET_STS_SUCCESS;

844: l_qual_usgs_out_rec.qual_usg_id := l_qual_usgs_rec.qual_usg_id;
845:
846:
847:
848: l_qual_usgs_out_rec.return_status := FND_API.G_RET_STS_SUCCESS;
849:
850: -- save id and status
851: x_qual_usgs_out_rec := l_qual_usgs_out_rec;
852:

Line 878: l_qual_usgs_out_rec.return_status := FND_API.G_RET_STS_SUCCESS;

874: -- initialize locak seeded qualifier record
875: l_qual_usgs_rec := p_qual_usgs_rec;
876:
877: -- Initialise API return status to success
878: l_qual_usgs_out_rec.return_status := FND_API.G_RET_STS_SUCCESS;
879:
880:
881: -- by eihsu, using similar method of problem resolution as in procedure Update_Seed_Qual_Record
882: -- (vinoo and jdochert)

Line 936: l_qual_usgs_out_rec.return_status := FND_API.G_RET_STS_SUCCESS;

932: X_use_in_lookup_flag => l_qual_usgs_rec.use_in_lookup_flag
933: );
934:
935: l_qual_usgs_out_rec.qual_usg_id := l_qual_usgs_rec.qual_usg_id;
936: l_qual_usgs_out_rec.return_status := FND_API.G_RET_STS_SUCCESS;
937:
938: -- save id and status
939: x_qual_usgs_out_rec := l_qual_usgs_out_rec;
940:

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

983: /* cursor return variable */
984: dummy_csr NUMBER;
985:
986: /* local return variable */
987: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
988:
989: /* local scratch variables */
990: l_seeded_qual_id NUMBER := p_seeded_qual_id;
991: l_qual_usg_id NUMBER := p_qual_usg_id;

Line 1007: l_return_status := FND_API.G_RET_STS_ERROR;

1003: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL1');
1004: FND_MSG_PUB.Add;
1005: END IF;
1006:
1007: l_return_status := FND_API.G_RET_STS_ERROR;
1008: END IF;
1009:
1010:
1011:

Line 1025: l_return_status := FND_API.G_RET_STS_ERROR;

1021: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL2');
1022: FND_MSG_PUB.Add;
1023: END IF;
1024:
1025: l_return_status := FND_API.G_RET_STS_ERROR;
1026: END IF;
1027:
1028: OPEN c_chk_terr ( l_qual_usg_id );
1029:

Line 1042: l_return_status := FND_API.G_RET_STS_ERROR;

1038: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL3');
1039: FND_MSG_PUB.Add;
1040: END IF;
1041:
1042: l_return_status := FND_API.G_RET_STS_ERROR;
1043: END IF;
1044:
1045:
1046:

Line 1061: l_return_status := FND_API.G_RET_STS_ERROR;

1057: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL4');
1058: FND_MSG_PUB.Add;
1059: END IF;
1060:
1061: l_return_status := FND_API.G_RET_STS_ERROR;
1062: END IF;
1063:
1064:
1065:

Line 1086: l_return_status := FND_API.G_RET_STS_SUCCESS;

1082: BEGIN
1083:
1084:
1085: -- Initialise API return status to success
1086: l_return_status := FND_API.G_RET_STS_SUCCESS;
1087:
1088: -- Call UPDATE table handler
1089: JTF_QUAL_USGS_PKG.DELETE_ROW ( X_QUAL_USG_ID => p_qual_usg_id);
1090:

Line 1120: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE

1116: -- p_Qual_Usgs_Rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC
1117: --
1118: -- Optional
1119: -- Parameter Name Data Type Default
1120: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1121: -- P_Commit VARCHAR2 FND_API.G_FALSE
1122: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL
1123: --
1124: -- OUT :

Line 1121: -- P_Commit VARCHAR2 FND_API.G_FALSE

1117: --
1118: -- Optional
1119: -- Parameter Name Data Type Default
1120: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1121: -- P_Commit VARCHAR2 FND_API.G_FALSE
1122: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL
1123: --
1124: -- OUT :
1125: -- Parameter Name Data Type Default

Line 1122: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL

1118: -- Optional
1119: -- Parameter Name Data Type Default
1120: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1121: -- P_Commit VARCHAR2 FND_API.G_FALSE
1122: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL
1123: --
1124: -- OUT :
1125: -- Parameter Name Data Type Default
1126: -- x_Return_Status VARCHAR2(1)

Line 1140: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1136: -- End of Comments
1137: --
1138: PROCEDURE Create_Qualifier
1139: (p_api_version IN NUMBER,
1140: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1141: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1143: x_Return_Status OUT NOCOPY VARCHAR2,
1144: x_Msg_Count OUT NOCOPY NUMBER,

Line 1141: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

1137: --
1138: PROCEDURE Create_Qualifier
1139: (p_api_version IN NUMBER,
1140: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1141: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1143: x_Return_Status OUT NOCOPY VARCHAR2,
1144: x_Msg_Count OUT NOCOPY NUMBER,
1145: x_Msg_Data OUT NOCOPY VARCHAR2,

Line 1142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1138: PROCEDURE Create_Qualifier
1139: (p_api_version IN NUMBER,
1140: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1141: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1143: x_Return_Status OUT NOCOPY VARCHAR2,
1144: x_Msg_Count OUT NOCOPY NUMBER,
1145: x_Msg_Data OUT NOCOPY VARCHAR2,
1146: -- commented eihsu 11/04

Line 1172: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1168: -- Standard Start of API savepoint
1169: SAVEPOINT CREATE_QUALIFIER_PVT;
1170:
1171: -- Standard call to check for call compatability
1172: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1173: p_api_version,
1174: l_api_name,
1175: G_PKG_NAME)
1176: THEN

Line 1177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1173: p_api_version,
1174: l_api_name,
1175: G_PKG_NAME)
1176: THEN
1177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1178: END IF;
1179:
1180: -- Initialize message list if p_init_msg_list is set to TRUE.
1181: IF FND_API.to_Boolean( p_init_msg_list )

Line 1181: IF FND_API.to_Boolean( p_init_msg_list )

1177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1178: END IF;
1179:
1180: -- Initialize message list if p_init_msg_list is set to TRUE.
1181: IF FND_API.to_Boolean( p_init_msg_list )
1182: THEN
1183: FND_MSG_PUB.initialize;
1184: END IF;
1185:

Line 1199: l_return_status := FND_API.G_RET_STS_SUCCESS;

1195: -- API BODY START
1196: -- ******************************************************************
1197:
1198: -- Initialize API return status to success
1199: l_return_status := FND_API.G_RET_STS_SUCCESS;
1200:
1201: -- Seeded Qualifier record doesn't have any default values, so
1202: -- just initialise local variable to value of variable passed in as
1203: -- a parameter to this procedure

Line 1215: RAISE FND_API.G_EXC_ERROR;

1211: check_qualifier_usage (l_qual_usgs_rec.qual_usg_id, l_qualifier_used);
1212: END IF;
1213: IF l_qualifier_used = 'TRUE' THEN
1214: -- qualifier being used and cannot be diabled
1215: RAISE FND_API.G_EXC_ERROR;
1216:
1217: END IF;
1218:
1219: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

Line 1219: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

1215: RAISE FND_API.G_EXC_ERROR;
1216:
1217: END IF;
1218:
1219: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
1220:
1221: -- Debug message
1222: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1223: FND_MESSAGE.Set_Name('JTF', 'PVTQUAL API:Validate Rec');

Line 1235: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1231: p_validation_level,
1232: l_return_status);
1233:
1234:
1235: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1236: RAISE FND_API.G_EXC_ERROR;
1237: END IF;
1238:
1239: -- validate the qualifier usage record

Line 1236: RAISE FND_API.G_EXC_ERROR;

1232: l_return_status);
1233:
1234:
1235: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1236: RAISE FND_API.G_EXC_ERROR;
1237: END IF;
1238:
1239: -- validate the qualifier usage record
1240: validate_qual_usgs_rec ( l_qual_usgs_rec,

Line 1245: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1241: JTF_CTM_UTILITY_PVT.G_CREATE,
1242: p_validation_level,
1243: l_return_status);
1244:
1245: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1246: RAISE FND_API.G_EXC_ERROR;
1247: END IF;
1248:
1249: END IF; -- End of Record Validation

Line 1246: RAISE FND_API.G_EXC_ERROR;

1242: p_validation_level,
1243: l_return_status);
1244:
1245: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1246: RAISE FND_API.G_EXC_ERROR;
1247: END IF;
1248:
1249: END IF; -- End of Record Validation
1250:

Line 1270: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1266:
1267:
1268: -- ' l_seeded_qual_id = '|| TO_CHAR(l_seed_qual_out_rec.seeded_qual_id));
1269:
1270: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1271: RAISE FND_API.G_EXC_ERROR;
1272: END IF;
1273:
1274:

Line 1271: RAISE FND_API.G_EXC_ERROR;

1267:
1268: -- ' l_seeded_qual_id = '|| TO_CHAR(l_seed_qual_out_rec.seeded_qual_id));
1269:
1270: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1271: RAISE FND_API.G_EXC_ERROR;
1272: END IF;
1273:
1274:
1275: -- Process Qualifier Usages Record

Line 1295: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1291:
1292: -- ' l_qual_usg_id = '|| TO_CHAR(l_qual_usgs_out_rec.qual_usg_id));
1293:
1294:
1295: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1296: RAISE FND_API.G_EXC_ERROR;
1297: END IF;
1298:
1299: -- save the returned seeded qualifer id, qualifier usage id, and status

Line 1296: RAISE FND_API.G_EXC_ERROR;

1292: -- ' l_qual_usg_id = '|| TO_CHAR(l_qual_usgs_out_rec.qual_usg_id));
1293:
1294:
1295: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1296: RAISE FND_API.G_EXC_ERROR;
1297: END IF;
1298:
1299: -- save the returned seeded qualifer id, qualifier usage id, and status
1300: x_seed_qual_rec.seeded_qual_id := l_seed_qual_out_rec.seeded_qual_id;

Line 1311: l_return_status = FND_API.G_RET_STS_SUCCESS

1307:
1308:
1309: -- Success Message
1310: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) AND
1311: l_return_status = FND_API.G_RET_STS_SUCCESS
1312: THEN
1313: FND_MESSAGE.Set_Name('JTF', 'API_SUCCESS');
1314: FND_MESSAGE.Set_Token('ROW', 'JTF_QUALIFIER', TRUE);
1315: FND_MSG_PUB.Add;

Line 1319: IF FND_API.To_Boolean ( p_commit )

1315: FND_MSG_PUB.Add;
1316: END IF;
1317:
1318: -- Standard check of p_commit.
1319: IF FND_API.To_Boolean ( p_commit )
1320: THEN
1321: COMMIT WORK;
1322: END IF;
1323:

Line 1339: WHEN FND_API.G_EXC_ERROR THEN

1335: );
1336:
1337: EXCEPTION
1338:
1339: WHEN FND_API.G_EXC_ERROR THEN
1340: ROLLBACK TO CREATE_QUALIFIER_PVT;
1341: x_return_status := FND_API.G_RET_STS_ERROR ;
1342:
1343: FND_MSG_PUB.Count_And_Get

Line 1341: x_return_status := FND_API.G_RET_STS_ERROR ;

1337: EXCEPTION
1338:
1339: WHEN FND_API.G_EXC_ERROR THEN
1340: ROLLBACK TO CREATE_QUALIFIER_PVT;
1341: x_return_status := FND_API.G_RET_STS_ERROR ;
1342:
1343: FND_MSG_PUB.Count_And_Get
1344: ( p_count => x_msg_count,
1345: p_data => x_msg_data

Line 1349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1345: p_data => x_msg_data
1346: );
1347:
1348:
1349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1350: ROLLBACK TO CREATE_QUALIFIER_PVT;
1351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1352:
1353: FND_MSG_PUB.Count_And_Get

Line 1351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1347:
1348:
1349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1350: ROLLBACK TO CREATE_QUALIFIER_PVT;
1351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1352:
1353: FND_MSG_PUB.Count_And_Get
1354: ( p_count => x_msg_count,
1355: p_data => x_msg_data

Line 1361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1357:
1358:
1359: WHEN OTHERS THEN
1360: ROLLBACK TO CREATE_QUALIFIER_PVT;
1361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1362:
1363: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1364: THEN
1365: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);

Line 1395: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE

1391: -- p_Qual_Usgs_Rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC
1392: --
1393: -- Optional
1394: -- Parameter Name Data Type Default
1395: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1396: -- P_Commit VARCHAR2 FND_API.G_FALSE
1397: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL
1398: --
1399: -- OUT :

Line 1396: -- P_Commit VARCHAR2 FND_API.G_FALSE

1392: --
1393: -- Optional
1394: -- Parameter Name Data Type Default
1395: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1396: -- P_Commit VARCHAR2 FND_API.G_FALSE
1397: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL
1398: --
1399: -- OUT :
1400: -- Parameter Name Data Type Default

Line 1397: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL

1393: -- Optional
1394: -- Parameter Name Data Type Default
1395: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1396: -- P_Commit VARCHAR2 FND_API.G_FALSE
1397: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL
1398: --
1399: -- OUT :
1400: -- Parameter Name Data Type Default
1401: -- x_Return_Status VARCHAR2(1)

Line 1415: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1411: -- End of Comments
1412: --
1413: PROCEDURE Update_Qualifier
1414: (p_api_version IN NUMBER,
1415: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1416: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1417: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1418: x_Return_Status OUT NOCOPY VARCHAR2,
1419: x_Msg_Count OUT NOCOPY NUMBER,

Line 1416: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

1412: --
1413: PROCEDURE Update_Qualifier
1414: (p_api_version IN NUMBER,
1415: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1416: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1417: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1418: x_Return_Status OUT NOCOPY VARCHAR2,
1419: x_Msg_Count OUT NOCOPY NUMBER,
1420: x_Msg_Data OUT NOCOPY VARCHAR2,

Line 1417: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1413: PROCEDURE Update_Qualifier
1414: (p_api_version IN NUMBER,
1415: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1416: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1417: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1418: x_Return_Status OUT NOCOPY VARCHAR2,
1419: x_Msg_Count OUT NOCOPY NUMBER,
1420: x_Msg_Data OUT NOCOPY VARCHAR2,
1421: p_Seed_Qual_Rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC,

Line 1445: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1441: -- Standard Start of API savepoint
1442: SAVEPOINT UPDATE_QUALIFIER_PVT;
1443:
1444: -- Standard call to check for call compatability
1445: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1446: p_api_version,
1447: l_api_name,
1448: G_PKG_NAME)
1449: THEN

Line 1450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1446: p_api_version,
1447: l_api_name,
1448: G_PKG_NAME)
1449: THEN
1450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1451: END IF;
1452:
1453: -- Initialize message list if p_init_msg_list is set to TRUE.
1454: IF FND_API.to_Boolean( p_init_msg_list )

Line 1454: IF FND_API.to_Boolean( p_init_msg_list )

1450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1451: END IF;
1452:
1453: -- Initialize message list if p_init_msg_list is set to TRUE.
1454: IF FND_API.to_Boolean( p_init_msg_list )
1455: THEN
1456: FND_MSG_PUB.initialize;
1457: END IF;
1458:

Line 1472: l_return_status := FND_API.G_RET_STS_SUCCESS;

1468: -- API BODY START
1469: -- ******************************************************************
1470:
1471: -- Initialize API return status to success
1472: l_return_status := FND_API.G_RET_STS_SUCCESS;
1473:
1474: -- Seeded Qualifier record doesn't have any default values, so
1475: -- just initialise local variable to value of variable passed in as
1476: -- a parameter to this procedure

Line 1484: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

1480: -- Converts missing items' values to default values in Qualifier Usages record
1481: convert_miss_qual_usgs_rec (p_qual_usgs_rec, l_qual_usgs_rec);
1482:
1483:
1484: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
1485:
1486: -- Debug message
1487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1488: FND_MESSAGE.Set_Name('JTF', 'PVT QUAL API: Valdte Record');

Line 1499: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1495: p_validation_level,
1496: l_return_status);
1497:
1498:
1499: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1500: RAISE FND_API.G_EXC_ERROR;
1501: END IF;
1502:
1503:

Line 1500: RAISE FND_API.G_EXC_ERROR;

1496: l_return_status);
1497:
1498:
1499: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1500: RAISE FND_API.G_EXC_ERROR;
1501: END IF;
1502:
1503:
1504:

Line 1514: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1510: l_return_status);
1511:
1512:
1513:
1514: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1515: RAISE FND_API.G_EXC_ERROR;
1516: END IF;
1517:
1518:

Line 1515: RAISE FND_API.G_EXC_ERROR;

1511:
1512:
1513:
1514: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1515: RAISE FND_API.G_EXC_ERROR;
1516: END IF;
1517:
1518:
1519:

Line 1538: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1534: l_seed_qual_out_rec);
1535: l_return_status := l_seed_qual_out_rec.return_status;
1536:
1537:
1538: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1539: RAISE FND_API.G_EXC_ERROR;
1540: END IF;
1541:
1542:

Line 1539: RAISE FND_API.G_EXC_ERROR;

1535: l_return_status := l_seed_qual_out_rec.return_status;
1536:
1537:
1538: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1539: RAISE FND_API.G_EXC_ERROR;
1540: END IF;
1541:
1542:
1543: -- Process Qualifier Usages Record

Line 1557: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1553: l_qual_usgs_out_rec);
1554:
1555: l_return_status := l_qual_usgs_out_rec.return_status;
1556:
1557: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1558: RAISE FND_API.G_EXC_ERROR;
1559: END IF;
1560:
1561: -- save the returned seeded qualifer id, qualifier usage id, and status

Line 1558: RAISE FND_API.G_EXC_ERROR;

1554:
1555: l_return_status := l_qual_usgs_out_rec.return_status;
1556:
1557: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1558: RAISE FND_API.G_EXC_ERROR;
1559: END IF;
1560:
1561: -- save the returned seeded qualifer id, qualifier usage id, and status
1562: x_seed_qual_rec.seeded_qual_id := l_seed_qual_out_rec.seeded_qual_id;

Line 1573: l_return_status = FND_API.G_RET_STS_SUCCESS

1569:
1570:
1571: -- Success Message
1572: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) AND
1573: l_return_status = FND_API.G_RET_STS_SUCCESS
1574: THEN
1575: FND_MESSAGE.Set_Name('JTF', 'API_SUCCESS');
1576: FND_MESSAGE.Set_Token('ROW', 'JTF_QUALIFIER', TRUE);
1577: FND_MSG_PUB.Add;

Line 1583: IF FND_API.To_Boolean ( p_commit )

1579:
1580:
1581:
1582: -- Standard check of p_commit.
1583: IF FND_API.To_Boolean ( p_commit )
1584: THEN
1585: COMMIT WORK;
1586: END IF;
1587:

Line 1603: WHEN FND_API.G_EXC_ERROR THEN

1599: );
1600:
1601: EXCEPTION
1602:
1603: WHEN FND_API.G_EXC_ERROR THEN
1604: ROLLBACK TO UPDATE_QUALIFIER_PVT;
1605: x_return_status := FND_API.G_RET_STS_ERROR ;
1606:
1607: FND_MSG_PUB.Count_And_Get

Line 1605: x_return_status := FND_API.G_RET_STS_ERROR ;

1601: EXCEPTION
1602:
1603: WHEN FND_API.G_EXC_ERROR THEN
1604: ROLLBACK TO UPDATE_QUALIFIER_PVT;
1605: x_return_status := FND_API.G_RET_STS_ERROR ;
1606:
1607: FND_MSG_PUB.Count_And_Get
1608: ( p_count => x_msg_count,
1609: p_data => x_msg_data

Line 1613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1609: p_data => x_msg_data
1610: );
1611:
1612:
1613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1614: ROLLBACK TO UPDATE_QUALIFIER_PVT;
1615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1616:
1617: FND_MSG_PUB.Count_And_Get

Line 1615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1611:
1612:
1613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1614: ROLLBACK TO UPDATE_QUALIFIER_PVT;
1615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1616:
1617: FND_MSG_PUB.Count_And_Get
1618: ( p_count => x_msg_count,
1619: p_data => x_msg_data

Line 1625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1621:
1622:
1623: WHEN OTHERS THEN
1624: ROLLBACK TO UPDATE_QUALIFIER_PVT;
1625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1626:
1627: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1628: THEN
1629: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);

Line 1654: -- p_Seeded_Qual_Id NUMBER FND_API.G_MISS_NUM

1650: -- IN :
1651: -- Required
1652: -- Parameter Name Data Type Default
1653: -- p_api_version NUMBER
1654: -- p_Seeded_Qual_Id NUMBER FND_API.G_MISS_NUM
1655: -- p_Qual_Usgs_Id NUMBER FND_API.G_MISS_NUM
1656: --
1657: -- Optional
1658: -- Parameter Name Data Type Default

Line 1655: -- p_Qual_Usgs_Id NUMBER FND_API.G_MISS_NUM

1651: -- Required
1652: -- Parameter Name Data Type Default
1653: -- p_api_version NUMBER
1654: -- p_Seeded_Qual_Id NUMBER FND_API.G_MISS_NUM
1655: -- p_Qual_Usgs_Id NUMBER FND_API.G_MISS_NUM
1656: --
1657: -- Optional
1658: -- Parameter Name Data Type Default
1659: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE

Line 1659: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE

1655: -- p_Qual_Usgs_Id NUMBER FND_API.G_MISS_NUM
1656: --
1657: -- Optional
1658: -- Parameter Name Data Type Default
1659: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1660: -- P_Commit VARCHAR2 FND_API.G_FALSE
1661: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL
1662: --
1663: -- OUT :

Line 1660: -- P_Commit VARCHAR2 FND_API.G_FALSE

1656: --
1657: -- Optional
1658: -- Parameter Name Data Type Default
1659: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1660: -- P_Commit VARCHAR2 FND_API.G_FALSE
1661: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL
1662: --
1663: -- OUT :
1664: -- Parameter Name Data Type Default

Line 1661: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL

1657: -- Optional
1658: -- Parameter Name Data Type Default
1659: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1660: -- P_Commit VARCHAR2 FND_API.G_FALSE
1661: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL
1662: --
1663: -- OUT :
1664: -- Parameter Name Data Type Default
1665: -- x_Return_Status VARCHAR2(1)

Line 1677: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1673: -- End of Comments
1674: --
1675: PROCEDURE Delete_Qualifier
1676: (p_api_version IN NUMBER,
1677: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1678: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1679: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1680: x_Return_Status OUT NOCOPY VARCHAR2,
1681: x_Msg_Count OUT NOCOPY NUMBER,

Line 1678: p_Commit IN VARCHAR2 := FND_API.G_FALSE,

1674: --
1675: PROCEDURE Delete_Qualifier
1676: (p_api_version IN NUMBER,
1677: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1678: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1679: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1680: x_Return_Status OUT NOCOPY VARCHAR2,
1681: x_Msg_Count OUT NOCOPY NUMBER,
1682: x_Msg_Data OUT NOCOPY VARCHAR2,

Line 1679: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1675: PROCEDURE Delete_Qualifier
1676: (p_api_version IN NUMBER,
1677: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1678: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1679: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1680: x_Return_Status OUT NOCOPY VARCHAR2,
1681: x_Msg_Count OUT NOCOPY NUMBER,
1682: x_Msg_Data OUT NOCOPY VARCHAR2,
1683: p_Seeded_Qual_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 1683: p_Seeded_Qual_Id IN NUMBER := FND_API.G_MISS_NUM,

1679: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1680: x_Return_Status OUT NOCOPY VARCHAR2,
1681: x_Msg_Count OUT NOCOPY NUMBER,
1682: x_Msg_Data OUT NOCOPY VARCHAR2,
1683: p_Seeded_Qual_Id IN NUMBER := FND_API.G_MISS_NUM,
1684: p_Qual_Usg_Id IN NUMBER := FND_API.G_MISS_NUM
1685: )
1686: IS
1687: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Qualifier';

Line 1684: p_Qual_Usg_Id IN NUMBER := FND_API.G_MISS_NUM

1680: x_Return_Status OUT NOCOPY VARCHAR2,
1681: x_Msg_Count OUT NOCOPY NUMBER,
1682: x_Msg_Data OUT NOCOPY VARCHAR2,
1683: p_Seeded_Qual_Id IN NUMBER := FND_API.G_MISS_NUM,
1684: p_Qual_Usg_Id IN NUMBER := FND_API.G_MISS_NUM
1685: )
1686: IS
1687: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Qualifier';
1688: l_api_version CONSTANT NUMBER := 1.0;

Line 1703: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1699: -- Standard Start of API savepoint
1700: SAVEPOINT DELETE_QUALIFIER_PVT;
1701:
1702: -- Standard call to check for call compatability
1703: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1704: p_api_version,
1705: l_api_name,
1706: G_PKG_NAME)
1707: THEN

Line 1708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1704: p_api_version,
1705: l_api_name,
1706: G_PKG_NAME)
1707: THEN
1708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1709: END IF;
1710:
1711:
1712: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1713: IF FND_API.to_Boolean( p_init_msg_list )

1709: END IF;
1710:
1711:
1712: -- Initialize message list if p_init_msg_list is set to TRUE.
1713: IF FND_API.to_Boolean( p_init_msg_list )
1714: THEN
1715: FND_MSG_PUB.initialize;
1716: END IF;
1717:

Line 1730: l_return_status := FND_API.G_RET_STS_SUCCESS;

1726: -- API BODY START
1727: -- ******************************************************************
1728:
1729: -- Initialize API return status to success
1730: l_return_status := FND_API.G_RET_STS_SUCCESS;
1731:
1732: /* initialise local variable to value of variable passed in as
1733: ** a parameter to this procedure
1734: */

Line 1750: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1746: is_qualifier_delete_allowed ( l_seeded_qual_id, l_qual_usg_id , l_return_status);
1747:
1748:
1749:
1750: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1751:
1752:
1753: RAISE FND_API.G_EXC_ERROR;
1754: END IF;

Line 1753: RAISE FND_API.G_EXC_ERROR;

1749:
1750: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1751:
1752:
1753: RAISE FND_API.G_EXC_ERROR;
1754: END IF;
1755:
1756:
1757: -- Process Seeded Qualifier Record

Line 1775: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1771:
1772:
1773:
1774:
1775: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1776: RAISE FND_API.G_EXC_ERROR;
1777: END IF;
1778:
1779:

Line 1776: RAISE FND_API.G_EXC_ERROR;

1772:
1773:
1774:
1775: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1776: RAISE FND_API.G_EXC_ERROR;
1777: END IF;
1778:
1779:
1780: -- Process Qualifier Usages Record

Line 1795: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1791: delete_qual_usgs_record ( l_qual_usg_id,
1792: l_return_status);
1793:
1794:
1795: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1796: RAISE FND_API.G_EXC_ERROR;
1797: END IF;
1798:
1799: /* save return status */

Line 1796: RAISE FND_API.G_EXC_ERROR;

1792: l_return_status);
1793:
1794:
1795: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1796: RAISE FND_API.G_EXC_ERROR;
1797: END IF;
1798:
1799: /* save return status */
1800: x_return_status := l_return_status;

Line 1809: l_return_status = FND_API.G_RET_STS_SUCCESS

1805:
1806:
1807: -- Success Message
1808: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) AND
1809: l_return_status = FND_API.G_RET_STS_SUCCESS
1810: THEN
1811: FND_MESSAGE.Set_Name('JTF', 'API_SUCCESS');
1812: FND_MESSAGE.Set_Token('ROW', 'JTF_QUALIFIER', TRUE);
1813: FND_MSG_PUB.Add;

Line 1817: IF FND_API.To_Boolean ( p_commit )

1813: FND_MSG_PUB.Add;
1814: END IF;
1815:
1816: -- Standard check of p_commit.
1817: IF FND_API.To_Boolean ( p_commit )
1818: THEN
1819: COMMIT WORK;
1820: END IF;
1821:

Line 1837: WHEN FND_API.G_EXC_ERROR THEN

1833: );
1834:
1835: EXCEPTION
1836:
1837: WHEN FND_API.G_EXC_ERROR THEN
1838: ROLLBACK TO DELETE_QUALIFIER_PVT;
1839: x_return_status := FND_API.G_RET_STS_ERROR ;
1840:
1841: FND_MSG_PUB.Count_And_Get

Line 1839: x_return_status := FND_API.G_RET_STS_ERROR ;

1835: EXCEPTION
1836:
1837: WHEN FND_API.G_EXC_ERROR THEN
1838: ROLLBACK TO DELETE_QUALIFIER_PVT;
1839: x_return_status := FND_API.G_RET_STS_ERROR ;
1840:
1841: FND_MSG_PUB.Count_And_Get
1842: ( p_count => x_msg_count,
1843: p_data => x_msg_data

Line 1847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1843: p_data => x_msg_data
1844: );
1845:
1846:
1847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1848: ROLLBACK TO DELETE_QUALIFIER_PVT;
1849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1850:
1851: FND_MSG_PUB.Count_And_Get

Line 1849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1845:
1846:
1847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1848: ROLLBACK TO DELETE_QUALIFIER_PVT;
1849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1850:
1851: FND_MSG_PUB.Count_And_Get
1852: ( p_count => x_msg_count,
1853: p_data => x_msg_data

Line 1859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1855:
1856:
1857: WHEN OTHERS THEN
1858: ROLLBACK TO DELETE_QUALIFIER_PVT;
1859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1860:
1861: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1862: THEN
1863: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);