DBA Data[Home] [Help]

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on WF_NOTIFICATION

Line 6381: wf_notification.send (ROLE => l_to_role_name,

6377:
6378: IF p_status = 'PUBLISHED'
6379: THEN
6380: l_notification_id :=
6381: wf_notification.send (ROLE => l_to_role_name,
6382: msg_type => 'HRWPM',
6383: msg_name => 'WPM_PLAN_PUB_ADMIN_MSG',
6384: callback => NULL,
6385: CONTEXT => NULL,

Line 6389: wf_notification.setattrtext (l_notification_id, 'PUB_PLAN_NAME', p_plan_rec.plan_name);

6385: CONTEXT => NULL,
6386: send_comment => NULL,
6387: priority => 50
6388: );
6389: wf_notification.setattrtext (l_notification_id, 'PUB_PLAN_NAME', p_plan_rec.plan_name);
6390: wf_notification.setattrnumber (l_notification_id, 'PUB_REQ_ID', p_request_id);
6391: ELSIF p_status = 'ERROR'
6392: THEN
6393: IF g_dbg

Line 6390: wf_notification.setattrnumber (l_notification_id, 'PUB_REQ_ID', p_request_id);

6386: send_comment => NULL,
6387: priority => 50
6388: );
6389: wf_notification.setattrtext (l_notification_id, 'PUB_PLAN_NAME', p_plan_rec.plan_name);
6390: wf_notification.setattrnumber (l_notification_id, 'PUB_REQ_ID', p_request_id);
6391: ELSIF p_status = 'ERROR'
6392: THEN
6393: IF g_dbg
6394: THEN

Line 6399: wf_notification.send (ROLE => l_to_role_name,

6395: op (l_proc, g_debug_log, 51);
6396: END IF;
6397:
6398: l_notification_id :=
6399: wf_notification.send (ROLE => l_to_role_name,
6400: msg_type => 'HRWPM',
6401: msg_name => 'WPM_PLANPUB_ERROR_ADMIN_MSG',
6402: callback => NULL,
6403: CONTEXT => NULL,

Line 6407: wf_notification.setattrtext (l_notification_id, 'FAILED_PLAN_NAME', p_plan_rec.plan_name);

6403: CONTEXT => NULL,
6404: send_comment => NULL,
6405: priority => 50
6406: );
6407: wf_notification.setattrtext (l_notification_id, 'FAILED_PLAN_NAME', p_plan_rec.plan_name);
6408: wf_notification.setattrnumber (l_notification_id, 'FAILED_REQ_ID', p_request_id);
6409:
6410: IF g_dbg
6411: THEN

Line 6408: wf_notification.setattrnumber (l_notification_id, 'FAILED_REQ_ID', p_request_id);

6404: send_comment => NULL,
6405: priority => 50
6406: );
6407: wf_notification.setattrtext (l_notification_id, 'FAILED_PLAN_NAME', p_plan_rec.plan_name);
6408: wf_notification.setattrnumber (l_notification_id, 'FAILED_REQ_ID', p_request_id);
6409:
6410: IF g_dbg
6411: THEN
6412: op (l_proc, g_debug_log, 52);

Line 6422: wf_notification.send (ROLE => l_to_role_name,

6418: op (l_proc, g_debug_log, 52);
6419: END IF;
6420:
6421: l_notification_id :=
6422: wf_notification.send (ROLE => l_to_role_name,
6423: msg_type => 'HRWPM',
6424: msg_name => 'WPM_PLAN_SUBMIT_ADMIN_MSG',
6425: callback => NULL,
6426: CONTEXT => NULL,

Line 6430: wf_notification.setattrtext (l_notification_id, 'SUBMIT_PLAN_NAME', p_plan_rec.plan_name);

6426: CONTEXT => NULL,
6427: send_comment => NULL,
6428: priority => 50
6429: );
6430: wf_notification.setattrtext (l_notification_id, 'SUBMIT_PLAN_NAME', p_plan_rec.plan_name);
6431: wf_notification.setattrnumber (l_notification_id, 'SUBMIT_REQ_ID', p_request_id);
6432: ELSIF p_status = 'ROLLBACK'
6433: THEN
6434: IF g_dbg

Line 6431: wf_notification.setattrnumber (l_notification_id, 'SUBMIT_REQ_ID', p_request_id);

6427: send_comment => NULL,
6428: priority => 50
6429: );
6430: wf_notification.setattrtext (l_notification_id, 'SUBMIT_PLAN_NAME', p_plan_rec.plan_name);
6431: wf_notification.setattrnumber (l_notification_id, 'SUBMIT_REQ_ID', p_request_id);
6432: ELSIF p_status = 'ROLLBACK'
6433: THEN
6434: IF g_dbg
6435: THEN

Line 6439: hr_utility.set_location (' wf_notification.send:', 51);

6435: THEN
6436: op (l_proc, g_debug_log, 54);
6437: END IF;
6438:
6439: hr_utility.set_location (' wf_notification.send:', 51);
6440: l_notification_id :=
6441: wf_notification.send (ROLE => l_to_role_name,
6442: msg_type => 'HRWPM',
6443: msg_name => 'WPM_PLAN_ROLLB_ADMIN_MSG',

Line 6441: wf_notification.send (ROLE => l_to_role_name,

6437: END IF;
6438:
6439: hr_utility.set_location (' wf_notification.send:', 51);
6440: l_notification_id :=
6441: wf_notification.send (ROLE => l_to_role_name,
6442: msg_type => 'HRWPM',
6443: msg_name => 'WPM_PLAN_ROLLB_ADMIN_MSG',
6444: callback => NULL,
6445: CONTEXT => NULL,

Line 6449: wf_notification.setattrtext (l_notification_id, 'ROLLB_PLAN_NAME', p_plan_rec.plan_name);

6445: CONTEXT => NULL,
6446: send_comment => NULL,
6447: priority => 50
6448: );
6449: wf_notification.setattrtext (l_notification_id, 'ROLLB_PLAN_NAME', p_plan_rec.plan_name);
6450: wf_notification.setattrnumber (l_notification_id, 'ROLLB_REQ_ID', p_request_id);
6451: ELSE
6452: IF g_dbg
6453: THEN

Line 6450: wf_notification.setattrnumber (l_notification_id, 'ROLLB_REQ_ID', p_request_id);

6446: send_comment => NULL,
6447: priority => 50
6448: );
6449: wf_notification.setattrtext (l_notification_id, 'ROLLB_PLAN_NAME', p_plan_rec.plan_name);
6450: wf_notification.setattrnumber (l_notification_id, 'ROLLB_REQ_ID', p_request_id);
6451: ELSE
6452: IF g_dbg
6453: THEN
6454: op (l_proc, g_debug_log, 53);

Line 6465: wf_notification.setattrtext (l_notification_id, '#FROM_ROLE', l_to_role_name);

6461: THEN
6462: op (l_proc, g_debug_log, 60);
6463: END IF;
6464:
6465: wf_notification.setattrtext (l_notification_id, '#FROM_ROLE', l_to_role_name);
6466: wf_notification.setattrtext (l_notification_id, 'WPM_PLAN', p_plan_rec.plan_name);
6467: wf_notification.setattrtext (l_notification_id, 'PLAN_START_DATE', p_plan_rec.start_date);
6468: wf_notification.setattrtext (l_notification_id, 'PLAN_END_DATE', p_plan_rec.end_date);
6469: wf_notification.setattrnumber (l_notification_id, 'CONCREQID', p_request_id);

Line 6466: wf_notification.setattrtext (l_notification_id, 'WPM_PLAN', p_plan_rec.plan_name);

6462: op (l_proc, g_debug_log, 60);
6463: END IF;
6464:
6465: wf_notification.setattrtext (l_notification_id, '#FROM_ROLE', l_to_role_name);
6466: wf_notification.setattrtext (l_notification_id, 'WPM_PLAN', p_plan_rec.plan_name);
6467: wf_notification.setattrtext (l_notification_id, 'PLAN_START_DATE', p_plan_rec.start_date);
6468: wf_notification.setattrtext (l_notification_id, 'PLAN_END_DATE', p_plan_rec.end_date);
6469: wf_notification.setattrnumber (l_notification_id, 'CONCREQID', p_request_id);
6470:

Line 6467: wf_notification.setattrtext (l_notification_id, 'PLAN_START_DATE', p_plan_rec.start_date);

6463: END IF;
6464:
6465: wf_notification.setattrtext (l_notification_id, '#FROM_ROLE', l_to_role_name);
6466: wf_notification.setattrtext (l_notification_id, 'WPM_PLAN', p_plan_rec.plan_name);
6467: wf_notification.setattrtext (l_notification_id, 'PLAN_START_DATE', p_plan_rec.start_date);
6468: wf_notification.setattrtext (l_notification_id, 'PLAN_END_DATE', p_plan_rec.end_date);
6469: wf_notification.setattrnumber (l_notification_id, 'CONCREQID', p_request_id);
6470:
6471: IF g_dbg

Line 6468: wf_notification.setattrtext (l_notification_id, 'PLAN_END_DATE', p_plan_rec.end_date);

6464:
6465: wf_notification.setattrtext (l_notification_id, '#FROM_ROLE', l_to_role_name);
6466: wf_notification.setattrtext (l_notification_id, 'WPM_PLAN', p_plan_rec.plan_name);
6467: wf_notification.setattrtext (l_notification_id, 'PLAN_START_DATE', p_plan_rec.start_date);
6468: wf_notification.setattrtext (l_notification_id, 'PLAN_END_DATE', p_plan_rec.end_date);
6469: wf_notification.setattrnumber (l_notification_id, 'CONCREQID', p_request_id);
6470:
6471: IF g_dbg
6472: THEN

Line 6469: wf_notification.setattrnumber (l_notification_id, 'CONCREQID', p_request_id);

6465: wf_notification.setattrtext (l_notification_id, '#FROM_ROLE', l_to_role_name);
6466: wf_notification.setattrtext (l_notification_id, 'WPM_PLAN', p_plan_rec.plan_name);
6467: wf_notification.setattrtext (l_notification_id, 'PLAN_START_DATE', p_plan_rec.start_date);
6468: wf_notification.setattrtext (l_notification_id, 'PLAN_END_DATE', p_plan_rec.end_date);
6469: wf_notification.setattrnumber (l_notification_id, 'CONCREQID', p_request_id);
6470:
6471: IF g_dbg
6472: THEN
6473: op (l_proc, g_debug_log, 70);

Line 9462: wf_notification.send (ROLE => l_to_role,

9458: CLOSE csr_full_name;
9459: END IF;
9460:
9461: ln_notification_id :=
9462: wf_notification.send (ROLE => l_to_role,
9463: msg_type => 'HRWPM',
9464: -- msg_name => 'HR_WPM_SC_REMOVE',
9465: msg_name => p_message,
9466: callback => NULL,

Line 9471: wf_notification.setattrtext (ln_notification_id, '#FROM_ROLE', l_from_role);

9467: CONTEXT => NULL,
9468: send_comment => NULL,
9469: priority => 50
9470: );
9471: wf_notification.setattrtext (ln_notification_id, '#FROM_ROLE', l_from_role);
9472: --Bug14046389 included WPM_SC_RESET_MGR AND WPM_SC_RESET_WKR
9473: IF (p_message = 'WPM_AP_ENROLL_MSG' OR p_message = 'WPM_SC_REMOVE_MSG' OR p_message = 'WPM_PLAN_ROLLBACK_MSG' OR p_message = 'WPM_SC_REALLOCATE_OBJ_WKR' OR p_message = 'WPM_SC_RESET_WKR' OR p_message = 'WPM_SC_RESET_MGR')
9474: THEN
9475: wf_notification.setattrtext (ln_notification_id, 'HR_WPM_PLAN_NAME', l_plan_rec.plan_name);

Line 9475: wf_notification.setattrtext (ln_notification_id, 'HR_WPM_PLAN_NAME', l_plan_rec.plan_name);

9471: wf_notification.setattrtext (ln_notification_id, '#FROM_ROLE', l_from_role);
9472: --Bug14046389 included WPM_SC_RESET_MGR AND WPM_SC_RESET_WKR
9473: IF (p_message = 'WPM_AP_ENROLL_MSG' OR p_message = 'WPM_SC_REMOVE_MSG' OR p_message = 'WPM_PLAN_ROLLBACK_MSG' OR p_message = 'WPM_SC_REALLOCATE_OBJ_WKR' OR p_message = 'WPM_SC_RESET_WKR' OR p_message = 'WPM_SC_RESET_MGR')
9474: THEN
9475: wf_notification.setattrtext (ln_notification_id, 'HR_WPM_PLAN_NAME', l_plan_rec.plan_name);
9476: ELSIF p_message = 'WPM_SC_REOPEN_MGR_MSG' OR p_message = 'WPM_SC_REFRESH_MGR'
9477: THEN
9478: wf_notification.setattrtext (ln_notification_id, 'SCORE_CARD_EMP_NAME', NVL (p_full_name, l_full_name));
9479: ELSIF p_message = 'WPM_APPRAISAL_REOPEN_MGR_MSG'

Line 9478: wf_notification.setattrtext (ln_notification_id, 'SCORE_CARD_EMP_NAME', NVL (p_full_name, l_full_name));

9474: THEN
9475: wf_notification.setattrtext (ln_notification_id, 'HR_WPM_PLAN_NAME', l_plan_rec.plan_name);
9476: ELSIF p_message = 'WPM_SC_REOPEN_MGR_MSG' OR p_message = 'WPM_SC_REFRESH_MGR'
9477: THEN
9478: wf_notification.setattrtext (ln_notification_id, 'SCORE_CARD_EMP_NAME', NVL (p_full_name, l_full_name));
9479: ELSIF p_message = 'WPM_APPRAISAL_REOPEN_MGR_MSG'
9480: THEN
9481: wf_notification.setattrtext (ln_notification_id, 'APPRAISAL_EMP_NAME', NVL (p_full_name, l_full_name));
9482: --bug14046867 setting attributes

Line 9481: wf_notification.setattrtext (ln_notification_id, 'APPRAISAL_EMP_NAME', NVL (p_full_name, l_full_name));

9477: THEN
9478: wf_notification.setattrtext (ln_notification_id, 'SCORE_CARD_EMP_NAME', NVL (p_full_name, l_full_name));
9479: ELSIF p_message = 'WPM_APPRAISAL_REOPEN_MGR_MSG'
9480: THEN
9481: wf_notification.setattrtext (ln_notification_id, 'APPRAISAL_EMP_NAME', NVL (p_full_name, l_full_name));
9482: --bug14046867 setting attributes
9483: ELSIF ( p_message IN ('WPM_SC_TRNF_WITH_APPR_MGR','WPM_SC_TRNF_WITH_OBJ_MGR','WPM_SC_TRNF_ONLY_MGR'))
9484: THEN
9485: wf_notification.setattrtext (ln_notification_id, 'EMP_NAME', NVL (p_full_name, l_full_name));

Line 9485: wf_notification.setattrtext (ln_notification_id, 'EMP_NAME', NVL (p_full_name, l_full_name));

9481: wf_notification.setattrtext (ln_notification_id, 'APPRAISAL_EMP_NAME', NVL (p_full_name, l_full_name));
9482: --bug14046867 setting attributes
9483: ELSIF ( p_message IN ('WPM_SC_TRNF_WITH_APPR_MGR','WPM_SC_TRNF_WITH_OBJ_MGR','WPM_SC_TRNF_ONLY_MGR'))
9484: THEN
9485: wf_notification.setattrtext (ln_notification_id, 'EMP_NAME', NVL (p_full_name, l_full_name));
9486: wf_notification.setattrtext (ln_notification_id, 'SOURCE_WPM_PLAN', l_src_plan_rec.plan_name);
9487: wf_notification.setattrtext (ln_notification_id, 'TARGET_WPM_PLAN', l_plan_rec.plan_name);
9488:
9489:

Line 9486: wf_notification.setattrtext (ln_notification_id, 'SOURCE_WPM_PLAN', l_src_plan_rec.plan_name);

9482: --bug14046867 setting attributes
9483: ELSIF ( p_message IN ('WPM_SC_TRNF_WITH_APPR_MGR','WPM_SC_TRNF_WITH_OBJ_MGR','WPM_SC_TRNF_ONLY_MGR'))
9484: THEN
9485: wf_notification.setattrtext (ln_notification_id, 'EMP_NAME', NVL (p_full_name, l_full_name));
9486: wf_notification.setattrtext (ln_notification_id, 'SOURCE_WPM_PLAN', l_src_plan_rec.plan_name);
9487: wf_notification.setattrtext (ln_notification_id, 'TARGET_WPM_PLAN', l_plan_rec.plan_name);
9488:
9489:
9490: ELSIF ( p_message IN ('WPM_SC_TRNF_WITH_APPR_WKR','WPM_SC_TRNF_WITH_OBJ_WKR','WPM_SC_TRNF_ONLY_WKR'))

Line 9487: wf_notification.setattrtext (ln_notification_id, 'TARGET_WPM_PLAN', l_plan_rec.plan_name);

9483: ELSIF ( p_message IN ('WPM_SC_TRNF_WITH_APPR_MGR','WPM_SC_TRNF_WITH_OBJ_MGR','WPM_SC_TRNF_ONLY_MGR'))
9484: THEN
9485: wf_notification.setattrtext (ln_notification_id, 'EMP_NAME', NVL (p_full_name, l_full_name));
9486: wf_notification.setattrtext (ln_notification_id, 'SOURCE_WPM_PLAN', l_src_plan_rec.plan_name);
9487: wf_notification.setattrtext (ln_notification_id, 'TARGET_WPM_PLAN', l_plan_rec.plan_name);
9488:
9489:
9490: ELSIF ( p_message IN ('WPM_SC_TRNF_WITH_APPR_WKR','WPM_SC_TRNF_WITH_OBJ_WKR','WPM_SC_TRNF_ONLY_WKR'))
9491: THEN

Line 9493: wf_notification.setattrtext (ln_notification_id, 'SOURCE_WPM_PLAN', l_src_plan_rec.plan_name);

9489:
9490: ELSIF ( p_message IN ('WPM_SC_TRNF_WITH_APPR_WKR','WPM_SC_TRNF_WITH_OBJ_WKR','WPM_SC_TRNF_ONLY_WKR'))
9491: THEN
9492:
9493: wf_notification.setattrtext (ln_notification_id, 'SOURCE_WPM_PLAN', l_src_plan_rec.plan_name);
9494: wf_notification.setattrtext (ln_notification_id, 'TARGET_WPM_PLAN', l_plan_rec.plan_name);
9495: END IF;
9496: --bug14046867
9497: wf_notification.denormalize_notification (ln_notification_id, NULL, NULL);

Line 9494: wf_notification.setattrtext (ln_notification_id, 'TARGET_WPM_PLAN', l_plan_rec.plan_name);

9490: ELSIF ( p_message IN ('WPM_SC_TRNF_WITH_APPR_WKR','WPM_SC_TRNF_WITH_OBJ_WKR','WPM_SC_TRNF_ONLY_WKR'))
9491: THEN
9492:
9493: wf_notification.setattrtext (ln_notification_id, 'SOURCE_WPM_PLAN', l_src_plan_rec.plan_name);
9494: wf_notification.setattrtext (ln_notification_id, 'TARGET_WPM_PLAN', l_plan_rec.plan_name);
9495: END IF;
9496: --bug14046867
9497: wf_notification.denormalize_notification (ln_notification_id, NULL, NULL);
9498: EXCEPTION

Line 9497: wf_notification.denormalize_notification (ln_notification_id, NULL, NULL);

9493: wf_notification.setattrtext (ln_notification_id, 'SOURCE_WPM_PLAN', l_src_plan_rec.plan_name);
9494: wf_notification.setattrtext (ln_notification_id, 'TARGET_WPM_PLAN', l_plan_rec.plan_name);
9495: END IF;
9496: --bug14046867
9497: wf_notification.denormalize_notification (ln_notification_id, NULL, NULL);
9498: EXCEPTION
9499: WHEN OTHERS
9500: THEN
9501: err_msg := SUBSTR ('Error ' || TO_CHAR (SQLCODE) || ': ' || SQLERRM, 1, 255);