DBA Data[Home] [Help]

APPS.CSD_RO_BULLETINS_PVT dependencies on FND_MSG_PUB

Line 72: FND_MSG_PUB.initialize;

68:
69: --* Initialize message list if p_init_msg_list is set to TRUE.
70: IF FND_API.to_Boolean( p_init_msg_list )
71: THEN
72: FND_MSG_PUB.initialize;
73: END IF;
74:
75: --* Initialize API return status to SUCCESS
76: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 109: FND_MSG_PUB.Count_And_Get(

105: COMMIT WORK;
106: END IF;
107:
108: --* Standard call to get message count and if count is 1, get message info.
109: FND_MSG_PUB.Count_And_Get(
110: p_count => x_msg_count,
111: p_data => x_msg_data
112: );
113:

Line 120: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

116: x_return_status := FND_API.G_RET_STS_ERROR;
117: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
118: P_API_NAME => c_API_NAME
119: ,P_PKG_NAME => G_PKG_NAME
120: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
121: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
122: ,X_MSG_COUNT => X_MSG_COUNT
123: ,X_MSG_DATA => X_MSG_DATA
124: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 131: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

127: x_return_status := FND_API.G_RET_STS_ERROR;
128: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
129: P_API_NAME => c_API_NAME
130: ,P_PKG_NAME => G_PKG_NAME
131: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
132: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
133: ,X_MSG_COUNT => X_MSG_COUNT
134: ,X_MSG_DATA => X_MSG_DATA
135: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 227: FND_MSG_PUB.initialize;

223:
224: --* Initialize message list if p_init_msg_list is set to TRUE.
225: IF FND_API.to_Boolean( p_init_msg_list )
226: THEN
227: FND_MSG_PUB.initialize;
228: END IF;
229:
230: --* Initialize API return status to SUCCESS
231: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 252: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

248: l_ref_ro_bulletin_rec.last_update_date,
249: l_ref_ro_bulletin_rec.last_update_login;
250:
251: IF ( cur_get_ro_bulletin%NOTFOUND) THEN
252: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
253: FND_MESSAGE.Set_Name('CSD', 'CSD_RO_BTNS_NO_RECORD_FOUND'); -- no record is returned for the query
254: FND_MESSAGE.set_token( 'BULLETIN_ID', p_ro_bulletin_rec.RO_BULLETIN_ID);
255: FND_MSG_PUB.Add;
256: END IF;

Line 255: FND_MSG_PUB.Add;

251: IF ( cur_get_ro_bulletin%NOTFOUND) THEN
252: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
253: FND_MESSAGE.Set_Name('CSD', 'CSD_RO_BTNS_NO_RECORD_FOUND'); -- no record is returned for the query
254: FND_MESSAGE.set_token( 'BULLETIN_ID', p_ro_bulletin_rec.RO_BULLETIN_ID);
255: FND_MSG_PUB.Add;
256: END IF;
257: CLOSE cur_get_ro_bulletin;
258: RAISE FND_API.G_EXC_ERROR;
259: END IF;

Line 290: FND_MSG_PUB.Count_And_Get(

286: END IF;
287:
288:
289: --* Standard call to get message count and if count is 1, get message info.
290: FND_MSG_PUB.Count_And_Get(
291: p_count => x_msg_count,
292: p_data => x_msg_data
293: );
294:

Line 301: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

297: x_return_status := FND_API.G_RET_STS_ERROR;
298: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
299: P_API_NAME => c_API_NAME
300: ,P_PKG_NAME => G_PKG_NAME
301: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
302: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
303: ,X_MSG_COUNT => X_MSG_COUNT
304: ,X_MSG_DATA => X_MSG_DATA
305: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 312: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

308: x_return_status := FND_API.G_RET_STS_ERROR;
309: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
310: P_API_NAME => c_API_NAME
311: ,P_PKG_NAME => G_PKG_NAME
312: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
313: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
314: ,X_MSG_COUNT => X_MSG_COUNT
315: ,X_MSG_DATA => X_MSG_DATA
316: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 385: FND_MSG_PUB.initialize;

381:
382: --* Initialize message list if p_init_msg_list is set to TRUE.
383: IF FND_API.to_Boolean( p_init_msg_list )
384: THEN
385: FND_MSG_PUB.initialize;
386: END IF;
387:
388: --* Initialize API return status to SUCCESS
389: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 406: FND_MSG_PUB.Count_And_Get(

402: END IF;
403:
404:
405: --* Standard call to get message count and if count is 1, get message info.
406: FND_MSG_PUB.Count_And_Get(
407: p_count => x_msg_count,
408: p_data => x_msg_data
409: );
410:

Line 417: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

413: x_return_status := FND_API.G_RET_STS_ERROR;
414: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
415: P_API_NAME => c_API_NAME
416: ,P_PKG_NAME => G_PKG_NAME
417: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
418: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
419: ,X_MSG_COUNT => X_MSG_COUNT
420: ,X_MSG_DATA => X_MSG_DATA
421: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 428: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

424: x_return_status := FND_API.G_RET_STS_ERROR;
425: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
426: P_API_NAME => c_API_NAME
427: ,P_PKG_NAME => G_PKG_NAME
428: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
429: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
430: ,X_MSG_COUNT => X_MSG_COUNT
431: ,X_MSG_DATA => X_MSG_DATA
432: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 499: FND_MSG_PUB.initialize;

495:
496: --* Initialize message list if p_init_msg_list is set to TRUE.
497: IF FND_API.to_Boolean( p_init_msg_list )
498: THEN
499: FND_MSG_PUB.initialize;
500: END IF;
501:
502: --* Initialize API return status to SUCCESS
503: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 521: FND_MSG_PUB.Count_And_Get(

517: END IF;
518:
519:
520: --* Standard call to get message count and if count is 1, get message info.
521: FND_MSG_PUB.Count_And_Get(
522: p_count => x_msg_count,
523: p_data => x_msg_data
524: );
525:

Line 532: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

528: x_return_status := FND_API.G_RET_STS_ERROR;
529: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
530: P_API_NAME => c_API_NAME
531: ,P_PKG_NAME => G_PKG_NAME
532: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
533: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
534: ,X_MSG_COUNT => X_MSG_COUNT
535: ,X_MSG_DATA => X_MSG_DATA
536: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 543: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

539: x_return_status := FND_API.G_RET_STS_ERROR;
540: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
541: P_API_NAME => c_API_NAME
542: ,P_PKG_NAME => G_PKG_NAME
543: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
544: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
545: ,X_MSG_COUNT => X_MSG_COUNT
546: ,X_MSG_DATA => X_MSG_DATA
547: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 629: FND_MSG_PUB.initialize;

625:
626: --* Initialize message list if p_init_msg_list is set to TRUE.
627: IF FND_API.to_Boolean( p_init_msg_list )
628: THEN
629: FND_MSG_PUB.initialize;
630: END IF;
631:
632: --* Initialize API return status to SUCCESS
633: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 657: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

653: x_msg_count => x_msg_count,
654: x_msg_data => x_msg_data
655: );
656: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
657: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
658: FND_MESSAGE.Set_Name('CSD', 'CSD_UPDATE_REPAIR_FAILED');
659: FND_MSG_PUB.Add;
660: END IF;
661: RAISE FND_API.G_EXC_ERROR;

Line 659: FND_MSG_PUB.Add;

655: );
656: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
657: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
658: FND_MESSAGE.Set_Name('CSD', 'CSD_UPDATE_REPAIR_FAILED');
659: FND_MSG_PUB.Add;
660: END IF;
661: RAISE FND_API.G_EXC_ERROR;
662: END IF; --* end IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) *--
663:

Line 719: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

715: x_msg_data => x_msg_data
716: );
717:
718: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
719: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
720: FND_MESSAGE.Set_Name('CSD', 'CSD_RULE_MATCH_FAILED');
721: FND_MSG_PUB.Add;
722: END IF;
723: RAISE FND_API.G_EXC_ERROR;

Line 721: FND_MSG_PUB.Add;

717:
718: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
719: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
720: FND_MESSAGE.Set_Name('CSD', 'CSD_RULE_MATCH_FAILED');
721: FND_MSG_PUB.Add;
722: END IF;
723: RAISE FND_API.G_EXC_ERROR;
724: END IF;
725:

Line 768: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

764: --** debug starts!!
765: -- dbms_output.put_line('in LINK_BULLETINS_TO_RO ONE_REPAIR - after create new link, x_return_status = ' || x_return_status);
766: --** debug ends!!
767: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
768: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
769: FND_MESSAGE.Set_Name('CSD', 'CSD_CREATE_RO_BLTN_LINK_FAILED');
770: FND_MSG_PUB.Add;
771: END IF;
772: RAISE FND_API.G_EXC_ERROR;

Line 770: FND_MSG_PUB.Add;

766: --** debug ends!!
767: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
768: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
769: FND_MESSAGE.Set_Name('CSD', 'CSD_CREATE_RO_BLTN_LINK_FAILED');
770: FND_MSG_PUB.Add;
771: END IF;
772: RAISE FND_API.G_EXC_ERROR;
773: END IF; -- end IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN --
774: --* loop logic ends

Line 786: FND_MSG_PUB.Count_And_Get(

782: COMMIT WORK;
783: END IF;
784:
785: --* Standard call to get message count and if count is 1, get message info.
786: FND_MSG_PUB.Count_And_Get(
787: p_count => x_msg_count,
788: p_data => x_msg_data
789: );
790:

Line 797: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

793: x_return_status := FND_API.G_RET_STS_ERROR;
794: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
795: P_API_NAME => c_API_NAME
796: ,P_PKG_NAME => G_PKG_NAME
797: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
798: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
799: ,X_MSG_COUNT => X_MSG_COUNT
800: ,X_MSG_DATA => X_MSG_DATA
801: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 808: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

804: x_return_status := FND_API.G_RET_STS_ERROR;
805: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
806: P_API_NAME => c_API_NAME
807: ,P_PKG_NAME => G_PKG_NAME
808: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
809: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
810: ,X_MSG_COUNT => X_MSG_COUNT
811: ,X_MSG_DATA => X_MSG_DATA
812: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 955: FND_MSG_PUB.initialize;

951:
952: --* Initialize message list if p_init_msg_list is set to TRUE.
953: IF FND_API.to_Boolean( p_init_msg_list )
954: THEN
955: FND_MSG_PUB.initialize;
956: END IF;
957:
958: --* Initialize API return status to SUCCESS
959: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1056: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1052: x_msg_count => x_msg_count,
1053: x_msg_data => x_msg_data
1054: );
1055: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1056: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1057: FND_MESSAGE.Set_Name('CSD', 'CSD_CREATE_RO_BLTN_FAILED');
1058: FND_MSG_PUB.Add;
1059: END IF;
1060: RAISE FND_API.G_EXC_ERROR;

Line 1058: FND_MSG_PUB.Add;

1054: );
1055: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1056: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1057: FND_MESSAGE.Set_Name('CSD', 'CSD_CREATE_RO_BLTN_FAILED');
1058: FND_MSG_PUB.Add;
1059: END IF;
1060: RAISE FND_API.G_EXC_ERROR;
1061: END IF; --* end IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) *--
1062:

Line 1127: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1123: x_msg_count => x_msg_count,
1124: x_msg_data => x_msg_data
1125: );
1126: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1127: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1128: FND_MESSAGE.Set_Name('CSD', 'CSD_UPDATE_REPAIR_FAILED');
1129: FND_MSG_PUB.Add;
1130: END IF;
1131: RAISE FND_API.G_EXC_ERROR;

Line 1129: FND_MSG_PUB.Add;

1125: );
1126: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1127: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1128: FND_MESSAGE.Set_Name('CSD', 'CSD_UPDATE_REPAIR_FAILED');
1129: FND_MSG_PUB.Add;
1130: END IF;
1131: RAISE FND_API.G_EXC_ERROR;
1132: END IF; --* end IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) *--
1133:

Line 1183: FND_MSG_PUB.Count_And_Get(

1179: --dbms_output.put_line('in CREATE_NEW_RO_BULLETIN_LINK after check for p_commit ');
1180: --** debug ends!!
1181:
1182: --* Standard call to get message count and if count is 1, get message info.
1183: FND_MSG_PUB.Count_And_Get(
1184: p_count => x_msg_count,
1185: p_data => x_msg_data
1186: );
1187:

Line 1202: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1198:
1199: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1200: P_API_NAME => c_API_NAME
1201: ,P_PKG_NAME => G_PKG_NAME
1202: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1203: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1204: ,X_MSG_COUNT => X_MSG_COUNT
1205: ,X_MSG_DATA => X_MSG_DATA
1206: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1217: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1213:
1214: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1215: P_API_NAME => c_API_NAME
1216: ,P_PKG_NAME => G_PKG_NAME
1217: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1218: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1219: ,X_MSG_COUNT => X_MSG_COUNT
1220: ,X_MSG_DATA => X_MSG_DATA
1221: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1393: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;

1389: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1390: -- Concatenate the message from the message stack
1391: IF l_msg_count > 1 then
1392: FOR i IN 1..l_msg_count LOOP
1393: l_msg_data := l_msg_data||FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;
1394: END LOOP ;
1395: END IF ;
1396: --dbms_output.put_line(l_msg_data);
1397: -- Do not exit out of loop:

Line 1505: FND_MSG_PUB.initialize;

1501: END IF;
1502:
1503: -- Initialize message list if p_init_msg_list is set to TRUE.
1504: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1505: FND_MSG_PUB.initialize;
1506: END IF;
1507:
1508: -- initialize bulletin_id
1509: IF (p_bulletin_id is null) THEN

Line 1608: FND_MSG_PUB.Count_And_Get

1604: COMMIT WORK;
1605: END IF;
1606:
1607: -- Standard call to get message count and IF count is get message info.
1608: FND_MSG_PUB.Count_And_Get
1609: (p_count => x_msg_count,
1610: p_data => x_msg_data );
1611: EXCEPTION
1612: WHEN FND_API.G_EXC_ERROR THEN

Line 1620: FND_MSG_PUB.Count_And_Get

1616: IF NOT(FND_API.To_Boolean( p_commit )) THEN
1617: ROLLBACK TO LINK_BULLETIN_FOR_RULE;
1618: END IF;
1619: x_return_status := FND_API.G_RET_STS_ERROR ;
1620: FND_MSG_PUB.Count_And_Get
1621: (p_count => x_msg_count,
1622: p_data => x_msg_data );
1623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1624: --dbms_output.put_line('In FND_API.G_EXC_UNEXPECTED_ERROR exception');

Line 1637: FND_MSG_PUB.Count_And_Get

1633: IF NOT(FND_API.To_Boolean( p_commit )) THEN
1634: ROLLBACK TO LINK_BULLETIN_FOR_RULE;
1635: END IF;
1636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1637: FND_MSG_PUB.Count_And_Get
1638: ( p_count => x_msg_count,
1639: p_data => x_msg_data );
1640: WHEN OTHERS THEN
1641: --dbms_output.put_line('In OTHERS exception');

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

1650: IF NOT(FND_API.To_Boolean( p_commit )) THEN
1651: ROLLBACK TO LINK_BULLETIN_FOR_RULE;
1652: END IF;
1653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1654: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1655: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1656: l_api_name );
1657: END IF;
1658: FND_MSG_PUB.Count_And_Get

Line 1655: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

1651: ROLLBACK TO LINK_BULLETIN_FOR_RULE;
1652: END IF;
1653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1654: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1655: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1656: l_api_name );
1657: END IF;
1658: FND_MSG_PUB.Count_And_Get
1659: ( p_count => x_msg_count,

Line 1658: FND_MSG_PUB.Count_And_Get

1654: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1655: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1656: l_api_name );
1657: END IF;
1658: FND_MSG_PUB.Count_And_Get
1659: ( p_count => x_msg_count,
1660: p_data => x_msg_data );
1661:
1662: END LINK_BULLETIN_FOR_RULE;

Line 1783: FND_MSG_PUB.initialize;

1779: END IF;
1780:
1781: -- Initialize message list if p_init_msg_list is set to TRUE.
1782: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1783: FND_MSG_PUB.initialize;
1784: END IF;
1785:
1786: FOR i IN 1.. p_service_codes.count LOOP
1787: -- check if SC is for this repair order item

Line 1878: FND_MSG_PUB.Count_And_Get

1874: COMMIT WORK;
1875: END IF;
1876:
1877: -- Standard call to get message count and IF count is get message info.
1878: FND_MSG_PUB.Count_And_Get
1879: (p_count => x_msg_count,
1880: p_data => x_msg_data );
1881:
1882: EXCEPTION

Line 1887: FND_MSG_PUB.Count_And_Get

1883: WHEN FND_API.G_EXC_ERROR THEN
1884: --dbms_output.put_line('In FND_API.G_EXC_ERROR exception');
1885: ROLLBACK TO APPLY_BULLETIN_SCS_TO_RO;
1886: x_return_status := FND_API.G_RET_STS_ERROR ;
1887: FND_MSG_PUB.Count_And_Get
1888: (p_count => x_msg_count,
1889: p_data => x_msg_data );
1890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1891: --dbms_output.put_line('In FND_API.G_EXC_UNEXPECTED_ERROR exception');

Line 1900: FND_MSG_PUB.Count_And_Get

1896: fnd_log.message(l_error_level,l_mod_name,FALSE);
1897: END If;
1898: ROLLBACK TO APPLY_BULLETIN_SCS_TO_RO;
1899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1900: FND_MSG_PUB.Count_And_Get
1901: ( p_count => x_msg_count,
1902: p_data => x_msg_data );
1903: WHEN OTHERS THEN
1904: -- dbms_output.put_line('In OTHERS exception' );

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

1909: fnd_log.message(l_error_level,l_mod_name,FALSE);
1910: END If;
1911: ROLLBACK TO APPLY_BULLETIN_SCS_TO_RO;
1912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1913: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1914: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1915: l_api_name );
1916: END IF;
1917: FND_MSG_PUB.Count_And_Get

Line 1914: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

1910: END If;
1911: ROLLBACK TO APPLY_BULLETIN_SCS_TO_RO;
1912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1913: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1914: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1915: l_api_name );
1916: END IF;
1917: FND_MSG_PUB.Count_And_Get
1918: ( p_count => x_msg_count,

Line 1917: FND_MSG_PUB.Count_And_Get

1913: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1914: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1915: l_api_name );
1916: END IF;
1917: FND_MSG_PUB.Count_And_Get
1918: ( p_count => x_msg_count,
1919: p_data => x_msg_data );
1920:
1921: END APPLY_BULLETIN_SCS_TO_RO;