DBA Data[Home] [Help]

APPS.PAY_IN_PROF_TAX_PKG dependencies on HR_GENERAL

Line 254: IF hr_general.decode_lookup('IN_PT_STATES',p_state) IS NULL THEN

250: RETURN;
251: END IF;
252: pay_in_utils.set_location(g_debug,l_procedure,40);
253:
254: IF hr_general.decode_lookup('IN_PT_STATES',p_state) IS NULL THEN
255: IF hr_general.decode_lookup('IN_STATES',p_state) IS NULL THEN
256: p_message_name := 'PER_IN_INVALID_LOOKUP_VALUE';
257: p_token_name(1) := 'VALUE';
258: p_token_value(1) := p_state;

Line 255: IF hr_general.decode_lookup('IN_STATES',p_state) IS NULL THEN

251: END IF;
252: pay_in_utils.set_location(g_debug,l_procedure,40);
253:
254: IF hr_general.decode_lookup('IN_PT_STATES',p_state) IS NULL THEN
255: IF hr_general.decode_lookup('IN_STATES',p_state) IS NULL THEN
256: p_message_name := 'PER_IN_INVALID_LOOKUP_VALUE';
257: p_token_name(1) := 'VALUE';
258: p_token_value(1) := p_state;
259: p_token_name(2) := 'FIELD';

Line 391: IF hr_general.decode_lookup('IN_PT_STATES',p_state) IS NULL THEN

387: RETURN;
388: END IF;
389: pay_in_utils.set_location(g_debug,l_procedure,40);
390:
391: IF hr_general.decode_lookup('IN_PT_STATES',p_state) IS NULL THEN
392: IF hr_general.decode_lookup('IN_STATES',p_state) IS NULL THEN
393: p_message_name := 'PER_IN_INVALID_LOOKUP_VALUE';
394: p_token_name(1) := 'VALUE';
395: p_token_value(1) := p_state;

Line 392: IF hr_general.decode_lookup('IN_STATES',p_state) IS NULL THEN

388: END IF;
389: pay_in_utils.set_location(g_debug,l_procedure,40);
390:
391: IF hr_general.decode_lookup('IN_PT_STATES',p_state) IS NULL THEN
392: IF hr_general.decode_lookup('IN_STATES',p_state) IS NULL THEN
393: p_message_name := 'PER_IN_INVALID_LOOKUP_VALUE';
394: p_token_name(1) := 'VALUE';
395: p_token_value(1) := p_state;
396: p_token_name(2) := 'FIELD';

Line 403: IF hr_general.decode_lookup('IN_PT_FREQUENCIES',p_frequency) IS NULL THEN

399: END IF;
400: END IF;
401: pay_in_utils.set_location(g_debug,l_procedure,50);
402:
403: IF hr_general.decode_lookup('IN_PT_FREQUENCIES',p_frequency) IS NULL THEN
404: p_message_name := 'PER_IN_INVALID_LOOKUP_VALUE';
405: p_token_name(1) := 'VALUE';
406: p_token_value(1) := p_frequency;
407: p_token_name(2) := 'FIELD';

Line 551: IF hr_general.decode_lookup('IN_CALENDAR_MONTH',p_payment_month) IS NULL THEN

547: RETURN;
548: END IF;
549: pay_in_utils.set_location(g_debug,l_procedure,65);
550:
551: IF hr_general.decode_lookup('IN_CALENDAR_MONTH',p_payment_month) IS NULL THEN
552: p_message_name := 'PER_IN_INVALID_LOOKUP_VALUE';
553: p_token_name(1) := 'VALUE';
554: p_token_value(1) := p_payment_month;
555: p_token_name(2) := 'FIELD';

Line 741: IF hr_general.decode_lookup('IN_PT_STATES',l_state) IS NULL THEN

737: RETURN;
738: END IF;
739: CLOSE csr_state;
740:
741: IF hr_general.decode_lookup('IN_PT_STATES',l_state) IS NULL THEN
742: IF hr_general.decode_lookup('IN_STATES',l_state) IS NULL THEN
743: p_message_name := 'PER_IN_INVALID_LOOKUP_VALUE';
744: p_token_name(1) := 'VALUE';
745: p_token_value(1) := l_state;

Line 742: IF hr_general.decode_lookup('IN_STATES',l_state) IS NULL THEN

738: END IF;
739: CLOSE csr_state;
740:
741: IF hr_general.decode_lookup('IN_PT_STATES',l_state) IS NULL THEN
742: IF hr_general.decode_lookup('IN_STATES',l_state) IS NULL THEN
743: p_message_name := 'PER_IN_INVALID_LOOKUP_VALUE';
744: p_token_name(1) := 'VALUE';
745: p_token_value(1) := l_state;
746: p_token_name(2) := 'FIELD';