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 PV_BENFT_STATUS_CHANGE

Line 1: PACKAGE BODY PV_BENFT_STATUS_CHANGE AS

1: PACKAGE BODY PV_BENFT_STATUS_CHANGE AS
2: /* $Header: pvstchgb.pls 120.7 2006/05/09 16:19:04 saarumug ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_BENFT_STATUS_CHANGE';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvstchgb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_BENFT_STATUS_CHANGE';

1: PACKAGE BODY PV_BENFT_STATUS_CHANGE AS
2: /* $Header: pvstchgb.pls 120.7 2006/05/09 16:19:04 saarumug ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_BENFT_STATUS_CHANGE';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvstchgb.pls';
6:
7: /**
8: * Procedure to convert comma separated user list to a

Line 93: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.start',

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,
93: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.start',
94: 'Benefit id:' || p_benefit_id || '. Entity id: ' || p_entity_id ||
95: '. Status:' || p_status || '. Partner id:' || p_partner_id ||
96: '. Message callback API: ' || p_msg_callback_api || 'User type: ' || nvl(p_user_role,'NULL') ||
97: '. User Callback API: ' || p_user_callback_api);

Line 126: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.info',

122: exit when lc_get_message%notfound;
123:
124: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
125: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
126: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.info',
127: 'Notification Setup: User type:' || l_user_type || '. Message type:' || l_msg_type
128: || '. Message Name:' || l_msg_name);
129: END IF;
130:

Line 143: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.info',

139: if l_role_list is null then
140:
141: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
142: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
143: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.info',
144: 'None found from user callback api. executing system sql');
145: END IF;
146:
147: if l_user_type = 'CHANNEL_MANAGER' then

Line 171: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.info',

167:
168: else
169: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
170: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
171: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.info',
172: 'Possible error. Unrecognized user role:' || l_user_type);
173: END IF;
174: end if;
175: end if;

Line 183: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.info',

179:
180: if l_role_list_tbl.COUNT > 0 then
181: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
182: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
183: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.info',
184: 'user list for ' || l_user_type || ' is:' || l_role_list);
185: END IF;
186:
187: l_itemkey := l_msg_type||'|'||l_user_type||'|'||l_msg_name||'|'||p_entity_id||

Line 192: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.info',

188: '|'||to_char(sysdate,'YYYYMMDDHH24MISS');
189:
190: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
191: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
192: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.info',
193: 'Creating process for itemtype:' || l_benefit_type || '. itemkey: ' || l_itemkey);
194: END IF;
195:
196: wf_engine.CreateProcess ( ItemType => l_BENEFIT_TYPE,

Line 225: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.info',

221: priority => NULL );
222:
223: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
224: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
225: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.info',
226: 'Sent notification to role: ' || l_adhoc_role ||
227: ' Using message: ' || l_msg_name || '. Notify id: ' || l_group_notify_id );
228: END IF;
229:

Line 236: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.info',

232:
233: else
234: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
235: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
236: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.info',
237: 'No users found for user type: ' || l_user_type);
238: END IF;
239: end if;
240:

Line 247: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.info',

243:
244: if not l_has_notification then
245: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
246: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
247: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.info',
248: 'No Notifications has been setup for this benefit');
249: END IF;
250: end if;
251:

Line 258: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.end', 'Exiting' );

254: END IF;
255:
256: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
257: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
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,

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 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 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 398: 'pv.plsql.PV_BENFT_STATUS_CHANGE.CONVERT_LIST_TO_TABLE.unexpected', FALSE );

394: WHEN OTHERS THEN
395:
396: IF( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
397: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
398: 'pv.plsql.PV_BENFT_STATUS_CHANGE.CONVERT_LIST_TO_TABLE.unexpected', FALSE );
399: END IF;
400:
401: END CONVERT_LIST_TO_TABLE;
402:

Line 502: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_LOGGING.start',

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,
502: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_LOGGING.start',
503: 'Benefit id:' || p_benefit_id || '. Entity id: ' || p_entity_id ||
504: '. Status:' || p_status || '. Partner id:' || p_partner_id);
505: end if;
506:

Line 833: ,'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_LOGGING.start'

829: END IF;
830:
831: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
832: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE
833: ,'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_LOGGING.start'
834: ,'Approvers notification Message:'||l_message_name);
835: end if;
836:
837:

Line 850: ,'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_LOGGING.start'

846: l_log_params_tbl(1).param_value := l_approvers.source_name;
847:
848: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
849: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE
850: ,'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_LOGGING.start'
851: ,'Logging notification for:'||l_approvers.source_name);
852: end if;
853:
854: PVX_Utility_PVT.create_history_log(

Line 884: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_LOGGING.end', 'Exiting');

880: END IF;
881:
882: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
883: 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,

Line 976: 'pv.plsql.PV_BENFT_STATUS_CHANGE.CLAIM_REF_STATUS_CHANGE_SUB.start',

972: l_event_name := p_event.getEventName();
973:
974: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
975: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
976: 'pv.plsql.PV_BENFT_STATUS_CHANGE.CLAIM_REF_STATUS_CHANGE_SUB.start',
977: 'Event name: ' || l_event_name || 'Event key: ' || l_entity_id);
978: end if;
979:
980: if l_parameter_list is not null then

Line 1036: 'pv.plsql.PV_BENFT_STATUS_CHANGE.CLAIM_REF_STATUS_CHANGE_SUB',

1032: l_claim_id IS NULL)
1033: THEN
1034: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1035: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1036: 'pv.plsql.PV_BENFT_STATUS_CHANGE.CLAIM_REF_STATUS_CHANGE_SUB',
1037: 'Event name: ' || l_event_name || ' ' ||
1038: '--> There is no claim ID for this event.');
1039: end if;
1040:

Line 1056: 'pv.plsql.PV_BENFT_STATUS_CHANGE.CLAIM_REF_STATUS_CHANGE_SUB',

1052:
1053: IF (l_referral_id IS NULL) THEN
1054: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1055: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1056: 'pv.plsql.PV_BENFT_STATUS_CHANGE.CLAIM_REF_STATUS_CHANGE_SUB',
1057: 'Event name: ' || l_event_name || ' ' ||
1058: 'claim_id : ' || l_claim_id || ' ' ||
1059: '--> There is no corresponding referral for this claim.');
1060: end if;

Line 1077: pv_benft_status_change.status_change_raise(

1073: -- -------------------------------------------------
1074: -- Raise business event
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',

Line 1086: p_msg_callback_api => 'pv_benft_status_change.REFERRAL_SET_MSG_ATTRS',

1082: p_benefit_id => l_benefit_id,
1083: p_entity_id => l_referral_id,
1084: p_status_code => l_referral_status_code,
1085: p_partner_id => l_partner_id,
1086: p_msg_callback_api => 'pv_benft_status_change.REFERRAL_SET_MSG_ATTRS',
1087: p_user_callback_api => 'pv_benft_status_change.REFERRAL_RETURN_USERLIST',
1088: x_return_status => l_return_status,
1089: x_msg_count => l_msg_count,
1090: x_msg_data => l_msg_data);

Line 1087: p_user_callback_api => 'pv_benft_status_change.REFERRAL_RETURN_USERLIST',

1083: p_entity_id => l_referral_id,
1084: p_status_code => l_referral_status_code,
1085: p_partner_id => l_partner_id,
1086: p_msg_callback_api => 'pv_benft_status_change.REFERRAL_SET_MSG_ATTRS',
1087: p_user_callback_api => 'pv_benft_status_change.REFERRAL_RETURN_USERLIST',
1088: x_return_status => l_return_status,
1089: x_msg_count => l_msg_count,
1090: x_msg_data => l_msg_data);
1091:

Line 1120: 'pv.plsql.PV_BENFT_STATUS_CHANGE.CLAIM_REF_STATUS_CHANGE_SUB.end', 'Exiting');

1116: end if;
1117:
1118: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1119: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1120: 'pv.plsql.PV_BENFT_STATUS_CHANGE.CLAIM_REF_STATUS_CHANGE_SUB.end', 'Exiting');
1121: end if;
1122:
1123: RETURN 'SUCCESS';
1124:

Line 1130: 'pv.plsql.PV_BENFT_STATUS_CHANGE.CLAIM_REF_STATUS_CHANGE_SUB.unexpected', FALSE );

1126: WHEN OTHERS THEN
1127:
1128: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
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

Line 1199: 'pv.plsql.PV_BENFT_STATUS_CHANGE.REFERRAL_SET_MSG_ATTRS.start',

1195: BEGIN
1196:
1197: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1198: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1199: 'pv.plsql.PV_BENFT_STATUS_CHANGE.REFERRAL_SET_MSG_ATTRS.start',
1200: 'Item type:' || p_itemtype || 'Item key:' || p_itemkey || '. Entity id: ' ||
1201: p_entity_id || '. Status:' || p_status || '. User type: ' || p_user_type);
1202: end if;
1203:

Line 1444: 'pv.plsql.PV_BENFT_STATUS_CHANGE.REFERRAL_SET_MSG_ATTRS.end', 'Exiting');

1440: avalue => l_notes_varchar);
1441:
1442: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1443: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1444: 'pv.plsql.PV_BENFT_STATUS_CHANGE.REFERRAL_SET_MSG_ATTRS.end', 'Exiting');
1445: end if;
1446:
1447: END;
1448:

Line 1557: 'pv.plsql.PV_BENFT_STATUS_CHANGE.REFERRAL_RETURN_USERLIST.start',

1553:
1554: begin
1555: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1556: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1557: 'pv.plsql.PV_BENFT_STATUS_CHANGE.REFERRAL_RETURN_USERLIST.start',
1558: 'Benefit type:' || p_benefit_type || '. Entity id: ' || p_entity_id ||
1559: '. Status:' || p_status || '. User type: ' || p_user_role);
1560: end if;
1561:

Line 1635: 'pv.plsql.PV_BENFT_STATUS_CHANGE.REFERRAL_RETURN_USERLIST.info',

1631:
1632: else
1633: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1634: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1635: 'pv.plsql.PV_BENFT_STATUS_CHANGE.REFERRAL_RETURN_USERLIST.info',
1636: 'Unrecognized user role:' || p_user_role);
1637: END IF;
1638: end if;
1639:

Line 1642: 'pv.plsql.PV_BENFT_STATUS_CHANGE.REFERRAL_RETURN_USERLIST.end', 'Exiting');

1638: end if;
1639:
1640: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1641: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1642: 'pv.plsql.PV_BENFT_STATUS_CHANGE.REFERRAL_RETURN_USERLIST.end', 'Exiting');
1643: end if;
1644:
1645: return l_role_list;
1646: end;

Line 1681: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_SUB.start',

1677: l_event_name := p_event.getEventName();
1678:
1679: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1680: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1681: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_SUB.start',
1682: 'Event name: ' || l_event_name || 'Event key: ' || l_entity_id);
1683: end if;
1684:
1685: if l_parameter_list is not null then

Line 1707: pv_benft_status_change.STATUS_CHANGE_notification(

1703:
1704: i := l_parameter_list.next(i);
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,

Line 1728: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_SUB.end', 'Exiting');

1724: end if;
1725:
1726: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1727: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1728: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_SUB.end', 'Exiting');
1729: end if;
1730:
1731: RETURN 'SUCCESS';
1732:

Line 1738: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_SUB.unexpected', FALSE );

1734: WHEN OTHERS THEN
1735:
1736: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
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

Line 1795: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_RAISE.begin',

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,
1795: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_RAISE.begin',
1796: 'Event:' || p_event_name || '. Benefit id:' || p_benefit_id ||
1797: '. Status code:' || p_status_code || '. Partner id:' || p_partner_id ||
1798: '. Message callback API: ' || p_msg_callback_api ||
1799: '. User Callback API: ' || p_user_callback_api);

Line 1832: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_RAISE.raiseEvent', 'Calling pvx_event_pkg.raise_event' );

1828: l_parameter_list(5) := l_parameter_t;
1829:
1830: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1831: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1832: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_RAISE.raiseEvent', 'Calling pvx_event_pkg.raise_event' );
1833: end if;
1834:
1835: pvx_event_pkg.raise_event(
1836: p_event_name => p_event_name,

Line 1847: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_RAISE.end', 'Exiting' );

1843: END IF;
1844:
1845: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1846: 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,

Line 1862: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_RAISE.error', FALSE );

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 );
1863: end if;
1864:
1865: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1866: p_count => x_msg_count,

Line 1874: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_RAISE.unexpected', FALSE );

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 );
1875: end if;
1876:
1877: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1878: p_count => x_msg_count,

Line 1887: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_RAISE.unexpected', FALSE );

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 );
1888: end if;
1889:
1890: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1891: p_count => x_msg_count,

Line 1912: 'pv.plsql.PV_BENFT_STATUS_CHANGE.GET_DECLINE_REASON.begin',

1908:
1909: BEGIN
1910: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1911: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1912: 'pv.plsql.PV_BENFT_STATUS_CHANGE.GET_DECLINE_REASON.begin',
1913: 'Document_id:' || document_id || '. display_type:' || display_type);
1914: end if;
1915:
1916: if display_type in ('text/plain', 'text/html') then

Line 1924: 'pv.plsql.PV_BENFT_STATUS_CHANGE.GET_DECLINE_REASON.info', 'Reason: ' || l_translated_reason );

1920: close lc_get_reason;
1921:
1922: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1923: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1924: 'pv.plsql.PV_BENFT_STATUS_CHANGE.GET_DECLINE_REASON.info', 'Reason: ' || l_translated_reason );
1925: end if;
1926:
1927: document := l_translated_reason;
1928: end if;

Line 1932: 'pv.plsql.PV_BENFT_STATUS_CHANGE.GET_DECLINE_REASON.end', 'Exiting');

1928: end if;
1929:
1930: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1931: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1932: 'pv.plsql.PV_BENFT_STATUS_CHANGE.GET_DECLINE_REASON.end', 'Exiting');
1933: end if;
1934: END;
1935:
1936: procedure GET_PRODUCTS (document_id in varchar2,

Line 1974: 'pv.plsql.PV_BENFT_STATUS_CHANGE.GET_PRODUCTS.begin',

1970:
1971: BEGIN
1972: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1973: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1974: 'pv.plsql.PV_BENFT_STATUS_CHANGE.GET_PRODUCTS.begin',
1975: 'Document_id:' || document_id || '. display_type:' || display_type);
1976: end if;
1977:
1978: l_entity_id := substr(document_id, 1, instr(document_id, ':')-1);

Line 2004: 'pv.plsql.PV_BENFT_STATUS_CHANGE.GET_PRODUCTS.info', 'Product: ' || l_prod_rec.CONCAT_CAT_PARENTAGE );

2000: loop
2001: l_has_products := true;
2002: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2003: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2004: 'pv.plsql.PV_BENFT_STATUS_CHANGE.GET_PRODUCTS.info', 'Product: ' || l_prod_rec.CONCAT_CAT_PARENTAGE );
2005: end if;
2006: if display_type = 'text/html' then
2007:
2008: l_products_list := l_products_list || '' || l_prod_rec.concat_cat_parentage ||

Line 2031: 'pv.plsql.PV_BENFT_STATUS_CHANGE.GET_PRODUCTS.end', 'Exiting');

2027: document := l_products_list;
2028:
2029: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2030: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2031: 'pv.plsql.PV_BENFT_STATUS_CHANGE.GET_PRODUCTS.end', 'Exiting');
2032: end if;
2033: END;
2034:
2035: END;