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.PER_IN_CON_LEG_HOOK dependencies on PAY_IN_UTILS

Line 6: p_token_name pay_in_utils.char_tab_type;

2: /* $Header: peinlhco.pkb 120.6.12010000.2 2008/08/06 09:13:39 ubhat ship $ */
3:
4: g_package CONSTANT VARCHAR2(100) := 'per_in_con_leg_hook.';
5: g_debug BOOLEAN;
6: p_token_name pay_in_utils.char_tab_type;
7: p_token_value pay_in_utils.char_tab_type;
8: p_message_name VARCHAR2(50);
9:
10:

Line 7: p_token_value pay_in_utils.char_tab_type;

3:
4: g_package CONSTANT VARCHAR2(100) := 'per_in_con_leg_hook.';
5: g_debug BOOLEAN;
6: p_token_name pay_in_utils.char_tab_type;
7: p_token_value pay_in_utils.char_tab_type;
8: p_message_name VARCHAR2(50);
9:
10:
11:

Line 142: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type

138:
139: PROCEDURE check_nominee_age
140: ( p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
141: ,p_message_name OUT NOCOPY VARCHAR2
142: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
143: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)
144:
145: IS
146: l_birth_date DATE;

Line 143: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)

139: PROCEDURE check_nominee_age
140: ( p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
141: ,p_message_name OUT NOCOPY VARCHAR2
142: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
143: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)
144:
145: IS
146: l_birth_date DATE;
147: l_current_date DATE;

Line 188: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

184: BEGIN
185:
186: g_debug := hr_utility.debug_enabled ;
187: l_procedure := g_package ||'check_nominee_age';
188: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
189:
190: IF g_debug THEN
191: pay_in_utils.trace('**************************************************','********************');
192: pay_in_utils.trace('p_contact_relationship_id',p_contact_relationship_id);

Line 191: pay_in_utils.trace('******************************','');

187: l_procedure := g_package ||'check_nominee_age';
188: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
189:
190: IF g_debug THEN
191: pay_in_utils.trace('**************************************************','********************');
192: pay_in_utils.trace('p_contact_relationship_id',p_contact_relationship_id);
193: pay_in_utils.trace('**************************************************','********************');
194: END IF;
195:

Line 192: pay_in_utils.trace('p_contact_relationship_id',p_contact_relationship_id);

188: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
189:
190: IF g_debug THEN
191: pay_in_utils.trace('**************************************************','********************');
192: pay_in_utils.trace('p_contact_relationship_id',p_contact_relationship_id);
193: pay_in_utils.trace('**************************************************','********************');
194: END IF;
195:
196: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN

Line 193: pay_in_utils.trace('******************************','');

189:
190: IF g_debug THEN
191: pay_in_utils.trace('**************************************************','********************');
192: pay_in_utils.trace('p_contact_relationship_id',p_contact_relationship_id);
193: pay_in_utils.trace('**************************************************','********************');
194: END IF;
195:
196: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
197: hr_utility.trace ('IN Legislation not installed. Not performing the validations');

Line 198: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

194: END IF;
195:
196: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
197: hr_utility.trace ('IN Legislation not installed. Not performing the validations');
198: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
199: RETURN;
200: END IF;
201:
202: OPEN c_business_group_check(p_contact_relationship_id);

Line 208: pay_in_utils.set_location(g_debug,l_procedure,30);

204: CLOSE c_business_group_check;
205:
206: IF l_legislation_code = 'IN' THEN
207:
208: pay_in_utils.set_location(g_debug,l_procedure,30);
209:
210: OPEN c_get_contact_person_id;
211: FETCH c_get_contact_person_id into l_contact_person_id;
212: CLOSE c_get_contact_person_id;

Line 216: pay_in_utils.set_location(g_debug,l_procedure,40);

212: CLOSE c_get_contact_person_id;
213:
214: IF l_contact_person_id is not NULL THEN
215: --Get contact person Id--
216: pay_in_utils.set_location(g_debug,l_procedure,40);
217:
218: OPEN c_get_birth_date(l_contact_person_id);
219: FETCH c_get_birth_date into l_birth_date;
220: CLOSE c_get_birth_date;

Line 224: pay_in_utils.set_location(g_debug,l_procedure,50);

220: CLOSE c_get_birth_date;
221:
222: IF l_birth_date is not null THEN
223: ---Get the age of nominee--
224: pay_in_utils.set_location(g_debug,l_procedure,50);
225:
226: BEGIN
227: SELECT effective_date into l_current_date from fnd_sessions
228: WHERE session_id = userenv('SESSIONID');

Line 241: pay_in_utils.set_location(g_debug,l_procedure,60);

237:
238: IF (l_year < 18 or ((l_year = 18) and (l_month < 0)) or ((l_year = 18) and (l_month = 0) and (l_day < 0))) THEN
239: l_guardian_detail_flag := 0;
240: --check the age of nominee--
241: pay_in_utils.set_location(g_debug,l_procedure,60);
242:
243: OPEN c_check_guardian_details;
244: FETCH c_check_guardian_details into l_guardian_detail_flag;
245: CLOSE c_check_guardian_details;

Line 249: pay_in_utils.set_location(g_debug,l_procedure,70);

245: CLOSE c_check_guardian_details;
246:
247: IF l_guardian_detail_flag = 0 THEN
248: ---Gardian Details---
249: pay_in_utils.set_location(g_debug,l_procedure,70);
250:
251: hr_utility.set_message(800,'PER_IN_GUARDIAN_DETAILS');
252: hr_utility.raise_error;
253: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 262: pay_in_utils.set_location(g_debug,l_procedure,80);

258: END IF;
259: END IF;
260: ELSE
261:
262: pay_in_utils.set_location(g_debug,l_procedure,80);
263:
264: hr_utility.set_message(800,'PER_IN_GUARDIAN_DETAILS');
265:
266: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 274: pay_in_utils.set_location(g_debug,l_procedure,90);

270: END IF;
271: END IF;
272: ELSE
273:
274: pay_in_utils.set_location(g_debug,l_procedure,90);
275: p_message_name := 'PER_IN_NO_RELATIONSHIP';
276: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,100);
277: RETURN;
278: END IF;

Line 276: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,100);

272: ELSE
273:
274: pay_in_utils.set_location(g_debug,l_procedure,90);
275: p_message_name := 'PER_IN_NO_RELATIONSHIP';
276: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,100);
277: RETURN;
278: END IF;
279: END IF;
280: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,110);

Line 280: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,110);

276: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,100);
277: RETURN;
278: END IF;
279: END IF;
280: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,110);
281:
282: END check_nominee_age;
283:
284:

Line 321: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type

317: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
318: ,p_effective_date IN DATE
319: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
320: ,p_message_name OUT NOCOPY VARCHAR2
321: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
322: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)
323: IS
324: l_nomination_share NUMBER;
325: l_person_id NUMBER;

Line 322: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)

318: ,p_effective_date IN DATE
319: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
320: ,p_message_name OUT NOCOPY VARCHAR2
321: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
322: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)
323: IS
324: l_nomination_share NUMBER;
325: l_person_id NUMBER;
326: l_contact_relationship_id NUMBER;

Line 362: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

358: BEGIN
359:
360: g_debug := hr_utility.debug_enabled ;
361: l_procedure := g_package ||'get_essential_insert_value';
362: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
363:
364: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
365: hr_utility.trace ('IN Legislation not installed. Not performing the validations');
366: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

Line 366: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

362: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
363:
364: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
365: hr_utility.trace ('IN Legislation not installed. Not performing the validations');
366: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
367: RETURN;
368: END IF;
369:
370: OPEN c_business_group_check(p_contact_relationship_id);

Line 374: pay_in_utils.set_location(g_debug,l_procedure,20);

370: OPEN c_business_group_check(p_contact_relationship_id);
371: FETCH c_business_group_check into l_legislation_code;
372: CLOSE c_business_group_check;
373:
374: pay_in_utils.set_location(g_debug,l_procedure,20);
375:
376: IF l_legislation_code = 'IN' THEN
377: l_nomination_share := 0;
378: l_temp := 0;

Line 391: pay_in_utils.set_location(g_debug,l_procedure,30);

387: END;
388:
389: IF l_temp = 0 THEN
390: --get person id--
391: pay_in_utils.set_location(g_debug,l_procedure,30);
392:
393: OPEN c_get_person_id;
394: FETCH c_get_person_id into l_person_id;
395: CLOSE c_get_person_id;

Line 408: pay_in_utils.trace('nomination share after',l_nomination_share + to_number(p_CEI_INFORMATION2));

404: END LOOP;
405: CLOSE c_get_relationship_id;
406:
407: IF g_debug then
408: pay_in_utils.trace('nomination share after',l_nomination_share + to_number(p_CEI_INFORMATION2));
409: END IF;
410:
411: IF l_nomination_share + to_number(p_CEI_INFORMATION2) > 100 THEN
412: ---check for percentage--

Line 413: pay_in_utils.trace('Check the value of nomination share','40');

409: END IF;
410:
411: IF l_nomination_share + to_number(p_CEI_INFORMATION2) > 100 THEN
412: ---check for percentage--
413: pay_in_utils.trace('Check the value of nomination share','40');
414: p_message_name := 'PER_IN_NOM_SHARE_MORE';
415: RETURN ;
416: ELSIF l_nomination_share + to_number(p_CEI_INFORMATION2) < 100 THEN
417: --check for percentage--

Line 418: pay_in_utils.trace('Check the value of nomination share less','50');

414: p_message_name := 'PER_IN_NOM_SHARE_MORE';
415: RETURN ;
416: ELSIF l_nomination_share + to_number(p_CEI_INFORMATION2) < 100 THEN
417: --check for percentage--
418: pay_in_utils.trace('Check the value of nomination share less','50');
419: p_message_name := 'PER_IN_NOM_SHARE_LESS';
420: RETURN ;
421: END IF;
422: ELSE

Line 424: pay_in_utils.set_location(g_debug,l_procedure,60);

420: RETURN ;
421: END IF;
422: ELSE
423:
424: pay_in_utils.set_location(g_debug,l_procedure,60);
425: p_message_name := 'PER_IN_CONT_ALREADY_NOMINATED';
426: RETURN;
427: END IF;
428:

Line 431: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,70);

427: END IF;
428:
429: END IF;
430:
431: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,70);
432:
433: EXCEPTION
434: WHEN NO_DATA_FOUND THEN
435: NULL;

Line 480: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type

476: ,p_effective_date IN DATE
477: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
478: ,p_contact_extra_info_id IN PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE
479: ,p_message_name OUT NOCOPY VARCHAR2
480: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
481: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)
482: IS
483: l_nomination_share NUMBER;
484: l_person_id NUMBER;

Line 481: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)

477: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
478: ,p_contact_extra_info_id IN PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE
479: ,p_message_name OUT NOCOPY VARCHAR2
480: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
481: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)
482: IS
483: l_nomination_share NUMBER;
484: l_person_id NUMBER;
485: l_contact_relationship_id NUMBER;

Line 521: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

517: BEGIN
518:
519: g_debug := hr_utility.debug_enabled ;
520: l_procedure := g_package ||'get_essential_update_value';
521: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
522:
523: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
524: hr_utility.trace ('IN Legislation not installed. Not performing the validations');
525: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

Line 525: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

521: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
522:
523: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
524: hr_utility.trace ('IN Legislation not installed. Not performing the validations');
525: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
526: RETURN;
527: END IF;
528:
529: OPEN c_business_group_check(p_contact_relationship_id);

Line 535: pay_in_utils.set_location(g_debug,l_procedure,30);

531: CLOSE c_business_group_check;
532:
533: IF l_legislation_code = 'IN' THEN
534:
535: pay_in_utils.set_location(g_debug,l_procedure,30);
536:
537: l_nomination_share := 0;
538: l_temp := 0;
539: BEGIN

Line 551: pay_in_utils.set_location(g_debug,l_procedure,40);

547: END;
548:
549: IF l_temp = 0 THEN
550: --Get the person Id--
551: pay_in_utils.set_location(g_debug,l_procedure,40);
552:
553:
554: OPEN c_get_person_id;
555: FETCH c_get_person_id into l_person_id;

Line 569: pay_in_utils.trace('nomination share after',l_nomination_share + to_number(p_CEI_INFORMATION2));

565: END LOOP;
566: CLOSE c_get_relationship_id;
567:
568: IF g_debug then
569: pay_in_utils.trace('nomination share after',l_nomination_share + to_number(p_CEI_INFORMATION2));
570: END IF;
571: IF l_nomination_share + to_number(p_CEI_INFORMATION2) > 100 THEN
572: --check for percentage--
573: pay_in_utils.trace('Check the value of nomination share','50');

Line 573: pay_in_utils.trace('Check the value of nomination share','50');

569: pay_in_utils.trace('nomination share after',l_nomination_share + to_number(p_CEI_INFORMATION2));
570: END IF;
571: IF l_nomination_share + to_number(p_CEI_INFORMATION2) > 100 THEN
572: --check for percentage--
573: pay_in_utils.trace('Check the value of nomination share','50');
574: p_message_name := 'PER_IN_NOM_SHARE_MORE';
575: RETURN ;
576: ELSIF l_nomination_share + to_number(p_CEI_INFORMATION2) < 100 THEN
577: --check for percentage--

Line 578: pay_in_utils.trace('Check the value of nomination share less','60');

574: p_message_name := 'PER_IN_NOM_SHARE_MORE';
575: RETURN ;
576: ELSIF l_nomination_share + to_number(p_CEI_INFORMATION2) < 100 THEN
577: --check for percentage--
578: pay_in_utils.trace('Check the value of nomination share less','60');
579: p_message_name := 'PER_IN_NOM_SHARE_LESS';
580: RETURN ;
581: END IF;
582:

Line 585: pay_in_utils.set_location(g_debug,l_procedure,70);

581: END IF;
582:
583: ELSE
584: ----check for status of the nominee------
585: pay_in_utils.set_location(g_debug,l_procedure,70);
586: p_message_name := 'PER_IN_CONT_ALREADY_NOMINATED';
587: RETURN ;
588:
589: END IF;

Line 592: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);

588:
589: END IF;
590:
591: END IF;
592: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
593:
594: EXCEPTION
595: WHEN NO_DATA_FOUND THEN
596: NULL ;

Line 636: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type

632: ,p_effective_date IN DATE
633: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
634: ,p_contact_extra_info_id IN PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE
635: ,p_message_name OUT NOCOPY VARCHAR2
636: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
637: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)
638:
639: IS
640: l_procedure VARCHAR2(100);

Line 637: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)

633: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
634: ,p_contact_extra_info_id IN PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE
635: ,p_message_name OUT NOCOPY VARCHAR2
636: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
637: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)
638:
639: IS
640: l_procedure VARCHAR2(100);
641: l_message VARCHAR2(255);

Line 645: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

641: l_message VARCHAR2(255);
642: BEGIN
643: g_debug := hr_utility.debug_enabled;
644: l_procedure := g_package ||'check_in_con_int';
645: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
646:
647: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
648: hr_utility.trace ('IN Legislation not installed. Not performing the validations');
649: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

Line 649: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

645: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
646:
647: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
648: hr_utility.trace ('IN Legislation not installed. Not performing the validations');
649: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
650: RETURN;
651: END IF;
652:
653: IF p_contact_extra_info_id IS NULL THEN

Line 655: pay_in_utils.set_location(g_debug,l_procedure,30);

651: END IF;
652:
653: IF p_contact_extra_info_id IS NULL THEN
654: --Insert---
655: pay_in_utils.set_location(g_debug,l_procedure,30);
656:
657: -------check age and guardian status-----------------
658:
659: check_nominee_age(p_contact_relationship_id =>p_contact_relationship_id

Line 665: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);

661: ,p_token_name => p_token_name
662: ,p_token_value =>p_token_value);
663:
664: IF p_message_name <>'SUCCESS' THEN
665: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
666: RETURN ;
667: END IF ;
668:
669:

Line 680: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,50);

676: ,p_token_name => p_token_name
677: ,p_token_value =>p_token_value);
678:
679: IF p_message_name <>'SUCCESS' THEN
680: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,50);
681: RETURN ;
682: END IF;
683:
684:

Line 687: pay_in_utils.set_location(g_debug,l_procedure,60);

683:
684:
685: ELSE
686: --Update--
687: pay_in_utils.set_location(g_debug,l_procedure,60);
688:
689: get_essential_update_value
690: (p_CEI_INFORMATION2 => p_CEI_INFORMATION2
691: ,p_CEI_INFORMATION3 => p_CEI_INFORMATION3

Line 700: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,70);

696: ,p_token_name => p_token_name
697: ,p_token_value => p_token_value);
698:
699: IF p_message_name <>'SUCCESS' THEN
700: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,70);
701: RETURN ;
702: END IF;
703:
704: END IF ;

Line 706: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);

702: END IF;
703:
704: END IF ;
705:
706: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
707:
708:
709:
710: END check_in_con_int;

Line 760: pay_in_utils.null_message(p_token_name, p_token_value);

756:
757: g_debug := hr_utility.debug_enabled;
758: l_procedure := g_package ||'check_in_con_insert';
759: p_message_name := 'SUCCESS';
760: pay_in_utils.null_message(p_token_name, p_token_value);
761:
762: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
763:
764: check_in_con_int

Line 762: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

758: l_procedure := g_package ||'check_in_con_insert';
759: p_message_name := 'SUCCESS';
760: pay_in_utils.null_message(p_token_name, p_token_value);
761:
762: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
763:
764: check_in_con_int
765: (p_CEI_INFORMATION2 => p_CEI_INFORMATION2
766: ,p_CEI_INFORMATION3 => p_CEI_INFORMATION3

Line 776: pay_in_utils.trace('PER_IN_NOM_SHARE_LESS','20');

772: ,p_token_value => p_token_value);
773:
774:
775: IF p_message_name in ('PER_IN_NOM_SHARE_LESS') THEN
776: pay_in_utils.trace('PER_IN_NOM_SHARE_LESS','20');
777: ELSIF p_message_name <> 'HR_7207_API_MANDATORY_ARG' THEN
778: pay_in_utils.raise_message(800, p_message_name, p_token_name, p_token_value);
779: ELSE
780: pay_in_utils.raise_message(801, p_message_name, p_token_name, p_token_value);

Line 778: pay_in_utils.raise_message(800, p_message_name, p_token_name, p_token_value);

774:
775: IF p_message_name in ('PER_IN_NOM_SHARE_LESS') THEN
776: pay_in_utils.trace('PER_IN_NOM_SHARE_LESS','20');
777: ELSIF p_message_name <> 'HR_7207_API_MANDATORY_ARG' THEN
778: pay_in_utils.raise_message(800, p_message_name, p_token_name, p_token_value);
779: ELSE
780: pay_in_utils.raise_message(801, p_message_name, p_token_name, p_token_value);
781: END IF;
782:

Line 780: pay_in_utils.raise_message(801, p_message_name, p_token_name, p_token_value);

776: pay_in_utils.trace('PER_IN_NOM_SHARE_LESS','20');
777: ELSIF p_message_name <> 'HR_7207_API_MANDATORY_ARG' THEN
778: pay_in_utils.raise_message(800, p_message_name, p_token_name, p_token_value);
779: ELSE
780: pay_in_utils.raise_message(801, p_message_name, p_token_name, p_token_value);
781: END IF;
782:
783: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
784:

Line 783: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);

779: ELSE
780: pay_in_utils.raise_message(801, p_message_name, p_token_name, p_token_value);
781: END IF;
782:
783: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
784:
785: END check_in_con_insert ;
786:
787: -- -----------------------------------------------------------------------+

Line 846: pay_in_utils.null_message(p_token_name, p_token_value);

842:
843: g_debug := hr_utility.debug_enabled;
844: l_procedure := g_package ||'check_in_con_update';
845: p_message_name := 'SUCCESS';
846: pay_in_utils.null_message(p_token_name, p_token_value);
847:
848: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
849:
850: OPEN c_nom_id;

Line 848: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

844: l_procedure := g_package ||'check_in_con_update';
845: p_message_name := 'SUCCESS';
846: pay_in_utils.null_message(p_token_name, p_token_value);
847:
848: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
849:
850: OPEN c_nom_id;
851: FETCH c_nom_id
852: INTO l_CEI_INFORMATION2

Line 857: pay_in_utils.set_location(g_debug,l_procedure,20);

853: ,l_CEI_INFORMATION3
854: ,l_contact_relationship_id;
855: CLOSE c_nom_id;
856:
857: pay_in_utils.set_location(g_debug,l_procedure,20);
858:
859: IF p_CEI_INFORMATION2 <> hr_api.g_varchar2 THEN
860: l_CEI_INFORMATION2 := p_CEI_INFORMATION2;
861: END IF;

Line 879: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);

875: ,p_token_name => p_token_name
876: ,p_token_value => p_token_value
877: );
878:
879: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
880:
881: IF p_message_name in ('PER_IN_NOM_SHARE_LESS') THEN
882: hr_utility.trace('PER_IN_NOM_SHARE_LESS');
883: pay_in_utils.trace('PER_IN_NOM_SHARE_LESS','40');

Line 883: pay_in_utils.trace('PER_IN_NOM_SHARE_LESS','40');

879: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
880:
881: IF p_message_name in ('PER_IN_NOM_SHARE_LESS') THEN
882: hr_utility.trace('PER_IN_NOM_SHARE_LESS');
883: pay_in_utils.trace('PER_IN_NOM_SHARE_LESS','40');
884: ELSIF p_message_name <> 'HR_7207_API_MANDATORY_ARG' THEN
885: pay_in_utils.raise_message(800, p_message_name, p_token_name, p_token_value);
886: ELSE
887: pay_in_utils.raise_message(801, p_message_name, p_token_name, p_token_value);

Line 885: pay_in_utils.raise_message(800, p_message_name, p_token_name, p_token_value);

881: IF p_message_name in ('PER_IN_NOM_SHARE_LESS') THEN
882: hr_utility.trace('PER_IN_NOM_SHARE_LESS');
883: pay_in_utils.trace('PER_IN_NOM_SHARE_LESS','40');
884: ELSIF p_message_name <> 'HR_7207_API_MANDATORY_ARG' THEN
885: pay_in_utils.raise_message(800, p_message_name, p_token_name, p_token_value);
886: ELSE
887: pay_in_utils.raise_message(801, p_message_name, p_token_name, p_token_value);
888: END IF;
889:

Line 887: pay_in_utils.raise_message(801, p_message_name, p_token_name, p_token_value);

883: pay_in_utils.trace('PER_IN_NOM_SHARE_LESS','40');
884: ELSIF p_message_name <> 'HR_7207_API_MANDATORY_ARG' THEN
885: pay_in_utils.raise_message(800, p_message_name, p_token_name, p_token_value);
886: ELSE
887: pay_in_utils.raise_message(801, p_message_name, p_token_name, p_token_value);
888: END IF;
889:
890: END check_in_con_update ;
891:

Line 935: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

931:
932: BEGIN
933: g_debug := hr_utility.debug_enabled;
934: l_procedure := 'get_nomination_share';
935: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
936: l_nomination_share := 0;
937: l_nom := 0;
938:
939: OPEN c_nomination_share;

Line 942: pay_in_utils.trace('l_nom',l_nom);

938:
939: OPEN c_nomination_share;
940: LOOP
941: FETCH c_nomination_share INTO l_nom;
942: pay_in_utils.trace('l_nom',l_nom);
943: EXIT WHEN c_nomination_share%NOTFOUND;
944: l_nomination_share := l_nomination_share + l_nom;
945: END LOOP;
946: CLOSE c_nomination_share;

Line 948: pay_in_utils.trace('l_nomination_share',l_nomination_share);

944: l_nomination_share := l_nomination_share + l_nom;
945: END LOOP;
946: CLOSE c_nomination_share;
947:
948: pay_in_utils.trace('l_nomination_share',l_nomination_share);
949: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
950:
951: RETURN l_nomination_share;
952:

Line 949: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);

945: END LOOP;
946: CLOSE c_nomination_share;
947:
948: pay_in_utils.trace('l_nomination_share',l_nomination_share);
949: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
950:
951: RETURN l_nomination_share;
952:
953: EXCEPTION