DBA Data[Home] [Help]

APPS.OTA_CFS_BUS dependencies on HR_UTILITY

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

39: l_legislation_code varchar2(150);
40: --
41: begin
42: --
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error

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

79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --
85: end set_security_group_id;
86: --
87: -- ---------------------------------------------------------------------------

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

108: l_proc varchar2(72) := g_package||'return_legislation_code';
109: --
110: Begin
111: --
112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error

Line 130: hr_utility.set_location(l_proc, 20);

126: -- call to this function. Just return the value in the global
127: -- variable.
128: --
129: l_legislation_code := ota_cfs_bus.g_legislation_code;
130: hr_utility.set_location(l_proc, 20);
131: else
132: --
133: -- The ID is different to the last call to this function
134: -- or this is the first call to this function.

Line 147: hr_utility.set_location(l_proc,30);

143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
150: -- available for the next call to this function.
151: --

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

152: close csr_leg_code;
153: ota_cfs_bus.g_conference_server_id := p_conference_server_id;
154: ota_cfs_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
159:
160: --

Line 167: -- hr_utility.

163: -- ----------------------------------------------------------------------------
164: --
165: -- Description:
166: -- Passes the error information to the procedure set_message of package
167: -- hr_utility.
168: --
169: Procedure call_error_message
170: (
171: p_error_appl varchar2

Line 179: hr_utility.set_location('Entering:'|| v_proc, 5);

175: v_proc varchar2(72) := g_package||'call_error_message';
176: --
177: Begin
178: --
179: hr_utility.set_location('Entering:'|| v_proc, 5);
180: --
181: -- ** TEMP ** Add error message with the following text.
182: --
183: fnd_message.set_name ( p_error_appl ,p_error_txt);

Line 186: hr_utility.set_location(' Leaving:'|| v_proc, 10);

182: --
183: fnd_message.set_name ( p_error_appl ,p_error_txt);
184: fnd_message.raise_error;
185: --
186: hr_utility.set_location(' Leaving:'|| v_proc, 10);
187: --
188: End call_error_message;
189: --
190: --

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

222: --
223: l_proc varchar2(72) := g_package || 'chk_df';
224: --
225: begin
226: hr_utility.set_location('Entering:'||l_proc,10);
227: --
228: if ((p_rec.conference_server_id is not null) and (
229: nvl(ota_cfs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

321: ,p_attribute20_value => p_rec.attribute20
322: );
323: end if;
324: --
325: hr_utility.set_location(' Leaving:'||l_proc,20);
326: end chk_df;
327: --
328: -- ----------------------------------------------------------------------------
329: -- |-----------------------< chk_non_updateable_args >------------------------|

Line 401: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);

397: := G_PACKAGE || 'CHECK_UNIQUE';
398: --
399: begin
400: --
401: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
402: --
403: -- Do not perform the uniqueness check unless inserting, or updating
404: -- with a value different from the current value (and not just changing
405: -- case)

Line 417: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);

413: fnd_message.raise_error;
414: --
415: end if;
416: --
417: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);
418: --
419: Exception
420: WHEN app_exception.application_exception THEN
421:

Line 427: --hr_utility.set_location(' Leaving:'||v_proc, 22);

423: p_associated_column1 => 'OTA_CONFERENCE_SERVERS_B.BUSINESS_GROUP_ID',
424: p_associated_column2 => 'OTA_CONFERENCE_SERVERS_B.CONFERENCE_SERVER_ID')
425: THEN
426:
427: --hr_utility.set_location(' Leaving:'||v_proc, 22);
428: RAISE;
429:
430: END IF;
431:

Line 480: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);

476: l_name ota_conference_servers_tl.name%type;
477: --
478: begin
479: --
480: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
481: --
482: -- Check arguments
483: --
484: HR_API.MANDATORY_ARG_ERROR (

Line 512: HR_UTILITY.SET_LOCATION (W_PROC, 10);

508: v_name_is_unique := C1%notfound;
509: close C1;
510: end if;
511: --
512: HR_UTILITY.SET_LOCATION (W_PROC, 10);
513: return v_name_is_unique;
514: --
515: end UNIQUE_CFS_NAME;
516:

Line 557: hr_utility.set_location('Entering:'|| v_proc, 5);

553: where cfr.conference_server_id = p_conference_server_id;
554: --
555: Begin
556: --
557: hr_utility.set_location('Entering:'|| v_proc, 5);
558: --
559: Open sel_conf_exists;
560: fetch sel_conf_exists into v_exists;
561: --

Line 575: hr_utility.set_location(' Leaving:'|| v_proc, 10);

571: end if;
572: --
573: close sel_conf_exists;
574: --
575: hr_utility.set_location(' Leaving:'|| v_proc, 10);
576: --
577: End check_if_conf_exists;
578:
579: --

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

589: --
590: l_proc varchar2(72) := g_package||'insert_validate';
591: --
592: Begin
593: hr_utility.set_location('Entering:'||l_proc, 5);
594: --
595: -- Call all supporting business operations
596: --
597: hr_api.validate_bus_grp_id

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

613: --
614: --
615: ota_cfs_bus.chk_df(p_rec);
616: --
617: hr_utility.set_location(' Leaving:'||l_proc, 10);
618: End insert_validate;
619: --
620: -- ----------------------------------------------------------------------------
621: -- |---------------------------< update_validate >----------------------------|

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

628: --
629: l_proc varchar2(72) := g_package||'update_validate';
630: --
631: Begin
632: hr_utility.set_location('Entering:'||l_proc, 5);
633: --
634: -- Call all supporting business operations
635: --
636: hr_api.validate_bus_grp_id

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

657: --
658: --
659: ota_cfs_bus.chk_df(p_rec);
660: --
661: hr_utility.set_location(' Leaving:'||l_proc, 10);
662: End update_validate;
663: --
664: -- ----------------------------------------------------------------------------
665: -- |---------------------------< delete_validate >----------------------------|

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

670: --
671: l_proc varchar2(72) := g_package||'delete_validate';
672: --
673: Begin
674: hr_utility.set_location('Entering:'||l_proc, 5);
675: --
676: -- Call all supporting business operations
677: check_if_conf_exists( p_conference_server_id => p_rec.conference_server_id );
678:

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

676: -- Call all supporting business operations
677: check_if_conf_exists( p_conference_server_id => p_rec.conference_server_id );
678:
679: --
680: hr_utility.set_location(' Leaving:'||l_proc, 10);
681: End delete_validate;
682: --
683: end ota_cfs_bus;