DBA Data[Home] [Help]

APPS.CS_WF_EVENT_PKG dependencies on FND_MSG_PUB

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

1293: WHEN l_INVALID_EVENT_ARGS THEN
1294: --dbms_output.put_line('Exception : WHEN l_INVALID_EVENT_ARGS ');
1295: --l_param_list.DELETE;
1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1297: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1298: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1299: 'Raise_ServiceRequest_Event' );
1300: END IF;
1301: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 1298: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',

1294: --dbms_output.put_line('Exception : WHEN l_INVALID_EVENT_ARGS ');
1295: --l_param_list.DELETE;
1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1297: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1298: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1299: 'Raise_ServiceRequest_Event' );
1300: END IF;
1301: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1302: p_data => x_msg_data,

Line 1301: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1297: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1298: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1299: 'Raise_ServiceRequest_Event' );
1300: END IF;
1301: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1302: p_data => x_msg_data,
1303: p_encoded => FND_API.G_FALSE );
1304:
1305: WHEN l_INVALID_EVENT_CODE THEN

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

1305: WHEN l_INVALID_EVENT_CODE THEN
1306: --dbms_output.put_line('Exception : WHEN l_INVALID_EVENT_CODE');
1307: --l_param_list.DELETE;
1308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1309: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1310: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1311: 'Raise_ServiceRequest_Event' );
1312: END IF;
1313: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 1310: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',

1306: --dbms_output.put_line('Exception : WHEN l_INVALID_EVENT_CODE');
1307: --l_param_list.DELETE;
1308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1309: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1310: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1311: 'Raise_ServiceRequest_Event' );
1312: END IF;
1313: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1314: p_data => x_msg_data,

Line 1313: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1309: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1310: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1311: 'Raise_ServiceRequest_Event' );
1312: END IF;
1313: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1314: p_data => x_msg_data,
1315: p_encoded => FND_API.G_FALSE );
1316:
1317: WHEN FND_API.G_EXC_ERROR THEN

Line 1324: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1320: IF (l_sel_request_csr%ISOPEN) THEN
1321: CLOSE l_sel_request_csr;
1322: END IF;
1323: x_return_status := FND_API.G_RET_STS_ERROR;
1324: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1325: p_data => x_msg_data,
1326: p_encoded => FND_API.G_FALSE );
1327:
1328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1335: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1331: IF (l_sel_request_csr%ISOPEN) THEN
1332: CLOSE l_sel_request_csr;
1333: END IF;
1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1335: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1336: p_data => x_msg_data,
1337: p_encoded => FND_API.G_FALSE );
1338:
1339: WHEN OTHERS THEN

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

1339: WHEN OTHERS THEN
1340: --dbms_output.put_line('Exception : WHEN OTHERS');
1341: --l_param_list.DELETE;
1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1343: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1344: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1345: 'Raise_ServiceRequest_Event' );
1346: END IF;
1347: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 1344: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',

1340: --dbms_output.put_line('Exception : WHEN OTHERS');
1341: --l_param_list.DELETE;
1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1343: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1344: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1345: 'Raise_ServiceRequest_Event' );
1346: END IF;
1347: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1348: p_data => x_msg_data,

Line 1347: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1343: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1344: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1345: 'Raise_ServiceRequest_Event' );
1346: END IF;
1347: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1348: p_data => x_msg_data,
1349: p_encoded => FND_API.G_FALSE );
1350:
1351: