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_TRANSACTION_API dependencies on HR_UTILITY

Line 7: g_debug boolean := hr_utility.debug_enabled;

3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'hr_transaction_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8: -- ----------------------------------------------------------------------------
9: -- |----------------------< get_transaction_step_info >-----------------------|
10: -- ----------------------------------------------------------------------------
11: procedure get_transaction_step_info

Line 31: g_debug := hr_utility.debug_enabled;

27: and hats.item_key = p_item_key
28: and hats.activity_id = p_activity_id;
29: --
30: begin
31: g_debug := hr_utility.debug_enabled;
32:
33: IF g_debug THEN
34: hr_utility.set_location('Entering:'|| l_proc, 5);
35: END IF;

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

30: begin
31: g_debug := hr_utility.debug_enabled;
32:
33: IF g_debug THEN
34: hr_utility.set_location('Entering:'|| l_proc, 5);
35: END IF;
36:
37: -- open the cursor
38: open csr_hats;

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

35: END IF;
36:
37: -- open the cursor
38: open csr_hats;
39: hr_utility.trace('Going into Fetch after (open csr_hats ): '|| l_proc);
40: fetch csr_hats into p_transaction_step_id, p_object_version_number;
41: if csr_hats%notfound then
42: -- transaction step does not exist
43: p_transaction_step_id := null;

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

45: end if;
46: close csr_hats;
47:
48: IF g_debug THEN
49: hr_utility.set_location(' Leaving:'||l_proc, 15);
50: END IF;
51:
52: end get_transaction_step_info;
53: -- --------------------------------------------------------------------

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

78: l_data csr_hats%rowtype;
79: l_proc constant varchar2(100) := g_package || ' get_transaction_step_info';
80: --
81: begin
82: hr_utility.set_location('Entering: '|| l_proc,5);
83: g_debug := hr_utility.debug_enabled;
84: l_index := 0;
85: open csr_hats;
86: loop

Line 83: g_debug := hr_utility.debug_enabled;

79: l_proc constant varchar2(100) := g_package || ' get_transaction_step_info';
80: --
81: begin
82: hr_utility.set_location('Entering: '|| l_proc,5);
83: g_debug := hr_utility.debug_enabled;
84: l_index := 0;
85: open csr_hats;
86: loop
87: hr_utility.trace('Going into Fetch after (open csr_hats ): '|| l_proc);

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

83: g_debug := hr_utility.debug_enabled;
84: l_index := 0;
85: open csr_hats;
86: loop
87: hr_utility.trace('Going into Fetch after (open csr_hats ): '|| l_proc);
88: fetch csr_hats into l_data;
89: exit when csr_hats%notfound;
90: p_transaction_step_id(l_index) := to_char(l_data.transaction_step_id);
91: p_object_version_number(l_index) := to_char(l_data.object_version_number

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

93: l_index := l_index + 1;
94: end loop;
95: close csr_hats;
96: p_rows := l_index;
97: hr_utility.set_location('Leaving: '|| l_proc,15);
98: end get_transaction_step_info;
99: -- --------------------------------------------------------------------
100: -- ------------------<< get_transaction_step_info >>-------------------
101: -- --------------------------------------------------------------------

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

122: l_data csr_hats%rowtype;
123: l_proc constant varchar2(100) := g_package || ' get_transaction_step_info';
124: --
125: BEGIN
126: hr_utility.set_location('Entering: '|| l_proc,5);
127: g_debug := hr_utility.debug_enabled;
128: l_index := 0;
129: open csr_hats;
130: loop

Line 127: g_debug := hr_utility.debug_enabled;

123: l_proc constant varchar2(100) := g_package || ' get_transaction_step_info';
124: --
125: BEGIN
126: hr_utility.set_location('Entering: '|| l_proc,5);
127: g_debug := hr_utility.debug_enabled;
128: l_index := 0;
129: open csr_hats;
130: loop
131: hr_utility.trace('Going into Fetch after (open csr_hats ): '|| l_proc);

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

127: g_debug := hr_utility.debug_enabled;
128: l_index := 0;
129: open csr_hats;
130: loop
131: hr_utility.trace('Going into Fetch after (open csr_hats ): '|| l_proc);
132: fetch csr_hats into l_data;
133: exit when csr_hats%notfound;
134: p_transaction_step_id(l_index) := to_char(l_data.transaction_step_id);
135: p_object_version_number(l_index) := to_char(l_data.object_version_number);

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

136: l_index := l_index + 1;
137: end loop;
138: close csr_hats;
139: p_rows := l_index;
140: hr_utility.set_location('Leaving: '|| l_proc,15);
141: end get_transaction_step_info;
142: --
143: -- ----------------------------------------------------------------------------
144: -- |----------------------< get_transaction_step_info >-----------------------|

Line 164: g_debug := hr_utility.debug_enabled;

160: from hr_api_transaction_steps hats
161: where hats.transaction_step_id = p_transaction_step_id;
162: --
163: begin
164: g_debug := hr_utility.debug_enabled;
165:
166: IF g_debug THEN
167: -- l_proc := g_package||'get_transaction_step_info';
168: hr_utility.set_location('Entering:'|| l_proc, 5);

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

164: g_debug := hr_utility.debug_enabled;
165:
166: IF g_debug THEN
167: -- l_proc := g_package||'get_transaction_step_info';
168: hr_utility.set_location('Entering:'|| l_proc, 5);
169: END IF;
170:
171: -- open the cursor
172: open csr_hats;

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

169: END IF;
170:
171: -- open the cursor
172: open csr_hats;
173: hr_utility.trace('Going into Fetch after (open csr_hats ): '|| l_proc);
174: fetch csr_hats into p_item_type, p_item_key, p_activity_id;
175: if csr_hats%notfound then
176: -- transaction step does not exist
177: p_item_type := null;

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

180: end if;
181: close csr_hats;
182:
183: IF g_debug THEN
184: hr_utility.set_location(' Leaving:'||l_proc, 15);
185: END IF;
186:
187: end get_transaction_step_info;
188: -- ----------------------------------------------------------------------------

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

224: l_proc constant varchar2(100) := g_package || ' get_transaction_step_info ';
225: --
226: begin
227:
228: hr_utility.set_location('Entering: '|| l_proc,5);
229: g_debug := hr_utility.debug_enabled;
230: l_index := 0;
231:
232: if(p_activity_id is null) then

Line 229: g_debug := hr_utility.debug_enabled;

225: --
226: begin
227:
228: hr_utility.set_location('Entering: '|| l_proc,5);
229: g_debug := hr_utility.debug_enabled;
230: l_index := 0;
231:
232: if(p_activity_id is null) then
233: open csr_hapi_nAct;

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

231:
232: if(p_activity_id is null) then
233: open csr_hapi_nAct;
234: loop
235: hr_utility.trace('Going into Fetch after (open csr_hapi_nAct ): '|| l_proc);
236: fetch csr_hapi_nAct into l_data;
237: exit when csr_hapi_nAct%notfound;
238: p_transaction_step_id(l_index) := to_char(l_data.transaction_step_id);
239: p_api_name(l_index) := l_data.api_name;

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

242: close csr_hapi_nAct;
243: else
244: open csr_hapi;
245: loop
246: hr_utility.trace('Going into Fetch after (open csr_hapi ): '|| l_proc);
247: fetch csr_hapi into l_data;
248: exit when csr_hapi%notfound;
249: p_transaction_step_id(l_index) := to_char(l_data.transaction_step_id);
250: p_api_name(l_index) := l_data.api_name;

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

254: end if;
255:
256: p_rows := l_index;
257:
258: hr_utility.set_location('Leaving: '|| l_proc,20);
259: end get_transaction_step_info;
260: -- ----------------------------------------------------------------------------
261: -- |-----------------------< transaction_step_exist >-------------------------|
262: -- ----------------------------------------------------------------------------

Line 276: g_debug := hr_utility.debug_enabled;

272: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
273: l_return boolean := true;
274: --
275: begin
276: g_debug := hr_utility.debug_enabled;
277:
278: IF g_debug THEN
279: --l_proc := g_package||'transaction_step_exist';
280: hr_utility.set_location('Entering:'|| l_proc, 5);

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

276: g_debug := hr_utility.debug_enabled;
277:
278: IF g_debug THEN
279: --l_proc := g_package||'transaction_step_exist';
280: hr_utility.set_location('Entering:'|| l_proc, 5);
281: END IF;
282:
283: -- get the transaction step info (if a step exists)
284: hr_transaction_api.get_transaction_step_info

Line 295: hr_utility.set_location('Leaving: '|| l_proc,10);

291: if l_transaction_step_id is null then
292: -- transaction step does not exist
293: l_return := false;
294: end if;
295: hr_utility.set_location('Leaving: '|| l_proc,10);
296: return(l_return);
297: end transaction_step_exist;
298: -- ----------------------------------------------------------------------------
299: -- |------------------------< get_transaction_id >----------------------------|

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

314: begin
315:
316: IF g_debug THEN
317: -- l_proc := g_package||'get_transaction_id';
318: hr_utility.set_location('Entering:'|| l_proc, 5);
319: END IF;
320:
321: open csr_hats;
322: hr_utility.trace('Going into Fetch after (open csr_hats ): '|| l_proc);

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

318: hr_utility.set_location('Entering:'|| l_proc, 5);
319: END IF;
320:
321: open csr_hats;
322: hr_utility.trace('Going into Fetch after (open csr_hats ): '|| l_proc);
323: fetch csr_hats into l_transaction_id;
324: if csr_hats%notfound then
325: -- the transaction step doesn't exist
326: close csr_hats;

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

323: fetch csr_hats into l_transaction_id;
324: if csr_hats%notfound then
325: -- the transaction step doesn't exist
326: close csr_hats;
327: hr_utility.set_message(801, 'HR_51751_WEB_TRA_STEP_EXISTS');
328: hr_utility.raise_error;
329: end if;
330: close csr_hats;
331: hr_utility.set_location(' Leaving:'||l_proc, 15);

Line 328: hr_utility.raise_error;

324: if csr_hats%notfound then
325: -- the transaction step doesn't exist
326: close csr_hats;
327: hr_utility.set_message(801, 'HR_51751_WEB_TRA_STEP_EXISTS');
328: hr_utility.raise_error;
329: end if;
330: close csr_hats;
331: hr_utility.set_location(' Leaving:'||l_proc, 15);
332: return(l_transaction_id);

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

327: hr_utility.set_message(801, 'HR_51751_WEB_TRA_STEP_EXISTS');
328: hr_utility.raise_error;
329: end if;
330: close csr_hats;
331: hr_utility.set_location(' Leaving:'||l_proc, 15);
332: return(l_transaction_id);
333:
334: IF g_debug THEN
335: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

331: hr_utility.set_location(' Leaving:'||l_proc, 15);
332: return(l_transaction_id);
333:
334: IF g_debug THEN
335: hr_utility.set_location(' Leaving:'||l_proc, 20);
336: END IF;
337:
338: end get_transaction_id;
339: -- ----------------------------------------------------------------------------

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

358: begin
359:
360: IF g_debug THEN
361: -- l_proc := g_package||'check_transaction_privilege';
362: hr_utility.set_location('Entering:'|| l_proc, 5);
363: END IF;
364:
365: open csr_hat;
366: hr_utility.trace('Going into Fetch after (open csr_hats ): '|| l_proc);

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

362: hr_utility.set_location('Entering:'|| l_proc, 5);
363: END IF;
364:
365: open csr_hat;
366: hr_utility.trace('Going into Fetch after (open csr_hats ): '|| l_proc);
367: fetch csr_hat into l_creator_person_id, l_transaction_privilege;
368: if csr_hat%notfound then
369: close csr_hat;
370: -- transaction not found

Line 371: hr_utility.set_message(801, 'HR_51752_WEB_TRANSAC_EXISTS');

367: fetch csr_hat into l_creator_person_id, l_transaction_privilege;
368: if csr_hat%notfound then
369: close csr_hat;
370: -- transaction not found
371: hr_utility.set_message(801, 'HR_51752_WEB_TRANSAC_EXISTS');
372: hr_utility.raise_error;
373: end if;
374: close csr_hat;
375: --

Line 372: hr_utility.raise_error;

368: if csr_hat%notfound then
369: close csr_hat;
370: -- transaction not found
371: hr_utility.set_message(801, 'HR_51752_WEB_TRANSAC_EXISTS');
372: hr_utility.raise_error;
373: end if;
374: close csr_hat;
375: --
376: if (l_transaction_privilege = 'PRIVATEns' and --ns

Line 380: hr_utility.set_message(801, 'HR_51753_WEB_FAIL_CREATE_STEP');

376: if (l_transaction_privilege = 'PRIVATEns' and --ns
377: l_creator_person_id <> p_person_id) then
378: -- the transaction is PRIVATE and the person who is attempting to
379: -- create the step is not the creator of the transaction
380: hr_utility.set_message(801, 'HR_51753_WEB_FAIL_CREATE_STEP');
381: hr_utility.raise_error;
382: end if;
383:
384: IF g_debug THEN

Line 381: hr_utility.raise_error;

377: l_creator_person_id <> p_person_id) then
378: -- the transaction is PRIVATE and the person who is attempting to
379: -- create the step is not the creator of the transaction
380: hr_utility.set_message(801, 'HR_51753_WEB_FAIL_CREATE_STEP');
381: hr_utility.raise_error;
382: end if;
383:
384: IF g_debug THEN
385: hr_utility.set_location(' Leaving:'||l_proc, 15);

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

381: hr_utility.raise_error;
382: end if;
383:
384: IF g_debug THEN
385: hr_utility.set_location(' Leaving:'||l_proc, 15);
386: END IF;
387:
388: end check_transaction_privilege;
389: -- ----------------------------------------------------------------------------

Line 403: g_debug := hr_utility.debug_enabled;

399: -- --------------------------------------------------------------------------
400: l_proc constant varchar2(100) := g_package || ' create_transaction';
401: --
402: begin
403: g_debug := hr_utility.debug_enabled;
404:
405: IF g_debug THEN
406: -- l_proc := g_package||'create_transaction';
407: hr_utility.set_location('Entering:'|| l_proc, 5);

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

403: g_debug := hr_utility.debug_enabled;
404:
405: IF g_debug THEN
406: -- l_proc := g_package||'create_transaction';
407: hr_utility.set_location('Entering:'|| l_proc, 5);
408: END IF;
409:
410: --
411: -- issue a savepoint if operating in validation only mode.

Line 431: hr_utility.set_location(' Leaving:'||l_proc, 10);

427: end if;
428: --
429:
430: IF g_debug THEN
431: hr_utility.set_location(' Leaving:'||l_proc, 10);
432: END IF;
433:
434: exception
435: when hr_api.validate_enabled then

Line 437: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

433:
434: exception
435: when hr_api.validate_enabled then
436:
437: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
438: --
439: -- As the Validate_Enabled exception has been raised
440: -- we must rollback to the savepoint
441: --

Line 482: g_debug := hr_utility.debug_enabled;

478: l_proc constant varchar2(100) := g_package || ' create_transaction';
479: url_too_long exception;
480: --
481: begin
482: g_debug := hr_utility.debug_enabled;
483:
484: IF g_debug THEN
485: -- l_proc := g_package||'create_transaction';
486: hr_utility.set_location('Entering:'|| l_proc, 5);

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

482: g_debug := hr_utility.debug_enabled;
483:
484: IF g_debug THEN
485: -- l_proc := g_package||'create_transaction';
486: hr_utility.set_location('Entering:'|| l_proc, 5);
487: END IF;
488:
489:
490: IF p_url is not null and length(p_url) > 4000 THEN

Line 539: hr_utility.set_location(' Leaving:'||l_proc, 10);

535: end if;
536: --
537:
538: IF g_debug THEN
539: hr_utility.set_location(' Leaving:'||l_proc, 10);
540: END IF;
541:
542: exception
543:

Line 546: hr_utility.set_location('EXCEPTION: '|| l_proc,560);

542: exception
543:
544:
545: when url_too_long then
546: hr_utility.set_location('EXCEPTION: '|| l_proc,560);
547: p_transaction_id := null;
548: hr_utility.trace(' exception in ' || 'Url too long, it supports only 4000 characters' );
549: when hr_api.validate_enabled then
550:

Line 548: hr_utility.trace(' exception in ' || 'Url too long, it supports only 4000 characters' );

544:
545: when url_too_long then
546: hr_utility.set_location('EXCEPTION: '|| l_proc,560);
547: p_transaction_id := null;
548: hr_utility.trace(' exception in ' || 'Url too long, it supports only 4000 characters' );
549: when hr_api.validate_enabled then
550:
551: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
552: --

Line 551: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

547: p_transaction_id := null;
548: hr_utility.trace(' exception in ' || 'Url too long, it supports only 4000 characters' );
549: when hr_api.validate_enabled then
550:
551: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
552: --
553: -- As the Validate_Enabled exception has been raised
554: -- we must rollback to the savepoint
555: --

Line 559: hr_utility.trace(' exception in ' || sqlerrm);

555: --
556: rollback to create_transaction;
557: -- set primary key to null
558: p_transaction_id := null;
559: hr_utility.trace(' exception in ' || sqlerrm);
560: when others then
561:
562: hr_utility.set_location('EXCEPTION: '|| l_proc,560);
563: p_transaction_id := null;

Line 562: hr_utility.set_location('EXCEPTION: '|| l_proc,560);

558: p_transaction_id := null;
559: hr_utility.trace(' exception in ' || sqlerrm);
560: when others then
561:
562: hr_utility.set_location('EXCEPTION: '|| l_proc,560);
563: p_transaction_id := null;
564: hr_utility.trace(' exception in ' || sqlerrm);
565: end create_transaction;
566:

Line 564: hr_utility.trace(' exception in ' || sqlerrm);

560: when others then
561:
562: hr_utility.set_location('EXCEPTION: '|| l_proc,560);
563: p_transaction_id := null;
564: hr_utility.trace(' exception in ' || sqlerrm);
565: end create_transaction;
566:
567: --
568:

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

579: ) is
580: ------
581: l_proc constant varchar2(100) := g_package || ' update_transaction';
582: begin
583: hr_utility.set_location('Entering: '|| l_proc,5);
584: hr_trn_upd.upd
585: (
586: p_transaction_id => p_transaction_id,
587: p_status => p_status,

Line 593: hr_utility.set_location('Leaving: '|| l_proc,10);

589: p_transaction_effective_date => p_transaction_effective_date,
590: p_effective_date_option => p_effective_date_option,
591: p_item_key => p_item_key
592: );
593: hr_utility.set_location('Leaving: '|| l_proc,10);
594: end update_transaction;
595: --ns end
596:
597:

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

605: l_last_process_order varchar2(100);
606: l_proc constant varchar2(100) := g_package || ' Get_Last_Process_Order';
607: --
608: begin
609: hr_utility.set_location('Entering: '|| l_proc,5);
610: g_debug := hr_utility.debug_enabled;
611: if p_process_order_str is not null then
612: l_last_process_order := rtrim(substr(p_process_order_str, (instr(p_process_order_str, '%', -1,2)) +1),'%' );
613: end if;

Line 610: g_debug := hr_utility.debug_enabled;

606: l_proc constant varchar2(100) := g_package || ' Get_Last_Process_Order';
607: --
608: begin
609: hr_utility.set_location('Entering: '|| l_proc,5);
610: g_debug := hr_utility.debug_enabled;
611: if p_process_order_str is not null then
612: l_last_process_order := rtrim(substr(p_process_order_str, (instr(p_process_order_str, '%', -1,2)) +1),'%' );
613: end if;
614: hr_utility.set_location('Leaving: '|| l_proc,10);

Line 614: hr_utility.set_location('Leaving: '|| l_proc,10);

610: g_debug := hr_utility.debug_enabled;
611: if p_process_order_str is not null then
612: l_last_process_order := rtrim(substr(p_process_order_str, (instr(p_process_order_str, '%', -1,2)) +1),'%' );
613: end if;
614: hr_utility.set_location('Leaving: '|| l_proc,10);
615: return (l_last_process_order);
616:
617: exception
618: when others then

Line 619: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

615: return (l_last_process_order);
616:
617: exception
618: when others then
619: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
620: return(null);
621: --
622: end Get_Last_Process_Order ;
623: --

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

650: and wiav.name = 'PROCESS_ORDER_STRING' ;
651:
652: --
653: begin
654: hr_utility.set_location('Entering: '|| l_proc,5);
655: g_debug := hr_utility.debug_enabled;
656: -- fix for bug#2112623
657: -- open the cursor to determine if the attribute exists
658: open csr_wiav;

Line 655: g_debug := hr_utility.debug_enabled;

651:
652: --
653: begin
654: hr_utility.set_location('Entering: '|| l_proc,5);
655: g_debug := hr_utility.debug_enabled;
656: -- fix for bug#2112623
657: -- open the cursor to determine if the attribute exists
658: open csr_wiav;
659: hr_utility.trace('Going into Fetch after (open csr_wiav ): '|| l_proc);

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

655: g_debug := hr_utility.debug_enabled;
656: -- fix for bug#2112623
657: -- open the cursor to determine if the attribute exists
658: open csr_wiav;
659: hr_utility.trace('Going into Fetch after (open csr_wiav ): '|| l_proc);
660: fetch csr_wiav into l_dummy;
661: if csr_wiav%notfound then
662: l_dummy := -1;
663: end if;

Line 667: hr_utility.set_location('Leaving: '|| l_proc,10);

663: end if;
664: close csr_wiav;
665:
666: if(l_dummy=-1) then
667: hr_utility.set_location('Leaving: '|| l_proc,10);
668: return ;
669: end if;
670: -- end of bug fix
671:

Line 680: hr_utility.trace('In (if l_process_order_str is null then): '|| l_proc);

676: aname =>'PROCESS_ORDER_STRING');
677:
678: --
679: if l_process_order_str is null then
680: hr_utility.trace('In (if l_process_order_str is null then): '|| l_proc);
681: l_process_order_str := '%'||to_char(p_actid)||'%1%';
682: wf_engine.SetItemAttrText (itemtype => p_item_type,
683: itemkey => p_item_key,
684: aname => 'PROCESS_ORDER_STRING',

Line 687: hr_utility.trace('In else of (if l_process_order_str is null then): '|| l_proc);

683: itemkey => p_item_key,
684: aname => 'PROCESS_ORDER_STRING',
685: avalue => l_process_order_str );
686: else
687: hr_utility.trace('In else of (if l_process_order_str is null then): '|| l_proc);
688: -- Following commented code is replaced by if(instr(l_process_order_str,p_actid)=0) code
689: /*
690: while instr(l_process_order_str,'%', l_counter) <> 0 loop
691: l_value := substr(l_process_order_str,

Line 716: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

712: end if;
713: --
714: exception
715: when others then
716: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
717: null;
718: --
719: end Set_Process_Order_String ;
720: --

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

746: and wiav.item_key = p_item_key
747: and wiav.name = 'PROCESS_ORDER_STRING' ;
748: --
749: begin
750: hr_utility.set_location('Entering: '|| l_proc,5);
751: g_debug := hr_utility.debug_enabled;
752: -- fix for bug#2112623
753: -- open the cursor to determine if the a
754: open csr_wiav;

Line 751: g_debug := hr_utility.debug_enabled;

747: and wiav.name = 'PROCESS_ORDER_STRING' ;
748: --
749: begin
750: hr_utility.set_location('Entering: '|| l_proc,5);
751: g_debug := hr_utility.debug_enabled;
752: -- fix for bug#2112623
753: -- open the cursor to determine if the a
754: open csr_wiav;
755: hr_utility.trace('Going into Fetch after (open csr_wiav ): '|| l_proc);

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

751: g_debug := hr_utility.debug_enabled;
752: -- fix for bug#2112623
753: -- open the cursor to determine if the a
754: open csr_wiav;
755: hr_utility.trace('Going into Fetch after (open csr_wiav ): '|| l_proc);
756: fetch csr_wiav into l_dummy;
757: if csr_wiav%notfound then
758: l_dummy := -1;
759: end if;

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

759: end if;
760: close csr_wiav;
761:
762: if(l_dummy=-1) then
763: hr_utility.set_location('Leaving: '|| l_proc,20);
764: return (null);
765: end if;
766: -- end of bug fix
767:

Line 772: --hr_utility.trace('Get Process Order--Process Order Str ' || l_process_order_str);

768: l_process_order_str := wf_engine.GetItemAttrText
769: (itemtype => p_item_type,
770: itemkey => p_item_key,
771: aname =>'PROCESS_ORDER_STRING');
772: --hr_utility.trace('Get Process Order--Process Order Str ' || l_process_order_str);
773: if l_process_order_str is null then
774: hr_utility.set_location('Leaving: '|| l_proc,25);
775: return(null);
776: else

Line 774: hr_utility.set_location('Leaving: '|| l_proc,25);

770: itemkey => p_item_key,
771: aname =>'PROCESS_ORDER_STRING');
772: --hr_utility.trace('Get Process Order--Process Order Str ' || l_process_order_str);
773: if l_process_order_str is null then
774: hr_utility.set_location('Leaving: '|| l_proc,25);
775: return(null);
776: else
777: while instr(l_process_order_str,'%', l_counter) <> 0 loop
778: l_value := substr(l_process_order_str,

Line 782: --hr_utility.trace('Get Process Order--l_value ' || l_value);

778: l_value := substr(l_process_order_str,
779: instr(l_process_order_str,'%',1, l_counter-1) +1,
780: (instr(l_process_order_str,'%',1, l_counter) -
781: instr(l_process_order_str,'%',1, l_counter-1)) -1);
782: --hr_utility.trace('Get Process Order--l_value ' || l_value);
783: if to_char(p_actid) <> l_value then
784: l_counter := l_counter + 2;
785: else
786: l_process_order := substr(l_process_order_str,

Line 790: --hr_utility.trace('Get Process Order--Process Order ' || l_process_order);

786: l_process_order := substr(l_process_order_str,
787: instr(l_process_order_str,'%',1, l_counter) +1,
788: (instr(l_process_order_str,'%',1, l_counter+1) -
789: instr(l_process_order_str,'%',1, l_counter)) -1);
790: --hr_utility.trace('Get Process Order--Process Order ' || l_process_order);
791: hr_utility.set_location('Leaving: '|| l_proc,30);
792: return(l_process_order);
793: end if;
794: end loop;

Line 791: hr_utility.set_location('Leaving: '|| l_proc,30);

787: instr(l_process_order_str,'%',1, l_counter) +1,
788: (instr(l_process_order_str,'%',1, l_counter+1) -
789: instr(l_process_order_str,'%',1, l_counter)) -1);
790: --hr_utility.trace('Get Process Order--Process Order ' || l_process_order);
791: hr_utility.set_location('Leaving: '|| l_proc,30);
792: return(l_process_order);
793: end if;
794: end loop;
795: hr_utility.set_location('Leaving: '|| l_proc,35);

Line 795: hr_utility.set_location('Leaving: '|| l_proc,35);

791: hr_utility.set_location('Leaving: '|| l_proc,30);
792: return(l_process_order);
793: end if;
794: end loop;
795: hr_utility.set_location('Leaving: '|| l_proc,35);
796: return(null);
797: end if;
798: --
799: exception

Line 802: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

798: --
799: exception
800: when others then
801:
802: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
803: hr_utility.set_message(800, 'HR_NO_PROCESS_ORDER');
804: hr_utility.set_message_token('ACTID', p_actid);
805: hr_utility.raise_error;
806: --

Line 803: hr_utility.set_message(800, 'HR_NO_PROCESS_ORDER');

799: exception
800: when others then
801:
802: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
803: hr_utility.set_message(800, 'HR_NO_PROCESS_ORDER');
804: hr_utility.set_message_token('ACTID', p_actid);
805: hr_utility.raise_error;
806: --
807: end Get_Process_Order ;

Line 804: hr_utility.set_message_token('ACTID', p_actid);

800: when others then
801:
802: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
803: hr_utility.set_message(800, 'HR_NO_PROCESS_ORDER');
804: hr_utility.set_message_token('ACTID', p_actid);
805: hr_utility.raise_error;
806: --
807: end Get_Process_Order ;
808: --

Line 805: hr_utility.raise_error;

801:
802: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
803: hr_utility.set_message(800, 'HR_NO_PROCESS_ORDER');
804: hr_utility.set_message_token('ACTID', p_actid);
805: hr_utility.raise_error;
806: --
807: end Get_Process_Order ;
808: --
809: -- ----------------------------------------------------------------------------

Line 831: g_debug := hr_utility.debug_enabled;

827: l_proc constant varchar2(100) := g_package || ' create_trans_step';
828: l_processing_order number default null;
829: --
830: begin
831: g_debug := hr_utility.debug_enabled;
832:
833: IF g_debug THEN
834: --l_proc := g_package||'create_trans_step';
835: hr_utility.set_location('Entering:'|| l_proc, 5);

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

831: g_debug := hr_utility.debug_enabled;
832:
833: IF g_debug THEN
834: --l_proc := g_package||'create_trans_step';
835: hr_utility.set_location('Entering:'|| l_proc, 5);
836: END IF;
837:
838: -- verify that person has transaction privilege
839: check_transaction_privilege

Line 879: hr_utility.set_location(' Leaving:'||l_proc, 10);

875: end if;
876: --
877:
878: IF g_debug THEN
879: hr_utility.set_location(' Leaving:'||l_proc, 10);
880: END IF;
881:
882: exception
883: when hr_api.validate_enabled then

Line 885: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

881:
882: exception
883: when hr_api.validate_enabled then
884:
885: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
886: --
887: -- As the Validate_Enabled exception has been raised
888: -- we must rollback to the savepoint
889: --

Line 915: g_debug := hr_utility.debug_enabled;

911: -- --------------------------------------------------------------------------
912: l_proc constant varchar2(100) := g_package || ' create_transaction_step';
913: --
914: begin
915: g_debug := hr_utility.debug_enabled;
916:
917: IF g_debug THEN
918: -- l_proc := g_package||'create_transaction_step';
919: hr_utility.set_location('Entering:'|| l_proc, 5);

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

915: g_debug := hr_utility.debug_enabled;
916:
917: IF g_debug THEN
918: -- l_proc := g_package||'create_transaction_step';
919: hr_utility.set_location('Entering:'|| l_proc, 5);
920: END IF;
921:
922: create_trans_step
923: (p_validate => false

Line 937: hr_utility.set_location(' Leaving:'||l_proc, 10);

933: ,p_object_version_number => p_object_version_number);
934: --
935:
936: IF g_debug THEN
937: hr_utility.set_location(' Leaving:'||l_proc, 10);
938: END IF;
939:
940: end create_transaction_step;
941: -- ----------------------------------------------------------------------------

Line 960: g_debug := hr_utility.debug_enabled;

956: from hr_api_transaction_values hatv
957: where hatv.transaction_step_id = p_transaction_step_id;
958: --
959: begin
960: g_debug := hr_utility.debug_enabled;
961:
962: IF g_debug THEN
963: -- l_proc := g_package||'update_transaction_step';
964: hr_utility.set_location('Entering: '|| l_proc, 5);

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

960: g_debug := hr_utility.debug_enabled;
961:
962: IF g_debug THEN
963: -- l_proc := g_package||'update_transaction_step';
964: hr_utility.set_location('Entering: '|| l_proc, 5);
965: END IF;
966:
967: -- verify that person has transaction privilege
968: check_transaction_privilege

Line 993: hr_utility.set_location(' Leaving:'||l_proc, 10);

989: end if;
990: --
991:
992: IF g_debug THEN
993: hr_utility.set_location(' Leaving:'||l_proc, 10);
994: END IF;
995:
996: exception
997: when hr_api.validate_enabled then

Line 998: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

994: END IF;
995:
996: exception
997: when hr_api.validate_enabled then
998: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
999: --
1000: -- As the Validate_Enabled exception has been raised
1001: -- we must rollback to the savepoint
1002: --

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

1014: ,p_object_version_number in number) is
1015: --
1016: l_proc constant varchar2(100) := g_package || ' delete_transaction_step';
1017: begin
1018: hr_utility.set_location('Entering: '|| l_proc,5);
1019: g_debug := hr_utility.debug_enabled;
1020: -- verify that person has transaction privilege
1021: check_transaction_privilege
1022: (p_transaction_id => get_transaction_id

Line 1019: g_debug := hr_utility.debug_enabled;

1015: --
1016: l_proc constant varchar2(100) := g_package || ' delete_transaction_step';
1017: begin
1018: hr_utility.set_location('Entering: '|| l_proc,5);
1019: g_debug := hr_utility.debug_enabled;
1020: -- verify that person has transaction privilege
1021: check_transaction_privilege
1022: (p_transaction_id => get_transaction_id
1023: (p_transaction_step_id => p_transaction_step_id)

Line 1049: hr_utility.set_location('Leaving: '|| l_proc,10);

1045: ,p_object_version_number => p_object_version_number);
1046: if p_validate then
1047: raise hr_api.validate_enabled;
1048: end if;
1049: hr_utility.set_location('Leaving: '|| l_proc,10);
1050: exception
1051: when hr_api.validate_enabled then
1052: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1053: --

Line 1052: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1048: end if;
1049: hr_utility.set_location('Leaving: '|| l_proc,10);
1050: exception
1051: when hr_api.validate_enabled then
1052: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1053: --
1054: -- As the Validate_Enabled exception has been raised
1055: -- we must rollback to the savepoint
1056: --

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

1094: begin
1095:
1096: IF g_debug THEN
1097: -- l_proc := g_package||'set_value';
1098: hr_utility.set_location('Entering:'|| l_proc, 5);
1099: END IF;
1100:
1101: -- upper the parameter name
1102: l_name := upper(p_name);

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

1106: (p_transaction_step_id => p_transaction_step_id)
1107: ,p_person_id => p_person_id);
1108: -- determine if we are doing an insert or update
1109: open csr_hatv;
1110: hr_utility.trace('Going into Fetch after (open csr_hatv ): '|| l_proc);
1111: fetch csr_hatv into l_transaction_value_id,l_current_value,l_original_value;
1112: if csr_hatv%notfound then
1113: -- a row does exist so we must be trying to create a value
1114: l_insert := true;

Line 1167: hr_utility.set_location(' Leaving:'||l_proc, 10);

1163: end if;
1164: --
1165:
1166: IF g_debug THEN
1167: hr_utility.set_location(' Leaving:'||l_proc, 10);
1168: END IF;
1169:
1170: exception
1171: when hr_api.validate_enabled then

Line 1173: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1169:
1170: exception
1171: when hr_api.validate_enabled then
1172:
1173: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1174: --
1175: -- As the Validate_Enabled exception has been raised
1176: -- we must rollback to the savepoint
1177: --

Line 1199: g_debug := hr_utility.debug_enabled;

1195: l_proc constant varchar2(100) := g_package || ' set_varchar2_value';
1196: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;
1197: --
1198: begin
1199: g_debug := hr_utility.debug_enabled;
1200:
1201: IF g_debug THEN
1202: -- l_proc := g_package||'set_varchar2_value';
1203: hr_utility.set_location('Entering:'|| l_proc, 5);

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

1199: g_debug := hr_utility.debug_enabled;
1200:
1201: IF g_debug THEN
1202: -- l_proc := g_package||'set_varchar2_value';
1203: hr_utility.set_location('Entering:'|| l_proc, 5);
1204: END IF;
1205:
1206: --
1207: set_value

Line 1219: hr_utility.set_location(' Leaving:'||l_proc, 10);

1215: ,p_transaction_value_id => l_transaction_value_id);
1216: --
1217:
1218: IF g_debug THEN
1219: hr_utility.set_location(' Leaving:'||l_proc, 10);
1220: END IF;
1221:
1222: end set_varchar2_value;
1223: -- ----------------------------------------------------------------------------

Line 1240: g_debug := hr_utility.debug_enabled;

1236: l_proc constant varchar2(100) := g_package || ' set_number_value';
1237: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;
1238: --
1239: begin
1240: g_debug := hr_utility.debug_enabled;
1241:
1242: IF g_debug THEN
1243: -- l_proc := g_package||'set_number_value';
1244: hr_utility.set_location('Entering:'|| l_proc, 5);

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

1240: g_debug := hr_utility.debug_enabled;
1241:
1242: IF g_debug THEN
1243: -- l_proc := g_package||'set_number_value';
1244: hr_utility.set_location('Entering:'|| l_proc, 5);
1245: END IF;
1246:
1247: --
1248: set_value

Line 1260: hr_utility.set_location(' Leaving:'||l_proc, 10);

1256: ,p_transaction_value_id => l_transaction_value_id);
1257: --
1258:
1259: IF g_debug THEN
1260: hr_utility.set_location(' Leaving:'||l_proc, 10);
1261: END IF;
1262:
1263: end set_number_value;
1264: -- ----------------------------------------------------------------------------

Line 1281: g_debug := hr_utility.debug_enabled;

1277: l_proc constant varchar2(100) := g_package || ' set_date_value';
1278: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;
1279: --
1280: begin
1281: g_debug := hr_utility.debug_enabled;
1282:
1283: IF g_debug THEN
1284: -- l_proc := g_package||'set_date_value';
1285: hr_utility.set_location('Entering:'|| l_proc, 5);

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

1281: g_debug := hr_utility.debug_enabled;
1282:
1283: IF g_debug THEN
1284: -- l_proc := g_package||'set_date_value';
1285: hr_utility.set_location('Entering:'|| l_proc, 5);
1286: END IF;
1287:
1288: --
1289: set_value

Line 1301: hr_utility.set_location(' Leaving:'||l_proc, 10);

1297: ,p_transaction_value_id => l_transaction_value_id);
1298: --
1299:
1300: IF g_debug THEN
1301: hr_utility.set_location(' Leaving:'||l_proc, 10);
1302: END IF;
1303:
1304: end set_date_value;
1305: -- ----------------------------------------------------------------------------

Line 1324: g_debug := hr_utility.debug_enabled;

1320: l_value varchar2(30);
1321: l_original_value varchar2(30); --ns
1322: --
1323: begin
1324: g_debug := hr_utility.debug_enabled;
1325:
1326: IF g_debug THEN
1327: -- l_proc := g_package||'set_boolean_value';
1328: hr_utility.set_location('Entering:'|| l_proc, 5);

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

1324: g_debug := hr_utility.debug_enabled;
1325:
1326: IF g_debug THEN
1327: -- l_proc := g_package||'set_boolean_value';
1328: hr_utility.set_location('Entering:'|| l_proc, 5);
1329: END IF;
1330:
1331: -- derive the value
1332: if p_value then

Line 1362: hr_utility.set_location(' Leaving:'||l_proc, 10);

1358: ,p_transaction_value_id => l_transaction_value_id);
1359: --
1360:
1361: IF g_debug THEN
1362: hr_utility.set_location(' Leaving:'||l_proc, 10);
1363: END IF;
1364:
1365: end set_boolean_value;
1366: -- ----------------------------------------------------------------------------

Line 1393: g_debug := hr_utility.debug_enabled;

1389: where hatv.transaction_step_id = p_transaction_step_id
1390: and hatv.name = l_name;
1391: --
1392: begin
1393: g_debug := hr_utility.debug_enabled;
1394:
1395: IF g_debug THEN
1396: -- l_proc := g_package||'get_value';
1397: hr_utility.set_location('Entering:'|| l_proc, 5);

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

1393: g_debug := hr_utility.debug_enabled;
1394:
1395: IF g_debug THEN
1396: -- l_proc := g_package||'get_value';
1397: hr_utility.set_location('Entering:'|| l_proc, 5);
1398: END IF;
1399:
1400: -- upper the parameter name
1401: l_name := upper(p_name);

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

1400: -- upper the parameter name
1401: l_name := upper(p_name);
1402: -- select the transaction value details
1403: open csr_hatv;
1404: hr_utility.trace('Going into Fetch after (open csr_hatv ): '|| l_proc);
1405: fetch csr_hatv
1406: into p_datatype
1407: ,p_varchar2_value
1408: ,p_number_value

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

1410: close csr_hatv;
1411: --
1412:
1413: IF g_debug THEN
1414: hr_utility.set_location(' Leaving:'||l_proc, 15);
1415: END IF;
1416:
1417: end get_value;
1418: -- ----------------------------------------------------------------------------

Line 1434: g_debug := hr_utility.debug_enabled;

1430: l_number hr_api_transaction_values.number_value%type;
1431: l_date hr_api_transaction_values.date_value%type;
1432: --
1433: begin
1434: g_debug := hr_utility.debug_enabled;
1435:
1436: IF g_debug THEN
1437: -- l_proc := g_package||'get_varchar2_value';
1438: hr_utility.set_location('Entering:'|| l_proc, 5);

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

1434: g_debug := hr_utility.debug_enabled;
1435:
1436: IF g_debug THEN
1437: -- l_proc := g_package||'get_varchar2_value';
1438: hr_utility.set_location('Entering:'|| l_proc, 5);
1439: END IF;
1440:
1441: --
1442: get_value

Line 1452: hr_utility.set_location(' Leaving:'||l_proc, 10);

1448: ,p_date_value => l_date);
1449: --
1450:
1451: IF g_debug THEN
1452: hr_utility.set_location(' Leaving:'||l_proc, 10);
1453: END IF;
1454:
1455: return(l_varchar2);
1456: end get_varchar2_value;

Line 1473: g_debug := hr_utility.debug_enabled;

1469: l_number hr_api_transaction_values.number_value%type;
1470: l_date hr_api_transaction_values.date_value%type;
1471: --
1472: begin
1473: g_debug := hr_utility.debug_enabled;
1474:
1475: IF g_debug THEN
1476: -- l_proc := g_package||'get_number_value';
1477: hr_utility.set_location('Entering:'|| l_proc, 5);

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

1473: g_debug := hr_utility.debug_enabled;
1474:
1475: IF g_debug THEN
1476: -- l_proc := g_package||'get_number_value';
1477: hr_utility.set_location('Entering:'|| l_proc, 5);
1478: END IF;
1479:
1480: --
1481: get_value

Line 1491: hr_utility.set_location(' Leaving:'||l_proc, 10);

1487: ,p_date_value => l_date);
1488: --
1489:
1490: IF g_debug THEN
1491: hr_utility.set_location(' Leaving:'||l_proc, 10);
1492: END IF;
1493:
1494: hr_utility.set_location(' Leaving:'||l_proc, 15);
1495: return(l_number);

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

1490: IF g_debug THEN
1491: hr_utility.set_location(' Leaving:'||l_proc, 10);
1492: END IF;
1493:
1494: hr_utility.set_location(' Leaving:'||l_proc, 15);
1495: return(l_number);
1496:
1497: end get_number_value;
1498: -- ----------------------------------------------------------------------------

Line 1514: g_debug := hr_utility.debug_enabled;

1510: l_number hr_api_transaction_values.number_value%type;
1511: l_date hr_api_transaction_values.date_value%type;
1512: --
1513: begin
1514: g_debug := hr_utility.debug_enabled;
1515:
1516: IF g_debug THEN
1517: -- l_proc := g_package||'get_date_value';
1518: hr_utility.set_location('Entering:'|| l_proc, 5);

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

1514: g_debug := hr_utility.debug_enabled;
1515:
1516: IF g_debug THEN
1517: -- l_proc := g_package||'get_date_value';
1518: hr_utility.set_location('Entering:'|| l_proc, 5);
1519: END IF;
1520:
1521: --
1522: get_value

Line 1532: hr_utility.set_location(' Leaving:'||l_proc, 10);

1528: ,p_date_value => l_date);
1529: --
1530:
1531: IF g_debug THEN
1532: hr_utility.set_location(' Leaving:'||l_proc, 10);
1533: END IF;
1534:
1535: return(l_date);
1536: end get_date_value;

Line 1557: g_debug := hr_utility.debug_enabled;

1553: l_date hr_api_transaction_values.date_value%type;
1554: l_char_date varchar2(200);
1555: --
1556: begin
1557: g_debug := hr_utility.debug_enabled;
1558:
1559: IF g_debug THEN
1560: -- l_proc := g_package||'get_date2char_value';
1561: hr_utility.set_location('Entering:'|| l_proc, 5);

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

1557: g_debug := hr_utility.debug_enabled;
1558:
1559: IF g_debug THEN
1560: -- l_proc := g_package||'get_date2char_value';
1561: hr_utility.set_location('Entering:'|| l_proc, 5);
1562: END IF;
1563:
1564: --
1565: get_value

Line 1575: hr_utility.set_location(' Leaving:'||l_proc, 10);

1571: ,p_date_value => l_date);
1572: --
1573:
1574: IF g_debug THEN
1575: hr_utility.set_location(' Leaving:'||l_proc, 10);
1576: END IF;
1577:
1578: l_char_date := to_char(l_date, p_date_format);
1579: hr_utility.set_location(' Leaving:'||l_proc, 15);

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

1575: hr_utility.set_location(' Leaving:'||l_proc, 10);
1576: END IF;
1577:
1578: l_char_date := to_char(l_date, p_date_format);
1579: hr_utility.set_location(' Leaving:'||l_proc, 15);
1580: return(l_char_date);
1581: --
1582: end get_date2char_value;
1583: --

Line 1603: g_debug := hr_utility.debug_enabled;

1599: l_date hr_api_transaction_values.date_value%type;
1600: l_boolean boolean;
1601: --
1602: begin
1603: g_debug := hr_utility.debug_enabled;
1604:
1605: IF g_debug THEN
1606: -- l_proc := g_package||'get_boolean_value';
1607: hr_utility.set_location('Entering:'|| l_proc, 5);

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

1603: g_debug := hr_utility.debug_enabled;
1604:
1605: IF g_debug THEN
1606: -- l_proc := g_package||'get_boolean_value';
1607: hr_utility.set_location('Entering:'|| l_proc, 5);
1608: END IF;
1609:
1610: --
1611: get_value

Line 1628: hr_utility.set_location(' Leaving:'||l_proc, 10);

1624: l_boolean := null;
1625: end if;
1626:
1627: IF g_debug THEN
1628: hr_utility.set_location(' Leaving:'||l_proc, 10);
1629: END IF;
1630: hr_utility.set_location(' Leaving:'||l_proc, 15);
1631: return(l_boolean);
1632: end get_boolean_value;

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

1626:
1627: IF g_debug THEN
1628: hr_utility.set_location(' Leaving:'||l_proc, 10);
1629: END IF;
1630: hr_utility.set_location(' Leaving:'||l_proc, 15);
1631: return(l_boolean);
1632: end get_boolean_value;
1633: -- ----------------------------------------------------------------------------
1634: -- |---------------------< get_original_value >-------------------------------|

Line 1660: g_debug := hr_utility.debug_enabled;

1656: where hatv.transaction_step_id = p_transaction_step_id
1657: and hatv.name = l_name;
1658: --
1659: begin
1660: g_debug := hr_utility.debug_enabled;
1661:
1662: IF g_debug THEN
1663: -- l_proc := g_package||'get_original_value';
1664: hr_utility.set_location('Entering:'|| l_proc, 5);

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

1660: g_debug := hr_utility.debug_enabled;
1661:
1662: IF g_debug THEN
1663: -- l_proc := g_package||'get_original_value';
1664: hr_utility.set_location('Entering:'|| l_proc, 5);
1665: END IF;
1666:
1667: -- upper the parameter name
1668: l_name := upper(p_name);

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

1667: -- upper the parameter name
1668: l_name := upper(p_name);
1669: -- select the transaction value details
1670: open csr_hatv;
1671: hr_utility.trace('Going into Fetch after (open csr_hatv ): '|| l_proc);
1672: fetch csr_hatv
1673: into p_datatype
1674: ,p_original_varchar2_value
1675: ,p_original_number_value

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

1676: ,p_original_date_value;
1677: if csr_hatv%notfound then
1678: -- parameter does not exist
1679: close csr_hatv;
1680: hr_utility.set_message(801, 'HR_51751_WEB_TRA_STEP_EXISTS');
1681: hr_utility.raise_error;
1682: end if;
1683: close csr_hatv;
1684: --

Line 1681: hr_utility.raise_error;

1677: if csr_hatv%notfound then
1678: -- parameter does not exist
1679: close csr_hatv;
1680: hr_utility.set_message(801, 'HR_51751_WEB_TRA_STEP_EXISTS');
1681: hr_utility.raise_error;
1682: end if;
1683: close csr_hatv;
1684: --
1685:

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

1683: close csr_hatv;
1684: --
1685:
1686: IF g_debug THEN
1687: hr_utility.set_location(' Leaving:'||l_proc, 15);
1688: END IF;
1689:
1690: end get_original_value;
1691: -- ----------------------------------------------------------------------------

Line 1707: g_debug := hr_utility.debug_enabled;

1703: l_number hr_api_transaction_values.number_value%type;
1704: l_date hr_api_transaction_values.date_value%type;
1705: --
1706: begin
1707: g_debug := hr_utility.debug_enabled;
1708:
1709: IF g_debug THEN
1710: -- l_proc := g_package||'get_original_varchar2_value';
1711: hr_utility.set_location('Entering:'|| l_proc, 5);

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

1707: g_debug := hr_utility.debug_enabled;
1708:
1709: IF g_debug THEN
1710: -- l_proc := g_package||'get_original_varchar2_value';
1711: hr_utility.set_location('Entering:'|| l_proc, 5);
1712: END IF;
1713:
1714: --
1715: get_original_value

Line 1725: hr_utility.set_location(' Leaving:'||l_proc, 10);

1721: ,p_original_date_value => l_date);
1722: --
1723:
1724: IF g_debug THEN
1725: hr_utility.set_location(' Leaving:'||l_proc, 10);
1726: END IF;
1727: hr_utility.set_location(' Leaving:'||l_proc, 15);
1728: return(l_varchar2);
1729: end get_original_varchar2_value;

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

1723:
1724: IF g_debug THEN
1725: hr_utility.set_location(' Leaving:'||l_proc, 10);
1726: END IF;
1727: hr_utility.set_location(' Leaving:'||l_proc, 15);
1728: return(l_varchar2);
1729: end get_original_varchar2_value;
1730: -- ----------------------------------------------------------------------------
1731: -- |--------------------< get_original_number_value >-------------------------|

Line 1746: g_debug := hr_utility.debug_enabled;

1742: l_number hr_api_transaction_values.number_value%type;
1743: l_date hr_api_transaction_values.date_value%type;
1744: --
1745: begin
1746: g_debug := hr_utility.debug_enabled;
1747:
1748: IF g_debug THEN
1749: -- l_proc := g_package||'get_original_number_value';
1750: hr_utility.set_location('Entering:'|| l_proc, 5);

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

1746: g_debug := hr_utility.debug_enabled;
1747:
1748: IF g_debug THEN
1749: -- l_proc := g_package||'get_original_number_value';
1750: hr_utility.set_location('Entering:'|| l_proc, 5);
1751: END IF;
1752:
1753: --
1754: get_original_value

Line 1764: hr_utility.set_location(' Leaving:'||l_proc, 10);

1760: ,p_original_date_value => l_date);
1761: --
1762:
1763: IF g_debug THEN
1764: hr_utility.set_location(' Leaving:'||l_proc, 10);
1765: END IF;
1766: hr_utility.set_location(' Leaving:'||l_proc, 15);
1767: return(l_number);
1768: end get_original_number_value;

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

1762:
1763: IF g_debug THEN
1764: hr_utility.set_location(' Leaving:'||l_proc, 10);
1765: END IF;
1766: hr_utility.set_location(' Leaving:'||l_proc, 15);
1767: return(l_number);
1768: end get_original_number_value;
1769: -- ----------------------------------------------------------------------------
1770: -- |----------------------< get_original_date_value >-------------------------|

Line 1785: g_debug := hr_utility.debug_enabled;

1781: l_number hr_api_transaction_values.number_value%type;
1782: l_date hr_api_transaction_values.date_value%type;
1783: --
1784: begin
1785: g_debug := hr_utility.debug_enabled;
1786:
1787: IF g_debug THEN
1788: -- l_proc := g_package||'get_original_date_value';
1789: hr_utility.set_location('Entering:'|| l_proc, 5);

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

1785: g_debug := hr_utility.debug_enabled;
1786:
1787: IF g_debug THEN
1788: -- l_proc := g_package||'get_original_date_value';
1789: hr_utility.set_location('Entering:'|| l_proc, 5);
1790: END IF;
1791:
1792: --
1793: get_original_value

Line 1803: hr_utility.set_location(' Leaving:'||l_proc, 10);

1799: ,p_original_date_value => l_date);
1800: --
1801:
1802: IF g_debug THEN
1803: hr_utility.set_location(' Leaving:'||l_proc, 10);
1804: END IF;
1805: hr_utility.set_location(' Leaving:'||l_proc, 15);
1806: return(l_date);
1807: end get_original_date_value;

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

1801:
1802: IF g_debug THEN
1803: hr_utility.set_location(' Leaving:'||l_proc, 10);
1804: END IF;
1805: hr_utility.set_location(' Leaving:'||l_proc, 15);
1806: return(l_date);
1807: end get_original_date_value;
1808: -- ----------------------------------------------------------------------------
1809: -- |----------------< get_original_boolean_value >----------------------------|

Line 1825: g_debug := hr_utility.debug_enabled;

1821: l_date hr_api_transaction_values.date_value%type;
1822: l_boolean boolean;
1823: --
1824: begin
1825: g_debug := hr_utility.debug_enabled;
1826:
1827: IF g_debug THEN
1828: -- l_proc := g_package||'get_original_boolean_value';
1829: hr_utility.set_location('Entering:'|| l_proc, 5);

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

1825: g_debug := hr_utility.debug_enabled;
1826:
1827: IF g_debug THEN
1828: -- l_proc := g_package||'get_original_boolean_value';
1829: hr_utility.set_location('Entering:'|| l_proc, 5);
1830: END IF;
1831:
1832: --
1833: get_original_value

Line 1850: hr_utility.set_location(' Leaving:'||l_proc, 10);

1846: l_boolean := null;
1847: end if;
1848:
1849: IF g_debug THEN
1850: hr_utility.set_location(' Leaving:'||l_proc, 10);
1851: END IF;
1852: hr_utility.set_location(' Leaving:'||l_proc, 15);
1853: return(l_boolean);
1854: end get_original_boolean_value;

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

1848:
1849: IF g_debug THEN
1850: hr_utility.set_location(' Leaving:'||l_proc, 10);
1851: END IF;
1852: hr_utility.set_location(' Leaving:'||l_proc, 15);
1853: return(l_boolean);
1854: end get_original_boolean_value;
1855: --
1856: -- ----------------------------------------------------------------------------

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

1910: l_return_status varchar2(10);
1911: lv_status pqh_ss_approval_history.action%type;
1912:
1913: begin
1914: hr_utility.set_location('Entering: '|| l_proc,5);
1915: g_debug := hr_utility.debug_enabled;
1916: --
1917: -- issue a savepoint if operating in validation only mode.
1918: --

Line 1915: g_debug := hr_utility.debug_enabled;

1911: lv_status pqh_ss_approval_history.action%type;
1912:
1913: begin
1914: hr_utility.set_location('Entering: '|| l_proc,5);
1915: g_debug := hr_utility.debug_enabled;
1916: --
1917: -- issue a savepoint if operating in validation only mode.
1918: --
1919: if p_validate then

Line 1945: hr_utility.trace('Going into (for csr1 in csr_trs loop): '|| l_proc);

1941: -- lock the transaction
1942: hr_trn_shd.lck
1943: (p_transaction_id => p_transaction_id);
1944: -- delete all transaction steps and values
1945: hr_utility.trace('Going into (for csr1 in csr_trs loop): '|| l_proc);
1946: for csr1 in csr_trs loop
1947: -- lock the transaction step
1948: hr_trs_shd.lck
1949: (p_transaction_step_id => csr1.transaction_step_id

Line 1962: hr_utility.trace('Out of (for csr1 in csr_trs loop): '|| l_proc);

1958: hr_trs_del.del
1959: (p_transaction_step_id => csr1.transaction_step_id
1960: ,p_object_version_number => csr1.object_version_number);
1961: end loop;
1962: hr_utility.trace('Out of (for csr1 in csr_trs loop): '|| l_proc);
1963: -- delete transaction
1964: hr_trn_del.del
1965: (p_transaction_id => p_transaction_id);
1966: --

Line 1980: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1976: end if;
1977: --
1978: exception
1979: when hr_api.validate_enabled then
1980: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1981: --
1982: -- As the Validate_Enabled exception has been raised
1983: -- we must rollback to the savepoint
1984: --