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

Line 42: RETURN FND_API.g_false;

38: fetch c_app into temp;
39:
40: if (c_app%NOTFOUND) then
41: close c_app;
42: RETURN FND_API.g_false;
43: else
44: close c_app;
45: RETURN FND_API.g_true;
46: end if;

Line 45: RETURN FND_API.g_true;

41: close c_app;
42: RETURN FND_API.g_false;
43: else
44: close c_app;
45: RETURN FND_API.g_true;
46: end if;
47: END;
48:
49:

Line 80: RETURN FND_API.g_false;

76: fetch c_appi into temp;
77:
78: if (c_appi%NOTFOUND) then
79: close c_appi;
80: RETURN FND_API.g_false;
81: else
82: close c_appi;
83: RETURN FND_API.g_true;
84: end if;

Line 83: RETURN FND_API.g_true;

79: close c_appi;
80: RETURN FND_API.g_false;
81: else
82: close c_appi;
83: RETURN FND_API.g_true;
84: end if;
85: END;
86:
87:

Line 101: RETURN FND_API.g_true;

97: RETURN VARCHAR2
98: IS
99: BEGIN
100: IF ( (f_boolean = 'F') OR (f_boolean = 'T') ) THEN
101: RETURN FND_API.g_true;
102: ELSE
103: RETURN FND_API.g_false;
104: END IF;
105: END isBoolean;

Line 103: RETURN FND_API.g_false;

99: BEGIN
100: IF ( (f_boolean = 'F') OR (f_boolean = 'T') ) THEN
101: RETURN FND_API.g_true;
102: ELSE
103: RETURN FND_API.g_false;
104: END IF;
105: END isBoolean;
106:
107:

Line 141: RETURN Fnd_Api.g_true;

137: temp := TO_DATE(f_date,'RRRR-mm-dd');
138: END;
139:
140: END;
141: RETURN Fnd_Api.g_true;
142: ELSE
143: RETURN Fnd_Api.g_false;
144: END IF;
145: EXCEPTION

Line 143: RETURN Fnd_Api.g_false;

139:
140: END;
141: RETURN Fnd_Api.g_true;
142: ELSE
143: RETURN Fnd_Api.g_false;
144: END IF;
145: EXCEPTION
146: WHEN OTHERS THEN
147: RETURN Fnd_Api.g_false;

Line 147: RETURN Fnd_Api.g_false;

143: RETURN Fnd_Api.g_false;
144: END IF;
145: EXCEPTION
146: WHEN OTHERS THEN
147: RETURN Fnd_Api.g_false;
148: END isDate;
149:
150:
151:

Line 169: RETURN FND_API.g_true;

165: temp NUMBER;
166: BEGIN
167: if (f_number is not null) then
168: temp := TO_NUMBER(f_number);
169: RETURN FND_API.g_true;
170: else
171: RETURN FND_API.g_false;
172: end if;
173: EXCEPTION

Line 171: RETURN FND_API.g_false;

167: if (f_number is not null) then
168: temp := TO_NUMBER(f_number);
169: RETURN FND_API.g_true;
170: else
171: RETURN FND_API.g_false;
172: end if;
173: EXCEPTION
174: WHEN OTHERS THEN
175: RETURN FND_API.g_false;

Line 175: RETURN FND_API.g_false;

171: RETURN FND_API.g_false;
172: end if;
173: EXCEPTION
174: WHEN OTHERS THEN
175: RETURN FND_API.g_false;
176: END isNumber;
177:
178:
179:

Line 208: RETURN FND_API.g_false;

204: FETCH c_assoc INTO temp;
205:
206: IF (c_assoc%NOTFOUND) THEN
207: CLOSE c_assoc;
208: RETURN FND_API.g_false;
209: ELSE
210: CLOSE c_assoc;
211: RETURN FND_API.g_false;
212: END IF;

Line 211: RETURN FND_API.g_false;

207: CLOSE c_assoc;
208: RETURN FND_API.g_false;
209: ELSE
210: CLOSE c_assoc;
211: RETURN FND_API.g_false;
212: END IF;
213: ELSE
214: RETURN FND_API.g_false;
215: END IF;

Line 214: RETURN FND_API.g_false;

210: CLOSE c_assoc;
211: RETURN FND_API.g_false;
212: END IF;
213: ELSE
214: RETURN FND_API.g_false;
215: END IF;
216: END isValidAssoc;
217:
218:

Line 248: RETURN FND_API.g_false;

244: FETCH c_attach INTO temp;
245:
246: IF (c_attach%NOTFOUND) THEN
247: CLOSE c_attach;
248: RETURN FND_API.g_false;
249: ELSE
250: CLOSE c_attach;
251: RETURN FND_API.g_true;
252: END IF;

Line 251: RETURN FND_API.g_true;

247: CLOSE c_attach;
248: RETURN FND_API.g_false;
249: ELSE
250: CLOSE c_attach;
251: RETURN FND_API.g_true;
252: END IF;
253: ELSE
254: RETURN FND_API.g_false;
255: END IF;

Line 254: RETURN FND_API.g_false;

250: CLOSE c_attach;
251: RETURN FND_API.g_true;
252: END IF;
253: ELSE
254: RETURN FND_API.g_false;
255: END IF;
256: END isValidAttachment;
257:
258:

Line 287: RETURN FND_API.g_false;

283: fetch c_assoc into temp;
284:
285: if (c_assoc%NOTFOUND) then
286: close c_assoc;
287: RETURN FND_API.g_false;
288: else
289: close c_assoc;
290: RETURN FND_API.g_true;
291: end if;

Line 290: RETURN FND_API.g_true;

286: close c_assoc;
287: RETURN FND_API.g_false;
288: else
289: close c_assoc;
290: RETURN FND_API.g_true;
291: end if;
292: ELSE
293: RETURN FND_API.g_false;
294: END IF;

Line 293: RETURN FND_API.g_false;

289: close c_assoc;
290: RETURN FND_API.g_true;
291: end if;
292: ELSE
293: RETURN FND_API.g_false;
294: END IF;
295: END isValidAssocType;
296:
297:

Line 330: RETURN FND_API.g_false;

326: fetch c_acode into temp;
327:
328: if (c_acode%NOTFOUND) then
329: CLOSE c_acode;
330: RETURN FND_API.g_false;
331: else
332: CLOSE c_acode;
333: RETURN FND_API.g_true;
334: end if;

Line 333: RETURN FND_API.g_true;

329: CLOSE c_acode;
330: RETURN FND_API.g_false;
331: else
332: CLOSE c_acode;
333: RETURN FND_API.g_true;
334: end if;
335: ELSE
336: RETURN FND_API.g_false;
337: END IF;

Line 336: RETURN FND_API.g_false;

332: CLOSE c_acode;
333: RETURN FND_API.g_true;
334: end if;
335: ELSE
336: RETURN FND_API.g_false;
337: END IF;
338: END isValidAttrCode;
339:
340:

Line 370: RETURN FND_API.g_false;

366: fetch c_verid into temp;
367:
368: if (c_verid%NOTFOUND) then
369: close c_verid;
370: RETURN FND_API.g_false;
371: else
372: close c_verid;
373: RETURN FND_API.g_true;
374: end if;

Line 373: RETURN FND_API.g_true;

369: close c_verid;
370: RETURN FND_API.g_false;
371: else
372: close c_verid;
373: RETURN FND_API.g_true;
374: end if;
375: ELSE
376: RETURN FND_API.g_false;
377: END IF;

Line 376: RETURN FND_API.g_false;

372: close c_verid;
373: RETURN FND_API.g_true;
374: end if;
375: ELSE
376: RETURN FND_API.g_false;
377: END IF;
378: END isValidCitemVer;
379:
380:

Line 408: RETURN FND_API.g_false;

404: fetch c_verid into temp;
405:
406: if (c_verid%NOTFOUND) then
407: close c_verid;
408: RETURN FND_API.g_false;
409: else
410: close c_verid;
411: RETURN FND_API.g_true;
412: end if;

Line 411: RETURN FND_API.g_true;

407: close c_verid;
408: RETURN FND_API.g_false;
409: else
410: close c_verid;
411: RETURN FND_API.g_true;
412: end if;
413: ELSE
414: RETURN FND_API.g_false;
415: END IF;

Line 414: RETURN FND_API.g_false;

410: close c_verid;
411: RETURN FND_API.g_true;
412: end if;
413: ELSE
414: RETURN FND_API.g_false;
415: END IF;
416: END isValidCitemVerForCitem;
417:
418:

Line 447: RETURN FND_API.g_false;

443: fetch c_citem into temp;
444:
445: IF (c_citem%NOTFOUND) THEN
446: close c_citem;
447: RETURN FND_API.g_false;
448: ELSE
449: close c_citem;
450: RETURN FND_API.g_true;
451: END IF;

Line 450: RETURN FND_API.g_true;

446: close c_citem;
447: RETURN FND_API.g_false;
448: ELSE
449: close c_citem;
450: RETURN FND_API.g_true;
451: END IF;
452: ELSE
453: RETURN FND_API.g_false;
454: END IF;

Line 453: RETURN FND_API.g_false;

449: close c_citem;
450: RETURN FND_API.g_true;
451: END IF;
452: ELSE
453: RETURN FND_API.g_false;
454: END IF;
455: END isValidCitem;
456:
457:

Line 482: RETURN FND_API.g_false;

478: fetch c_language into l_dummy;
479:
480: IF (c_language%NOTFOUND) THEN
481: close c_language;
482: RETURN FND_API.g_false;
483: ELSE
484: close c_language;
485: RETURN FND_API.g_true;
486: END IF;

Line 485: RETURN FND_API.g_true;

481: close c_language;
482: RETURN FND_API.g_false;
483: ELSE
484: close c_language;
485: RETURN FND_API.g_true;
486: END IF;
487: ELSE
488: RETURN FND_API.g_true;
489: END IF;

Line 488: RETURN FND_API.g_true;

484: close c_language;
485: RETURN FND_API.g_true;
486: END IF;
487: ELSE
488: RETURN FND_API.g_true;
489: END IF;
490: END isValidLanguage;
491:
492:

Line 520: RETURN FND_API.g_false;

516: fetch c_ctype into temp;
517:
518: IF(c_ctype%NOTFOUND) THEN
519: CLOSE c_ctype;
520: RETURN FND_API.g_false;
521: ELSE
522: CLOSE c_ctype;
523: RETURN FND_API.g_true;
524: END IF;

Line 523: RETURN FND_API.g_true;

519: CLOSE c_ctype;
520: RETURN FND_API.g_false;
521: ELSE
522: CLOSE c_ctype;
523: RETURN FND_API.g_true;
524: END IF;
525: ELSE
526: RETURN FND_API.g_false;
527: END IF;

Line 526: RETURN FND_API.g_false;

522: CLOSE c_ctype;
523: RETURN FND_API.g_true;
524: END IF;
525: ELSE
526: RETURN FND_API.g_false;
527: END IF;
528: END isValidCType;
529:
530:

Line 559: RETURN FND_API.g_false;

555: fetch c_dnode into temp;
556:
557: IF(c_dnode%NOTFOUND) THEN
558: CLOSE c_dnode;
559: RETURN FND_API.g_false;
560: ELSE
561: CLOSE c_dnode;
562: RETURN FND_API.g_true;
563: END IF;

Line 562: RETURN FND_API.g_true;

558: CLOSE c_dnode;
559: RETURN FND_API.g_false;
560: ELSE
561: CLOSE c_dnode;
562: RETURN FND_API.g_true;
563: END IF;
564: ELSE
565: RETURN FND_API.g_false;
566: END IF;

Line 565: RETURN FND_API.g_false;

561: CLOSE c_dnode;
562: RETURN FND_API.g_true;
563: END IF;
564: ELSE
565: RETURN FND_API.g_false;
566: END IF;
567: END isValidDirNode;
568:
569:

Line 600: RETURN FND_API.g_false;

596: fetch c_lob into temp;
597:
598: IF(c_lob%NOTFOUND) THEN
599: CLOSE c_lob;
600: RETURN FND_API.g_false;
601: ELSE
602: CLOSE c_lob;
603: RETURN FND_API.g_true;
604: END IF;

Line 603: RETURN FND_API.g_true;

599: CLOSE c_lob;
600: RETURN FND_API.g_false;
601: ELSE
602: CLOSE c_lob;
603: RETURN FND_API.g_true;
604: END IF;
605: ELSE
606: RETURN FND_API.g_false;
607: END IF;

Line 606: RETURN FND_API.g_false;

602: CLOSE c_lob;
603: RETURN FND_API.g_true;
604: END IF;
605: ELSE
606: RETURN FND_API.g_false;
607: END IF;
608: END isValidLob;
609:
610:

Line 639: RETURN FND_API.g_false;

635:
636: BEGIN
637:
638: if (f_resource_id IS NULL or f_resource_type IS NULL) then
639: RETURN FND_API.g_false;
640: end if;
641:
642: if (UPPER(f_resource_type) = 'USER') then
643: open c_user;

Line 648: RETURN FND_API.g_false;

644: fetch c_user into temp;
645:
646: if (c_user%NOTFOUND) then
647: close c_user;
648: RETURN FND_API.g_false;
649: else
650: close c_user;
651: RETURN FND_API.g_true;
652: end if;

Line 651: RETURN FND_API.g_true;

647: close c_user;
648: RETURN FND_API.g_false;
649: else
650: close c_user;
651: RETURN FND_API.g_true;
652: end if;
653: else
654: open c_resource;
655: fetch c_resource into temp;

Line 659: RETURN FND_API.g_false;

655: fetch c_resource into temp;
656:
657: if (c_resource%NOTFOUND) then
658: close c_resource;
659: RETURN FND_API.g_false;
660: else
661: close c_resource;
662: RETURN FND_API.g_true;
663: end if;

Line 662: RETURN FND_API.g_true;

658: close c_resource;
659: RETURN FND_API.g_false;
660: else
661: close c_resource;
662: RETURN FND_API.g_true;
663: end if;
664: end if;
665: END isValidResource;
666:

Line 691: RETURN FND_API.g_false;

687: fetch c_user into temp;
688:
689: if (c_user%NOTFOUND) then
690: close c_user;
691: RETURN FND_API.g_false;
692: else
693: close c_user;
694: RETURN FND_API.g_true;
695: end if;

Line 694: RETURN FND_API.g_true;

690: close c_user;
691: RETURN FND_API.g_false;
692: else
693: close c_user;
694: RETURN FND_API.g_true;
695: end if;
696: else
697: RETURN FND_API.g_false;
698: end if;

Line 697: RETURN FND_API.g_false;

693: close c_user;
694: RETURN FND_API.g_true;
695: end if;
696: else
697: RETURN FND_API.g_false;
698: end if;
699: END isValidUser;
700:
701:

Line 723: RETURN FND_API.g_true;

719: (f_status = IBC_UTILITIES_PUB.G_STV_ARCHIVED) or
720: (f_status = IBC_UTILITIES_PUB.G_STV_WORK_IN_PROGRESS) or
721: (f_status = IBC_UTILITIES_PUB.G_STV_REJECTED) ) then
722:
723: RETURN FND_API.g_true;
724: else
725: RETURN FND_API.g_false;
726: end if;
727: END isValidStatus;

Line 725: RETURN FND_API.g_false;

721: (f_status = IBC_UTILITIES_PUB.G_STV_REJECTED) ) then
722:
723: RETURN FND_API.g_true;
724: else
725: RETURN FND_API.g_false;
726: end if;
727: END isValidStatus;
728:
729:

Line 758: RETURN FND_API.g_false;

754: fetch c_label into temp;
755:
756: IF(c_label%NOTFOUND) THEN
757: CLOSE c_label;
758: RETURN FND_API.g_false;
759: ELSE
760: CLOSE c_label;
761: RETURN FND_API.g_true;
762: END IF;

Line 761: RETURN FND_API.g_true;

757: CLOSE c_label;
758: RETURN FND_API.g_false;
759: ELSE
760: CLOSE c_label;
761: RETURN FND_API.g_true;
762: END IF;
763: ELSE
764: RETURN FND_API.g_false;
765: END IF;

Line 764: RETURN FND_API.g_false;

760: CLOSE c_label;
761: RETURN FND_API.g_true;
762: END IF;
763: ELSE
764: RETURN FND_API.g_false;
765: END IF;
766: END isValidLabel;
767:
768:

Line 785: IF FND_API.to_Boolean( p_init_msg_list ) THEN

781: x_msg_data OUT NOCOPY VARCHAR2)
782: IS
783: BEGIN
784: -- Initialize message list if p_init_msg_list is set to TRUE.
785: IF FND_API.to_Boolean( p_init_msg_list ) THEN
786: FND_MSG_PUB.initialize;
787: END IF;
788:
789: -- Initialize API return status to success

Line 790: x_return_status := FND_API.G_RET_STS_SUCCESS;

786: FND_MSG_PUB.initialize;
787: END IF;
788:
789: -- Initialize API return status to success
790: x_return_status := FND_API.G_RET_STS_SUCCESS;
791:
792: IF (p_notnull_column IS NULL OR p_notnull_column = FND_API.G_MISS_NUM) THEN
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 792: IF (p_notnull_column IS NULL OR p_notnull_column = FND_API.G_MISS_NUM) THEN

788:
789: -- Initialize API return status to success
790: x_return_status := FND_API.G_RET_STS_SUCCESS;
791:
792: IF (p_notnull_column IS NULL OR p_notnull_column = FND_API.G_MISS_NUM) THEN
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
795: FND_MESSAGE.Set_Name('IBC', 'API_MISSING_COLUMN');
796: FND_MESSAGE.Set_Token('COLUMN', p_column_name, FALSE);

Line 793: x_return_status := FND_API.G_RET_STS_ERROR;

789: -- Initialize API return status to success
790: x_return_status := FND_API.G_RET_STS_SUCCESS;
791:
792: IF (p_notnull_column IS NULL OR p_notnull_column = FND_API.G_MISS_NUM) THEN
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
795: FND_MESSAGE.Set_Name('IBC', 'API_MISSING_COLUMN');
796: FND_MESSAGE.Set_Token('COLUMN', p_column_name, FALSE);
797: FND_MSG_PUB.ADD;

Line 818: IF FND_API.to_Boolean( p_init_msg_list ) THEN

814: x_msg_data OUT NOCOPY VARCHAR2)
815: IS
816: BEGIN
817: -- Initialize message list if p_init_msg_list is set to TRUE.
818: IF FND_API.to_Boolean( p_init_msg_list ) THEN
819: FND_MSG_PUB.initialize;
820: END IF;
821:
822: -- Initialize API return status to success

Line 823: x_return_status := FND_API.G_RET_STS_SUCCESS;

819: FND_MSG_PUB.initialize;
820: END IF;
821:
822: -- Initialize API return status to success
823: x_return_status := FND_API.G_RET_STS_SUCCESS;
824:
825: IF (p_notnull_column IS NULL OR p_notnull_column = FND_API.G_MISS_CHAR) THEN
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 825: IF (p_notnull_column IS NULL OR p_notnull_column = FND_API.G_MISS_CHAR) THEN

821:
822: -- Initialize API return status to success
823: x_return_status := FND_API.G_RET_STS_SUCCESS;
824:
825: IF (p_notnull_column IS NULL OR p_notnull_column = FND_API.G_MISS_CHAR) THEN
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
828: FND_MESSAGE.Set_Name('IBC', 'API_MISSING_COLUMN');
829: FND_MESSAGE.Set_Token('COLUMN', p_column_name, FALSE);

Line 826: x_return_status := FND_API.G_RET_STS_ERROR;

822: -- Initialize API return status to success
823: x_return_status := FND_API.G_RET_STS_SUCCESS;
824:
825: IF (p_notnull_column IS NULL OR p_notnull_column = FND_API.G_MISS_CHAR) THEN
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
828: FND_MESSAGE.Set_Name('IBC', 'API_MISSING_COLUMN');
829: FND_MESSAGE.Set_Token('COLUMN', p_column_name, FALSE);
830: FND_MSG_PUB.ADD;

Line 842: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

838: END Validate_NotNULL_VARCHAR2;
839:
840:
841: PROCEDURE Validate_Content_Type_Status (
842: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
843: p_Content_Type_Status IN VARCHAR2,
844: X_Return_Status OUT NOCOPY VARCHAR2,
845: X_Msg_Count OUT NOCOPY NUMBER,
846: X_Msg_Data OUT NOCOPY VARCHAR2)

Line 860: IF FND_API.to_Boolean( p_init_msg_list ) THEN

856:
857: BEGIN
858:
859: -- Initialize message list if p_init_msg_list is set to TRUE.
860: IF FND_API.to_Boolean( p_init_msg_list ) THEN
861: FND_MSG_PUB.initialize;
862: END IF;
863:
864: -- Initialize API return status to success

Line 865: x_return_status := FND_API.G_RET_STS_SUCCESS;

861: FND_MSG_PUB.initialize;
862: END IF;
863:
864: -- Initialize API return status to success
865: x_return_status := FND_API.G_RET_STS_SUCCESS;
866:
867: IF (p_Content_Type_Status IS NOT NULL AND p_Content_Type_Status <> FND_API.G_MISS_CHAR) THEN
868: OPEN C_Content_Type_Status;
869: FETCH C_Content_Type_Status INTO l_Content_Type_Status;

Line 867: IF (p_Content_Type_Status IS NOT NULL AND p_Content_Type_Status <> FND_API.G_MISS_CHAR) THEN

863:
864: -- Initialize API return status to success
865: x_return_status := FND_API.G_RET_STS_SUCCESS;
866:
867: IF (p_Content_Type_Status IS NOT NULL AND p_Content_Type_Status <> FND_API.G_MISS_CHAR) THEN
868: OPEN C_Content_Type_Status;
869: FETCH C_Content_Type_Status INTO l_Content_Type_Status;
870: IF (C_Content_Type_Status%NOTFOUND) THEN
871: CLOSE C_Content_Type_Status;

Line 872: x_return_status := FND_API.G_RET_STS_ERROR;

868: OPEN C_Content_Type_Status;
869: FETCH C_Content_Type_Status INTO l_Content_Type_Status;
870: IF (C_Content_Type_Status%NOTFOUND) THEN
871: CLOSE C_Content_Type_Status;
872: x_return_status := FND_API.G_RET_STS_ERROR;
873: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
874: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
875: FND_MESSAGE.Set_Token('COLUMN', 'CONTENT_TYPE_STATUS', FALSE);
876: FND_MSG_PUB.ADD;

Line 886: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

882:
883: END Validate_Content_Type_Status;
884:
885: PROCEDURE Validate_appl_short_name (
886: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
887: p_appl_short_name IN VARCHAR2,
888: x_application_id OUT NOCOPY NUMBER,
889: X_Return_Status OUT NOCOPY VARCHAR2,
890: X_Msg_Count OUT NOCOPY NUMBER,

Line 902: IF FND_API.to_Boolean( p_init_msg_list ) THEN

898: BEGIN
899:
900:
901: -- Initialize message list if p_init_msg_list is set to TRUE.
902: IF FND_API.to_Boolean( p_init_msg_list ) THEN
903: FND_MSG_PUB.initialize;
904: END IF;
905:
906: -- Initialize API return status to success

Line 907: x_return_status := FND_API.G_RET_STS_SUCCESS;

903: FND_MSG_PUB.initialize;
904: END IF;
905:
906: -- Initialize API return status to success
907: x_return_status := FND_API.G_RET_STS_SUCCESS;
908:
909: IF (p_appl_short_name IS NOT NULL AND p_appl_short_name <> FND_API.G_MISS_CHAR) THEN
910: OPEN C_Get_Appl_Id (p_appl_short_name);
911: FETCH C_Get_Appl_Id INTO x_application_id;

Line 909: IF (p_appl_short_name IS NOT NULL AND p_appl_short_name <> FND_API.G_MISS_CHAR) THEN

905:
906: -- Initialize API return status to success
907: x_return_status := FND_API.G_RET_STS_SUCCESS;
908:
909: IF (p_appl_short_name IS NOT NULL AND p_appl_short_name <> FND_API.G_MISS_CHAR) THEN
910: OPEN C_Get_Appl_Id (p_appl_short_name);
911: FETCH C_Get_Appl_Id INTO x_application_id;
912: IF (C_Get_Appl_Id%NOTFOUND) THEN
913: CLOSE C_Get_Appl_Id;

Line 914: x_return_status := FND_API.G_RET_STS_ERROR;

910: OPEN C_Get_Appl_Id (p_appl_short_name);
911: FETCH C_Get_Appl_Id INTO x_application_id;
912: IF (C_Get_Appl_Id%NOTFOUND) THEN
913: CLOSE C_Get_Appl_Id;
914: x_return_status := FND_API.G_RET_STS_ERROR;
915: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
916: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
917: FND_MESSAGE.Set_Token('COLUMN', 'APPLICATION SHORT NAME', FALSE);
918: FND_MSG_PUB.ADD;

Line 929: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

925: END Validate_appl_short_name;
926:
927:
928: PROCEDURE Validate_application_id (
929: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
930: p_application_id IN NUMBER,
931: X_Return_Status OUT NOCOPY VARCHAR2,
932: X_Msg_Count OUT NOCOPY NUMBER,
933: X_Msg_Data OUT NOCOPY VARCHAR2)

Line 946: IF FND_API.to_Boolean( p_init_msg_list ) THEN

942: BEGIN
943:
944:
945: -- Initialize message list if p_init_msg_list is set to TRUE.
946: IF FND_API.to_Boolean( p_init_msg_list ) THEN
947: FND_MSG_PUB.initialize;
948: END IF;
949:
950: -- Initialize API return status to success

Line 951: x_return_status := FND_API.G_RET_STS_SUCCESS;

947: FND_MSG_PUB.initialize;
948: END IF;
949:
950: -- Initialize API return status to success
951: x_return_status := FND_API.G_RET_STS_SUCCESS;
952:
953: IF (p_application_id IS NOT NULL AND p_application_id <> FND_API.G_MISS_NUM) THEN
954: OPEN C_Get_Appl_Id;
955: FETCH C_Get_Appl_Id INTO l_temp;

Line 953: IF (p_application_id IS NOT NULL AND p_application_id <> FND_API.G_MISS_NUM) THEN

949:
950: -- Initialize API return status to success
951: x_return_status := FND_API.G_RET_STS_SUCCESS;
952:
953: IF (p_application_id IS NOT NULL AND p_application_id <> FND_API.G_MISS_NUM) THEN
954: OPEN C_Get_Appl_Id;
955: FETCH C_Get_Appl_Id INTO l_temp;
956: IF (C_Get_Appl_Id%NOTFOUND) THEN
957: CLOSE C_Get_Appl_Id;

Line 958: x_return_status := FND_API.G_RET_STS_ERROR;

954: OPEN C_Get_Appl_Id;
955: FETCH C_Get_Appl_Id INTO l_temp;
956: IF (C_Get_Appl_Id%NOTFOUND) THEN
957: CLOSE C_Get_Appl_Id;
958: x_return_status := FND_API.G_RET_STS_ERROR;
959: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
960: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
961: FND_MESSAGE.Set_Token('COLUMN', 'APPLICATION ID', FALSE);
962: FND_MSG_PUB.ADD;

Line 973: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

969: END Validate_application_id;
970:
971:
972: PROCEDURE Validate_Content_Type_Code (
973: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
974: p_Content_type_Code IN VARCHAR2,
975: X_Return_Status OUT NOCOPY VARCHAR2,
976: X_Msg_Count OUT NOCOPY NUMBER,
977: X_Msg_Data OUT NOCOPY VARCHAR2)

Line 989: IF FND_API.to_Boolean( p_init_msg_list ) THEN

985:
986: BEGIN
987:
988: -- Initialize message list if p_init_msg_list is set to TRUE.
989: IF FND_API.to_Boolean( p_init_msg_list ) THEN
990: FND_MSG_PUB.initialize;
991: END IF;
992:
993: -- Initialize API return status to success

Line 994: x_return_status := FND_API.G_RET_STS_SUCCESS;

990: FND_MSG_PUB.initialize;
991: END IF;
992:
993: -- Initialize API return status to success
994: x_return_status := FND_API.G_RET_STS_SUCCESS;
995:
996: IF (p_Content_type_Code IS NOT NULL AND p_Content_type_Code <> FND_API.G_MISS_CHAR) THEN
997: OPEN C_CType_Code;
998: FETCH C_CType_Code INTO l_temp;

Line 996: IF (p_Content_type_Code IS NOT NULL AND p_Content_type_Code <> FND_API.G_MISS_CHAR) THEN

992:
993: -- Initialize API return status to success
994: x_return_status := FND_API.G_RET_STS_SUCCESS;
995:
996: IF (p_Content_type_Code IS NOT NULL AND p_Content_type_Code <> FND_API.G_MISS_CHAR) THEN
997: OPEN C_CType_Code;
998: FETCH C_CType_Code INTO l_temp;
999: IF (C_CType_Code%NOTFOUND) THEN
1000: CLOSE C_CType_Code;

Line 1001: x_return_status := FND_API.G_RET_STS_ERROR;

997: OPEN C_CType_Code;
998: FETCH C_CType_Code INTO l_temp;
999: IF (C_CType_Code%NOTFOUND) THEN
1000: CLOSE C_CType_Code;
1001: x_return_status := FND_API.G_RET_STS_ERROR;
1002: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1003: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1004: FND_MESSAGE.Set_Token('COLUMN', 'CONTENT TYPE CODE', FALSE);
1005: FND_MSG_PUB.ADD;

Line 1016: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1012: END Validate_Content_Type_Code;
1013:
1014:
1015: PROCEDURE Validate_Data_Type_Code (
1016: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1017: p_Data_type_Code IN VARCHAR2,
1018: X_Return_Status OUT NOCOPY VARCHAR2,
1019: X_Msg_Count OUT NOCOPY NUMBER,
1020: X_Msg_Data OUT NOCOPY VARCHAR2)

Line 1033: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1029:
1030: BEGIN
1031:
1032: -- Initialize message list if p_init_msg_list is set to TRUE.
1033: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1034: FND_MSG_PUB.initialize;
1035: END IF;
1036:
1037: -- Initialize API return status to success

Line 1038: x_return_status := FND_API.G_RET_STS_SUCCESS;

1034: FND_MSG_PUB.initialize;
1035: END IF;
1036:
1037: -- Initialize API return status to success
1038: x_return_status := FND_API.G_RET_STS_SUCCESS;
1039:
1040: -- Data Type Code cannot be NULL
1041: IF (p_Data_type_Code IS NOT NULL AND p_Data_type_Code <> FND_API.G_MISS_CHAR) THEN
1042: OPEN C_Data_type_Code;

Line 1041: IF (p_Data_type_Code IS NOT NULL AND p_Data_type_Code <> FND_API.G_MISS_CHAR) THEN

1037: -- Initialize API return status to success
1038: x_return_status := FND_API.G_RET_STS_SUCCESS;
1039:
1040: -- Data Type Code cannot be NULL
1041: IF (p_Data_type_Code IS NOT NULL AND p_Data_type_Code <> FND_API.G_MISS_CHAR) THEN
1042: OPEN C_Data_type_Code;
1043: FETCH C_Data_type_Code INTO l_Data_type_Code;
1044: IF (C_Data_type_Code%NOTFOUND) THEN
1045: CLOSE C_Data_type_Code;

Line 1046: x_return_status := FND_API.G_RET_STS_ERROR;

1042: OPEN C_Data_type_Code;
1043: FETCH C_Data_type_Code INTO l_Data_type_Code;
1044: IF (C_Data_type_Code%NOTFOUND) THEN
1045: CLOSE C_Data_type_Code;
1046: x_return_status := FND_API.G_RET_STS_ERROR;
1047: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1048: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1049: FND_MESSAGE.Set_Token('COLUMN', 'DATA_TYPE_CODE', FALSE);
1050: FND_MSG_PUB.ADD;

Line 1061: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1057: END Validate_Data_Type_Code;
1058:
1059:
1060: PROCEDURE Validate_Default_value (
1061: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1062: p_data_type_code IN VARCHAR2,
1063: p_Default_value IN VARCHAR2,
1064: X_Return_Status OUT NOCOPY VARCHAR2,
1065: X_Msg_Count OUT NOCOPY NUMBER,

Line 1073: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1069: BEGIN
1070:
1071:
1072: -- Initialize message list if p_init_msg_list is set to TRUE.
1073: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1074: FND_MSG_PUB.initialize;
1075: END IF;
1076:
1077: -- Initialize API return status to success

Line 1078: x_return_status := FND_API.G_RET_STS_SUCCESS;

1074: FND_MSG_PUB.initialize;
1075: END IF;
1076:
1077: -- Initialize API return status to success
1078: x_return_status := FND_API.G_RET_STS_SUCCESS;
1079:
1080:
1081: IF (p_Default_value IS NULL OR p_Default_value = FND_API.G_MISS_CHAR) THEN
1082: RETURN;

Line 1081: IF (p_Default_value IS NULL OR p_Default_value = FND_API.G_MISS_CHAR) THEN

1077: -- Initialize API return status to success
1078: x_return_status := FND_API.G_RET_STS_SUCCESS;
1079:
1080:
1081: IF (p_Default_value IS NULL OR p_Default_value = FND_API.G_MISS_CHAR) THEN
1082: RETURN;
1083: END IF;
1084:
1085: -- Check for valid Default_value is NOT NULL

Line 1117: x_return_status := FND_API.G_RET_STS_ERROR;

1113: OPEN C_content_item_id;
1114: FETCH C_content_item_id INTO l_content_item_id;
1115: IF (C_content_item_id%NOTFOUND) THEN
1116: CLOSE C_content_item_id;
1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1119: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1120: FND_MESSAGE.Set_Token('COLUMN', 'DEFAULT VALUE', FALSE);
1121: FND_MSG_PUB.ADD;

Line 1142: x_return_status := FND_API.G_RET_STS_ERROR;

1138: OPEN C_file_id;
1139: FETCH C_file_id INTO l_file_id;
1140: IF (C_file_id%NOTFOUND) THEN
1141: CLOSE C_file_id;
1142: x_return_status := FND_API.G_RET_STS_ERROR;
1143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1144: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1145: FND_MESSAGE.Set_Token('COLUMN', 'DEFAULT VALUE', FALSE);
1146: FND_MSG_PUB.ADD;

Line 1159: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1155:
1156: END Validate_Default_value;
1157:
1158: PROCEDURE Validate_Reference_Code (
1159: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1160: p_data_type_code IN VARCHAR2,
1161: p_Reference_Code IN VARCHAR2,
1162: X_Return_Status OUT NOCOPY VARCHAR2,
1163: X_Msg_Count OUT NOCOPY NUMBER,

Line 1168: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1164: X_Msg_Data OUT NOCOPY VARCHAR2)
1165: IS
1166: BEGIN
1167: -- Initialize message list if p_init_msg_list is set to TRUE.
1168: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1169: FND_MSG_PUB.initialize;
1170: END IF;
1171:
1172: -- Initialize API return status to success

Line 1173: x_return_status := FND_API.G_RET_STS_SUCCESS;

1169: FND_MSG_PUB.initialize;
1170: END IF;
1171:
1172: -- Initialize API return status to success
1173: x_return_status := FND_API.G_RET_STS_SUCCESS;
1174:
1175: IF p_data_type_code = 'component' THEN
1176:
1177: -- For CITEM the reference code must refer to a valid Content Type Code

Line 1178: IF (p_reference_code IS NULL OR p_reference_code = FND_API.G_MISS_CHAR) THEN

1174:
1175: IF p_data_type_code = 'component' THEN
1176:
1177: -- For CITEM the reference code must refer to a valid Content Type Code
1178: IF (p_reference_code IS NULL OR p_reference_code = FND_API.G_MISS_CHAR) THEN
1179: x_return_status := FND_API.G_RET_STS_ERROR;
1180: ELSE
1181:
1182: Validate_Content_Type_Code (

Line 1179: x_return_status := FND_API.G_RET_STS_ERROR;

1175: IF p_data_type_code = 'component' THEN
1176:
1177: -- For CITEM the reference code must refer to a valid Content Type Code
1178: IF (p_reference_code IS NULL OR p_reference_code = FND_API.G_MISS_CHAR) THEN
1179: x_return_status := FND_API.G_RET_STS_ERROR;
1180: ELSE
1181:
1182: Validate_Content_Type_Code (
1183: p_init_msg_list => p_init_msg_list,

Line 1191: IF (p_reference_code IS NOT NULL AND p_reference_code <> FND_API.G_MISS_CHAR) THEN

1187: X_Msg_Data => X_Msg_Data);
1188: END IF;
1189:
1190: ELSE
1191: IF (p_reference_code IS NOT NULL AND p_reference_code <> FND_API.G_MISS_CHAR) THEN
1192: x_return_status := FND_API.G_RET_STS_ERROR;
1193: END IF;
1194:
1195: END IF;

Line 1192: x_return_status := FND_API.G_RET_STS_ERROR;

1188: END IF;
1189:
1190: ELSE
1191: IF (p_reference_code IS NOT NULL AND p_reference_code <> FND_API.G_MISS_CHAR) THEN
1192: x_return_status := FND_API.G_RET_STS_ERROR;
1193: END IF;
1194:
1195: END IF;
1196:

Line 1197: IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

1193: END IF;
1194:
1195: END IF;
1196:
1197: IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1198: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1199: FND_MESSAGE.Set_Token('COLUMN', 'Reference Code', FALSE);
1200: FND_MSG_PUB.ADD;
1201: END IF;

Line 1206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1202:
1203: END Validate_Reference_Code;
1204:
1205: PROCEDURE Validate_Min_Max_Instances (
1206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1207: p_Max_Instances IN NUMBER,
1208: p_Min_Instances IN NUMBER,
1209: X_Return_Status OUT NOCOPY VARCHAR2,
1210: X_Msg_Count OUT NOCOPY NUMBER,

Line 1216: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1212: IS
1213: BEGIN
1214:
1215: -- Initialize message list if p_init_msg_list is set to TRUE.
1216: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1217: FND_MSG_PUB.initialize;
1218: END IF;
1219:
1220: -- Initialize API return status to success

Line 1221: x_return_status := FND_API.G_RET_STS_SUCCESS;

1217: FND_MSG_PUB.initialize;
1218: END IF;
1219:
1220: -- Initialize API return status to success
1221: x_return_status := FND_API.G_RET_STS_SUCCESS;
1222:
1223: -- Max Instance cannot be greater than Min Instances
1224: IF (p_MAX_Instances < 1 OR p_min_instances < 0 OR NVL(p_Max_Instances,p_Min_Instances+1) < p_Min_Instances ) THEN
1225: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1225: x_return_status := FND_API.G_RET_STS_ERROR;

1221: x_return_status := FND_API.G_RET_STS_SUCCESS;
1222:
1223: -- Max Instance cannot be greater than Min Instances
1224: IF (p_MAX_Instances < 1 OR p_min_instances < 0 OR NVL(p_Max_Instances,p_Min_Instances+1) < p_Min_Instances ) THEN
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1227: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1228: FND_MESSAGE.Set_Token('COLUMN','MAX Instances', FALSE);
1229: FND_MSG_PUB.ADD;

Line 1256: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1252:
1253: BEGIN
1254:
1255: -- Initialize message list if p_init_msg_list is set to TRUE.
1256: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1257: FND_MSG_PUB.initialize;
1258: END IF;
1259:
1260: -- Initialize API return status to success

Line 1261: x_return_status := FND_API.G_RET_STS_SUCCESS;

1257: FND_MSG_PUB.initialize;
1258: END IF;
1259:
1260: -- Initialize API return status to success
1261: x_return_status := FND_API.G_RET_STS_SUCCESS;
1262:
1263: IF (p_resource_id IS NOT NULL AND p_resource_id <> FND_API.G_MISS_NUM) THEN
1264: OPEN C_jtf_resources;
1265: FETCH C_jtf_resources INTO l_tmp;

Line 1263: IF (p_resource_id IS NOT NULL AND p_resource_id <> FND_API.G_MISS_NUM) THEN

1259:
1260: -- Initialize API return status to success
1261: x_return_status := FND_API.G_RET_STS_SUCCESS;
1262:
1263: IF (p_resource_id IS NOT NULL AND p_resource_id <> FND_API.G_MISS_NUM) THEN
1264: OPEN C_jtf_resources;
1265: FETCH C_jtf_resources INTO l_tmp;
1266: IF (C_jtf_resources%NOTFOUND) THEN
1267: CLOSE C_jtf_resources;

Line 1268: x_return_status := FND_API.G_RET_STS_ERROR;

1264: OPEN C_jtf_resources;
1265: FETCH C_jtf_resources INTO l_tmp;
1266: IF (C_jtf_resources%NOTFOUND) THEN
1267: CLOSE C_jtf_resources;
1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1270: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1271: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE_ID', FALSE);
1272: FND_MSG_PUB.ADD;

Line 1312: RETURN FND_API.g_false;

1308: fetch c_app into temp;
1309:
1310: if (c_app%NOTFOUND) then
1311: close c_app;
1312: RETURN FND_API.g_false;
1313: else
1314: close c_app;
1315: RETURN FND_API.g_true;
1316: end if;

Line 1315: RETURN FND_API.g_true;

1311: close c_app;
1312: RETURN FND_API.g_false;
1313: else
1314: close c_app;
1315: RETURN FND_API.g_true;
1316: end if;
1317: END isTranslationApproved;
1318:
1319: