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