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_CV_LABEL_GRP dependencies on FND_API

Line 16: P_Init_Msg_List IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,

12:
13:
14: PROCEDURE Create_CV_Label(
15: P_Api_Version_Number IN NUMBER,
16: P_Init_Msg_List IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
17: P_Commit IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
18: P_Validation_Level IN NUMBER ,--:= Fnd_Api.G_VALID_LEVEL_FULL,
19: P_CV_Label_Rec IN Ibc_Cv_Label_Grp.CV_Label_Rec_Type ,--:= Ibc_Cv_Label_Grp.G_MISS_CV_Label_Rec,
20: x_CV_Label_Rec OUT NOCOPY Ibc_Cv_Label_Grp.CV_Label_Rec_Type,

Line 17: P_Commit IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,

13:
14: PROCEDURE Create_CV_Label(
15: P_Api_Version_Number IN NUMBER,
16: P_Init_Msg_List IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
17: P_Commit IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
18: P_Validation_Level IN NUMBER ,--:= Fnd_Api.G_VALID_LEVEL_FULL,
19: P_CV_Label_Rec IN Ibc_Cv_Label_Grp.CV_Label_Rec_Type ,--:= Ibc_Cv_Label_Grp.G_MISS_CV_Label_Rec,
20: x_CV_Label_Rec OUT NOCOPY Ibc_Cv_Label_Grp.CV_Label_Rec_Type,
21: X_Return_Status OUT NOCOPY VARCHAR2,

Line 18: P_Validation_Level IN NUMBER ,--:= Fnd_Api.G_VALID_LEVEL_FULL,

14: PROCEDURE Create_CV_Label(
15: P_Api_Version_Number IN NUMBER,
16: P_Init_Msg_List IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
17: P_Commit IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
18: P_Validation_Level IN NUMBER ,--:= Fnd_Api.G_VALID_LEVEL_FULL,
19: P_CV_Label_Rec IN Ibc_Cv_Label_Grp.CV_Label_Rec_Type ,--:= Ibc_Cv_Label_Grp.G_MISS_CV_Label_Rec,
20: x_CV_Label_Rec OUT NOCOPY Ibc_Cv_Label_Grp.CV_Label_Rec_Type,
21: X_Return_Status OUT NOCOPY VARCHAR2,
22: X_Msg_Count OUT NOCOPY NUMBER,

Line 43: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

39:
40: BEGIN
41:
42: -- Initialize API return status to SUCCESS
43: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
44:
45: --
46: -- API body
47: --

Line 60: RAISE Fnd_Api.G_EXC_ERROR;

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;
62:
63: -- Check for all the NOT NULL Columns
64: -- CV_Label_Code Cannot be NULL and must exist in IBC_LABELS

Line 65: IF (Ibc_Validate_Pvt.isValidLabel(l_CV_Label_rec.Label_code) = Fnd_Api.g_false) THEN

61: END IF;
62:
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;

Line 73: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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.
73: x_return_status := Fnd_Api.G_RET_STS_ERROR;
74: END IF;
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

Line 77: IF (Ibc_Validate_Pvt.isValidCitem(l_CV_Label_rec.content_item_id) = Fnd_Api.g_false) THEN

73: x_return_status := Fnd_Api.G_RET_STS_ERROR;
74: END IF;
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;

Line 83: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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;
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

Line 87: IF (Ibc_Validate_Pvt.isValidCitemVer(l_CV_Label_rec.citem_version_id) = Fnd_Api.g_false) THEN

83: x_return_status := Fnd_Api.G_RET_STS_ERROR;
84: END IF;
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;

Line 93: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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;
95:
96:
97:

Line 108: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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;
110:
111: CLOSE C_CV_Label;
112:

Line 114: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

110:
111: CLOSE C_CV_Label;
112:
113:
114: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
115: RAISE Fnd_Api.G_EXC_ERROR;
116: END IF;
117:
118:

Line 115: RAISE Fnd_Api.G_EXC_ERROR;

111: CLOSE C_CV_Label;
112:
113:
114: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
115: RAISE Fnd_Api.G_EXC_ERROR;
116: END IF;
117:
118:
119: -- Validate Object Version Number

Line 121: OR l_CV_Label_rec.OBJECT_VERSION_NUMBER = Fnd_Api.G_MISS_NUM THEN

117:
118:
119: -- Validate Object Version Number
120: IF l_CV_Label_rec.OBJECT_VERSION_NUMBER IS NULL
121: OR l_CV_Label_rec.OBJECT_VERSION_NUMBER = Fnd_Api.G_MISS_NUM THEN
122: l_CV_Label_rec.OBJECT_VERSION_NUMBER := 1;
123: END IF;
124:
125: --

Line 141: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

137: ,p_LAST_UPDATE_LOGIN => l_CV_Label_rec.LAST_UPDATE_LOGIN
138: ,p_OBJECT_VERSION_NUMBER => l_CV_Label_rec.OBJECT_VERSION_NUMBER);
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;

Line 147: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_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
148: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
149: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
150: RAISE Fnd_Api.G_EXC_ERROR;
151: END IF;

Line 148: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

144: Fnd_Msg_Pub.ADD;
145: END IF;
146:
147: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
148: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
149: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
150: RAISE Fnd_Api.G_EXC_ERROR;
151: END IF;
152: END IF;

Line 149: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN

145: END IF;
146:
147: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
148: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
149: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
150: RAISE Fnd_Api.G_EXC_ERROR;
151: END IF;
152: END IF;
153:

Line 150: RAISE Fnd_Api.G_EXC_ERROR;

146:
147: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
148: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
149: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
150: RAISE Fnd_Api.G_EXC_ERROR;
151: END IF;
152: END IF;
153:
154: --

Line 159: IF Fnd_Api.to_Boolean( p_commit )

155: -- End of API body
156: --
157:
158: -- Standard check for p_commit
159: IF Fnd_Api.to_Boolean( p_commit )
160: THEN
161: COMMIT WORK;
162: END IF;
163:

Line 172: WHEN Fnd_Api.G_EXC_ERROR THEN

168: );
169:
170:
171: EXCEPTION
172: WHEN Fnd_Api.G_EXC_ERROR THEN
173: ROLLBACK;
174: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
175: P_API_NAME => L_API_NAME
176: ,P_PKG_NAME => G_PKG_NAME

Line 185: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

181: ,X_MSG_COUNT => X_MSG_COUNT
182: ,X_MSG_DATA => X_MSG_DATA
183: ,X_RETURN_STATUS => X_RETURN_STATUS);
184:
185: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
186: ROLLBACK;
187: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
188: P_API_NAME => L_API_NAME
189: ,P_PKG_NAME => G_PKG_NAME

Line 216: P_Init_Msg_List IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,

212:
213:
214: PROCEDURE Update_CV_Label(
215: P_Api_Version_Number IN NUMBER,
216: P_Init_Msg_List IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
217: P_Commit IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
218: P_Validation_Level IN NUMBER ,--:= Fnd_Api.G_VALID_LEVEL_FULL,
219: P_CV_Label_Rec IN Ibc_Cv_Label_Grp.CV_Label_Rec_Type ,--:= Ibc_Cv_Label_Grp.G_MISS_CV_Label_Rec,
220: x_CV_Label_Rec OUT NOCOPY Ibc_Cv_Label_Grp.CV_Label_Rec_Type,

Line 217: P_Commit IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,

213:
214: PROCEDURE Update_CV_Label(
215: P_Api_Version_Number IN NUMBER,
216: P_Init_Msg_List IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
217: P_Commit IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
218: P_Validation_Level IN NUMBER ,--:= Fnd_Api.G_VALID_LEVEL_FULL,
219: P_CV_Label_Rec IN Ibc_Cv_Label_Grp.CV_Label_Rec_Type ,--:= Ibc_Cv_Label_Grp.G_MISS_CV_Label_Rec,
220: x_CV_Label_Rec OUT NOCOPY Ibc_Cv_Label_Grp.CV_Label_Rec_Type,
221: X_Return_Status OUT NOCOPY VARCHAR2,

Line 218: P_Validation_Level IN NUMBER ,--:= Fnd_Api.G_VALID_LEVEL_FULL,

214: PROCEDURE Update_CV_Label(
215: P_Api_Version_Number IN NUMBER,
216: P_Init_Msg_List IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
217: P_Commit IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
218: P_Validation_Level IN NUMBER ,--:= Fnd_Api.G_VALID_LEVEL_FULL,
219: P_CV_Label_Rec IN Ibc_Cv_Label_Grp.CV_Label_Rec_Type ,--:= Ibc_Cv_Label_Grp.G_MISS_CV_Label_Rec,
220: x_CV_Label_Rec OUT NOCOPY Ibc_Cv_Label_Grp.CV_Label_Rec_Type,
221: X_Return_Status OUT NOCOPY VARCHAR2,
222: X_Msg_Count OUT NOCOPY NUMBER,

Line 234: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

230: WHERE Label_Code = P_CV_Label_Rec.Label_Code
231: AND content_item_id = P_CV_Label_Rec.content_item_id;
232:
233: l_temp CHAR(1);
234: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
235:
236: l_api_version_number NUMBER := 1.0;
237: l_api_name VARCHAR2(50) := 'Update_CV_Label';
238: l_CV_Label_Code VARCHAR2(100);

Line 249: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

245:
246: BEGIN
247:
248: -- Initialize API return status to SUCCESS
249: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
250:
251: --
252: -- API body
253: --

Line 266: RAISE Fnd_Api.G_EXC_ERROR;

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;
268:
269: -- Check for all the NOT NULL Columns
270: -- CV_Label_Code Cannot be NULL and must exist in IBC_LABELS

Line 271: IF (Ibc_Validate_Pvt.isValidLabel(l_CV_Label_rec.Label_code) = Fnd_Api.g_false) THEN

267: END IF;
268:
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;

Line 279: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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.
279: x_return_status := Fnd_Api.G_RET_STS_ERROR;
280: END IF;
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

Line 283: IF (Ibc_Validate_Pvt.isValidCitem(l_CV_Label_rec.content_item_id) = Fnd_Api.g_false) THEN

279: x_return_status := Fnd_Api.G_RET_STS_ERROR;
280: END IF;
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;

Line 289: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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;
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

Line 293: IF (Ibc_Validate_Pvt.isValidCitemVer(l_CV_Label_rec.citem_version_id) = Fnd_Api.g_false) THEN

289: x_return_status := Fnd_Api.G_RET_STS_ERROR;
290: END IF;
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;

Line 299: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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;
301:
302:
303:

Line 314: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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;
316: CLOSE C_CV_Label;
317:
318: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

Line 318: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

314: x_return_status := Fnd_Api.G_RET_STS_ERROR;
315: END IF;
316: CLOSE C_CV_Label;
317:
318: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
319: RAISE Fnd_Api.G_EXC_ERROR;
320: END IF;
321:
322: -- -- Validate Object Version Number

Line 319: RAISE Fnd_Api.G_EXC_ERROR;

315: END IF;
316: CLOSE C_CV_Label;
317:
318: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
319: RAISE Fnd_Api.G_EXC_ERROR;
320: END IF;
321:
322: -- -- Validate Object Version Number
323: -- IF l_CV_Label_rec.OBJECT_VERSION_NUMBER IS NULL THEN

Line 324: -- l_CV_Label_rec.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;

320: END IF;
321:
322: -- -- Validate Object Version Number
323: -- IF l_CV_Label_rec.OBJECT_VERSION_NUMBER IS NULL THEN
324: -- l_CV_Label_rec.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
325: -- END IF;
326:
327: --
328: -- Table Handler to Update Row into IBC_CV_LabelS

Line 341: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

337: ,p_OBJECT_VERSION_NUMBER => l_CV_Label_rec.OBJECT_VERSION_NUMBER);
338:
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;

Line 347: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_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
348: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
349: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
350: RAISE Fnd_Api.G_EXC_ERROR;
351: END IF;

Line 348: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

344: Fnd_Msg_Pub.ADD;
345: END IF;
346:
347: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
348: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
349: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
350: RAISE Fnd_Api.G_EXC_ERROR;
351: END IF;
352: END IF;

Line 349: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN

345: END IF;
346:
347: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
348: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
349: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
350: RAISE Fnd_Api.G_EXC_ERROR;
351: END IF;
352: END IF;
353:

Line 350: RAISE Fnd_Api.G_EXC_ERROR;

346:
347: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
348: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
349: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
350: RAISE Fnd_Api.G_EXC_ERROR;
351: END IF;
352: END IF;
353:
354: --

Line 359: IF Fnd_Api.to_Boolean( p_commit )

355: -- End of API body
356: --
357:
358: -- Standard check for p_commit
359: IF Fnd_Api.to_Boolean( p_commit )
360: THEN
361: COMMIT WORK;
362: END IF;
363:

Line 372: WHEN Fnd_Api.G_EXC_ERROR THEN

368: );
369:
370:
371: EXCEPTION
372: WHEN Fnd_Api.G_EXC_ERROR THEN
373: ROLLBACK;
374: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
375: P_API_NAME => L_API_NAME
376: ,P_PKG_NAME => G_PKG_NAME

Line 385: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

381: ,X_MSG_COUNT => X_MSG_COUNT
382: ,X_MSG_DATA => X_MSG_DATA
383: ,X_RETURN_STATUS => X_RETURN_STATUS);
384:
385: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
386: ROLLBACK;
387: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
388: P_API_NAME => L_API_NAME
389: ,P_PKG_NAME => G_PKG_NAME

Line 416: P_Init_Msg_List IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,

412:
413:
414: PROCEDURE delete_CV_Label(
415: P_Api_Version_Number IN NUMBER,
416: P_Init_Msg_List IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
417: P_Commit IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
418: P_Validation_Level IN NUMBER ,--:= Fnd_Api.G_VALID_LEVEL_FULL,
419: P_Label_Code IN VARCHAR2,
420: P_content_item_id IN NUMBER,

Line 417: P_Commit IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,

413:
414: PROCEDURE delete_CV_Label(
415: P_Api_Version_Number IN NUMBER,
416: P_Init_Msg_List IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
417: P_Commit IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
418: P_Validation_Level IN NUMBER ,--:= Fnd_Api.G_VALID_LEVEL_FULL,
419: P_Label_Code IN VARCHAR2,
420: P_content_item_id IN NUMBER,
421: X_Return_Status OUT NOCOPY VARCHAR2,

Line 418: P_Validation_Level IN NUMBER ,--:= Fnd_Api.G_VALID_LEVEL_FULL,

414: PROCEDURE delete_CV_Label(
415: P_Api_Version_Number IN NUMBER,
416: P_Init_Msg_List IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
417: P_Commit IN VARCHAR2 ,--:= Fnd_Api.G_FALSE,
418: P_Validation_Level IN NUMBER ,--:= Fnd_Api.G_VALID_LEVEL_FULL,
419: P_Label_Code IN VARCHAR2,
420: P_content_item_id IN NUMBER,
421: X_Return_Status OUT NOCOPY VARCHAR2,
422: X_Msg_Count OUT NOCOPY NUMBER,

Line 435: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

431: WHERE Label_Code = P_Label_Code
432: AND content_item_id = P_content_item_id;
433:
434: l_temp CHAR(1);
435: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
436:
437: l_api_version_number NUMBER := 1.0;
438: l_api_name VARCHAR2(50) := 'Delete_CV_Label';
439: l_CV_Label_Code VARCHAR2(100);

Line 448: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

444:
445: BEGIN
446:
447: -- Initialize API return status to SUCCESS
448: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
449:
450: --
451: -- API body
452: --

Line 465: RAISE Fnd_Api.G_EXC_ERROR;

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;
467:
468:
469: --

Line 478: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

474: ,p_Label_code => p_Label_code);
475:
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;

Line 484: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_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
485: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
486: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
487: RAISE Fnd_Api.G_EXC_ERROR;
488: END IF;

Line 485: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

481: Fnd_Msg_Pub.ADD;
482: END IF;
483:
484: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
485: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
486: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
487: RAISE Fnd_Api.G_EXC_ERROR;
488: END IF;
489: END IF;

Line 486: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN

482: END IF;
483:
484: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
485: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
486: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
487: RAISE Fnd_Api.G_EXC_ERROR;
488: END IF;
489: END IF;
490:

Line 487: RAISE Fnd_Api.G_EXC_ERROR;

483:
484: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
485: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
486: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
487: RAISE Fnd_Api.G_EXC_ERROR;
488: END IF;
489: END IF;
490:
491: --

Line 496: IF Fnd_Api.to_Boolean( p_commit )

492: -- End of API body
493: --
494:
495: -- Standard check for p_commit
496: IF Fnd_Api.to_Boolean( p_commit )
497: THEN
498: COMMIT WORK;
499: END IF;
500:

Line 509: WHEN Fnd_Api.G_EXC_ERROR THEN

505: );
506:
507:
508: EXCEPTION
509: WHEN Fnd_Api.G_EXC_ERROR THEN
510: ROLLBACK;
511: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
512: P_API_NAME => L_API_NAME
513: ,P_PKG_NAME => G_PKG_NAME

Line 522: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

518: ,X_MSG_COUNT => X_MSG_COUNT
519: ,X_MSG_DATA => X_MSG_DATA
520: ,X_RETURN_STATUS => X_RETURN_STATUS);
521:
522: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
523: ROLLBACK;
524: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
525: P_API_NAME => L_API_NAME
526: ,P_PKG_NAME => G_PKG_NAME

Line 592: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

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;
594:
595: FUNCTION get_CV_Label_rec RETURN Ibc_Cv_Label_Grp.CV_Label_rec_type
596: IS

Line 612: ,p_init_msg_list IN VARCHAR2 --DEFAULT Fnd_Api.G_FALSE

608: ,p_citem_version_ids IN JTF_NUMBER_TABLE
609: ,p_version_number IN JTF_NUMBER_TABLE
610: ,p_commit IN VARCHAR2
611: ,p_api_version_number IN NUMBER
612: ,p_init_msg_list IN VARCHAR2 --DEFAULT Fnd_Api.G_FALSE
613: ,x_return_status OUT NOCOPY VARCHAR2
614: ,x_msg_count OUT NOCOPY NUMBER
615: ,x_msg_data OUT NOCOPY VARCHAR2
616: )

Line 637: IF (p_init_msg_list = Fnd_Api.g_true) THEN --|**|

633:
634:
635: SAVEPOINT SVPT_UPSERT_CV_LABELS;
636:
637: IF (p_init_msg_list = Fnd_Api.g_true) THEN --|**|
638: Fnd_Msg_Pub.initialize; --|**|
639: END IF; --|**|
640: --|**|
641: -- Standard call to check for call compatibility. --|**|

Line 642: IF NOT Fnd_Api.Compatible_API_Call ( --|**|

638: Fnd_Msg_Pub.initialize; --|**|
639: END IF; --|**|
640: --|**|
641: -- Standard call to check for call compatibility. --|**|
642: IF NOT Fnd_Api.Compatible_API_Call ( --|**|
643: l_api_version_number --|**|
644: ,p_api_version_number --|**|
645: ,l_api_name --|**|
646: ,G_PKG_NAME --|**|

Line 648: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR; --|**|

644: ,p_api_version_number --|**|
645: ,l_api_name --|**|
646: ,G_PKG_NAME --|**|
647: )THEN --|**|
648: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR; --|**|
649: END IF; --|**|
650: --|**|
651: -- Initialize API return status to SUCCESS --|**|
652: x_return_status := Fnd_Api.G_RET_STS_SUCCESS; --|**|

Line 652: x_return_status := Fnd_Api.G_RET_STS_SUCCESS; --|**|

648: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR; --|**|
649: END IF; --|**|
650: --|**|
651: -- Initialize API return status to SUCCESS --|**|
652: x_return_status := Fnd_Api.G_RET_STS_SUCCESS; --|**|
653:
654:
655: IF l_citem_version_ids.COUNT <> 0 THEN
656: BEGIN

Line 669: x_return_status := Fnd_Api.G_RET_STS_ERROR;

665: AND citem_version_id = l_citem_version_ids(i);
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;

Line 674: RAISE Fnd_Api.G_EXC_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
677: BEGIN
678: -- get the citem_version id for all the content item id and

Line 691: x_return_status := Fnd_Api.G_RET_STS_ERROR;

687: AND version_number = p_version_number(i);
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;

Line 696: RAISE Fnd_Api.G_EXC_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;
699:
700: --

Line 708: x_return_status := Fnd_Api.G_RET_STS_ERROR;

704: SELECT '1' INTO l_temp FROM IBC_LABELS_B
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;

Line 713: RAISE Fnd_Api.G_EXC_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:
716: --
717: -- Update

Line 777: IF ( (x_return_status = Fnd_Api.G_RET_STS_SUCCESS) AND (p_commit = Fnd_Api.g_true) ) THEN

773:
774:
775:
776: -- COMMIT?
777: IF ( (x_return_status = Fnd_Api.G_RET_STS_SUCCESS) AND (p_commit = Fnd_Api.g_true) ) THEN
778: COMMIT;
779: END IF;
780:
781: -- Standard call to get message count and if count is 1, get message info.

Line 788: WHEN Fnd_Api.G_EXC_ERROR THEN

784: p_data => x_msg_data
785: );
786:
787: EXCEPTION
788: WHEN Fnd_Api.G_EXC_ERROR THEN
789: ROLLBACK TO SVPT_UPSERT_CV_LABELS;
790: --DBMS_OUTPUT.put_line('Expected Error');
791: Ibc_Utilities_Pvt.handle_exceptions(
792: p_api_name => L_API_NAME

Line 803: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

799: ,x_msg_data => x_msg_data
800: ,x_return_status => x_return_status
801: );
802:
803: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
804: ROLLBACK TO SVPT_UPSERT_CV_LABELS;
805: --DBMS_OUTPUT.put_line('Unexpected error');
806: Ibc_Utilities_Pvt.handle_exceptions(
807: p_api_name => L_API_NAME

Line 843: ,p_init_msg_list IN VARCHAR2 --DEFAULT Fnd_Api.G_FALSE

839: ,p_content_item_ids IN JTF_NUMBER_TABLE
840: ,p_citem_version_ids IN JTF_NUMBER_TABLE
841: ,p_commit IN VARCHAR2
842: ,p_api_version_number IN NUMBER
843: ,p_init_msg_list IN VARCHAR2 --DEFAULT Fnd_Api.G_FALSE
844: ,x_return_status OUT NOCOPY VARCHAR2
845: ,x_msg_count OUT NOCOPY NUMBER
846: ,x_msg_data OUT NOCOPY VARCHAR2
847: )

Line 885: ,p_init_msg_list IN VARCHAR2 --DEFAULT Fnd_Api.G_FALSE

881: ,p_content_item_ids IN JTF_NUMBER_TABLE
882: ,p_version_number IN JTF_NUMBER_TABLE
883: ,p_commit IN VARCHAR2
884: ,p_api_version_number IN NUMBER
885: ,p_init_msg_list IN VARCHAR2 --DEFAULT Fnd_Api.G_FALSE
886: ,x_return_status OUT NOCOPY VARCHAR2
887: ,x_msg_count OUT NOCOPY NUMBER
888: ,x_msg_data OUT NOCOPY VARCHAR2
889: )

Line 924: ,p_init_msg_list IN VARCHAR2 --DEFAULT Fnd_Api.G_FALSE

920: p_label_code IN VARCHAR2
921: ,p_content_item_ids IN JTF_NUMBER_TABLE
922: ,p_commit IN VARCHAR2
923: ,p_api_version_number IN NUMBER
924: ,p_init_msg_list IN VARCHAR2 --DEFAULT Fnd_Api.G_FALSE
925: ,x_return_status OUT NOCOPY VARCHAR2
926: ,x_msg_count OUT NOCOPY NUMBER
927: ,x_msg_data OUT NOCOPY VARCHAR2
928: )

Line 941: IF (p_init_msg_list = Fnd_Api.g_true) THEN --|**|

937:
938:
939: SAVEPOINT SVPT_DELETE_CV_LABELS;
940:
941: IF (p_init_msg_list = Fnd_Api.g_true) THEN --|**|
942: Fnd_Msg_Pub.initialize; --|**|
943: END IF; --|**|
944: --|**|
945: -- Standard call to check for call compatibility. --|**|

Line 946: IF NOT Fnd_Api.Compatible_API_Call ( --|**|

942: Fnd_Msg_Pub.initialize; --|**|
943: END IF; --|**|
944: --|**|
945: -- Standard call to check for call compatibility. --|**|
946: IF NOT Fnd_Api.Compatible_API_Call ( --|**|
947: l_api_version_number --|**|
948: ,p_api_version_number --|**|
949: ,l_api_name --|**|
950: ,G_PKG_NAME --|**|

Line 952: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR; --|**|

948: ,p_api_version_number --|**|
949: ,l_api_name --|**|
950: ,G_PKG_NAME --|**|
951: )THEN --|**|
952: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR; --|**|
953: END IF; --|**|
954: --|**|
955: -- Initialize API return status to SUCCESS --|**|
956: x_return_status := Fnd_Api.G_RET_STS_SUCCESS; --|**|

Line 956: x_return_status := Fnd_Api.G_RET_STS_SUCCESS; --|**|

952: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR; --|**|
953: END IF; --|**|
954: --|**|
955: -- Initialize API return status to SUCCESS --|**|
956: x_return_status := Fnd_Api.G_RET_STS_SUCCESS; --|**|
957:
958:
959: --
960: -- Delete

Line 969: IF ( (x_return_status = Fnd_Api.G_RET_STS_SUCCESS) AND (p_commit = Fnd_Api.g_true) ) THEN

965:
966: --DBMS_OUTPUT.put_line('Delete Successful....');
967:
968: -- COMMIT?
969: IF ( (x_return_status = Fnd_Api.G_RET_STS_SUCCESS) AND (p_commit = Fnd_Api.g_true) ) THEN
970: COMMIT;
971: END IF;
972:
973: -- Standard call to get message count and if count is 1, get message info.

Line 980: WHEN Fnd_Api.G_EXC_ERROR THEN

976: p_data => x_msg_data
977: );
978:
979: EXCEPTION
980: WHEN Fnd_Api.G_EXC_ERROR THEN
981: ROLLBACK TO SVPT_UPSERT_CV_LABELS;
982: --DBMS_OUTPUT.put_line('Expected Error');
983: Ibc_Utilities_Pvt.handle_exceptions(
984: p_api_name => L_API_NAME

Line 995: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

991: ,x_msg_data => x_msg_data
992: ,x_return_status => x_return_status
993: );
994:
995: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
996: ROLLBACK TO SVPT_UPSERT_CV_LABELS;
997: --DBMS_OUTPUT.put_line('Unexpected error');
998: Ibc_Utilities_Pvt.handle_exceptions(
999: p_api_name => L_API_NAME