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

Line 64: hr_utility.trace('Entering '||l_proc_name);

60:
61: BEGIN
62:
63: l_proc_name := 'PER_US_ASG_EXT_INFO_CHK.CHK_DUP_PRORATION_INS';
64: hr_utility.trace('Entering '||l_proc_name);
65: hr_utility.set_location (l_proc_name,10);
66: hr_utility.trace('Input parameters....');
67: hr_utility.trace('P_ASSIGNMENT_ID = '||P_ASSIGNMENT_ID);
68: hr_utility.trace('P_AEI_INFORMATION_CATEGORY = '||P_AEI_INFORMATION_CATEGORY);

Line 65: hr_utility.set_location (l_proc_name,10);

61: BEGIN
62:
63: l_proc_name := 'PER_US_ASG_EXT_INFO_CHK.CHK_DUP_PRORATION_INS';
64: hr_utility.trace('Entering '||l_proc_name);
65: hr_utility.set_location (l_proc_name,10);
66: hr_utility.trace('Input parameters....');
67: hr_utility.trace('P_ASSIGNMENT_ID = '||P_ASSIGNMENT_ID);
68: hr_utility.trace('P_AEI_INFORMATION_CATEGORY = '||P_AEI_INFORMATION_CATEGORY);
69: hr_utility.trace('P_AEI_INFORMATION1 = '||P_AEI_INFORMATION1);

Line 66: hr_utility.trace('Input parameters....');

62:
63: l_proc_name := 'PER_US_ASG_EXT_INFO_CHK.CHK_DUP_PRORATION_INS';
64: hr_utility.trace('Entering '||l_proc_name);
65: hr_utility.set_location (l_proc_name,10);
66: hr_utility.trace('Input parameters....');
67: hr_utility.trace('P_ASSIGNMENT_ID = '||P_ASSIGNMENT_ID);
68: hr_utility.trace('P_AEI_INFORMATION_CATEGORY = '||P_AEI_INFORMATION_CATEGORY);
69: hr_utility.trace('P_AEI_INFORMATION1 = '||P_AEI_INFORMATION1);
70: hr_utility.trace('P_AEI_INFORMATION2 = '||P_AEI_INFORMATION2);

Line 67: hr_utility.trace('P_ASSIGNMENT_ID = '||P_ASSIGNMENT_ID);

63: l_proc_name := 'PER_US_ASG_EXT_INFO_CHK.CHK_DUP_PRORATION_INS';
64: hr_utility.trace('Entering '||l_proc_name);
65: hr_utility.set_location (l_proc_name,10);
66: hr_utility.trace('Input parameters....');
67: hr_utility.trace('P_ASSIGNMENT_ID = '||P_ASSIGNMENT_ID);
68: hr_utility.trace('P_AEI_INFORMATION_CATEGORY = '||P_AEI_INFORMATION_CATEGORY);
69: hr_utility.trace('P_AEI_INFORMATION1 = '||P_AEI_INFORMATION1);
70: hr_utility.trace('P_AEI_INFORMATION2 = '||P_AEI_INFORMATION2);
71:

Line 68: hr_utility.trace('P_AEI_INFORMATION_CATEGORY = '||P_AEI_INFORMATION_CATEGORY);

64: hr_utility.trace('Entering '||l_proc_name);
65: hr_utility.set_location (l_proc_name,10);
66: hr_utility.trace('Input parameters....');
67: hr_utility.trace('P_ASSIGNMENT_ID = '||P_ASSIGNMENT_ID);
68: hr_utility.trace('P_AEI_INFORMATION_CATEGORY = '||P_AEI_INFORMATION_CATEGORY);
69: hr_utility.trace('P_AEI_INFORMATION1 = '||P_AEI_INFORMATION1);
70: hr_utility.trace('P_AEI_INFORMATION2 = '||P_AEI_INFORMATION2);
71:
72: IF p_aei_information_category = 'US_PRORATION_RULE' THEN

Line 69: hr_utility.trace('P_AEI_INFORMATION1 = '||P_AEI_INFORMATION1);

65: hr_utility.set_location (l_proc_name,10);
66: hr_utility.trace('Input parameters....');
67: hr_utility.trace('P_ASSIGNMENT_ID = '||P_ASSIGNMENT_ID);
68: hr_utility.trace('P_AEI_INFORMATION_CATEGORY = '||P_AEI_INFORMATION_CATEGORY);
69: hr_utility.trace('P_AEI_INFORMATION1 = '||P_AEI_INFORMATION1);
70: hr_utility.trace('P_AEI_INFORMATION2 = '||P_AEI_INFORMATION2);
71:
72: IF p_aei_information_category = 'US_PRORATION_RULE' THEN
73: OPEN c_dup_records;

Line 70: hr_utility.trace('P_AEI_INFORMATION2 = '||P_AEI_INFORMATION2);

66: hr_utility.trace('Input parameters....');
67: hr_utility.trace('P_ASSIGNMENT_ID = '||P_ASSIGNMENT_ID);
68: hr_utility.trace('P_AEI_INFORMATION_CATEGORY = '||P_AEI_INFORMATION_CATEGORY);
69: hr_utility.trace('P_AEI_INFORMATION1 = '||P_AEI_INFORMATION1);
70: hr_utility.trace('P_AEI_INFORMATION2 = '||P_AEI_INFORMATION2);
71:
72: IF p_aei_information_category = 'US_PRORATION_RULE' THEN
73: OPEN c_dup_records;
74: FETCH c_dup_records INTO l_count;

Line 77: hr_utility.trace('Number of records = '||l_count);

73: OPEN c_dup_records;
74: FETCH c_dup_records INTO l_count;
75: CLOSE c_dup_records;
76:
77: hr_utility.trace('Number of records = '||l_count);
78: IF l_count >= 1 THEN
79: hr_utility.set_location (l_proc_name,20);
80: hr_utility.set_message(800, 'PER_US_DUP_PRORATION');
81: hr_utility.raise_error;

Line 79: hr_utility.set_location (l_proc_name,20);

75: CLOSE c_dup_records;
76:
77: hr_utility.trace('Number of records = '||l_count);
78: IF l_count >= 1 THEN
79: hr_utility.set_location (l_proc_name,20);
80: hr_utility.set_message(800, 'PER_US_DUP_PRORATION');
81: hr_utility.raise_error;
82: END IF;
83: END IF;

Line 80: hr_utility.set_message(800, 'PER_US_DUP_PRORATION');

76:
77: hr_utility.trace('Number of records = '||l_count);
78: IF l_count >= 1 THEN
79: hr_utility.set_location (l_proc_name,20);
80: hr_utility.set_message(800, 'PER_US_DUP_PRORATION');
81: hr_utility.raise_error;
82: END IF;
83: END IF;
84: hr_utility.set_location (l_proc_name,30);

Line 81: hr_utility.raise_error;

77: hr_utility.trace('Number of records = '||l_count);
78: IF l_count >= 1 THEN
79: hr_utility.set_location (l_proc_name,20);
80: hr_utility.set_message(800, 'PER_US_DUP_PRORATION');
81: hr_utility.raise_error;
82: END IF;
83: END IF;
84: hr_utility.set_location (l_proc_name,30);
85: hr_utility.trace('Leaving '||l_proc_name);

Line 84: hr_utility.set_location (l_proc_name,30);

80: hr_utility.set_message(800, 'PER_US_DUP_PRORATION');
81: hr_utility.raise_error;
82: END IF;
83: END IF;
84: hr_utility.set_location (l_proc_name,30);
85: hr_utility.trace('Leaving '||l_proc_name);
86:
87: END CHK_DUP_PRORATION_INS;
88:

Line 85: hr_utility.trace('Leaving '||l_proc_name);

81: hr_utility.raise_error;
82: END IF;
83: END IF;
84: hr_utility.set_location (l_proc_name,30);
85: hr_utility.trace('Leaving '||l_proc_name);
86:
87: END CHK_DUP_PRORATION_INS;
88:
89:

Line 111: hr_utility.trace('Entering '||l_proc_name);

107: l_asg_id per_assignment_extra_info.assignment_id%TYPE;
108: l_proc_name varchar2(100);
109: BEGIN
110: l_proc_name := 'PER_US_ASG_EXT_INFO_CHK.CHK_DUP_PRORATION_UPD';
111: hr_utility.trace('Entering '||l_proc_name);
112: hr_utility.set_location(l_proc_name, 10);
113: hr_utility.trace('Input parameters....');
114: hr_utility.trace('P_ASSIGNMENT_EXTRA_INFO_ID = '||P_ASSIGNMENT_EXTRA_INFO_ID);
115: hr_utility.trace('P_AEI_INFORMATION_CATEGORY = '||P_AEI_INFORMATION_CATEGORY);

Line 112: hr_utility.set_location(l_proc_name, 10);

108: l_proc_name varchar2(100);
109: BEGIN
110: l_proc_name := 'PER_US_ASG_EXT_INFO_CHK.CHK_DUP_PRORATION_UPD';
111: hr_utility.trace('Entering '||l_proc_name);
112: hr_utility.set_location(l_proc_name, 10);
113: hr_utility.trace('Input parameters....');
114: hr_utility.trace('P_ASSIGNMENT_EXTRA_INFO_ID = '||P_ASSIGNMENT_EXTRA_INFO_ID);
115: hr_utility.trace('P_AEI_INFORMATION_CATEGORY = '||P_AEI_INFORMATION_CATEGORY);
116: hr_utility.trace('P_AEI_INFORMATION1 = '||P_AEI_INFORMATION1);

Line 113: hr_utility.trace('Input parameters....');

109: BEGIN
110: l_proc_name := 'PER_US_ASG_EXT_INFO_CHK.CHK_DUP_PRORATION_UPD';
111: hr_utility.trace('Entering '||l_proc_name);
112: hr_utility.set_location(l_proc_name, 10);
113: hr_utility.trace('Input parameters....');
114: hr_utility.trace('P_ASSIGNMENT_EXTRA_INFO_ID = '||P_ASSIGNMENT_EXTRA_INFO_ID);
115: hr_utility.trace('P_AEI_INFORMATION_CATEGORY = '||P_AEI_INFORMATION_CATEGORY);
116: hr_utility.trace('P_AEI_INFORMATION1 = '||P_AEI_INFORMATION1);
117: hr_utility.trace('P_AEI_INFORMATION2 = '||P_AEI_INFORMATION2);

Line 114: hr_utility.trace('P_ASSIGNMENT_EXTRA_INFO_ID = '||P_ASSIGNMENT_EXTRA_INFO_ID);

110: l_proc_name := 'PER_US_ASG_EXT_INFO_CHK.CHK_DUP_PRORATION_UPD';
111: hr_utility.trace('Entering '||l_proc_name);
112: hr_utility.set_location(l_proc_name, 10);
113: hr_utility.trace('Input parameters....');
114: hr_utility.trace('P_ASSIGNMENT_EXTRA_INFO_ID = '||P_ASSIGNMENT_EXTRA_INFO_ID);
115: hr_utility.trace('P_AEI_INFORMATION_CATEGORY = '||P_AEI_INFORMATION_CATEGORY);
116: hr_utility.trace('P_AEI_INFORMATION1 = '||P_AEI_INFORMATION1);
117: hr_utility.trace('P_AEI_INFORMATION2 = '||P_AEI_INFORMATION2);
118: OPEN c_asg_id;

Line 115: hr_utility.trace('P_AEI_INFORMATION_CATEGORY = '||P_AEI_INFORMATION_CATEGORY);

111: hr_utility.trace('Entering '||l_proc_name);
112: hr_utility.set_location(l_proc_name, 10);
113: hr_utility.trace('Input parameters....');
114: hr_utility.trace('P_ASSIGNMENT_EXTRA_INFO_ID = '||P_ASSIGNMENT_EXTRA_INFO_ID);
115: hr_utility.trace('P_AEI_INFORMATION_CATEGORY = '||P_AEI_INFORMATION_CATEGORY);
116: hr_utility.trace('P_AEI_INFORMATION1 = '||P_AEI_INFORMATION1);
117: hr_utility.trace('P_AEI_INFORMATION2 = '||P_AEI_INFORMATION2);
118: OPEN c_asg_id;
119: FETCH c_asg_id INTO l_asg_id;

Line 116: hr_utility.trace('P_AEI_INFORMATION1 = '||P_AEI_INFORMATION1);

112: hr_utility.set_location(l_proc_name, 10);
113: hr_utility.trace('Input parameters....');
114: hr_utility.trace('P_ASSIGNMENT_EXTRA_INFO_ID = '||P_ASSIGNMENT_EXTRA_INFO_ID);
115: hr_utility.trace('P_AEI_INFORMATION_CATEGORY = '||P_AEI_INFORMATION_CATEGORY);
116: hr_utility.trace('P_AEI_INFORMATION1 = '||P_AEI_INFORMATION1);
117: hr_utility.trace('P_AEI_INFORMATION2 = '||P_AEI_INFORMATION2);
118: OPEN c_asg_id;
119: FETCH c_asg_id INTO l_asg_id;
120: CLOSE c_asg_id;

Line 117: hr_utility.trace('P_AEI_INFORMATION2 = '||P_AEI_INFORMATION2);

113: hr_utility.trace('Input parameters....');
114: hr_utility.trace('P_ASSIGNMENT_EXTRA_INFO_ID = '||P_ASSIGNMENT_EXTRA_INFO_ID);
115: hr_utility.trace('P_AEI_INFORMATION_CATEGORY = '||P_AEI_INFORMATION_CATEGORY);
116: hr_utility.trace('P_AEI_INFORMATION1 = '||P_AEI_INFORMATION1);
117: hr_utility.trace('P_AEI_INFORMATION2 = '||P_AEI_INFORMATION2);
118: OPEN c_asg_id;
119: FETCH c_asg_id INTO l_asg_id;
120: CLOSE c_asg_id;
121:

Line 133: hr_utility.set_location(l_proc_name, 20);

129: p_aei_information2
130: );
131:
132: GLB_MODE := NULL;
133: hr_utility.set_location(l_proc_name, 20);
134: hr_utility.trace('Leaving '||l_proc_name);
135: END CHK_DUP_PRORATION_UPD;
136:
137: END PER_US_ASG_EXT_INFO_CHK;

Line 134: hr_utility.trace('Leaving '||l_proc_name);

130: );
131:
132: GLB_MODE := NULL;
133: hr_utility.set_location(l_proc_name, 20);
134: hr_utility.trace('Leaving '||l_proc_name);
135: END CHK_DUP_PRORATION_UPD;
136:
137: END PER_US_ASG_EXT_INFO_CHK;