APPS.PAY_CA_VALUE_VALIDATION dependencies on HR_UTILITY

Line 22: hr_utility.set_location('validate_wcb_account_number', 10);

18: where account_number = p_act_number
19: and business_group_id = p_bus_group_id;
20: --
21: BEGIN
22: hr_utility.set_location('validate_wcb_account_number', 10);
23: --
24: OPEN validate_wcb_account_number(p_business_group_id, p_account_number);
25: FETCH validate_wcb_account_number INTO l_valid_value;
26: IF validate_wcb_account_number%NOTFOUND THEN

Line 27: hr_utility.set_location('validate_wcb_account_number', 20);

23: --
24: OPEN validate_wcb_account_number(p_business_group_id, p_account_number);
25: FETCH validate_wcb_account_number INTO l_valid_value;
26: IF validate_wcb_account_number%NOTFOUND THEN
27: hr_utility.set_location('validate_wcb_account_number', 20);
28: l_valid_value := 'E';
29: END IF;
30: CLOSE validate_wcb_account_number;
31: --

Line 54: hr_utility.set_location('validate_wcb_rate_code', 10);

50: where code = p_code
51: and business_group_id = p_bus_group_id;
52: --
53: BEGIN
54: hr_utility.set_location('validate_wcb_rate_code', 10);
55: --
56: OPEN validate_wcb_rate_code(p_business_group_id, p_rate_code);
57: FETCH validate_wcb_rate_code INTO l_valid_value;
58: IF validate_wcb_rate_code%NOTFOUND THEN

Line 59: hr_utility.set_location('validate_wcb_rate_code', 20);

55: --
56: OPEN validate_wcb_rate_code(p_business_group_id, p_rate_code);
57: FETCH validate_wcb_rate_code INTO l_valid_value;
58: IF validate_wcb_rate_code%NOTFOUND THEN
59: hr_utility.set_location('validate_wcb_rate_code', 20);
60: l_valid_value := 'E';
61: END IF;
62: CLOSE validate_wcb_rate_code;
63: --

Line 86: hr_utility.set_location('validate_pmed_account_number', 10);

82: where account_number = p_act_number
83: and business_group_id = p_bus_group_id;
84: --
85: BEGIN
86: hr_utility.set_location('validate_pmed_account_number', 10);
87: --
88: OPEN validate_pmed_account_number(p_business_group_id, p_account_number);
89: FETCH validate_pmed_account_number INTO l_valid_value;
90: IF validate_pmed_account_number%NOTFOUND THEN

Line 91: hr_utility.set_location('validate_pmed_account_number', 20);

87: --
88: OPEN validate_pmed_account_number(p_business_group_id, p_account_number);
89: FETCH validate_pmed_account_number INTO l_valid_value;
90: IF validate_pmed_account_number%NOTFOUND THEN
91: hr_utility.set_location('validate_pmed_account_number', 20);
92: l_valid_value := 'E';
93: END IF;
94: CLOSE validate_pmed_account_number;
95: --

Line 126: hr_utility.set_location('validate_user_table_name', 10);

122: )
123: );
124: --
125: BEGIN
126: hr_utility.set_location('validate_user_table_name', 10);
127: --
128: OPEN validate_user_table_name(p_business_group_id, p_user_table_name);
129: FETCH validate_user_table_name INTO l_valid_value;
130: IF validate_user_table_name%NOTFOUND THEN

Line 131: hr_utility.set_location('validate_user_table_name',20);

127: --
128: OPEN validate_user_table_name(p_business_group_id, p_user_table_name);
129: FETCH validate_user_table_name INTO l_valid_value;
130: IF validate_user_table_name%NOTFOUND THEN
131: hr_utility.set_location('validate_user_table_name',20);
132: l_valid_value := 'E';
133: END IF;
134: CLOSE validate_user_table_name;
135: --

Line 166: hr_utility.set_location('validate_user_table_column', 10);

162: )
163: );
164: --
165: BEGIN
166: hr_utility.set_location('validate_user_table_column', 10);
167: --
168: OPEN validate_user_table_column(p_business_group_id, p_user_table_column);
169: FETCH validate_user_table_column INTO l_valid_value;
170: IF validate_user_table_column%NOTFOUND THEN

Line 171: hr_utility.set_location('validate_user_table_column', 20);

167: --
168: OPEN validate_user_table_column(p_business_group_id, p_user_table_column);
169: FETCH validate_user_table_column INTO l_valid_value;
170: IF validate_user_table_column%NOTFOUND THEN
171: hr_utility.set_location('validate_user_table_column', 20);
172: l_valid_value := 'E';
173: END IF;
174: CLOSE validate_user_table_column;
175: --