DBA Data[Home] [Help]

APPS.CS_INCIDENTLINKS_PVT dependencies on FND_MSG_PUB

Line 136: FND_MSG_PUB.ADD;

132: WHEN OTHERS THEN
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
135: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
136: FND_MSG_PUB.ADD;
137: FND_MSG_PUB.Count_And_Get(
138: p_count => x_msg_count,
139: p_data => x_msg_data);
140:

Line 137: FND_MSG_PUB.Count_And_Get(

133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
135: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
136: FND_MSG_PUB.ADD;
137: FND_MSG_PUB.Count_And_Get(
138: p_count => x_msg_count,
139: p_data => x_msg_data);
140:
141: END CREATE_INCIDENTLINK;

Line 246: FND_MSG_PUB.Initialize;

242: SAVEPOINT Create_IncidentLink_PVT;
243:
244: -- Initialize message list if p_init_msg_list is set to TRUE
245: IF FND_API.To_Boolean(p_init_msg_list) THEN
246: FND_MSG_PUB.Initialize;
247: END IF;
248:
249: -- Allow this API to be called with both version numbers, 1.2 and 2.0,
250: -- introduced for bugs 2972584 and 2972611

Line 260: FND_MSG_PUB.Count_And_Get(

256:
257: -- Standard call to check for call compatibility
258: IF NOT FND_API.Compatible_API_Call(l_invoked_version, p_api_version,
259: l_api_name, G_PKG_NAME) THEN
260: FND_MSG_PUB.Count_And_Get(
261: p_count => x_msg_count,
262: p_data => x_msg_data );
263:
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 314: FND_MSG_PUB.Count_And_Get(

310: p_login_id => p_login_id,
311: x_return_status => x_return_status );
312:
313: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
314: FND_MSG_PUB.Count_And_Get(
315: p_count => x_msg_count,
316: p_data => x_msg_data );
317: RAISE FND_API.G_EXC_ERROR;
318: END IF;

Line 366: FND_MSG_PUB.Add;

362: (p_link_rec.subject_type = p_link_rec.object_type)) THEN
363:
364: FND_MESSAGE.Set_Name('CS', 'CS_SR_SAME_SUBJECT_OBJECT');
365: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
366: FND_MSG_PUB.Add;
367:
368: FND_MSG_PUB.Count_And_Get(
369: p_count => x_msg_count,
370: p_data => x_msg_data);

Line 368: FND_MSG_PUB.Count_And_Get(

364: FND_MESSAGE.Set_Name('CS', 'CS_SR_SAME_SUBJECT_OBJECT');
365: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
366: FND_MSG_PUB.Add;
367:
368: FND_MSG_PUB.Count_And_Get(
369: p_count => x_msg_count,
370: p_data => x_msg_data);
371:
372: RAISE FND_API.G_EXC_ERROR;

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

1126: -- if the p_commit parameter is FALSE. This issue is faced by HTML service since the
1127: -- API is called with p_commit= false -- spusegao 12/15/2003
1128:
1129: -- Standard call to get message count and if count is 1, get message info
1130: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1131:
1132: EXCEPTION
1133: WHEN FND_API.G_EXC_ERROR THEN
1134: ROLLBACK TO create_incidentlink_pvt;

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

1132: EXCEPTION
1133: WHEN FND_API.G_EXC_ERROR THEN
1134: ROLLBACK TO create_incidentlink_pvt;
1135: x_return_status := FND_API.G_RET_STS_ERROR;
1136: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1137:
1138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1139: ROLLBACK TO create_incidentlink_pvt;
1140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1137:
1138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1139: ROLLBACK TO create_incidentlink_pvt;
1140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1141: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1142:
1143: WHEN OTHERS THEN
1144: ROLLBACK TO create_incidentlink_pvt;
1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1148: FND_MSG_PUB.ADD;

1144: ROLLBACK TO create_incidentlink_pvt;
1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1146: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1147: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1148: FND_MSG_PUB.ADD;
1149: FND_MSG_PUB.Count_And_Get(
1150: p_count => x_msg_count,
1151: p_data => x_msg_data);
1152:

Line 1149: FND_MSG_PUB.Count_And_Get(

1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1146: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1147: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1148: FND_MSG_PUB.ADD;
1149: FND_MSG_PUB.Count_And_Get(
1150: p_count => x_msg_count,
1151: p_data => x_msg_data);
1152:
1153: END CREATE_INCIDENTLINK;

Line 1268: FND_MSG_PUB.ADD;

1264: WHEN OTHERS THEN
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1266: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1267: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1268: FND_MSG_PUB.ADD;
1269: FND_MSG_PUB.Count_And_Get(
1270: p_count => x_msg_count,
1271: p_data => x_msg_data);
1272:

Line 1269: FND_MSG_PUB.Count_And_Get(

1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1266: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1267: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1268: FND_MSG_PUB.ADD;
1269: FND_MSG_PUB.Count_And_Get(
1270: p_count => x_msg_count,
1271: p_data => x_msg_data);
1272:
1273: END UPDATE_INCIDENTLINK;

Line 1363: FND_MSG_PUB.Initialize;

1359: SAVEPOINT Update_IncidentLink_PVT;
1360:
1361: -- Initialize message list if p_init_msg_list is set to TRUE
1362: IF FND_API.To_Boolean(p_init_msg_list) THEN
1363: FND_MSG_PUB.Initialize;
1364: END IF;
1365:
1366: -- Allow this API to be called with both version numbers, 1.2 and 2.0, introduced for bugs 2972584 and 2972611
1367: IF p_api_version = 1.2 THEN

Line 1376: FND_MSG_PUB.Count_And_Get(

1372:
1373: -- Standard call to check for call compatibility, changed so that both versions 1.2 and 2.0 may be allowed
1374: IF NOT FND_API.Compatible_API_Call(l_invoked_version, p_api_version,
1375: l_api_name, G_PKG_NAME) THEN
1376: FND_MSG_PUB.Count_And_Get(
1377: p_count => x_msg_count,
1378: p_data => x_msg_data );
1379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1380: END IF;

Line 1399: FND_MSG_PUB.Add;

1395: close c_old_values;
1396: FND_MESSAGE.Set_Name('CS', 'CS_INVALID_INCIDENT_LINK_ID');
1397: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1398: FND_MESSAGE.Set_Token('LINK_ID', to_char(p_link_id));
1399: FND_MSG_PUB.Add;
1400: FND_MSG_PUB.Count_And_Get(
1401: p_count => x_msg_count,
1402: p_data => x_msg_data );
1403: RAISE FND_API.G_EXC_ERROR;

Line 1400: FND_MSG_PUB.Count_And_Get(

1396: FND_MESSAGE.Set_Name('CS', 'CS_INVALID_INCIDENT_LINK_ID');
1397: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1398: FND_MESSAGE.Set_Token('LINK_ID', to_char(p_link_id));
1399: FND_MSG_PUB.Add;
1400: FND_MSG_PUB.Count_And_Get(
1401: p_count => x_msg_count,
1402: p_data => x_msg_data );
1403: RAISE FND_API.G_EXC_ERROR;
1404: end if; -- (p_link_rec.link_id_ext IS NULL)

Line 1408: FND_MSG_PUB.Add;

1404: end if; -- (p_link_rec.link_id_ext IS NULL)
1405:
1406: ELSIF (l_old_values_rec.object_version_number <> p_object_version_number) THEN
1407: FND_MESSAGE.Set_Name('CS', 'CS_RECORD_HAS_BEEN_UPDATED');
1408: FND_MSG_PUB.Add;
1409: FND_MSG_PUB.Count_And_Get(
1410: p_count => x_msg_count,
1411: p_data => x_msg_data );
1412: RAISE FND_API.G_EXC_ERROR;

Line 1409: FND_MSG_PUB.Count_And_Get(

1405:
1406: ELSIF (l_old_values_rec.object_version_number <> p_object_version_number) THEN
1407: FND_MESSAGE.Set_Name('CS', 'CS_RECORD_HAS_BEEN_UPDATED');
1408: FND_MSG_PUB.Add;
1409: FND_MSG_PUB.Count_And_Get(
1410: p_count => x_msg_count,
1411: p_data => x_msg_data );
1412: RAISE FND_API.G_EXC_ERROR;
1413: end if; -- ( c_old_values%NOTFOUND )

Line 1474: FND_MSG_PUB.Count_And_Get(

1470: p_login_id => p_login_id,
1471: x_return_status => x_return_status );
1472:
1473: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1474: FND_MSG_PUB.Count_And_Get(
1475: p_count => x_msg_count,
1476: p_data => x_msg_data);
1477:
1478: RAISE FND_API.G_EXC_ERROR;

Line 1842: FND_MSG_PUB.Count_And_Get(

1838:
1839: --
1840: -- Standard call to get message count and if count is 1, get message info
1841: --
1842: FND_MSG_PUB.Count_And_Get(
1843: p_count => x_msg_count,
1844: p_data => x_msg_data);
1845:
1846: EXCEPTION

Line 1850: FND_MSG_PUB.Count_And_Get(

1846: EXCEPTION
1847: WHEN FND_API.G_EXC_ERROR THEN
1848: ROLLBACK TO UPDATE_INCIDENTLINK_PVT;
1849: x_return_status := FND_API.G_RET_STS_ERROR;
1850: FND_MSG_PUB.Count_And_Get(
1851: p_count => x_msg_count,
1852: p_data => x_msg_data);
1853:
1854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1857: FND_MSG_PUB.Count_And_Get(

1853:
1854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1855: ROLLBACK TO UPDATE_INCIDENTLINK_PVT;
1856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1857: FND_MSG_PUB.Count_And_Get(
1858: p_count => x_msg_count,
1859: p_data => x_msg_data);
1860:
1861: WHEN OTHERS THEN

Line 1866: FND_MSG_PUB.ADD;

1862: ROLLBACK TO UPDATE_INCIDENTLINK_PVT;
1863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1864: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1865: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1866: FND_MSG_PUB.ADD;
1867: FND_MSG_PUB.Count_And_Get(
1868: p_count => x_msg_count,
1869: p_data => x_msg_data);
1870:

Line 1867: FND_MSG_PUB.Count_And_Get(

1863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1864: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1865: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1866: FND_MSG_PUB.ADD;
1867: FND_MSG_PUB.Count_And_Get(
1868: p_count => x_msg_count,
1869: p_data => x_msg_data);
1870:
1871: END update_incidentlink;

Line 1917: FND_MSG_PUB.ADD;

1913: WHEN OTHERS THEN
1914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1915: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1916: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1917: FND_MSG_PUB.ADD;
1918: FND_MSG_PUB.Count_And_Get(
1919: p_count => x_msg_count,
1920: p_data => x_msg_data);
1921: END;

Line 1918: FND_MSG_PUB.Count_And_Get(

1914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1915: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1916: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1917: FND_MSG_PUB.ADD;
1918: FND_MSG_PUB.Count_And_Get(
1919: p_count => x_msg_count,
1920: p_data => x_msg_data);
1921: END;
1922:

Line 1988: FND_MSG_PUB.Initialize;

1984: SAVEPOINT Delete_IncidentLink_PVT;
1985:
1986: -- Initialize message list if p_init_msg_list is set to TRUE
1987: IF FND_API.To_Boolean(p_init_msg_list) THEN
1988: FND_MSG_PUB.Initialize;
1989: END IF;
1990:
1991: -- Allow this API to be called with both version numbers, 1.2 and 2.0, introduced for bugs 2972584 and 2972611
1992: IF p_api_version = 1.2 THEN

Line 2001: FND_MSG_PUB.Count_And_Get(

1997:
1998: -- Standard call to check for call compatibility, changed so that both versions 1.2 and 2.0 may be allowed
1999: IF NOT FND_API.Compatible_API_Call(l_invoked_version, p_api_version,
2000: l_api_name, G_PKG_NAME) THEN
2001: FND_MSG_PUB.Count_And_Get(
2002: p_count => x_msg_count,
2003: p_data => x_msg_data);
2004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2005: END IF;

Line 2297: FND_MSG_PUB.Count_And_Get(

2293: EXCEPTION
2294: WHEN FND_API.G_EXC_ERROR THEN
2295: ROLLBACK TO SAVEPOINT Delete_IncidentLink_PVT;
2296: x_return_status := FND_API.G_RET_STS_ERROR;
2297: FND_MSG_PUB.Count_And_Get(
2298: p_count => x_msg_count,
2299: p_data => x_msg_data);
2300:
2301: WHEN OTHERS THEN

Line 2306: FND_MSG_PUB.ADD;

2302: ROLLBACK TO SAVEPOINT Delete_IncidentLink_PVT;
2303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2304: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2305: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2306: FND_MSG_PUB.ADD;
2307: FND_MSG_PUB.Count_And_Get(
2308: p_count => x_msg_count,
2309: p_data => x_msg_data);
2310:

Line 2307: FND_MSG_PUB.Count_And_Get(

2303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2304: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2305: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2306: FND_MSG_PUB.ADD;
2307: FND_MSG_PUB.Count_And_Get(
2308: p_count => x_msg_count,
2309: p_data => x_msg_data);
2310:
2311: END DELETE_INCIDENTLINK;

Line 2566: FND_MSG_PUB.Count_And_Get

2562: , L_API_NAME
2563: , G_PKG_NAME
2564: )
2565: THEN
2566: FND_MSG_PUB.Count_And_Get
2567: (
2568: p_count => x_msg_count
2569: , p_data => x_msg_data
2570: );

Line 2576: FND_MSG_PUB.initialize;

2572: END IF ;
2573:
2574: IF FND_API.to_Boolean(p_init_msg_list)
2575: THEN
2576: FND_MSG_PUB.initialize;
2577: END IF ;
2578:
2579: ------------------------------------------------------------------------------
2580: -- Parameter Validations:

Line 2599: FND_MSG_PUB.ADD;

2595: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
2596: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2597: FND_MESSAGE.Set_Token('PARAM', 'p_object_type');
2598: FND_MESSAGE.Set_Token('CURRVAL', p_object_type);
2599: FND_MSG_PUB.ADD;
2600:
2601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2602: END IF;
2603:

Line 2622: FND_MSG_PUB.ADD;

2618: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
2619: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2620: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
2621: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
2622: FND_MSG_PUB.ADD;
2623:
2624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2625: END IF;
2626:

Line 2702: x_msg_count := FND_MSG_PUB.Count_Msg;

2698: , L_LOG_MODULE || 'unexpected_error'
2699: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
2700: );
2701:
2702: x_msg_count := FND_MSG_PUB.Count_Msg;
2703:
2704: IF x_msg_count > 0
2705: THEN
2706: FOR

Line 2709: FND_MSG_PUB.Get

2705: THEN
2706: FOR
2707: i IN 1..x_msg_count
2708: LOOP
2709: FND_MSG_PUB.Get
2710: (
2711: p_msg_index => i
2712: , p_encoded => 'F'
2713: , p_data => x_msg_data

Line 2732: FND_MSG_PUB.ADD;

2728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2729: FND_MESSAGE.Set_Name('CS', 'CS_SR_LNK_DEL_FAIL');
2730: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2731: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
2732: FND_MSG_PUB.ADD;
2733:
2734: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2735: THEN
2736: FND_LOG.String