DBA Data[Home] [Help]

APPS.CS_INCIDENTLINKS_PVT dependencies on FND_MESSAGE

Line 134: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');

130:
131: EXCEPTION
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,

Line 135: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);

131: EXCEPTION
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);

Line 364: FND_MESSAGE.Set_Name('CS', 'CS_SR_SAME_SUBJECT_OBJECT');

360: -- Check if subject and object are the same.
361: IF ((p_link_rec.subject_id = p_link_rec.object_id) AND
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(

Line 365: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

361: IF ((p_link_rec.subject_id = p_link_rec.object_id) AND
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,

Line 1146: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');

1142:
1143: WHEN OTHERS THEN
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,

Line 1147: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);

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

Line 1266: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');

1262:
1263: EXCEPTION
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,

Line 1267: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);

1263: EXCEPTION
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);

Line 1396: FND_MESSAGE.Set_Name('CS', 'CS_INVALID_INCIDENT_LINK_ID');

1392: -- record does not exist or has been modified by other users.
1393: -- Raise error only if the external link ID that has been passed is NULL (i.e. has not been passed for update)
1394: if (p_link_rec.link_id_ext IS NULL) then -- For bugs 2972584 and 2972611
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(

Line 1397: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

1393: -- Raise error only if the external link ID that has been passed is NULL (i.e. has not been passed for update)
1394: if (p_link_rec.link_id_ext IS NULL) then -- For bugs 2972584 and 2972611
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,

Line 1398: FND_MESSAGE.Set_Token('LINK_ID', to_char(p_link_id));

1394: if (p_link_rec.link_id_ext IS NULL) then -- For bugs 2972584 and 2972611
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 );

Line 1407: FND_MESSAGE.Set_Name('CS', 'CS_RECORD_HAS_BEEN_UPDATED');

1403: RAISE FND_API.G_EXC_ERROR;
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 );

Line 1864: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');

1860:
1861: WHEN OTHERS THEN
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,

Line 1865: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);

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

Line 1915: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');

1911:
1912: EXCEPTION
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,

Line 1916: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);

1912: EXCEPTION
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);

Line 2304: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');

2300:
2301: WHEN OTHERS THEN
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,

Line 2305: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);

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

Line 2595: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');

2591: , 'p_object_type has to be SR.'
2592: );
2593: END IF ;
2594:
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;

Line 2596: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);

2592: );
2593: END IF ;
2594:
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:

Line 2597: FND_MESSAGE.Set_Token('PARAM', 'p_object_type');

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

Line 2598: FND_MESSAGE.Set_Token('CURRVAL', p_object_type);

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

Line 2618: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');

2614: , 'p_processing_set_id should not be NULL.'
2615: );
2616: END IF ;
2617:
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;

Line 2619: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);

2615: );
2616: END IF ;
2617:
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:

Line 2620: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');

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

Line 2621: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));

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

Line 2729: FND_MESSAGE.Set_Name('CS', 'CS_SR_LNK_DEL_FAIL');

2725: END IF ;
2726:
2727: WHEN OTHERS THEN
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:

Line 2730: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);

2726:
2727: WHEN OTHERS THEN
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

Line 2731: FND_MESSAGE.Set_Token('ERROR', SQLERRM);

2727: WHEN OTHERS THEN
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