DBA Data[Home] [Help]

APPS.CS_SR_PREFERRED_LANG_PVT dependencies on FND_MSG_PUB

Line 56: FND_MSG_PUB.Add;

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:
60: -- Initialize message list if p_init_msg_list is set to TRUE

Line 62: FND_MSG_PUB.Initialize;

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
66: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 109: FND_MSG_PUB.Add;

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

Line 145: FND_MSG_PUB.Add;

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

Line 171: FND_MSG_PUB.Add;

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

Line 214: FND_MSG_PUB.Add;

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:
218: IF (p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN

Line 231: FND_MSG_PUB.Add;

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

Line 248: FND_MSG_PUB.Add;

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

Line 274: FND_MSG_PUB.Add;

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

Line 466: FND_MSG_PUB.Add;

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

Line 503: FND_MSG_PUB.Add;

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

Line 528: FND_MSG_PUB.Add;

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:
532: --END IF;

Line 549: FND_MSG_PUB.Count_And_Get

545: END IF;
546:
547:
548: -- Standard call to get message count and if count is 1, get message info
549: FND_MSG_PUB.Count_And_Get
550: ( p_count => x_msg_count,
551: p_data => x_msg_data
552: );
553:

Line 558: FND_MSG_PUB.Count_And_Get

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: );
562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 565: FND_MSG_PUB.Count_And_Get

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: );
569: WHEN OTHERS THEN

Line 572: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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
576: ( p_count => x_msg_count,

Line 573: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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
576: ( p_count => x_msg_count,
577: p_data => x_msg_data

Line 575: FND_MSG_PUB.Count_And_Get

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
576: ( p_count => x_msg_count,
577: p_data => x_msg_data
578: );
579: END Create_Preferred_Language;

Line 648: FND_MSG_PUB.Add;

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:
652: -- Initialize message list if p_init_msg_list is set to TRUE

Line 654: FND_MSG_PUB.Initialize;

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
658: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 685: FND_MSG_PUB.Add;

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:
689: --dbms_output.put_line('After Fetch') ;

Line 731: FND_MSG_PUB.Add;

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

Line 772: FND_MSG_PUB.Add;

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

Line 807: FND_MSG_PUB.Add;

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

Line 837: FND_MSG_PUB.Add;

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

Line 855: FND_MSG_PUB.Add;

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

Line 1103: FND_MSG_PUB.Add;

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

Line 1145: FND_MSG_PUB.Add;

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

Line 1173: FND_MSG_PUB.Add;

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:
1177: --END IF;

Line 1195: FND_MSG_PUB.Add;

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

Line 1253: FND_MSG_PUB.Add;

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

Line 1293: FND_MSG_PUB.Add;

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

Line 1321: FND_MSG_PUB.Add;

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:
1325: --END IF;

Line 1353: FND_MSG_PUB.Add;

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;
1357: END IF;

Line 1371: FND_MSG_PUB.Count_And_Get

1367: END IF;
1368:
1369:
1370: -- Standard call to get message count and if count is 1, get message info
1371: FND_MSG_PUB.Count_And_Get
1372: ( p_count => x_msg_count,
1373: p_data => x_msg_data
1374: );
1375:

Line 1383: FND_MSG_PUB.Count_And_Get

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

Line 1394: FND_MSG_PUB.Count_And_Get

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

Line 1405: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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
1409: ( p_count => x_msg_count,

Line 1406: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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
1409: ( p_count => x_msg_count,
1410: p_data => x_msg_data

Line 1408: FND_MSG_PUB.Count_And_Get

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
1409: ( p_count => x_msg_count,
1410: p_data => x_msg_data
1411: );
1412: