DBA Data[Home] [Help]

APPS.IBC_CV_LABEL_GRP dependencies on FND_MESSAGE

Line 56: Fnd_Message.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');

52: IF Fnd_Global.User_Id IS NULL
53: THEN
54: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
55: THEN
56: Fnd_Message.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
57: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);
58: Fnd_Msg_Pub.ADD;
59: END IF;
60: RAISE Fnd_Api.G_EXC_ERROR;

Line 57: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);

53: THEN
54: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
55: THEN
56: Fnd_Message.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
57: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);
58: Fnd_Msg_Pub.ADD;
59: END IF;
60: RAISE Fnd_Api.G_EXC_ERROR;
61: END IF;

Line 67: Fnd_Message.Set_Name('IBC', 'INVALID_LABEL_CODE');

63: -- Check for all the NOT NULL Columns
64: -- CV_Label_Code Cannot be NULL and must exist in IBC_LABELS
65: IF (Ibc_Validate_Pvt.isValidLabel(l_CV_Label_rec.Label_code) = Fnd_Api.g_false) THEN
66: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
67: Fnd_Message.Set_Name('IBC', 'INVALID_LABEL_CODE');
68: Fnd_Message.Set_token('LABEL_CODE', l_CV_Label_rec.Label_code);
69: Fnd_Msg_Pub.ADD;
70: END IF;
71: -- Don't RAISE the EXCEPTION Yet. RUN ALL the validation procedures

Line 68: Fnd_Message.Set_token('LABEL_CODE', l_CV_Label_rec.Label_code);

64: -- CV_Label_Code Cannot be NULL and must exist in IBC_LABELS
65: IF (Ibc_Validate_Pvt.isValidLabel(l_CV_Label_rec.Label_code) = Fnd_Api.g_false) THEN
66: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
67: Fnd_Message.Set_Name('IBC', 'INVALID_LABEL_CODE');
68: Fnd_Message.Set_token('LABEL_CODE', l_CV_Label_rec.Label_code);
69: Fnd_Msg_Pub.ADD;
70: END IF;
71: -- Don't RAISE the EXCEPTION Yet. RUN ALL the validation procedures
72: -- and show Exceptions all at once.

Line 79: Fnd_Message.Set_Name('IBC', 'INVALID_CITEM_ID');

75:
76: -- Check if Content_item_id is Valid
77: IF (Ibc_Validate_Pvt.isValidCitem(l_CV_Label_rec.content_item_id) = Fnd_Api.g_false) THEN
78: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
79: Fnd_Message.Set_Name('IBC', 'INVALID_CITEM_ID');
80: Fnd_Message.Set_token('CITEM_ID', l_CV_Label_rec.content_item_id);
81: Fnd_Msg_Pub.ADD;
82: END IF;
83: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 80: Fnd_Message.Set_token('CITEM_ID', l_CV_Label_rec.content_item_id);

76: -- Check if Content_item_id is Valid
77: IF (Ibc_Validate_Pvt.isValidCitem(l_CV_Label_rec.content_item_id) = Fnd_Api.g_false) THEN
78: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
79: Fnd_Message.Set_Name('IBC', 'INVALID_CITEM_ID');
80: Fnd_Message.Set_token('CITEM_ID', l_CV_Label_rec.content_item_id);
81: Fnd_Msg_Pub.ADD;
82: END IF;
83: x_return_status := Fnd_Api.G_RET_STS_ERROR;
84: END IF;

Line 89: Fnd_Message.Set_Name('IBC', 'INVALID_CITEM_VERSION_ID');

85:
86: -- Check if Citem_Version_ID exists
87: IF (Ibc_Validate_Pvt.isValidCitemVer(l_CV_Label_rec.citem_version_id) = Fnd_Api.g_false) THEN
88: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
89: Fnd_Message.Set_Name('IBC', 'INVALID_CITEM_VERSION_ID');
90: Fnd_Message.Set_token('CITEM_VERSION_ID', l_CV_Label_rec.CITEM_VERSION_id);
91: Fnd_Msg_Pub.ADD;
92: END IF;
93: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 90: Fnd_Message.Set_token('CITEM_VERSION_ID', l_CV_Label_rec.CITEM_VERSION_id);

86: -- Check if Citem_Version_ID exists
87: IF (Ibc_Validate_Pvt.isValidCitemVer(l_CV_Label_rec.citem_version_id) = Fnd_Api.g_false) THEN
88: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
89: Fnd_Message.Set_Name('IBC', 'INVALID_CITEM_VERSION_ID');
90: Fnd_Message.Set_token('CITEM_VERSION_ID', l_CV_Label_rec.CITEM_VERSION_id);
91: Fnd_Msg_Pub.ADD;
92: END IF;
93: x_return_status := Fnd_Api.G_RET_STS_ERROR;
94: END IF;

Line 104: Fnd_Message.Set_Name('IBC', 'Label Code Already EXISTS');

100: OPEN C_CV_Label;
101: FETCH C_CV_Label INTO l_CV_Label_Code;
102: IF C_CV_Label%FOUND THEN
103: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
104: Fnd_Message.Set_Name('IBC', 'Label Code Already EXISTS');
105: Fnd_Message.Set_Token('COLUMN', 'Label_Code', FALSE);
106: Fnd_Msg_Pub.ADD;
107: END IF;
108: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 105: Fnd_Message.Set_Token('COLUMN', 'Label_Code', FALSE);

101: FETCH C_CV_Label INTO l_CV_Label_Code;
102: IF C_CV_Label%FOUND THEN
103: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
104: Fnd_Message.Set_Name('IBC', 'Label Code Already EXISTS');
105: Fnd_Message.Set_Token('COLUMN', 'Label_Code', FALSE);
106: Fnd_Msg_Pub.ADD;
107: END IF;
108: x_return_status := Fnd_Api.G_RET_STS_ERROR;
109: END IF;

Line 143: Fnd_Message.Set_Name('IBC', 'IBC_INSERT_ERROR');

139:
140:
141: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
142: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
143: Fnd_Message.Set_Name('IBC', 'IBC_INSERT_ERROR');
144: Fnd_Msg_Pub.ADD;
145: END IF;
146:
147: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 262: Fnd_Message.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');

258: IF Fnd_Global.User_Id IS NULL
259: THEN
260: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
261: THEN
262: Fnd_Message.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
263: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);
264: Fnd_Msg_Pub.ADD;
265: END IF;
266: RAISE Fnd_Api.G_EXC_ERROR;

Line 263: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);

259: THEN
260: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
261: THEN
262: Fnd_Message.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
263: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);
264: Fnd_Msg_Pub.ADD;
265: END IF;
266: RAISE Fnd_Api.G_EXC_ERROR;
267: END IF;

Line 273: Fnd_Message.Set_Name('IBC', 'INVALID_LABEL_CODE');

269: -- Check for all the NOT NULL Columns
270: -- CV_Label_Code Cannot be NULL and must exist in IBC_LABELS
271: IF (Ibc_Validate_Pvt.isValidLabel(l_CV_Label_rec.Label_code) = Fnd_Api.g_false) THEN
272: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
273: Fnd_Message.Set_Name('IBC', 'INVALID_LABEL_CODE');
274: Fnd_Message.Set_token('LABEL_CODE', l_CV_Label_rec.Label_code);
275: Fnd_Msg_Pub.ADD;
276: END IF;
277: -- Don't RAISE the EXCEPTION Yet. RUN ALL the validation procedures

Line 274: Fnd_Message.Set_token('LABEL_CODE', l_CV_Label_rec.Label_code);

270: -- CV_Label_Code Cannot be NULL and must exist in IBC_LABELS
271: IF (Ibc_Validate_Pvt.isValidLabel(l_CV_Label_rec.Label_code) = Fnd_Api.g_false) THEN
272: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
273: Fnd_Message.Set_Name('IBC', 'INVALID_LABEL_CODE');
274: Fnd_Message.Set_token('LABEL_CODE', l_CV_Label_rec.Label_code);
275: Fnd_Msg_Pub.ADD;
276: END IF;
277: -- Don't RAISE the EXCEPTION Yet. RUN ALL the validation procedures
278: -- and show Exceptions all at once.

Line 285: Fnd_Message.Set_Name('IBC', 'INVALID_CITEM_ID');

281:
282: -- Check if Content_item_id is Valid
283: IF (Ibc_Validate_Pvt.isValidCitem(l_CV_Label_rec.content_item_id) = Fnd_Api.g_false) THEN
284: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
285: Fnd_Message.Set_Name('IBC', 'INVALID_CITEM_ID');
286: Fnd_Message.Set_token('CITEM_ID', l_CV_Label_rec.content_item_id);
287: Fnd_Msg_Pub.ADD;
288: END IF;
289: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 286: Fnd_Message.Set_token('CITEM_ID', l_CV_Label_rec.content_item_id);

282: -- Check if Content_item_id is Valid
283: IF (Ibc_Validate_Pvt.isValidCitem(l_CV_Label_rec.content_item_id) = Fnd_Api.g_false) THEN
284: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
285: Fnd_Message.Set_Name('IBC', 'INVALID_CITEM_ID');
286: Fnd_Message.Set_token('CITEM_ID', l_CV_Label_rec.content_item_id);
287: Fnd_Msg_Pub.ADD;
288: END IF;
289: x_return_status := Fnd_Api.G_RET_STS_ERROR;
290: END IF;

Line 295: Fnd_Message.Set_Name('IBC', 'INVALID_CITEM_VERSION_ID');

291:
292: -- Check if Citem_Version_ID exists
293: IF (Ibc_Validate_Pvt.isValidCitemVer(l_CV_Label_rec.citem_version_id) = Fnd_Api.g_false) THEN
294: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
295: Fnd_Message.Set_Name('IBC', 'INVALID_CITEM_VERSION_ID');
296: Fnd_Message.Set_token('CITEM_VERSION_ID', l_CV_Label_rec.CITEM_VERSION_id);
297: Fnd_Msg_Pub.ADD;
298: END IF;
299: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 296: Fnd_Message.Set_token('CITEM_VERSION_ID', l_CV_Label_rec.CITEM_VERSION_id);

292: -- Check if Citem_Version_ID exists
293: IF (Ibc_Validate_Pvt.isValidCitemVer(l_CV_Label_rec.citem_version_id) = Fnd_Api.g_false) THEN
294: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
295: Fnd_Message.Set_Name('IBC', 'INVALID_CITEM_VERSION_ID');
296: Fnd_Message.Set_token('CITEM_VERSION_ID', l_CV_Label_rec.CITEM_VERSION_id);
297: Fnd_Msg_Pub.ADD;
298: END IF;
299: x_return_status := Fnd_Api.G_RET_STS_ERROR;
300: END IF;

Line 310: Fnd_Message.Set_Name('IBC', 'Label Code doesnot EXIST');

306: OPEN C_CV_Label;
307: FETCH C_CV_Label INTO l_CV_Label_Code;
308: IF C_CV_Label%NOTFOUND THEN
309: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
310: Fnd_Message.Set_Name('IBC', 'Label Code doesnot EXIST');
311: Fnd_Message.Set_Token('COLUMN', 'Label_Code', FALSE);
312: Fnd_Msg_Pub.ADD;
313: END IF;
314: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 311: Fnd_Message.Set_Token('COLUMN', 'Label_Code', FALSE);

307: FETCH C_CV_Label INTO l_CV_Label_Code;
308: IF C_CV_Label%NOTFOUND THEN
309: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
310: Fnd_Message.Set_Name('IBC', 'Label Code doesnot EXIST');
311: Fnd_Message.Set_Token('COLUMN', 'Label_Code', FALSE);
312: Fnd_Msg_Pub.ADD;
313: END IF;
314: x_return_status := Fnd_Api.G_RET_STS_ERROR;
315: END IF;

Line 343: Fnd_Message.Set_Name('IBC', 'IBC_UPDATE_ERROR');

339:
340:
341: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
342: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
343: Fnd_Message.Set_Name('IBC', 'IBC_UPDATE_ERROR');
344: Fnd_Msg_Pub.ADD;
345: END IF;
346:
347: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 461: Fnd_Message.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');

457: IF Fnd_Global.User_Id IS NULL
458: THEN
459: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
460: THEN
461: Fnd_Message.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
462: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);
463: Fnd_Msg_Pub.ADD;
464: END IF;
465: RAISE Fnd_Api.G_EXC_ERROR;

Line 462: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);

458: THEN
459: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
460: THEN
461: Fnd_Message.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
462: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);
463: Fnd_Msg_Pub.ADD;
464: END IF;
465: RAISE Fnd_Api.G_EXC_ERROR;
466: END IF;

Line 480: Fnd_Message.Set_Name('IBC', 'IBC_DELETE_ERROR');

476:
477:
478: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
479: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
480: Fnd_Message.Set_Name('IBC', 'IBC_DELETE_ERROR');
481: Fnd_Msg_Pub.ADD;
482: END IF;
483:
484: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 589: Fnd_Message.Set_Name('IBC', 'CItem Version Label RECORD Error');

585: WHEN NO_DATA_FOUND THEN
586: RAISE NO_DATA_FOUND;
587: WHEN OTHERS THEN
588: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
589: Fnd_Message.Set_Name('IBC', 'CItem Version Label RECORD Error');
590: Fnd_Msg_Pub.ADD;
591: END IF;
592: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
593: END Query_CV_Label_Row;

Line 670: Fnd_Message.Set_Name('IBC', 'API_INVALID_ID');

666: END LOOP;
667: EXCEPTION WHEN NO_DATA_FOUND THEN
668: --DBMS_OUTPUT.put_line('CitemVersionId Invalid....');
669: x_return_status := Fnd_Api.G_RET_STS_ERROR;
670: Fnd_Message.Set_Name('IBC', 'API_INVALID_ID');
671: Fnd_Message.Set_Token('COLUMN','p_citem_version_ids', FALSE);
672: Fnd_Message.Set_Token('VALUE','p_citem_version_ids(i)', FALSE);
673: Fnd_Msg_Pub.ADD;
674: RAISE Fnd_Api.G_EXC_ERROR;

Line 671: Fnd_Message.Set_Token('COLUMN','p_citem_version_ids', FALSE);

667: EXCEPTION WHEN NO_DATA_FOUND THEN
668: --DBMS_OUTPUT.put_line('CitemVersionId Invalid....');
669: x_return_status := Fnd_Api.G_RET_STS_ERROR;
670: Fnd_Message.Set_Name('IBC', 'API_INVALID_ID');
671: Fnd_Message.Set_Token('COLUMN','p_citem_version_ids', FALSE);
672: Fnd_Message.Set_Token('VALUE','p_citem_version_ids(i)', FALSE);
673: Fnd_Msg_Pub.ADD;
674: RAISE Fnd_Api.G_EXC_ERROR;
675: END;

Line 672: Fnd_Message.Set_Token('VALUE','p_citem_version_ids(i)', FALSE);

668: --DBMS_OUTPUT.put_line('CitemVersionId Invalid....');
669: x_return_status := Fnd_Api.G_RET_STS_ERROR;
670: Fnd_Message.Set_Name('IBC', 'API_INVALID_ID');
671: Fnd_Message.Set_Token('COLUMN','p_citem_version_ids', FALSE);
672: Fnd_Message.Set_Token('VALUE','p_citem_version_ids(i)', FALSE);
673: Fnd_Msg_Pub.ADD;
674: RAISE Fnd_Api.G_EXC_ERROR;
675: END;
676: ELSIF p_version_number.COUNT <> 0 THEN

Line 692: Fnd_Message.Set_Name('IBC', 'API_INVALID_ID');

688: END LOOP;
689: EXCEPTION WHEN NO_DATA_FOUND THEN
690: --DBMS_OUTPUT.put_line('CitemVersionId Invalid....');
691: x_return_status := Fnd_Api.G_RET_STS_ERROR;
692: Fnd_Message.Set_Name('IBC', 'API_INVALID_ID');
693: Fnd_Message.Set_Token('COLUMN','p_version_number', FALSE);
694: Fnd_Message.Set_Token('VALUE','p_version_number(i)',FALSE);
695: Fnd_Msg_Pub.ADD;
696: RAISE Fnd_Api.G_EXC_ERROR;

Line 693: Fnd_Message.Set_Token('COLUMN','p_version_number', FALSE);

689: EXCEPTION WHEN NO_DATA_FOUND THEN
690: --DBMS_OUTPUT.put_line('CitemVersionId Invalid....');
691: x_return_status := Fnd_Api.G_RET_STS_ERROR;
692: Fnd_Message.Set_Name('IBC', 'API_INVALID_ID');
693: Fnd_Message.Set_Token('COLUMN','p_version_number', FALSE);
694: Fnd_Message.Set_Token('VALUE','p_version_number(i)',FALSE);
695: Fnd_Msg_Pub.ADD;
696: RAISE Fnd_Api.G_EXC_ERROR;
697: END;

Line 694: Fnd_Message.Set_Token('VALUE','p_version_number(i)',FALSE);

690: --DBMS_OUTPUT.put_line('CitemVersionId Invalid....');
691: x_return_status := Fnd_Api.G_RET_STS_ERROR;
692: Fnd_Message.Set_Name('IBC', 'API_INVALID_ID');
693: Fnd_Message.Set_Token('COLUMN','p_version_number', FALSE);
694: Fnd_Message.Set_Token('VALUE','p_version_number(i)',FALSE);
695: Fnd_Msg_Pub.ADD;
696: RAISE Fnd_Api.G_EXC_ERROR;
697: END;
698: END IF;

Line 709: Fnd_Message.Set_Name('IBC', 'API_INVALID_ID');

705: WHERE label_code = p_label_code;
706: EXCEPTION WHEN NO_DATA_FOUND THEN
707: --DBMS_OUTPUT.put_line('Label Code is Invalid....');
708: x_return_status := Fnd_Api.G_RET_STS_ERROR;
709: Fnd_Message.Set_Name('IBC', 'API_INVALID_ID');
710: Fnd_Message.Set_Token('COLUMN','p_label_code', FALSE);
711: Fnd_Message.Set_Token('VALUE',p_label_code, FALSE);
712: Fnd_Msg_Pub.ADD;
713: RAISE Fnd_Api.G_EXC_ERROR;

Line 710: Fnd_Message.Set_Token('COLUMN','p_label_code', FALSE);

706: EXCEPTION WHEN NO_DATA_FOUND THEN
707: --DBMS_OUTPUT.put_line('Label Code is Invalid....');
708: x_return_status := Fnd_Api.G_RET_STS_ERROR;
709: Fnd_Message.Set_Name('IBC', 'API_INVALID_ID');
710: Fnd_Message.Set_Token('COLUMN','p_label_code', FALSE);
711: Fnd_Message.Set_Token('VALUE',p_label_code, FALSE);
712: Fnd_Msg_Pub.ADD;
713: RAISE Fnd_Api.G_EXC_ERROR;
714: END;

Line 711: Fnd_Message.Set_Token('VALUE',p_label_code, FALSE);

707: --DBMS_OUTPUT.put_line('Label Code is Invalid....');
708: x_return_status := Fnd_Api.G_RET_STS_ERROR;
709: Fnd_Message.Set_Name('IBC', 'API_INVALID_ID');
710: Fnd_Message.Set_Token('COLUMN','p_label_code', FALSE);
711: Fnd_Message.Set_Token('VALUE',p_label_code, FALSE);
712: Fnd_Msg_Pub.ADD;
713: RAISE Fnd_Api.G_EXC_ERROR;
714: END;
715: