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

Line 32: hr_utility.set_location(' Step:'|| l_proc, 20);

28: BEGIN
29: --
30: -- check mandatory parameters have been set
31: --
32: hr_utility.set_location(' Step:'|| l_proc, 20);
33: hr_api.mandatory_arg_error
34: (p_api_name => l_proc
35: ,p_argument => 'p_training_plan_id'
36: ,p_argument_value => p_training_plan_id

Line 39: hr_utility.set_location(' Step:'|| l_proc, 30);

35: ,p_argument => 'p_training_plan_id'
36: ,p_argument_value => p_training_plan_id
37: );
38: --
39: hr_utility.set_location(' Step:'|| l_proc, 30);
40: hr_api.mandatory_arg_error
41: (p_api_name => l_proc
42: ,p_argument => 'p_business_group_id'
43: ,p_argument_value => p_business_group_id

Line 47: hr_utility.set_location(' Step:'|| l_proc, 50);

43: ,p_argument_value => p_business_group_id
44: );
45: --
46: --
47: hr_utility.set_location(' Step:'|| l_proc, 50);
48: OPEN csr_training_plan_id;
49: FETCH csr_training_plan_id INTO l_exists;
50: IF csr_training_plan_id%NOTFOUND THEN
51: CLOSE csr_training_plan_id;

Line 52: hr_utility.set_location(' Step:'|| l_proc, 60);

48: OPEN csr_training_plan_id;
49: FETCH csr_training_plan_id INTO l_exists;
50: IF csr_training_plan_id%NOTFOUND THEN
51: CLOSE csr_training_plan_id;
52: hr_utility.set_location(' Step:'|| l_proc, 60);
53: fnd_message.set_name('OTA', 'OTA_13828_TPC_NO_TRAINING_PLAN');
54: fnd_message.raise_error;
55: ELSE
56: hr_utility.set_location(' Step:'|| l_proc, 80);

Line 56: hr_utility.set_location(' Step:'|| l_proc, 80);

52: hr_utility.set_location(' Step:'|| l_proc, 60);
53: fnd_message.set_name('OTA', 'OTA_13828_TPC_NO_TRAINING_PLAN');
54: fnd_message.raise_error;
55: ELSE
56: hr_utility.set_location(' Step:'|| l_proc, 80);
57: CLOSE csr_training_plan_id;
58: END IF;
59: --
60: hr_utility.set_location(' Leaving:'||l_proc, 90);

Line 60: hr_utility.set_location(' Leaving:'||l_proc, 90);

56: hr_utility.set_location(' Step:'|| l_proc, 80);
57: CLOSE csr_training_plan_id;
58: END IF;
59: --
60: hr_utility.set_location(' Leaving:'||l_proc, 90);
61:
62: EXCEPTION
63:
64: WHEN app_exception.application_exception THEN

Line 69: hr_utility.set_location(' Leaving:'||l_proc, 92);

65:
66: IF hr_multi_message.exception_add
67: (p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID') THEN
68:
69: hr_utility.set_location(' Leaving:'||l_proc, 92);
70: RAISE;
71: END IF;
72:
73: hr_utility.set_location(' Leaving:'||l_proc, 94);

Line 73: hr_utility.set_location(' Leaving:'||l_proc, 94);

69: hr_utility.set_location(' Leaving:'||l_proc, 92);
70: RAISE;
71: END IF;
72:
73: hr_utility.set_location(' Leaving:'||l_proc, 94);
74:
75: END chk_training_plan_id;
76: -- ----------------------------------------------------------------------------
77: -- |----------------------------------------------|

Line 100: hr_utility.set_location(' Step:'|| l_proc, 10);

96: BEGIN
97: --
98: -- check mandatory parameters have been set.
99: --
100: hr_utility.set_location(' Step:'|| l_proc, 10);
101: hr_api.mandatory_arg_error
102: (p_api_name => l_proc
103: ,p_argument => 'p_business_group_id'
104: ,p_argument_value => p_business_group_id

Line 122: hr_utility.set_location(' Step:'|| l_proc, 20);

118: OR (NOT l_api_updating) )
119: THEN
120: -- Check that the definition exists
121: --
122: hr_utility.set_location(' Step:'|| l_proc, 20);
123: OPEN csr_activity_definition_id;
124: FETCH csr_activity_definition_id INTO l_business_group_id;
125: IF csr_activity_definition_id%NOTFOUND THEN
126: CLOSE csr_activity_definition_id;

Line 135: hr_utility.set_location(' Step:'|| l_proc, 30);

131: CLOSE csr_activity_definition_id;
132: fnd_message.set_name('OTA', 'OTA_13849_TPM_WRONG_ACT_DEF');
133: fnd_message.raise_error;
134: ELSE
135: hr_utility.set_location(' Step:'|| l_proc, 30);
136: CLOSE csr_activity_definition_id;
137: END IF;
138: END IF;
139: END IF;

Line 142: hr_utility.set_location(' Leaving:'||l_proc, 40);

138: END IF;
139: END IF;
140: END IF;
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 40);
143:
144: EXCEPTION
145:
146: WHEN app_exception.application_exception THEN

Line 151: hr_utility.set_location(' Leaving:'||l_proc, 42);

147:
148: IF hr_multi_message.exception_add
149: (p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN
150:
151: hr_utility.set_location(' Leaving:'||l_proc, 42);
152: RAISE;
153: END IF;
154:
155: hr_utility.set_location(' Leaving:'||l_proc, 44);

Line 155: hr_utility.set_location(' Leaving:'||l_proc, 44);

151: hr_utility.set_location(' Leaving:'||l_proc, 42);
152: RAISE;
153: END IF;
154:
155: hr_utility.set_location(' Leaving:'||l_proc, 44);
156:
157: END chk_activity_definition_id;
158: -- ----------------------------------------------------------------------------
159: -- |--------------------------------------------------|

Line 185: hr_utility.set_location(' Step:'|| l_proc, 30);

181: --
182: -- check mandatory parameters have been set
183: --
184: --
185: hr_utility.set_location(' Step:'|| l_proc, 30);
186: hr_api.mandatory_arg_error
187: (p_api_name => l_proc
188: ,p_argument => 'p_business_group_id'
189: ,p_argument_value => p_business_group_id

Line 193: hr_utility.set_location(' Step:'|| l_proc, 40);

189: ,p_argument_value => p_business_group_id
190: );
191: --
192: --
193: hr_utility.set_location(' Step:'|| l_proc, 40);
194: hr_api.mandatory_arg_error
195: (p_api_name => l_proc
196: ,p_argument => 'p_training_plan_id'
197: ,p_argument_value => p_training_plan_id

Line 223: hr_utility.set_location(' Step:'|| l_proc, 50);

219: NVL(p_activity_version_id, hr_api.g_number)
220: OR NVL(ota_tpm_shd.g_old_rec.activity_definition_id, hr_api.g_number) <>
221: NVL(p_activity_definition_id, hr_api.g_number) )) THEN
222: --
223: hr_utility.set_location(' Step:'|| l_proc, 50);
224: OPEN csr_version_definition;
225: FETCH csr_version_definition INTO l_exists;
226: IF csr_version_definition%FOUND THEN
227: CLOSE csr_version_definition;

Line 228: hr_utility.set_location(' Step:'|| l_proc, 60);

224: OPEN csr_version_definition;
225: FETCH csr_version_definition INTO l_exists;
226: IF csr_version_definition%FOUND THEN
227: CLOSE csr_version_definition;
228: hr_utility.set_location(' Step:'|| l_proc, 60);
229: fnd_message.set_name('OTA', 'OTA_13845_TPM_HAS_BUDGET_RECS');
230: fnd_message.raise_error;
231: ELSE
232: hr_utility.set_location(' Step:'|| l_proc, 70);

Line 232: hr_utility.set_location(' Step:'|| l_proc, 70);

228: hr_utility.set_location(' Step:'|| l_proc, 60);
229: fnd_message.set_name('OTA', 'OTA_13845_TPM_HAS_BUDGET_RECS');
230: fnd_message.raise_error;
231: ELSE
232: hr_utility.set_location(' Step:'|| l_proc, 70);
233: CLOSE csr_version_definition;
234: END IF;
235: END IF;
236: --

Line 237: hr_utility.set_location(' Leaving:'||l_proc, 100);

233: CLOSE csr_version_definition;
234: END IF;
235: END IF;
236: --
237: hr_utility.set_location(' Leaving:'||l_proc, 100);
238:
239: EXCEPTION
240:
241: WHEN app_exception.application_exception THEN

Line 247: hr_utility.set_location(' Leaving:'||l_proc, 102);

243: IF hr_multi_message.exception_add
244: (p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
245: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN
246:
247: hr_utility.set_location(' Leaving:'||l_proc, 102);
248: RAISE;
249: END IF;
250:
251: hr_utility.set_location(' Leaving:'||l_proc, 104);

Line 251: hr_utility.set_location(' Leaving:'||l_proc, 104);

247: hr_utility.set_location(' Leaving:'||l_proc, 102);
248: RAISE;
249: END IF;
250:
251: hr_utility.set_location(' Leaving:'||l_proc, 104);
252:
253: END chk_version_definition;
254: -- ----------------------------------------------------------------------------
255: -- |-------------------------------------------------|

Line 309: hr_utility.set_location(' Step:'|| l_proc, 10);

305: BEGIN
306: --
307: -- check mandatory parameters have been set.
308: --
309: hr_utility.set_location(' Step:'|| l_proc, 10);
310:
311: IF hr_multi_message.no_exclusive_error
312: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
313: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID') THEN

Line 336: hr_utility.set_location(' Step:'|| l_proc, 20);

332: OR (NOT l_api_updating)
333: THEN
334: -- Check that the definition exists
335: --
336: hr_utility.set_location(' Step:'|| l_proc, 20);
337: OPEN csr_activity_version_id;
338: FETCH csr_activity_version_id INTO l_business_group_id;
339: IF csr_activity_version_id%NOTFOUND THEN
340: CLOSE csr_activity_version_id;

Line 349: hr_utility.set_location(' Step:'|| l_proc, 30);

345: CLOSE csr_activity_version_id;
346: fnd_message.set_name('OTA', 'OTA_13851_TPM_WRONG_ACT_VER');
347: fnd_message.raise_error;
348: ELSE
349: hr_utility.set_location(' Step:'|| l_proc, 30);
350: CLOSE csr_activity_version_id;
351: END IF;
352: END IF;
353: --

Line 386: hr_utility.set_location(' Leaving:'||l_proc, 40);

382: END IF;
383: --
384:
385: END IF;
386: hr_utility.set_location(' Leaving:'||l_proc, 40);
387:
388: EXCEPTION
389:
390: WHEN app_exception.application_exception THEN

Line 395: hr_utility.set_location(' Leaving:'||l_proc, 42);

391:
392: IF hr_multi_message.exception_add
393: (p_same_associated_columns => 'Y') THEN
394:
395: hr_utility.set_location(' Leaving:'||l_proc, 42);
396: RAISE;
397:
398: END IF;
399:

Line 400: hr_utility.set_location(' Leaving:'||l_proc, 44);

396: RAISE;
397:
398: END IF;
399:
400: hr_utility.set_location(' Leaving:'||l_proc, 44);
401:
402:
403: END chk_activity_version_id;
404: -- ----------------------------------------------------------------------------

Line 471: hr_utility.set_location(' Step:'|| l_proc, 30);

467: BEGIN
468: --
469: -- check mandatory parameters have been set.
470: --
471: hr_utility.set_location(' Step:'|| l_proc, 30);
472:
473: IF hr_multi_message.no_exclusive_error
474: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
475: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'

Line 488: hr_utility.set_location(' Step:'|| l_proc, 40);

484: ,p_argument => 'p_business_group_id'
485: ,p_argument_value => p_business_group_id
486: );
487: --
488: hr_utility.set_location(' Step:'|| l_proc, 40);
489: hr_api.mandatory_arg_error
490: (p_api_name => l_proc
491: ,p_argument => 'p_member_status_type_id'
492: ,p_argument_value => p_member_status_type_id

Line 495: hr_utility.set_location(' Step:'|| l_proc, 45);

491: ,p_argument => 'p_member_status_type_id'
492: ,p_argument_value => p_member_status_type_id
493: );
494: --
495: hr_utility.set_location(' Step:'|| l_proc, 45);
496: hr_api.mandatory_arg_error
497: (p_api_name => l_proc
498: ,p_argument => 'p_effective_date'
499: ,p_argument_value => p_effective_date

Line 502: hr_utility.set_location(' Step:'|| l_proc, 50);

498: ,p_argument => 'p_effective_date'
499: ,p_argument_value => p_effective_date
500: );
501: --
502: hr_utility.set_location(' Step:'|| l_proc, 50);
503: hr_api.mandatory_arg_error
504: (p_api_name => l_proc
505: ,p_argument => 'p_training_plan_id'
506: ,p_argument_value => p_training_plan_id

Line 523: hr_utility.set_location(' Step:'|| l_proc, 55);

519: OR (NOT l_api_updating)
520: THEN
521: -- Check that the lookup code is valid
522: --
523: hr_utility.set_location(' Step:'|| l_proc, 55);
524: IF hr_api.not_exists_in_hr_lookups
525: (p_effective_date => p_effective_date
526: ,p_lookup_type => 'OTA_MEMBER_USER_STATUS_TYPE'
527: ,p_lookup_code => p_member_status_type_id

Line 542: hr_utility.set_location(' Step:'|| l_proc, 60);

538: OPEN csr_seek_statuses;
539: FETCH csr_seek_statuses INTO l_exists;
540: IF csr_seek_statuses%FOUND THEN
541: CLOSE csr_seek_statuses;
542: hr_utility.set_location(' Step:'|| l_proc, 60);
543: IF p_activity_version_id IS NOT NULL THEN
544: IF (OTA_TRNG_PLAN_UTIL_SS.is_personal_trng_plan(p_training_plan_id)) THEN
545: fnd_message.set_name('OTA', 'OTA_443567_PLPM_OTHER_MEM_V');
546: Else

Line 560: hr_utility.set_location(' Step:'|| l_proc, 70);

556: fnd_message.set_name('OTA', 'OTA_13847_TPM_OTHER_MEMBERS_D');
557: fnd_message.raise_error;
558: END IF;
559: ELSE
560: hr_utility.set_location(' Step:'|| l_proc, 70);
561: CLOSE csr_seek_statuses;
562: END IF;
563: END IF;
564: END IF;

Line 566: hr_utility.set_location(' Leaving:'||l_proc, 80);

562: END IF;
563: END IF;
564: END IF;
565: END IF;
566: hr_utility.set_location(' Leaving:'||l_proc, 80);
567:
568: EXCEPTION
569:
570: WHEN app_exception.application_exception THEN

Line 575: hr_utility.set_location(' Leaving:'||l_proc, 82);

571:
572: IF hr_multi_message.exception_add
573: (p_same_associated_columns => 'Y') THEN
574:
575: hr_utility.set_location(' Leaving:'||l_proc, 82);
576: RAISE;
577:
578: END IF;
579:

Line 580: hr_utility.set_location(' Leaving:'||l_proc, 84);

576: RAISE;
577:
578: END IF;
579:
580: hr_utility.set_location(' Leaving:'||l_proc, 84);
581:
582:
583: END chk_member_status_type_id;
584: -- ----------------------------------------------------------------------------

Line 613: hr_utility.set_location(' Step:'|| l_proc, 30);

609: --
610: -- check mandatory parameters have been set
611: --
612: --
613: hr_utility.set_location(' Step:'|| l_proc, 30);
614:
615: IF hr_multi_message.no_exclusive_error
616: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
617: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'

Line 645: hr_utility.set_location(' Step:'|| l_proc, 50);

641: OR (NOT l_api_updating) THEN
642: --
643: -- check the combination is unique
644: --
645: hr_utility.set_location(' Step:'|| l_proc, 50);
646: OPEN csr_unique;
647: FETCH csr_unique INTO l_exists;
648: IF csr_unique%FOUND THEN
649: CLOSE csr_unique;

Line 650: hr_utility.set_location(' Step:'|| l_proc, 60);

646: OPEN csr_unique;
647: FETCH csr_unique INTO l_exists;
648: IF csr_unique%FOUND THEN
649: CLOSE csr_unique;
650: hr_utility.set_location(' Step:'|| l_proc, 60);
651: fnd_message.set_name('OTA', 'OTA_13844_TPM_NOT_UNIQUE');
652: fnd_message.raise_error;
653: ELSE
654: CLOSE csr_unique;

Line 655: hr_utility.set_location(' Step:'|| l_proc, 70);

651: fnd_message.set_name('OTA', 'OTA_13844_TPM_NOT_UNIQUE');
652: fnd_message.raise_error;
653: ELSE
654: CLOSE csr_unique;
655: hr_utility.set_location(' Step:'|| l_proc, 70);
656: END IF;
657: END IF;
658: --
659: END IF;

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

656: END IF;
657: END IF;
658: --
659: END IF;
660: hr_utility.set_location(' Leaving:'||l_proc, 90);
661:
662: EXCEPTION
663:
664: WHEN app_exception.application_exception THEN

Line 669: hr_utility.set_location(' Leaving:'||l_proc, 92);

665:
666: IF hr_multi_message.exception_add
667: (p_same_associated_columns => 'Y') THEN
668:
669: hr_utility.set_location(' Leaving:'||l_proc, 92);
670: RAISE;
671:
672: END IF;
673:

Line 674: hr_utility.set_location(' Leaving:'||l_proc, 94);

670: RAISE;
671:
672: END IF;
673:
674: hr_utility.set_location(' Leaving:'||l_proc, 94);
675:
676: END chk_unique;
677:
678: -- ----------------------------------------------------------------------------

Line 714: hr_utility.set_location(' Step:'|| l_proc, 30);

710: --
711: -- check mandatory parameters have been set
712: --
713: --
714: hr_utility.set_location(' Step:'|| l_proc, 30);
715:
716: IF hr_multi_message.no_exclusive_error
717: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
718: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'

Line 748: hr_utility.set_location(' Step:'|| l_proc, 50);

744: OR (NOT l_api_updating) THEN
745: --
746: -- check the combination is unique
747: --
748: hr_utility.set_location(' Step:'|| l_proc, 50);
749: OPEN csr_unique;
750: FETCH csr_unique INTO l_exists,l_member_status_type_id;
751: IF csr_unique%FOUND THEN
752: CLOSE csr_unique;

Line 753: hr_utility.set_location(' Step:'|| l_proc, 60);

749: OPEN csr_unique;
750: FETCH csr_unique INTO l_exists,l_member_status_type_id;
751: IF csr_unique%FOUND THEN
752: CLOSE csr_unique;
753: hr_utility.set_location(' Step:'|| l_proc, 60);
754: if l_member_status_type_id = 'CANCELLED' then
755: fnd_message.set_name('OTA', 'OTA_13189_TPM_CANCEL_EXISTS');
756: else
757: fnd_message.set_name('OTA', 'OTA_13182_TPM_ACT_NOT_UNIQUE');

Line 762: hr_utility.set_location(' Step:'|| l_proc, 70);

758: end if;
759: fnd_message.raise_error;
760: ELSE
761: CLOSE csr_unique;
762: hr_utility.set_location(' Step:'|| l_proc, 70);
763: END IF;
764:
765: END IF;
766: --

Line 768: hr_utility.set_location(' Leaving:'||l_proc, 90);

764:
765: END IF;
766: --
767: END IF;
768: hr_utility.set_location(' Leaving:'||l_proc, 90);
769:
770: EXCEPTION
771:
772: WHEN app_exception.application_exception THEN

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

773:
774: IF hr_multi_message.exception_add
775: (p_same_associated_columns => 'Y') THEN
776:
777: hr_utility.set_location(' Leaving:'||l_proc, 92);
778: RAISE;
779:
780: END IF;
781:

Line 782: hr_utility.set_location(' Leaving:'||l_proc, 94);

778: RAISE;
779:
780: END IF;
781:
782: hr_utility.set_location(' Leaving:'||l_proc, 94);
783:
784:
785:
786: END chk_unique1;

Line 813: hr_utility.set_location(' Step:'|| l_proc, 30);

809: --
810: -- check mandatory parameters have been set
811: --
812: --
813: hr_utility.set_location(' Step:'|| l_proc, 30);
814:
815: IF hr_multi_message.no_exclusive_error
816: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
817: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID') THEN

Line 827: hr_utility.set_location(' Step:'|| l_proc, 40);

823: ,p_argument_value => p_training_plan_member_id
824: );
825: --
826: --
827: hr_utility.set_location(' Step:'|| l_proc, 40);
828: hr_api.mandatory_arg_error
829: (p_api_name => l_proc
830: ,p_argument => 'p_training_plan_id'
831: ,p_argument_value => p_training_plan_id

Line 836: hr_utility.set_location(' Step:'|| l_proc, 50);

832: );
833: --
834: --
835: --
836: hr_utility.set_location(' Step:'|| l_proc, 50);
837: OPEN csr_chk_delete;
838: FETCH csr_chk_delete INTO l_exists;
839: IF csr_chk_delete%FOUND THEN
840: CLOSE csr_chk_delete;

Line 841: hr_utility.set_location(' Step:'|| l_proc, 60);

837: OPEN csr_chk_delete;
838: FETCH csr_chk_delete INTO l_exists;
839: IF csr_chk_delete%FOUND THEN
840: CLOSE csr_chk_delete;
841: hr_utility.set_location(' Step:'|| l_proc, 60);
842: fnd_message.set_name('OTA', 'OTA_13845_TPM_HAS_BUDGET_RECS');
843: fnd_message.raise_error;
844: ELSE
845: hr_utility.set_location(' Step:'|| l_proc, 70);

Line 845: hr_utility.set_location(' Step:'|| l_proc, 70);

841: hr_utility.set_location(' Step:'|| l_proc, 60);
842: fnd_message.set_name('OTA', 'OTA_13845_TPM_HAS_BUDGET_RECS');
843: fnd_message.raise_error;
844: ELSE
845: hr_utility.set_location(' Step:'|| l_proc, 70);
846: CLOSE csr_chk_delete;
847: END IF;
848: --
849: END IF;

Line 850: hr_utility.set_location(' Leaving:'||l_proc, 100);

846: CLOSE csr_chk_delete;
847: END IF;
848: --
849: END IF;
850: hr_utility.set_location(' Leaving:'||l_proc, 100);
851:
852: EXCEPTION
853:
854: WHEN app_exception.application_exception THEN

Line 859: hr_utility.set_location(' Leaving:'||l_proc, 102);

855:
856: IF hr_multi_message.exception_add
857: (p_same_associated_columns => 'Y') THEN
858:
859: hr_utility.set_location(' Leaving:'||l_proc, 102);
860: RAISE;
861:
862: END IF;
863:

Line 864: hr_utility.set_location(' Leaving:'||l_proc, 104);

860: RAISE;
861:
862: END IF;
863:
864: hr_utility.set_location(' Leaving:'||l_proc, 104);
865:
866: END chk_delete;
867:
868: -- ----------------------------------------------------------------------------

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

877: l_proc VARCHAR2(72) := g_package||'chk_source_function';
878: l_api_updating boolean;
879:
880: BEGIN
881: hr_utility.set_location(' Leaving:'||l_proc, 10);
882: --
883: -- check mandatory parameters has been set
884: --
885: hr_api.mandatory_arg_error

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

892: NVL(p_source_function,hr_api.g_VARCHAR2))
893: OR
894: (p_training_plan_member_id IS NULL)) THEN
895:
896: hr_utility.set_location(' Leaving:'||l_proc, 20);
897: --
898:
899: --
900: IF p_source_function IS NOT NULL THEN

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

904: ,p_lookup_code => p_source_FUNCTION) THEN
905: fnd_message.set_name('OTA','OTA_13178_TPM_SRC_FUNC_INVLD');
906: fnd_message.raise_error;
907: END IF;
908: hr_utility.set_location(' Leaving:'||l_proc, 30);
909:
910: END IF;
911:
912: END IF;

Line 913: hr_utility.set_location(' Leaving:'||l_proc, 40);

909:
910: END IF;
911:
912: END IF;
913: hr_utility.set_location(' Leaving:'||l_proc, 40);
914:
915: EXCEPTION
916:
917: WHEN app_exception.application_exception THEN

Line 922: hr_utility.set_location(' Leaving:'||l_proc, 42);

918:
919: IF hr_multi_message.exception_add
920: (p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.SOURCE_FUNCTION') THEN
921:
922: hr_utility.set_location(' Leaving:'||l_proc, 42);
923: RAISE;
924: END IF;
925:
926: hr_utility.set_location(' Leaving:'||l_proc, 44);

Line 926: hr_utility.set_location(' Leaving:'||l_proc, 44);

922: hr_utility.set_location(' Leaving:'||l_proc, 42);
923: RAISE;
924: END IF;
925:
926: hr_utility.set_location(' Leaving:'||l_proc, 44);
927:
928: END chk_source_function;
929:
930: -- ----------------------------------------------------------------------------

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

938: l_proc VARCHAR2(72) := g_package||'chk_cancellation_reason';
939: l_api_updating boolean;
940:
941: BEGIN
942: hr_utility.set_location(' Leaving:'||l_proc, 10);
943: --
944: -- check mandatory parameters has been set
945: --
946: hr_api.mandatory_arg_error

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

953: NVL(p_cancellation_reason,hr_api.g_VARCHAR2))
954: OR
955: (p_training_plan_member_id IS NULL)) THEN
956:
957: hr_utility.set_location(' Leaving:'||l_proc, 20);
958: --
959:
960: --
961: IF p_cancellation_reason IS NOT NULL THEN

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

965: ,p_lookup_code => p_cancellation_reason) THEN
966: fnd_message.set_name('OTA','OTA_13177_TPM_CANCL_RSN_INVLD');
967: fnd_message.raise_error;
968: END IF;
969: hr_utility.set_location(' Leaving:'||l_proc, 30);
970:
971: END IF;
972:
973: END IF;

Line 974: hr_utility.set_location(' Leaving:'||l_proc, 40);

970:
971: END IF;
972:
973: END IF;
974: hr_utility.set_location(' Leaving:'||l_proc, 40);
975:
976: EXCEPTION
977:
978: WHEN app_exception.application_exception THEN

Line 983: hr_utility.set_location(' Leaving:'||l_proc, 42);

979:
980: IF hr_multi_message.exception_add
981: (p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.CANCELLATION_REASON') THEN
982:
983: hr_utility.set_location(' Leaving:'||l_proc, 42);
984: RAISE;
985: END IF;
986:
987: hr_utility.set_location(' Leaving:'||l_proc, 44);

Line 987: hr_utility.set_location(' Leaving:'||l_proc, 44);

983: hr_utility.set_location(' Leaving:'||l_proc, 42);
984: RAISE;
985: END IF;
986:
987: hr_utility.set_location(' Leaving:'||l_proc, 44);
988:
989: END chk_cancellation_reason;
990:
991: -- ----------------------------------------------------------------------------

Line 1043: hr_utility.set_location(' Step:'|| l_proc, 10);

1039: BEGIN
1040:
1041: -- check mandatory parameters have been set
1042: --
1043: hr_utility.set_location(' Step:'|| l_proc, 10);
1044: hr_api.mandatory_arg_error
1045: (p_api_name => l_proc
1046: ,p_argument => 'p_training_plan_id'
1047: ,p_argument_value => p_training_plan_id

Line 1065: hr_utility.set_location(' Step:'|| l_proc, 20);

1061: OR NVL(ota_tpm_shd.g_old_rec.target_completion_date, hr_api.g_date) <>
1062: NVL(p_target_completion_date, hr_api.g_date) )
1063: OR (NOT l_api_updating))
1064: THEN
1065: hr_utility.set_location(' Step:'|| l_proc, 20);
1066:
1067: /* IF( NOT l_api_updating
1068: or NVL(ota_tpm_shd.g_old_rec.earliest_start_date, hr_api.g_date) <>
1069: NVL(p_earliest_start_date, hr_api.g_date)) THEN

Line 1135: hr_utility.set_location(' Step:'|| l_proc, 30);

1131:
1132:
1133: END IF;
1134:
1135: hr_utility.set_location(' Step:'|| l_proc, 30);
1136:
1137: --MULTI MESSAGE SUPPORT
1138: EXCEPTION
1139:

Line 1147: hr_utility.set_location(' Leaving:'||l_proc, 32);

1143: /* IF hr_multi_message.exception_add(
1144: p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.EARLIEST_START_DATE') THEN
1145: -- ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.TARGET_COMPLETION_DATE') THEN
1146:
1147: hr_utility.set_location(' Leaving:'||l_proc, 32);
1148: RAISE;
1149:
1150: END IF;
1151: ELSIF l_flag = 'END_DATE' THEN */

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

1152: IF hr_multi_message.exception_add(
1153: -- p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.EARLIEST_START_DATE') THEN
1154: p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TARGET_COMPLETION_DATE') THEN
1155:
1156: hr_utility.set_location(' Leaving:'||l_proc, 35);
1157: RAISE;
1158:
1159: END IF;
1160: ELSE

Line 1165: hr_utility.set_location(' Leaving:'||l_proc, 36);

1161: IF hr_multi_message.exception_add(
1162: p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.EARLIEST_START_DATE'
1163: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.TARGET_COMPLETION_DATE') THEN
1164:
1165: hr_utility.set_location(' Leaving:'||l_proc, 36);
1166: RAISE;
1167:
1168: END IF;
1169:

Line 1171: hr_utility.set_location(' Leaving:'||l_proc, 37);

1167:
1168: END IF;
1169:
1170: END IF;
1171: hr_utility.set_location(' Leaving:'||l_proc, 37);
1172:
1173: END chk_tpc_tp_actver_dates;
1174:
1175: