DBA Data[Home] [Help]

APPS.PQH_SS_WORKFLOW dependencies on WF_CORE

Line 617: Wf_Core.Context(g_package, 'complete_wf_activity', p_itemType, p_itemKey);

613: --
614: EXCEPTION
615: WHEN OTHERS THEN
616: hr_utility.trace(' exception in '||g_package||'.complete_wf_activity : ' || sqlerrm);
617: Wf_Core.Context(g_package, 'complete_wf_activity', p_itemType, p_itemKey);
618: raise;
619: --
620: END complete_wf_activity;
621: --

Line 731: Wf_Core.Context(g_package, 'start_approval_wf', itemType, itemKey);

727: --
728: EXCEPTION
729: WHEN OTHERS THEN
730: hr_utility.trace(' exception in '||g_package||'.start_approval_wf : ' || sqlerrm);
731: Wf_Core.Context(g_package, 'start_approval_wf', itemType, itemKey);
732: raise;
733: --
734: END start_approval_wf;
735: --

Line 1709: Wf_Core.Context(g_package, 'set_txn_approve_status', itemType, itemKey);

1705: --
1706: EXCEPTION
1707: WHEN OTHERS THEN
1708: hr_utility.trace(' exception in '||g_package||'.set_txn_approve_status : ' || sqlerrm);
1709: Wf_Core.Context(g_package, 'set_txn_approve_status', itemType, itemKey);
1710: raise;
1711: --
1712: END set_txn_approve_status;
1713: --

Line 1737: Wf_Core.Context(g_package, 'set_txn_rfc_status', itemType, itemKey);

1733:
1734: EXCEPTION
1735: WHEN OTHERS THEN
1736: hr_utility.trace(' exception in '||g_package||'.set_txn_rfc_status : ' || sqlerrm);
1737: Wf_Core.Context(g_package, 'set_txn_rfc_status', itemType, itemKey);
1738: raise;
1739: --
1740: END set_txn_rfc_status;
1741: --

Line 1770: Wf_Core.Context(g_package, 'set_txn_sfl_status', itemType, itemKey);

1766:
1767: EXCEPTION
1768: WHEN OTHERS THEN
1769: hr_utility.trace(' exception in '||g_package||'.set_txn_sfl_status : ' || sqlerrm);
1770: Wf_Core.Context(g_package, 'set_txn_sfl_status', itemType, itemKey);
1771: raise;
1772: END set_txn_sfl_status;
1773: --
1774:

Line 1958: Wf_Core.Context(g_package, 'reset_txn_current_values', itemType, itemKey);

1954: --
1955: EXCEPTION
1956: WHEN OTHERS THEN
1957: hr_utility.trace(' exception in '||g_package||'.reset_txn_current_values : ' || sqlerrm);
1958: Wf_Core.Context(g_package, 'reset_txn_current_values', itemType, itemKey);
1959: raise;
1960: --
1961: END reset_txn_current_values;
1962:

Line 2016: Wf_Core.Context(g_package, 'check_initial_save_for_later', itemType, itemKey);

2012: --
2013: EXCEPTION
2014: WHEN OTHERS THEN
2015: hr_utility.trace(' exception in '||g_package||'.check_initial_save_for_later : ' || sqlerrm);
2016: Wf_Core.Context(g_package, 'check_initial_save_for_later', itemType, itemKey);
2017: raise;
2018: --
2019: END check_initial_save_for_later;
2020: --

Line 2490: Wf_Core.Context(g_package, 'set_date_if_as_of_approval', itemType, itemKey);

2486: --
2487: EXCEPTION
2488: WHEN OTHERS THEN
2489: hr_utility.trace(' exception in '||g_package||'.set_date_if_as_of_approval : ' || sqlerrm);
2490: Wf_Core.Context(g_package, 'set_date_if_as_of_approval', itemType, itemKey);
2491: raise;
2492: --
2493: END set_date_if_as_of_approval;
2494: --

Line 2942: Wf_Core.Context(g_package, 'validation_on_final_approval', itemType, itemKey);

2938: --
2939: EXCEPTION
2940: WHEN OTHERS THEN
2941: hr_utility.trace(' exception in '||g_package||'.validation_on_final_approval : ' || sqlerrm);
2942: Wf_Core.Context(g_package, 'validation_on_final_approval', itemType, itemKey);
2943: raise;
2944: --
2945: END validation_on_final_approval;
2946: --

Line 3146: Wf_Core.Token('TYPE', itemtype);

3142: ,p_roleName => l_roleName
3143: ,p_roleId => l_roleId );
3144:
3145: /* if l_roleName is null then
3146: Wf_Core.Token('TYPE', itemtype);
3147: Wf_Core.Token('ACTID', to_char(actid));
3148: Wf_Core.Raise('WFENG_NOTIFICATION_PERFORMER');
3149: end if;
3150: */

Line 3147: Wf_Core.Token('ACTID', to_char(actid));

3143: ,p_roleId => l_roleId );
3144:
3145: /* if l_roleName is null then
3146: Wf_Core.Token('TYPE', itemtype);
3147: Wf_Core.Token('ACTID', to_char(actid));
3148: Wf_Core.Raise('WFENG_NOTIFICATION_PERFORMER');
3149: end if;
3150: */
3151: IF ( l_roleId IS NULL ) THEN

Line 3148: Wf_Core.Raise('WFENG_NOTIFICATION_PERFORMER');

3144:
3145: /* if l_roleName is null then
3146: Wf_Core.Token('TYPE', itemtype);
3147: Wf_Core.Token('ACTID', to_char(actid));
3148: Wf_Core.Raise('WFENG_NOTIFICATION_PERFORMER');
3149: end if;
3150: */
3151: IF ( l_roleId IS NULL ) THEN
3152: --

Line 3196: Wf_Core.Context(g_package, 'set_hr_rep_role', itemType, itemKey);

3192: --
3193: EXCEPTION
3194: WHEN OTHERS THEN
3195: hr_utility.trace(' exception in '||g_package||'.set_hr_rep_role : ' || sqlerrm);
3196: Wf_Core.Context(g_package, 'set_hr_rep_role', itemType, itemKey);
3197: raise;
3198:
3199: END set_hr_rep_role;
3200:

Line 3227: Wf_Core.Context(g_package, 'approval_block', itemType, itemKey);

3223: ':'||wf_engine.eng_null;
3224: exception
3225: when others then
3226: hr_utility.trace(' exception in '||g_package||'.approval_block : ' || sqlerrm);
3227: Wf_Core.Context(g_package, 'approval_block', itemType, itemKey);
3228: raise;
3229: end approval_block;
3230: --
3231:

Line 3341: rs := rs||wf_core.newline||' 3340: '>
';
3341: rs := rs||wf_core.newline||'';

Line 3358: rs := rs||wf_core.newline||'
';

3354: -- dbms_output.put_line(substrb('('||to_char(i)||')='||cells(i),1,254));
3355: -- end if;
3356: modv := mod(i, col);
3357: if (modv = 1) then
3358: rs := rs||wf_core.newline||'

';
3359: end if;
3360:
3361: alignv := substrb(cells(i), 1, 1);
3362: if (alignv = 'R') then

Line 3393: rs := rs||wf_core.newline||'

3389:
3390: if ((l_type = 'V' and modv = 1) or (l_type = 'N' and modv = 1)
3391: or (l_type = 'H' and i <= col)) then
3392: if (l_type = 'N') then
3393: rs := rs||wf_core.newline||' 3394: else
3395: -- this is a header
3396: rs := rs||wf_core.newline||' 3397: end if;

Line 3396: rs := rs||wf_core.newline||'

3392: if (l_type = 'N') then
3393: rs := rs||wf_core.newline||' 3394: else
3395: -- this is a header
3396: rs := rs||wf_core.newline||' 3397: end if;
3398: if (l_type = 'V') then
3399: rs := rs||' scope=row';
3400: else

Line 3419: rs := rs||wf_core.newline||'

3415: rs := rs||'';
3416: end if;
3417: else
3418: -- this is regular data
3419: rs := rs||wf_core.newline||' 3420: if (l_width is not null) then
3421: rs := rs||' width='||l_width;
3422: end if;
3423: rs := rs||' align='||l_align||' valign=baseline bgcolor='||

Line 3434: rs := rs||wf_core.newline||'
';

3430: rs := rs||l_text||'';
3431: end if;
3432: end if;
3433: if (modv = 0) then
3434: rs := rs||wf_core.newline||'';
3435: end if;
3436: end loop;
3437: rs := rs||wf_core.newline||'

'||wf_core.newline||'
';
3438:

Line 3437: rs := rs||wf_core.newline||''||wf_core.newline||'';

3433: if (modv = 0) then
3434: rs := rs||wf_core.newline||'';
3435: end if;
3436: end loop;
3437: rs := rs||wf_core.newline||''||wf_core.newline||'';
3438:
3439: exception
3440: when OTHERS then
3441: wf_core.context('Wf_Notification', 'NTF_Table',to_char(col),l_type);

Line 3441: wf_core.context('Wf_Notification', 'NTF_Table',to_char(col),l_type);

3437: rs := rs||wf_core.newline||''||wf_core.newline||'';
3438:
3439: exception
3440: when OTHERS then
3441: wf_core.context('Wf_Notification', 'NTF_Table',to_char(col),l_type);
3442: raise;
3443: end NTF_Table;
3444:
3445:

Line 3534: cells(j) := wf_core.translate('SEQUENCE');

3530: end;
3531:
3532: j := 1;
3533: -- title
3534: cells(j) := wf_core.translate('SEQUENCE');
3535: if (disptype = wf_notification.doc_html) then
3536: cells(j) := 'L10%:'||cells(j);
3537: end if;
3538: j := j+1;

Line 3539: cells(j) := wf_core.translate('WHO');

3535: if (disptype = wf_notification.doc_html) then
3536: cells(j) := 'L10%:'||cells(j);
3537: end if;
3538: j := j+1;
3539: cells(j) := wf_core.translate('WHO');
3540: if (disptype = wf_notification.doc_html) then
3541: cells(j) := 'L:'||cells(j);
3542: end if;
3543: j := j+1;

Line 3544: cells(j) := wf_core.translate('ACTION');

3540: if (disptype = wf_notification.doc_html) then
3541: cells(j) := 'L:'||cells(j);
3542: end if;
3543: j := j+1;
3544: cells(j) := wf_core.translate('ACTION');
3545: if (disptype = wf_notification.doc_html) then
3546: cells(j) := 'L:'||cells(j);
3547: end if;
3548: j := j+1;

Line 3549: cells(j) := wf_core.translate('DATE');

3545: if (disptype = wf_notification.doc_html) then
3546: cells(j) := 'L:'||cells(j);
3547: end if;
3548: j := j+1;
3549: cells(j) := wf_core.translate('DATE');
3550: if (disptype = wf_notification.doc_html) then
3551: cells(j) := 'L:'||cells(j);
3552: end if;
3553: j := j+1;

Line 3554: cells(j) := wf_core.translate('NOTE');

3550: if (disptype = wf_notification.doc_html) then
3551: cells(j) := 'L:'||cells(j);
3552: end if;
3553: j := j+1;
3554: cells(j) := wf_core.translate('NOTE');
3555: if (disptype = wf_notification.doc_html) then
3556: cells(j) := 'L:'||cells(j);
3557: end if;
3558: j := j+1;

Line 3591: l_action := wf_core.activity_result(l_result_type, l_result_code);

3587: histr.result_type <> l_result_type or
3588: histr.activity_result_code <> l_result_code) then
3589: l_result_type := histr.result_type;
3590: l_result_code := histr.activity_result_code;
3591: l_action := wf_core.activity_result(l_result_type, l_result_code);
3592: end if;
3593: if (disptype = wf_notification.doc_html) then
3594: if (l_action is null) then
3595: cells(j) := 'L: ';

Line 3614: wf_core.clear;

3610: cells(j) := Wf_Notification.GetAttrText(histr.notification_id,'WF_NOTE');
3611: exception
3612: when OTHERS then
3613: cells(j) := null;
3614: wf_core.clear;
3615: end;
3616: if (disptype = wf_notification.doc_html) then
3617: if (cells(j) is null) then
3618: cells(j) := 'L: ';

Line 3640: cells(j) := 'L:'||wf_core.translate('SUBMIT');

3636: cells(j) := role_info_tbl(1).display_name;
3637: end if;
3638: j := j+1;
3639: if (disptype = wf_notification.doc_html) then
3640: cells(j) := 'L:'||wf_core.translate('SUBMIT');
3641: else
3642: cells(j) := wf_core.translate('SUBMIT');
3643: end if;
3644: j := j+1;

Line 3642: cells(j) := wf_core.translate('SUBMIT');

3638: j := j+1;
3639: if (disptype = wf_notification.doc_html) then
3640: cells(j) := 'L:'||wf_core.translate('SUBMIT');
3641: else
3642: cells(j) := wf_core.translate('SUBMIT');
3643: end if;
3644: j := j+1;
3645: if (disptype = wf_notification.doc_html) then
3646: cells(j) := 'L:'||to_char(l_begin_date);

Line 3687: result := result||cells(k)||wf_core.newline;

3683: for k in 1..cells.LAST loop
3684: if (mod(k, 5) <> 0) then
3685: result := result||cells(k)||' '||l_delim||' ';
3686: else
3687: result := result||cells(k)||wf_core.newline;
3688: end if;
3689: end loop;
3690: end if;
3691:

Line 3695: wf_core.context('Wf_Notification', 'Wf_NTF_History', to_char(nid));

3691:
3692: return(result);
3693: exception
3694: when OTHERS then
3695: wf_core.context('Wf_Notification', 'Wf_NTF_History', to_char(nid));
3696: raise;
3697: end wf_ntf_history;
3698:
3699: