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

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

37: --
38: l_proc varchar2(72) := g_package || 'CHK_CONDITION_ID';
39: --
40: Begin
41: hr_utility.set_location('Entering:'||l_proc,10);
42: hr_api.mandatory_arg_error(p_api_name => l_proc
43: ,p_argument => 'CONDITION_ID'
44: ,p_argument_value => p_condition_id
45: );

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

42: hr_api.mandatory_arg_error(p_api_name => l_proc
43: ,p_argument => 'CONDITION_ID'
44: ,p_argument_value => p_condition_id
45: );
46: hr_utility.set_location(' Leaving:'||l_proc,30);
47: exception
48: when app_exception.application_exception then
49: if hr_multi_message.exception_add
50: (p_associated_column1 => 'AME_CONDITIONS.CONDITION_ID'

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

48: when app_exception.application_exception then
49: if hr_multi_message.exception_add
50: (p_associated_column1 => 'AME_CONDITIONS.CONDITION_ID'
51: ) then
52: hr_utility.set_location(' Leaving:'||l_proc, 40);
53: raise;
54: end if;
55: hr_utility.set_location(' Leaving:'||l_proc,50);
56: End chk_condition_id;

Line 55: hr_utility.set_location(' Leaving:'||l_proc,50);

51: ) then
52: hr_utility.set_location(' Leaving:'||l_proc, 40);
53: raise;
54: end if;
55: hr_utility.set_location(' Leaving:'||l_proc,50);
56: End chk_condition_id;
57: --
58: -- ----------------------------------------------------------------------------
59: -- |-------------------------< CHK_CONDITION_TYPE >---------------------------|

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

86: --
87: l_proc varchar2(72) := g_package || 'CHK_CONDITION_TYPE';
88: --
89: Begin
90: hr_utility.set_location('Entering:'||l_proc,10);
91: hr_api.mandatory_arg_error(p_api_name => l_proc
92: ,p_argument => 'CONDITION_TYPE'
93: ,p_argument_value => p_condition_type
94: );

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

99: ) then
100: fnd_message.set_name('PER','AME_400496_INV_CON_TYPE');
101: fnd_message.raise_error;
102: end if;
103: hr_utility.set_location(' Leaving:'||l_proc,30);
104: exception
105: when app_exception.application_exception then
106: if hr_multi_message.exception_add
107: (p_associated_column1 => 'AME_CONDITIONS.CONDITION_TYPE'

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

105: when app_exception.application_exception then
106: if hr_multi_message.exception_add
107: (p_associated_column1 => 'AME_CONDITIONS.CONDITION_TYPE'
108: ) then
109: hr_utility.set_location(' Leaving:'||l_proc, 40);
110: raise;
111: end if;
112: hr_utility.set_location( ' Leaving:'||l_proc,50 );
113: End chk_condition_type;

Line 112: hr_utility.set_location( ' Leaving:'||l_proc,50 );

108: ) then
109: hr_utility.set_location(' Leaving:'||l_proc, 40);
110: raise;
111: end if;
112: hr_utility.set_location( ' Leaving:'||l_proc,50 );
113: End chk_condition_type;
114: --
115: -- ----------------------------------------------------------------------------
116: -- |-------------------------< CHK_ATTRIBUTE_ID >-----------------------------|

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

159: l_proc varchar2(72) := g_package || 'CHK_ATTRIBUTE_ID';
160: l_key number;
161: --
162: Begin
163: hr_utility.set_location(' Entering:'||l_proc,10);
164: -- Check whether any dependencies on CONDITION_KEY have failed
165: if hr_multi_message.no_all_inclusive_error
166: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE') then
167: hr_api.mandatory_arg_error(p_api_name => l_proc

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

185: fnd_message.raise_error;
186: end if;
187: end if;
188: end if;
189: hr_utility.set_location(' Leaving:'||l_proc,30);
190: exception
191: when app_exception.application_exception then
192: if hr_multi_message.exception_add
193: (p_associated_column1 => 'AME_CONDITIONS.ATTRIBUTE_ID'

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

191: when app_exception.application_exception then
192: if hr_multi_message.exception_add
193: (p_associated_column1 => 'AME_CONDITIONS.ATTRIBUTE_ID'
194: ) then
195: hr_utility.set_location(' Leaving:'||l_proc, 40);
196: raise;
197: end if;
198: hr_utility.set_location(' Leaving:'||l_proc,50);
199: End chk_attribute_id;

Line 198: hr_utility.set_location(' Leaving:'||l_proc,50);

194: ) then
195: hr_utility.set_location(' Leaving:'||l_proc, 40);
196: raise;
197: end if;
198: hr_utility.set_location(' Leaving:'||l_proc,50);
199: End chk_attribute_id;
200: --
201: -- ----------------------------------------------------------------------------
202: -- |-------------------------< CHK_PARAMETER_ONE >----------------------------|

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

248: l_proc varchar2(72) := g_package || 'CHK_PARAMETER_ONE';
249: l_key varchar2(30);
250: --
251: Begin
252: hr_utility.set_location('Entering:'||l_proc,10);
253: -- Check for dependency issues with ATTRIBUTE_ID
254: if hr_multi_message.no_all_inclusive_error
255: (p_check_column1 => 'AME_CONDITIONS.ATTRIBUTE_ID') then
256: -- Check if the attribute_type is not ame_util.stringType

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

268: fnd_message.raise_error;
269: end if;
270: end if;
271: end if;
272: hr_utility.set_location(' Leaving:'||l_proc,30);
273: exception
274: when app_exception.application_exception then
275: if hr_multi_message.exception_add
276: (p_associated_column1 => 'AME_CONDITIONS.PARAMETER_ONE'

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

274: when app_exception.application_exception then
275: if hr_multi_message.exception_add
276: (p_associated_column1 => 'AME_CONDITIONS.PARAMETER_ONE'
277: ) then
278: hr_utility.set_location(' Leaving:'||l_proc, 40);
279: raise;
280: end if;
281: hr_utility.set_location(' Leaving:'||l_proc,50);
282: End chk_parameter_one;

Line 281: hr_utility.set_location(' Leaving:'||l_proc,50);

277: ) then
278: hr_utility.set_location(' Leaving:'||l_proc, 40);
279: raise;
280: end if;
281: hr_utility.set_location(' Leaving:'||l_proc,50);
282: End chk_parameter_one;
283: --
284: -- ----------------------------------------------------------------------------
285: -- |-------------------------< CHK_PARAMETERS >-------------------------------|

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

347: l_key varchar2(30);
348: l_key_approver number;
349: --
350: Begin
351: hr_utility.set_location('Entering:'||l_proc,10);
352: -- Check for dependency over CONDITION_TYPE.ATTRIBUTE_ID and PARAMETER_ONE
353: if hr_multi_message.no_all_inclusive_error
354: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'
355: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'

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

419: close csr_wf_role;
420: end if;
421: end if;
422: ----
423: hr_utility.set_location(' Leaving:'||l_proc,30);
424: exception
425: when app_exception.application_exception then
426: if hr_multi_message.exception_add
427: (p_associated_column1 => 'AME_CONDITIONS.PARAMETERS'

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

425: when app_exception.application_exception then
426: if hr_multi_message.exception_add
427: (p_associated_column1 => 'AME_CONDITIONS.PARAMETERS'
428: ) then
429: hr_utility.set_location(' Leaving:'||l_proc, 40);
430: raise;
431: end if;
432: hr_utility.set_location(' Leaving:'||l_proc,50);
433: End chk_parameters;

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

428: ) then
429: hr_utility.set_location(' Leaving:'||l_proc, 40);
430: raise;
431: end if;
432: hr_utility.set_location(' Leaving:'||l_proc,50);
433: End chk_parameters;
434: --
435: -- ----------------------------------------------------------------------------
436: -- |-------------------------< CHK_PARAMETER_THREE >--------------------------|

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

484: l_proc varchar2(72) := g_package || 'CHK_PARAMETER_THREE';
485: l_key varchar2(30);
486: --
487: Begin
488: hr_utility.set_location('Entering:'||l_proc,10);
489: -- Check for dependency over CONDITION_TYPE, ATTRIBUTE_ID
490: if hr_multi_message.no_all_inclusive_error
491: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'
492: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'

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

512: fnd_message.raise_error;
513: end if;
514: end if;
515: end if;
516: hr_utility.set_location(' Leaving:'||l_proc,30);
517: exception
518: when app_exception.application_exception then
519: if hr_multi_message.exception_add
520: (p_associated_column1 => 'AME_CONDITIONS.PARAMETER_THREE'

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

518: when app_exception.application_exception then
519: if hr_multi_message.exception_add
520: (p_associated_column1 => 'AME_CONDITIONS.PARAMETER_THREE'
521: ) then
522: hr_utility.set_location(' Leaving:'||l_proc, 40);
523: raise;
524: end if;
525: hr_utility.set_location(' Leaving:'||l_proc,50);
526: End chk_parameter_three;

Line 525: hr_utility.set_location(' Leaving:'||l_proc,50);

521: ) then
522: hr_utility.set_location(' Leaving:'||l_proc, 40);
523: raise;
524: end if;
525: hr_utility.set_location(' Leaving:'||l_proc,50);
526: End chk_parameter_three;
527: --
528: -- ----------------------------------------------------------------------------
529: -- |------------------------------< CHK_UNIQUE >------------------------------|

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

586: l_proc varchar2(72) := g_package || 'CHK_UNIQUE';
587: l_key number;
588: --
589: Begin
590: hr_utility.set_location('Entering:'||l_proc,10);
591: -- check for dependency over CONDITION_TYPE, ATTRIBUTE_ID
592: -- PARAMETER_ONE,PARAMETER_THREE and LIMITS
593: if hr_multi_message.no_all_inclusive_error
594: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'

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

610: end if;
611: end if;
612: close csr_name;
613: end if;
614: hr_utility.set_location(' Leaving:'||l_proc,30);
615: exception
616: when app_exception.application_exception then
617: if hr_multi_message.exception_add
618: (p_associated_column1 => 'AME_CONDITIONS.UNIQUE'

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

616: when app_exception.application_exception then
617: if hr_multi_message.exception_add
618: (p_associated_column1 => 'AME_CONDITIONS.UNIQUE'
619: ) then
620: hr_utility.set_location(' Leaving:'||l_proc, 40);
621: raise;
622: end if;
623: hr_utility.set_location(' Leaving:'||l_proc,50);
624: End chk_unique;

Line 623: hr_utility.set_location(' Leaving:'||l_proc,50);

619: ) then
620: hr_utility.set_location(' Leaving:'||l_proc, 40);
621: raise;
622: end if;
623: hr_utility.set_location(' Leaving:'||l_proc,50);
624: End chk_unique;
625: --
626: -- ----------------------------------------------------------------------------
627: -- |------------------------------< CHK_LIMITS >------------------------------|

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

678: l_proc varchar2(72) := g_package || 'CHK_LIMITS';
679: l_key varchar2(30);
680: --
681: Begin
682: hr_utility.set_location( 'Entering:'||l_proc,10 );
683: if hr_multi_message.no_all_inclusive_error
684: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'
685: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'
686: ,p_check_column3 => 'AME_CONDITIONS.PARAMETERS'

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

727: end if;
728: end if;
729: end if;
730: --
731: hr_utility.set_location(' Leaving:'||l_proc,30);
732: exception
733: when app_exception.application_exception then
734: if hr_multi_message.exception_add
735: (p_associated_column1 => 'AME_CONDITIONS.LIMITS'

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

733: when app_exception.application_exception then
734: if hr_multi_message.exception_add
735: (p_associated_column1 => 'AME_CONDITIONS.LIMITS'
736: ) then
737: hr_utility.set_location(' Leaving:'||l_proc, 40);
738: raise;
739: end if;
740: hr_utility.set_location(' Leaving:'||l_proc,50);
741: End chk_limits;

Line 740: hr_utility.set_location(' Leaving:'||l_proc,50);

736: ) then
737: hr_utility.set_location(' Leaving:'||l_proc, 40);
738: raise;
739: end if;
740: hr_utility.set_location(' Leaving:'||l_proc,50);
741: End chk_limits;
742: --
743: -- ----------------------------------------------------------------------------
744: -- |-------------------------< CHK_CONDITION_KEY >----------------------------|

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

782: l_proc varchar2(72) := g_package || 'CHK_CONDITION_KEY';
783: l_key varchar2(1);
784: --
785: Begin
786: hr_utility.set_location('Entering:'||l_proc,10);
787: hr_api.mandatory_arg_error(p_api_name => l_proc
788: ,p_argument => 'CONDITION_KEY'
789: ,p_argument_value => p_condition_key
790: );

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

800: fnd_message.set_name('PER','AME_400364_COND_KEY_SYMBOL');
801: fnd_message.raise_error;
802: end if;
803: close csr_name;
804: hr_utility.set_location(' Leaving:'||l_proc,30);
805: exception
806: when app_exception.application_exception then
807: if hr_multi_message.exception_add
808: (p_associated_column1 => 'AME_CONDITIONS.CONDITION_KEY'

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

806: when app_exception.application_exception then
807: if hr_multi_message.exception_add
808: (p_associated_column1 => 'AME_CONDITIONS.CONDITION_KEY'
809: ) then
810: hr_utility.set_location(' Leaving:'||l_proc, 40);
811: raise;
812: end if;
813: hr_utility.set_location(' Leaving:'||l_proc,50);
814: End chk_condition_key;

Line 813: hr_utility.set_location(' Leaving:'||l_proc,50);

809: ) then
810: hr_utility.set_location(' Leaving:'||l_proc, 40);
811: raise;
812: end if;
813: hr_utility.set_location(' Leaving:'||l_proc,50);
814: End chk_condition_key;
815: --
816: -- ----------------------------------------------------------------------------
817: -- |-----------------------------< chk_delete >-------------------------------|

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

867: l_proc varchar2(72) := g_package || 'CHK_DELETE';
868: l_key varchar2(1);
869: --
870: Begin
871: hr_utility.set_location('Entering:'||l_proc,10);
872: -- Check if the value already exists
873: open csr_name;
874: fetch csr_name into l_key;
875: if(csr_name%found) then

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

888: -- fnd_message.raise_error;
889: -- end if;
890: -- close c_sel2;
891:
892: hr_utility.set_location(' Leaving:'||l_proc,30);
893: exception
894: when app_exception.application_exception then
895: if hr_multi_message.exception_add
896: (p_associated_column1 => 'AME_CONDITIONS.DELETE'

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

894: when app_exception.application_exception then
895: if hr_multi_message.exception_add
896: (p_associated_column1 => 'AME_CONDITIONS.DELETE'
897: ) then
898: hr_utility.set_location(' Leaving:'||l_proc, 40);
899: raise;
900: end if;
901: hr_utility.set_location(' Leaving:'||l_proc,50);
902: End chk_delete;

Line 901: hr_utility.set_location(' Leaving:'||l_proc,50);

897: ) then
898: hr_utility.set_location(' Leaving:'||l_proc, 40);
899: raise;
900: end if;
901: hr_utility.set_location(' Leaving:'||l_proc,50);
902: End chk_delete;
903: --
904: -- ----------------------------------------------------------------------------
905: -- |-----------------------< chk_non_updateable_args >------------------------|

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

1172: --
1173: l_proc varchar2(72) := g_package||'insert_validate';
1174: --
1175: Begin
1176: hr_utility.set_location('Entering:'||l_proc, 5);
1177: --
1178: -- Validate Dependent Attributes
1179: --
1180: -- User Entered calls to validate procedures

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

1223: ,p_effective_date
1224: );
1225:
1226: --
1227: hr_utility.set_location(' Leaving:'||l_proc, 10);
1228: End insert_validate;
1229: --
1230: -- ----------------------------------------------------------------------------
1231: -- |---------------------------< update_validate >----------------------------|

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

1240: --
1241: l_proc varchar2(72) := g_package||'update_validate';
1242: --
1243: Begin
1244: hr_utility.set_location('Entering:'||l_proc, 5);
1245: --
1246: -- Validate Dependent Attributes
1247: --
1248: -- Call the datetrack update integrity operation

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

1294: ,p_effective_date
1295: );
1296:
1297: --
1298: hr_utility.set_location(' Leaving:'||l_proc, 10);
1299: End update_validate;
1300: --
1301: -- ----------------------------------------------------------------------------
1302: -- |---------------------------< delete_validate >----------------------------|

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

1311: --
1312: l_proc varchar2(72) := g_package||'delete_validate';
1313: --
1314: Begin
1315: hr_utility.set_location('Entering:'||l_proc, 5);
1316: --
1317: -- Call all supporting business operations
1318: --
1319: dt_delete_validate

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

1322: ,p_validation_end_date => p_validation_end_date
1323: ,p_condition_id => p_rec.condition_id
1324: );
1325: --
1326: hr_utility.set_location(' Leaving:'||l_proc, 10);
1327: End delete_validate;
1328: --
1329: end ame_con_bus;