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.OTA_TEA_BUS dependencies on HR_UTILITY

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

364: and cancelled_flag <> 'Y';
365: --
366: begin
367: --
368: hr_utility.set_location('Entering '||l_proc,10);
369: --
370: -- Display values of all variables passed in
371: --
372: hr_utility.trace('p_booking_deal_id '||p_booking_deal_id);

Line 372: hr_utility.trace('p_booking_deal_id '||p_booking_deal_id);

368: hr_utility.set_location('Entering '||l_proc,10);
369: --
370: -- Display values of all variables passed in
371: --
372: hr_utility.trace('p_booking_deal_id '||p_booking_deal_id);
373: hr_utility.trace('p_event_id '||p_event_id);
374: hr_utility.trace('p_money_amount '||p_money_amount);
375: hr_utility.trace('p_finance_header_id'||p_finance_header_id);
376: --

Line 373: hr_utility.trace('p_event_id '||p_event_id);

369: --
370: -- Display values of all variables passed in
371: --
372: hr_utility.trace('p_booking_deal_id '||p_booking_deal_id);
373: hr_utility.trace('p_event_id '||p_event_id);
374: hr_utility.trace('p_money_amount '||p_money_amount);
375: hr_utility.trace('p_finance_header_id'||p_finance_header_id);
376: --
377: -- get pre_purchase_agreement_details

Line 374: hr_utility.trace('p_money_amount '||p_money_amount);

370: -- Display values of all variables passed in
371: --
372: hr_utility.trace('p_booking_deal_id '||p_booking_deal_id);
373: hr_utility.trace('p_event_id '||p_event_id);
374: hr_utility.trace('p_money_amount '||p_money_amount);
375: hr_utility.trace('p_finance_header_id'||p_finance_header_id);
376: --
377: -- get pre_purchase_agreement_details
378: --

Line 375: hr_utility.trace('p_finance_header_id'||p_finance_header_id);

371: --
372: hr_utility.trace('p_booking_deal_id '||p_booking_deal_id);
373: hr_utility.trace('p_event_id '||p_event_id);
374: hr_utility.trace('p_money_amount '||p_money_amount);
375: hr_utility.trace('p_finance_header_id'||p_finance_header_id);
376: --
377: -- get pre_purchase_agreement_details
378: --
379: open c_pre_purchase_limit;

Line 418: hr_utility.trace(p_money_amount||' '||l_amount_so_far);

414: close c_amount_so_far;
415: --
416: -- Check if limit exceeded
417: --
418: hr_utility.trace(p_money_amount||' '||l_amount_so_far);
419: hr_utility.trace(l_overdraft_limit||' '||l_pre_purchase_limit);
420: if (p_money_amount + l_amount_so_far) >
421: (l_overdraft_limit + l_pre_purchase_limit) then
422: --

Line 419: hr_utility.trace(l_overdraft_limit||' '||l_pre_purchase_limit);

415: --
416: -- Check if limit exceeded
417: --
418: hr_utility.trace(p_money_amount||' '||l_amount_so_far);
419: hr_utility.trace(l_overdraft_limit||' '||l_pre_purchase_limit);
420: if (p_money_amount + l_amount_so_far) >
421: (l_overdraft_limit + l_pre_purchase_limit) then
422: --
423: hr_utility.trace('Set Warning Flag');

Line 423: hr_utility.trace('Set Warning Flag');

419: hr_utility.trace(l_overdraft_limit||' '||l_pre_purchase_limit);
420: if (p_money_amount + l_amount_so_far) >
421: (l_overdraft_limit + l_pre_purchase_limit) then
422: --
423: hr_utility.trace('Set Warning Flag');
424: l_warn := true;
425: --
426: end if;
427: --

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

428: end if;
429: --
430: -- Check if warning message needed
431: --
432: hr_utility.set_location('Leaving '||l_proc,10);
433: --
434: if l_warn then
435: --
436: return true;

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

511: ,nvl(l_job_id,-1))
512: and nvl(position_id,-1) = decode(position_id,null,-1
513: ,nvl(l_position_id,-1));
514: begin
515: hr_utility.set_location('Entering:'||l_proc, 5);
516: if p_customer_id is not null then
517: open get_external_enrollments;
518: fetch get_external_enrollments into l_exists;
519: if get_external_enrollments%notfound then

Line 527: hr_utility.trace('step 1');

523: end if;
524: close get_external_enrollments;
525: --
526: elsif p_customer_id is null then
527: hr_utility.trace('step 1');
528: for internal_enrollments in get_internal_enrollments loop
529: -- Test whether the Enrollment matches the new criteria
530: hr_utility.trace('step 2');
531: if ((p_organization_id is not null

Line 530: hr_utility.trace('step 2');

526: elsif p_customer_id is null then
527: hr_utility.trace('step 1');
528: for internal_enrollments in get_internal_enrollments loop
529: -- Test whether the Enrollment matches the new criteria
530: hr_utility.trace('step 2');
531: if ((p_organization_id is not null
532: and p_organization_id = internal_enrollments.organization_id)
533: or p_organization_id is null)
534: and ((p_job_id is not null

Line 543: hr_utility.trace('step 3');

539: or p_position_id is null)
540: then null;
541: else
542: --
543: hr_utility.trace('step 3');
544: -- If it doesnt match then look for another set of criteria
545: open get_associations(internal_enrollments.organization_id
546: ,internal_enrollments.job_id
547: ,internal_enrollments.position_id);

Line 548: hr_utility.trace('step 4');

544: -- If it doesnt match then look for another set of criteria
545: open get_associations(internal_enrollments.organization_id
546: ,internal_enrollments.job_id
547: ,internal_enrollments.position_id);
548: hr_utility.trace('step 4');
549: fetch get_associations into l_exists;
550: hr_utility.trace('step 5');
551:
552: if get_associations%notfound then

Line 550: hr_utility.trace('step 5');

546: ,internal_enrollments.job_id
547: ,internal_enrollments.position_id);
548: hr_utility.trace('step 4');
549: fetch get_associations into l_exists;
550: hr_utility.trace('step 5');
551:
552: if get_associations%notfound then
553: close get_associations;
554: fnd_message.set_name('OTA','OTA_13532_TEA_CRITERIA_UNMATCH');

Line 557: hr_utility.trace('step 6');

553: close get_associations;
554: fnd_message.set_name('OTA','OTA_13532_TEA_CRITERIA_UNMATCH');
555: fnd_message.raise_error;
556: end if;
557: hr_utility.trace('step 6');
558: close get_associations;
559: end if;
560: end loop;
561: end if;

Line 562: hr_utility.set_location('Leaving:'||l_proc, 5);

558: close get_associations;
559: end if;
560: end loop;
561: end if;
562: hr_utility.set_location('Leaving:'||l_proc, 5);
563: end check_enrollments;
564: --=======================================================
565: --=======================================================
566: procedure delete_check_tdb (

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

807: l_proc varchar2(72) := g_package||'insert_validate';
808: l_price_basis ota_events.price_basis%type; /* bug no 3476078 */
809: --
810: Begin
811: hr_utility.set_location('Entering:'||l_proc, 5);
812: --
813: -- Call all supporting business operations
814: --
815: if p_association_type = 'C' then

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

835: end if;
836: --
837: check_public_event_flag(p_rec.event_id);
838: --
839: hr_utility.set_location(' Leaving:'||l_proc, 10);
840: End insert_validate;
841: --
842: -- ----------------------------------------------------------------------------
843: -- |---------------------------< update_validate >----------------------------|

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

861: ota_general.value_changed( ota_tea_shd.g_old_rec.position_id
862: , p_rec.position_id );
863: --
864: Begin
865: hr_utility.set_location('Entering:'||l_proc, 5);
866: --
867: -- Call all supporting business operations
868: --
869: if p_association_type = 'C' then

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

903: ,p_position_id => p_rec.position_id);
904: end if;
905: end if;
906: --
907: hr_utility.set_location(' Leaving:'||l_proc, 10);
908: End update_validate;
909: --
910: -- ----------------------------------------------------------------------------
911: -- |---------------------------< delete_validate >----------------------------|

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

914: --
915: l_proc varchar2(72) := g_package||'delete_validate';
916: --
917: Begin
918: hr_utility.set_location('Entering:'||l_proc, 5);
919: --
920: -- Call all supporting business operations
921: --
922: delete_check_tdb(p_event_association_id => p_rec.event_association_id);

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

920: -- Call all supporting business operations
921: --
922: delete_check_tdb(p_event_association_id => p_rec.event_association_id);
923: --
924: hr_utility.set_location(' Leaving:'||l_proc, 10);
925: End delete_validate;
926: --
927: end ota_tea_bus;