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_LOG

Line 91: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 92: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

Line 124: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

120: loop
121: fetch lc_get_message into l_user_type, l_msg_type, l_msg_name;
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);

Line 125: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

121: fetch lc_get_message into l_user_type, l_msg_type, l_msg_name;
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;

Line 141: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

137: into l_role_list using l_benefit_type, p_entity_id, l_user_type, p_status ;
138:
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;

Line 142: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

138:
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:

Line 169: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

165: end loop;
166: l_role_list := substr(l_role_list,2);
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;

Line 170: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

166: l_role_list := substr(l_role_list,2);
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;

Line 181: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

177: CONVERT_LIST_TO_TABLE(p_role_list => l_role_list,
178: x_role_list_tbl => l_role_list_tbl);
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;

Line 182: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

178: x_role_list_tbl => l_role_list_tbl);
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:

Line 190: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

186:
187: l_itemkey := l_msg_type||'|'||l_user_type||'|'||l_msg_name||'|'||p_entity_id||
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;

Line 191: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

187: l_itemkey := l_msg_type||'|'||l_user_type||'|'||l_msg_name||'|'||p_entity_id||
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:

Line 223: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

219: context => l_context,
220: send_comment => NULL,
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 );

Line 224: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

220: send_comment => NULL,
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;

Line 234: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

230: wf_engine.StartProcess(itemtype => l_benefit_type,
231: itemkey => l_itemkey);
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;

Line 235: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

231: itemkey => l_itemkey);
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;

Line 245: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

241: end loop;
242: close lc_get_message;
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;

Line 246: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

242: close lc_get_message;
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;

Line 256: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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
257: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
258: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_NOTIFICATION.end', 'Exiting' );
259: end if;
260:

Line 257: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

253: COMMIT WORK;
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.

Line 270: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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') );
273: end if;
274:

Line 271: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

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') );
273: end if;
274:
275: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

Line 282: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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:

Line 283: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

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,

Line 295: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) 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') );
298: end if;
299:

Line 296: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

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') );
298: end if;
299:
300: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

Line 331: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

327: l_from_position NUMBER := 1;
328: l_temp VARCHAR2(100);
329: BEGIN
330:
331: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
332: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
333: 'pv.plsql.CONVERT_LIST_TO_TABLE.GET_PRODUCTS.begin',
334: 'p_role_list '||p_role_list);
335: END IF;

Line 332: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

328: l_temp VARCHAR2(100);
329: BEGIN
330:
331: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
332: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
333: 'pv.plsql.CONVERT_LIST_TO_TABLE.GET_PRODUCTS.begin',
334: 'p_role_list '||p_role_list);
335: END IF;
336:

Line 353: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

349: ELSIF(l_from_position > 1 and l_to_position <> 0 ) THEN
350: l_temp := substr(p_role_list,l_from_position+1,l_to_position-l_from_position-1);
351: END IF;
352:
353: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
354: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
355: 'pv.plsql.CONVERT_LIST_TO_TABLE.GET_PRODUCTS.begin',
356: 'Next User===>'||l_temp);
357: END IF;

Line 354: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

350: l_temp := substr(p_role_list,l_from_position+1,l_to_position-l_from_position-1);
351: END IF;
352:
353: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
354: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
355: 'pv.plsql.CONVERT_LIST_TO_TABLE.GET_PRODUCTS.begin',
356: 'Next User===>'||l_temp);
357: END IF;
358:

Line 372: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

368: x_role_list_tbl(l_index) := l_temp;
369:
370: ELSE
371:
372: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
373: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
374: 'pv.plsql.CONVERT_LIST_TO_TABLE.GET_PRODUCTS.begin',
375: 'There were no Commas so only one user...');
376: END IF;

Line 373: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

369:
370: ELSE
371:
372: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
373: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
374: 'pv.plsql.CONVERT_LIST_TO_TABLE.GET_PRODUCTS.begin',
375: 'There were no Commas so only one user...');
376: END IF;
377:

Line 386: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

382: END IF;
383:
384: FOR i IN 1..x_role_list_tbl.COUNT
385: LOOP
386: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
387: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
388: 'pv.plsql.CONVERT_LIST_TO_TABLE.GET_PRODUCTS.begin',
389: 'USER ['||x_role_list_tbl(i)||']');
390: END IF;

Line 387: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

383:
384: FOR i IN 1..x_role_list_tbl.COUNT
385: LOOP
386: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
387: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
388: 'pv.plsql.CONVERT_LIST_TO_TABLE.GET_PRODUCTS.begin',
389: 'USER ['||x_role_list_tbl(i)||']');
390: END IF;
391: END LOOP;

Line 396: IF( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

392:
393: EXCEPTION
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:

Line 397: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

393: EXCEPTION
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;

Line 500: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 501: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

Line 831: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

827: ELSIF l_benefit_type = 'PVDQMAPR' then
828: l_message_name := 'PV_LG_DQM_REQR_DEDUP_BY_USER';
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;

Line 832: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE

828: l_message_name := 'PV_LG_DQM_REQR_DEDUP_BY_USER';
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:

Line 848: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

844: l_log_params_tbl.DELETE;
845: l_log_params_tbl(1).param_name := 'APPROVER';
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;

Line 849: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE

845: l_log_params_tbl(1).param_name := 'APPROVER';
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:

Line 882: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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
883: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
884: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_LOGGING.end', 'Exiting');
885: end if;
886:

Line 883: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

879: COMMIT WORK;
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.

Line 974: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

970: l_parameter_list := p_event.getParameterList();
971: l_entity_id := p_event.getEventKey();
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;

Line 975: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

971: l_entity_id := p_event.getEventKey();
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:

Line 1034: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1030:
1031: IF (LOWER(l_event_name) = 'oracle.apps.ozf.claim.updatestatus' AND
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.');

Line 1035: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1031: IF (LOWER(l_event_name) = 'oracle.apps.ozf.claim.updatestatus' AND
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;

Line 1054: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1050: l_partner_id := x.partner_id;
1051: END LOOP;
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 || ' ' ||

Line 1055: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1051: END LOOP;
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.');

Line 1118: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1114: end if;
1115:
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:

Line 1119: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1115:
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';

Line 1128: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1124:
1125: EXCEPTION
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:

Line 1129: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

1125: EXCEPTION
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

Line 1197: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1193:
1194:
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);

Line 1198: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1194:
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;

Line 1442: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1438: itemkey => p_itemKey,
1439: aname => 'LAST_NOTE',
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:

Line 1443: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1439: aname => 'LAST_NOTE',
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;

Line 1555: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1551: AND APR.approval_status_code IN ('PENDING_APPROVAL','PENDING_DEFAULT','APPROVED')
1552: and apr.approver_type_code = 'USER';
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);

Line 1556: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1552: and apr.approver_type_code = 'USER';
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;

Line 1633: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1629: end loop;
1630: l_role_list := substr(l_role_list,2);
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;

Line 1634: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1630: l_role_list := substr(l_role_list,2);
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;

Line 1640: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1636: 'Unrecognized user role:' || p_user_role);
1637: END IF;
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:

Line 1641: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

Line 1679: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1675: l_parameter_list := p_event.getParameterList();
1676: l_entity_id := p_event.getEventKey();
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;

Line 1680: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1676: l_entity_id := p_event.getEventKey();
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:

Line 1726: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1722: end if;
1723:
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:

Line 1727: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1723:
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';

Line 1736: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1732:
1733: EXCEPTION
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:

Line 1737: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

1733: EXCEPTION
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

Line 1793: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 1794: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

Line 1830: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1826: l_parameter_t.setValue(p_user_callback_api);
1827: l_parameter_list.extend;
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:

Line 1831: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1827: l_parameter_list.extend;
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(

Line 1845: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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
1846: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1847: 'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_RAISE.end', 'Exiting' );
1848: end if;
1849:

Line 1846: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1842: COMMIT WORK;
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.

Line 1860: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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 );
1863: end if;
1864:

Line 1861: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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

Line 1872: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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 );
1875: end if;
1876:

Line 1873: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

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

Line 1885: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) 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 );
1888: end if;
1889:

Line 1886: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

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

Line 1910: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1906: l_entity_id number;
1907: l_translated_reason varchar2(100);
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;

Line 1911: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1907: l_translated_reason varchar2(100);
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:

Line 1922: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1918: open lc_get_reason(pc_entity_id => l_entity_id);
1919: fetch lc_get_reason into 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:

Line 1923: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1919: fetch lc_get_reason into 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;

Line 1930: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1926:
1927: document := l_translated_reason;
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;

Line 1931: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1927: document := l_translated_reason;
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:

Line 1972: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1968: l_label_products varchar2(200);
1969: l_has_products boolean;
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;

Line 1973: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1969: l_has_products boolean;
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:

Line 2002: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1998:
1999: for l_prod_rec in lc_get_products(pc_entity_id => l_entity_id)
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

Line 2003: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1999: for l_prod_rec in lc_get_products(pc_entity_id => l_entity_id)
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:

Line 2029: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2025: end if;
2026:
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;

Line 2030: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2026:
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: