DBA Data[Home] [Help]

APPS.PQH_APPLY_BUDGET dependencies on PQH_WF

Line 231: pqh_wf.set_apply_error(p_transaction_category_id => g_transaction_category_id,

227: pqh_process_batch_log.end_log;
228: -- call the wf error
229: hr_utility.set_location('txn_cat :'||g_transaction_category_id||l_proc, 10);
230: hr_utility.set_location('txn_id :'||g_root_wks_dtl_id||l_proc, 10);
231: pqh_wf.set_apply_error(p_transaction_category_id => g_transaction_category_id,
232: p_transaction_id => g_root_wks_dtl_id,
233: p_apply_error_mesg => SQLERRM,
234: p_apply_error_num => SQLCODE);
235: WHEN others THEN

Line 2527: pqh_wf.set_apply_error(p_transaction_category_id => g_transaction_category_id,

2523: END IF; -- not in validate mode and errors
2524:
2525:
2526: -- set the error message to see the process log
2527: pqh_wf.set_apply_error(p_transaction_category_id => g_transaction_category_id,
2528: p_transaction_id => g_root_wks_dtl_id,
2529: p_apply_error_mesg => 'PQH_WKS_CHK_ERRORS',
2530: p_apply_error_num => '1');
2531:

Line 2604: pqh_wf.set_apply_error(p_transaction_category_id => g_transaction_category_id,

2600: -- ROLLBACK HERE up to Savepoint s1 AND THEN PASS CONTROL TO FORM
2601: rollback to s1;
2602: hr_utility.set_location('Conc Program could not be submittted '||l_req, 27);
2603: -- set the error message to see the process log
2604: pqh_wf.set_apply_error(p_transaction_category_id => g_transaction_category_id,
2605: p_transaction_id => g_root_wks_dtl_id,
2606: p_apply_error_mesg => 'PQH_CONC_GL_PGM',
2607: p_apply_error_num => '3');
2608:

Line 2620: pqh_wf.set_apply_error(p_transaction_category_id => g_transaction_category_id,

2616: -- ROLLBACK HERE up to Savepoint s1 AND THEN PASS CONTROL TO FORM
2617: rollback to s1;
2618: hr_utility.set_location('GL Validation Failed ',26);
2619: -- set the error message to see the process log
2620: pqh_wf.set_apply_error(p_transaction_category_id => g_transaction_category_id,
2621: p_transaction_id => g_root_wks_dtl_id,
2622: p_apply_error_mesg => 'PQH_GL_VAL_ERR',
2623: p_apply_error_num => '3');
2624:

Line 2981: l_workflow_name := pqh_wf.get_workflow_name(p_transaction_category_id => p_transaction_category_id);

2977: l_itemkey varchar2(30);
2978: l_workflow_name varchar2(30);
2979:
2980: BEGIN
2981: l_workflow_name := pqh_wf.get_workflow_name(p_transaction_category_id => p_transaction_category_id);
2982: for i in c1 loop
2983: l_itemkey := to_char(p_transaction_category_id) || '-' || to_char(i.worksheet_detail_id) ;
2984: pqh_wf.complete_delegate_workflow(p_itemkey => l_itemkey,
2985: p_workflow_name => l_workflow_name);

Line 2984: pqh_wf.complete_delegate_workflow(p_itemkey => l_itemkey,

2980: BEGIN
2981: l_workflow_name := pqh_wf.get_workflow_name(p_transaction_category_id => p_transaction_category_id);
2982: for i in c1 loop
2983: l_itemkey := to_char(p_transaction_category_id) || '-' || to_char(i.worksheet_detail_id) ;
2984: pqh_wf.complete_delegate_workflow(p_itemkey => l_itemkey,
2985: p_workflow_name => l_workflow_name);
2986: end loop;
2987:
2988: EXCEPTION

Line 3192: hr_utility.set_message(8302,'PQH_WF_FYI_NOTICE_FAIL');

3188: l_document := hr_utility.get_message;
3189: return l_document;
3190: exception
3191: when others then
3192: hr_utility.set_message(8302,'PQH_WF_FYI_NOTICE_FAIL');
3193: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3194: l_document := hr_utility.get_message;
3195: return l_document;
3196: END fyi_notification;

Line 3247: hr_utility.set_message(8302,'PQH_WF_BACK_NOTICE_FAIL');

3243: l_document := hr_utility.get_message;
3244: return l_document;
3245: exception
3246: when others then
3247: hr_utility.set_message(8302,'PQH_WF_BACK_NOTICE_FAIL');
3248: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3249: l_document := hr_utility.get_message;
3250: return l_document;
3251: END back_notification;

Line 3301: hr_utility.set_message(8302,'PQH_WF_OVERRIDE_NOTICE_FAIL');

3297: l_document := hr_utility.get_message;
3298: return l_document;
3299: exception
3300: when others then
3301: hr_utility.set_message(8302,'PQH_WF_OVERRIDE_NOTICE_FAIL');
3302: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3303: l_document := hr_utility.get_message;
3304: return l_document;
3305: END override_notification;

Line 3355: hr_utility.set_message(8302,'PQH_WF_APPLY_NOTICE_FAIL');

3351: l_document := hr_utility.get_message;
3352: return l_document;
3353: exception
3354: when others then
3355: hr_utility.set_message(8302,'PQH_WF_APPLY_NOTICE_FAIL');
3356: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3357: l_document := hr_utility.get_message;
3358: return l_document;
3359: END apply_notification;

Line 3409: hr_utility.set_message(8302,'PQH_WF_REJECT_NOTICE_FAIL');

3405: l_document := hr_utility.get_message;
3406: return l_document;
3407: exception
3408: when others then
3409: hr_utility.set_message(8302,'PQH_WF_REJECT_NOTICE_FAIL');
3410: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3411: l_document := hr_utility.get_message;
3412: return l_document;
3413: END reject_notification;

Line 3463: hr_utility.set_message(8302,'PQH_WF_WARNING_NOTICE_FAIL');

3459: l_document := hr_utility.get_message;
3460: return l_document;
3461: exception
3462: when others then
3463: hr_utility.set_message(8302,'PQH_WF_WARNING_NOTICE_FAIL');
3464: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3465: l_document := hr_utility.get_message;
3466: return l_document;
3467: END warning_notification;

Line 3517: hr_utility.set_message(8302,'PQH_WF_RESPOND_NOTICE_FAIL');

3513: l_document := hr_utility.get_message;
3514: return l_document;
3515: exception
3516: when others then
3517: hr_utility.set_message(8302,'PQH_WF_RESPOND_NOTICE_FAIL');
3518: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3519: l_document := hr_utility.get_message;
3520: return l_document;
3521: END respond_notification;