84:
85: -- Initialize message list if p_init_msg_list is set to TRUE.
86: IF FND_API.to_Boolean( p_init_msg_list )
87: THEN
88: fnd_msg_pub.initialize;
89: END IF;
90:
91: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
92: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
106:
107: IF l_benefit_type is null then
108: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
109: fnd_message.Set_Token('TEXT', 'Benefit does not exist. Benefit id: ' || p_benefit_id);
110: fnd_msg_pub.Add;
111: raise FND_API.G_EXC_UNEXPECTED_ERROR;
112: end if;
113:
114: if p_user_role is null then
258: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.end', 'Exiting' );
259: end if;
260:
261: -- Standard call to get message count and if count is 1, get message info.
262: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
263: p_count => x_msg_count,
264: p_data => x_msg_data);
265: EXCEPTION
266: WHEN FND_API.G_EXC_ERROR THEN
268: x_return_status := FND_API.G_RET_STS_ERROR ;
269:
270: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
271: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
272: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.error', fnd_msg_pub.get(p_encoded => 'F') );
273: end if;
274:
275: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
276: p_count => x_msg_count,
271: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
272: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.error', fnd_msg_pub.get(p_encoded => 'F') );
273: end if;
274:
275: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
276: p_count => x_msg_count,
277: p_data => x_msg_data);
278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279:
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
281:
282: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
283: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
284: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.unexpected', fnd_msg_pub.get(p_encoded => 'F') );
285: end if;
286:
287: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
288: p_count => x_msg_count,
283: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
284: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.unexpected', fnd_msg_pub.get(p_encoded => 'F') );
285: end if;
286:
287: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
288: p_count => x_msg_count,
289: p_data => x_msg_data);
290: WHEN OTHERS THEN
291:
289: p_data => x_msg_data);
290: WHEN OTHERS THEN
291:
292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
293: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
294:
295: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
296: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
297: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.unexpected', fnd_msg_pub.get(p_encoded => 'F') );
293: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
294:
295: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
296: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
297: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.unexpected', fnd_msg_pub.get(p_encoded => 'F') );
298: end if;
299:
300: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
301: p_count => x_msg_count,
296: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
297: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.unexpected', fnd_msg_pub.get(p_encoded => 'F') );
298: end if;
299:
300: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
301: p_count => x_msg_count,
302: p_data => x_msg_data);
303: END;
304:
493:
494: -- Initialize message list if p_init_msg_list is set to TRUE.
495: IF FND_API.to_Boolean( p_init_msg_list )
496: THEN
497: fnd_msg_pub.initialize;
498: END IF;
499:
500: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
501: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
884: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_LOGGING.end', 'Exiting');
885: end if;
886:
887: -- Standard call to get message count and if count is 1, get message info.
888: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
889: p_count => x_msg_count,
890: p_data => x_msg_data);
891:
892: EXCEPTION
893:
894: WHEN FND_API.G_EXC_ERROR THEN
895:
896: x_return_status := FND_API.G_RET_STS_ERROR ;
897: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
898: p_count => x_msg_count,
899: p_data => x_msg_data);
900:
901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
900:
901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
902:
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
904: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
905: p_count => x_msg_count,
906: p_data => x_msg_data);
907:
908: WHEN OTHERS THEN
907:
908: WHEN OTHERS THEN
909:
910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
912: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
913: p_count => x_msg_count,
914: p_data => x_msg_data);
915:
908: WHEN OTHERS THEN
909:
910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
912: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
913: p_count => x_msg_count,
914: p_data => x_msg_data);
915:
916: END;
1129: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
1130: 'pv.plsql.PV_BENFT_STATUS_CHANGE.CLAIM_REF_STATUS_CHANGE_SUB.unexpected', FALSE );
1131: end if;
1132:
1133: fnd_msg_pub.Count_And_Get(p_encoded => FND_API.G_TRUE
1134: ,p_count => l_msg_count
1135: ,p_data => l_msg_data);
1136:
1137: WF_CORE.CONTEXT(G_PKG_NAME, L_API_NAME, P_EVENT.GETEVENTNAME(), P_SUBSCRIPTION_GUID);
1737: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
1738: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_SUB.unexpected', FALSE );
1739: end if;
1740:
1741: fnd_msg_pub.Count_And_Get(p_encoded => FND_API.G_TRUE
1742: ,p_count => l_msg_count
1743: ,p_data => l_msg_data);
1744:
1745: WF_CORE.CONTEXT(G_PKG_NAME, L_API_NAME, P_EVENT.GETEVENTNAME(), P_SUBSCRIPTION_GUID);
1786:
1787: -- Initialize message list if p_init_msg_list is set to TRUE.
1788: IF FND_API.to_Boolean( p_init_msg_list )
1789: THEN
1790: fnd_msg_pub.initialize;
1791: END IF;
1792:
1793: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1794: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1847: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_RAISE.end', 'Exiting' );
1848: end if;
1849:
1850: -- Standard call to get message count and if count is 1, get message info.
1851: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1852: p_count => x_msg_count,
1853: p_data => x_msg_data);
1854:
1855: EXCEPTION
1861: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
1862: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_RAISE.error', FALSE );
1863: end if;
1864:
1865: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1866: p_count => x_msg_count,
1867: p_data => x_msg_data);
1868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1869:
1873: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
1874: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_RAISE.unexpected', FALSE );
1875: end if;
1876:
1877: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1878: p_count => x_msg_count,
1879: p_data => x_msg_data);
1880: WHEN OTHERS THEN
1881:
1879: p_data => x_msg_data);
1880: WHEN OTHERS THEN
1881:
1882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1883: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1884:
1885: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1886: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
1887: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_RAISE.unexpected', FALSE );
1886: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
1887: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_RAISE.unexpected', FALSE );
1888: end if;
1889:
1890: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1891: p_count => x_msg_count,
1892: p_data => x_msg_data);
1893: END;
1894: