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

Line 14: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

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,

Line 15: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

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,

Line 16: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

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,

Line 45: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

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:

Line 47: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 57: RAISE FND_API.G_EXC_ERROR;

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

Line 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

Line 66: x_return_status := FND_API.G_RET_STS_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: --

Line 105: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;

Line 110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 141: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;

Line 146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 167: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;

Line 172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;

Line 189: IF (l_preferred_language_rec.pref_lang_id = FND_API.G_MISS_NUM )

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

Line 201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;

Line 203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 208: IF (l_preferred_language_rec.language_code = FND_API.G_MISS_CHAR OR

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

Line 215: RAISE FND_API.G_EXC_ERROR;

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

Line 218: IF (p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN

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

Line 232: RAISE FND_API.G_EXC_ERROR;

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:

Line 234: RAISE FND_API.G_EXC_ERROR;

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

Line 249: RAISE FND_API.G_EXC_ERROR;

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

Line 254: RAISE FND_API.G_EXC_ERROR;

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:

Line 259: IF (l_preferred_language_rec.start_date_active = FND_API.G_MISS_DATE ) THEN

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

Line 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)

Line 275: RAISE FND_API.G_EXC_ERROR;

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

Line 282: IF (l_preferred_language_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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)

Line 386: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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;

Line 387: raise FND_API.G_EXC_ERROR;

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;

Line 388: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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:

Line 389: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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 )

Line 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:

Line 462: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;

Line 467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 499: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;

Line 504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 524: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;

Line 529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 543: IF FND_API.To_Boolean(p_commit) THEN

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:

Line 555: WHEN FND_API.G_EXC_ERROR THEN

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,

Line 557: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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,

Line 564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 590: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

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,

Line 591: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

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,

Line 592: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

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,

Line 637: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

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:

Line 639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 649: RAISE FND_API.G_EXC_ERROR;

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

Line 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

Line 658: x_return_status := FND_API.G_RET_STS_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

Line 667: RAISE FND_API.G_EXC_ERROR;

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

Line 672: 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');
672: RAISE FND_API.G_EXC_ERROR;
673: END IF;
674:
675:
676: -- Fetch and get the original values

Line 686: raise FND_API.G_EXC_ERROR;

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:

Line 727: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;

Line 732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 768: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;

Line 773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 803: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;

Line 808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;

Line 824: IF (p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN

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

Line 838: RAISE FND_API.G_EXC_ERROR;

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:

Line 840: RAISE FND_API.G_EXC_ERROR;

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

Line 856: RAISE FND_API.G_EXC_ERROR;

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

Line 861: RAISE FND_API.G_EXC_ERROR;

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

Line 871: IF (l_preferred_language_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

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

Line 976: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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;

Line 977: raise FND_API.G_EXC_ERROR;

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

Line 978: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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;

Line 979: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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;

Line 1012: IF l_preferred_language_rec.language_code = FND_API.G_MISS_CHAR THEN

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:

Line 1017: IF l_preferred_language_rec.start_date_active = FND_API.G_MISS_DATE THEN

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:

Line 1022: IF l_preferred_language_rec.end_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:
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:

Line 1099: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;

Line 1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 1141: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;

Line 1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 1169: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;

Line 1174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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,

Line 1191: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;

Line 1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1201: IF FND_API.To_Boolean(p_commit) THEN

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 ;

Line 1249: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;

Line 1254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 1289: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;

Line 1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 1317: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;

Line 1322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 1349: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;

Line 1354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1365: IF FND_API.To_Boolean(p_commit) THEN

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:

Line 1377: WHEN FND_API.G_EXC_ERROR THEN

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;

Line 1382: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;

Line 1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1423: p_preferred_lang_record.PREF_LANG_ID := FND_API.G_MISS_NUM;

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;

Line 1424: p_preferred_lang_record.LANGUAGE_CODE := FND_API.G_MISS_CHAR;

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;

Line 1425: p_preferred_lang_record.START_DATE_ACTIVE := 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;

Line 1426: p_preferred_lang_record.END_DATE_ACTIVE := FND_API.G_MISS_DATE;

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;

Line 1427: p_preferred_lang_record.OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;

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;

Line 1428: p_preferred_lang_record.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;

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;

Line 1429: p_preferred_lang_record.LAST_UPDATED_BY := 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;

Line 1430: p_preferred_lang_record.CREATION_DATE := 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;
1434: p_preferred_lang_record.ATTRIBUTE2 := FND_API.G_MISS_CHAR;

Line 1431: p_preferred_lang_record.CREATED_BY := FND_API.G_MISS_NUM;

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;

Line 1432: p_preferred_lang_record.LAST_UPDATE_LOGIN := 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;
1436: p_preferred_lang_record.ATTRIBUTE4 := FND_API.G_MISS_CHAR;

Line 1433: p_preferred_lang_record.ATTRIBUTE1 := 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;

Line 1434: p_preferred_lang_record.ATTRIBUTE2 := 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;

Line 1435: p_preferred_lang_record.ATTRIBUTE3 := 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;

Line 1436: p_preferred_lang_record.ATTRIBUTE4 := 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;

Line 1437: p_preferred_lang_record.ATTRIBUTE5 := 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;

Line 1438: p_preferred_lang_record.ATTRIBUTE6 := 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;

Line 1439: p_preferred_lang_record.ATTRIBUTE7 := 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;

Line 1440: p_preferred_lang_record.ATTRIBUTE8 := 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;

Line 1441: p_preferred_lang_record.ATTRIBUTE9 := 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;

Line 1442: p_preferred_lang_record.ATTRIBUTE10 := 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;

Line 1443: p_preferred_lang_record.ATTRIBUTE11 := 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;

Line 1444: p_preferred_lang_record.ATTRIBUTE12 := 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;

Line 1445: p_preferred_lang_record.ATTRIBUTE13 := 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;

Line 1446: p_preferred_lang_record.ATTRIBUTE14 := 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;
1450: END initialize_rec;

Line 1447: p_preferred_lang_record.ATTRIBUTE15 := 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;
1451:

Line 1448: p_preferred_lang_record.ATTRIBUTE_CATEGORY := 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:
1452:

Line 1522: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1558: p_return_status := FND_API.G_RET_STS_ERROR;

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;