DBA Data[Home] [Help]

APPS.CS_SR_PREFERRED_LANG_PVT dependencies on FND_MESSAGE

Line 52: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');

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
52: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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;

Line 53: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

49:
50: IF (l_preferred_language_rec.initialize_flag IS NULL
51: OR l_preferred_language_rec.initialize_flag <> G_INITIALIZED) THEN
52: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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;

Line 54: FND_MESSAGE.Set_Token('VALUE', l_preferred_language_rec.initialize_flag);

50: IF (l_preferred_language_rec.initialize_flag IS NULL
51: OR l_preferred_language_rec.initialize_flag <> G_INITIALIZED) THEN
52: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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;

Line 55: FND_MESSAGE.Set_Token('PARAMETER', 'Initialize_Flag');

51: OR l_preferred_language_rec.initialize_flag <> G_INITIALIZED) THEN
52: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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:

Line 107: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_PRE_CUST_USR_HK');

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;
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
111: END IF;

Line 108: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

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;
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
111: END IF;
112: END IF;

Line 143: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_PRE_VERT_USR_HK');

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;
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;

Line 144: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

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;
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148: END IF;

Line 169: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_PRE_INT_USR_HK');

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;
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;

Line 170: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

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;
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;
174:

Line 210: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');

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);
213: FND_MESSAGE.Set_Token('PARAMETER', 'Language_Code');
214: FND_MSG_PUB.Add;

Line 211: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

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);
213: FND_MESSAGE.Set_Token('PARAMETER', 'Language_Code');
214: FND_MSG_PUB.Add;
215: RAISE FND_API.G_EXC_ERROR;

Line 212: FND_MESSAGE.Set_Token('VALUE', l_preferred_language_rec.language_code);

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);
213: FND_MESSAGE.Set_Token('PARAMETER', 'Language_Code');
214: FND_MSG_PUB.Add;
215: RAISE FND_API.G_EXC_ERROR;
216: END IF;

Line 213: FND_MESSAGE.Set_Token('PARAMETER', 'Language_Code');

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);
213: FND_MESSAGE.Set_Token('PARAMETER', 'Language_Code');
214: FND_MSG_PUB.Add;
215: RAISE FND_API.G_EXC_ERROR;
216: END IF;
217:

Line 227: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');

223: from fnd_languages
224: where language_code = l_preferred_language_rec.language_code;
225: EXCEPTION
226: WHEN NO_DATA_FOUND THEN
227: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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;

Line 228: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

224: where language_code = l_preferred_language_rec.language_code;
225: EXCEPTION
226: WHEN NO_DATA_FOUND THEN
227: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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;

Line 229: FND_MESSAGE.Set_Token('VALUE', l_preferred_language_rec.language_code);

225: EXCEPTION
226: WHEN NO_DATA_FOUND THEN
227: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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

Line 230: FND_MESSAGE.Set_Token('PARAMETER', 'Language_Code');

226: WHEN NO_DATA_FOUND THEN
227: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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;

Line 244: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');

240: select 'x' into l_dummy
241: from CS_SR_PREFERRED_LANG
242: where language_code = l_preferred_language_rec.language_code;
243:
244: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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;

Line 245: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

241: from CS_SR_PREFERRED_LANG
242: where language_code = l_preferred_language_rec.language_code;
243:
244: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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;

Line 246: FND_MESSAGE.Set_Token('VALUE', l_preferred_language_rec.language_code);

242: where language_code = l_preferred_language_rec.language_code;
243:
244: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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

Line 247: FND_MESSAGE.Set_Token('PARAMETER', 'Language_Code');

243:
244: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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

Line 270: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');

266:
267: IF (l_preferred_language_rec.start_date_active is not null)
268: AND (l_preferred_language_rec.end_date_active is not null)
269: AND (l_preferred_language_rec.start_date_active > l_preferred_language_rec.end_date_active) THEN
270: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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;

Line 271: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

267: IF (l_preferred_language_rec.start_date_active is not null)
268: AND (l_preferred_language_rec.end_date_active is not null)
269: AND (l_preferred_language_rec.start_date_active > l_preferred_language_rec.end_date_active) THEN
270: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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;

Line 272: FND_MESSAGE.Set_Token('VALUE', to_char(l_preferred_language_rec.end_date_active));

268: AND (l_preferred_language_rec.end_date_active is not null)
269: AND (l_preferred_language_rec.start_date_active > l_preferred_language_rec.end_date_active) THEN
270: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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 ;

Line 273: FND_MESSAGE.Set_Token('PARAMETER', 'End_Date_Active');

269: AND (l_preferred_language_rec.start_date_active > l_preferred_language_rec.end_date_active) THEN
270: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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:

Line 464: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_CUST_USR_HK');

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;
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: END IF;

Line 465: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

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;
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: END IF;
469: END IF;

Line 501: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_VERT_USR_HK');

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;
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
505: END IF;

Line 502: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

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;
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
505: END IF;
506: END IF;

Line 526: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_INT_USR_HK');

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;
529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
530: END IF;

Line 527: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

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;
529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
530: END IF;
531:

Line 644: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');

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
644: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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;

Line 645: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

641:
642: IF (l_preferred_language_rec.initialize_flag IS NULL
643: OR l_preferred_language_rec.initialize_flag <> G_INITIALIZED) THEN
644: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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;

Line 646: FND_MESSAGE.Set_Token('VALUE', l_preferred_language_rec.initialize_flag);

642: IF (l_preferred_language_rec.initialize_flag IS NULL
643: OR l_preferred_language_rec.initialize_flag <> G_INITIALIZED) THEN
644: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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;

Line 647: FND_MESSAGE.Set_Token('PARAMETER', 'Initialize_Flag');

643: OR l_preferred_language_rec.initialize_flag <> G_INITIALIZED) THEN
644: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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:

Line 681: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');

677: --dbms_output.put_line('Fetch id=' || p_pref_lang_id || ', object_ver_num=' || p_object_version_number) ;
678: OPEN l_Preferred_Language_csr(p_pref_lang_id, p_object_version_number);
679: FETCH l_Preferred_Language_csr INTO l_old_Preferred_Language_rec;
680: IF (l_Preferred_Language_csr%NOTFOUND) THEN
681: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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;

Line 682: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

678: OPEN l_Preferred_Language_csr(p_pref_lang_id, p_object_version_number);
679: FETCH l_Preferred_Language_csr INTO l_old_Preferred_Language_rec;
680: IF (l_Preferred_Language_csr%NOTFOUND) THEN
681: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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;

Line 683: FND_MESSAGE.Set_Token('VALUE', to_char(p_pref_lang_id));

679: FETCH l_Preferred_Language_csr INTO l_old_Preferred_Language_rec;
680: IF (l_Preferred_Language_csr%NOTFOUND) THEN
681: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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;

Line 684: FND_MESSAGE.Set_Token('PARAMETER', 'Pref_Lang_ID');

680: IF (l_Preferred_Language_csr%NOTFOUND) THEN
681: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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:

Line 729: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_PRE_CUST_USR_HK');

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;
732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
733: END IF;

Line 730: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

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;
732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
733: END IF;
734: END IF;

Line 770: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_PRE_VERT_USR_HK');

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;
773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
774: END IF;

Line 771: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

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;
773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
774: END IF;
775: END IF;

Line 805: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_PRE_INT_USR_HK');

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;
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: END IF;

Line 806: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

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;
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: END IF;
810:

Line 833: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');

829: from fnd_languages
830: where language_code = l_preferred_language_rec.language_code;
831: EXCEPTION
832: WHEN NO_DATA_FOUND THEN
833: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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;

Line 834: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

830: where language_code = l_preferred_language_rec.language_code;
831: EXCEPTION
832: WHEN NO_DATA_FOUND THEN
833: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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;

Line 835: FND_MESSAGE.Set_Token('VALUE', l_preferred_language_rec.language_code);

831: EXCEPTION
832: WHEN NO_DATA_FOUND THEN
833: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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

Line 836: FND_MESSAGE.Set_Token('PARAMETER', 'Language_Code');

832: WHEN NO_DATA_FOUND THEN
833: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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;

Line 851: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');

847: from CS_SR_PREFERRED_LANG
848: where language_code = l_preferred_language_rec.language_code
849: and pref_lang_id <> p_pref_lang_id;
850:
851: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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;

Line 852: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

848: where language_code = l_preferred_language_rec.language_code
849: and pref_lang_id <> p_pref_lang_id;
850:
851: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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;

Line 853: FND_MESSAGE.Set_Token('VALUE', l_preferred_language_rec.language_code);

849: and pref_lang_id <> p_pref_lang_id;
850:
851: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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

Line 854: FND_MESSAGE.Set_Token('PARAMETER', 'Language_Code');

850:
851: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
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

Line 1101: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_CUST_USR_HK');

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;
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105: END IF;

Line 1102: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

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;
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105: END IF;
1106: END IF;

Line 1143: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_VERT_USR_HK');

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;
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: END IF;

Line 1144: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

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;
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: END IF;
1148: END IF;

Line 1171: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_INT_USR_HK');

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;
1174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1175: END IF;

Line 1172: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

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;
1174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1175: END IF;
1176:

Line 1193: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_MSG_GEN_HK');

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;
1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1197: END IF;

Line 1194: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

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;
1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1197: END IF;
1198: END IF;

Line 1251: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_CUST_USR_HK');

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;
1254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1255: END IF;

Line 1252: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

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;
1254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1255: END IF;
1256: END IF;

Line 1291: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_VERT_USR_HK');

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;
1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: END IF;

Line 1292: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

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;
1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: END IF;
1296: END IF;

Line 1319: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_POST_INT_USR_HK');

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;
1322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1323: END IF;

Line 1320: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

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;
1322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1323: END IF;
1324:

Line 1351: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ERR_MSG_GEN_HK');

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;
1354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1355: END IF;

Line 1352: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

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;
1354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1355: END IF;
1356: END IF;