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

Line 25: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,

21: G_FILE_Name CONSTANT VARCHAR2(12) := 'ibcvctyb.pls';
22:
23: PROCEDURE Update_Attribute_Type(
24: P_Api_Version_Number IN NUMBER,
25: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
26: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
27: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
28: P_Attribute_Type_Rec IN Ibc_Ctype_Pvt.Attribute_Type_Rec_Type,
29: X_Return_Status OUT NOCOPY VARCHAR2,

Line 26: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,

22:
23: PROCEDURE Update_Attribute_Type(
24: P_Api_Version_Number IN NUMBER,
25: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
26: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
27: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
28: P_Attribute_Type_Rec IN Ibc_Ctype_Pvt.Attribute_Type_Rec_Type,
29: X_Return_Status OUT NOCOPY VARCHAR2,
30: X_Msg_Count OUT NOCOPY NUMBER,

Line 27: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,

23: PROCEDURE Update_Attribute_Type(
24: P_Api_Version_Number IN NUMBER,
25: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
26: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
27: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
28: P_Attribute_Type_Rec IN Ibc_Ctype_Pvt.Attribute_Type_Rec_Type,
29: X_Return_Status OUT NOCOPY VARCHAR2,
30: X_Msg_Count OUT NOCOPY NUMBER,
31: X_Msg_Data OUT NOCOPY VARCHAR2

Line 36: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,

32: );
33:
34: PROCEDURE Delete_Attribute_Type(
35: P_Api_Version_Number IN NUMBER,
36: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
37: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
38: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
39: P_Attribute_Type_Rec IN Ibc_Ctype_Pvt.Attribute_Type_Rec_Type,
40: X_Return_Status OUT NOCOPY VARCHAR2,

Line 37: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,

33:
34: PROCEDURE Delete_Attribute_Type(
35: P_Api_Version_Number IN NUMBER,
36: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
37: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
38: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
39: P_Attribute_Type_Rec IN Ibc_Ctype_Pvt.Attribute_Type_Rec_Type,
40: X_Return_Status OUT NOCOPY VARCHAR2,
41: X_Msg_Count OUT NOCOPY NUMBER,

Line 38: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,

34: PROCEDURE Delete_Attribute_Type(
35: P_Api_Version_Number IN NUMBER,
36: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
37: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
38: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
39: P_Attribute_Type_Rec IN Ibc_Ctype_Pvt.Attribute_Type_Rec_Type,
40: X_Return_Status OUT NOCOPY VARCHAR2,
41: X_Msg_Count OUT NOCOPY NUMBER,
42: X_Msg_Data OUT NOCOPY VARCHAR2

Line 58: OR p_attribute_type_rec.content_type_code = Fnd_Api.G_MISS_CHAR)

54:
55: BEGIN
56:
57: IF ((p_attribute_type_rec.content_type_code IS NULL
58: OR p_attribute_type_rec.content_type_code = Fnd_Api.G_MISS_CHAR)
59: AND (p_attribute_type_rec.attribute_type_code IS NULL
60: OR p_attribute_type_rec.attribute_type_code = Fnd_Api.G_MISS_CHAR))
61: THEN
62:

Line 60: OR p_attribute_type_rec.attribute_type_code = Fnd_Api.G_MISS_CHAR))

56:
57: IF ((p_attribute_type_rec.content_type_code IS NULL
58: OR p_attribute_type_rec.content_type_code = Fnd_Api.G_MISS_CHAR)
59: AND (p_attribute_type_rec.attribute_type_code IS NULL
60: OR p_attribute_type_rec.attribute_type_code = Fnd_Api.G_MISS_CHAR))
61: THEN
62:
63: RETURN TRUE;
64: ELSE

Line 78: OR P_content_Type_Rec.content_type_code = Fnd_Api.G_MISS_CHAR)

74:
75: BEGIN
76:
77: IF ((P_content_Type_Rec.content_type_code IS NULL
78: OR P_content_Type_Rec.content_type_code = Fnd_Api.G_MISS_CHAR)
79: AND (P_content_Type_Rec.content_type_status IS NULL
80: OR P_content_Type_Rec.content_type_status = Fnd_Api.G_MISS_CHAR))
81: THEN
82:

Line 80: OR P_content_Type_Rec.content_type_status = Fnd_Api.G_MISS_CHAR))

76:
77: IF ((P_content_Type_Rec.content_type_code IS NULL
78: OR P_content_Type_Rec.content_type_code = Fnd_Api.G_MISS_CHAR)
79: AND (P_content_Type_Rec.content_type_status IS NULL
80: OR P_content_Type_Rec.content_type_status = Fnd_Api.G_MISS_CHAR))
81: THEN
82:
83: RETURN TRUE;
84:

Line 94: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,

90: END IsCTypeRecordEmpty;
91:
92: PROCEDURE Create_Content_Type(
93: P_Api_Version_Number IN NUMBER,
94: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
95: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
96: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
97: P_Content_Type_Rec IN Ibc_Ctype_Pvt.Content_Type_Rec_Type ,--:= Ibc_Ctype_Pvt.G_MISS_Content_Type_Rec,
98: P_Attribute_Type_Tbl IN Ibc_Ctype_Pvt.Attribute_Type_Tbl_Type ,--:= Ibc_Ctype_Pvt.G_Miss_Attribute_Type_Tbl,

Line 95: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,

91:
92: PROCEDURE Create_Content_Type(
93: P_Api_Version_Number IN NUMBER,
94: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
95: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
96: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
97: P_Content_Type_Rec IN Ibc_Ctype_Pvt.Content_Type_Rec_Type ,--:= Ibc_Ctype_Pvt.G_MISS_Content_Type_Rec,
98: P_Attribute_Type_Tbl IN Ibc_Ctype_Pvt.Attribute_Type_Tbl_Type ,--:= Ibc_Ctype_Pvt.G_Miss_Attribute_Type_Tbl,
99: X_Return_Status OUT NOCOPY VARCHAR2,

Line 96: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,

92: PROCEDURE Create_Content_Type(
93: P_Api_Version_Number IN NUMBER,
94: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
95: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
96: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
97: P_Content_Type_Rec IN Ibc_Ctype_Pvt.Content_Type_Rec_Type ,--:= Ibc_Ctype_Pvt.G_MISS_Content_Type_Rec,
98: P_Attribute_Type_Tbl IN Ibc_Ctype_Pvt.Attribute_Type_Tbl_Type ,--:= Ibc_Ctype_Pvt.G_Miss_Attribute_Type_Tbl,
99: X_Return_Status OUT NOCOPY VARCHAR2,
100: X_Msg_Count OUT NOCOPY NUMBER,

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

116: WHERE content_type_code = p_content_type_code
117: AND attribute_type_code = p_attribute_type_code;
118:
119: l_temp CHAR(1);
120: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
121:
122: l_api_version_number NUMBER := 1.0;
123: l_api_name VARCHAR2(50) := 'Create_Content_Type';
124: l_Content_Type_Code VARCHAR2(100);

Line 139: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

135: -- Standard Start of API savepoint
136: DBMS_TRANSACTION.SAVEPOINT(l_api_name);
137: --SAVEPOINT l_api_name;
138: -- Initialize API return status to SUCCESS
139: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
140:
141: --
142: -- API body
143: --

Line 156: RAISE Fnd_Api.G_EXC_ERROR;

152: Fnd_Message.Set_Name(' + appShortname +', 'UT_CANNOT_GET_PROFILE_VALUE');
153: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);
154: Fnd_Msg_Pub.ADD;
155: END IF;
156: RAISE Fnd_Api.G_EXC_ERROR;
157: END IF;
158:
159: -- Check for all the NOT NULL Columns
160: -- Content_TYpe_Code Cannot be NULL

Line 162: p_init_msg_list => Fnd_Api.G_FALSE,

158:
159: -- Check for all the NOT NULL Columns
160: -- Content_TYpe_Code Cannot be NULL
161: Ibc_Validate_Pvt.validate_NotNULL_VARCHAR2 (
162: p_init_msg_list => Fnd_Api.G_FALSE,
163: p_column_name => 'Content_Type_Code',
164: p_notnull_column=> l_content_type_rec.content_type_code,
165: x_return_status => x_return_status,
166: x_msg_count => x_msg_count,

Line 171: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

167: x_msg_data => x_msg_data);
168:
169: -- Don't RAISE the EXCEPTION Yet. RUN ALL the validation procedures
170: -- and show Exceptions all at once.
171: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
172: l_return_status := x_return_status;
173: END IF;
174:
175: -- Content_TYpe_Status Cannot be NULL

Line 177: p_init_msg_list => Fnd_Api.G_FALSE,

173: END IF;
174:
175: -- Content_TYpe_Status Cannot be NULL
176: Ibc_Validate_Pvt.validate_NotNULL_VARCHAR2 (
177: p_init_msg_list => Fnd_Api.G_FALSE,
178: p_column_name => 'Content_Type_Status',
179: p_notnull_column=> l_content_type_rec.content_type_Status,
180: x_return_status => x_return_status,
181: x_msg_count => x_msg_count,

Line 184: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

180: x_return_status => x_return_status,
181: x_msg_count => x_msg_count,
182: x_msg_data => x_msg_data);
183:
184: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
185: l_return_status := x_return_status;
186: END IF;
187:
188: -- Content_TYpe_name Cannot be NULL

Line 190: p_init_msg_list => Fnd_Api.G_FALSE,

186: END IF;
187:
188: -- Content_TYpe_name Cannot be NULL
189: Ibc_Validate_Pvt.validate_NotNULL_VARCHAR2 (
190: p_init_msg_list => Fnd_Api.G_FALSE,
191: p_column_name => 'Content_Type_name',
192: p_notnull_column=> l_content_type_rec.content_type_name,
193: x_return_status => x_return_status,
194: x_msg_count => x_msg_count,

Line 197: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

193: x_return_status => x_return_status,
194: x_msg_count => x_msg_count,
195: x_msg_data => x_msg_data);
196:
197: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
198: l_return_status := x_return_status;
199: END IF;
200:
201:

Line 212: RAISE Fnd_Api.G_EXC_ERROR;

208: Fnd_Message.Set_Token('DUPLICATE_OBJECT_TOKEN', 'Content_Type_Code', FALSE);
209: Fnd_Msg_Pub.ADD;
210: END IF;
211: CLOSE C_Content_Type;
212: RAISE Fnd_Api.G_EXC_ERROR;
213: END IF;
214: CLOSE C_Content_Type;
215:
216:

Line 219: p_init_msg_list => Fnd_Api.G_FALSE,

215:
216:
217: -- Validate Content Type Status
218: Ibc_Validate_Pvt.validate_Content_Type_Status(
219: p_init_msg_list => Fnd_Api.G_FALSE,
220: p_Content_Type_Status => l_content_type_rec.content_type_status,
221: x_return_status => x_return_status,
222: x_msg_count => x_msg_count,
223: x_msg_data => x_msg_data);

Line 225: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

221: x_return_status => x_return_status,
222: x_msg_count => x_msg_count,
223: x_msg_data => x_msg_data);
224:
225: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
226: l_return_status := x_return_status;
227: END IF;
228:
229:

Line 232: p_init_msg_list => Fnd_Api.G_FALSE,

228:
229:
230: -- Validate Application Id
231: Ibc_Validate_Pvt.validate_application_id(
232: p_init_msg_list => Fnd_Api.G_FALSE,
233: p_application_id => l_content_type_rec.application_id,
234: x_return_status => x_return_status,
235: x_msg_count => x_msg_count,
236: x_msg_data => x_msg_data);

Line 238: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS

234: x_return_status => x_return_status,
235: x_msg_count => x_msg_count,
236: x_msg_data => x_msg_data);
237:
238: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS
239: OR l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
240: RAISE Fnd_Api.G_EXC_ERROR;
241: END IF;
242:

Line 239: OR l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

235: x_msg_count => x_msg_count,
236: x_msg_data => x_msg_data);
237:
238: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS
239: OR l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
240: RAISE Fnd_Api.G_EXC_ERROR;
241: END IF;
242:
243: -- Validate Object Version Number

Line 240: RAISE Fnd_Api.G_EXC_ERROR;

236: x_msg_data => x_msg_data);
237:
238: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS
239: OR l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
240: RAISE Fnd_Api.G_EXC_ERROR;
241: END IF;
242:
243: -- Validate Object Version Number
244: IF l_content_type_rec.OBJECT_VERSION_NUMBER IS NULL

Line 245: OR l_content_type_rec.OBJECT_VERSION_NUMBER = Fnd_Api.G_MISS_NUM THEN

241: END IF;
242:
243: -- Validate Object Version Number
244: IF l_content_type_rec.OBJECT_VERSION_NUMBER IS NULL
245: OR l_content_type_rec.OBJECT_VERSION_NUMBER = Fnd_Api.G_MISS_NUM THEN
246: l_content_type_rec.OBJECT_VERSION_NUMBER := 1;
247: END IF;
248:
249: --dbms_output.put_line('Validation complete FOR content TYPE');

Line 294: P_Validation_Level =>Fnd_Api.G_VALID_LEVEL_FULL,

290: Create_Attribute_Type(
291: P_Api_Version_Number =>P_Api_Version_Number,
292: P_Init_Msg_List =>P_Init_Msg_List,
293: P_Commit =>P_Commit,
294: P_Validation_Level =>Fnd_Api.G_VALID_LEVEL_FULL,
295: P_Attribute_Type_Rec =>l_Attribute_Type_Tbl(i),
296: X_Return_Status =>X_Return_Status,
297: X_Msg_Count =>X_Msg_Count,
298: X_Msg_Data =>X_Msg_Data);

Line 322: P_Validation_Level =>Fnd_Api.G_VALID_LEVEL_FULL,

318: Create_Attribute_Type(
319: P_Api_Version_Number =>P_Api_Version_Number,
320: P_Init_Msg_List =>P_Init_Msg_List,
321: P_Commit =>P_Commit,
322: P_Validation_Level =>Fnd_Api.G_VALID_LEVEL_FULL,
323: P_Attribute_Type_Rec =>l_Attribute_Type_rec,
324: X_Return_Status =>X_Return_Status,
325: X_Msg_Count =>X_Msg_Count,
326: X_Msg_Data =>X_Msg_Data);

Line 347: P_Validation_Level =>Fnd_Api.G_VALID_LEVEL_FULL,

343: Create_Attribute_Type(
344: P_Api_Version_Number =>P_Api_Version_Number,
345: P_Init_Msg_List =>P_Init_Msg_List,
346: P_Commit =>P_Commit,
347: P_Validation_Level =>Fnd_Api.G_VALID_LEVEL_FULL,
348: P_Attribute_Type_Rec =>l_Attribute_Type_Tbl(1),
349: X_Return_Status =>X_Return_Status,
350: X_Msg_Count =>X_Msg_Count,
351: X_Msg_Data =>X_Msg_Data);

Line 363: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

359:
360:
361: -- dbms_output.put_line('COUNT ' || l_temp);
362: ---
363: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
364: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
365: Fnd_Message.Set_name('IBC', 'IBC_INSERT_ERROR');
366: Fnd_Msg_Pub.ADD;
367: END IF;

Line 369: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN

365: Fnd_Message.Set_name('IBC', 'IBC_INSERT_ERROR');
366: Fnd_Msg_Pub.ADD;
367: END IF;
368:
369: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
370: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
371: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
372: RAISE Fnd_Api.G_EXC_ERROR;
373: END IF;

Line 370: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

366: Fnd_Msg_Pub.ADD;
367: END IF;
368:
369: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
370: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
371: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
372: RAISE Fnd_Api.G_EXC_ERROR;
373: END IF;
374: END IF;

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

367: END IF;
368:
369: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
370: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
371: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
372: RAISE Fnd_Api.G_EXC_ERROR;
373: END IF;
374: END IF;
375:

Line 372: RAISE Fnd_Api.G_EXC_ERROR;

368:
369: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
370: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
371: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
372: RAISE Fnd_Api.G_EXC_ERROR;
373: END IF;
374: END IF;
375:
376: --

Line 381: IF Fnd_Api.to_Boolean( p_commit )

377: -- End of API body
378: --
379:
380: -- Standard check for p_commit
381: IF Fnd_Api.to_Boolean( p_commit )
382: THEN
383: COMMIT WORK;
384: END IF;
385:

Line 393: WHEN Fnd_Api.G_EXC_ERROR THEN

389: p_data => x_msg_data
390: );
391:
392: EXCEPTION
393: WHEN Fnd_Api.G_EXC_ERROR THEN
394: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
395: --ROLLBACK TO SAVEPOINT l_api_name;
396: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
397: P_API_name => L_API_name

Line 407: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

403: ,X_MSG_COUNT => X_MSG_COUNT
404: ,X_MSG_DATA => X_MSG_DATA
405: ,X_RETURN_STATUS => X_RETURN_STATUS);
406:
407: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
408: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
409: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
410: P_API_name => L_API_name
411: ,P_PKG_name => G_PKG_name

Line 438: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,

434:
435:
436: PROCEDURE Create_Attribute_Type(
437: P_Api_Version_Number IN NUMBER,
438: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
439: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
440: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
441: P_Attribute_Type_Rec IN Ibc_Ctype_Pvt.Attribute_Type_Rec_Type,
442: X_Return_Status OUT NOCOPY VARCHAR2,

Line 439: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,

435:
436: PROCEDURE Create_Attribute_Type(
437: P_Api_Version_Number IN NUMBER,
438: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
439: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
440: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
441: P_Attribute_Type_Rec IN Ibc_Ctype_Pvt.Attribute_Type_Rec_Type,
442: X_Return_Status OUT NOCOPY VARCHAR2,
443: X_Msg_Count OUT NOCOPY NUMBER,

Line 440: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,

436: PROCEDURE Create_Attribute_Type(
437: P_Api_Version_Number IN NUMBER,
438: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
439: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
440: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
441: P_Attribute_Type_Rec IN Ibc_Ctype_Pvt.Attribute_Type_Rec_Type,
442: X_Return_Status OUT NOCOPY VARCHAR2,
443: X_Msg_Count OUT NOCOPY NUMBER,
444: X_Msg_Data OUT NOCOPY VARCHAR2

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

458: WHERE content_type_code = p_content_type_code
459: AND attribute_type_code = p_attribute_type_code;
460:
461: l_temp CHAR(1);
462: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
463:
464: l_api_version_number NUMBER := 1.0;
465: l_api_name VARCHAR2(50) := 'Create_Attribute_Type';
466: lx_rowid VARCHAR2(240);

Line 474: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

470:
471: BEGIN
472:
473: -- Initialize API return status to SUCCESS
474: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
475:
476: -- Begin Validation for Attribute Type Record
477:
478: -- Check for all the NOT NULL Columns

Line 481: p_init_msg_list => Fnd_Api.G_FALSE,

477:
478: -- Check for all the NOT NULL Columns
479: -- Attribute_Type_Code Cannot be NULL
480: Ibc_Validate_Pvt.validate_NotNULL_VARCHAR2 (
481: p_init_msg_list => Fnd_Api.G_FALSE,
482: p_column_name => 'Attribute_Type_Code',
483: p_notnull_column=> l_attribute_type_rec.attribute_type_code,
484: x_return_status => x_return_status,
485: x_msg_count => x_msg_count,

Line 488: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

484: x_return_status => x_return_status,
485: x_msg_count => x_msg_count,
486: x_msg_data => x_msg_data);
487:
488: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
489: l_return_status := x_return_status;
490: END IF;
491:
492:

Line 496: p_init_msg_list => Fnd_Api.G_FALSE,

492:
493: --
494: -- Validate the Content Type Code in Attribute Rec
495: Ibc_Validate_Pvt.validate_NotNULL_VARCHAR2 (
496: p_init_msg_list => Fnd_Api.G_FALSE,
497: p_column_name => 'Content_Type_Code',
498: p_notnull_column=> l_attribute_type_rec.Content_Type_Code,
499: x_return_status => x_return_status,
500: x_msg_count => x_msg_count,

Line 503: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

499: x_return_status => x_return_status,
500: x_msg_count => x_msg_count,
501: x_msg_data => x_msg_data);
502:
503: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
504: l_return_status := x_return_status;
505: END IF;
506:
507:

Line 512: x_return_status := Fnd_Api.G_RET_STS_ERROR;

508: -- Check for Content Type Code exits in Content Type Table
509: OPEN C_Content_Type(p_Content_Type_Code => l_attribute_type_rec.Content_Type_Code);
510: FETCH C_Content_Type INTO l_Content_Type_Code;
511: IF C_Content_Type%NOTFOUND THEN
512: x_return_status := Fnd_Api.G_RET_STS_ERROR;
513: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
514: Fnd_Message.Set_name('IBC', 'INVALID_CONTENT_TYPE_CODE');
515: Fnd_Message.Set_Token('COLUMN', 'Content_Type_Code', FALSE);
516: Fnd_Msg_Pub.ADD;

Line 519: RAISE Fnd_Api.G_EXC_ERROR;

515: Fnd_Message.Set_Token('COLUMN', 'Content_Type_Code', FALSE);
516: Fnd_Msg_Pub.ADD;
517: END IF;
518: CLOSE C_Content_Type;
519: RAISE Fnd_Api.G_EXC_ERROR;
520: END IF;
521: CLOSE C_Content_Type;
522:
523: -- Attribute_Type_name Cannot be NULL

Line 525: p_init_msg_list => Fnd_Api.G_FALSE,

521: CLOSE C_Content_Type;
522:
523: -- Attribute_Type_name Cannot be NULL
524: Ibc_Validate_Pvt.validate_NotNULL_VARCHAR2 (
525: p_init_msg_list => Fnd_Api.G_FALSE,
526: p_column_name => 'Attribute_Type_Name',
527: p_notnull_column=> l_attribute_type_rec.Attribute_type_name,
528: x_return_status => x_return_status,
529: x_msg_count => x_msg_count,

Line 532: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

528: x_return_status => x_return_status,
529: x_msg_count => x_msg_count,
530: x_msg_data => x_msg_data);
531:
532: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
533: l_return_status := x_return_status;
534: END IF;
535:
536: -- Data_Type_Code Cannot be NULL

Line 538: p_init_msg_list => Fnd_Api.G_FALSE,

534: END IF;
535:
536: -- Data_Type_Code Cannot be NULL
537: Ibc_Validate_Pvt.validate_NotNULL_VARCHAR2 (
538: p_init_msg_list => Fnd_Api.G_FALSE,
539: p_column_name => 'Data_Type_code',
540: p_notnull_column=> l_attribute_type_rec.Data_Type_code,
541: x_return_status => x_return_status,
542: x_msg_count => x_msg_count,

Line 545: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

541: x_return_status => x_return_status,
542: x_msg_count => x_msg_count,
543: x_msg_data => x_msg_data);
544:
545: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
546: l_return_status := x_return_status;
547: END IF;
548:
549:

Line 552: p_init_msg_list => Fnd_Api.G_FALSE,

548:
549:
550: -- Validate Data Type Code
551: Ibc_Validate_Pvt.validate_Data_Type_Code(
552: p_init_msg_list => Fnd_Api.G_FALSE,
553: p_data_Type_Code => l_attribute_type_rec.Data_Type_code,
554: x_return_status => x_return_status,
555: x_msg_count => x_msg_count,
556: x_msg_data => x_msg_data);

Line 558: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

554: x_return_status => x_return_status,
555: x_msg_count => x_msg_count,
556: x_msg_data => x_msg_data);
557:
558: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
559: l_return_status := x_return_status;
560: END IF;
561:
562: -- Validate Default Value

Line 564: p_init_msg_list => Fnd_Api.G_FALSE,

560: END IF;
561:
562: -- Validate Default Value
563: Ibc_Validate_Pvt.validate_Default_Value(
564: p_init_msg_list => Fnd_Api.G_FALSE,
565: p_data_type_code => l_attribute_type_rec.data_type_code,
566: p_default_Value => l_attribute_type_rec.Default_value,
567: x_return_status => x_return_status,
568: x_msg_count => x_msg_count,

Line 571: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

567: x_return_status => x_return_status,
568: x_msg_count => x_msg_count,
569: x_msg_data => x_msg_data);
570:
571: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
572: l_return_status := x_return_status;
573: END IF;
574:
575: -- Validate Reference code

Line 577: p_init_msg_list => Fnd_Api.G_FALSE,

573: END IF;
574:
575: -- Validate Reference code
576: Ibc_Validate_Pvt.validate_Reference_Code(
577: p_init_msg_list => Fnd_Api.G_FALSE,
578: p_data_type_Code => l_attribute_type_rec.data_type_Code,
579: p_Reference_Code => l_attribute_type_rec.Reference_Code,
580: x_return_status => x_return_status,
581: x_msg_count => x_msg_count,

Line 584: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

580: x_return_status => x_return_status,
581: x_msg_count => x_msg_count,
582: x_msg_data => x_msg_data);
583:
584: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
585: l_return_status := x_return_status;
586: END IF;
587:
588: -- Default Values for MIN and MAX Instances

Line 590: OR l_attribute_type_rec.min_instances = Fnd_Api.G_MISS_NUM THEN

586: END IF;
587:
588: -- Default Values for MIN and MAX Instances
589: IF l_attribute_type_rec.min_instances IS NULL
590: OR l_attribute_type_rec.min_instances = Fnd_Api.G_MISS_NUM THEN
591: l_attribute_type_rec.min_instances := 0;
592: END IF;
593:
594: -- IF l_attribute_type_rec.max_instances IS NULL

Line 595: -- OR l_attribute_type_rec.max_instances = FND_API.G_MISS_NUM THEN

591: l_attribute_type_rec.min_instances := 0;
592: END IF;
593:
594: -- IF l_attribute_type_rec.max_instances IS NULL
595: -- OR l_attribute_type_rec.max_instances = FND_API.G_MISS_NUM THEN
596: -- l_attribute_type_rec.max_instances := 1;
597: -- END IF;
598:
599: -- Validate Min Max Instances

Line 601: p_init_msg_list => Fnd_Api.G_FALSE,

597: -- END IF;
598:
599: -- Validate Min Max Instances
600: Ibc_Validate_Pvt.validate_Min_Max_Instances(
601: p_init_msg_list => Fnd_Api.G_FALSE,
602: p_Min_Instances => l_attribute_type_rec.Min_instances,
603: p_Max_Instances => l_attribute_type_rec.Max_instances,
604: x_return_status => x_return_status,
605: x_msg_count => x_msg_count,

Line 608: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

604: x_return_status => x_return_status,
605: x_msg_count => x_msg_count,
606: x_msg_data => x_msg_data);
607:
608: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
609: l_return_status := x_return_status;
610: END IF;
611:
612:

Line 618: OR l_attribute_type_rec.OBJECT_VERSION_NUMBER = Fnd_Api.G_MISS_NUM THEN

614:
615:
616: -- Validate Object Version Number
617: IF l_attribute_type_rec.OBJECT_VERSION_NUMBER IS NULL
618: OR l_attribute_type_rec.OBJECT_VERSION_NUMBER = Fnd_Api.G_MISS_NUM THEN
619: l_attribute_type_rec.OBJECT_VERSION_NUMBER := 1;
620: END IF;
621:
622: -- Check for Uniqueness

Line 627: x_return_status := Fnd_Api.G_RET_STS_ERROR;

623: OPEN C_Attribute_Type(p_Content_Type_Code => l_attribute_type_rec.content_type_code
624: ,p_attribute_Type_Code => l_attribute_type_rec.Attribute_type_code);
625: FETCH C_Attribute_Type INTO l_temp;
626: IF C_Attribute_Type%FOUND THEN
627: x_return_status := Fnd_Api.G_RET_STS_ERROR;
628: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
629: Fnd_Message.Set_name('IBC', 'IBC_ALREADY_EXISTS');
630: Fnd_Message.Set_Token('DUPLICATE_OBJECT_TOKEN', 'Attribute_Type_Code',FALSE);
631: Fnd_Msg_Pub.ADD;

Line 639: IF l_return_status<>Fnd_Api.G_RET_STS_SUCCESS

635: CLOSE C_Attribute_Type;
636:
637:
638:
639: IF l_return_status<>Fnd_Api.G_RET_STS_SUCCESS
640: OR x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
641: RAISE Fnd_Api.G_EXC_ERROR;
642: END IF;
643:

Line 640: OR x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

636:
637:
638:
639: IF l_return_status<>Fnd_Api.G_RET_STS_SUCCESS
640: OR x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
641: RAISE Fnd_Api.G_EXC_ERROR;
642: END IF;
643:
644:

Line 641: RAISE Fnd_Api.G_EXC_ERROR;

637:
638:
639: IF l_return_status<>Fnd_Api.G_RET_STS_SUCCESS
640: OR x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
641: RAISE Fnd_Api.G_EXC_ERROR;
642: END IF;
643:
644:
645:

Line 673: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,

669:
670:
671: PROCEDURE Update_Content_Type(
672: P_Api_Version_Number IN NUMBER,
673: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
674: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
675: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
676: P_Content_Type_Rec IN Ibc_Ctype_Pvt.Content_Type_Rec_Type ,--:= Ibc_Ctype_Pvt.G_MISS_Content_Type_Rec,
677: P_Attribute_Type_Tbl IN Ibc_Ctype_Pvt.Attribute_Type_Tbl_Type ,--:= Ibc_Ctype_Pvt.G_Miss_Attribute_Type_Tbl,

Line 674: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,

670:
671: PROCEDURE Update_Content_Type(
672: P_Api_Version_Number IN NUMBER,
673: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
674: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
675: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
676: P_Content_Type_Rec IN Ibc_Ctype_Pvt.Content_Type_Rec_Type ,--:= Ibc_Ctype_Pvt.G_MISS_Content_Type_Rec,
677: P_Attribute_Type_Tbl IN Ibc_Ctype_Pvt.Attribute_Type_Tbl_Type ,--:= Ibc_Ctype_Pvt.G_Miss_Attribute_Type_Tbl,
678: x_Content_Type_Rec OUT NOCOPY Ibc_Ctype_Pvt.Content_Type_Rec_Type,

Line 675: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,

671: PROCEDURE Update_Content_Type(
672: P_Api_Version_Number IN NUMBER,
673: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
674: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
675: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
676: P_Content_Type_Rec IN Ibc_Ctype_Pvt.Content_Type_Rec_Type ,--:= Ibc_Ctype_Pvt.G_MISS_Content_Type_Rec,
677: P_Attribute_Type_Tbl IN Ibc_Ctype_Pvt.Attribute_Type_Tbl_Type ,--:= Ibc_Ctype_Pvt.G_Miss_Attribute_Type_Tbl,
678: x_Content_Type_Rec OUT NOCOPY Ibc_Ctype_Pvt.Content_Type_Rec_Type,
679: x_Attribute_Type_Tbl OUT NOCOPY Ibc_Ctype_Pvt.Attribute_Type_Tbl_Type,

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

698: WHERE content_type_code = p_content_type_code
699: AND attribute_type_code = p_attribute_type_code;
700:
701: l_temp CHAR(1);
702: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
703:
704: l_api_version_number NUMBER := 1.0;
705: l_api_name VARCHAR2(50) := 'Update_Content_Type';
706: l_Content_Type_Code VARCHAR2(100);

Line 716: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

712:
713: BEGIN
714:
715: -- Initialize API return status to SUCCESS
716: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
717:
718: --
719: -- API body
720: --

Line 733: RAISE Fnd_Api.G_EXC_ERROR;

729: Fnd_Message.Set_name(' + appShortname +', 'UT_CANNOT_GET_PROFILE_VALUE');
730: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);
731: Fnd_Msg_Pub.ADD;
732: END IF;
733: RAISE Fnd_Api.G_EXC_ERROR;
734: END IF;
735:
736:
737: IF NOT IsCTypeRecordEmpty(l_content_type_rec) THEN

Line 742: p_init_msg_list => Fnd_Api.G_FALSE,

738:
739: -- Check for all the NOT NULL Columns
740: -- Content_TYpe_Code Cannot be NULL
741: Ibc_Validate_Pvt.validate_NotNULL_VARCHAR2 (
742: p_init_msg_list => Fnd_Api.G_FALSE,
743: p_column_name => 'Content_Type_Code',
744: p_notnull_column=> l_content_type_rec.content_type_code,
745: x_return_status => x_return_status,
746: x_msg_count => x_msg_count,

Line 751: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

747: x_msg_data => x_msg_data);
748:
749: -- Don't RAISE the EXCEPTION Yet. RUN ALL the validation procedures
750: -- and show Exceptions all at once.
751: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
752: l_return_status := x_return_status;
753: END IF;
754:
755:

Line 760: x_return_status := Fnd_Api.G_RET_STS_ERROR;

756: -- Check If the Record Exists
757: OPEN C_Content_Type(p_Content_Type_Code => l_content_type_rec.content_type_code);
758: FETCH C_Content_Type INTO l_Content_Type_Code;
759: IF C_Content_Type%NOTFOUND THEN
760: x_return_status := Fnd_Api.G_RET_STS_ERROR;
761: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
762: Fnd_Message.Set_name('IBC', 'INVALID_CONTENT_TYPE_CODE');
763: Fnd_Message.Set_Token('COLUMN', 'Content_Type_Code', FALSE);
764: Fnd_Msg_Pub.ADD;

Line 767: RAISE Fnd_Api.G_EXC_ERROR;

763: Fnd_Message.Set_Token('COLUMN', 'Content_Type_Code', FALSE);
764: Fnd_Msg_Pub.ADD;
765: END IF;
766: CLOSE C_Content_Type;
767: RAISE Fnd_Api.G_EXC_ERROR;
768: END IF;
769: CLOSE C_Content_Type;
770:
771:

Line 772: IF l_content_type_rec.content_type_status <> Fnd_Api.G_MISS_CHAR THEN

768: END IF;
769: CLOSE C_Content_Type;
770:
771:
772: IF l_content_type_rec.content_type_status <> Fnd_Api.G_MISS_CHAR THEN
773: -- Validate Content Type Status
774: Ibc_Validate_Pvt.validate_Content_Type_Status(
775: p_init_msg_list => Fnd_Api.G_FALSE,
776: p_Content_Type_Status => l_content_type_rec.content_type_status,

Line 775: p_init_msg_list => Fnd_Api.G_FALSE,

771:
772: IF l_content_type_rec.content_type_status <> Fnd_Api.G_MISS_CHAR THEN
773: -- Validate Content Type Status
774: Ibc_Validate_Pvt.validate_Content_Type_Status(
775: p_init_msg_list => Fnd_Api.G_FALSE,
776: p_Content_Type_Status => l_content_type_rec.content_type_status,
777: x_return_status => x_return_status,
778: x_msg_count => x_msg_count,
779: x_msg_data => x_msg_data);

Line 781: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

777: x_return_status => x_return_status,
778: x_msg_count => x_msg_count,
779: x_msg_data => x_msg_data);
780:
781: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
782: l_return_status := x_return_status;
783: END IF;
784: END IF;
785:

Line 787: IF l_content_type_rec.application_id <> Fnd_Api.G_MISS_NUM THEN

783: END IF;
784: END IF;
785:
786:
787: IF l_content_type_rec.application_id <> Fnd_Api.G_MISS_NUM THEN
788: -- Validate Application Id
789: Ibc_Validate_Pvt.validate_application_id(
790: p_init_msg_list => Fnd_Api.G_FALSE,
791: p_application_id => l_content_type_rec.application_id,

Line 790: p_init_msg_list => Fnd_Api.G_FALSE,

786:
787: IF l_content_type_rec.application_id <> Fnd_Api.G_MISS_NUM THEN
788: -- Validate Application Id
789: Ibc_Validate_Pvt.validate_application_id(
790: p_init_msg_list => Fnd_Api.G_FALSE,
791: p_application_id => l_content_type_rec.application_id,
792: x_return_status => x_return_status,
793: x_msg_count => x_msg_count,
794: x_msg_data => x_msg_data);

Line 796: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS

792: x_return_status => x_return_status,
793: x_msg_count => x_msg_count,
794: x_msg_data => x_msg_data);
795:
796: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS
797: OR l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
798: RAISE Fnd_Api.G_EXC_ERROR;
799: END IF;
800: END IF;

Line 797: OR l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

793: x_msg_count => x_msg_count,
794: x_msg_data => x_msg_data);
795:
796: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS
797: OR l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
798: RAISE Fnd_Api.G_EXC_ERROR;
799: END IF;
800: END IF;
801:

Line 798: RAISE Fnd_Api.G_EXC_ERROR;

794: x_msg_data => x_msg_data);
795:
796: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS
797: OR l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
798: RAISE Fnd_Api.G_EXC_ERROR;
799: END IF;
800: END IF;
801:
802: --

Line 836: P_Validation_Level =>Fnd_Api.G_VALID_LEVEL_FULL,

832: Create_Attribute_Type(
833: P_Api_Version_Number =>P_Api_Version_Number,
834: P_Init_Msg_List =>P_Init_Msg_List,
835: P_Commit =>P_Commit,
836: P_Validation_Level =>Fnd_Api.G_VALID_LEVEL_FULL,
837: P_Attribute_Type_Rec =>l_Attribute_Type_Tbl(i),
838: X_Return_Status =>X_Return_Status,
839: X_Msg_Count =>X_Msg_Count,
840: X_Msg_Data =>X_Msg_Data);

Line 848: P_Validation_Level =>Fnd_Api.G_VALID_LEVEL_FULL,

844: Update_Attribute_Type(
845: P_Api_Version_Number =>P_Api_Version_Number,
846: P_Init_Msg_List =>P_Init_Msg_List,
847: P_Commit =>P_Commit,
848: P_Validation_Level =>Fnd_Api.G_VALID_LEVEL_FULL,
849: P_Attribute_Type_Rec =>l_Attribute_Type_Tbl(i),
850: X_Return_Status =>X_Return_Status,
851: X_Msg_Count =>X_Msg_Count,
852: X_Msg_Data =>X_Msg_Data);

Line 860: P_Validation_Level =>Fnd_Api.G_VALID_LEVEL_FULL,

856: Delete_Attribute_Type(
857: P_Api_Version_Number =>P_Api_Version_Number,
858: P_Init_Msg_List =>P_Init_Msg_List,
859: P_Commit =>P_Commit,
860: P_Validation_Level =>Fnd_Api.G_VALID_LEVEL_FULL,
861: P_Attribute_Type_Rec =>l_Attribute_Type_Tbl(i),
862: X_Return_Status =>X_Return_Status,
863: X_Msg_Count =>X_Msg_Count,
864: X_Msg_Data =>X_Msg_Data);

Line 875: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

871:
872: END IF;
873:
874: ---
875: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
876: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
877: Fnd_Message.Set_name('IBC', 'IBC_UPDATE_ERROR');
878: Fnd_Msg_Pub.ADD;
879: END IF;

Line 881: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN

877: Fnd_Message.Set_name('IBC', 'IBC_UPDATE_ERROR');
878: Fnd_Msg_Pub.ADD;
879: END IF;
880:
881: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
882: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
883: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
884: RAISE Fnd_Api.G_EXC_ERROR;
885: END IF;

Line 882: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

878: Fnd_Msg_Pub.ADD;
879: END IF;
880:
881: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
882: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
883: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
884: RAISE Fnd_Api.G_EXC_ERROR;
885: END IF;
886: END IF;

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

879: END IF;
880:
881: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
882: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
883: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
884: RAISE Fnd_Api.G_EXC_ERROR;
885: END IF;
886: END IF;
887:

Line 884: RAISE Fnd_Api.G_EXC_ERROR;

880:
881: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
882: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
883: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
884: RAISE Fnd_Api.G_EXC_ERROR;
885: END IF;
886: END IF;
887:
888: --

Line 893: IF Fnd_Api.to_Boolean( p_commit )

889: -- End of API body
890: --
891:
892: -- Standard check for p_commit
893: IF Fnd_Api.to_Boolean( p_commit )
894: THEN
895: COMMIT WORK;
896: END IF;
897:

Line 906: WHEN Fnd_Api.G_EXC_ERROR THEN

902: );
903:
904:
905: EXCEPTION
906: WHEN Fnd_Api.G_EXC_ERROR THEN
907: ROLLBACK;
908: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
909: P_API_name => L_API_name
910: ,P_PKG_name => G_PKG_name

Line 919: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

915: ,X_MSG_COUNT => X_MSG_COUNT
916: ,X_MSG_DATA => X_MSG_DATA
917: ,X_RETURN_STATUS => X_RETURN_STATUS);
918:
919: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
920: ROLLBACK;
921: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
922: P_API_name => L_API_name
923: ,P_PKG_name => G_PKG_name

Line 950: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,

946:
947:
948: PROCEDURE Delete_Content_Type(
949: P_Api_Version_Number IN NUMBER,
950: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
951: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
952: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
953: P_Content_Type_Code IN VARCHAR2,
954: X_Return_Status OUT NOCOPY VARCHAR2,

Line 951: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,

947:
948: PROCEDURE Delete_Content_Type(
949: P_Api_Version_Number IN NUMBER,
950: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
951: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
952: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
953: P_Content_Type_Code IN VARCHAR2,
954: X_Return_Status OUT NOCOPY VARCHAR2,
955: X_Msg_Count OUT NOCOPY NUMBER,

Line 952: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,

948: PROCEDURE Delete_Content_Type(
949: P_Api_Version_Number IN NUMBER,
950: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
951: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
952: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
953: P_Content_Type_Code IN VARCHAR2,
954: X_Return_Status OUT NOCOPY VARCHAR2,
955: X_Msg_Count OUT NOCOPY NUMBER,
956: X_Msg_Data OUT NOCOPY VARCHAR2

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

969: SELECT attribute_Type_code
970: FROM IBC_ATTRIBUTE_TYPES_B
971: WHERE Reference_code = p_content_type_code;
972:
973: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
974:
975: l_api_version_number NUMBER := 1.0;
976: l_api_name VARCHAR2(50) := 'Delete_Content_Type';
977: l_Content_Type_Code VARCHAR2(100);

Line 983: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

979:
980: BEGIN
981:
982: -- Initialize API return status to SUCCESS
983: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
984:
985: --
986: -- API body
987: --

Line 1000: RAISE Fnd_Api.G_EXC_ERROR;

996: Fnd_Message.Set_name(' + appShortname +', 'UT_CANNOT_GET_PROFILE_VALUE');
997: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);
998: Fnd_Msg_Pub.ADD;
999: END IF;
1000: RAISE Fnd_Api.G_EXC_ERROR;
1001: END IF;
1002:
1003:
1004: -- Check for all the NOT NULL Columns

Line 1007: p_init_msg_list => Fnd_Api.G_FALSE,

1003:
1004: -- Check for all the NOT NULL Columns
1005: -- Content_TYpe_Code Cannot be NULL
1006: Ibc_Validate_Pvt.validate_NotNULL_VARCHAR2 (
1007: p_init_msg_list => Fnd_Api.G_FALSE,
1008: p_column_name => 'Content_Type_Code',
1009: p_notnull_column=> p_content_type_code,
1010: x_return_status => x_return_status,
1011: x_msg_count => x_msg_count,

Line 1016: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

1012: x_msg_data => x_msg_data);
1013:
1014: -- Don't RAISE the EXCEPTION Yet. RUN ALL the validation procedures
1015: -- and show Exceptions all at once.
1016: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
1017: l_return_status := x_return_status;
1018: END IF;
1019:
1020:

Line 1031: RAISE Fnd_Api.G_EXC_ERROR;

1027: Fnd_Message.Set_Token('COLUMN', 'Content_Type_Code', FALSE);
1028: Fnd_Msg_Pub.ADD;
1029: END IF;
1030: CLOSE C_Content_Type;
1031: RAISE Fnd_Api.G_EXC_ERROR;
1032: END IF;
1033: CLOSE C_Content_Type;
1034:
1035: OPEN C_Attribute_Type;

Line 1044: RAISE Fnd_Api.G_EXC_ERROR;

1040: Fnd_Message.Set_Token('COLUMN', 'Content_Type_Code', FALSE);
1041: Fnd_Msg_Pub.ADD;
1042: END IF;
1043: CLOSE C_Attribute_Type;
1044: RAISE Fnd_Api.G_EXC_ERROR;
1045: END IF;
1046: CLOSE C_Attribute_Type;
1047:
1048:

Line 1049: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS

1045: END IF;
1046: CLOSE C_Attribute_Type;
1047:
1048:
1049: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS
1050: OR l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1051: RAISE Fnd_Api.G_EXC_ERROR;
1052: END IF;
1053:

Line 1050: OR l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

1046: CLOSE C_Attribute_Type;
1047:
1048:
1049: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS
1050: OR l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1051: RAISE Fnd_Api.G_EXC_ERROR;
1052: END IF;
1053:
1054: --

Line 1051: RAISE Fnd_Api.G_EXC_ERROR;

1047:
1048:
1049: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS
1050: OR l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1051: RAISE Fnd_Api.G_EXC_ERROR;
1052: END IF;
1053:
1054: --
1055: -- Table Handler to Delete Row from IBC_ATTRIBUTE_TYPES

Line 1071: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

1067: Ibc_Content_Types_Pkg.DELETE_ROW (
1068: p_CONTENT_TYPE_CODE =>p_CONTENT_TYPE_CODE);
1069:
1070:
1071: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
1072: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1073: Fnd_Message.Set_name('IBC', 'IBC_DELETE_ERROR');
1074: Fnd_Msg_Pub.ADD;
1075: END IF;

Line 1077: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN

1073: Fnd_Message.Set_name('IBC', 'IBC_DELETE_ERROR');
1074: Fnd_Msg_Pub.ADD;
1075: END IF;
1076:
1077: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
1078: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1079: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
1080: RAISE Fnd_Api.G_EXC_ERROR;
1081: END IF;

Line 1078: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

1074: Fnd_Msg_Pub.ADD;
1075: END IF;
1076:
1077: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
1078: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1079: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
1080: RAISE Fnd_Api.G_EXC_ERROR;
1081: END IF;
1082: END IF;

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

1075: END IF;
1076:
1077: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
1078: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1079: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
1080: RAISE Fnd_Api.G_EXC_ERROR;
1081: END IF;
1082: END IF;
1083:

Line 1080: RAISE Fnd_Api.G_EXC_ERROR;

1076:
1077: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
1078: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1079: ELSIF (x_return_status = Fnd_Api.G_RET_STS_ERROR) THEN
1080: RAISE Fnd_Api.G_EXC_ERROR;
1081: END IF;
1082: END IF;
1083:
1084: --

Line 1089: IF Fnd_Api.to_Boolean( p_commit )

1085: -- End of API body
1086: --
1087:
1088: -- Standard check for p_commit
1089: IF Fnd_Api.to_Boolean( p_commit )
1090: THEN
1091: COMMIT WORK;
1092: END IF;
1093:

Line 1102: WHEN Fnd_Api.G_EXC_ERROR THEN

1098: );
1099:
1100:
1101: EXCEPTION
1102: WHEN Fnd_Api.G_EXC_ERROR THEN
1103: ROLLBACK;
1104: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
1105: P_API_name => L_API_name
1106: ,P_PKG_name => G_PKG_name

Line 1115: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

1111: ,X_MSG_COUNT => X_MSG_COUNT
1112: ,X_MSG_DATA => X_MSG_DATA
1113: ,X_RETURN_STATUS => X_RETURN_STATUS);
1114:
1115: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1116: ROLLBACK;
1117: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
1118: P_API_name => L_API_name
1119: ,P_PKG_name => G_PKG_name

Line 1145: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,

1141: END Delete_Content_Type;
1142:
1143: PROCEDURE Update_Attribute_Type(
1144: P_Api_Version_Number IN NUMBER,
1145: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
1146: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
1147: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
1148: P_Attribute_Type_Rec IN Ibc_Ctype_Pvt.Attribute_Type_Rec_Type,
1149: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1146: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,

1142:
1143: PROCEDURE Update_Attribute_Type(
1144: P_Api_Version_Number IN NUMBER,
1145: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
1146: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
1147: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
1148: P_Attribute_Type_Rec IN Ibc_Ctype_Pvt.Attribute_Type_Rec_Type,
1149: X_Return_Status OUT NOCOPY VARCHAR2,
1150: X_Msg_Count OUT NOCOPY NUMBER,

Line 1147: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,

1143: PROCEDURE Update_Attribute_Type(
1144: P_Api_Version_Number IN NUMBER,
1145: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
1146: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
1147: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
1148: P_Attribute_Type_Rec IN Ibc_Ctype_Pvt.Attribute_Type_Rec_Type,
1149: X_Return_Status OUT NOCOPY VARCHAR2,
1150: X_Msg_Count OUT NOCOPY NUMBER,
1151: X_Msg_Data OUT NOCOPY VARCHAR2

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

1165: WHERE content_type_code = p_content_type_code
1166: AND attribute_type_code = p_attribute_type_code;
1167:
1168: l_temp CHAR(1);
1169: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
1170:
1171: l_api_version_number NUMBER := 1.0;
1172: l_api_name VARCHAR2(50) := 'Update_Attribute_Type';
1173: lx_rowid VARCHAR2(240);

Line 1182: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1178:
1179: BEGIN
1180:
1181: -- Initialize API return status to SUCCESS
1182: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1183:
1184: -- Check If Row exists
1185: l_old_attribute_type_rec := Query_Attribute_Type_Row
1186: (p_Content_Type_Code => l_attribute_type_rec.content_type_code

Line 1194: p_init_msg_list => Fnd_Api.G_FALSE,

1190: -- Begin Validation for Attribute Type Record
1191: -- Check for all the NOT NULL Columns
1192: -- Attribute_Type_Code Cannot be NULL
1193: Ibc_Validate_Pvt.validate_NotNULL_VARCHAR2 (
1194: p_init_msg_list => Fnd_Api.G_FALSE,
1195: p_column_name => 'Attribute_Type_Code',
1196: p_notnull_column=> l_attribute_type_rec.attribute_type_code,
1197: x_return_status => x_return_status,
1198: x_msg_count => x_msg_count,

Line 1201: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

1197: x_return_status => x_return_status,
1198: x_msg_count => x_msg_count,
1199: x_msg_data => x_msg_data);
1200:
1201: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
1202: l_return_status := x_return_status;
1203: END IF;
1204:
1205: --

Line 1208: p_init_msg_list => Fnd_Api.G_FALSE,

1204:
1205: --
1206: -- Validate the Content Type Code in Attribute Rec
1207: Ibc_Validate_Pvt.validate_NotNULL_VARCHAR2 (
1208: p_init_msg_list => Fnd_Api.G_FALSE,
1209: p_column_name => 'Content_Type_Code',
1210: p_notnull_column=> l_attribute_type_rec.Content_Type_Code,
1211: x_return_status => x_return_status,
1212: x_msg_count => x_msg_count,

Line 1215: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

1211: x_return_status => x_return_status,
1212: x_msg_count => x_msg_count,
1213: x_msg_data => x_msg_data);
1214:
1215: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
1216: l_return_status := x_return_status;
1217: END IF;
1218:
1219:

Line 1220: IF l_attribute_type_rec.Attribute_type_name <> Fnd_Api.G_MISS_CHAR THEN

1216: l_return_status := x_return_status;
1217: END IF;
1218:
1219:
1220: IF l_attribute_type_rec.Attribute_type_name <> Fnd_Api.G_MISS_CHAR THEN
1221: -- Content_TYpe_name Cannot be NULL
1222: Ibc_Validate_Pvt.validate_NotNULL_VARCHAR2 (
1223: p_init_msg_list => Fnd_Api.G_FALSE,
1224: p_column_name => 'Attribute_Type_name',

Line 1223: p_init_msg_list => Fnd_Api.G_FALSE,

1219:
1220: IF l_attribute_type_rec.Attribute_type_name <> Fnd_Api.G_MISS_CHAR THEN
1221: -- Content_TYpe_name Cannot be NULL
1222: Ibc_Validate_Pvt.validate_NotNULL_VARCHAR2 (
1223: p_init_msg_list => Fnd_Api.G_FALSE,
1224: p_column_name => 'Attribute_Type_name',
1225: p_notnull_column=> l_attribute_type_rec.Attribute_type_name,
1226: x_return_status => x_return_status,
1227: x_msg_count => x_msg_count,

Line 1230: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

1226: x_return_status => x_return_status,
1227: x_msg_count => x_msg_count,
1228: x_msg_data => x_msg_data);
1229:
1230: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
1231: l_return_status := x_return_status;
1232: END IF;
1233:
1234: END IF;

Line 1237: IF l_attribute_type_rec.Data_Type_code <> Fnd_Api.G_MISS_CHAR THEN

1233:
1234: END IF;
1235:
1236:
1237: IF l_attribute_type_rec.Data_Type_code <> Fnd_Api.G_MISS_CHAR THEN
1238: -- Data_Type_Code Cannot be NULL
1239: Ibc_Validate_Pvt.validate_NotNULL_VARCHAR2 (
1240: p_init_msg_list => Fnd_Api.G_FALSE,
1241: p_column_name => 'Data_Type_code',

Line 1240: p_init_msg_list => Fnd_Api.G_FALSE,

1236:
1237: IF l_attribute_type_rec.Data_Type_code <> Fnd_Api.G_MISS_CHAR THEN
1238: -- Data_Type_Code Cannot be NULL
1239: Ibc_Validate_Pvt.validate_NotNULL_VARCHAR2 (
1240: p_init_msg_list => Fnd_Api.G_FALSE,
1241: p_column_name => 'Data_Type_code',
1242: p_notnull_column=> l_attribute_type_rec.Data_Type_code,
1243: x_return_status => x_return_status,
1244: x_msg_count => x_msg_count,

Line 1247: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

1243: x_return_status => x_return_status,
1244: x_msg_count => x_msg_count,
1245: x_msg_data => x_msg_data);
1246:
1247: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
1248: l_return_status := x_return_status;
1249: END IF;
1250:
1251: END IF;

Line 1254: IF l_attribute_type_rec.Data_Type_code <> Fnd_Api.G_MISS_CHAR THEN

1250:
1251: END IF;
1252:
1253:
1254: IF l_attribute_type_rec.Data_Type_code <> Fnd_Api.G_MISS_CHAR THEN
1255: -- Validate Data Type Code
1256: Ibc_Validate_Pvt.validate_Data_Type_Code(
1257: p_init_msg_list => Fnd_Api.G_FALSE,
1258: p_data_Type_Code => l_attribute_type_rec.Data_Type_code,

Line 1257: p_init_msg_list => Fnd_Api.G_FALSE,

1253:
1254: IF l_attribute_type_rec.Data_Type_code <> Fnd_Api.G_MISS_CHAR THEN
1255: -- Validate Data Type Code
1256: Ibc_Validate_Pvt.validate_Data_Type_Code(
1257: p_init_msg_list => Fnd_Api.G_FALSE,
1258: p_data_Type_Code => l_attribute_type_rec.Data_Type_code,
1259: x_return_status => x_return_status,
1260: x_msg_count => x_msg_count,
1261: x_msg_data => x_msg_data);

Line 1263: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

1259: x_return_status => x_return_status,
1260: x_msg_count => x_msg_count,
1261: x_msg_data => x_msg_data);
1262:
1263: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
1264: l_return_status := x_return_status;
1265: END IF;
1266: END IF;
1267:

Line 1269: IF l_attribute_type_rec.Default_value <> Fnd_Api.G_MISS_CHAR THEN

1265: END IF;
1266: END IF;
1267:
1268:
1269: IF l_attribute_type_rec.Default_value <> Fnd_Api.G_MISS_CHAR THEN
1270:
1271: IF l_attribute_type_rec.Data_Type_code = Fnd_Api.G_MISS_CHAR THEN
1272: l_attribute_type_rec.data_type_code := l_old_attribute_type_rec.data_type_code;
1273: END IF;

Line 1271: IF l_attribute_type_rec.Data_Type_code = Fnd_Api.G_MISS_CHAR THEN

1267:
1268:
1269: IF l_attribute_type_rec.Default_value <> Fnd_Api.G_MISS_CHAR THEN
1270:
1271: IF l_attribute_type_rec.Data_Type_code = Fnd_Api.G_MISS_CHAR THEN
1272: l_attribute_type_rec.data_type_code := l_old_attribute_type_rec.data_type_code;
1273: END IF;
1274:
1275: -- Validate Default Value

Line 1277: p_init_msg_list => Fnd_Api.G_FALSE,

1273: END IF;
1274:
1275: -- Validate Default Value
1276: Ibc_Validate_Pvt.validate_Default_Value(
1277: p_init_msg_list => Fnd_Api.G_FALSE,
1278: p_data_type_code => l_attribute_type_rec.data_type_code,
1279: p_default_Value => l_attribute_type_rec.Default_value,
1280: x_return_status => x_return_status,
1281: x_msg_count => x_msg_count,

Line 1284: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

1280: x_return_status => x_return_status,
1281: x_msg_count => x_msg_count,
1282: x_msg_data => x_msg_data);
1283:
1284: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
1285: l_return_status := x_return_status;
1286: END IF;
1287: END IF;
1288:

Line 1290: IF l_attribute_type_rec.Reference_Code <> Fnd_Api.G_MISS_CHAR THEN

1286: END IF;
1287: END IF;
1288:
1289:
1290: IF l_attribute_type_rec.Reference_Code <> Fnd_Api.G_MISS_CHAR THEN
1291:
1292: IF l_attribute_type_rec.Data_Type_code = Fnd_Api.G_MISS_CHAR THEN
1293: l_attribute_type_rec.data_type_code := l_old_attribute_type_rec.data_type_code;
1294: END IF;

Line 1292: IF l_attribute_type_rec.Data_Type_code = Fnd_Api.G_MISS_CHAR THEN

1288:
1289:
1290: IF l_attribute_type_rec.Reference_Code <> Fnd_Api.G_MISS_CHAR THEN
1291:
1292: IF l_attribute_type_rec.Data_Type_code = Fnd_Api.G_MISS_CHAR THEN
1293: l_attribute_type_rec.data_type_code := l_old_attribute_type_rec.data_type_code;
1294: END IF;
1295:
1296: -- Validate Reference code

Line 1298: p_init_msg_list => Fnd_Api.G_FALSE,

1294: END IF;
1295:
1296: -- Validate Reference code
1297: Ibc_Validate_Pvt.validate_Reference_Code(
1298: p_init_msg_list => Fnd_Api.G_FALSE,
1299: p_data_type_Code => l_attribute_type_rec.data_type_Code,
1300: p_Reference_Code => l_attribute_type_rec.Reference_Code,
1301: x_return_status => x_return_status,
1302: x_msg_count => x_msg_count,

Line 1305: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

1301: x_return_status => x_return_status,
1302: x_msg_count => x_msg_count,
1303: x_msg_data => x_msg_data);
1304:
1305: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
1306: l_return_status := x_return_status;
1307: END IF;
1308:
1309: END IF;

Line 1321: IF l_attribute_type_rec.Min_instances = Fnd_Api.G_MISS_NUM THEN

1317: -- IF l_attribute_type_rec.max_instances IS NULL THEN
1318: -- l_attribute_type_rec.max_instances := 1;
1319: -- END IF;
1320:
1321: IF l_attribute_type_rec.Min_instances = Fnd_Api.G_MISS_NUM THEN
1322: l_attribute_type_rec.Min_instances := l_old_attribute_type_rec.Min_instances;
1323: END IF;
1324:
1325: IF l_attribute_type_rec.Max_instances = Fnd_Api.G_MISS_NUM THEN

Line 1325: IF l_attribute_type_rec.Max_instances = Fnd_Api.G_MISS_NUM THEN

1321: IF l_attribute_type_rec.Min_instances = Fnd_Api.G_MISS_NUM THEN
1322: l_attribute_type_rec.Min_instances := l_old_attribute_type_rec.Min_instances;
1323: END IF;
1324:
1325: IF l_attribute_type_rec.Max_instances = Fnd_Api.G_MISS_NUM THEN
1326: l_attribute_type_rec.Max_instances := l_old_attribute_type_rec.Max_instances;
1327: END IF;
1328:
1329: -- Validate Min Max Instances

Line 1331: p_init_msg_list => Fnd_Api.G_FALSE,

1327: END IF;
1328:
1329: -- Validate Min Max Instances
1330: Ibc_Validate_Pvt.validate_Min_Max_Instances(
1331: p_init_msg_list => Fnd_Api.G_FALSE,
1332: p_Min_Instances => l_attribute_type_rec.Min_instances,
1333: p_Max_Instances => l_attribute_type_rec.Max_instances,
1334: x_return_status => x_return_status,
1335: x_msg_count => x_msg_count,

Line 1338: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

1334: x_return_status => x_return_status,
1335: x_msg_count => x_msg_count,
1336: x_msg_data => x_msg_data);
1337:
1338: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
1339: l_return_status := x_return_status;
1340: END IF;
1341:
1342:

Line 1343: IF l_return_status<>Fnd_Api.G_RET_STS_SUCCESS

1339: l_return_status := x_return_status;
1340: END IF;
1341:
1342:
1343: IF l_return_status<>Fnd_Api.G_RET_STS_SUCCESS
1344: OR x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
1345: x_return_status := l_return_status;
1346: RAISE Fnd_Api.G_EXC_ERROR;
1347: END IF;

Line 1344: OR x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

1340: END IF;
1341:
1342:
1343: IF l_return_status<>Fnd_Api.G_RET_STS_SUCCESS
1344: OR x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
1345: x_return_status := l_return_status;
1346: RAISE Fnd_Api.G_EXC_ERROR;
1347: END IF;
1348:

Line 1346: RAISE Fnd_Api.G_EXC_ERROR;

1342:
1343: IF l_return_status<>Fnd_Api.G_RET_STS_SUCCESS
1344: OR x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
1345: x_return_status := l_return_status;
1346: RAISE Fnd_Api.G_EXC_ERROR;
1347: END IF;
1348:
1349:
1350: -- End Validation for Attribute Type Record

Line 1375: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,

1371:
1372:
1373: PROCEDURE Delete_Attribute_Type(
1374: P_Api_Version_Number IN NUMBER,
1375: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
1376: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
1377: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
1378: P_Attribute_Type_Rec IN Ibc_Ctype_Pvt.Attribute_Type_Rec_Type,
1379: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1376: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,

1372:
1373: PROCEDURE Delete_Attribute_Type(
1374: P_Api_Version_Number IN NUMBER,
1375: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
1376: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
1377: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
1378: P_Attribute_Type_Rec IN Ibc_Ctype_Pvt.Attribute_Type_Rec_Type,
1379: X_Return_Status OUT NOCOPY VARCHAR2,
1380: X_Msg_Count OUT NOCOPY NUMBER,

Line 1377: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,

1373: PROCEDURE Delete_Attribute_Type(
1374: P_Api_Version_Number IN NUMBER,
1375: P_Init_Msg_List IN VARCHAR2 ,--:= FND_API.G_FALSE,
1376: P_Commit IN VARCHAR2 ,--:= FND_API.G_FALSE,
1377: P_Validation_Level IN NUMBER ,--:= FND_API.G_VALID_LEVEL_FULL,
1378: P_Attribute_Type_Rec IN Ibc_Ctype_Pvt.Attribute_Type_Rec_Type,
1379: X_Return_Status OUT NOCOPY VARCHAR2,
1380: X_Msg_Count OUT NOCOPY NUMBER,
1381: X_Msg_Data OUT NOCOPY VARCHAR2

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

1380: X_Msg_Count OUT NOCOPY NUMBER,
1381: X_Msg_Data OUT NOCOPY VARCHAR2
1382: )
1383: IS
1384: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
1385: l_api_name VARCHAR2(50) := 'Delete_Attribute_Type';
1386: l_attribute_type_rec Ibc_Ctype_Pvt.Attribute_Type_Rec_Type := P_Attribute_Type_Rec;
1387:
1388: BEGIN

Line 1391: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1387:
1388: BEGIN
1389:
1390: -- Initialize API return status to SUCCESS
1391: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1392:
1393: IF l_attribute_type_rec.attribute_type_code IN (G_NAME,G_DESCRIPTION) THEN
1394: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1395: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

Line 1394: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1390: -- Initialize API return status to SUCCESS
1391: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1392:
1393: IF l_attribute_type_rec.attribute_type_code IN (G_NAME,G_DESCRIPTION) THEN
1394: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1395: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1396: Fnd_Message.Set_name('IBC', 'Name OR Description Cannot be Deleted');
1397: Fnd_Msg_Pub.ADD;
1398: END IF;

Line 1399: RAISE Fnd_Api.G_EXC_ERROR;

1395: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1396: Fnd_Message.Set_name('IBC', 'Name OR Description Cannot be Deleted');
1397: Fnd_Msg_Pub.ADD;
1398: END IF;
1399: RAISE Fnd_Api.G_EXC_ERROR;
1400: END IF;
1401:
1402: -- Begin Validation for Attribute Type Record
1403: -- Check for all the NOT NULL Columns

Line 1406: p_init_msg_list => Fnd_Api.G_FALSE,

1402: -- Begin Validation for Attribute Type Record
1403: -- Check for all the NOT NULL Columns
1404: -- Attribute_Type_Code Cannot be NULL
1405: Ibc_Validate_Pvt.validate_NotNULL_VARCHAR2 (
1406: p_init_msg_list => Fnd_Api.G_FALSE,
1407: p_column_name => 'Attribute_Type_Code',
1408: p_notnull_column=> l_attribute_type_rec.attribute_type_code,
1409: x_return_status => x_return_status,
1410: x_msg_count => x_msg_count,

Line 1413: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

1409: x_return_status => x_return_status,
1410: x_msg_count => x_msg_count,
1411: x_msg_data => x_msg_data);
1412:
1413: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
1414: l_return_status := x_return_status;
1415: END IF;
1416:
1417: --

Line 1420: p_init_msg_list => Fnd_Api.G_FALSE,

1416:
1417: --
1418: -- Validate the Content Type Code in Attribute Rec
1419: Ibc_Validate_Pvt.validate_NotNULL_VARCHAR2 (
1420: p_init_msg_list => Fnd_Api.G_FALSE,
1421: p_column_name => 'Content_Type_Code',
1422: p_notnull_column=> l_attribute_type_rec.Content_Type_Code,
1423: x_return_status => x_return_status,
1424: x_msg_count => x_msg_count,

Line 1427: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

1423: x_return_status => x_return_status,
1424: x_msg_count => x_msg_count,
1425: x_msg_data => x_msg_data);
1426:
1427: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
1428: l_return_status := x_return_status;
1429: END IF;
1430:
1431:

Line 1432: IF l_return_status<>Fnd_Api.G_RET_STS_SUCCESS

1428: l_return_status := x_return_status;
1429: END IF;
1430:
1431:
1432: IF l_return_status<>Fnd_Api.G_RET_STS_SUCCESS
1433: OR x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
1434: x_return_status := l_return_status;
1435: RAISE Fnd_Api.G_EXC_ERROR;
1436: END IF;

Line 1433: OR x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN

1429: END IF;
1430:
1431:
1432: IF l_return_status<>Fnd_Api.G_RET_STS_SUCCESS
1433: OR x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
1434: x_return_status := l_return_status;
1435: RAISE Fnd_Api.G_EXC_ERROR;
1436: END IF;
1437:

Line 1435: RAISE Fnd_Api.G_EXC_ERROR;

1431:
1432: IF l_return_status<>Fnd_Api.G_RET_STS_SUCCESS
1433: OR x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
1434: x_return_status := l_return_status;
1435: RAISE Fnd_Api.G_EXC_ERROR;
1436: END IF;
1437:
1438:
1439: Ibc_Attribute_Types_Pkg.delete_row (

Line 1450: ,P_Init_Msg_List IN VARCHAR2 --:= FND_API.G_FALSE

1446:
1447:
1448: PROCEDURE get_Attribute_Type_LOV(
1449: P_Api_Version_Number IN NUMBER
1450: ,P_Init_Msg_List IN VARCHAR2 --:= FND_API.G_FALSE
1451: ,p_content_type_code IN VARCHAR2 --1
1452: ,p_attribute_type_code IN VARCHAR2 --2
1453: ,x_code OUT NOCOPY JTF_VARCHAR2_TABLE_100 --4
1454: ,x_name OUT NOCOPY JTF_VARCHAR2_TABLE_300 -- 5

Line 1477: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1473: l_api_name VARCHAR2(30) := 'Get_Attribute_Type_LOV';
1474:
1475: BEGIN
1476:
1477: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1478:
1479: OPEN C_attribs;
1480: FETCH C_attribs INTO l_value_set_id,l_vset_type;
1481:

Line 1490: -- RAISE FND_API.G_EXC_ERROR;

1486: -- FND_MESSAGE.Set_name('IBC', 'Invalid Flex Value SET');
1487: -- FND_MESSAGE.Set_Token('COLUMN',p_attribute_type_code, FALSE);
1488: -- FND_MSG_PUB.ADD;
1489: -- CLOSE C_attribs;
1490: -- RAISE FND_API.G_EXC_ERROR;
1491: -- END IF;
1492:
1493: CLOSE C_ATTRIBS;
1494:

Line 1535: WHEN Fnd_Api.G_EXC_ERROR THEN

1531: );
1532:
1533:
1534: EXCEPTION
1535: WHEN Fnd_Api.G_EXC_ERROR THEN
1536: ROLLBACK;
1537: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
1538: P_API_name => L_API_name
1539: ,P_PKG_name => G_PKG_name

Line 1548: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

1544: ,X_MSG_COUNT => X_MSG_COUNT
1545: ,X_MSG_DATA => X_MSG_DATA
1546: ,X_RETURN_STATUS => X_RETURN_STATUS);
1547:
1548: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1549: ROLLBACK;
1550: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
1551: P_API_name => L_API_name
1552: ,P_PKG_name => G_PKG_name

Line 1579: ,p_init_msg_list IN VARCHAR2 --DEFAULT FND_API.g_false

1575:
1576:
1577: PROCEDURE get_Content_Type(
1578: p_api_version_number IN NUMBER --DEFAULT 1.0
1579: ,p_init_msg_list IN VARCHAR2 --DEFAULT FND_API.g_false
1580: ,p_content_type_code IN VARCHAR2 -- 1
1581: ,x_content_type_name OUT NOCOPY VARCHAR2 -- 2
1582: ,x_content_type_description OUT NOCOPY VARCHAR2 -- 3
1583: ,x_content_type_status OUT NOCOPY VARCHAR2 -- 4

Line 1660: IF l_language IS NULL OR l_language = Fnd_Api.G_MISS_CHAR THEN

1656: l_temp CHAR(1);
1657:
1658: BEGIN
1659:
1660: IF l_language IS NULL OR l_language = Fnd_Api.G_MISS_CHAR THEN
1661: l_language := USERENV('LANG');
1662: ELSE
1663: OPEN CUR_LANG;
1664: FETCH CUR_LANG INTO l_temp;

Line 1670: RAISE Fnd_Api.G_EXC_ERROR;

1666: Fnd_Message.Set_name('IBC', 'IBC_INVALID_LANGUAGE_CODE');
1667: Fnd_Message.Set_Token('COLUMN', 'LANGUAGE', FALSE);
1668: Fnd_Msg_Pub.ADD;
1669: CLOSE CUR_LANG;
1670: RAISE Fnd_Api.G_EXC_ERROR;
1671: END IF;
1672: END IF;
1673:
1674:

Line 1677: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1673:
1674:
1675:
1676: -- Initialize API return status to SUCCESS
1677: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1678:
1679: OPEN Cur_Content_Type(l_language);
1680: FETCH Cur_Content_Type INTO x_content_type_name
1681: ,x_content_type_description

Line 1688: RAISE Fnd_Api.G_EXC_ERROR;

1684: Fnd_Message.Set_name('IBC', 'Invalid Content TYPE Code');
1685: Fnd_Message.Set_Token('COLUMN', 'Content_Type_Code', FALSE);
1686: Fnd_Msg_Pub.ADD;
1687: CLOSE Cur_Content_Type;
1688: RAISE Fnd_Api.G_EXC_ERROR;
1689: END IF;
1690: CLOSE Cur_Content_Type;
1691:
1692:

Line 1737: WHEN Fnd_Api.G_EXC_ERROR THEN

1733: );
1734:
1735:
1736: EXCEPTION
1737: WHEN Fnd_Api.G_EXC_ERROR THEN
1738: ROLLBACK;
1739: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
1740: P_API_name => L_API_name
1741: ,P_PKG_name => G_PKG_name

Line 1750: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

1746: ,X_MSG_COUNT => X_MSG_COUNT
1747: ,X_MSG_DATA => X_MSG_DATA
1748: ,X_RETURN_STATUS => X_RETURN_STATUS);
1749:
1750: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1751: ROLLBACK;
1752: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
1753: P_API_name => L_API_name
1754: ,P_PKG_name => G_PKG_name

Line 1886: x_exists := Fnd_Api.G_TRUE;

1882: WHERE flex_value_set_id=p_flex_value_set_id;
1883:
1884: BEGIN
1885:
1886: x_exists := Fnd_Api.G_TRUE;
1887: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1888:
1889: OPEN C_FlexValueSet;
1890: FETCH C_FlexValueSet INTO l_value_set_id,l_vset_type;

Line 1887: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1883:
1884: BEGIN
1885:
1886: x_exists := Fnd_Api.G_TRUE;
1887: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1888:
1889: OPEN C_FlexValueSet;
1890: FETCH C_FlexValueSet INTO l_value_set_id,l_vset_type;
1891: IF C_FlexValueSet%NOTFOUND THEN

Line 1896: x_exists := Fnd_Api.G_FALSE;

1892: Fnd_Message.Set_name('IBC', 'BAD_INPUT_VALUE');
1893: Fnd_Message.Set_Token('INPUT',p_flex_value_set_id, FALSE);
1894: Fnd_Msg_Pub.ADD;
1895: CLOSE C_FlexValueSet;
1896: x_exists := Fnd_Api.G_FALSE;
1897: RAISE Fnd_Api.G_EXC_ERROR;
1898: END IF;
1899: CLOSE C_FlexValueSet;
1900:

Line 1897: RAISE Fnd_Api.G_EXC_ERROR;

1893: Fnd_Message.Set_Token('INPUT',p_flex_value_set_id, FALSE);
1894: Fnd_Msg_Pub.ADD;
1895: CLOSE C_FlexValueSet;
1896: x_exists := Fnd_Api.G_FALSE;
1897: RAISE Fnd_Api.G_EXC_ERROR;
1898: END IF;
1899: CLOSE C_FlexValueSet;
1900:
1901: -- dbms_output.put_line(l_value_set_id);

Line 1941: x_exists := Fnd_Api.G_FALSE;

1937: lx_select := REPLACE(UPPER(lx_select),'FROM','BULK COLLECT INTO :tab1,:tab2,:tab3 FROM ');
1938: EXECUTE IMMEDIATE 'BEGIN ' || lx_select || '; END;'
1939: USING OUT l_code,OUT l_name,OUT l_description;
1940: ELSE
1941: x_exists := Fnd_Api.G_FALSE;
1942: RETURN;
1943: END IF;
1944:
1945: OPEN C_Flex_Value_Code;

Line 1949: x_exists := Fnd_Api.G_FALSE;

1945: OPEN C_Flex_Value_Code;
1946: FETCH C_Flex_Value_Code INTO l_temp;
1947:
1948: IF C_Flex_Value_Code%NOTFOUND THEN
1949: x_exists := Fnd_Api.G_FALSE;
1950: END IF;
1951:
1952: -- Standard call to get message count and if count is 1, get message info.
1953: Fnd_Msg_Pub.Count_And_Get

Line 1959: WHEN Fnd_Api.G_EXC_ERROR THEN

1955: p_data => x_msg_data
1956: );
1957:
1958: EXCEPTION
1959: WHEN Fnd_Api.G_EXC_ERROR THEN
1960: ROLLBACK;
1961: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
1962: P_API_name => L_API_name
1963: ,P_PKG_name => G_PKG_name

Line 1972: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

1968: ,X_MSG_COUNT => X_MSG_COUNT
1969: ,X_MSG_DATA => X_MSG_DATA
1970: ,X_RETURN_STATUS => X_RETURN_STATUS);
1971:
1972: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1973: ROLLBACK;
1974: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
1975: P_API_name => L_API_name
1976: ,P_PKG_name => G_PKG_name

Line 2002: ,P_Init_Msg_List IN VARCHAR2 --:= FND_API.G_FALSE

1998:
1999:
2000: PROCEDURE get_sql_from_flex(
2001: P_Api_Version_Number IN NUMBER
2002: ,P_Init_Msg_List IN VARCHAR2 --:= FND_API.G_FALSE
2003: ,p_flex_value_set_id IN NUMBER --1
2004: ,x_select OUT NOCOPY VARCHAR2 --4
2005: ,X_Return_Status OUT NOCOPY VARCHAR2 --6
2006: ,X_Msg_Count OUT NOCOPY NUMBER -- 7

Line 2024: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

2020: l_api_name VARCHAR2(30) := 'GET_SQL_FROM_FLEX';
2021:
2022: BEGIN
2023:
2024: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2025:
2026: OPEN C_flex;
2027: FETCH C_flex INTO l_value_set_id,l_vset_type;
2028:

Line 2031: x_return_status := FND_API.G_RET_STS_ERROR;

2027: FETCH C_flex INTO l_value_set_id,l_vset_type;
2028:
2029: IF C_flex%NOTFOUND THEN
2030: CLOSE C_flex;
2031: x_return_status := FND_API.G_RET_STS_ERROR;
2032: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
2033: FND_MESSAGE.Set_Token('INPUT', 'FLEX_VALUE_SET_ID', FALSE);
2034: FND_MSG_PUB.ADD;
2035: RAISE FND_API.G_EXC_ERROR;

Line 2035: RAISE FND_API.G_EXC_ERROR;

2031: x_return_status := FND_API.G_RET_STS_ERROR;
2032: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
2033: FND_MESSAGE.Set_Token('INPUT', 'FLEX_VALUE_SET_ID', FALSE);
2034: FND_MSG_PUB.ADD;
2035: RAISE FND_API.G_EXC_ERROR;
2036: END IF;
2037:
2038:
2039: CLOSE C_flex;

Line 2059: x_return_status := FND_API.G_RET_STS_ERROR;

2055: x_mapping_code =>lx_mapping_code,
2056: x_success =>lx_success);
2057: -- dbms_output.put_line(lx_success);
2058: ELSE
2059: x_return_status := FND_API.G_RET_STS_ERROR;
2060: FND_MESSAGE.Set_Name('IBC', 'IBC_INVALID_FLEX_VALUE_SET');
2061: FND_MSG_PUB.ADD;
2062: RAISE FND_API.G_EXC_ERROR;
2063: END IF;

Line 2062: RAISE FND_API.G_EXC_ERROR;

2058: ELSE
2059: x_return_status := FND_API.G_RET_STS_ERROR;
2060: FND_MESSAGE.Set_Name('IBC', 'IBC_INVALID_FLEX_VALUE_SET');
2061: FND_MSG_PUB.ADD;
2062: RAISE FND_API.G_EXC_ERROR;
2063: END IF;
2064:
2065:
2066: x_select := lx_select;

Line 2081: WHEN Fnd_Api.G_EXC_ERROR THEN

2077: );
2078:
2079:
2080: EXCEPTION
2081: WHEN Fnd_Api.G_EXC_ERROR THEN
2082: ROLLBACK;
2083: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
2084: P_API_name => L_API_name
2085: ,P_PKG_name => G_PKG_name

Line 2094: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

2090: ,X_MSG_COUNT => X_MSG_COUNT
2091: ,X_MSG_DATA => X_MSG_DATA
2092: ,X_RETURN_STATUS => X_RETURN_STATUS);
2093:
2094: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2095: ROLLBACK;
2096: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
2097: P_API_name => L_API_name
2098: ,P_PKG_name => G_PKG_name