DBA Data[Home] [Help]

APPS.CS_INCIDENTLINKS_PUB dependencies on FND_MSG_PUB

Line 60: FND_MSG_PUB.Initialize;

56: --#BUG 3630159
57: --Added to clear message cache in case of API call wrong version.
58: -- Initialize message list if p_init_msg_list is set to TRUE
59: IF FND_API.To_Boolean(p_init_msg_list) THEN
60: FND_MSG_PUB.Initialize;
61: END IF;
62:
63: -- Standard call to check for call compatibility
64: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

Line 147: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

143: COMMIT WORK;
144: END IF;
145:
146: -- Standard call to get message count and if count is 1, get message info
147: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
148:
149: EXCEPTION
150: WHEN FND_API.G_EXC_ERROR THEN
151: ROLLBACK TO CREATE_INCIDENTLINK_PUB;

Line 153: FND_MSG_PUB.Count_And_Get(

149: EXCEPTION
150: WHEN FND_API.G_EXC_ERROR THEN
151: ROLLBACK TO CREATE_INCIDENTLINK_PUB;
152: x_return_status := FND_API.G_RET_STS_ERROR;
153: FND_MSG_PUB.Count_And_Get(
154: p_count => x_msg_count,
155: p_data => x_msg_data);
156:
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 160: FND_MSG_PUB.Count_And_Get(

156:
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
158: ROLLBACK TO CREATE_INCIDENTLINK_PUB;
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160: FND_MSG_PUB.Count_And_Get(
161: p_count => x_msg_count,
162: p_data => x_msg_data);
163:
164: WHEN OTHERS THEN

Line 169: FND_MSG_PUB.ADD;

165: ROLLBACK TO CREATE_INCIDENTLINK_PUB;
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
168: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
169: FND_MSG_PUB.ADD;
170: FND_MSG_PUB.Count_And_Get(
171: p_count => x_msg_count,
172: p_data => x_msg_data);
173:

Line 170: FND_MSG_PUB.Count_And_Get(

166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
168: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
169: FND_MSG_PUB.ADD;
170: FND_MSG_PUB.Count_And_Get(
171: p_count => x_msg_count,
172: p_data => x_msg_data);
173:
174: END CREATE_INCIDENTLINK;

Line 292: FND_MSG_PUB.ADD;

288: WHEN OTHERS THEN
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
291: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
292: FND_MSG_PUB.ADD;
293: FND_MSG_PUB.Count_And_Get(
294: p_count => x_msg_count,
295: p_data => x_msg_data);
296:

Line 293: FND_MSG_PUB.Count_And_Get(

289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
291: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
292: FND_MSG_PUB.ADD;
293: FND_MSG_PUB.Count_And_Get(
294: p_count => x_msg_count,
295: p_data => x_msg_data);
296:
297: END CREATE_INCIDENTLINK;

Line 335: FND_MSG_PUB.Initialize;

331: --#BUG 3630159
332: --Added to clear message cache in case of API call wrong version.
333: -- Initialize message list if p_init_msg_list is set to TRUE
334: IF FND_API.To_Boolean(p_init_msg_list) THEN
335: FND_MSG_PUB.Initialize;
336: END IF;
337:
338: -- Standard call to check for call compatibility
339: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

Line 408: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

404: COMMIT WORK;
405: END IF;
406:
407: -- Standard call to get message count and if count is 1, get message info
408: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
409:
410: EXCEPTION
411: WHEN FND_API.G_EXC_ERROR THEN
412: ROLLBACK TO CREATE_INCIDENTLINK_PUB;

Line 414: FND_MSG_PUB.Count_And_Get(

410: EXCEPTION
411: WHEN FND_API.G_EXC_ERROR THEN
412: ROLLBACK TO CREATE_INCIDENTLINK_PUB;
413: x_return_status := FND_API.G_RET_STS_ERROR;
414: FND_MSG_PUB.Count_And_Get(
415: p_count => x_msg_count,
416: p_data => x_msg_data);
417:
418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 421: FND_MSG_PUB.Count_And_Get(

417:
418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
419: ROLLBACK TO CREATE_INCIDENTLINK_PUB;
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: FND_MSG_PUB.Count_And_Get(
422: p_count => x_msg_count,
423: p_data => x_msg_data);
424:
425: WHEN OTHERS THEN

Line 430: FND_MSG_PUB.ADD;

426: ROLLBACK TO CREATE_INCIDENTLINK_PUB;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
429: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
430: FND_MSG_PUB.ADD;
431: FND_MSG_PUB.Count_And_Get(
432: p_count => x_msg_count,
433: p_data => x_msg_data);
434:

Line 431: FND_MSG_PUB.Count_And_Get(

427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
429: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
430: FND_MSG_PUB.ADD;
431: FND_MSG_PUB.Count_And_Get(
432: p_count => x_msg_count,
433: p_data => x_msg_data);
434:
435: END CREATE_INCIDENTLINK;

Line 490: FND_MSG_PUB.Initialize;

486: --#BUG 3630159
487: --Added to clear message cache in case of API call wrong version.
488: -- Initialize message list if p_init_msg_list is set to TRUE
489: IF FND_API.To_Boolean(p_init_msg_list) THEN
490: FND_MSG_PUB.Initialize;
491: END IF;
492:
493: -- Standard call to check for call compatibility
494: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 595: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

591: COMMIT WORK;
592: END IF;
593:
594: -- Standard call to get message count and if count is 1, get message info
595: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
596:
597: EXCEPTION
598: WHEN FND_API.G_EXC_ERROR THEN
599: ROLLBACK TO UPDATE_INCIDENTLINK_PUB;

Line 601: FND_MSG_PUB.Count_And_Get(

597: EXCEPTION
598: WHEN FND_API.G_EXC_ERROR THEN
599: ROLLBACK TO UPDATE_INCIDENTLINK_PUB;
600: x_return_status := FND_API.G_RET_STS_ERROR;
601: FND_MSG_PUB.Count_And_Get(
602: p_count => x_msg_count,
603: p_data => x_msg_data );
604:
605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 608: FND_MSG_PUB.Count_And_Get(

604:
605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
606: ROLLBACK TO UPDATE_INCIDENTLINK_PUB;
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: FND_MSG_PUB.Count_And_Get(
609: p_count => x_msg_count,
610: p_data => x_msg_data );
611:
612: WHEN OTHERS THEN

Line 617: FND_MSG_PUB.ADD;

613: ROLLBACK TO UPDATE_INCIDENTLINK_PUB;
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
616: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
617: FND_MSG_PUB.ADD;
618: FND_MSG_PUB.Count_And_Get(
619: p_count => x_msg_count,
620: p_data => x_msg_data );
621:

Line 618: FND_MSG_PUB.Count_And_Get(

614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
616: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
617: FND_MSG_PUB.ADD;
618: FND_MSG_PUB.Count_And_Get(
619: p_count => x_msg_count,
620: p_data => x_msg_data );
621:
622: END UPDATE_INCIDENTLINK;

Line 737: FND_MSG_PUB.ADD;

733: WHEN OTHERS THEN
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
735: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
736: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
737: FND_MSG_PUB.ADD;
738: FND_MSG_PUB.Count_And_Get(
739: p_count => x_msg_count,
740: p_data => x_msg_data);
741:

Line 738: FND_MSG_PUB.Count_And_Get(

734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
735: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
736: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
737: FND_MSG_PUB.ADD;
738: FND_MSG_PUB.Count_And_Get(
739: p_count => x_msg_count,
740: p_data => x_msg_data);
741:
742: END UPDATE_INCIDENTLINK;

Line 781: FND_MSG_PUB.Initialize;

777: --#BUG 3630159
778: --Added to clear message cache in case of API call wrong version.
779: -- Initialize message list if p_init_msg_list is set to TRUE
780: IF FND_API.To_Boolean(p_init_msg_list) THEN
781: FND_MSG_PUB.Initialize;
782: END IF;
783:
784: -- Standard call to check for call compatibility
785: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 856: FND_MSG_PUB.Count_And_Get(

852: EXCEPTION
853: WHEN FND_API.G_EXC_ERROR THEN
854: ROLLBACK TO UPDATE_INCIDENTLINK_PUB;
855: x_return_status := FND_API.G_RET_STS_ERROR;
856: FND_MSG_PUB.Count_And_Get(
857: p_count => x_msg_count,
858: p_data => x_msg_data );
859:
860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 863: FND_MSG_PUB.Count_And_Get(

859:
860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
861: ROLLBACK TO UPDATE_INCIDENTLINK_PUB;
862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
863: FND_MSG_PUB.Count_And_Get(
864: p_count => x_msg_count,
865: p_data => x_msg_data );
866:
867: WHEN OTHERS THEN

Line 872: FND_MSG_PUB.ADD;

868: ROLLBACK TO UPDATE_INCIDENTLINK_PUB;
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
870: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
871: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
872: FND_MSG_PUB.ADD;
873: FND_MSG_PUB.Count_And_Get(
874: p_count => x_msg_count,
875: p_data => x_msg_data );
876:

Line 873: FND_MSG_PUB.Count_And_Get(

869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
870: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
871: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
872: FND_MSG_PUB.ADD;
873: FND_MSG_PUB.Count_And_Get(
874: p_count => x_msg_count,
875: p_data => x_msg_data );
876:
877: END UPDATE_INCIDENTLINK;

Line 909: FND_MSG_PUB.Initialize;

905: --#BUG 3630159
906: --Added to clear message cache in case of API call wrong version.
907: -- Initialize message list if p_init_msg_list is set to TRUE
908: IF FND_API.To_Boolean(p_init_msg_list) THEN
909: FND_MSG_PUB.Initialize;
910: END IF;
911:
912: -- Allow this API to be called with both version numbers, 1.2 and 2.0, added for bugs 2972584 and 2972611
913: IF p_api_version = 1.2 THEN

Line 958: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

954: COMMIT WORK;
955: END IF;
956:
957: -- Standard call to get message count and if count is 1, get message info
958: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
959:
960: EXCEPTION
961: WHEN FND_API.G_EXC_ERROR THEN
962: ROLLBACK TO DELETE_INCIDENTLINK_PUB;

Line 964: FND_MSG_PUB.Count_And_Get(

960: EXCEPTION
961: WHEN FND_API.G_EXC_ERROR THEN
962: ROLLBACK TO DELETE_INCIDENTLINK_PUB;
963: x_return_status := FND_API.G_RET_STS_ERROR;
964: FND_MSG_PUB.Count_And_Get(
965: p_count => x_msg_count,
966: p_data => x_msg_data);
967:
968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 971: FND_MSG_PUB.Count_And_Get(

967:
968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
969: ROLLBACK TO DELETE_INCIDENTLINK_PUB;
970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
971: FND_MSG_PUB.Count_And_Get(
972: p_count => x_msg_count,
973: p_data => x_msg_data);
974:
975: WHEN OTHERS THEN

Line 981: FND_MSG_PUB.ADD;

977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
979: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
980: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
981: FND_MSG_PUB.ADD;
982: FND_MSG_PUB.Count_And_Get(
983: p_count => x_msg_count,
984: p_data => x_msg_data);
985:

Line 982: FND_MSG_PUB.Count_And_Get(

978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
979: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
980: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
981: FND_MSG_PUB.ADD;
982: FND_MSG_PUB.Count_And_Get(
983: p_count => x_msg_count,
984: p_data => x_msg_data);
985:
986: END DELETE_INCIDENTLINK;

Line 1050: FND_MSG_PUB.Initialize;

1046: --#BUG 3630159
1047: --Added to clear message cache in case of API call wrong version.
1048: -- Initialize message list if p_init_msg_list is set to TRUE
1049: IF FND_API.To_Boolean(p_init_msg_list) THEN
1050: FND_MSG_PUB.Initialize;
1051: END IF;
1052:
1053: -- Standard call to check for call compatibility
1054: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

Line 1148: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1144: -- Return the retrieved external link ID to the calling program by assigning it to the OUT parameter x_link_id
1145: x_link_id := lx_link_id;
1146:
1147: -- Standard call to get message count and if count is 1, get message info
1148: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1149:
1150: EXCEPTION
1151: WHEN FND_API.G_EXC_ERROR THEN
1152: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1153: FND_MSG_PUB.Count_And_Get(

1149:
1150: EXCEPTION
1151: WHEN FND_API.G_EXC_ERROR THEN
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153: FND_MSG_PUB.Count_And_Get(
1154: p_count => x_msg_count,
1155: p_data => x_msg_data);
1156:
1157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1159: FND_MSG_PUB.Count_And_Get(

1155: p_data => x_msg_data);
1156:
1157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1159: FND_MSG_PUB.Count_And_Get(
1160: p_count => x_msg_count,
1161: p_data => x_msg_data);
1162:
1163: WHEN OTHERS THEN

Line 1167: FND_MSG_PUB.ADD;

1163: WHEN OTHERS THEN
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1165: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1166: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1167: FND_MSG_PUB.ADD;
1168: FND_MSG_PUB.Count_And_Get(
1169: p_count => x_msg_count,
1170: p_data => x_msg_data);
1171:

Line 1168: FND_MSG_PUB.Count_And_Get(

1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1165: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1166: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1167: FND_MSG_PUB.ADD;
1168: FND_MSG_PUB.Count_And_Get(
1169: p_count => x_msg_count,
1170: p_data => x_msg_data);
1171:
1172: END CREATE_INCIDENTLINK_EXT;

Line 1237: FND_MSG_PUB.Initialize;

1233: --#BUG 3630159
1234: --Added to clear message cache in case of API call wrong version.
1235: -- Initialize message list if p_init_msg_list is set to TRUE
1236: IF FND_API.To_Boolean(p_init_msg_list) THEN
1237: FND_MSG_PUB.Initialize;
1238: END IF;
1239:
1240: -- Standard call to check for call compatibility
1241: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

Line 1437: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1433: COMMIT WORK;
1434: END IF;
1435:
1436: -- Standard call to get message count and if count is 1, get message info
1437: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1438:
1439: EXCEPTION
1440: WHEN FND_API.G_EXC_ERROR THEN
1441: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1442: FND_MSG_PUB.Count_And_Get(

1438:
1439: EXCEPTION
1440: WHEN FND_API.G_EXC_ERROR THEN
1441: x_return_status := FND_API.G_RET_STS_ERROR;
1442: FND_MSG_PUB.Count_And_Get(
1443: p_count => x_msg_count,
1444: p_data => x_msg_data);
1445:
1446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1448: FND_MSG_PUB.Count_And_Get(

1444: p_data => x_msg_data);
1445:
1446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1448: FND_MSG_PUB.Count_And_Get(
1449: p_count => x_msg_count,
1450: p_data => x_msg_data);
1451:
1452: WHEN OTHERS THEN

Line 1456: FND_MSG_PUB.ADD;

1452: WHEN OTHERS THEN
1453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1454: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1455: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1456: FND_MSG_PUB.ADD;
1457: FND_MSG_PUB.Count_And_Get(
1458: p_count => x_msg_count,
1459: p_data => x_msg_data);
1460:

Line 1457: FND_MSG_PUB.Count_And_Get(

1453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1454: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1455: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1456: FND_MSG_PUB.ADD;
1457: FND_MSG_PUB.Count_And_Get(
1458: p_count => x_msg_count,
1459: p_data => x_msg_data);
1460:
1461: END UPDATE_INCIDENTLINK_EXT;

Line 1500: FND_MSG_PUB.Initialize;

1496: --#BUG 3630159
1497: --Added to clear message cache in case of API call wrong version.
1498: -- Initialize message list if p_init_msg_list is set to TRUE
1499: IF FND_API.To_Boolean(p_init_msg_list) THEN
1500: FND_MSG_PUB.Initialize;
1501: END IF;
1502:
1503: -- Standard call to check for call compatibility
1504: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

Line 1598: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1594: COMMIT WORK;
1595: END IF;
1596:
1597: -- Standard call to get message count and if count is 1, get message info
1598: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1599:
1600: EXCEPTION
1601: WHEN FND_API.G_EXC_ERROR THEN
1602: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1603: FND_MSG_PUB.Count_And_Get(

1599:
1600: EXCEPTION
1601: WHEN FND_API.G_EXC_ERROR THEN
1602: x_return_status := FND_API.G_RET_STS_ERROR;
1603: FND_MSG_PUB.Count_And_Get(
1604: p_count => x_msg_count,
1605: p_data => x_msg_data);
1606:
1607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1609: FND_MSG_PUB.Count_And_Get(

1605: p_data => x_msg_data);
1606:
1607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1609: FND_MSG_PUB.Count_And_Get(
1610: p_count => x_msg_count,
1611: p_data => x_msg_data);
1612:
1613: WHEN OTHERS THEN

Line 1617: FND_MSG_PUB.ADD;

1613: WHEN OTHERS THEN
1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1615: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1616: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1617: FND_MSG_PUB.ADD;
1618: FND_MSG_PUB.Count_And_Get(
1619: p_count => x_msg_count,
1620: p_data => x_msg_data);
1621:

Line 1618: FND_MSG_PUB.Count_And_Get(

1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1615: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1616: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1617: FND_MSG_PUB.ADD;
1618: FND_MSG_PUB.Count_And_Get(
1619: p_count => x_msg_count,
1620: p_data => x_msg_data);
1621:
1622: END DELETE_INCIDENTLINK_EXT;