DBA Data[Home] [Help]

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on WF_NOTIFICATION

Line 4776: l_notification_id := wf_notification.send

4772: expand_role := 'N';
4773: --
4774: IF g_dbg THEN op(l_proc, g_DEBUG_LOG, 50); END IF;
4775: if p_status = 'PUBLISHED' then
4776: l_notification_id := wf_notification.send
4777: (role => l_to_role_name
4778: ,msg_type => 'HRWPM'
4779: ,msg_name => 'WPM_PLAN_PUB_ADMIN_MSG'
4780: ,callback => null

Line 4785: wf_notification.SetAttrText(l_notification_id,'PUB_PLAN_NAME', p_plan_rec.plan_name);

4781: ,context => null
4782: ,send_comment => null
4783: ,priority => 50
4784: );
4785: wf_notification.SetAttrText(l_notification_id,'PUB_PLAN_NAME', p_plan_rec.plan_name);
4786: wf_notification.SetAttrNumber(l_notification_id,'PUB_REQ_ID', p_request_id);
4787: elsif p_status = 'ERROR' then
4788: IF g_dbg THEN op(l_proc, g_DEBUG_LOG, 51); END IF;
4789: l_notification_id := wf_notification.send

Line 4786: wf_notification.SetAttrNumber(l_notification_id,'PUB_REQ_ID', p_request_id);

4782: ,send_comment => null
4783: ,priority => 50
4784: );
4785: wf_notification.SetAttrText(l_notification_id,'PUB_PLAN_NAME', p_plan_rec.plan_name);
4786: wf_notification.SetAttrNumber(l_notification_id,'PUB_REQ_ID', p_request_id);
4787: elsif p_status = 'ERROR' then
4788: IF g_dbg THEN op(l_proc, g_DEBUG_LOG, 51); END IF;
4789: l_notification_id := wf_notification.send
4790: (role => l_to_role_name

Line 4789: l_notification_id := wf_notification.send

4785: wf_notification.SetAttrText(l_notification_id,'PUB_PLAN_NAME', p_plan_rec.plan_name);
4786: wf_notification.SetAttrNumber(l_notification_id,'PUB_REQ_ID', p_request_id);
4787: elsif p_status = 'ERROR' then
4788: IF g_dbg THEN op(l_proc, g_DEBUG_LOG, 51); END IF;
4789: l_notification_id := wf_notification.send
4790: (role => l_to_role_name
4791: ,msg_type => 'HRWPM'
4792: ,msg_name => 'WPM_PLANPUB_ERROR_ADMIN_MSG'
4793: ,callback => null

Line 4798: wf_notification.SetAttrText(l_notification_id,'FAILED_PLAN_NAME', p_plan_rec.plan_name);

4794: ,context => null
4795: ,send_comment => null
4796: ,priority => 50
4797: );
4798: wf_notification.SetAttrText(l_notification_id,'FAILED_PLAN_NAME', p_plan_rec.plan_name);
4799: wf_notification.SetAttrNumber(l_notification_id,'FAILED_REQ_ID', p_request_id);
4800: IF g_dbg THEN op(l_proc, g_DEBUG_LOG, 52); END IF;
4801: elsif p_status = 'SUBMITTED' then
4802: IF g_dbg THEN op(l_proc, g_DEBUG_LOG, 52); END IF;

Line 4799: wf_notification.SetAttrNumber(l_notification_id,'FAILED_REQ_ID', p_request_id);

4795: ,send_comment => null
4796: ,priority => 50
4797: );
4798: wf_notification.SetAttrText(l_notification_id,'FAILED_PLAN_NAME', p_plan_rec.plan_name);
4799: wf_notification.SetAttrNumber(l_notification_id,'FAILED_REQ_ID', p_request_id);
4800: IF g_dbg THEN op(l_proc, g_DEBUG_LOG, 52); END IF;
4801: elsif p_status = 'SUBMITTED' then
4802: IF g_dbg THEN op(l_proc, g_DEBUG_LOG, 52); END IF;
4803: l_notification_id := wf_notification.send

Line 4803: l_notification_id := wf_notification.send

4799: wf_notification.SetAttrNumber(l_notification_id,'FAILED_REQ_ID', p_request_id);
4800: IF g_dbg THEN op(l_proc, g_DEBUG_LOG, 52); END IF;
4801: elsif p_status = 'SUBMITTED' then
4802: IF g_dbg THEN op(l_proc, g_DEBUG_LOG, 52); END IF;
4803: l_notification_id := wf_notification.send
4804: (role => l_to_role_name
4805: ,msg_type => 'HRWPM'
4806: ,msg_name => 'WPM_PLAN_SUBMIT_ADMIN_MSG'
4807: ,callback => null

Line 4812: wf_notification.SetAttrText(l_notification_id,'SUBMIT_PLAN_NAME', p_plan_rec.plan_name);

4808: ,context => null
4809: ,send_comment => null
4810: ,priority => 50
4811: );
4812: wf_notification.SetAttrText(l_notification_id,'SUBMIT_PLAN_NAME', p_plan_rec.plan_name);
4813: wf_notification.SetAttrNumber(l_notification_id,'SUBMIT_REQ_ID', p_request_id);
4814: else
4815: IF g_dbg THEN op(l_proc, g_DEBUG_LOG, 53); END IF;
4816: null;

Line 4813: wf_notification.SetAttrNumber(l_notification_id,'SUBMIT_REQ_ID', p_request_id);

4809: ,send_comment => null
4810: ,priority => 50
4811: );
4812: wf_notification.SetAttrText(l_notification_id,'SUBMIT_PLAN_NAME', p_plan_rec.plan_name);
4813: wf_notification.SetAttrNumber(l_notification_id,'SUBMIT_REQ_ID', p_request_id);
4814: else
4815: IF g_dbg THEN op(l_proc, g_DEBUG_LOG, 53); END IF;
4816: null;
4817: end if;

Line 4819: wf_notification.SetAttrText(l_notification_id,'#FROM_ROLE',l_to_role_name);

4815: IF g_dbg THEN op(l_proc, g_DEBUG_LOG, 53); END IF;
4816: null;
4817: end if;
4818: IF g_dbg THEN op(l_proc, g_DEBUG_LOG, 60); END IF;
4819: wf_notification.SetAttrText(l_notification_id,'#FROM_ROLE',l_to_role_name);
4820: wf_notification.SetAttrText(l_notification_id,'WPM_PLAN', p_plan_rec.plan_name);
4821: wf_notification.SetAttrText(l_notification_id,'PLAN_START_DATE', p_plan_rec.start_date);
4822: wf_notification.SetAttrText(l_notification_id,'PLAN_END_DATE', p_plan_rec.end_date);
4823: wf_notification.SetAttrNumber(l_notification_id,'CONCREQID', p_request_id);

Line 4820: wf_notification.SetAttrText(l_notification_id,'WPM_PLAN', p_plan_rec.plan_name);

4816: null;
4817: end if;
4818: IF g_dbg THEN op(l_proc, g_DEBUG_LOG, 60); END IF;
4819: wf_notification.SetAttrText(l_notification_id,'#FROM_ROLE',l_to_role_name);
4820: wf_notification.SetAttrText(l_notification_id,'WPM_PLAN', p_plan_rec.plan_name);
4821: wf_notification.SetAttrText(l_notification_id,'PLAN_START_DATE', p_plan_rec.start_date);
4822: wf_notification.SetAttrText(l_notification_id,'PLAN_END_DATE', p_plan_rec.end_date);
4823: wf_notification.SetAttrNumber(l_notification_id,'CONCREQID', p_request_id);
4824: IF g_dbg THEN op(l_proc, g_DEBUG_LOG, 70); END IF;

Line 4821: wf_notification.SetAttrText(l_notification_id,'PLAN_START_DATE', p_plan_rec.start_date);

4817: end if;
4818: IF g_dbg THEN op(l_proc, g_DEBUG_LOG, 60); END IF;
4819: wf_notification.SetAttrText(l_notification_id,'#FROM_ROLE',l_to_role_name);
4820: wf_notification.SetAttrText(l_notification_id,'WPM_PLAN', p_plan_rec.plan_name);
4821: wf_notification.SetAttrText(l_notification_id,'PLAN_START_DATE', p_plan_rec.start_date);
4822: wf_notification.SetAttrText(l_notification_id,'PLAN_END_DATE', p_plan_rec.end_date);
4823: wf_notification.SetAttrNumber(l_notification_id,'CONCREQID', p_request_id);
4824: IF g_dbg THEN op(l_proc, g_DEBUG_LOG, 70); END IF;
4825:

Line 4822: wf_notification.SetAttrText(l_notification_id,'PLAN_END_DATE', p_plan_rec.end_date);

4818: IF g_dbg THEN op(l_proc, g_DEBUG_LOG, 60); END IF;
4819: wf_notification.SetAttrText(l_notification_id,'#FROM_ROLE',l_to_role_name);
4820: wf_notification.SetAttrText(l_notification_id,'WPM_PLAN', p_plan_rec.plan_name);
4821: wf_notification.SetAttrText(l_notification_id,'PLAN_START_DATE', p_plan_rec.start_date);
4822: wf_notification.SetAttrText(l_notification_id,'PLAN_END_DATE', p_plan_rec.end_date);
4823: wf_notification.SetAttrNumber(l_notification_id,'CONCREQID', p_request_id);
4824: IF g_dbg THEN op(l_proc, g_DEBUG_LOG, 70); END IF;
4825:
4826: exception when others then

Line 4823: wf_notification.SetAttrNumber(l_notification_id,'CONCREQID', p_request_id);

4819: wf_notification.SetAttrText(l_notification_id,'#FROM_ROLE',l_to_role_name);
4820: wf_notification.SetAttrText(l_notification_id,'WPM_PLAN', p_plan_rec.plan_name);
4821: wf_notification.SetAttrText(l_notification_id,'PLAN_START_DATE', p_plan_rec.start_date);
4822: wf_notification.SetAttrText(l_notification_id,'PLAN_END_DATE', p_plan_rec.end_date);
4823: wf_notification.SetAttrNumber(l_notification_id,'CONCREQID', p_request_id);
4824: IF g_dbg THEN op(l_proc, g_DEBUG_LOG, 70); END IF;
4825:
4826: exception when others then
4827: IF g_dbg THEN op(l_proc, g_REGULAR_LOG, 100); END IF;

Line 6582: ln_notification_id := wf_notification.send(role => l_to_role,

6578: fetch get_role into l_to_role;
6579: close get_role;
6580:
6581:
6582: ln_notification_id := wf_notification.send(role => l_to_role,
6583: msg_type => 'HRWPM' ,
6584: -- msg_name => 'HR_WPM_SC_REMOVE',
6585: msg_name => p_message,
6586: callback => null,

Line 6591: wf_notification.SetAttrText(ln_notification_id,'#FROM_ROLE',l_from_role);

6587: context => null,
6588: send_comment => null,
6589: priority => 50) ;
6590:
6591: wf_notification.SetAttrText(ln_notification_id,'#FROM_ROLE',l_from_role);
6592:
6593: if (p_message='WPM_AP_ENROLL_MSG' or p_message = 'WPM_SC_REMOVE_MSG' or p_message = 'WPM_PLAN_ROLLBACK_MSG' ) then
6594: wf_notification.SetAttrText(ln_notification_id,'HR_WPM_PLAN_NAME' ,l_plan_rec.plan_name);
6595: elsif p_message = 'WPM_SC_REOPEN_MGR_MSG' or p_message = 'WPM_SC_REFRESH_MGR' then

Line 6594: wf_notification.SetAttrText(ln_notification_id,'HR_WPM_PLAN_NAME' ,l_plan_rec.plan_name);

6590:
6591: wf_notification.SetAttrText(ln_notification_id,'#FROM_ROLE',l_from_role);
6592:
6593: if (p_message='WPM_AP_ENROLL_MSG' or p_message = 'WPM_SC_REMOVE_MSG' or p_message = 'WPM_PLAN_ROLLBACK_MSG' ) then
6594: wf_notification.SetAttrText(ln_notification_id,'HR_WPM_PLAN_NAME' ,l_plan_rec.plan_name);
6595: elsif p_message = 'WPM_SC_REOPEN_MGR_MSG' or p_message = 'WPM_SC_REFRESH_MGR' then
6596: wf_notification.SetAttrText(ln_notification_id,'SCORE_CARD_EMP_NAME' ,p_full_name);
6597: elsif p_message = 'WPM_APPRAISAL_REOPEN_MGR_MSG' then
6598: wf_notification.SetAttrText(ln_notification_id,'APPRAISAL_EMP_NAME' ,p_full_name);

Line 6596: wf_notification.SetAttrText(ln_notification_id,'SCORE_CARD_EMP_NAME' ,p_full_name);

6592:
6593: if (p_message='WPM_AP_ENROLL_MSG' or p_message = 'WPM_SC_REMOVE_MSG' or p_message = 'WPM_PLAN_ROLLBACK_MSG' ) then
6594: wf_notification.SetAttrText(ln_notification_id,'HR_WPM_PLAN_NAME' ,l_plan_rec.plan_name);
6595: elsif p_message = 'WPM_SC_REOPEN_MGR_MSG' or p_message = 'WPM_SC_REFRESH_MGR' then
6596: wf_notification.SetAttrText(ln_notification_id,'SCORE_CARD_EMP_NAME' ,p_full_name);
6597: elsif p_message = 'WPM_APPRAISAL_REOPEN_MGR_MSG' then
6598: wf_notification.SetAttrText(ln_notification_id,'APPRAISAL_EMP_NAME' ,p_full_name);
6599: end if;
6600: wf_notification.Denormalize_Notification(ln_notification_id,null,null);

Line 6598: wf_notification.SetAttrText(ln_notification_id,'APPRAISAL_EMP_NAME' ,p_full_name);

6594: wf_notification.SetAttrText(ln_notification_id,'HR_WPM_PLAN_NAME' ,l_plan_rec.plan_name);
6595: elsif p_message = 'WPM_SC_REOPEN_MGR_MSG' or p_message = 'WPM_SC_REFRESH_MGR' then
6596: wf_notification.SetAttrText(ln_notification_id,'SCORE_CARD_EMP_NAME' ,p_full_name);
6597: elsif p_message = 'WPM_APPRAISAL_REOPEN_MGR_MSG' then
6598: wf_notification.SetAttrText(ln_notification_id,'APPRAISAL_EMP_NAME' ,p_full_name);
6599: end if;
6600: wf_notification.Denormalize_Notification(ln_notification_id,null,null);
6601:
6602:

Line 6600: wf_notification.Denormalize_Notification(ln_notification_id,null,null);

6596: wf_notification.SetAttrText(ln_notification_id,'SCORE_CARD_EMP_NAME' ,p_full_name);
6597: elsif p_message = 'WPM_APPRAISAL_REOPEN_MGR_MSG' then
6598: wf_notification.SetAttrText(ln_notification_id,'APPRAISAL_EMP_NAME' ,p_full_name);
6599: end if;
6600: wf_notification.Denormalize_Notification(ln_notification_id,null,null);
6601:
6602:
6603: exception
6604: WHEN OTHERS THEN