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_TPS_BUS1 dependencies on HR_API

Line 50: hr_api.mandatory_arg_error

46: ,p_associated_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
47: ,p_associated_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
48: ) THEN
49:
50: hr_api.mandatory_arg_error
51: (p_api_name => l_proc
52: ,p_argument => 'p_time_period_id'
53: ,p_argument_value => p_time_period_id
54: );

Line 68: NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>

64: -- If the time_period is changing
65: -- or this is an insert
66: --
67: IF (l_api_updating AND
68: NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>
69: NVL(p_time_period_id, hr_api.g_number) )
70: OR (NOT l_api_updating)
71: THEN
72: hr_utility.set_location(' Step:'|| l_proc, 50);

Line 69: NVL(p_time_period_id, hr_api.g_number) )

65: -- or this is an insert
66: --
67: IF (l_api_updating AND
68: NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>
69: NVL(p_time_period_id, hr_api.g_number) )
70: OR (NOT l_api_updating)
71: THEN
72: hr_utility.set_location(' Step:'|| l_proc, 50);
73: OPEN csr_unique;

Line 174: hr_api.mandatory_arg_error

170: --
171: -- check mandatory parameters have been set
172: --
173: hr_utility.set_location(' Step:'|| l_proc, 20);
174: hr_api.mandatory_arg_error
175: (p_api_name => l_proc
176: ,p_argument => 'p_business_group_id'
177: ,p_argument_value => p_business_group_id
178: );

Line 240: hr_api.mandatory_arg_error

236: --
237: -- check mandatory parameters have been set
238: --
239: hr_utility.set_location(' Step:'|| l_proc, 20);
240: hr_api.mandatory_arg_error
241: (p_api_name => l_proc
242: ,p_argument => 'p_business_group_id'
243: ,p_argument_value => p_business_group_id
244: );

Line 315: hr_api.mandatory_arg_error

311: --
312: -- check mandatory parameters have been set
313: --
314: hr_utility.set_location(' Step:'|| l_proc, 20);
315: hr_api.mandatory_arg_error
316: (p_api_name => l_proc
317: ,p_argument => 'p_business_group_id'
318: ,p_argument_value => p_business_group_id
319: );

Line 330: (NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>

326: -- If the time_period is changing
327: -- or this is an insert
328: --
329: IF (l_api_updating AND
330: (NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>
331: NVL(p_time_period_id, hr_api.g_number) )
332: OR (NOT l_api_updating))
333: THEN
334: --

Line 331: NVL(p_time_period_id, hr_api.g_number) )

327: -- or this is an insert
328: --
329: IF (l_api_updating AND
330: (NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>
331: NVL(p_time_period_id, hr_api.g_number) )
332: OR (NOT l_api_updating))
333: THEN
334: --
335: -- The time period_id must exist in per_time_periods

Line 354: NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>

350: -- in OTA_TRAINING_PLAN_MEMBERS
351: --
352: hr_utility.set_location(' Step:'|| l_proc, 40);
353: IF l_api_updating AND
354: NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>
355: NVL(p_time_period_id, hr_api.g_number) THEN
356: hr_utility.set_location(' Step:'|| l_proc, 50);
357: OPEN csr_members;
358: FETCH csr_members INTO l_exists;

Line 355: NVL(p_time_period_id, hr_api.g_number) THEN

351: --
352: hr_utility.set_location(' Step:'|| l_proc, 40);
353: IF l_api_updating AND
354: NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>
355: NVL(p_time_period_id, hr_api.g_number) THEN
356: hr_utility.set_location(' Step:'|| l_proc, 50);
357: OPEN csr_members;
358: FETCH csr_members INTO l_exists;
359: IF csr_members%FOUND THEN

Line 402: hr_api.mandatory_arg_error

398: -- check mandatory parameters have been set
399: --
400: --
401: hr_utility.set_location(' Step:'|| l_proc, 10);
402: hr_api.mandatory_arg_error
403: (p_api_name => l_proc
404: ,p_argument => 'p_plan_status_type_id'
405: ,p_argument_value => p_plan_status_type_id
406: );

Line 409: IF hr_api.not_exists_in_hr_lookups

405: ,p_argument_value => p_plan_status_type_id
406: );
407: --
408: hr_utility.set_location(' Step:'|| l_proc, 20);
409: IF hr_api.not_exists_in_hr_lookups
410: (p_effective_date => p_effective_date
411: ,p_lookup_type => 'OTA_PLAN_USER_STATUS_TYPE'
412: ,p_lookup_code => p_plan_status_type_id
413: ) THEN

Line 509: hr_api.mandatory_arg_error

505: ,p_associated_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
506: ,p_associated_column4 => 'OTA_TRAINING_PLANS.PLAN_STATUS_TYPE_ID'
507: ) THEN
508:
509: hr_api.mandatory_arg_error
510: (p_api_name => l_proc
511: ,p_argument => 'p_plan_status_type_id'
512: ,p_argument_value => p_plan_status_type_id
513: );

Line 517: hr_api.mandatory_arg_error

513: );
514: --
515: --
516: hr_utility.set_location(' Step:'|| l_proc, 20);
517: hr_api.mandatory_arg_error
518: (p_api_name => l_proc
519: ,p_argument => 'p_time_period_id'
520: ,p_argument_value => p_time_period_id
521: );

Line 535: (NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>

531: -- or the time period is changing
532: -- or this is an insert and its not cancelled
533: --
534: IF (l_api_updating AND
535: (NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>
536: NVL(p_time_period_id, hr_api.g_number)
537: AND p_plan_status_type_id <> 'CANCELLED' )
538: OR (NVL(ota_tps_shd.g_old_rec.plan_status_type_id, hr_api.g_varchar2) <>
539: NVL(p_plan_status_type_id, hr_api.g_varchar2)

Line 536: NVL(p_time_period_id, hr_api.g_number)

532: -- or this is an insert and its not cancelled
533: --
534: IF (l_api_updating AND
535: (NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>
536: NVL(p_time_period_id, hr_api.g_number)
537: AND p_plan_status_type_id <> 'CANCELLED' )
538: OR (NVL(ota_tps_shd.g_old_rec.plan_status_type_id, hr_api.g_varchar2) <>
539: NVL(p_plan_status_type_id, hr_api.g_varchar2)
540: AND

Line 538: OR (NVL(ota_tps_shd.g_old_rec.plan_status_type_id, hr_api.g_varchar2) <>

534: IF (l_api_updating AND
535: (NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>
536: NVL(p_time_period_id, hr_api.g_number)
537: AND p_plan_status_type_id <> 'CANCELLED' )
538: OR (NVL(ota_tps_shd.g_old_rec.plan_status_type_id, hr_api.g_varchar2) <>
539: NVL(p_plan_status_type_id, hr_api.g_varchar2)
540: AND
541: (p_plan_status_type_id <> 'CANCELLED') )
542: OR (NOT l_api_updating AND p_plan_status_type_id <> 'CANCELLED'))

Line 539: NVL(p_plan_status_type_id, hr_api.g_varchar2)

535: (NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>
536: NVL(p_time_period_id, hr_api.g_number)
537: AND p_plan_status_type_id <> 'CANCELLED' )
538: OR (NVL(ota_tps_shd.g_old_rec.plan_status_type_id, hr_api.g_varchar2) <>
539: NVL(p_plan_status_type_id, hr_api.g_varchar2)
540: AND
541: (p_plan_status_type_id <> 'CANCELLED') )
542: OR (NOT l_api_updating AND p_plan_status_type_id <> 'CANCELLED'))
543: THEN

Line 611: hr_api.mandatory_arg_error

607: -- check mandatory parameters have been set. Currency code can
608: -- be null, so it is not mandatory.
609: --
610: hr_utility.set_location(' Step:'|| l_proc, 30);
611: hr_api.mandatory_arg_error
612: (p_api_name => l_proc
613: ,p_argument => 'p_business_group_id'
614: ,p_argument_value => p_business_group_id
615: );

Line 618: hr_api.mandatory_arg_error

614: ,p_argument_value => p_business_group_id
615: );
616: --
617: hr_utility.set_location(' Step:'|| l_proc, 40);
618: hr_api.mandatory_arg_error
619: (p_api_name => l_proc
620: ,p_argument => 'p_budget_currency'
621: ,p_argument_value => p_budget_currency
622: );

Line 632: NVL(ota_tps_shd.g_old_rec.budget_currency, hr_api.g_varchar2) <>

628: --
629: -- If this is a changing update, or a new insert, test
630: --
631: IF ((l_api_updating AND
632: NVL(ota_tps_shd.g_old_rec.budget_currency, hr_api.g_varchar2) <>
633: NVL(p_budget_currency, hr_api.g_varchar2) )
634: OR (NOT l_api_updating))
635: THEN
636: hr_utility.set_location(' Step:'|| l_proc, 50);

Line 633: NVL(p_budget_currency, hr_api.g_varchar2) )

629: -- If this is a changing update, or a new insert, test
630: --
631: IF ((l_api_updating AND
632: NVL(ota_tps_shd.g_old_rec.budget_currency, hr_api.g_varchar2) <>
633: NVL(p_budget_currency, hr_api.g_varchar2) )
634: OR (NOT l_api_updating))
635: THEN
636: hr_utility.set_location(' Step:'|| l_proc, 50);
637: IF p_budget_currency IS NOT NULL THEN

Line 709: hr_api.mandatory_arg_error

705: --
706: -- check mandatory parameters have been set
707: --
708: hr_utility.set_location('Entering:'||l_proc, 5);
709: hr_api.mandatory_arg_error
710: (p_api_name => l_proc
711: ,p_argument => 'p_name'
712: ,p_argument_value => p_name
713: );

Line 725: NVL(ota_tps_shd.g_old_rec.name, hr_api.g_varchar2) <>

721: --
722: -- If this is a changing update, or a new insert, test
723: --
724: IF ((l_api_updating AND
725: NVL(ota_tps_shd.g_old_rec.name, hr_api.g_varchar2) <>
726: NVL(p_name, hr_api.g_varchar2) )
727: OR (NOT l_api_updating))
728: THEN
729: hr_utility.set_location(' Step:'|| l_proc, 50);

Line 726: NVL(p_name, hr_api.g_varchar2) )

722: -- If this is a changing update, or a new insert, test
723: --
724: IF ((l_api_updating AND
725: NVL(ota_tps_shd.g_old_rec.name, hr_api.g_varchar2) <>
726: NVL(p_name, hr_api.g_varchar2) )
727: OR (NOT l_api_updating))
728: THEN
729: hr_utility.set_location(' Step:'|| l_proc, 50);
730: IF p_name IS NOT NULL THEN

Line 801: hr_api.mandatory_arg_error

797: --
798: -- check mandatory parameters have been set
799: --
800: hr_utility.set_location('Entering:'||l_proc, 5);
801: hr_api.mandatory_arg_error
802: (p_api_name => l_proc
803: ,p_argument => 'p_training_plan_id'
804: ,p_argument_value => p_training_plan_id
805: );

Line 840: hr_api.mandatory_arg_error

836: hr_utility.set_location(' Leaving:'||l_proc, 10);
837: --
838: -- check mandatory parameters has been set
839: --
840: hr_api.mandatory_arg_error
841: (p_api_name => l_proc
842: ,p_argument => 'effective_date'
843: ,p_argument_value => p_effective_date);
844:

Line 846: NVL(ota_tps_shd.g_old_rec.plan_source,hr_api.g_varchar2) <>

842: ,p_argument => 'effective_date'
843: ,p_argument_value => p_effective_date);
844:
845: IF (((p_training_plan_id IS NOT NULL) AND
846: NVL(ota_tps_shd.g_old_rec.plan_source,hr_api.g_varchar2) <>
847: NVL(p_plan_source,hr_api.g_varchar2))
848: OR
849: (p_training_plan_id IS NULL)) THEN
850:

Line 847: NVL(p_plan_source,hr_api.g_varchar2))

843: ,p_argument_value => p_effective_date);
844:
845: IF (((p_training_plan_id IS NOT NULL) AND
846: NVL(ota_tps_shd.g_old_rec.plan_source,hr_api.g_varchar2) <>
847: NVL(p_plan_source,hr_api.g_varchar2))
848: OR
849: (p_training_plan_id IS NULL)) THEN
850:
851: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 856: IF hr_api.not_exists_in_hr_lookups

852: --
853:
854: --
855: IF p_plan_source IS NOT NULL THEN
856: IF hr_api.not_exists_in_hr_lookups
857: (p_effective_date => p_effective_date
858: ,p_lookup_type => 'OTA_TRAINING_PLAN_SOURCE'
859: ,p_lookup_code => p_plan_source) THEN
860: fnd_message.set_name('OTA','OTA_13176_TPM_PLN_SRC_INVLD');

Line 926: hr_api.mandatory_arg_error

922: -- check mandatory parameters have been set
923: --
924: hr_utility.set_location(' Step:'|| l_proc, 10);
925:
926: hr_api.mandatory_arg_error
927: (p_api_name => l_proc
928: ,p_argument => 'p_start_date'
929: ,p_argument_value => p_start_date
930: );

Line 941: NVL( ota_tps_shd.g_old_rec.start_date, hr_api.g_date ) <>

937: --
938: -- If this is a changing update, or a new insert, test
939: --
940: IF ((l_api_updating AND
941: NVL( ota_tps_shd.g_old_rec.start_date, hr_api.g_date ) <>
942: NVL( p_start_date, hr_api.g_date )
943: OR NVL( ota_tps_shd.g_old_rec.end_date, hr_api.g_date ) <>
944: NVL( p_end_date, hr_api.g_date) )
945: OR ( NOT l_api_updating) )

Line 942: NVL( p_start_date, hr_api.g_date )

938: -- If this is a changing update, or a new insert, test
939: --
940: IF ((l_api_updating AND
941: NVL( ota_tps_shd.g_old_rec.start_date, hr_api.g_date ) <>
942: NVL( p_start_date, hr_api.g_date )
943: OR NVL( ota_tps_shd.g_old_rec.end_date, hr_api.g_date ) <>
944: NVL( p_end_date, hr_api.g_date) )
945: OR ( NOT l_api_updating) )
946: THEN

Line 943: OR NVL( ota_tps_shd.g_old_rec.end_date, hr_api.g_date ) <>

939: --
940: IF ((l_api_updating AND
941: NVL( ota_tps_shd.g_old_rec.start_date, hr_api.g_date ) <>
942: NVL( p_start_date, hr_api.g_date )
943: OR NVL( ota_tps_shd.g_old_rec.end_date, hr_api.g_date ) <>
944: NVL( p_end_date, hr_api.g_date) )
945: OR ( NOT l_api_updating) )
946: THEN
947: hr_utility.set_location(' Step:'|| l_proc, 20);

Line 944: NVL( p_end_date, hr_api.g_date) )

940: IF ((l_api_updating AND
941: NVL( ota_tps_shd.g_old_rec.start_date, hr_api.g_date ) <>
942: NVL( p_start_date, hr_api.g_date )
943: OR NVL( ota_tps_shd.g_old_rec.end_date, hr_api.g_date ) <>
944: NVL( p_end_date, hr_api.g_date) )
945: OR ( NOT l_api_updating) )
946: THEN
947: hr_utility.set_location(' Step:'|| l_proc, 20);
948:

Line 950: or NVL( ota_tps_shd.g_old_rec.start_date, hr_api.g_date ) <>

946: THEN
947: hr_utility.set_location(' Step:'|| l_proc, 20);
948:
949: /* IF ( NOT l_api_updating
950: or NVL( ota_tps_shd.g_old_rec.start_date, hr_api.g_date ) <>
951: NVL( p_start_date, hr_api.g_date )) THEN
952:
953: IF ( p_start_date < TRUNC(SYSDATE) ) THEN
954: l_flag :='START_DATE';

Line 951: NVL( p_start_date, hr_api.g_date )) THEN

947: hr_utility.set_location(' Step:'|| l_proc, 20);
948:
949: /* IF ( NOT l_api_updating
950: or NVL( ota_tps_shd.g_old_rec.start_date, hr_api.g_date ) <>
951: NVL( p_start_date, hr_api.g_date )) THEN
952:
953: IF ( p_start_date < TRUNC(SYSDATE) ) THEN
954: l_flag :='START_DATE';
955: fnd_message.set_name('OTA', 'OTA_13999_TPS_STRT_DATE');