eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DOR_REVIEW_SS dependencies on HR_UTILITY

Line 25: hr_utility.set_location('ENTERING get_approval_req', 10);

21:
22: l_item_value varchar2(200);
23:
24: BEGIN
25: hr_utility.set_location('ENTERING get_approval_req', 10);
26: IF (funcmode='RUN') THEN
27: l_item_value := wf_engine.getItemAttrText(
28: itemtype => itemtype
29: ,itemkey => itemkey

Line 37: hr_utility.trace('l_resultout' || resultout);

33: resultout:='COMPLETE:N';
34: else
35: resultout:='COMPLETE:Y';
36: end if;
37: hr_utility.trace('l_resultout' || resultout);
38:
39: RETURN;
40: END IF; --RUN
41:

Line 48: hr_utility.set_location('ENTERING exception get_approval_req', 10);

44: RETURN;
45: END IF;
46: Exception
47: when others then
48: hr_utility.set_location('ENTERING exception get_approval_req', 10);
49:
50: end get_approval_req;
51:
52:

Line 109: -- hr_utility.trace_on(null,'ORCL1');

105: and status ='W'
106: and selected_person_id = p_selected_person_id ;
107:
108: BEGIN
109: -- hr_utility.trace_on(null,'ORCL1');
110: hr_utility.set_location('Entering '||g_package||'.start_transaction', 10);
111:
112:
113:

Line 110: hr_utility.set_location('Entering '||g_package||'.start_transaction', 10);

106: and selected_person_id = p_selected_person_id ;
107:
108: BEGIN
109: -- hr_utility.trace_on(null,'ORCL1');
110: hr_utility.set_location('Entering '||g_package||'.start_transaction', 10);
111:
112:
113:
114: --

Line 260: hr_utility.raise_error;

256: p_transaction_step_id := l_transaction_step_id;
257: p_transaction_id := l_transaction_id;
258:
259: if p_error_message = 'E' then
260: hr_utility.raise_error;
261: else
262: p_error_message := 'S';
263: end if;
264:

Line 266: WHEN hr_utility.hr_error THEN

262: p_error_message := 'S';
263: end if;
264:
265: EXCEPTION
266: WHEN hr_utility.hr_error THEN
267: -- -------------------------------------------
268: -- an application error has been raised so we must
269: -- redisplay the web form to display the error
270: -- --------------------------------------------

Line 395: -- hr_utility.trace_on(null,'ORCL1');

391: msg_name varchar2(1000);
392: msg_appl varchar2(10);
393:
394: BEGIN
395: -- hr_utility.trace_on(null,'ORCL1');
396: hr_utility.set_location('Entering '||l_proc, 30);
397: --
398:
399: p_transaction_id := get_transaction_id(p_transaction_step_id);

Line 396: hr_utility.set_location('Entering '||l_proc, 30);

392: msg_appl varchar2(10);
393:
394: BEGIN
395: -- hr_utility.trace_on(null,'ORCL1');
396: hr_utility.set_location('Entering '||l_proc, 30);
397: --
398:
399: p_transaction_id := get_transaction_id(p_transaction_step_id);
400: p_action_mode := getActionMode(p_transaction_id);

Line 2110: hr_utility.raise_error;

2106:
2107: END IF;
2108:
2109: if p_return_status = 'E' then
2110: hr_utility.raise_error;
2111: else
2112: p_return_status := 'S';
2113: end if;
2114:

Line 2118: hr_utility.trace('Exception in g_data_error in '||l_proc||','|| SQLERRM );

2114:
2115: EXCEPTION
2116:
2117: WHEN g_data_error THEN
2118: hr_utility.trace('Exception in g_data_error in '||l_proc||','|| SQLERRM );
2119: hr_utility.set_location(' Leaving:' || l_proc,666);
2120: p_return_status := SQLERRM;
2121:
2122: WHEN hr_utility.hr_error THEN

Line 2119: hr_utility.set_location(' Leaving:' || l_proc,666);

2115: EXCEPTION
2116:
2117: WHEN g_data_error THEN
2118: hr_utility.trace('Exception in g_data_error in '||l_proc||','|| SQLERRM );
2119: hr_utility.set_location(' Leaving:' || l_proc,666);
2120: p_return_status := SQLERRM;
2121:
2122: WHEN hr_utility.hr_error THEN
2123: hr_utility.get_message_details(msg_name,msg_appl);

Line 2122: WHEN hr_utility.hr_error THEN

2118: hr_utility.trace('Exception in g_data_error in '||l_proc||','|| SQLERRM );
2119: hr_utility.set_location(' Leaving:' || l_proc,666);
2120: p_return_status := SQLERRM;
2121:
2122: WHEN hr_utility.hr_error THEN
2123: hr_utility.get_message_details(msg_name,msg_appl);
2124: fnd_message.set_name(msg_appl,msg_name);
2125: p_return_status := hr_utility.get_message;
2126:

Line 2123: hr_utility.get_message_details(msg_name,msg_appl);

2119: hr_utility.set_location(' Leaving:' || l_proc,666);
2120: p_return_status := SQLERRM;
2121:
2122: WHEN hr_utility.hr_error THEN
2123: hr_utility.get_message_details(msg_name,msg_appl);
2124: fnd_message.set_name(msg_appl,msg_name);
2125: p_return_status := hr_utility.get_message;
2126:
2127: WHEN OTHERS THEN

Line 2125: p_return_status := hr_utility.get_message;

2121:
2122: WHEN hr_utility.hr_error THEN
2123: hr_utility.get_message_details(msg_name,msg_appl);
2124: fnd_message.set_name(msg_appl,msg_name);
2125: p_return_status := hr_utility.get_message;
2126:
2127: WHEN OTHERS THEN
2128: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );
2129: hr_utility.set_location(' Leaving:' || l_proc,660);

Line 2128: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );

2124: fnd_message.set_name(msg_appl,msg_name);
2125: p_return_status := hr_utility.get_message;
2126:
2127: WHEN OTHERS THEN
2128: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );
2129: hr_utility.set_location(' Leaving:' || l_proc,660);
2130: p_return_status := SQLERRM;
2131:
2132:

Line 2129: hr_utility.set_location(' Leaving:' || l_proc,660);

2125: p_return_status := hr_utility.get_message;
2126:
2127: WHEN OTHERS THEN
2128: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );
2129: hr_utility.set_location(' Leaving:' || l_proc,660);
2130: p_return_status := SQLERRM;
2131:
2132:
2133: END save_transaction_values;

Line 2165: -- hr_utility.trace_on(null,'ORCL1');

2161: msg_appl varchar2(10);
2162:
2163: BEGIN
2164:
2165: -- hr_utility.trace_on(null,'ORCL1');
2166: hr_utility.set_location(' Entering:' || l_proc,40);
2167:
2168:
2169: If p_validate then

Line 2166: hr_utility.set_location(' Entering:' || l_proc,40);

2162:
2163: BEGIN
2164:
2165: -- hr_utility.trace_on(null,'ORCL1');
2166: hr_utility.set_location(' Entering:' || l_proc,40);
2167:
2168:
2169: If p_validate then
2170: l_validate := hr_api.g_true_num;

Line 2421: hr_utility.raise_error;

2417: ,p_return_status => p_return_status);
2418:
2419:
2420: if p_return_status = 'E' then
2421: hr_utility.raise_error;
2422: else
2423: p_return_status := 'S';
2424: end if;
2425:

Line 2430: hr_utility.trace('Exception in g_data_error in '||l_proc||','|| SQLERRM );

2426:
2427: EXCEPTION
2428:
2429: WHEN g_data_error THEN
2430: hr_utility.trace('Exception in g_data_error in '||l_proc||','|| SQLERRM );
2431: hr_utility.set_location(' Leaving:' || l_proc,666);
2432: raise;
2433:
2434: WHEN hr_utility.hr_error THEN

Line 2431: hr_utility.set_location(' Leaving:' || l_proc,666);

2427: EXCEPTION
2428:
2429: WHEN g_data_error THEN
2430: hr_utility.trace('Exception in g_data_error in '||l_proc||','|| SQLERRM );
2431: hr_utility.set_location(' Leaving:' || l_proc,666);
2432: raise;
2433:
2434: WHEN hr_utility.hr_error THEN
2435: hr_utility.get_message_details(msg_name,msg_appl);

Line 2434: WHEN hr_utility.hr_error THEN

2430: hr_utility.trace('Exception in g_data_error in '||l_proc||','|| SQLERRM );
2431: hr_utility.set_location(' Leaving:' || l_proc,666);
2432: raise;
2433:
2434: WHEN hr_utility.hr_error THEN
2435: hr_utility.get_message_details(msg_name,msg_appl);
2436: fnd_message.set_name(msg_appl,msg_name);
2437: p_return_status := hr_utility.get_message;
2438:

Line 2435: hr_utility.get_message_details(msg_name,msg_appl);

2431: hr_utility.set_location(' Leaving:' || l_proc,666);
2432: raise;
2433:
2434: WHEN hr_utility.hr_error THEN
2435: hr_utility.get_message_details(msg_name,msg_appl);
2436: fnd_message.set_name(msg_appl,msg_name);
2437: p_return_status := hr_utility.get_message;
2438:
2439: WHEN OTHERS THEN

Line 2437: p_return_status := hr_utility.get_message;

2433:
2434: WHEN hr_utility.hr_error THEN
2435: hr_utility.get_message_details(msg_name,msg_appl);
2436: fnd_message.set_name(msg_appl,msg_name);
2437: p_return_status := hr_utility.get_message;
2438:
2439: WHEN OTHERS THEN
2440: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );
2441: hr_utility.set_location(' Leaving:' || l_proc,660);

Line 2440: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );

2436: fnd_message.set_name(msg_appl,msg_name);
2437: p_return_status := hr_utility.get_message;
2438:
2439: WHEN OTHERS THEN
2440: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );
2441: hr_utility.set_location(' Leaving:' || l_proc,660);
2442: raise ;
2443:
2444:

Line 2441: hr_utility.set_location(' Leaving:' || l_proc,660);

2437: p_return_status := hr_utility.get_message;
2438:
2439: WHEN OTHERS THEN
2440: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );
2441: hr_utility.set_location(' Leaving:' || l_proc,660);
2442: raise ;
2443:
2444:
2445: END process_api;

Line 2604: --hr_utility.trace_on(null,'ORCL1');

2600: --FIX FOR BUG 15835786
2601:
2602: BEGIN
2603:
2604: --hr_utility.trace_on(null,'ORCL1');
2605: hr_utility.set_location(' Entering:' || l_proc,50);
2606:
2607:
2608: --- Validating the document information thru api------------------

Line 2605: hr_utility.set_location(' Entering:' || l_proc,50);

2601:
2602: BEGIN
2603:
2604: --hr_utility.trace_on(null,'ORCL1');
2605: hr_utility.set_location(' Entering:' || l_proc,50);
2606:
2607:
2608: --- Validating the document information thru api------------------
2609: if p_action_mode = 'DOR_INSERT' then

Line 2812: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');

2808: select document_type into l_document_type
2809: from hr_document_types_v
2810: where document_type_id = p_document_type_id;
2811:
2812: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');
2813: hr_utility.set_message_token('TYPE', l_document_type);
2814: hr_utility.set_message_token('DATE_FROM', p_date_from);
2815: hr_utility.set_message_token('DATE_TO', p_date_to);
2816: p_return_status := hr_utility.hr_error_number||hr_utility.get_message;

Line 2813: hr_utility.set_message_token('TYPE', l_document_type);

2809: from hr_document_types_v
2810: where document_type_id = p_document_type_id;
2811:
2812: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');
2813: hr_utility.set_message_token('TYPE', l_document_type);
2814: hr_utility.set_message_token('DATE_FROM', p_date_from);
2815: hr_utility.set_message_token('DATE_TO', p_date_to);
2816: p_return_status := hr_utility.hr_error_number||hr_utility.get_message;
2817:

Line 2814: hr_utility.set_message_token('DATE_FROM', p_date_from);

2810: where document_type_id = p_document_type_id;
2811:
2812: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');
2813: hr_utility.set_message_token('TYPE', l_document_type);
2814: hr_utility.set_message_token('DATE_FROM', p_date_from);
2815: hr_utility.set_message_token('DATE_TO', p_date_to);
2816: p_return_status := hr_utility.hr_error_number||hr_utility.get_message;
2817:
2818: else

Line 2815: hr_utility.set_message_token('DATE_TO', p_date_to);

2811:
2812: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');
2813: hr_utility.set_message_token('TYPE', l_document_type);
2814: hr_utility.set_message_token('DATE_FROM', p_date_from);
2815: hr_utility.set_message_token('DATE_TO', p_date_to);
2816: p_return_status := hr_utility.hr_error_number||hr_utility.get_message;
2817:
2818: else
2819: close csr_chk_duplicate_txn;

Line 2816: p_return_status := hr_utility.hr_error_number||hr_utility.get_message;

2812: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');
2813: hr_utility.set_message_token('TYPE', l_document_type);
2814: hr_utility.set_message_token('DATE_FROM', p_date_from);
2815: hr_utility.set_message_token('DATE_TO', p_date_to);
2816: p_return_status := hr_utility.hr_error_number||hr_utility.get_message;
2817:
2818: else
2819: close csr_chk_duplicate_txn;
2820: --fix FOR BUG 15835786

Line 2824: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');

2820: --fix FOR BUG 15835786
2821: fetch csr_chk_doc_number into l_num1;
2822: if l_num1 > 0 then
2823: close csr_chk_doc_number;
2824: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');
2825: hr_utility.set_message_token('TYPE', p_document_number);
2826: hr_utility.set_message_token('DATE_FROM', p_date_from);
2827: hr_utility.set_message_token('DATE_TO', p_date_to);
2828: p_return_status := hr_utility.hr_error_number||hr_utility.get_message;

Line 2825: hr_utility.set_message_token('TYPE', p_document_number);

2821: fetch csr_chk_doc_number into l_num1;
2822: if l_num1 > 0 then
2823: close csr_chk_doc_number;
2824: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');
2825: hr_utility.set_message_token('TYPE', p_document_number);
2826: hr_utility.set_message_token('DATE_FROM', p_date_from);
2827: hr_utility.set_message_token('DATE_TO', p_date_to);
2828: p_return_status := hr_utility.hr_error_number||hr_utility.get_message;
2829:

Line 2826: hr_utility.set_message_token('DATE_FROM', p_date_from);

2822: if l_num1 > 0 then
2823: close csr_chk_doc_number;
2824: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');
2825: hr_utility.set_message_token('TYPE', p_document_number);
2826: hr_utility.set_message_token('DATE_FROM', p_date_from);
2827: hr_utility.set_message_token('DATE_TO', p_date_to);
2828: p_return_status := hr_utility.hr_error_number||hr_utility.get_message;
2829:
2830: else

Line 2827: hr_utility.set_message_token('DATE_TO', p_date_to);

2823: close csr_chk_doc_number;
2824: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');
2825: hr_utility.set_message_token('TYPE', p_document_number);
2826: hr_utility.set_message_token('DATE_FROM', p_date_from);
2827: hr_utility.set_message_token('DATE_TO', p_date_to);
2828: p_return_status := hr_utility.hr_error_number||hr_utility.get_message;
2829:
2830: else
2831: close csr_chk_doc_number;

Line 2828: p_return_status := hr_utility.hr_error_number||hr_utility.get_message;

2824: hr_utility.set_message(800, 'HR_449708_DOR_UNQ_PER_DOC');
2825: hr_utility.set_message_token('TYPE', p_document_number);
2826: hr_utility.set_message_token('DATE_FROM', p_date_from);
2827: hr_utility.set_message_token('DATE_TO', p_date_to);
2828: p_return_status := hr_utility.hr_error_number||hr_utility.get_message;
2829:
2830: else
2831: close csr_chk_doc_number;
2832:

Line 2838: hr_utility.raise_error;

2834: --FIX FOR BUG 15835786
2835: end if;
2836:
2837: if p_return_status = 'E' then
2838: hr_utility.raise_error;
2839: end if;
2840:
2841:
2842: EXCEPTION

Line 2845: hr_utility.trace('Exception in g_data_error in hr_dor_review_ss.validate_dor ' || SQLERRM );

2841:
2842: EXCEPTION
2843:
2844: WHEN g_data_error THEN
2845: hr_utility.trace('Exception in g_data_error in hr_dor_review_ss.validate_dor ' || SQLERRM );
2846: hr_utility.set_location(' Leaving:' || l_proc,555);
2847: p_return_status := SQLERRM;
2848: raise;
2849:

Line 2846: hr_utility.set_location(' Leaving:' || l_proc,555);

2842: EXCEPTION
2843:
2844: WHEN g_data_error THEN
2845: hr_utility.trace('Exception in g_data_error in hr_dor_review_ss.validate_dor ' || SQLERRM );
2846: hr_utility.set_location(' Leaving:' || l_proc,555);
2847: p_return_status := SQLERRM;
2848: raise;
2849:
2850: WHEN hr_utility.hr_error THEN

Line 2850: WHEN hr_utility.hr_error THEN

2846: hr_utility.set_location(' Leaving:' || l_proc,555);
2847: p_return_status := SQLERRM;
2848: raise;
2849:
2850: WHEN hr_utility.hr_error THEN
2851: hr_utility.get_message_details(msg_name,msg_appl);
2852: fnd_message.set_name(msg_appl,msg_name);
2853: p_return_status := hr_utility.get_message;
2854: hr_utility.set_location(p_return_status,566);

Line 2851: hr_utility.get_message_details(msg_name,msg_appl);

2847: p_return_status := SQLERRM;
2848: raise;
2849:
2850: WHEN hr_utility.hr_error THEN
2851: hr_utility.get_message_details(msg_name,msg_appl);
2852: fnd_message.set_name(msg_appl,msg_name);
2853: p_return_status := hr_utility.get_message;
2854: hr_utility.set_location(p_return_status,566);
2855:

Line 2853: p_return_status := hr_utility.get_message;

2849:
2850: WHEN hr_utility.hr_error THEN
2851: hr_utility.get_message_details(msg_name,msg_appl);
2852: fnd_message.set_name(msg_appl,msg_name);
2853: p_return_status := hr_utility.get_message;
2854: hr_utility.set_location(p_return_status,566);
2855:
2856: WHEN OTHERS THEN
2857: hr_utility.trace('When others exception in hr_dor_review_ss.validate_dor ' || SQLERRM );

Line 2854: hr_utility.set_location(p_return_status,566);

2850: WHEN hr_utility.hr_error THEN
2851: hr_utility.get_message_details(msg_name,msg_appl);
2852: fnd_message.set_name(msg_appl,msg_name);
2853: p_return_status := hr_utility.get_message;
2854: hr_utility.set_location(p_return_status,566);
2855:
2856: WHEN OTHERS THEN
2857: hr_utility.trace('When others exception in hr_dor_review_ss.validate_dor ' || SQLERRM );
2858: hr_utility.set_location(' Leaving:' || l_proc,560);

Line 2857: hr_utility.trace('When others exception in hr_dor_review_ss.validate_dor ' || SQLERRM );

2853: p_return_status := hr_utility.get_message;
2854: hr_utility.set_location(p_return_status,566);
2855:
2856: WHEN OTHERS THEN
2857: hr_utility.trace('When others exception in hr_dor_review_ss.validate_dor ' || SQLERRM );
2858: hr_utility.set_location(' Leaving:' || l_proc,560);
2859: p_return_status := SQLERRM;
2860: raise;
2861:

Line 2858: hr_utility.set_location(' Leaving:' || l_proc,560);

2854: hr_utility.set_location(p_return_status,566);
2855:
2856: WHEN OTHERS THEN
2857: hr_utility.trace('When others exception in hr_dor_review_ss.validate_dor ' || SQLERRM );
2858: hr_utility.set_location(' Leaving:' || l_proc,560);
2859: p_return_status := SQLERRM;
2860: raise;
2861:
2862:

Line 2884: hr_utility.set_location(' Entering:' || l_proc,60);

2880: l_proc varchar2(72) := g_package ||'get_review_data_from_tt';
2881:
2882: BEGIN
2883:
2884: hr_utility.set_location(' Entering:' || l_proc,60);
2885:
2886: p_dor_rec.person_id :=
2887: hr_transaction_api.get_number_value
2888: (p_transaction_step_id => p_transaction_step_id

Line 3299: hr_utility.trace('Exception in g_data_error in '||l_proc||','|| SQLERRM );

3295:
3296: EXCEPTION
3297:
3298: WHEN g_data_error THEN
3299: hr_utility.trace('Exception in g_data_error in '||l_proc||','|| SQLERRM );
3300: hr_utility.set_location(' Leaving:' || l_proc,666);
3301: raise;
3302:
3303: WHEN OTHERS THEN

Line 3300: hr_utility.set_location(' Leaving:' || l_proc,666);

3296: EXCEPTION
3297:
3298: WHEN g_data_error THEN
3299: hr_utility.trace('Exception in g_data_error in '||l_proc||','|| SQLERRM );
3300: hr_utility.set_location(' Leaving:' || l_proc,666);
3301: raise;
3302:
3303: WHEN OTHERS THEN
3304: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );

Line 3304: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );

3300: hr_utility.set_location(' Leaving:' || l_proc,666);
3301: raise;
3302:
3303: WHEN OTHERS THEN
3304: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );
3305: hr_utility.set_location(' Leaving:' || l_proc,660);
3306: raise ;
3307:
3308:

Line 3305: hr_utility.set_location(' Leaving:' || l_proc,660);

3301: raise;
3302:
3303: WHEN OTHERS THEN
3304: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );
3305: hr_utility.set_location(' Leaving:' || l_proc,660);
3306: raise ;
3307:
3308:
3309: END get_review_data_from_tt;

Line 3425: --hr_utility.trace_on(null,'ORCL1');

3421: l_status varchar2(10);
3422:
3423: BEGIN
3424:
3425: --hr_utility.trace_on(null,'ORCL1');
3426: hr_utility.set_location(' Entering:' || l_proc,70);
3427: p_transaction_id := get_transaction_id(p_transaction_step_id);
3428:
3429: begin

Line 3426: hr_utility.set_location(' Entering:' || l_proc,70);

3422:
3423: BEGIN
3424:
3425: --hr_utility.trace_on(null,'ORCL1');
3426: hr_utility.set_location(' Entering:' || l_proc,70);
3427: p_transaction_id := get_transaction_id(p_transaction_step_id);
3428:
3429: begin
3430: select status into l_status

Line 3555: hr_utility.set_location(' Entering:' || l_proc,72);

3551: else
3552: l_country_name := null;
3553: end if;
3554:
3555: hr_utility.set_location(' Entering:' || l_proc,72);
3556:
3557: p_document_type := l_document_type;
3558: p_category_name := l_category_name;
3559: p_sub_category_name := l_sub_category_name;

Line 3578: hr_utility.raise_error;

3574:
3575: commit;
3576:
3577: if p_return_status = 'E' then
3578: hr_utility.raise_error;
3579: else
3580: p_return_status := 'S';
3581: end if;
3582:

Line 3587: hr_utility.trace('Exception in g_data_error in '||l_proc||','|| SQLERRM );

3583:
3584: EXCEPTION
3585:
3586: WHEN g_data_error THEN
3587: hr_utility.trace('Exception in g_data_error in '||l_proc||','|| SQLERRM );
3588: hr_utility.set_location(' Leaving:' || l_proc,777);
3589: p_return_status := SQLERRM;
3590:
3591: WHEN hr_utility.hr_error THEN

Line 3588: hr_utility.set_location(' Leaving:' || l_proc,777);

3584: EXCEPTION
3585:
3586: WHEN g_data_error THEN
3587: hr_utility.trace('Exception in g_data_error in '||l_proc||','|| SQLERRM );
3588: hr_utility.set_location(' Leaving:' || l_proc,777);
3589: p_return_status := SQLERRM;
3590:
3591: WHEN hr_utility.hr_error THEN
3592: hr_utility.get_message_details(msg_name,msg_appl);

Line 3591: WHEN hr_utility.hr_error THEN

3587: hr_utility.trace('Exception in g_data_error in '||l_proc||','|| SQLERRM );
3588: hr_utility.set_location(' Leaving:' || l_proc,777);
3589: p_return_status := SQLERRM;
3590:
3591: WHEN hr_utility.hr_error THEN
3592: hr_utility.get_message_details(msg_name,msg_appl);
3593: fnd_message.set_name(msg_appl,msg_name);
3594: p_return_status := hr_utility.get_message;
3595:

Line 3592: hr_utility.get_message_details(msg_name,msg_appl);

3588: hr_utility.set_location(' Leaving:' || l_proc,777);
3589: p_return_status := SQLERRM;
3590:
3591: WHEN hr_utility.hr_error THEN
3592: hr_utility.get_message_details(msg_name,msg_appl);
3593: fnd_message.set_name(msg_appl,msg_name);
3594: p_return_status := hr_utility.get_message;
3595:
3596: WHEN OTHERS THEN

Line 3594: p_return_status := hr_utility.get_message;

3590:
3591: WHEN hr_utility.hr_error THEN
3592: hr_utility.get_message_details(msg_name,msg_appl);
3593: fnd_message.set_name(msg_appl,msg_name);
3594: p_return_status := hr_utility.get_message;
3595:
3596: WHEN OTHERS THEN
3597: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );
3598: hr_utility.set_location(' Leaving:' || l_proc,770);

Line 3597: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );

3593: fnd_message.set_name(msg_appl,msg_name);
3594: p_return_status := hr_utility.get_message;
3595:
3596: WHEN OTHERS THEN
3597: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );
3598: hr_utility.set_location(' Leaving:' || l_proc,770);
3599: p_return_status := SQLERRM;
3600:
3601: END get_transaction_values;

Line 3598: hr_utility.set_location(' Leaving:' || l_proc,770);

3594: p_return_status := hr_utility.get_message;
3595:
3596: WHEN OTHERS THEN
3597: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );
3598: hr_utility.set_location(' Leaving:' || l_proc,770);
3599: p_return_status := SQLERRM;
3600:
3601: END get_transaction_values;
3602:

Line 3635: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 1);

3631:
3632:
3633: BEGIN
3634:
3635: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 1);
3636:
3637: p_entity_name := 'R_DOCUMENT_EXTRA_INFO' ;
3638:
3639:

Line 3661: hr_utility.raise_error;

3657:
3658: end if;
3659: commit;
3660: if p_return_status = 'E' then
3661: hr_utility.raise_error;
3662: else
3663: p_return_status := 'S';
3664: end if;
3665:

Line 3666: hr_utility.set_location('Leaving:'|| g_package||'.'||l_proc, 2);

3662: else
3663: p_return_status := 'S';
3664: end if;
3665:
3666: hr_utility.set_location('Leaving:'|| g_package||'.'||l_proc, 2);
3667:
3668: EXCEPTION
3669:
3670: WHEN hr_utility.hr_error THEN

Line 3670: WHEN hr_utility.hr_error THEN

3666: hr_utility.set_location('Leaving:'|| g_package||'.'||l_proc, 2);
3667:
3668: EXCEPTION
3669:
3670: WHEN hr_utility.hr_error THEN
3671: hr_utility.get_message_details(msg_name,msg_appl);
3672: fnd_message.set_name(msg_appl,msg_name);
3673: p_return_status := hr_utility.get_message;
3674: when others then

Line 3671: hr_utility.get_message_details(msg_name,msg_appl);

3667:
3668: EXCEPTION
3669:
3670: WHEN hr_utility.hr_error THEN
3671: hr_utility.get_message_details(msg_name,msg_appl);
3672: fnd_message.set_name(msg_appl,msg_name);
3673: p_return_status := hr_utility.get_message;
3674: when others then
3675: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );

Line 3673: p_return_status := hr_utility.get_message;

3669:
3670: WHEN hr_utility.hr_error THEN
3671: hr_utility.get_message_details(msg_name,msg_appl);
3672: fnd_message.set_name(msg_appl,msg_name);
3673: p_return_status := hr_utility.get_message;
3674: when others then
3675: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );
3676: hr_utility.set_location(' Leaving:' || l_proc,770);
3677: p_return_status := SQLERRM;

Line 3675: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );

3671: hr_utility.get_message_details(msg_name,msg_appl);
3672: fnd_message.set_name(msg_appl,msg_name);
3673: p_return_status := hr_utility.get_message;
3674: when others then
3675: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );
3676: hr_utility.set_location(' Leaving:' || l_proc,770);
3677: p_return_status := SQLERRM;
3678:
3679:

Line 3676: hr_utility.set_location(' Leaving:' || l_proc,770);

3672: fnd_message.set_name(msg_appl,msg_name);
3673: p_return_status := hr_utility.get_message;
3674: when others then
3675: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );
3676: hr_utility.set_location(' Leaving:' || l_proc,770);
3677: p_return_status := SQLERRM;
3678:
3679:
3680: END save_attachments;

Line 3719: hr_utility.set_location(' Entering:' || l_proc,10);

3715: l_attached_doc_pre_upd csr_get_attached_doc%rowtype;
3716: l_doc_pre_upd csr_get_doc%rowtype;
3717: l_doc_tl_pre_upd csr_get_doc_tl%rowtype;
3718: Begin
3719: hr_utility.set_location(' Entering:' || l_proc,10);
3720: select userenv('LANG') into l_language from dual;
3721: Open csr_get_attached_doc;
3722: fetch csr_get_attached_doc into l_attached_doc_pre_upd;
3723: IF csr_get_attached_doc%NOTFOUND THEN

Line 3743: hr_utility.set_location(' before fnd_attached_documents_pkg.lock_row :' || l_proc,20);

3739: close csr_get_doc_tl;
3740: raise data_error;
3741: END IF;
3742:
3743: hr_utility.set_location(' before fnd_attached_documents_pkg.lock_row :' || l_proc,20);
3744: fnd_attached_documents_pkg.lock_row
3745: (x_rowid => p_rowid
3746: ,x_attached_document_id =>
3747: l_attached_doc_pre_upd.attached_document_id

Line 3812: hr_utility.set_location(' before fnd_attached_documents_pkg.update_row :' || l_proc,30);

3808: ,x_title => l_doc_tl_pre_upd.title
3809: );
3810:
3811:
3812: hr_utility.set_location(' before fnd_attached_documents_pkg.update_row :' || l_proc,30);
3813:
3814:
3815: fnd_attached_documents_pkg.update_row
3816: (x_rowid => p_rowid

Line 3885: hr_utility.set_location(' after fnd_attached_documents_pkg.update_row :' || l_proc,40);

3881: ,x_url => l_doc_pre_upd.url
3882: ,x_title => l_doc_tl_pre_upd.title
3883: );
3884:
3885: hr_utility.set_location(' after fnd_attached_documents_pkg.update_row :' || l_proc,40);
3886: hr_utility.set_location(' Leaving:' || l_proc,50);
3887:
3888: EXCEPTION
3889: when others then

Line 3886: hr_utility.set_location(' Leaving:' || l_proc,50);

3882: ,x_title => l_doc_tl_pre_upd.title
3883: );
3884:
3885: hr_utility.set_location(' after fnd_attached_documents_pkg.update_row :' || l_proc,40);
3886: hr_utility.set_location(' Leaving:' || l_proc,50);
3887:
3888: EXCEPTION
3889: when others then
3890: hr_utility.set_location(' Error in :' || l_proc,60);

Line 3890: hr_utility.set_location(' Error in :' || l_proc,60);

3886: hr_utility.set_location(' Leaving:' || l_proc,50);
3887:
3888: EXCEPTION
3889: when others then
3890: hr_utility.set_location(' Error in :' || l_proc,60);
3891: raise;
3892: End update_attachment;
3893: /*==========================================================================
3894: This procedure will abort the workflow process and update the

Line 3905: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 1);

3901: l_proc varchar2(50) := 'delete_transaction';
3902:
3903: BEGIN
3904:
3905: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 1);
3906:
3907: select item_type,item_key into
3908: p_item_type,p_item_key
3909: from hr_api_transactions

Line 3918: hr_utility.set_location('Leaving:'|| g_package||'.'||l_proc, 2);

3914:
3915: hr_transaction_api.rollback_transaction
3916: (p_transaction_id => p_transaction_id);
3917:
3918: hr_utility.set_location('Leaving:'|| g_package||'.'||l_proc, 2);
3919:
3920: EXCEPTION
3921: when others then
3922: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );

Line 3922: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );

3918: hr_utility.set_location('Leaving:'|| g_package||'.'||l_proc, 2);
3919:
3920: EXCEPTION
3921: when others then
3922: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );
3923: hr_utility.set_location(' Leaving:' || l_proc,770);
3924: raise;
3925:
3926: END delete_transaction;

Line 3923: hr_utility.set_location(' Leaving:' || l_proc,770);

3919:
3920: EXCEPTION
3921: when others then
3922: hr_utility.trace('When others exception in ' ||l_proc||','|| SQLERRM );
3923: hr_utility.set_location(' Leaving:' || l_proc,770);
3924: raise;
3925:
3926: END delete_transaction;
3927:

Line 3998: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

3994:
3995: begin
3996:
3997:
3998: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
3999:
4000: if p_document_extra_info_id is null then
4001: -- for now this will only allow for transaction owner to update
4002:

Line 4014: hr_utility.set_location('p_transaction_id is null' , 1);

4010: end if;
4011: elsif p_transaction_id is null then
4012: open c_transaction;
4013: fetch c_transaction into ltransaction_id;
4014: hr_utility.set_location('p_transaction_id is null' , 1);
4015: --fix for bug 14848787
4016: begin
4017: hr_utility.set_location('ltransaction_id saketi'|| ltransaction_id , 1);
4018: select 'X' into dummy from fnd_form_functions where function_id = ltransaction_id

Line 4017: hr_utility.set_location('ltransaction_id saketi'|| ltransaction_id , 1);

4013: fetch c_transaction into ltransaction_id;
4014: hr_utility.set_location('p_transaction_id is null' , 1);
4015: --fix for bug 14848787
4016: begin
4017: hr_utility.set_location('ltransaction_id saketi'|| ltransaction_id , 1);
4018: select 'X' into dummy from fnd_form_functions where function_id = ltransaction_id
4019: and parameters like '%pNtfFyiDetails=Y%';
4020: hr_utility.set_location('dummy saketi'|| dummy , 1);
4021: dummy := null;

Line 4020: hr_utility.set_location('dummy saketi'|| dummy , 1);

4016: begin
4017: hr_utility.set_location('ltransaction_id saketi'|| ltransaction_id , 1);
4018: select 'X' into dummy from fnd_form_functions where function_id = ltransaction_id
4019: and parameters like '%pNtfFyiDetails=Y%';
4020: hr_utility.set_location('dummy saketi'|| dummy , 1);
4021: dummy := null;
4022: pNtfFyiDetails := 'Y';
4023: exception
4024: when NO_DATA_FOUND then

Line 4025: hr_utility.set_location('No data found' , 1);

4021: dummy := null;
4022: pNtfFyiDetails := 'Y';
4023: exception
4024: when NO_DATA_FOUND then
4025: hr_utility.set_location('No data found' , 1);
4026: pNtfFyiDetails := 'N';
4027: end;
4028: --emd of fix for bug 14848787
4029: if pNtfFyiDetails = 'Y' then

Line 4031: hr_utility.set_location('pNtfFyiDetails is Y' , 1);

4027: end;
4028: --emd of fix for bug 14848787
4029: if pNtfFyiDetails = 'Y' then
4030: close c_transaction;
4031: hr_utility.set_location('pNtfFyiDetails is Y' , 1);
4032: dor_UpdateAllowed := 'HrUpdateEnabled';
4033: else --fix
4034: hr_utility.set_location('pNtfFyiDetails is N' , 1);
4035: --open c_transaction;

Line 4034: hr_utility.set_location('pNtfFyiDetails is N' , 1);

4030: close c_transaction;
4031: hr_utility.set_location('pNtfFyiDetails is Y' , 1);
4032: dor_UpdateAllowed := 'HrUpdateEnabled';
4033: else --fix
4034: hr_utility.set_location('pNtfFyiDetails is N' , 1);
4035: --open c_transaction;
4036: --fetch c_transaction into ltransaction_id;
4037:
4038: if c_transaction%found then

Line 4050: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);

4046: end if;
4047:
4048: return dor_UpdateAllowed;
4049:
4050: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
4051:
4052:
4053: exception
4054: when others then

Line 4055: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

4051:
4052:
4053: exception
4054: when others then
4055: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
4056: Wf_Core.Context(g_package, c_proc, p_transaction_id);
4057: raise;
4058: end isUpdateAllowed;
4059:

Line 4071: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

4067: pvalue varchar2(30);
4068:
4069: begin
4070:
4071: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
4072:
4073:
4074: -- for now this will only allow for transaction owner to update
4075:

Line 4092: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);

4088: end if;
4089:
4090: return dor_DeleteAllowed;
4091:
4092: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
4093:
4094:
4095: exception
4096: when others then

Line 4097: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

4093:
4094:
4095: exception
4096: when others then
4097: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
4098: Wf_Core.Context(g_package, c_proc, p_transaction_id);
4099: raise;
4100:
4101: end isDeleteAllowed;

Line 4112: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

4108: c_proc constant varchar2(30) := 'isAttachAllowed';
4109: dor_AttachAllowed varchar2(30);
4110: begin
4111:
4112: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
4113:
4114:
4115: -- for now this will only allow for transaction owner to update
4116:

Line 4128: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);

4124: end if;
4125:
4126: return dor_AttachAllowed;
4127:
4128: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
4129:
4130:
4131: exception
4132: when others then

Line 4133: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

4129:
4130:
4131: exception
4132: when others then
4133: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
4134: Wf_Core.Context(g_package, c_proc, p_transaction_id);
4135: raise;
4136:
4137: end isAttachAllowed;

Line 4216: hr_utility.set_location('Entering:'|| l_proc, 5);

4212: where hats.transaction_step_id = p_transaction_step_id;
4213:
4214: begin
4215:
4216: hr_utility.set_location('Entering:'|| l_proc, 5);
4217:
4218: open csr_hats;
4219: hr_utility.trace('Going into Fetch after (open csr_hats ): '|| l_proc);
4220: fetch csr_hats into l_transaction_id;

Line 4219: hr_utility.trace('Going into Fetch after (open csr_hats ): '|| l_proc);

4215:
4216: hr_utility.set_location('Entering:'|| l_proc, 5);
4217:
4218: open csr_hats;
4219: hr_utility.trace('Going into Fetch after (open csr_hats ): '|| l_proc);
4220: fetch csr_hats into l_transaction_id;
4221: if csr_hats%notfound then
4222: -- the transaction step doesn't exist
4223: close csr_hats;

Line 4224: hr_utility.set_message(801, 'HR_51751_WEB_TRA_STEP_EXISTS');

4220: fetch csr_hats into l_transaction_id;
4221: if csr_hats%notfound then
4222: -- the transaction step doesn't exist
4223: close csr_hats;
4224: hr_utility.set_message(801, 'HR_51751_WEB_TRA_STEP_EXISTS');
4225: hr_utility.raise_error;
4226: end if;
4227: close csr_hats;
4228: hr_utility.set_location(' Leaving:'||l_proc, 15);

Line 4225: hr_utility.raise_error;

4221: if csr_hats%notfound then
4222: -- the transaction step doesn't exist
4223: close csr_hats;
4224: hr_utility.set_message(801, 'HR_51751_WEB_TRA_STEP_EXISTS');
4225: hr_utility.raise_error;
4226: end if;
4227: close csr_hats;
4228: hr_utility.set_location(' Leaving:'||l_proc, 15);
4229: return(l_transaction_id);

Line 4228: hr_utility.set_location(' Leaving:'||l_proc, 15);

4224: hr_utility.set_message(801, 'HR_51751_WEB_TRA_STEP_EXISTS');
4225: hr_utility.raise_error;
4226: end if;
4227: close csr_hats;
4228: hr_utility.set_location(' Leaving:'||l_proc, 15);
4229: return(l_transaction_id);
4230:
4231: hr_utility.set_location(' Leaving:'||l_proc, 20);
4232:

Line 4231: hr_utility.set_location(' Leaving:'||l_proc, 20);

4227: close csr_hats;
4228: hr_utility.set_location(' Leaving:'||l_proc, 15);
4229: return(l_transaction_id);
4230:
4231: hr_utility.set_location(' Leaving:'||l_proc, 20);
4232:
4233: end get_transaction_id;
4234:
4235: PROCEDURE block_for_transaction (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,

Line 4269: hr_utility.set_location('ENTERING exception block_for_transaction', 10);

4265: RETURN;
4266: END IF;
4267: Exception
4268: when others then
4269: hr_utility.set_location('ENTERING exception block_for_transaction', 10);
4270:
4271:
4272: end block_for_transaction;
4273:

Line 4286: hr_utility.set_location('Entered hr_dor_review_ss.create_bprv_block',10);

4282: l_item_value varchar2(200);
4283: l_result_out varchar2(400);
4284:
4285: BEGIN
4286: hr_utility.set_location('Entered hr_dor_review_ss.create_bprv_block',10);
4287: hr_utility.set_location('create_bprv_block - funcmode = '||funcmode,20);
4288: IF (funcmode='RUN') THEN
4289: hr_utility.set_location('create_bprv_block - funcmode = '||funcmode,30);
4290: wf_engine.AddItemAttr(itemtype => itemtype,

Line 4287: hr_utility.set_location('create_bprv_block - funcmode = '||funcmode,20);

4283: l_result_out varchar2(400);
4284:
4285: BEGIN
4286: hr_utility.set_location('Entered hr_dor_review_ss.create_bprv_block',10);
4287: hr_utility.set_location('create_bprv_block - funcmode = '||funcmode,20);
4288: IF (funcmode='RUN') THEN
4289: hr_utility.set_location('create_bprv_block - funcmode = '||funcmode,30);
4290: wf_engine.AddItemAttr(itemtype => itemtype,
4291: itemkey => itemkey,

Line 4289: hr_utility.set_location('create_bprv_block - funcmode = '||funcmode,30);

4285: BEGIN
4286: hr_utility.set_location('Entered hr_dor_review_ss.create_bprv_block',10);
4287: hr_utility.set_location('create_bprv_block - funcmode = '||funcmode,20);
4288: IF (funcmode='RUN') THEN
4289: hr_utility.set_location('create_bprv_block - funcmode = '||funcmode,30);
4290: wf_engine.AddItemAttr(itemtype => itemtype,
4291: itemkey => itemkey,
4292: aname => 'CREATE_TRN_BPRV_BLOCK',
4293: text_value => actid,

Line 4296: hr_utility.set_location('create_bprv_block - funcmode = '||funcmode,40);

4292: aname => 'CREATE_TRN_BPRV_BLOCK',
4293: text_value => actid,
4294: number_value => null,
4295: date_value => null);
4296: hr_utility.set_location('create_bprv_block - funcmode = '||funcmode,40);
4297: WF_STANDARD.Block(itemtype => itemtype,
4298: itemkey => itemkey,
4299: actid => itemkey,
4300: funcmode => funcmode,

Line 4302: hr_utility.set_location('create_bprv_block - l_result_out = '||l_result_out,50);

4298: itemkey => itemkey,
4299: actid => itemkey,
4300: funcmode => funcmode,
4301: resultout => l_result_out);
4302: hr_utility.set_location('create_bprv_block - l_result_out = '||l_result_out,50);
4303: resultout := l_result_out;
4304: hr_utility.set_location('create_bprv_block ',60);
4305: END IF;
4306: hr_utility.set_location('create_bprv_block - ',70);

Line 4304: hr_utility.set_location('create_bprv_block ',60);

4300: funcmode => funcmode,
4301: resultout => l_result_out);
4302: hr_utility.set_location('create_bprv_block - l_result_out = '||l_result_out,50);
4303: resultout := l_result_out;
4304: hr_utility.set_location('create_bprv_block ',60);
4305: END IF;
4306: hr_utility.set_location('create_bprv_block - ',70);
4307: IF (funcmode='CANCEL') THEN
4308: hr_utility.set_location('create_bprv_block - funcmode = '||funcmode,80);

Line 4306: hr_utility.set_location('create_bprv_block - ',70);

4302: hr_utility.set_location('create_bprv_block - l_result_out = '||l_result_out,50);
4303: resultout := l_result_out;
4304: hr_utility.set_location('create_bprv_block ',60);
4305: END IF;
4306: hr_utility.set_location('create_bprv_block - ',70);
4307: IF (funcmode='CANCEL') THEN
4308: hr_utility.set_location('create_bprv_block - funcmode = '||funcmode,80);
4309: resultout:='COMPLETE';
4310: hr_utility.set_location('create_bprv_block - resultout = '||resultout,90);

Line 4308: hr_utility.set_location('create_bprv_block - funcmode = '||funcmode,80);

4304: hr_utility.set_location('create_bprv_block ',60);
4305: END IF;
4306: hr_utility.set_location('create_bprv_block - ',70);
4307: IF (funcmode='CANCEL') THEN
4308: hr_utility.set_location('create_bprv_block - funcmode = '||funcmode,80);
4309: resultout:='COMPLETE';
4310: hr_utility.set_location('create_bprv_block - resultout = '||resultout,90);
4311: RETURN;
4312: END IF;

Line 4310: hr_utility.set_location('create_bprv_block - resultout = '||resultout,90);

4306: hr_utility.set_location('create_bprv_block - ',70);
4307: IF (funcmode='CANCEL') THEN
4308: hr_utility.set_location('create_bprv_block - funcmode = '||funcmode,80);
4309: resultout:='COMPLETE';
4310: hr_utility.set_location('create_bprv_block - resultout = '||resultout,90);
4311: RETURN;
4312: END IF;
4313: Exception
4314: when others then

Line 4315: hr_utility.set_location('ENTERING exception create_bprv_block', 100);

4311: RETURN;
4312: END IF;
4313: Exception
4314: when others then
4315: hr_utility.set_location('ENTERING exception create_bprv_block', 100);
4316:
4317:
4318: end create_bprv_block;
4319: