DBA Data[Home] [Help]

APPS.PV_BENFT_STATUS_CHANGE dependencies on FND_MSG_PUB

Line 88: fnd_msg_pub.initialize;

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,

Line 110: fnd_msg_pub.Add;

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

Line 262: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

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

Line 272: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.error', fnd_msg_pub.get(p_encoded => 'F') );

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,

Line 275: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

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:

Line 284: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.unexpected', fnd_msg_pub.get(p_encoded => 'F') );

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,

Line 287: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

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:

Line 293: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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') );

Line 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,

Line 300: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

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:

Line 497: fnd_msg_pub.initialize;

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,

Line 888: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

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

Line 897: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

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

Line 904: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

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

Line 911: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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:

Line 912: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

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;

Line 1133: fnd_msg_pub.Count_And_Get(p_encoded => FND_API.G_TRUE

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);

Line 1741: fnd_msg_pub.Count_And_Get(p_encoded => FND_API.G_TRUE

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);

Line 1790: fnd_msg_pub.initialize;

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,

Line 1851: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

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

Line 1865: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

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:

Line 1877: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

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:

Line 1883: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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 );

Line 1890: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

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: