eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_BENFT_STATUS_CHANGE dependencies on FND_API

Line 17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

13:
14:
15: PROCEDURE STATUS_CHANGE_notification(
16: p_api_version_number IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: P_BENEFIT_ID IN NUMBER,
21: P_STATUS IN VARCHAR2,

Line 18: p_commit IN VARCHAR2 := FND_API.G_FALSE,

14:
15: PROCEDURE STATUS_CHANGE_notification(
16: p_api_version_number IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: P_BENEFIT_ID IN NUMBER,
21: P_STATUS IN VARCHAR2,
22: P_ENTITY_ID IN NUMBER,

Line 19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

15: PROCEDURE STATUS_CHANGE_notification(
16: p_api_version_number IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: P_BENEFIT_ID IN NUMBER,
21: P_STATUS IN VARCHAR2,
22: P_ENTITY_ID IN NUMBER,
23: P_PARTNER_ID IN NUMBER,

Line 77: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

73:
74: BEGIN
75: -- Standard call to check for call compatibility.
76:
77: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
78: p_api_version_number,
79: l_api_name,
80: G_PKG_NAME) THEN
81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

77: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
78: p_api_version_number,
79: l_api_name,
80: G_PKG_NAME) THEN
81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
82:
83: END IF;
84:
85: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 86: IF FND_API.to_Boolean( p_init_msg_list )

82:
83: END IF;
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:

Line 101: x_return_status := FND_API.G_RET_STS_SUCCESS;

97: '. User Callback API: ' || p_user_callback_api);
98: end if;
99:
100: -- Initialize API return status to success
101: x_return_status := FND_API.G_RET_STS_SUCCESS;
102:
103: open lc_get_benefit_type(pc_benefit_id => p_benefit_id);
104: fetch lc_get_benefit_type into l_benefit_type;
105: close lc_get_benefit_type;

Line 111: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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
115: open lc_get_message(pc_benefit_id => p_benefit_id, pc_status => p_status, pc_userrole => '%');

Line 252: IF FND_API.To_Boolean ( p_commit ) THEN

248: 'No Notifications has been setup for this benefit');
249: END IF;
250: end if;
251:
252: IF FND_API.To_Boolean ( p_commit ) THEN
253: COMMIT WORK;
254: END IF;
255:
256: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) 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 266: WHEN FND_API.G_EXC_ERROR THEN

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
267:
268: x_return_status := FND_API.G_RET_STS_ERROR ;
269:
270: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 268: x_return_status := FND_API.G_RET_STS_ERROR ;

264: p_data => x_msg_data);
265: EXCEPTION
266: WHEN FND_API.G_EXC_ERROR THEN
267:
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') );

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 278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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 292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

288: p_count => x_msg_count,
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,

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 420: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

416: --| |
417: --==============================================================================
418: PROCEDURE STATUS_CHANGE_LOGGING(
419: p_api_version_number IN NUMBER,
420: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
421: p_commit IN VARCHAR2 := FND_API.G_FALSE,
422: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
423: P_BENEFIT_ID IN NUMBER,
424: P_STATUS IN VARCHAR2,

Line 421: p_commit IN VARCHAR2 := FND_API.G_FALSE,

417: --==============================================================================
418: PROCEDURE STATUS_CHANGE_LOGGING(
419: p_api_version_number IN NUMBER,
420: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
421: p_commit IN VARCHAR2 := FND_API.G_FALSE,
422: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
423: P_BENEFIT_ID IN NUMBER,
424: P_STATUS IN VARCHAR2,
425: P_ENTITY_ID IN NUMBER,

Line 422: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

418: PROCEDURE STATUS_CHANGE_LOGGING(
419: p_api_version_number IN NUMBER,
420: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
421: p_commit IN VARCHAR2 := FND_API.G_FALSE,
422: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
423: P_BENEFIT_ID IN NUMBER,
424: P_STATUS IN VARCHAR2,
425: P_ENTITY_ID IN NUMBER,
426: P_PARTNER_ID IN NUMBER,

Line 486: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

482:
483: BEGIN
484: -- Standard call to check for call compatibility.
485:
486: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
487: p_api_version_number,
488: l_api_name,
489: G_PKG_NAME) THEN
490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

486: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
487: p_api_version_number,
488: l_api_name,
489: G_PKG_NAME) THEN
490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
491:
492: END IF;
493:
494: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 495: IF FND_API.to_Boolean( p_init_msg_list )

491:
492: END IF;
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:

Line 508: x_return_status := FND_API.G_RET_STS_SUCCESS;

504: '. Status:' || p_status || '. Partner id:' || p_partner_id);
505: end if;
506:
507: -- Initialize API return status to success
508: x_return_status := FND_API.G_RET_STS_SUCCESS;
509:
510: open lc_get_entity_detail (pc_entity_id => p_entity_id);
511: fetch lc_get_entity_detail into l_referral_code, l_benefit_type, l_entity_type,
512: l_linked_to, l_decline_code, l_order_id;

Line 812: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

808: x_return_status => x_return_status,
809: x_msg_count => x_msg_count,
810: x_msg_data => x_msg_data);
811:
812: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
813: raise FND_API.G_EXC_ERROR;
814: end if;
815:
816: end if;

Line 813: raise FND_API.G_EXC_ERROR;

809: x_msg_count => x_msg_count,
810: x_msg_data => x_msg_data);
811:
812: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
813: raise FND_API.G_EXC_ERROR;
814: end if;
815:
816: end if;
817:

Line 872: --if x_return_status <> FND_API.G_RET_STS_SUCCESS then

868: END IF;
869:
870: END LOOP;
871:
872: --if x_return_status <> FND_API.G_RET_STS_SUCCESS then
873: -- raise FND_API.G_EXC_ERROR;
874: --end if;
875:
876: end if;

Line 873: -- raise FND_API.G_EXC_ERROR;

869:
870: END LOOP;
871:
872: --if x_return_status <> FND_API.G_RET_STS_SUCCESS then
873: -- raise FND_API.G_EXC_ERROR;
874: --end if;
875:
876: end if;
877:

Line 878: IF FND_API.To_Boolean ( p_commit ) THEN

874: --end if;
875:
876: end if;
877:
878: IF FND_API.To_Boolean ( p_commit ) THEN
879: COMMIT WORK;
880: END IF;
881:
882: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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 894: WHEN FND_API.G_EXC_ERROR THEN

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,

Line 896: x_return_status := FND_API.G_RET_STS_ERROR ;

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:

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 901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

899: p_data => x_msg_data);
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:

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 910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

906: p_data => x_msg_data);
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);

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 1079: p_init_msg_list => FND_API.G_FALSE,

1075: -- oracle.apps.pv.benefit.referral.statusChange
1076: -- -------------------------------------------------
1077: pv_benft_status_change.status_change_raise(
1078: p_api_version_number => 1.0,
1079: p_init_msg_list => FND_API.G_FALSE,
1080: p_commit => FND_API.G_FALSE,
1081: p_event_name => 'oracle.apps.pv.benefit.referral.statusChange',
1082: p_benefit_id => l_benefit_id,
1083: p_entity_id => l_referral_id,

Line 1080: p_commit => FND_API.G_FALSE,

1076: -- -------------------------------------------------
1077: pv_benft_status_change.status_change_raise(
1078: p_api_version_number => 1.0,
1079: p_init_msg_list => FND_API.G_FALSE,
1080: p_commit => FND_API.G_FALSE,
1081: p_event_name => 'oracle.apps.pv.benefit.referral.statusChange',
1082: p_benefit_id => l_benefit_id,
1083: p_entity_id => l_referral_id,
1084: p_status_code => l_referral_status_code,

Line 1092: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

1088: x_return_status => l_return_status,
1089: x_msg_count => l_msg_count,
1090: x_msg_data => l_msg_data);
1091:
1092: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1093: raise FND_API.G_EXC_ERROR;
1094: end if;
1095:
1096: -- -------------------------------------------------

Line 1093: raise FND_API.G_EXC_ERROR;

1089: x_msg_count => l_msg_count,
1090: x_msg_data => l_msg_data);
1091:
1092: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1093: raise FND_API.G_EXC_ERROR;
1094: end if;
1095:
1096: -- -------------------------------------------------
1097: -- Log the event.

Line 1101: p_init_msg_list => FND_API.G_FALSE,

1097: -- Log the event.
1098: -- -------------------------------------------------
1099: STATUS_CHANGE_LOGGING(
1100: p_api_version_number => 1.0,
1101: p_init_msg_list => FND_API.G_FALSE,
1102: p_commit => FND_API.G_FALSE,
1103: p_benefit_id => l_benefit_id,
1104: P_STATUS => l_referral_status_code,
1105: p_entity_id => l_referral_id,

Line 1102: p_commit => FND_API.G_FALSE,

1098: -- -------------------------------------------------
1099: STATUS_CHANGE_LOGGING(
1100: p_api_version_number => 1.0,
1101: p_init_msg_list => FND_API.G_FALSE,
1102: p_commit => FND_API.G_FALSE,
1103: p_benefit_id => l_benefit_id,
1104: P_STATUS => l_referral_status_code,
1105: p_entity_id => l_referral_id,
1106: p_partner_id => l_partner_id,

Line 1112: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

1108: x_msg_count => l_msg_count,
1109: x_msg_data => l_msg_data
1110: );
1111:
1112: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1113: raise FND_API.G_EXC_ERROR;
1114: end if;
1115:
1116: end if;

Line 1113: raise FND_API.G_EXC_ERROR;

1109: x_msg_data => l_msg_data
1110: );
1111:
1112: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1113: raise FND_API.G_EXC_ERROR;
1114: end if;
1115:
1116: end if;
1117:

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 1709: p_init_msg_list => fnd_api.G_FALSE,

1705: end loop;
1706:
1707: pv_benft_status_change.STATUS_CHANGE_notification(
1708: p_api_version_number => 1.0,
1709: p_init_msg_list => fnd_api.G_FALSE,
1710: P_BENEFIT_ID => l_benefit_id,
1711: P_STATUS => l_status,
1712: P_ENTITY_ID => l_entity_id,
1713: P_PARTNER_ID => l_partner_id,

Line 1720: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1716: x_return_status => l_return_status,
1717: x_msg_count => l_msg_count,
1718: x_msg_data => l_msg_data);
1719:
1720: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1721: raise FND_API.G_EXC_ERROR;
1722: end if;
1723:
1724: end if;

Line 1721: raise FND_API.G_EXC_ERROR;

1717: x_msg_count => l_msg_count,
1718: x_msg_data => l_msg_data);
1719:
1720: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1721: raise FND_API.G_EXC_ERROR;
1722: end if;
1723:
1724: end if;
1725:

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 1752: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1748: END;
1749:
1750: PROCEDURE STATUS_CHANGE_RAISE(
1751: p_api_version_number IN NUMBER,
1752: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1753: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1754: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1755: p_event_name IN VARCHAR2,
1756: p_benefit_id IN NUMBER,

Line 1753: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1749:
1750: PROCEDURE STATUS_CHANGE_RAISE(
1751: p_api_version_number IN NUMBER,
1752: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1753: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1754: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1755: p_event_name IN VARCHAR2,
1756: p_benefit_id IN NUMBER,
1757: p_entity_id IN NUMBER,

Line 1754: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1750: PROCEDURE STATUS_CHANGE_RAISE(
1751: p_api_version_number IN NUMBER,
1752: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1753: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1754: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1755: p_event_name IN VARCHAR2,
1756: p_benefit_id IN NUMBER,
1757: p_entity_id IN NUMBER,
1758: p_status_code IN VARCHAR2,

Line 1779: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1775:
1776: BEGIN
1777: -- Standard call to check for call compatibility.
1778:
1779: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1780: p_api_version_number,
1781: l_api_name,
1782: G_PKG_NAME) THEN
1783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1779: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1780: p_api_version_number,
1781: l_api_name,
1782: G_PKG_NAME) THEN
1783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1784:
1785: END IF;
1786:
1787: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1788: IF FND_API.to_Boolean( p_init_msg_list )

1784:
1785: END IF;
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:

Line 1803: x_return_status := FND_API.G_RET_STS_SUCCESS;

1799: '. User Callback API: ' || p_user_callback_api);
1800: end if;
1801:
1802: -- Initialize API return status to success
1803: x_return_status := FND_API.G_RET_STS_SUCCESS;
1804:
1805: l_parameter_t.setName('BENEFIT_ID');
1806: l_parameter_t.setValue(p_benefit_id);
1807: l_parameter_list.extend;

Line 1841: IF FND_API.To_Boolean ( p_commit ) THEN

1837: p_event_key => p_entity_id,
1838: p_data => null,
1839: p_parameters => l_parameter_list);
1840:
1841: IF FND_API.To_Boolean ( p_commit ) THEN
1842: COMMIT WORK;
1843: END IF;
1844:
1845: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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 1856: WHEN FND_API.G_EXC_ERROR THEN

1852: p_count => x_msg_count,
1853: p_data => x_msg_data);
1854:
1855: EXCEPTION
1856: WHEN FND_API.G_EXC_ERROR THEN
1857:
1858: x_return_status := FND_API.G_RET_STS_ERROR ;
1859:
1860: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 1858: x_return_status := FND_API.G_RET_STS_ERROR ;

1854:
1855: EXCEPTION
1856: WHEN FND_API.G_EXC_ERROR THEN
1857:
1858: x_return_status := FND_API.G_RET_STS_ERROR ;
1859:
1860: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1861: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
1862: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_RAISE.error', FALSE );

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 1868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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:
1870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1871:
1872: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 1870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1866: p_count => x_msg_count,
1867: p_data => x_msg_data);
1868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1869:
1870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1871:
1872: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1873: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
1874: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_RAISE.unexpected', FALSE );

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 1882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1878: p_count => x_msg_count,
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,

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: