DBA Data[Home] [Help]

APPS.CS_WF_EVENT_PKG dependencies on FND_MSG_PUB

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

1647: WHEN l_INVALID_EVENT_ARGS THEN
1648: --dbms_output.put_line('Exception : WHEN l_INVALID_EVENT_ARGS ');
1649: --l_param_list.DELETE;
1650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1651: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1652: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1653: 'Raise_ServiceRequest_Event' );
1654: END IF;
1655: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 1652: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',

1648: --dbms_output.put_line('Exception : WHEN l_INVALID_EVENT_ARGS ');
1649: --l_param_list.DELETE;
1650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1651: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1652: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1653: 'Raise_ServiceRequest_Event' );
1654: END IF;
1655: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1656: p_data => x_msg_data,

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

1651: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1652: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1653: 'Raise_ServiceRequest_Event' );
1654: END IF;
1655: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1656: p_data => x_msg_data,
1657: p_encoded => FND_API.G_FALSE );
1658:
1659: WHEN l_INVALID_EVENT_CODE THEN

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

1659: WHEN l_INVALID_EVENT_CODE THEN
1660: --dbms_output.put_line('Exception : WHEN l_INVALID_EVENT_CODE');
1661: --l_param_list.DELETE;
1662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1663: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1664: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1665: 'Raise_ServiceRequest_Event' );
1666: END IF;
1667: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 1664: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',

1660: --dbms_output.put_line('Exception : WHEN l_INVALID_EVENT_CODE');
1661: --l_param_list.DELETE;
1662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1663: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1664: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1665: 'Raise_ServiceRequest_Event' );
1666: END IF;
1667: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1668: p_data => x_msg_data,

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

1663: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1664: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1665: 'Raise_ServiceRequest_Event' );
1666: END IF;
1667: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1668: p_data => x_msg_data,
1669: p_encoded => FND_API.G_FALSE );
1670:
1671: WHEN FND_API.G_EXC_ERROR THEN

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

1674: IF (l_sel_request_csr%ISOPEN) THEN
1675: CLOSE l_sel_request_csr;
1676: END IF;
1677: x_return_status := FND_API.G_RET_STS_ERROR;
1678: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1679: p_data => x_msg_data,
1680: p_encoded => FND_API.G_FALSE );
1681:
1682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1685: IF (l_sel_request_csr%ISOPEN) THEN
1686: CLOSE l_sel_request_csr;
1687: END IF;
1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1689: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1690: p_data => x_msg_data,
1691: p_encoded => FND_API.G_FALSE );
1692:
1693: WHEN OTHERS THEN

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

1693: WHEN OTHERS THEN
1694: --dbms_output.put_line('Exception : WHEN OTHERS');
1695: --l_param_list.DELETE;
1696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1697: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1698: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1699: 'Raise_ServiceRequest_Event' );
1700: END IF;
1701: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 1698: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',

1694: --dbms_output.put_line('Exception : WHEN OTHERS');
1695: --l_param_list.DELETE;
1696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1697: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1698: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1699: 'Raise_ServiceRequest_Event' );
1700: END IF;
1701: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1702: p_data => x_msg_data,

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

1697: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1698: FND_MSG_PUB.Add_Exc_Msg( 'CS_WF_EVENT_PKG',
1699: 'Raise_ServiceRequest_Event' );
1700: END IF;
1701: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1702: p_data => x_msg_data,
1703: p_encoded => FND_API.G_FALSE );
1704:
1705: