DBA Data[Home] [Help]

APPS.OTA_TMT_BUS1 dependencies on FND_MESSAGE

Line 63: fnd_message.set_name('OTA', 'OTA_13800_TMT_INV_MEAS_TYPE');

59: ,p_lookup_type => 'OTA_PLAN_MEASUREMENT_TYPE'
60: ,p_lookup_code => p_tp_measurement_code
61: ) then
62: -- Error, lookup not available
63: fnd_message.set_name('OTA', 'OTA_13800_TMT_INV_MEAS_TYPE');
64: fnd_message.raise_error;
65: end if;
66: --
67: -- Check that the combination is unique

Line 64: fnd_message.raise_error;

60: ,p_lookup_code => p_tp_measurement_code
61: ) then
62: -- Error, lookup not available
63: fnd_message.set_name('OTA', 'OTA_13800_TMT_INV_MEAS_TYPE');
64: fnd_message.raise_error;
65: end if;
66: --
67: -- Check that the combination is unique
68: --

Line 75: fnd_message.set_name('OTA', 'OTA_13801_TMT_DUP_MEAS_TYPE');

71: fetch csr_tp_measurement_code into l_exists;
72: if csr_tp_measurement_code%FOUND then
73: close csr_tp_measurement_code;
74: hr_utility.set_location(' Step:'|| l_proc, 60);
75: fnd_message.set_name('OTA', 'OTA_13801_TMT_DUP_MEAS_TYPE');
76: fnd_message.raise_error;
77: end if;
78: close csr_tp_measurement_code;
79: --

Line 76: fnd_message.raise_error;

72: if csr_tp_measurement_code%FOUND then
73: close csr_tp_measurement_code;
74: hr_utility.set_location(' Step:'|| l_proc, 60);
75: fnd_message.set_name('OTA', 'OTA_13801_TMT_DUP_MEAS_TYPE');
76: fnd_message.raise_error;
77: end if;
78: close csr_tp_measurement_code;
79: --
80: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 140: fnd_message.set_name('OTA', 'OTA_13813_TMT_NO_DEL_BUDGET');

136: fetch csr_del_tp_measurement_code into l_exists;
137: if csr_del_tp_measurement_code%FOUND then
138: close csr_del_tp_measurement_code;
139: hr_utility.set_location(' Step:'|| l_proc, 60);
140: fnd_message.set_name('OTA', 'OTA_13813_TMT_NO_DEL_BUDGET');
141: fnd_message.raise_error;
142: end if;
143: close csr_del_tp_measurement_code;
144: --

Line 141: fnd_message.raise_error;

137: if csr_del_tp_measurement_code%FOUND then
138: close csr_del_tp_measurement_code;
139: hr_utility.set_location(' Step:'|| l_proc, 60);
140: fnd_message.set_name('OTA', 'OTA_13813_TMT_NO_DEL_BUDGET');
141: fnd_message.raise_error;
142: end if;
143: close csr_del_tp_measurement_code;
144: --
145: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 216: fnd_message.set_name('OTA', 'OTA_13804_INV_UNIT_TYPE');

212: ,p_lookup_code => p_unit
213: ) then
214: -- Error, lookup not available
215: hr_utility.set_location(l_proc, 60);
216: fnd_message.set_name('OTA', 'OTA_13804_INV_UNIT_TYPE');
217: fnd_message.raise_error;
218: elsif (p_unit <> 'I')
219: and (p_unit <> 'M')
220: and (p_unit <> 'N') then

Line 217: fnd_message.raise_error;

213: ) then
214: -- Error, lookup not available
215: hr_utility.set_location(l_proc, 60);
216: fnd_message.set_name('OTA', 'OTA_13804_INV_UNIT_TYPE');
217: fnd_message.raise_error;
218: elsif (p_unit <> 'I')
219: and (p_unit <> 'M')
220: and (p_unit <> 'N') then
221: -- Error, lookup not in sub list of allowed values

Line 223: fnd_message.set_name('OTA', 'OTA_13804_INV_UNIT_TYPE');

219: and (p_unit <> 'M')
220: and (p_unit <> 'N') then
221: -- Error, lookup not in sub list of allowed values
222: hr_utility.set_location(l_proc, 70);
223: fnd_message.set_name('OTA', 'OTA_13804_INV_UNIT_TYPE');
224: fnd_message.raise_error;
225: End if;
226: End if;
227: --

Line 224: fnd_message.raise_error;

220: and (p_unit <> 'N') then
221: -- Error, lookup not in sub list of allowed values
222: hr_utility.set_location(l_proc, 70);
223: fnd_message.set_name('OTA', 'OTA_13804_INV_UNIT_TYPE');
224: fnd_message.raise_error;
225: End if;
226: End if;
227: --
228: -- but changes are only allowed if there are no current recs in costs

Line 239: fnd_message.set_name('OTA', 'OTA_13803_TMT_UNIT_UPD_COST');

235: fetch csr_chk_no_cost_recs into l_exists;
236: If csr_chk_no_cost_recs%FOUND then
237: close csr_chk_no_cost_recs;
238: hr_utility.set_location(' Step:'|| l_proc, 90);
239: fnd_message.set_name('OTA', 'OTA_13803_TMT_UNIT_UPD_COST');
240: fnd_message.raise_error;
241: End if;
242: close csr_chk_no_cost_recs;
243: End if;

Line 240: fnd_message.raise_error;

236: If csr_chk_no_cost_recs%FOUND then
237: close csr_chk_no_cost_recs;
238: hr_utility.set_location(' Step:'|| l_proc, 90);
239: fnd_message.set_name('OTA', 'OTA_13803_TMT_UNIT_UPD_COST');
240: fnd_message.raise_error;
241: End if;
242: close csr_chk_no_cost_recs;
243: End if;
244: hr_utility.set_location(' Leaving:'||l_proc, 100);

Line 328: fnd_message.set_name('OTA', 'OTA_13805_TMT_INV_BUDGET');

324: ,p_lookup_code => p_budget_level
325: ) then
326: -- Error, lookup not available
327: hr_utility.set_location(l_proc, 70);
328: fnd_message.set_name('OTA', 'OTA_13805_TMT_INV_BUDGET');
329: fnd_message.raise_error;
330: End if;
331: --
332: End if;

Line 329: fnd_message.raise_error;

325: ) then
326: -- Error, lookup not available
327: hr_utility.set_location(l_proc, 70);
328: fnd_message.set_name('OTA', 'OTA_13805_TMT_INV_BUDGET');
329: fnd_message.raise_error;
330: End if;
331: --
332: End if;
333: --

Line 345: fnd_message.set_name('OTA', 'OTA_13806_TMT_UPD_BUDGET');

341: fetch csr_upd_tp_budget_level into l_exists;
342: If csr_upd_tp_budget_level%FOUND then
343: close csr_upd_tp_budget_level;
344: hr_utility.set_location(' Step:'|| l_proc, 90);
345: fnd_message.set_name('OTA', 'OTA_13806_TMT_UPD_BUDGET');
346: fnd_message.raise_error;
347: End if;
348: close csr_upd_tp_budget_level;
349: --

Line 346: fnd_message.raise_error;

342: If csr_upd_tp_budget_level%FOUND then
343: close csr_upd_tp_budget_level;
344: hr_utility.set_location(' Step:'|| l_proc, 90);
345: fnd_message.set_name('OTA', 'OTA_13806_TMT_UPD_BUDGET');
346: fnd_message.raise_error;
347: End if;
348: close csr_upd_tp_budget_level;
349: --
350: End if;

Line 413: fnd_message.set_name('OTA', 'OTA_13807_TMT_BUDGET_COST_COMB');

409: or p_budget_level = 'ACTIVITY' ))
410: then
411: -- Error, combination invalid
412: hr_utility.set_location(l_proc, 60);
413: fnd_message.set_name('OTA', 'OTA_13807_TMT_BUDGET_COST_COMB');
414: fnd_message.raise_error;
415: End if;
416: --
417: End if;

Line 414: fnd_message.raise_error;

410: then
411: -- Error, combination invalid
412: hr_utility.set_location(l_proc, 60);
413: fnd_message.set_name('OTA', 'OTA_13807_TMT_BUDGET_COST_COMB');
414: fnd_message.raise_error;
415: End if;
416: --
417: End if;
418: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 488: fnd_message.set_name('OTA', 'OTA_13808_TMT_INV_COST');

484: ,p_lookup_code => p_cost_level
485: ) then
486: -- Error, lookup not available
487: hr_utility.set_location(l_proc, 70);
488: fnd_message.set_name('OTA', 'OTA_13808_TMT_INV_COST');
489: fnd_message.raise_error;
490: End if;
491: --
492: End if;

Line 489: fnd_message.raise_error;

485: ) then
486: -- Error, lookup not available
487: hr_utility.set_location(l_proc, 70);
488: fnd_message.set_name('OTA', 'OTA_13808_TMT_INV_COST');
489: fnd_message.raise_error;
490: End if;
491: --
492: End if;
493: --

Line 505: fnd_message.set_name('OTA', 'OTA_13809_TMT_UPD_COSTS');

501: fetch csr_upd_cost_level into l_exists;
502: If csr_upd_cost_level%FOUND then
503: close csr_upd_cost_level;
504: hr_utility.set_location(' Step:'|| l_proc, 90);
505: fnd_message.set_name('OTA', 'OTA_13809_TMT_UPD_COSTS');
506: fnd_message.raise_error;
507: End if;
508: close csr_upd_cost_level;
509: --

Line 506: fnd_message.raise_error;

502: If csr_upd_cost_level%FOUND then
503: close csr_upd_cost_level;
504: hr_utility.set_location(' Step:'|| l_proc, 90);
505: fnd_message.set_name('OTA', 'OTA_13809_TMT_UPD_COSTS');
506: fnd_message.raise_error;
507: End if;
508: close csr_upd_cost_level;
509: --
510: End if;

Line 600: fnd_message.set_name('OTA', 'OTA_13810_TMT_INV_MANY_BUDGETS');

596: ,p_lookup_code => p_many_budget_values_flag
597: ) then
598: -- Error, lookup not available
599: hr_utility.set_location(l_proc, 70);
600: fnd_message.set_name('OTA', 'OTA_13810_TMT_INV_MANY_BUDGETS');
601: fnd_message.raise_error;
602: End if;
603: --
604: End if;

Line 601: fnd_message.raise_error;

597: ) then
598: -- Error, lookup not available
599: hr_utility.set_location(l_proc, 70);
600: fnd_message.set_name('OTA', 'OTA_13810_TMT_INV_MANY_BUDGETS');
601: fnd_message.raise_error;
602: End if;
603: --
604: End if;
605: --

Line 617: fnd_message.set_name('OTA', 'OTA_13811_TMT_INV_UPD_FLAG');

613: open csr_upd_tp_budget_flag;
614: fetch csr_upd_tp_budget_flag into l_exists;
615: if csr_upd_tp_budget_flag%FOUND then
616: close csr_upd_tp_budget_flag;
617: fnd_message.set_name('OTA', 'OTA_13811_TMT_INV_UPD_FLAG');
618: fnd_message.raise_error;
619: else
620: close csr_upd_tp_budget_flag;
621: End if;

Line 618: fnd_message.raise_error;

614: fetch csr_upd_tp_budget_flag into l_exists;
615: if csr_upd_tp_budget_flag%FOUND then
616: close csr_upd_tp_budget_flag;
617: fnd_message.set_name('OTA', 'OTA_13811_TMT_INV_UPD_FLAG');
618: fnd_message.raise_error;
619: else
620: close csr_upd_tp_budget_flag;
621: End if;
622: --

Line 680: fnd_message.set_name('OTA', 'OTA_13812_TMT_INV_CALC');

676: If csr_chk_item_type%NOTFOUND then
677: -- Error, item type does not exist.
678: close csr_chk_item_type;
679: hr_utility.set_location(' Step:'|| l_proc, 20);
680: fnd_message.set_name('OTA', 'OTA_13812_TMT_INV_CALC');
681: fnd_message.raise_error;
682: End if;
683: close csr_chk_item_type;
684: --

Line 681: fnd_message.raise_error;

677: -- Error, item type does not exist.
678: close csr_chk_item_type;
679: hr_utility.set_location(' Step:'|| l_proc, 20);
680: fnd_message.set_name('OTA', 'OTA_13812_TMT_INV_CALC');
681: fnd_message.raise_error;
682: End if;
683: close csr_chk_item_type;
684: --
685: End if;

Line 723: fnd_message.set_name('OTA', 'OTA_13802_TMT_DEL_COST');

719: fetch csr_del_tp_measurement_type_id into l_exists;
720: if csr_del_tp_measurement_type_id%FOUND then
721: close csr_del_tp_measurement_type_id;
722: hr_utility.set_location(' Step:'|| l_proc, 10);
723: fnd_message.set_name('OTA', 'OTA_13802_TMT_DEL_COST');
724: fnd_message.raise_error;
725: end if;
726: close csr_del_tp_measurement_type_id;
727: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 724: fnd_message.raise_error;

720: if csr_del_tp_measurement_type_id%FOUND then
721: close csr_del_tp_measurement_type_id;
722: hr_utility.set_location(' Step:'|| l_proc, 10);
723: fnd_message.set_name('OTA', 'OTA_13802_TMT_DEL_COST');
724: fnd_message.raise_error;
725: end if;
726: close csr_del_tp_measurement_type_id;
727: hr_utility.set_location(' Leaving:'||l_proc, 20);
728: --

Line 828: fnd_message.set_name('OTA', 'OTA_13876_TMT_INV_SETUP');

824: --
825: -- Error, legislative setup not correct
826: --
827: hr_utility.set_location(l_proc, 70);
828: fnd_message.set_name('OTA', 'OTA_13876_TMT_INV_SETUP');
829: fnd_message.raise_error;
830: end if;
831: end if;
832: end if;

Line 829: fnd_message.raise_error;

825: -- Error, legislative setup not correct
826: --
827: hr_utility.set_location(l_proc, 70);
828: fnd_message.set_name('OTA', 'OTA_13876_TMT_INV_SETUP');
829: fnd_message.raise_error;
830: end if;
831: end if;
832: end if;
833: --