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 368: IF (l_qual_usgs_rec.enabled_flag = FND_API.G_MISS_CHAR) THEN

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

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

371:
372:
373:
374:
375: IF (l_qual_usgs_rec.qual_col1_datatype = FND_API.G_MISS_CHAR) THEN
376: l_qual_usgs_rec.qual_col1_datatype := get_column_datatype( l_qual_usgs_rec.qual_col1,
377: l_qual_usgs_rec.qual_col1_table);
378: END IF;
379:

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

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

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

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

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

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

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

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

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

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

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

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

Line 419: p_qual_usgs_rec.qual_type_usg_id = FND_API.G_MISS_NUM OR

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

Line 421: p_qual_usgs_rec.qual_col1 = FND_API.G_MISS_CHAR OR

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

Line 423: p_qual_usgs_rec.qual_col1_alias = FND_API.G_MISS_CHAR OR

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

Line 425: p_qual_usgs_rec.qual_col1_datatype = FND_API.G_MISS_CHAR OR

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

Line 427: p_qual_usgs_rec.qual_col1_table = FND_API.G_MISS_CHAR OR

423: p_qual_usgs_rec.qual_col1_alias = FND_API.G_MISS_CHAR OR
424: p_qual_usgs_rec.qual_col1_datatype IS NULL OR
425: p_qual_usgs_rec.qual_col1_datatype = FND_API.G_MISS_CHAR OR
426: p_qual_usgs_rec.qual_col1_table IS NULL OR
427: p_qual_usgs_rec.qual_col1_table = FND_API.G_MISS_CHAR OR
428: p_qual_usgs_rec.qual_col1_table_alias IS NULL OR
429: p_qual_usgs_rec.qual_col1_table_alias = FND_API.G_MISS_CHAR
430: )
431: THEN

Line 429: p_qual_usgs_rec.qual_col1_table_alias = FND_API.G_MISS_CHAR

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

Line 442: RETURN FND_API.G_TRUE;

438: 'QUAL_COL1_TABLE, QUAL_COL1_TABLE_ALIAS');
439: FND_MSG_PUB.ADD;
440: END IF;
441:
442: RETURN FND_API.G_TRUE;
443: ELSE
444: RETURN FND_API.G_FALSE;
445: END IF;
446:

Line 444: RETURN FND_API.G_FALSE;

440: END IF;
441:
442: RETURN FND_API.G_TRUE;
443: ELSE
444: RETURN FND_API.G_FALSE;
445: END IF;
446:
447: END is_qual_usgs_rec_missing;
448:

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

477: where synonym_name = UPPER(l_table_name)
478: and owner = l_apps_schema);
479:
480: l_return_csr VARCHAR2(1);
481: l_return_variable VARCHAR2(1) := FND_API.G_TRUE;
482: l_apps_schema_name VARCHAR2(30);
483:
484: BEGIN
485:

Line 498: l_return_variable := FND_API.G_FALSE;

494: FETCH c_chk_table_exists INTO l_return_csr;
495:
496: IF c_chk_table_exists%NOTFOUND THEN
497:
498: l_return_variable := FND_API.G_FALSE;
499:
500: /* Debug message */
501: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
502: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Table dnot exist');

Line 521: l_return_variable := FND_API.G_FALSE;

517: FETCH c_chk_col_exists INTO l_return_csr;
518:
519: IF c_chk_col_exists%NOTFOUND THEN
520:
521: l_return_variable := FND_API.G_FALSE;
522:
523: /* Debug message */
524: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
525: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Column dnot exist');

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

547: RETURN VARCHAR2
548: IS
549:
550: /* return varaible */
551: l_return_variable VARCHAR2(1) := FND_API.G_TRUE;
552:
553: /* local scratch record */
554: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type;
555:

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

560: l_qual_usgs_rec := p_qual_usgs_rec;
561:
562: IF ( JTF_CTM_UTILITY_PVT.lookup_code_is_valid ( l_qual_usgs_rec.seeded_flag
563: , 'FLAG'
564: , 'FND_LOOKUPS') = FND_API.G_FALSE) THEN
565: l_return_variable := FND_API.G_FALSE;
566: l_qual_usgs_rec.seeded_flag := 'N';
567: END IF;
568:

Line 565: l_return_variable := FND_API.G_FALSE;

561:
562: IF ( JTF_CTM_UTILITY_PVT.lookup_code_is_valid ( l_qual_usgs_rec.seeded_flag
563: , 'FLAG'
564: , 'FND_LOOKUPS') = FND_API.G_FALSE) THEN
565: l_return_variable := FND_API.G_FALSE;
566: l_qual_usgs_rec.seeded_flag := 'N';
567: END IF;
568:
569: IF ( JTF_CTM_UTILITY_PVT.lookup_code_is_valid ( l_qual_usgs_rec.display_type

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

567: END IF;
568:
569: IF ( JTF_CTM_UTILITY_PVT.lookup_code_is_valid ( l_qual_usgs_rec.display_type
570: , 'DISPLAY_TYPE'
571: , 'FND_LOOKUPS') = FND_API.G_FALSE) THEN
572: l_return_variable := FND_API.G_FALSE;
573: l_qual_usgs_rec.display_type := 'STANDARD';
574: END IF;
575:

Line 572: l_return_variable := FND_API.G_FALSE;

568:
569: IF ( JTF_CTM_UTILITY_PVT.lookup_code_is_valid ( l_qual_usgs_rec.display_type
570: , 'DISPLAY_TYPE'
571: , 'FND_LOOKUPS') = FND_API.G_FALSE) THEN
572: l_return_variable := FND_API.G_FALSE;
573: l_qual_usgs_rec.display_type := 'STANDARD';
574: END IF;
575:
576: RETURN l_return_variable;

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

598:
599: l_return_csr VARCHAR2(1);
600:
601: -- Initialise return status
602: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
603:
604: -- Initialise local Qualifer Usages record
605: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := p_qual_usgs_rec;
606:

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

611:
612: /* If record is being updated, check that primary key is not null */
613: IF ( (p_validation_mode = JTF_CTM_UTILITY_PVT.G_UPDATE) AND
614: ( l_qual_usgs_rec.qual_usg_id IS NULL OR
615: l_qual_usgs_rec.qual_usg_id = FND_API.G_MISS_NUM) ) THEN
616:
617: l_return_status := FND_API.G_RET_STS_ERROR;
618:
619: END IF;

Line 617: l_return_status := FND_API.G_RET_STS_ERROR;

613: IF ( (p_validation_mode = JTF_CTM_UTILITY_PVT.G_UPDATE) AND
614: ( l_qual_usgs_rec.qual_usg_id IS NULL OR
615: l_qual_usgs_rec.qual_usg_id = FND_API.G_MISS_NUM) ) THEN
616:
617: l_return_status := FND_API.G_RET_STS_ERROR;
618:
619: END IF;
620:
621:

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

621:
622: -- IF ( p_validation_level >= JTF_CTM_UTILITY_PVT.G_VALID_LEVEL_RECORD ) THEN
623:
624: /* Check that all mandatory items exist in record */
625: IF (is_qual_usgs_rec_missing (l_qual_usgs_rec) = FND_API.G_TRUE) THEN
626: l_return_status := FND_API.G_RET_STS_ERROR;
627: END IF;
628:
629:

Line 626: l_return_status := FND_API.G_RET_STS_ERROR;

622: -- IF ( p_validation_level >= JTF_CTM_UTILITY_PVT.G_VALID_LEVEL_RECORD ) THEN
623:
624: /* Check that all mandatory items exist in record */
625: IF (is_qual_usgs_rec_missing (l_qual_usgs_rec) = FND_API.G_TRUE) THEN
626: l_return_status := FND_API.G_RET_STS_ERROR;
627: END IF;
628:
629:
630:

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

632: -- IF ( p_validation_level >= JTF_CTM_UTILITY_PVT.G_VALID_LEVEL_INTER_ENTITY ) THEN
633:
634: /* check FK reference to JTF_SEEDED_QUAL */
635: IF ( l_qual_usgs_rec.seeded_qual_id IS NOT NULL AND
636: l_qual_usgs_rec.seeded_qual_id <> FND_API.G_MISS_NUM ) THEN
637:
638: IF ( JTF_CTM_UTILITY_PVT.fk_id_is_valid (
639: l_qual_usgs_rec.seeded_qual_id,
640: 'SEEDED_QUAL_ID',

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

637:
638: IF ( JTF_CTM_UTILITY_PVT.fk_id_is_valid (
639: l_qual_usgs_rec.seeded_qual_id,
640: 'SEEDED_QUAL_ID',
641: 'JTF_SEEDED_QUAL') = FND_API.G_FALSE)
642: THEN
643: l_return_status := FND_API.G_RET_STS_ERROR;
644: END IF;
645: END IF;

Line 643: l_return_status := FND_API.G_RET_STS_ERROR;

639: l_qual_usgs_rec.seeded_qual_id,
640: 'SEEDED_QUAL_ID',
641: 'JTF_SEEDED_QUAL') = FND_API.G_FALSE)
642: THEN
643: l_return_status := FND_API.G_RET_STS_ERROR;
644: END IF;
645: END IF;
646:
647:

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

650: -- IF ( p_validation_level >= JTF_CTM_UTILITY_PVT.G_VALID_LEVEL_INTER_ENTITY ) THEN
651:
652: /* check FK reference to JTF_QUAL_TYPE_USGS */
653: IF ( l_qual_usgs_rec.qual_type_usg_id IS NOT NULL AND
654: l_qual_usgs_rec.qual_type_usg_id <> FND_API.G_MISS_NUM ) THEN
655:
656: IF ( JTF_CTM_UTILITY_PVT.fk_id_is_valid (
657: l_qual_usgs_rec.qual_type_usg_id,
658: 'QUAL_TYPE_USG_ID',

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

655:
656: IF ( JTF_CTM_UTILITY_PVT.fk_id_is_valid (
657: l_qual_usgs_rec.qual_type_usg_id,
658: 'QUAL_TYPE_USG_ID',
659: 'JTF_QUAL_TYPE_USGS') = FND_API.G_FALSE)
660: THEN
661: l_return_status := FND_API.G_RET_STS_ERROR;
662: END IF;
663: END IF;

Line 661: l_return_status := FND_API.G_RET_STS_ERROR;

657: l_qual_usgs_rec.qual_type_usg_id,
658: 'QUAL_TYPE_USG_ID',
659: 'JTF_QUAL_TYPE_USGS') = FND_API.G_FALSE)
660: THEN
661: l_return_status := FND_API.G_RET_STS_ERROR;
662: END IF;
663: END IF;
664:
665:

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

668: IF (p_validation_mode = JTF_CTM_UTILITY_PVT.G_CREATE) THEN
669:
670: /* check that Unique Key constraint not violated */
671: IF ( l_qual_usgs_rec.seeded_qual_id IS NOT NULL AND
672: l_qual_usgs_rec.seeded_qual_id <> FND_API.G_MISS_NUM AND
673: l_qual_usgs_rec.qual_type_usg_id IS NOT NULL AND
674: l_qual_usgs_rec.qual_type_usg_id <> FND_API.G_MISS_NUM )THEN
675:
676: /* check if rec already exists */

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

670: /* check that Unique Key constraint not violated */
671: IF ( l_qual_usgs_rec.seeded_qual_id IS NOT NULL AND
672: l_qual_usgs_rec.seeded_qual_id <> FND_API.G_MISS_NUM AND
673: l_qual_usgs_rec.qual_type_usg_id IS NOT NULL AND
674: l_qual_usgs_rec.qual_type_usg_id <> FND_API.G_MISS_NUM )THEN
675:
676: /* check if rec already exists */
677: OPEN c_chk_uk_violation ( l_qual_usgs_rec.seeded_qual_id
678: , l_qual_usgs_rec.qual_type_usg_id);

Line 683: l_return_status := FND_API.G_RET_STS_ERROR;

679: FETCH c_chk_uk_violation INTO l_return_csr;
680:
681: IF c_chk_uk_violation%FOUND THEN
682:
683: l_return_status := FND_API.G_RET_STS_ERROR;
684:
685: /* Debug message */
686: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
687: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:UK Violation');

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

702: -- IF ( p_validation_level >= JTF_CTM_UTILITY_PVT.G_VALID_LEVEL_RECORD ) THEN
703:
704: /* check qualifier column and table exists */
705: IF ( l_qual_usgs_rec.qual_col1_table IS NOT NULL AND
706: l_qual_usgs_rec.qual_col1_table <> FND_API.G_MISS_CHAR AND
707: l_qual_usgs_rec.qual_col1 IS NOT NULL AND
708: l_qual_usgs_rec.qual_col1 <> FND_API.G_MISS_CHAR ) THEN
709:
710: /* if qualifier has been defined as a special function, do

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

704: /* check qualifier column and table exists */
705: IF ( l_qual_usgs_rec.qual_col1_table IS NOT NULL AND
706: l_qual_usgs_rec.qual_col1_table <> FND_API.G_MISS_CHAR AND
707: l_qual_usgs_rec.qual_col1 IS NOT NULL AND
708: l_qual_usgs_rec.qual_col1 <> FND_API.G_MISS_CHAR ) THEN
709:
710: /* if qualifier has been defined as a special function, do
711: ** not check if table and column definitions exist
712: */

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

712: */
713: IF (l_qual_usgs_rec.qual_col1_datatype <> 'SPECIAL_FUNCTION') THEN
714:
715: IF (table_col_is_valid ( l_qual_usgs_rec.qual_col1_table,
716: l_qual_usgs_rec.qual_col1) = FND_API.G_FALSE)
717: THEN
718: l_return_status := FND_API.G_RET_STS_ERROR;
719: END IF;
720:

Line 718: l_return_status := FND_API.G_RET_STS_ERROR;

714:
715: IF (table_col_is_valid ( l_qual_usgs_rec.qual_col1_table,
716: l_qual_usgs_rec.qual_col1) = FND_API.G_FALSE)
717: THEN
718: l_return_status := FND_API.G_RET_STS_ERROR;
719: END IF;
720:
721: END IF;
722: END IF;

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

727: -- IF ( p_validation_level >= JTF_CTM_UTILITY_PVT.G_VALID_LEVEL_RECORD ) THEN
728:
729: /* check qualifier column and table exists */
730: IF ( l_qual_usgs_rec.int_cde_col_table IS NOT NULL AND
731: l_qual_usgs_rec.int_cde_col_table <> FND_API.G_MISS_CHAR AND
732: l_qual_usgs_rec.prim_int_cde_col IS NOT NULL AND
733: l_qual_usgs_rec.prim_int_cde_col <> FND_API.G_MISS_CHAR ) THEN
734:
735: IF (table_col_is_valid ( l_qual_usgs_rec.int_cde_col_table,

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

729: /* check qualifier column and table exists */
730: IF ( l_qual_usgs_rec.int_cde_col_table IS NOT NULL AND
731: l_qual_usgs_rec.int_cde_col_table <> FND_API.G_MISS_CHAR AND
732: l_qual_usgs_rec.prim_int_cde_col IS NOT NULL AND
733: l_qual_usgs_rec.prim_int_cde_col <> FND_API.G_MISS_CHAR ) THEN
734:
735: IF (table_col_is_valid ( l_qual_usgs_rec.int_cde_col_table,
736: l_qual_usgs_rec.prim_int_cde_col) = FND_API.G_FALSE)
737: THEN

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

732: l_qual_usgs_rec.prim_int_cde_col IS NOT NULL AND
733: l_qual_usgs_rec.prim_int_cde_col <> FND_API.G_MISS_CHAR ) THEN
734:
735: IF (table_col_is_valid ( l_qual_usgs_rec.int_cde_col_table,
736: l_qual_usgs_rec.prim_int_cde_col) = FND_API.G_FALSE)
737: THEN
738:
739: l_return_status := FND_API.G_RET_STS_ERROR;
740: END IF;

Line 739: l_return_status := FND_API.G_RET_STS_ERROR;

735: IF (table_col_is_valid ( l_qual_usgs_rec.int_cde_col_table,
736: l_qual_usgs_rec.prim_int_cde_col) = FND_API.G_FALSE)
737: THEN
738:
739: l_return_status := FND_API.G_RET_STS_ERROR;
740: END IF;
741:
742: END IF;
743:

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

747: -- IF ( p_validation_level >= JTF_CTM_UTILITY_PVT.G_VALID_LEVEL_RECORD ) THEN
748:
749: /* check qualifier column and table exists */
750: IF ( l_qual_usgs_rec.int_cde_col_table IS NOT NULL AND
751: l_qual_usgs_rec.int_cde_col_table <> FND_API.G_MISS_CHAR AND
752: l_qual_usgs_rec.sec_int_cde_col IS NOT NULL AND
753: l_qual_usgs_rec.sec_int_cde_col <> FND_API.G_MISS_CHAR ) THEN
754:
755: IF (table_col_is_valid ( l_qual_usgs_rec.int_cde_col_table,

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

749: /* check qualifier column and table exists */
750: IF ( l_qual_usgs_rec.int_cde_col_table IS NOT NULL AND
751: l_qual_usgs_rec.int_cde_col_table <> FND_API.G_MISS_CHAR AND
752: l_qual_usgs_rec.sec_int_cde_col IS NOT NULL AND
753: l_qual_usgs_rec.sec_int_cde_col <> FND_API.G_MISS_CHAR ) THEN
754:
755: IF (table_col_is_valid ( l_qual_usgs_rec.int_cde_col_table,
756: l_qual_usgs_rec.sec_int_cde_col) = FND_API.G_FALSE)
757: THEN

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

752: l_qual_usgs_rec.sec_int_cde_col IS NOT NULL AND
753: l_qual_usgs_rec.sec_int_cde_col <> FND_API.G_MISS_CHAR ) THEN
754:
755: IF (table_col_is_valid ( l_qual_usgs_rec.int_cde_col_table,
756: l_qual_usgs_rec.sec_int_cde_col) = FND_API.G_FALSE)
757: THEN
758:
759: l_return_status := FND_API.G_RET_STS_ERROR;
760: END IF;

Line 759: l_return_status := FND_API.G_RET_STS_ERROR;

755: IF (table_col_is_valid ( l_qual_usgs_rec.int_cde_col_table,
756: l_qual_usgs_rec.sec_int_cde_col) = FND_API.G_FALSE)
757: THEN
758:
759: l_return_status := FND_API.G_RET_STS_ERROR;
760: END IF;
761:
762: END IF;
763:

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

789:
790: l_qual_usgs_rec := p_qual_usgs_rec;
791:
792: -- Initialise API return status to success
793: l_qual_usgs_out_rec.return_status := FND_API.G_RET_STS_SUCCESS;
794:
795: -- convert id to null, so that next value of sequence will
796: -- be selected
797: IF (l_qual_usgs_rec.qual_usg_id = FND_API.G_MISS_NUM) THEN

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

793: l_qual_usgs_out_rec.return_status := FND_API.G_RET_STS_SUCCESS;
794:
795: -- convert id to null, so that next value of sequence will
796: -- be selected
797: IF (l_qual_usgs_rec.qual_usg_id = FND_API.G_MISS_NUM) THEN
798:
799:
800: l_qual_usgs_rec.qual_usg_id := NULL;
801: END IF;

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

853: l_qual_usgs_out_rec.qual_usg_id := l_qual_usgs_rec.qual_usg_id;
854:
855:
856:
857: l_qual_usgs_out_rec.return_status := FND_API.G_RET_STS_SUCCESS;
858:
859: -- save id and status
860: x_qual_usgs_out_rec := l_qual_usgs_out_rec;
861:

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

883: -- initialize locak seeded qualifier record
884: l_qual_usgs_rec := p_qual_usgs_rec;
885:
886: -- Initialise API return status to success
887: l_qual_usgs_out_rec.return_status := FND_API.G_RET_STS_SUCCESS;
888:
889:
890: -- by eihsu, using similar method of problem resolution as in procedure Update_Seed_Qual_Record
891: -- (vinoo and jdochert)

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

941: X_use_in_lookup_flag => l_qual_usgs_rec.use_in_lookup_flag
942: );
943:
944: l_qual_usgs_out_rec.qual_usg_id := l_qual_usgs_rec.qual_usg_id;
945: l_qual_usgs_out_rec.return_status := FND_API.G_RET_STS_SUCCESS;
946:
947: -- save id and status
948: x_qual_usgs_out_rec := l_qual_usgs_out_rec;
949:

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

992: /* cursor return variable */
993: dummy_csr NUMBER;
994:
995: /* local return variable */
996: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
997:
998: /* local scratch variables */
999: l_seeded_qual_id NUMBER := p_seeded_qual_id;
1000: l_qual_usg_id NUMBER := p_qual_usg_id;

Line 1016: l_return_status := FND_API.G_RET_STS_ERROR;

1012: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL1');
1013: FND_MSG_PUB.Add;
1014: END IF;
1015:
1016: l_return_status := FND_API.G_RET_STS_ERROR;
1017: END IF;
1018:
1019:
1020:

Line 1034: l_return_status := FND_API.G_RET_STS_ERROR;

1030: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL2');
1031: FND_MSG_PUB.Add;
1032: END IF;
1033:
1034: l_return_status := FND_API.G_RET_STS_ERROR;
1035: END IF;
1036:
1037: OPEN c_chk_terr ( l_qual_usg_id );
1038:

Line 1051: l_return_status := FND_API.G_RET_STS_ERROR;

1047: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL3');
1048: FND_MSG_PUB.Add;
1049: END IF;
1050:
1051: l_return_status := FND_API.G_RET_STS_ERROR;
1052: END IF;
1053:
1054:
1055:

Line 1070: l_return_status := FND_API.G_RET_STS_ERROR;

1066: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL4');
1067: FND_MSG_PUB.Add;
1068: END IF;
1069:
1070: l_return_status := FND_API.G_RET_STS_ERROR;
1071: END IF;
1072:
1073:
1074:

Line 1095: l_return_status := FND_API.G_RET_STS_SUCCESS;

1091: BEGIN
1092:
1093:
1094: -- Initialise API return status to success
1095: l_return_status := FND_API.G_RET_STS_SUCCESS;
1096:
1097: -- Call UPDATE table handler
1098: JTF_QUAL_USGS_PKG.DELETE_ROW ( X_QUAL_USG_ID => p_qual_usg_id);
1099:

Line 1129: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE

1125: -- p_Qual_Usgs_Rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC
1126: --
1127: -- Optional
1128: -- Parameter Name Data Type Default
1129: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1130: -- P_Commit VARCHAR2 FND_API.G_FALSE
1131: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL
1132: --
1133: -- OUT :

Line 1130: -- P_Commit VARCHAR2 FND_API.G_FALSE

1126: --
1127: -- Optional
1128: -- Parameter Name Data Type Default
1129: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1130: -- P_Commit VARCHAR2 FND_API.G_FALSE
1131: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL
1132: --
1133: -- OUT :
1134: -- Parameter Name Data Type Default

Line 1131: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL

1127: -- Optional
1128: -- Parameter Name Data Type Default
1129: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1130: -- P_Commit VARCHAR2 FND_API.G_FALSE
1131: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL
1132: --
1133: -- OUT :
1134: -- Parameter Name Data Type Default
1135: -- x_Return_Status VARCHAR2(1)

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

1145: -- End of Comments
1146: --
1147: PROCEDURE Create_Qualifier
1148: (p_api_version IN NUMBER,
1149: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1150: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1151: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1152: x_Return_Status OUT NOCOPY VARCHAR2,
1153: x_Msg_Count OUT NOCOPY NUMBER,

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

1146: --
1147: PROCEDURE Create_Qualifier
1148: (p_api_version IN NUMBER,
1149: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1150: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1151: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1152: x_Return_Status OUT NOCOPY VARCHAR2,
1153: x_Msg_Count OUT NOCOPY NUMBER,
1154: x_Msg_Data OUT NOCOPY VARCHAR2,

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

1147: PROCEDURE Create_Qualifier
1148: (p_api_version IN NUMBER,
1149: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1150: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1151: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1152: x_Return_Status OUT NOCOPY VARCHAR2,
1153: x_Msg_Count OUT NOCOPY NUMBER,
1154: x_Msg_Data OUT NOCOPY VARCHAR2,
1155: -- commented eihsu 11/04

Line 1181: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1177: -- Standard Start of API savepoint
1178: SAVEPOINT CREATE_QUALIFIER_PVT;
1179:
1180: -- Standard call to check for call compatability
1181: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1182: p_api_version,
1183: l_api_name,
1184: G_PKG_NAME)
1185: THEN

Line 1186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1182: p_api_version,
1183: l_api_name,
1184: G_PKG_NAME)
1185: THEN
1186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1187: END IF;
1188:
1189: -- Initialize message list if p_init_msg_list is set to TRUE.
1190: IF FND_API.to_Boolean( p_init_msg_list )

Line 1190: IF FND_API.to_Boolean( p_init_msg_list )

1186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1187: END IF;
1188:
1189: -- Initialize message list if p_init_msg_list is set to TRUE.
1190: IF FND_API.to_Boolean( p_init_msg_list )
1191: THEN
1192: FND_MSG_PUB.initialize;
1193: END IF;
1194:

Line 1208: l_return_status := FND_API.G_RET_STS_SUCCESS;

1204: -- API BODY START
1205: -- ******************************************************************
1206:
1207: -- Initialize API return status to success
1208: l_return_status := FND_API.G_RET_STS_SUCCESS;
1209:
1210: -- Seeded Qualifier record doesn't have any default values, so
1211: -- just initialise local variable to value of variable passed in as
1212: -- a parameter to this procedure

Line 1224: RAISE FND_API.G_EXC_ERROR;

1220: check_qualifier_usage (l_qual_usgs_rec.qual_usg_id, l_qualifier_used);
1221: END IF;
1222: IF l_qualifier_used = 'TRUE' THEN
1223: -- qualifier being used and cannot be diabled
1224: RAISE FND_API.G_EXC_ERROR;
1225:
1226: END IF;
1227:
1228: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

Line 1228: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

1224: RAISE FND_API.G_EXC_ERROR;
1225:
1226: END IF;
1227:
1228: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
1229:
1230: -- Debug message
1231: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1232: FND_MESSAGE.Set_Name('JTF', 'PVTQUAL API:Validate Rec');

Line 1244: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1240: p_validation_level,
1241: l_return_status);
1242:
1243:
1244: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1245: RAISE FND_API.G_EXC_ERROR;
1246: END IF;
1247:
1248: -- validate the qualifier usage record

Line 1245: RAISE FND_API.G_EXC_ERROR;

1241: l_return_status);
1242:
1243:
1244: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1245: RAISE FND_API.G_EXC_ERROR;
1246: END IF;
1247:
1248: -- validate the qualifier usage record
1249: validate_qual_usgs_rec ( l_qual_usgs_rec,

Line 1254: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1250: JTF_CTM_UTILITY_PVT.G_CREATE,
1251: p_validation_level,
1252: l_return_status);
1253:
1254: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1255: RAISE FND_API.G_EXC_ERROR;
1256: END IF;
1257:
1258: END IF; -- End of Record Validation

Line 1255: RAISE FND_API.G_EXC_ERROR;

1251: p_validation_level,
1252: l_return_status);
1253:
1254: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1255: RAISE FND_API.G_EXC_ERROR;
1256: END IF;
1257:
1258: END IF; -- End of Record Validation
1259:

Line 1279: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1275:
1276:
1277: -- ' l_seeded_qual_id = '|| TO_CHAR(l_seed_qual_out_rec.seeded_qual_id));
1278:
1279: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1280: RAISE FND_API.G_EXC_ERROR;
1281: END IF;
1282:
1283:

Line 1280: RAISE FND_API.G_EXC_ERROR;

1276:
1277: -- ' l_seeded_qual_id = '|| TO_CHAR(l_seed_qual_out_rec.seeded_qual_id));
1278:
1279: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1280: RAISE FND_API.G_EXC_ERROR;
1281: END IF;
1282:
1283:
1284: -- Process Qualifier Usages Record

Line 1304: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1300:
1301: -- ' l_qual_usg_id = '|| TO_CHAR(l_qual_usgs_out_rec.qual_usg_id));
1302:
1303:
1304: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1305: RAISE FND_API.G_EXC_ERROR;
1306: END IF;
1307:
1308: -- save the returned seeded qualifer id, qualifier usage id, and status

Line 1305: RAISE FND_API.G_EXC_ERROR;

1301: -- ' l_qual_usg_id = '|| TO_CHAR(l_qual_usgs_out_rec.qual_usg_id));
1302:
1303:
1304: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1305: RAISE FND_API.G_EXC_ERROR;
1306: END IF;
1307:
1308: -- save the returned seeded qualifer id, qualifier usage id, and status
1309: x_seed_qual_rec.seeded_qual_id := l_seed_qual_out_rec.seeded_qual_id;

Line 1320: l_return_status = FND_API.G_RET_STS_SUCCESS

1316:
1317:
1318: -- Success Message
1319: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) AND
1320: l_return_status = FND_API.G_RET_STS_SUCCESS
1321: THEN
1322: FND_MESSAGE.Set_Name('JTF', 'API_SUCCESS');
1323: FND_MESSAGE.Set_Token('ROW', 'JTF_QUALIFIER', TRUE);
1324: FND_MSG_PUB.Add;

Line 1328: IF FND_API.To_Boolean ( p_commit )

1324: FND_MSG_PUB.Add;
1325: END IF;
1326:
1327: -- Standard check of p_commit.
1328: IF FND_API.To_Boolean ( p_commit )
1329: THEN
1330: COMMIT WORK;
1331: END IF;
1332:

Line 1348: WHEN FND_API.G_EXC_ERROR THEN

1344: );
1345:
1346: EXCEPTION
1347:
1348: WHEN FND_API.G_EXC_ERROR THEN
1349: ROLLBACK TO CREATE_QUALIFIER_PVT;
1350: x_return_status := FND_API.G_RET_STS_ERROR ;
1351:
1352: FND_MSG_PUB.Count_And_Get

Line 1350: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1354: p_data => x_msg_data
1355: );
1356:
1357:
1358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1359: ROLLBACK TO CREATE_QUALIFIER_PVT;
1360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1361:
1362: FND_MSG_PUB.Count_And_Get

Line 1360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1356:
1357:
1358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1359: ROLLBACK TO CREATE_QUALIFIER_PVT;
1360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1361:
1362: FND_MSG_PUB.Count_And_Get
1363: ( p_count => x_msg_count,
1364: p_data => x_msg_data

Line 1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1366:
1367:
1368: WHEN OTHERS THEN
1369: ROLLBACK TO CREATE_QUALIFIER_PVT;
1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1371:
1372: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1373: THEN
1374: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);

Line 1404: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE

1400: -- p_Qual_Usgs_Rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC
1401: --
1402: -- Optional
1403: -- Parameter Name Data Type Default
1404: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1405: -- P_Commit VARCHAR2 FND_API.G_FALSE
1406: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL
1407: --
1408: -- OUT :

Line 1405: -- P_Commit VARCHAR2 FND_API.G_FALSE

1401: --
1402: -- Optional
1403: -- Parameter Name Data Type Default
1404: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1405: -- P_Commit VARCHAR2 FND_API.G_FALSE
1406: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL
1407: --
1408: -- OUT :
1409: -- Parameter Name Data Type Default

Line 1406: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL

1402: -- Optional
1403: -- Parameter Name Data Type Default
1404: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1405: -- P_Commit VARCHAR2 FND_API.G_FALSE
1406: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL
1407: --
1408: -- OUT :
1409: -- Parameter Name Data Type Default
1410: -- x_Return_Status VARCHAR2(1)

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

1420: -- End of Comments
1421: --
1422: PROCEDURE Update_Qualifier
1423: (p_api_version IN NUMBER,
1424: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1425: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1426: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1427: x_Return_Status OUT NOCOPY VARCHAR2,
1428: x_Msg_Count OUT NOCOPY NUMBER,

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

1421: --
1422: PROCEDURE Update_Qualifier
1423: (p_api_version IN NUMBER,
1424: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1425: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1426: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1427: x_Return_Status OUT NOCOPY VARCHAR2,
1428: x_Msg_Count OUT NOCOPY NUMBER,
1429: x_Msg_Data OUT NOCOPY VARCHAR2,

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

1422: PROCEDURE Update_Qualifier
1423: (p_api_version IN NUMBER,
1424: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1425: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1426: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1427: x_Return_Status OUT NOCOPY VARCHAR2,
1428: x_Msg_Count OUT NOCOPY NUMBER,
1429: x_Msg_Data OUT NOCOPY VARCHAR2,
1430: p_Seed_Qual_Rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC,

Line 1454: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1450: -- Standard Start of API savepoint
1451: SAVEPOINT UPDATE_QUALIFIER_PVT;
1452:
1453: -- Standard call to check for call compatability
1454: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1455: p_api_version,
1456: l_api_name,
1457: G_PKG_NAME)
1458: THEN

Line 1459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1455: p_api_version,
1456: l_api_name,
1457: G_PKG_NAME)
1458: THEN
1459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1460: END IF;
1461:
1462: -- Initialize message list if p_init_msg_list is set to TRUE.
1463: IF FND_API.to_Boolean( p_init_msg_list )

Line 1463: IF FND_API.to_Boolean( p_init_msg_list )

1459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1460: END IF;
1461:
1462: -- Initialize message list if p_init_msg_list is set to TRUE.
1463: IF FND_API.to_Boolean( p_init_msg_list )
1464: THEN
1465: FND_MSG_PUB.initialize;
1466: END IF;
1467:

Line 1481: l_return_status := FND_API.G_RET_STS_SUCCESS;

1477: -- API BODY START
1478: -- ******************************************************************
1479:
1480: -- Initialize API return status to success
1481: l_return_status := FND_API.G_RET_STS_SUCCESS;
1482:
1483: -- Seeded Qualifier record doesn't have any default values, so
1484: -- just initialise local variable to value of variable passed in as
1485: -- a parameter to this procedure

Line 1493: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

1489: -- Converts missing items' values to default values in Qualifier Usages record
1490: convert_miss_qual_usgs_rec (p_qual_usgs_rec, l_qual_usgs_rec);
1491:
1492:
1493: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
1494:
1495: -- Debug message
1496: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1497: FND_MESSAGE.Set_Name('JTF', 'PVT QUAL API: Valdte Record');

Line 1508: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1504: p_validation_level,
1505: l_return_status);
1506:
1507:
1508: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1509: RAISE FND_API.G_EXC_ERROR;
1510: END IF;
1511:
1512:

Line 1509: RAISE FND_API.G_EXC_ERROR;

1505: l_return_status);
1506:
1507:
1508: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1509: RAISE FND_API.G_EXC_ERROR;
1510: END IF;
1511:
1512:
1513:

Line 1523: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1519: l_return_status);
1520:
1521:
1522:
1523: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1524: RAISE FND_API.G_EXC_ERROR;
1525: END IF;
1526:
1527:

Line 1524: RAISE FND_API.G_EXC_ERROR;

1520:
1521:
1522:
1523: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1524: RAISE FND_API.G_EXC_ERROR;
1525: END IF;
1526:
1527:
1528:

Line 1547: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1543: l_seed_qual_out_rec);
1544: l_return_status := l_seed_qual_out_rec.return_status;
1545:
1546:
1547: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1548: RAISE FND_API.G_EXC_ERROR;
1549: END IF;
1550:
1551:

Line 1548: RAISE FND_API.G_EXC_ERROR;

1544: l_return_status := l_seed_qual_out_rec.return_status;
1545:
1546:
1547: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1548: RAISE FND_API.G_EXC_ERROR;
1549: END IF;
1550:
1551:
1552: -- Process Qualifier Usages Record

Line 1566: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1562: l_qual_usgs_out_rec);
1563:
1564: l_return_status := l_qual_usgs_out_rec.return_status;
1565:
1566: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1567: RAISE FND_API.G_EXC_ERROR;
1568: END IF;
1569:
1570: -- save the returned seeded qualifer id, qualifier usage id, and status

Line 1567: RAISE FND_API.G_EXC_ERROR;

1563:
1564: l_return_status := l_qual_usgs_out_rec.return_status;
1565:
1566: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1567: RAISE FND_API.G_EXC_ERROR;
1568: END IF;
1569:
1570: -- save the returned seeded qualifer id, qualifier usage id, and status
1571: x_seed_qual_rec.seeded_qual_id := l_seed_qual_out_rec.seeded_qual_id;

Line 1582: l_return_status = FND_API.G_RET_STS_SUCCESS

1578:
1579:
1580: -- Success Message
1581: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) AND
1582: l_return_status = FND_API.G_RET_STS_SUCCESS
1583: THEN
1584: FND_MESSAGE.Set_Name('JTF', 'API_SUCCESS');
1585: FND_MESSAGE.Set_Token('ROW', 'JTF_QUALIFIER', TRUE);
1586: FND_MSG_PUB.Add;

Line 1592: IF FND_API.To_Boolean ( p_commit )

1588:
1589:
1590:
1591: -- Standard check of p_commit.
1592: IF FND_API.To_Boolean ( p_commit )
1593: THEN
1594: COMMIT WORK;
1595: END IF;
1596:

Line 1612: WHEN FND_API.G_EXC_ERROR THEN

1608: );
1609:
1610: EXCEPTION
1611:
1612: WHEN FND_API.G_EXC_ERROR THEN
1613: ROLLBACK TO UPDATE_QUALIFIER_PVT;
1614: x_return_status := FND_API.G_RET_STS_ERROR ;
1615:
1616: FND_MSG_PUB.Count_And_Get

Line 1614: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1618: p_data => x_msg_data
1619: );
1620:
1621:
1622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1623: ROLLBACK TO UPDATE_QUALIFIER_PVT;
1624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1625:
1626: FND_MSG_PUB.Count_And_Get

Line 1624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1620:
1621:
1622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1623: ROLLBACK TO UPDATE_QUALIFIER_PVT;
1624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1625:
1626: FND_MSG_PUB.Count_And_Get
1627: ( p_count => x_msg_count,
1628: p_data => x_msg_data

Line 1634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1630:
1631:
1632: WHEN OTHERS THEN
1633: ROLLBACK TO UPDATE_QUALIFIER_PVT;
1634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1635:
1636: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1637: THEN
1638: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);

Line 1663: -- p_Seeded_Qual_Id NUMBER FND_API.G_MISS_NUM

1659: -- IN :
1660: -- Required
1661: -- Parameter Name Data Type Default
1662: -- p_api_version NUMBER
1663: -- p_Seeded_Qual_Id NUMBER FND_API.G_MISS_NUM
1664: -- p_Qual_Usgs_Id NUMBER FND_API.G_MISS_NUM
1665: --
1666: -- Optional
1667: -- Parameter Name Data Type Default

Line 1664: -- p_Qual_Usgs_Id NUMBER FND_API.G_MISS_NUM

1660: -- Required
1661: -- Parameter Name Data Type Default
1662: -- p_api_version NUMBER
1663: -- p_Seeded_Qual_Id NUMBER FND_API.G_MISS_NUM
1664: -- p_Qual_Usgs_Id NUMBER FND_API.G_MISS_NUM
1665: --
1666: -- Optional
1667: -- Parameter Name Data Type Default
1668: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE

Line 1668: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE

1664: -- p_Qual_Usgs_Id NUMBER FND_API.G_MISS_NUM
1665: --
1666: -- Optional
1667: -- Parameter Name Data Type Default
1668: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1669: -- P_Commit VARCHAR2 FND_API.G_FALSE
1670: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL
1671: --
1672: -- OUT :

Line 1669: -- P_Commit VARCHAR2 FND_API.G_FALSE

1665: --
1666: -- Optional
1667: -- Parameter Name Data Type Default
1668: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1669: -- P_Commit VARCHAR2 FND_API.G_FALSE
1670: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL
1671: --
1672: -- OUT :
1673: -- Parameter Name Data Type Default

Line 1670: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL

1666: -- Optional
1667: -- Parameter Name Data Type Default
1668: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1669: -- P_Commit VARCHAR2 FND_API.G_FALSE
1670: -- p_validation_level VARCHAR2 FND_API.G_VALID_LEVEL_FULL
1671: --
1672: -- OUT :
1673: -- Parameter Name Data Type Default
1674: -- x_Return_Status VARCHAR2(1)

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

1682: -- End of Comments
1683: --
1684: PROCEDURE Delete_Qualifier
1685: (p_api_version IN NUMBER,
1686: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1687: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1688: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1689: x_Return_Status OUT NOCOPY VARCHAR2,
1690: x_Msg_Count OUT NOCOPY NUMBER,

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

1683: --
1684: PROCEDURE Delete_Qualifier
1685: (p_api_version IN NUMBER,
1686: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1687: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1688: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1689: x_Return_Status OUT NOCOPY VARCHAR2,
1690: x_Msg_Count OUT NOCOPY NUMBER,
1691: x_Msg_Data OUT NOCOPY VARCHAR2,

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

1684: PROCEDURE Delete_Qualifier
1685: (p_api_version IN NUMBER,
1686: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1687: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1688: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1689: x_Return_Status OUT NOCOPY VARCHAR2,
1690: x_Msg_Count OUT NOCOPY NUMBER,
1691: x_Msg_Data OUT NOCOPY VARCHAR2,
1692: p_Seeded_Qual_Id IN NUMBER := FND_API.G_MISS_NUM,

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

1688: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1689: x_Return_Status OUT NOCOPY VARCHAR2,
1690: x_Msg_Count OUT NOCOPY NUMBER,
1691: x_Msg_Data OUT NOCOPY VARCHAR2,
1692: p_Seeded_Qual_Id IN NUMBER := FND_API.G_MISS_NUM,
1693: p_Qual_Usg_Id IN NUMBER := FND_API.G_MISS_NUM
1694: )
1695: IS
1696: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Qualifier';

Line 1693: p_Qual_Usg_Id IN NUMBER := FND_API.G_MISS_NUM

1689: x_Return_Status OUT NOCOPY VARCHAR2,
1690: x_Msg_Count OUT NOCOPY NUMBER,
1691: x_Msg_Data OUT NOCOPY VARCHAR2,
1692: p_Seeded_Qual_Id IN NUMBER := FND_API.G_MISS_NUM,
1693: p_Qual_Usg_Id IN NUMBER := FND_API.G_MISS_NUM
1694: )
1695: IS
1696: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Qualifier';
1697: l_api_version CONSTANT NUMBER := 1.0;

Line 1712: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1708: -- Standard Start of API savepoint
1709: SAVEPOINT DELETE_QUALIFIER_PVT;
1710:
1711: -- Standard call to check for call compatability
1712: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1713: p_api_version,
1714: l_api_name,
1715: G_PKG_NAME)
1716: THEN

Line 1717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1713: p_api_version,
1714: l_api_name,
1715: G_PKG_NAME)
1716: THEN
1717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1718: END IF;
1719:
1720:
1721: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1722: IF FND_API.to_Boolean( p_init_msg_list )

1718: END IF;
1719:
1720:
1721: -- Initialize message list if p_init_msg_list is set to TRUE.
1722: IF FND_API.to_Boolean( p_init_msg_list )
1723: THEN
1724: FND_MSG_PUB.initialize;
1725: END IF;
1726:

Line 1739: l_return_status := FND_API.G_RET_STS_SUCCESS;

1735: -- API BODY START
1736: -- ******************************************************************
1737:
1738: -- Initialize API return status to success
1739: l_return_status := FND_API.G_RET_STS_SUCCESS;
1740:
1741: /* initialise local variable to value of variable passed in as
1742: ** a parameter to this procedure
1743: */

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

1755: is_qualifier_delete_allowed ( l_seeded_qual_id, l_qual_usg_id , l_return_status);
1756:
1757:
1758:
1759: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1760:
1761:
1762: RAISE FND_API.G_EXC_ERROR;
1763: END IF;

Line 1762: RAISE FND_API.G_EXC_ERROR;

1758:
1759: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1760:
1761:
1762: RAISE FND_API.G_EXC_ERROR;
1763: END IF;
1764:
1765:
1766: -- Process Seeded Qualifier Record

Line 1784: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1780:
1781:
1782:
1783:
1784: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1785: RAISE FND_API.G_EXC_ERROR;
1786: END IF;
1787:
1788:

Line 1785: RAISE FND_API.G_EXC_ERROR;

1781:
1782:
1783:
1784: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1785: RAISE FND_API.G_EXC_ERROR;
1786: END IF;
1787:
1788:
1789: -- Process Qualifier Usages Record

Line 1804: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1800: delete_qual_usgs_record ( l_qual_usg_id,
1801: l_return_status);
1802:
1803:
1804: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1805: RAISE FND_API.G_EXC_ERROR;
1806: END IF;
1807:
1808: /* save return status */

Line 1805: RAISE FND_API.G_EXC_ERROR;

1801: l_return_status);
1802:
1803:
1804: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1805: RAISE FND_API.G_EXC_ERROR;
1806: END IF;
1807:
1808: /* save return status */
1809: x_return_status := l_return_status;

Line 1818: l_return_status = FND_API.G_RET_STS_SUCCESS

1814:
1815:
1816: -- Success Message
1817: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) AND
1818: l_return_status = FND_API.G_RET_STS_SUCCESS
1819: THEN
1820: FND_MESSAGE.Set_Name('JTF', 'API_SUCCESS');
1821: FND_MESSAGE.Set_Token('ROW', 'JTF_QUALIFIER', TRUE);
1822: FND_MSG_PUB.Add;

Line 1826: IF FND_API.To_Boolean ( p_commit )

1822: FND_MSG_PUB.Add;
1823: END IF;
1824:
1825: -- Standard check of p_commit.
1826: IF FND_API.To_Boolean ( p_commit )
1827: THEN
1828: COMMIT WORK;
1829: END IF;
1830:

Line 1846: WHEN FND_API.G_EXC_ERROR THEN

1842: );
1843:
1844: EXCEPTION
1845:
1846: WHEN FND_API.G_EXC_ERROR THEN
1847: ROLLBACK TO DELETE_QUALIFIER_PVT;
1848: x_return_status := FND_API.G_RET_STS_ERROR ;
1849:
1850: FND_MSG_PUB.Count_And_Get

Line 1848: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1852: p_data => x_msg_data
1853: );
1854:
1855:
1856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1857: ROLLBACK TO DELETE_QUALIFIER_PVT;
1858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1859:
1860: FND_MSG_PUB.Count_And_Get

Line 1858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1854:
1855:
1856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1857: ROLLBACK TO DELETE_QUALIFIER_PVT;
1858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1859:
1860: FND_MSG_PUB.Count_And_Get
1861: ( p_count => x_msg_count,
1862: p_data => x_msg_data

Line 1868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1864:
1865:
1866: WHEN OTHERS THEN
1867: ROLLBACK TO DELETE_QUALIFIER_PVT;
1868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1869:
1870: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1871: THEN
1872: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);