DBA Data[Home] [Help]

APPS.PAY_IN_UTILS dependencies on HR_UTILITY

Line 40: g_debug := hr_utility.debug_enabled;

36: l_procedure VARCHAR2(50);
37: l_message VARCHAR2(300);
38: --
39: BEGIN
40: g_debug := hr_utility.debug_enabled;
41: l_procedure := g_package||'get_max_act_sequence';
42: --
43: set_location(g_debug, 'Entered '|| l_procedure,10);
44: trace('Assignment ID ',p_assignment_id );

Line 90: hr_utility.set_location(SUBSTR('INLOG: '||p_message,1,72), p_step);

86: )
87: IS
88: BEGIN
89: IF p_trace THEN
90: hr_utility.set_location(SUBSTR('INLOG: '||p_message,1,72), p_step);
91: END IF;
92:
93: END set_location;
94:

Line 111: hr_utility.trace(RPAD(SUBSTR('INTRC: '||p_message,1,60),60,' ')||': '||p_value);

107: PROCEDURE trace (p_message IN VARCHAR2
108: ,p_value IN VARCHAR2)
109: IS
110: BEGIN
111: hr_utility.trace(RPAD(SUBSTR('INTRC: '||p_message,1,60),60,' ')||': '||p_value);
112: END trace;
113:
114: --------------------------------------------------------------------------
115: -- --

Line 178: g_debug := hr_utility.debug_enabled;

174: l_colon_position NUMBER;
175: l_proc VARCHAR2(50);
176: --
177: BEGIN
178: g_debug := hr_utility.debug_enabled;
179: l_proc := g_package||'get_pay_message';
180: --
181: set_location(g_debug, 'Entered '||l_proc,5);
182: set_location(g_debug, '. Message Name: '||p_message_name,40);

Line 184: hr_utility.set_message(800,p_message_name);

180: --
181: set_location(g_debug, 'Entered '||l_proc,5);
182: set_location(g_debug, '. Message Name: '||p_message_name,40);
183:
184: hr_utility.set_message(800,p_message_name);
185:
186: IF p_token1 IS NOT NULL THEN
187: /* Obtain token 1 name and value */
188: l_colon_position := INSTR(p_token1,':');

Line 191: hr_utility.set_message_token(l_token_name,l_token_value);

187: /* Obtain token 1 name and value */
188: l_colon_position := INSTR(p_token1,':');
189: l_token_name := SUBSTR(p_token1,1,l_colon_position-1);
190: l_token_value := SUBSTR(SUBSTR(p_token1,l_colon_position+1,LENGTH(p_token1)) ,1,77);
191: hr_utility.set_message_token(l_token_name,l_token_value);
192: set_location(g_debug,'. Token1: '||l_token_name||'. Value: '||l_token_value,50);
193: END IF;
194:
195: IF p_token2 IS NOT NULL THEN

Line 200: hr_utility.set_message_token(l_token_name,l_token_value);

196: /* Obtain token 2 name and value */
197: l_colon_position := INSTR(p_token2,':');
198: l_token_name := SUBSTR(p_token2,1,l_colon_position-1);
199: l_token_value := SUBSTR(SUBSTR(p_token2,l_colon_position+1,LENGTH(p_token2)) ,1,77);
200: hr_utility.set_message_token(l_token_name,l_token_value);
201: set_location(g_debug,'. Token2: '||l_token_name||'. Value: '||l_token_value,60);
202: END IF;
203:
204: IF p_token3 IS NOT NULL THEN

Line 209: hr_utility.set_message_token(l_token_name,l_token_value);

205: /* Obtain token 3 name and value */
206: l_colon_position := INSTR(p_token3,':');
207: l_token_name := SUBSTR(p_token3,1,l_colon_position-1);
208: l_token_value := SUBSTR(SUBSTR(p_token3,l_colon_position+1,LENGTH(p_token3)) ,1,77);
209: hr_utility.set_message_token(l_token_name,l_token_value);
210: set_location(g_debug,'. Token3: '||l_token_name||'. Value: '||l_token_value,70);
211: END IF;
212:
213: IF p_token4 IS NOT NULL THEN

Line 218: hr_utility.set_message_token(l_token_name,l_token_value);

214: /* Obtain token 4 name and value */
215: l_colon_position := INSTR(p_token4,':');
216: l_token_name := SUBSTR(p_token4,1,l_colon_position-1);
217: l_token_value := SUBSTR(SUBSTR(p_token4,l_colon_position+1,LENGTH(p_token4)) ,1,77);
218: hr_utility.set_message_token(l_token_name,l_token_value);
219: set_location(g_debug,'. Token4: '||l_token_name||'. Value: '||l_token_value,80);
220: END IF;
221:
222: l_message := SUBSTRB(hr_utility.get_message,1,250);

Line 222: l_message := SUBSTRB(hr_utility.get_message,1,250);

218: hr_utility.set_message_token(l_token_name,l_token_value);
219: set_location(g_debug,'. Token4: '||l_token_name||'. Value: '||l_token_value,80);
220: END IF;
221:
222: l_message := SUBSTRB(hr_utility.get_message,1,250);
223:
224: set_location(g_debug,'leaving '||l_proc,100);
225: RETURN l_message;
226:

Line 275: hr_utility.set_message(p_application_id, p_message_name);

271: cnt NUMBER;
272: BEGIN
273: IF p_message_name IS NOT NULL AND p_message_name <> 'SUCCESS' THEN
274: cnt:= p_token_name.count;
275: hr_utility.set_message(p_application_id, p_message_name);
276: FOR i IN 1..cnt
277: LOOP
278: hr_utility.set_message_token(p_token_name(i),p_token_value(i));
279: END LOOP;

Line 278: hr_utility.set_message_token(p_token_name(i),p_token_value(i));

274: cnt:= p_token_name.count;
275: hr_utility.set_message(p_application_id, p_message_name);
276: FOR i IN 1..cnt
277: LOOP
278: hr_utility.set_message_token(p_token_name(i),p_token_value(i));
279: END LOOP;
280: hr_utility.raise_error;
281: END IF;
282:

Line 280: hr_utility.raise_error;

276: FOR i IN 1..cnt
277: LOOP
278: hr_utility.set_message_token(p_token_name(i),p_token_value(i));
279: END LOOP;
280: hr_utility.raise_error;
281: END IF;
282:
283: END raise_message;
284:

Line 323: g_debug := hr_utility.debug_enabled;

319: l_value pay_user_column_instances_f.value%TYPE;
320: l_proc VARCHAR2(100);
321: BEGIN
322: l_proc := g_package||'get_user_table_value';
323: g_debug := hr_utility.debug_enabled;
324:
325: set_location(g_debug, 'Entering : '||l_proc,10);
326:
327: l_value := hruserdt.get_table_value

Line 485: g_debug := hr_utility.debug_enabled;

481: --
482: BEGIN
483: --
484: l_proc := g_package||'get_person_id';
485: g_debug := hr_utility.debug_enabled;
486: set_location(g_debug, 'Entering: ' || l_proc, 10);
487: --
488: IF g_debug THEN
489: --

Line 558: g_debug := hr_utility.debug_enabled;

554: --
555: BEGIN
556: --
557: l_proc := g_package||'.get_assignment_id';
558: g_debug := hr_utility.debug_enabled;
559: set_location(g_debug, 'Entering: ' || l_proc, 10);
560: --
561: IF g_debug THEN
562: --

Line 909: g_debug := hr_utility.debug_enabled;

905:
906: BEGIN
907:
908: l_procedure := g_package||'get_org_id';
909: g_debug := hr_utility.debug_enabled;
910:
911: set_location(g_debug,'Entering : '||l_procedure, 10);
912:
913: OPEN cur_scl_value (p_assignment_id

Line 1422: g_debug := hr_utility.debug_enabled;

1418: l_formula_id NUMBER ;
1419: l_procedure CONSTANT VARCHAR2(100):= g_package||'get_formula_id';
1420: l_message VARCHAR2(255);
1421: BEGIN
1422: g_debug := hr_utility.debug_enabled;
1423: set_location(g_debug, 'Entering: '||l_procedure,10);
1424:
1425: SELECT formula_id
1426: INTO l_formula_id

Line 1471: g_debug := hr_utility.debug_enabled;

1467: l_element_id NUMBER ;
1468: l_procedure CONSTANT VARCHAR2(100):= g_package||'get_element_type_id';
1469: l_message VARCHAR2(255);
1470: BEGIN
1471: g_debug := hr_utility.debug_enabled;
1472: set_location(g_debug, 'Entering: '||l_procedure,10);
1473:
1474: SELECT element_type_id
1475: INTO l_element_id

Line 1517: g_debug := hr_utility.debug_enabled;

1513: l_balance_id NUMBER ;
1514: l_procedure CONSTANT VARCHAR2(100):= g_package||'get_balance_type_id';
1515: l_message VARCHAR2(255);
1516: BEGIN
1517: g_debug := hr_utility.debug_enabled;
1518: set_location(g_debug, 'Entering: '||l_procedure,10);
1519:
1520: SELECT balance_type_id
1521: INTO l_balance_id

Line 1575: g_debug := hr_utility.debug_enabled;

1571: l_input_value_id NUMBER ;
1572: l_procedure CONSTANT VARCHAR2(100):= g_package||'get_input_value_id';
1573: l_message VARCHAR2(255);
1574: BEGIN
1575: g_debug := hr_utility.debug_enabled;
1576: set_location(g_debug, 'Entering: '||l_procedure,10);
1577:
1578: OPEN c_input_value_id;
1579: FETCH c_input_value_id INTO l_input_value_id;

Line 1628: g_debug := hr_utility.debug_enabled;

1624: l_input_value_id NUMBER ;
1625: l_procedure CONSTANT VARCHAR2(100):= g_package||'get_input_value_id';
1626: l_message VARCHAR2(255);
1627: BEGIN
1628: g_debug := hr_utility.debug_enabled;
1629: set_location(g_debug, 'Entering: '||l_procedure,10);
1630:
1631: l_input_value_id := get_input_value_id
1632: (p_effective_date

Line 2600: g_debug := hr_utility.debug_enabled;

2596:
2597: l_procedure VARCHAR2(250);
2598: l_message VARCHAR2(250);
2599: BEGIN
2600: g_debug := hr_utility.debug_enabled;
2601: l_procedure := g_package ||'get_age';
2602: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2603: IF (g_debug)
2604: THEN