10: --------------------------------------------------------------------------
11:
12: PROCEDURE Create_Preferred_Language
13: ( p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
15: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
16: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
11:
12: PROCEDURE Create_Preferred_Language
13: ( p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
15: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
16: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2,
12: PROCEDURE Create_Preferred_Language
13: ( p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
15: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
16: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2,
20: p_resp_appl_id IN NUMBER DEFAULT NULL,
41: -- Standard start of API savepoint
42: SAVEPOINT Create_Preferred_Language_PVT;
43:
44: -- Standard call to check for call compatibility
45: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
46: G_PKG_NAME) THEN
47: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
48: END IF;
49:
43:
44: -- Standard call to check for call compatibility
45: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
46: G_PKG_NAME) THEN
47: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
48: END IF;
49:
50: IF (l_preferred_language_rec.initialize_flag IS NULL
51: OR l_preferred_language_rec.initialize_flag <> G_INITIALIZED) THEN
53: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
54: FND_MESSAGE.Set_Token('VALUE', l_preferred_language_rec.initialize_flag);
55: FND_MESSAGE.Set_Token('PARAMETER', 'Initialize_Flag');
56: FND_MSG_PUB.Add;
57: RAISE FND_API.G_EXC_ERROR;
58: END IF;
59:
60: -- Initialize message list if p_init_msg_list is set to TRUE
61: IF FND_API.To_Boolean(p_init_msg_list) THEN
57: RAISE FND_API.G_EXC_ERROR;
58: END IF;
59:
60: -- Initialize message list if p_init_msg_list is set to TRUE
61: IF FND_API.To_Boolean(p_init_msg_list) THEN
62: FND_MSG_PUB.Initialize;
63: END IF;
64:
65: -- Initialize API return status to success
62: FND_MSG_PUB.Initialize;
63: END IF;
64:
65: -- Initialize API return status to success
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67:
68:
69: /*
70: --
101: p_preferred_language_rec => l_preferred_language_rec);
102:
103:
104:
105: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
106: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
107: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_PRE_CUST_USR_HK');
108: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
109: FND_MSG_PUB.Add;
106: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
107: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_PRE_CUST_USR_HK');
108: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
109: FND_MSG_PUB.Add;
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
111: END IF;
112: END IF;
113:
114: -- Pre call to the Vertical Type User Hook
137: p_preferred_language_rec => l_preferred_language_rec);
138:
139:
140:
141: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
142: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
143: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_PRE_VERT_USR_HK');
144: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
145: FND_MSG_PUB.Add;
142: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
143: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_PRE_VERT_USR_HK');
144: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
145: FND_MSG_PUB.Add;
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148: END IF;
149:
150: -- Pre call to the Internal Type User Hook
163: cs_preferred_language_iuhk.call_internal_hook( p_package_name => 'Create_Preferred_Language_PVT',
164: p_api_name => 'Create_Preferred_Language'
165: p_processing_type => 'B',
166: x_return_status=>l_return_status);
167: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
168: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
169: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_PRE_INT_USR_HK');
170: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
171: FND_MSG_PUB.Add;
168: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
169: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_PRE_INT_USR_HK');
170: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
171: FND_MSG_PUB.Add;
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;
174:
175:
176: --END IF;
185: --
186: -- Validate Preferred Language Record
187: --
188:
189: IF (l_preferred_language_rec.pref_lang_id = FND_API.G_MISS_NUM )
190: OR (l_preferred_language_rec.pref_lang_id is null ) THEN
191: DECLARE
192: l_key_val NUMBER;
193: BEGIN
197:
198: l_preferred_language_rec.pref_lang_id := l_key_val;
199: EXCEPTION
200: WHEN NO_DATA_FOUND THEN
201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
202: WHEN OTHERS THEN
203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: END;
205: END IF;
199: EXCEPTION
200: WHEN NO_DATA_FOUND THEN
201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
202: WHEN OTHERS THEN
203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: END;
205: END IF;
206:
207:
204: END;
205: END IF;
206:
207:
208: IF (l_preferred_language_rec.language_code = FND_API.G_MISS_CHAR OR
209: l_preferred_language_rec.language_code IS NULL) THEN
210: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
211: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
212: FND_MESSAGE.Set_Token('VALUE', l_preferred_language_rec.language_code);
211: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
212: FND_MESSAGE.Set_Token('VALUE', l_preferred_language_rec.language_code);
213: FND_MESSAGE.Set_Token('PARAMETER', 'Language_Code');
214: FND_MSG_PUB.Add;
215: RAISE FND_API.G_EXC_ERROR;
216: END IF;
217:
218: IF (p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
219: DECLARE
214: FND_MSG_PUB.Add;
215: RAISE FND_API.G_EXC_ERROR;
216: END IF;
217:
218: IF (p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
219: DECLARE
220: l_dummy varchar2(1);
221: BEGIN
222: select 'x' into l_dummy
228: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
229: FND_MESSAGE.Set_Token('VALUE', l_preferred_language_rec.language_code);
230: FND_MESSAGE.Set_Token('PARAMETER', 'Language_Code');
231: FND_MSG_PUB.Add;
232: RAISE FND_API.G_EXC_ERROR;
233: WHEN OTHERS THEN
234: RAISE FND_API.G_EXC_ERROR;
235: END;
236:
230: FND_MESSAGE.Set_Token('PARAMETER', 'Language_Code');
231: FND_MSG_PUB.Add;
232: RAISE FND_API.G_EXC_ERROR;
233: WHEN OTHERS THEN
234: RAISE FND_API.G_EXC_ERROR;
235: END;
236:
237: DECLARE
238: l_dummy varchar2(1);
245: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
246: FND_MESSAGE.Set_Token('VALUE', l_preferred_language_rec.language_code);
247: FND_MESSAGE.Set_Token('PARAMETER', 'Language_Code');
248: FND_MSG_PUB.Add;
249: RAISE FND_API.G_EXC_ERROR;
250: EXCEPTION
251: WHEN NO_DATA_FOUND THEN
252: null;
253: WHEN OTHERS THEN
250: EXCEPTION
251: WHEN NO_DATA_FOUND THEN
252: null;
253: WHEN OTHERS THEN
254: RAISE FND_API.G_EXC_ERROR;
255: END;
256: END IF;
257:
258:
255: END;
256: END IF;
257:
258:
259: IF (l_preferred_language_rec.start_date_active = FND_API.G_MISS_DATE ) THEN
260: l_preferred_language_rec.start_date_active := NULL;
261: END IF;
262:
263: IF (l_preferred_language_rec.end_date_active = FND_API.G_MISS_DATE ) THEN
259: IF (l_preferred_language_rec.start_date_active = FND_API.G_MISS_DATE ) THEN
260: l_preferred_language_rec.start_date_active := NULL;
261: END IF;
262:
263: IF (l_preferred_language_rec.end_date_active = FND_API.G_MISS_DATE ) THEN
264: l_preferred_language_rec.end_date_active := NULL;
265: END IF;
266:
267: IF (l_preferred_language_rec.start_date_active is not null)
271: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
272: FND_MESSAGE.Set_Token('VALUE', to_char(l_preferred_language_rec.end_date_active));
273: FND_MESSAGE.Set_Token('PARAMETER', 'End_Date_Active');
274: FND_MSG_PUB.Add;
275: RAISE FND_API.G_EXC_ERROR;
276: END IF ;
277:
278: --
279: -- Validate the descriptive flexfields
278: --
279: -- Validate the descriptive flexfields
280: --
281:
282: IF (l_preferred_language_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
283: l_preferred_language_rec.attribute_category := NULL;
284: END IF;
285:
286: IF (l_preferred_language_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
282: IF (l_preferred_language_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
283: l_preferred_language_rec.attribute_category := NULL;
284: END IF;
285:
286: IF (l_preferred_language_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
287: l_preferred_language_rec.attribute1 := NULL;
288: END IF;
289:
290: IF (l_preferred_language_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
286: IF (l_preferred_language_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
287: l_preferred_language_rec.attribute1 := NULL;
288: END IF;
289:
290: IF (l_preferred_language_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
291: l_preferred_language_rec.attribute2 := NULL;
292: END IF;
293:
294: IF (l_preferred_language_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
290: IF (l_preferred_language_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
291: l_preferred_language_rec.attribute2 := NULL;
292: END IF;
293:
294: IF (l_preferred_language_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
295: l_preferred_language_rec.attribute3 := NULL;
296: END IF;
297:
298: IF (l_preferred_language_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
294: IF (l_preferred_language_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
295: l_preferred_language_rec.attribute3 := NULL;
296: END IF;
297:
298: IF (l_preferred_language_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
299: l_preferred_language_rec.attribute4 := NULL;
300: END IF;
301:
302: IF (l_preferred_language_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
298: IF (l_preferred_language_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
299: l_preferred_language_rec.attribute4 := NULL;
300: END IF;
301:
302: IF (l_preferred_language_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
303: l_preferred_language_rec.attribute5 := NULL;
304: END IF;
305:
306: IF (l_preferred_language_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
302: IF (l_preferred_language_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
303: l_preferred_language_rec.attribute5 := NULL;
304: END IF;
305:
306: IF (l_preferred_language_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
307: l_preferred_language_rec.attribute6 := NULL;
308: END IF;
309:
310: IF (l_preferred_language_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
306: IF (l_preferred_language_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
307: l_preferred_language_rec.attribute6 := NULL;
308: END IF;
309:
310: IF (l_preferred_language_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
311: l_preferred_language_rec.attribute7 := NULL;
312: END IF;
313:
314: IF (l_preferred_language_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
310: IF (l_preferred_language_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
311: l_preferred_language_rec.attribute7 := NULL;
312: END IF;
313:
314: IF (l_preferred_language_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
315: l_preferred_language_rec.attribute8 := NULL;
316: END IF;
317:
318: IF (l_preferred_language_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
314: IF (l_preferred_language_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
315: l_preferred_language_rec.attribute8 := NULL;
316: END IF;
317:
318: IF (l_preferred_language_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
319: l_preferred_language_rec.attribute9 := NULL;
320: END IF;
321:
322: IF (l_preferred_language_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
318: IF (l_preferred_language_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
319: l_preferred_language_rec.attribute9 := NULL;
320: END IF;
321:
322: IF (l_preferred_language_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
323: l_preferred_language_rec.attribute10 := NULL;
324: END IF;
325:
326: IF (l_preferred_language_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
322: IF (l_preferred_language_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
323: l_preferred_language_rec.attribute10 := NULL;
324: END IF;
325:
326: IF (l_preferred_language_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
327: l_preferred_language_rec.attribute11 := NULL;
328: END IF;
329:
330: IF (l_preferred_language_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
326: IF (l_preferred_language_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
327: l_preferred_language_rec.attribute11 := NULL;
328: END IF;
329:
330: IF (l_preferred_language_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
331: l_preferred_language_rec.attribute12 := NULL;
332: END IF;
333:
334: IF (l_preferred_language_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
330: IF (l_preferred_language_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
331: l_preferred_language_rec.attribute12 := NULL;
332: END IF;
333:
334: IF (l_preferred_language_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
335: l_preferred_language_rec.attribute13 := NULL;
336: END IF;
337:
338: IF (l_preferred_language_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
334: IF (l_preferred_language_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
335: l_preferred_language_rec.attribute13 := NULL;
336: END IF;
337:
338: IF (l_preferred_language_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
339: l_preferred_language_rec.attribute14 := NULL;
340: END IF;
341:
342: IF (l_preferred_language_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
338: IF (l_preferred_language_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
339: l_preferred_language_rec.attribute14 := NULL;
340: END IF;
341:
342: IF (l_preferred_language_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
343: l_preferred_language_rec.attribute15 := NULL;
344: END IF;
345:
346: IF (l_preferred_language_rec.attribute1 is not null)
382: p_resp_appl_id => p_resp_appl_id,
383: p_resp_id => p_resp_id,
384: p_return_status => l_return_status );
385:
386: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
387: raise FND_API.G_EXC_ERROR;
388: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
389: raise FND_API.G_EXC_UNEXPECTED_ERROR;
390: END IF;
383: p_resp_id => p_resp_id,
384: p_return_status => l_return_status );
385:
386: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
387: raise FND_API.G_EXC_ERROR;
388: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
389: raise FND_API.G_EXC_UNEXPECTED_ERROR;
390: END IF;
391: END IF;
384: p_return_status => l_return_status );
385:
386: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
387: raise FND_API.G_EXC_ERROR;
388: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
389: raise FND_API.G_EXC_UNEXPECTED_ERROR;
390: END IF;
391: END IF;
392:
385:
386: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
387: raise FND_API.G_EXC_ERROR;
388: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
389: raise FND_API.G_EXC_UNEXPECTED_ERROR;
390: END IF;
391: END IF;
392:
393: IF (l_preferred_language_rec.object_version_number = FND_API.G_MISS_NUM )
389: raise FND_API.G_EXC_UNEXPECTED_ERROR;
390: END IF;
391: END IF;
392:
393: IF (l_preferred_language_rec.object_version_number = FND_API.G_MISS_NUM )
394: OR (l_preferred_language_rec.object_version_number is null) THEN
395: l_preferred_language_rec.object_version_number := 1;
396: END IF;
397:
458: p_user_id => p_user_id,
459: p_login_id => p_login_id,
460: p_preferred_language_rec => l_preferred_language_rec);
461:
462: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
463: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Customer User Hook');
464: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_CUST_USR_HK');
465: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
466: FND_MSG_PUB.Add;
463: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Customer User Hook');
464: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_CUST_USR_HK');
465: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
466: FND_MSG_PUB.Add;
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: END IF;
469: END IF;
470:
471:
495: p_request_number => l_request_number,
496: p_preferred_language_rec => l_preferred_language_rec);
497:
498:
499: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
500: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Vertical User Hook');
501: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_VERT_USR_HK');
502: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
503: FND_MSG_PUB.Add;
500: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Vertical User Hook');
501: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_VERT_USR_HK');
502: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
503: FND_MSG_PUB.Add;
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
505: END IF;
506: END IF;
507:
508:
520: p_processing_type => 'A',
521: x_return_status=>l_return_status);
522:
523:
524: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
525: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Vertical User Hook');
526: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_INT_USR_HK');
527: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
528: FND_MSG_PUB.Add;
525: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Vertical User Hook');
526: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_INT_USR_HK');
527: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
528: FND_MSG_PUB.Add;
529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
530: END IF;
531:
532: --END IF;
533:
539: */
540:
541:
542: -- Standard check of p_commit
543: IF FND_API.To_Boolean(p_commit) THEN
544: COMMIT WORK;
545: END IF;
546:
547:
551: p_data => x_msg_data
552: );
553:
554: EXCEPTION
555: WHEN FND_API.G_EXC_ERROR THEN
556: ROLLBACK TO Create_Preferred_Language_PVT;
557: x_return_status := FND_API.G_RET_STS_ERROR;
558: FND_MSG_PUB.Count_And_Get
559: ( p_count => x_msg_count,
553:
554: EXCEPTION
555: WHEN FND_API.G_EXC_ERROR THEN
556: ROLLBACK TO Create_Preferred_Language_PVT;
557: x_return_status := FND_API.G_RET_STS_ERROR;
558: FND_MSG_PUB.Count_And_Get
559: ( p_count => x_msg_count,
560: p_data => x_msg_data
561: );
558: FND_MSG_PUB.Count_And_Get
559: ( p_count => x_msg_count,
560: p_data => x_msg_data
561: );
562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
563: ROLLBACK TO Create_Preferred_Language_PVT;
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565: FND_MSG_PUB.Count_And_Get
566: ( p_count => x_msg_count,
560: p_data => x_msg_data
561: );
562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
563: ROLLBACK TO Create_Preferred_Language_PVT;
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565: FND_MSG_PUB.Count_And_Get
566: ( p_count => x_msg_count,
567: p_data => x_msg_data
568: );
567: p_data => x_msg_data
568: );
569: WHEN OTHERS THEN
570: ROLLBACK TO Create_Preferred_Language_PVT;
571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
572: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
573: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
574: END IF;
575: FND_MSG_PUB.Count_And_Get
586:
587:
588: PROCEDURE Update_Preferred_Language
589: ( p_api_version IN NUMBER,
590: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
591: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
592: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
593: x_return_status OUT NOCOPY VARCHAR2,
594: x_msg_count OUT NOCOPY NUMBER,
587:
588: PROCEDURE Update_Preferred_Language
589: ( p_api_version IN NUMBER,
590: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
591: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
592: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
593: x_return_status OUT NOCOPY VARCHAR2,
594: x_msg_count OUT NOCOPY NUMBER,
595: x_msg_data OUT NOCOPY VARCHAR2,
588: PROCEDURE Update_Preferred_Language
589: ( p_api_version IN NUMBER,
590: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
591: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
592: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
593: x_return_status OUT NOCOPY VARCHAR2,
594: x_msg_count OUT NOCOPY NUMBER,
595: x_msg_data OUT NOCOPY VARCHAR2,
596: p_pref_lang_id IN NUMBER,
633: -- Standard start of API savepoint
634: SAVEPOINT Update_Preferred_Language_PVT;
635:
636: -- Standard call to check for call compatibility
637: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
638: G_PKG_NAME) THEN
639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
640: END IF;
641:
635:
636: -- Standard call to check for call compatibility
637: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
638: G_PKG_NAME) THEN
639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
640: END IF;
641:
642: IF (l_preferred_language_rec.initialize_flag IS NULL
643: OR l_preferred_language_rec.initialize_flag <> G_INITIALIZED) THEN
645: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
646: FND_MESSAGE.Set_Token('VALUE', l_preferred_language_rec.initialize_flag);
647: FND_MESSAGE.Set_Token('PARAMETER', 'Initialize_Flag');
648: FND_MSG_PUB.Add;
649: RAISE FND_API.G_EXC_ERROR;
650: END IF;
651:
652: -- Initialize message list if p_init_msg_list is set to TRUE
653: IF FND_API.To_Boolean(p_init_msg_list) THEN
649: RAISE FND_API.G_EXC_ERROR;
650: END IF;
651:
652: -- Initialize message list if p_init_msg_list is set to TRUE
653: IF FND_API.To_Boolean(p_init_msg_list) THEN
654: FND_MSG_PUB.Initialize;
655: END IF;
656:
657: -- Initialize API return status to success
654: FND_MSG_PUB.Initialize;
655: END IF;
656:
657: -- Initialize API return status to success
658: x_return_status := FND_API.G_RET_STS_SUCCESS;
659:
660:
661: --
662: -- Check if mandatory parameter is passed
663: --
664: --dbms_output.put_line('Check Mandatory') ;
665: IF (p_pref_lang_id IS NULL ) THEN
666: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'Preferred Language ID');
667: RAISE FND_API.G_EXC_ERROR;
668: END IF;
669:
670: IF (p_object_version_number IS NULL ) THEN
671: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'Object Version Number');
668: END IF;
669:
670: IF (p_object_version_number IS NULL ) THEN
671: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'Object Version Number');
672: RAISE FND_API.G_EXC_ERROR;
673: END IF;
674:
675:
676: -- Fetch and get the original values
682: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
683: FND_MESSAGE.Set_Token('VALUE', to_char(p_pref_lang_id));
684: FND_MESSAGE.Set_Token('PARAMETER', 'Pref_Lang_ID');
685: FND_MSG_PUB.Add;
686: raise FND_API.G_EXC_ERROR;
687: END IF;
688:
689: --dbms_output.put_line('After Fetch') ;
690:
723: p_last_update_date => p_last_update_date,
724: p_service_request_rec => l_service_request_rec);
725:
726:
727: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
728: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
729: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_PRE_CUST_USR_HK');
730: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
731: FND_MSG_PUB.Add;
728: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
729: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_PRE_CUST_USR_HK');
730: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
731: FND_MSG_PUB.Add;
732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
733: END IF;
734: END IF;
735:
736:
764: p_last_update_date => p_last_update_date,
765: p_service_request_rec => l_service_request_rec);
766:
767:
768: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
769: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
770: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_PRE_VERT_USR_HK');
771: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
772: FND_MSG_PUB.Add;
769: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
770: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_PRE_VERT_USR_HK');
771: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
772: FND_MSG_PUB.Add;
773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
774: END IF;
775: END IF;
776:
777: --
799: x_return_status=>l_return_status);
800:
801:
802:
803: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
804: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
805: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_PRE_INT_USR_HK');
806: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
807: FND_MSG_PUB.Add;
804: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
805: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_PRE_INT_USR_HK');
806: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
807: FND_MSG_PUB.Add;
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: END IF;
810:
811:
812: --END IF;
820:
821: --
822: -- We first deal with some special validation rules
823: --
824: IF (p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
825: DECLARE
826: l_dummy varchar2(1);
827: BEGIN
828: select 'x' into l_dummy
834: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
835: FND_MESSAGE.Set_Token('VALUE', l_preferred_language_rec.language_code);
836: FND_MESSAGE.Set_Token('PARAMETER', 'Language_Code');
837: FND_MSG_PUB.Add;
838: RAISE FND_API.G_EXC_ERROR;
839: WHEN OTHERS THEN
840: RAISE FND_API.G_EXC_ERROR;
841: END;
842:
836: FND_MESSAGE.Set_Token('PARAMETER', 'Language_Code');
837: FND_MSG_PUB.Add;
838: RAISE FND_API.G_EXC_ERROR;
839: WHEN OTHERS THEN
840: RAISE FND_API.G_EXC_ERROR;
841: END;
842:
843: DECLARE
844: l_dummy varchar2(1);
852: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
853: FND_MESSAGE.Set_Token('VALUE', l_preferred_language_rec.language_code);
854: FND_MESSAGE.Set_Token('PARAMETER', 'Language_Code');
855: FND_MSG_PUB.Add;
856: RAISE FND_API.G_EXC_ERROR;
857: EXCEPTION
858: WHEN NO_DATA_FOUND THEN
859: null;
860: WHEN OTHERS THEN
857: EXCEPTION
858: WHEN NO_DATA_FOUND THEN
859: null;
860: WHEN OTHERS THEN
861: RAISE FND_API.G_EXC_ERROR;
862: END;
863: END IF ; -- p_validation level end if
864:
865: --dbms_output.put_line('Validate1') ;
867: -- -----------------------------------------------------------
868: -- Check to see if the descriptive flexfield is being updated
869: -- -----------------------------------------------------------
870:
871: IF (l_preferred_language_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
872: l_preferred_language_rec.attribute_category := NULL;
873: END IF;
874:
875: IF (l_preferred_language_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
871: IF (l_preferred_language_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
872: l_preferred_language_rec.attribute_category := NULL;
873: END IF;
874:
875: IF (l_preferred_language_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
876: l_preferred_language_rec.attribute1 := NULL;
877: END IF;
878:
879: IF (l_preferred_language_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
875: IF (l_preferred_language_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
876: l_preferred_language_rec.attribute1 := NULL;
877: END IF;
878:
879: IF (l_preferred_language_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
880: l_preferred_language_rec.attribute2 := NULL;
881: END IF;
882:
883: IF (l_preferred_language_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
879: IF (l_preferred_language_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
880: l_preferred_language_rec.attribute2 := NULL;
881: END IF;
882:
883: IF (l_preferred_language_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
884: l_preferred_language_rec.attribute3 := NULL;
885: END IF;
886:
887: IF (l_preferred_language_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
883: IF (l_preferred_language_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
884: l_preferred_language_rec.attribute3 := NULL;
885: END IF;
886:
887: IF (l_preferred_language_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
888: l_preferred_language_rec.attribute4 := NULL;
889: END IF;
890:
891: IF (l_preferred_language_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
887: IF (l_preferred_language_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
888: l_preferred_language_rec.attribute4 := NULL;
889: END IF;
890:
891: IF (l_preferred_language_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
892: l_preferred_language_rec.attribute5 := NULL;
893: END IF;
894:
895: IF (l_preferred_language_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
891: IF (l_preferred_language_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
892: l_preferred_language_rec.attribute5 := NULL;
893: END IF;
894:
895: IF (l_preferred_language_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
896: l_preferred_language_rec.attribute6 := NULL;
897: END IF;
898:
899: IF (l_preferred_language_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
895: IF (l_preferred_language_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
896: l_preferred_language_rec.attribute6 := NULL;
897: END IF;
898:
899: IF (l_preferred_language_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
900: l_preferred_language_rec.attribute7 := NULL;
901: END IF;
902:
903: IF (l_preferred_language_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
899: IF (l_preferred_language_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
900: l_preferred_language_rec.attribute7 := NULL;
901: END IF;
902:
903: IF (l_preferred_language_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
904: l_preferred_language_rec.attribute8 := NULL;
905: END IF;
906:
907: IF (l_preferred_language_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
903: IF (l_preferred_language_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
904: l_preferred_language_rec.attribute8 := NULL;
905: END IF;
906:
907: IF (l_preferred_language_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
908: l_preferred_language_rec.attribute9 := NULL;
909: END IF;
910:
911: IF (l_preferred_language_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
907: IF (l_preferred_language_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
908: l_preferred_language_rec.attribute9 := NULL;
909: END IF;
910:
911: IF (l_preferred_language_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
912: l_preferred_language_rec.attribute10 := NULL;
913: END IF;
914:
915: IF (l_preferred_language_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
911: IF (l_preferred_language_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
912: l_preferred_language_rec.attribute10 := NULL;
913: END IF;
914:
915: IF (l_preferred_language_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
916: l_preferred_language_rec.attribute11 := NULL;
917: END IF;
918:
919: IF (l_preferred_language_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
915: IF (l_preferred_language_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
916: l_preferred_language_rec.attribute11 := NULL;
917: END IF;
918:
919: IF (l_preferred_language_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
920: l_preferred_language_rec.attribute12 := NULL;
921: END IF;
922:
923: IF (l_preferred_language_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
919: IF (l_preferred_language_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
920: l_preferred_language_rec.attribute12 := NULL;
921: END IF;
922:
923: IF (l_preferred_language_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
924: l_preferred_language_rec.attribute13 := NULL;
925: END IF;
926:
927: IF (l_preferred_language_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
923: IF (l_preferred_language_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
924: l_preferred_language_rec.attribute13 := NULL;
925: END IF;
926:
927: IF (l_preferred_language_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
928: l_preferred_language_rec.attribute14 := NULL;
929: END IF;
930:
931: IF (l_preferred_language_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
927: IF (l_preferred_language_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
928: l_preferred_language_rec.attribute14 := NULL;
929: END IF;
930:
931: IF (l_preferred_language_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
932: l_preferred_language_rec.attribute15 := NULL;
933: END IF;
934:
935: IF (l_preferred_language_rec.attribute_category <>
972: p_resp_appl_id => p_resp_appl_id,
973: p_resp_id => p_resp_id,
974: p_return_status => l_return_status );
975:
976: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
977: raise FND_API.G_EXC_ERROR;
978: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
979: raise FND_API.G_EXC_UNEXPECTED_ERROR;
980: END IF;
973: p_resp_id => p_resp_id,
974: p_return_status => l_return_status );
975:
976: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
977: raise FND_API.G_EXC_ERROR;
978: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
979: raise FND_API.G_EXC_UNEXPECTED_ERROR;
980: END IF;
981: ELSE
974: p_return_status => l_return_status );
975:
976: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
977: raise FND_API.G_EXC_ERROR;
978: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
979: raise FND_API.G_EXC_UNEXPECTED_ERROR;
980: END IF;
981: ELSE
982: l_preferred_language_rec.attribute1 := l_old_Preferred_Language_rec.attribute1;
975:
976: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
977: raise FND_API.G_EXC_ERROR;
978: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
979: raise FND_API.G_EXC_UNEXPECTED_ERROR;
980: END IF;
981: ELSE
982: l_preferred_language_rec.attribute1 := l_old_Preferred_Language_rec.attribute1;
983: l_preferred_language_rec.attribute2 := l_old_Preferred_Language_rec.attribute2;
1008: -- Before the actual update, see if the all the fields
1009: -- have their old values or null values
1010: --(otherwise they will have the MISS_NUM constants)
1011:
1012: IF l_preferred_language_rec.language_code = FND_API.G_MISS_CHAR THEN
1013: l_preferred_language_rec.language_code :=
1014: l_old_preferred_language_rec.language_code;
1015: END IF;
1016:
1013: l_preferred_language_rec.language_code :=
1014: l_old_preferred_language_rec.language_code;
1015: END IF;
1016:
1017: IF l_preferred_language_rec.start_date_active = FND_API.G_MISS_DATE THEN
1018: l_preferred_language_rec.start_date_active :=
1019: l_old_preferred_language_rec.start_date_active;
1020: END IF;
1021:
1018: l_preferred_language_rec.start_date_active :=
1019: l_old_preferred_language_rec.start_date_active;
1020: END IF;
1021:
1022: IF l_preferred_language_rec.end_date_active = FND_API.G_MISS_DATE THEN
1023: l_preferred_language_rec.end_date_active :=
1024: l_old_preferred_language_rec.end_date_active;
1025: END IF;
1026:
1095: p_service_request_rec => l_service_request_rec);
1096:
1097:
1098:
1099: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1100: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Customer User Hook');
1101: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_CUST_USR_HK');
1102: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1103: FND_MSG_PUB.Add;
1100: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Customer User Hook');
1101: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_CUST_USR_HK');
1102: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1103: FND_MSG_PUB.Add;
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105: END IF;
1106: END IF;
1107:
1108:
1137: p_last_update_date => p_last_update_date,
1138: p_service_request_rec => l_service_request_rec);
1139:
1140:
1141: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1142: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Vertical User Hook');
1143: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_VERT_USR_HK');
1144: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1145: FND_MSG_PUB.Add;
1142: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Vertical User Hook');
1143: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_VERT_USR_HK');
1144: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1145: FND_MSG_PUB.Add;
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: END IF;
1148: END IF;
1149:
1150:
1165: x_return_status=>l_return_status)
1166: ;
1167:
1168:
1169: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1170: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Vertical User Hook');
1171: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_INT_USR_HK');
1172: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1173: FND_MSG_PUB.Add;
1170: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Vertical User Hook');
1171: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_INT_USR_HK');
1172: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1173: FND_MSG_PUB.Add;
1174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1175: END IF;
1176:
1177: --END IF;
1178: IF (cs_servicerequest_cuhk.Ok_To_Generate_Msg(p_request_id => p_request_id,
1187: p_bind_data_id => l_bind_data_id,
1188: x_return_code => l_return_status);
1189:
1190:
1191: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1192: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Message Generation Hook');
1193: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_MSG_GEN_HK');
1194: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1195: FND_MSG_PUB.Add;
1192: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Message Generation Hook');
1193: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_MSG_GEN_HK');
1194: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1195: FND_MSG_PUB.Add;
1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1197: END IF;
1198: END IF;
1199:
1200: -- Standard check of p_commit
1197: END IF;
1198: END IF;
1199:
1200: -- Standard check of p_commit
1201: IF FND_API.To_Boolean(p_commit) THEN
1202: COMMIT WORK;
1203: END IF;
1204:
1205: RAISE OnlyUpdStatus ;
1245: p_last_update_date => p_last_update_date,
1246: p_service_request_rec => l_service_request_rec);
1247:
1248:
1249: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1250: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Customer User Hook');
1251: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_CUST_USR_HK');
1252: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1253: FND_MSG_PUB.Add;
1250: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Customer User Hook');
1251: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_CUST_USR_HK');
1252: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1253: FND_MSG_PUB.Add;
1254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1255: END IF;
1256: END IF;
1257:
1258:
1285: p_last_update_date => p_last_update_date,
1286: p_service_request_rec => l_service_request_rec);
1287:
1288:
1289: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1290: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Vertical User Hook');
1291: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_VERT_USR_HK');
1292: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1293: FND_MSG_PUB.Add;
1290: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Vertical User Hook');
1291: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_VERT_USR_HK');
1292: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1293: FND_MSG_PUB.Add;
1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: END IF;
1296: END IF;
1297:
1298:
1313: p_processing_type => 'A',
1314: x_return_status=>l_return_status);
1315:
1316:
1317: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1318: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Vertical User Hook');
1319: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_INT_USR_HK');
1320: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1321: FND_MSG_PUB.Add;
1318: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Vertical User Hook');
1319: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_INT_USR_HK');
1320: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1321: FND_MSG_PUB.Add;
1322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1323: END IF;
1324:
1325: --END IF;
1326:
1345: p_bind_data_id => l_bind_data_id,
1346: x_return_code => l_return_status);
1347:
1348:
1349: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1350: -- DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Message Generation Hook');
1351: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_MSG_GEN_HK');
1352: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1353: FND_MSG_PUB.Add;
1350: -- DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Message Generation Hook');
1351: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_MSG_GEN_HK');
1352: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1353: FND_MSG_PUB.Add;
1354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1355: END IF;
1356: END IF;
1357: END IF;
1358: --
1361: */
1362:
1363:
1364: -- Standard check of p_commit
1365: IF FND_API.To_Boolean(p_commit) THEN
1366: COMMIT WORK;
1367: END IF;
1368:
1369:
1373: p_data => x_msg_data
1374: );
1375:
1376: EXCEPTION
1377: WHEN FND_API.G_EXC_ERROR THEN
1378: ROLLBACK TO Update_Preferred_Language_PVT;
1379: IF (l_Preferred_Language_csr%ISOPEN) THEN
1380: CLOSE l_Preferred_Language_csr;
1381: END IF;
1378: ROLLBACK TO Update_Preferred_Language_PVT;
1379: IF (l_Preferred_Language_csr%ISOPEN) THEN
1380: CLOSE l_Preferred_Language_csr;
1381: END IF;
1382: x_return_status := FND_API.G_RET_STS_ERROR;
1383: FND_MSG_PUB.Count_And_Get
1384: ( p_count => x_msg_count,
1385: p_data => x_msg_data
1386: );
1384: ( p_count => x_msg_count,
1385: p_data => x_msg_data
1386: );
1387:
1388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1389: ROLLBACK TO Update_Preferred_Language_PVT;
1390: IF (l_Preferred_Language_csr%ISOPEN) THEN
1391: CLOSE l_Preferred_Language_csr;
1392: END IF;
1389: ROLLBACK TO Update_Preferred_Language_PVT;
1390: IF (l_Preferred_Language_csr%ISOPEN) THEN
1391: CLOSE l_Preferred_Language_csr;
1392: END IF;
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1394: FND_MSG_PUB.Count_And_Get
1395: ( p_count => x_msg_count,
1396: p_data => x_msg_data
1397: );
1400: ROLLBACK TO Update_Preferred_Language_PVT;
1401: IF (l_Preferred_Language_csr%ISOPEN) THEN
1402: CLOSE l_Preferred_Language_csr;
1403: END IF;
1404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1405: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1406: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1407: END IF;
1408: FND_MSG_PUB.Count_And_Get
1419: PROCEDURE initialize_rec(
1420: p_preferred_lang_record IN OUT NOCOPY preferred_language_rec_type
1421: ) AS
1422: BEGIN
1423: p_preferred_lang_record.PREF_LANG_ID := FND_API.G_MISS_NUM;
1424: p_preferred_lang_record.LANGUAGE_CODE := FND_API.G_MISS_CHAR;
1425: p_preferred_lang_record.START_DATE_ACTIVE := FND_API.G_MISS_DATE;
1426: p_preferred_lang_record.END_DATE_ACTIVE := FND_API.G_MISS_DATE;
1427: p_preferred_lang_record.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
1420: p_preferred_lang_record IN OUT NOCOPY preferred_language_rec_type
1421: ) AS
1422: BEGIN
1423: p_preferred_lang_record.PREF_LANG_ID := FND_API.G_MISS_NUM;
1424: p_preferred_lang_record.LANGUAGE_CODE := FND_API.G_MISS_CHAR;
1425: p_preferred_lang_record.START_DATE_ACTIVE := FND_API.G_MISS_DATE;
1426: p_preferred_lang_record.END_DATE_ACTIVE := FND_API.G_MISS_DATE;
1427: p_preferred_lang_record.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
1428: p_preferred_lang_record.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
1421: ) AS
1422: BEGIN
1423: p_preferred_lang_record.PREF_LANG_ID := FND_API.G_MISS_NUM;
1424: p_preferred_lang_record.LANGUAGE_CODE := FND_API.G_MISS_CHAR;
1425: p_preferred_lang_record.START_DATE_ACTIVE := FND_API.G_MISS_DATE;
1426: p_preferred_lang_record.END_DATE_ACTIVE := FND_API.G_MISS_DATE;
1427: p_preferred_lang_record.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
1428: p_preferred_lang_record.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
1429: p_preferred_lang_record.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
1422: BEGIN
1423: p_preferred_lang_record.PREF_LANG_ID := FND_API.G_MISS_NUM;
1424: p_preferred_lang_record.LANGUAGE_CODE := FND_API.G_MISS_CHAR;
1425: p_preferred_lang_record.START_DATE_ACTIVE := FND_API.G_MISS_DATE;
1426: p_preferred_lang_record.END_DATE_ACTIVE := FND_API.G_MISS_DATE;
1427: p_preferred_lang_record.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
1428: p_preferred_lang_record.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
1429: p_preferred_lang_record.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
1430: p_preferred_lang_record.CREATION_DATE := FND_API.G_MISS_DATE;
1423: p_preferred_lang_record.PREF_LANG_ID := FND_API.G_MISS_NUM;
1424: p_preferred_lang_record.LANGUAGE_CODE := FND_API.G_MISS_CHAR;
1425: p_preferred_lang_record.START_DATE_ACTIVE := FND_API.G_MISS_DATE;
1426: p_preferred_lang_record.END_DATE_ACTIVE := FND_API.G_MISS_DATE;
1427: p_preferred_lang_record.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
1428: p_preferred_lang_record.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
1429: p_preferred_lang_record.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
1430: p_preferred_lang_record.CREATION_DATE := FND_API.G_MISS_DATE;
1431: p_preferred_lang_record.CREATED_BY := FND_API.G_MISS_NUM;
1424: p_preferred_lang_record.LANGUAGE_CODE := FND_API.G_MISS_CHAR;
1425: p_preferred_lang_record.START_DATE_ACTIVE := FND_API.G_MISS_DATE;
1426: p_preferred_lang_record.END_DATE_ACTIVE := FND_API.G_MISS_DATE;
1427: p_preferred_lang_record.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
1428: p_preferred_lang_record.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
1429: p_preferred_lang_record.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
1430: p_preferred_lang_record.CREATION_DATE := FND_API.G_MISS_DATE;
1431: p_preferred_lang_record.CREATED_BY := FND_API.G_MISS_NUM;
1432: p_preferred_lang_record.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
1425: p_preferred_lang_record.START_DATE_ACTIVE := FND_API.G_MISS_DATE;
1426: p_preferred_lang_record.END_DATE_ACTIVE := FND_API.G_MISS_DATE;
1427: p_preferred_lang_record.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
1428: p_preferred_lang_record.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
1429: p_preferred_lang_record.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
1430: p_preferred_lang_record.CREATION_DATE := FND_API.G_MISS_DATE;
1431: p_preferred_lang_record.CREATED_BY := FND_API.G_MISS_NUM;
1432: p_preferred_lang_record.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
1433: p_preferred_lang_record.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1426: p_preferred_lang_record.END_DATE_ACTIVE := FND_API.G_MISS_DATE;
1427: p_preferred_lang_record.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
1428: p_preferred_lang_record.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
1429: p_preferred_lang_record.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
1430: p_preferred_lang_record.CREATION_DATE := FND_API.G_MISS_DATE;
1431: p_preferred_lang_record.CREATED_BY := FND_API.G_MISS_NUM;
1432: p_preferred_lang_record.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
1433: p_preferred_lang_record.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1434: p_preferred_lang_record.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1427: p_preferred_lang_record.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
1428: p_preferred_lang_record.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
1429: p_preferred_lang_record.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
1430: p_preferred_lang_record.CREATION_DATE := FND_API.G_MISS_DATE;
1431: p_preferred_lang_record.CREATED_BY := FND_API.G_MISS_NUM;
1432: p_preferred_lang_record.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
1433: p_preferred_lang_record.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1434: p_preferred_lang_record.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1435: p_preferred_lang_record.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
1428: p_preferred_lang_record.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
1429: p_preferred_lang_record.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
1430: p_preferred_lang_record.CREATION_DATE := FND_API.G_MISS_DATE;
1431: p_preferred_lang_record.CREATED_BY := FND_API.G_MISS_NUM;
1432: p_preferred_lang_record.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
1433: p_preferred_lang_record.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1434: p_preferred_lang_record.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1435: p_preferred_lang_record.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
1436: p_preferred_lang_record.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
1429: p_preferred_lang_record.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
1430: p_preferred_lang_record.CREATION_DATE := FND_API.G_MISS_DATE;
1431: p_preferred_lang_record.CREATED_BY := FND_API.G_MISS_NUM;
1432: p_preferred_lang_record.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
1433: p_preferred_lang_record.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1434: p_preferred_lang_record.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1435: p_preferred_lang_record.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
1436: p_preferred_lang_record.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
1437: p_preferred_lang_record.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
1430: p_preferred_lang_record.CREATION_DATE := FND_API.G_MISS_DATE;
1431: p_preferred_lang_record.CREATED_BY := FND_API.G_MISS_NUM;
1432: p_preferred_lang_record.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
1433: p_preferred_lang_record.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1434: p_preferred_lang_record.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1435: p_preferred_lang_record.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
1436: p_preferred_lang_record.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
1437: p_preferred_lang_record.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
1438: p_preferred_lang_record.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
1431: p_preferred_lang_record.CREATED_BY := FND_API.G_MISS_NUM;
1432: p_preferred_lang_record.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
1433: p_preferred_lang_record.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1434: p_preferred_lang_record.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1435: p_preferred_lang_record.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
1436: p_preferred_lang_record.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
1437: p_preferred_lang_record.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
1438: p_preferred_lang_record.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
1439: p_preferred_lang_record.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
1432: p_preferred_lang_record.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
1433: p_preferred_lang_record.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1434: p_preferred_lang_record.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1435: p_preferred_lang_record.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
1436: p_preferred_lang_record.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
1437: p_preferred_lang_record.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
1438: p_preferred_lang_record.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
1439: p_preferred_lang_record.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
1440: p_preferred_lang_record.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
1433: p_preferred_lang_record.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1434: p_preferred_lang_record.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1435: p_preferred_lang_record.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
1436: p_preferred_lang_record.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
1437: p_preferred_lang_record.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
1438: p_preferred_lang_record.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
1439: p_preferred_lang_record.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
1440: p_preferred_lang_record.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
1441: p_preferred_lang_record.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
1434: p_preferred_lang_record.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1435: p_preferred_lang_record.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
1436: p_preferred_lang_record.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
1437: p_preferred_lang_record.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
1438: p_preferred_lang_record.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
1439: p_preferred_lang_record.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
1440: p_preferred_lang_record.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
1441: p_preferred_lang_record.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
1442: p_preferred_lang_record.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
1435: p_preferred_lang_record.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
1436: p_preferred_lang_record.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
1437: p_preferred_lang_record.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
1438: p_preferred_lang_record.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
1439: p_preferred_lang_record.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
1440: p_preferred_lang_record.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
1441: p_preferred_lang_record.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
1442: p_preferred_lang_record.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
1443: p_preferred_lang_record.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
1436: p_preferred_lang_record.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
1437: p_preferred_lang_record.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
1438: p_preferred_lang_record.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
1439: p_preferred_lang_record.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
1440: p_preferred_lang_record.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
1441: p_preferred_lang_record.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
1442: p_preferred_lang_record.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
1443: p_preferred_lang_record.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
1444: p_preferred_lang_record.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
1437: p_preferred_lang_record.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
1438: p_preferred_lang_record.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
1439: p_preferred_lang_record.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
1440: p_preferred_lang_record.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
1441: p_preferred_lang_record.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
1442: p_preferred_lang_record.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
1443: p_preferred_lang_record.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
1444: p_preferred_lang_record.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
1445: p_preferred_lang_record.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
1438: p_preferred_lang_record.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
1439: p_preferred_lang_record.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
1440: p_preferred_lang_record.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
1441: p_preferred_lang_record.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
1442: p_preferred_lang_record.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
1443: p_preferred_lang_record.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
1444: p_preferred_lang_record.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
1445: p_preferred_lang_record.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
1446: p_preferred_lang_record.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
1439: p_preferred_lang_record.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
1440: p_preferred_lang_record.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
1441: p_preferred_lang_record.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
1442: p_preferred_lang_record.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
1443: p_preferred_lang_record.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
1444: p_preferred_lang_record.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
1445: p_preferred_lang_record.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
1446: p_preferred_lang_record.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
1447: p_preferred_lang_record.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
1440: p_preferred_lang_record.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
1441: p_preferred_lang_record.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
1442: p_preferred_lang_record.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
1443: p_preferred_lang_record.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
1444: p_preferred_lang_record.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
1445: p_preferred_lang_record.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
1446: p_preferred_lang_record.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
1447: p_preferred_lang_record.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
1448: p_preferred_lang_record.ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
1441: p_preferred_lang_record.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
1442: p_preferred_lang_record.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
1443: p_preferred_lang_record.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
1444: p_preferred_lang_record.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
1445: p_preferred_lang_record.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
1446: p_preferred_lang_record.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
1447: p_preferred_lang_record.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
1448: p_preferred_lang_record.ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
1449: p_preferred_lang_record.INITIALIZE_FLAG := G_INITIALIZED;
1442: p_preferred_lang_record.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
1443: p_preferred_lang_record.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
1444: p_preferred_lang_record.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
1445: p_preferred_lang_record.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
1446: p_preferred_lang_record.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
1447: p_preferred_lang_record.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
1448: p_preferred_lang_record.ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
1449: p_preferred_lang_record.INITIALIZE_FLAG := G_INITIALIZED;
1450: END initialize_rec;
1443: p_preferred_lang_record.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
1444: p_preferred_lang_record.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
1445: p_preferred_lang_record.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
1446: p_preferred_lang_record.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
1447: p_preferred_lang_record.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
1448: p_preferred_lang_record.ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
1449: p_preferred_lang_record.INITIALIZE_FLAG := G_INITIALIZED;
1450: END initialize_rec;
1451:
1444: p_preferred_lang_record.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
1445: p_preferred_lang_record.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
1446: p_preferred_lang_record.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
1447: p_preferred_lang_record.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
1448: p_preferred_lang_record.ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
1449: p_preferred_lang_record.INITIALIZE_FLAG := G_INITIALIZED;
1450: END initialize_rec;
1451:
1452:
1518: IS
1519: l_error_message VARCHAR2(2000);
1520: BEGIN
1521: -- Initialize API return status to success
1522: p_return_status := FND_API.G_RET_STS_SUCCESS;
1523:
1524: --dbms_output.put_line(' In the desc flex proc ') ;
1525:
1526: IF ( p_desc_context || p_desc_segment1 || p_desc_segment2 ||
1554: resp_id => p_resp_id
1555: ) THEN
1556: l_error_message := FND_FLEX_DESCVAL.Error_Message;
1557: CS_ServiceRequest_UTIL.Add_Desc_Flex_Msg(p_api_name, l_error_message);
1558: p_return_status := FND_API.G_RET_STS_ERROR;
1559: END IF;
1560: END IF;
1561:
1562: END Validate_Desc_Flex;