APPS.MSC_X_USER_EXCEP_GEN dependencies on WF_NOTIFICATION

Line 295: lNtfId := wf_notification.send

291: if buyer_c1%NOTFOUND then
292: log_message('Warning: Buyer not found for Item : '||l_item_name);
293: else
294: if l_user_name is not null and validate_block_notification(l_user_name, v_exception_id) = 0 then ---Bug # 6175897
295: lNtfId := wf_notification.send
296: (
297: role =>l_user_name,
298: msg_type=> p_item_type ,
299: msg_name => v_msg_name ,

Line 325: lNtfId := wf_notification.send

321: if buyer_c2%NOTFOUND then
322: log_message('Warning: Buyer not found for Item : '||l_item_name);
323: else
324: if l_user_name is not null and validate_block_notification(l_user_name, v_exception_id) = 0 then ---Bug # 6175897
325: lNtfId := wf_notification.send
326: (
327: role =>l_user_name,
328: msg_type=> p_item_type ,
329: msg_name => v_msg_name ,

Line 453: lNtfId := wf_notification.send

449: if sup_modelled_org_c%NOTFOUND then
450: log_message('Warning: Supplier Contact not found for Supplier :: '||l_sup_name ||' , Supplier Site :: '|| l_sup_site_name);
451: else
452: if l_user_name is not null and validate_block_notification(l_user_name, v_exception_id) = 0 then ---Bug # 6175897
453: lNtfId := wf_notification.send
454: (
455: role =>l_user_name,
456: msg_type=> p_item_type ,
457: msg_name => v_msg_name ,

Line 471: lNtfId := wf_notification.send

467: close sup_modelled_org_c;
468:
469: else
470: if l_user_name is not null and validate_block_notification(l_user_name, v_exception_id) = 0 then ---Bug # 6175897
471: lNtfId := wf_notification.send
472: (
473: role =>l_user_name,
474: msg_type=> p_item_type ,
475: msg_name => v_msg_name ,

Line 3071: lNtfId := wf_notification.send

3067: if v_debug then
3068: log_message('sending notification = '||lWfRole);
3069: end if;
3070:
3071: lNtfId := wf_notification.send
3072: (
3073: role =>lWfRole,
3074: msg_type=> p_item_type ,
3075: msg_name => v_msg_name ,

Line 3189: lNtfId := wf_notification.send

3185: log_message('Warning: Planner not found for Item : '||l_item_name);
3186:
3187: else
3188: if l_user_name is not null and validate_block_notification(l_user_name, v_exception_id) = 0 then ---Bug # 6175897
3189: lNtfId := wf_notification.send
3190: (
3191: role =>l_user_name,
3192: msg_type=> p_item_type ,
3193: msg_name => v_msg_name ,

Line 3218: lNtfId := wf_notification.send

3214: log_message('Warning: Planner not found for Item : '||l_item_name);
3215:
3216: else
3217: if l_user_name is not null and validate_block_notification(l_user_name, v_exception_id) = 0 then ---Bug # 6175897
3218: lNtfId := wf_notification.send
3219: (
3220: role =>l_user_name,
3221: msg_type=> p_item_type ,
3222: msg_name => v_msg_name ,

Line 3278: wf_notifications nt

3274: IS
3275: CURSOR c1 IS
3276: select nt.notification_id,nt.status
3277: from wf_item_activity_statuses st,
3278: wf_notifications nt
3279: where st.item_type = l_type
3280: and st.item_key like l_key
3281: and nt.notification_id = st.notification_id
3282: union

Line 3284: from wf_item_activity_statuses_h st1,wf_notifications nt

3280: and st.item_key like l_key
3281: and nt.notification_id = st.notification_id
3282: union
3283: select nt.notification_id,nt.status
3284: from wf_item_activity_statuses_h st1,wf_notifications nt
3285: where st1.item_type = l_type
3286: and st1.item_key like l_key
3287: and
3288: nt.notification_id = st1.notification_id;

Line 3294: update wf_notifications set

3290:
3291: BEGIN
3292:
3293: FOR aRec IN c1 LOOP
3294: update wf_notifications set
3295: end_date = sysdate
3296: where notification_id = aRec.notification_id;
3297: IF aRec.status = 'OPEN' THEN
3298: wf_notification.close(aRec.notification_id);

Line 3298: wf_notification.close(aRec.notification_id);

3294: update wf_notifications set
3295: end_date = sysdate
3296: where notification_id = aRec.notification_id;
3297: IF aRec.status = 'OPEN' THEN
3298: wf_notification.close(aRec.notification_id);
3299: END IF;
3300: END LOOP;
3301:
3302: update wf_items set