689: if g_debug then
690: hr_utility.set_location(l_proc,20);
691: end if;
692: --
693: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
694: fnd_message.raise_error;
695: --
696: else
697: --
690: hr_utility.set_location(l_proc,20);
691: end if;
692: --
693: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
694: fnd_message.raise_error;
695: --
696: else
697: --
698: if g_debug then
819: if g_debug then
820: hr_utility.set_location(l_proc,20);
821: end if;
822: --
823: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
824: fnd_message.raise_error;
825: --
826: else
827: --
820: hr_utility.set_location(l_proc,20);
821: end if;
822: --
823: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
824: fnd_message.raise_error;
825: --
826: else
827: --
828: if g_debug then
966: if g_debug then
967: hr_utility.set_location(l_proc,20);
968: end if;
969: --
970: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
971: fnd_message.raise_error;
972: --
973: else
974: --
967: hr_utility.set_location(l_proc,20);
968: end if;
969: --
970: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
971: fnd_message.raise_error;
972: --
973: else
974: --
975: if g_debug then
1169: if g_debug then
1170: hr_utility.set_location(l_proc,20);
1171: end if;
1172: --
1173: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
1174: fnd_message.raise_error;
1175: --
1176: else
1177: --
1170: hr_utility.set_location(l_proc,20);
1171: end if;
1172: --
1173: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
1174: fnd_message.raise_error;
1175: --
1176: else
1177: --
1178: if g_debug then
1364: if g_debug then
1365: hr_utility.set_location(l_proc,20);
1366: end if;
1367: --
1368: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
1369: fnd_message.raise_error;
1370: --
1371: else
1372: --
1365: hr_utility.set_location(l_proc,20);
1366: end if;
1367: --
1368: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
1369: fnd_message.raise_error;
1370: --
1371: else
1372: --
1373: if g_debug then
1561: if g_debug then
1562: hr_utility.set_location(l_proc,20);
1563: end if;
1564: --
1565: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
1566: fnd_message.raise_error;
1567: --
1568: else
1569: --
1562: hr_utility.set_location(l_proc,20);
1563: end if;
1564: --
1565: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
1566: fnd_message.raise_error;
1567: --
1568: else
1569: --
1570: if g_debug then
1805: if g_debug then
1806: hr_utility.set_location(l_proc,20);
1807: end if;
1808: --
1809: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
1810: fnd_message.raise_error;
1811: --
1812: else
1813: --
1806: hr_utility.set_location(l_proc,20);
1807: end if;
1808: --
1809: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
1810: fnd_message.raise_error;
1811: --
1812: else
1813: --
1814: if g_debug then
2006: if g_debug then
2007: hr_utility.set_location(l_proc,20);
2008: end if;
2009: --
2010: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
2011: fnd_message.raise_error;
2012: --
2013: else
2014: --
2007: hr_utility.set_location(l_proc,20);
2008: end if;
2009: --
2010: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
2011: fnd_message.raise_error;
2012: --
2013: else
2014: --
2015: if g_debug then
2210: if g_debug then
2211: hr_utility.set_location(l_proc,20);
2212: end if;
2213: --
2214: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
2215: fnd_message.raise_error;
2216: --
2217: else
2218: --
2211: hr_utility.set_location(l_proc,20);
2212: end if;
2213: --
2214: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
2215: fnd_message.raise_error;
2216: --
2217: else
2218: --
2219: if g_debug then
2418: if g_debug then
2419: hr_utility.set_location(l_proc,20);
2420: end if;
2421: --
2422: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
2423: fnd_message.raise_error;
2424: --
2425: else
2426: --
2419: hr_utility.set_location(l_proc,20);
2420: end if;
2421: --
2422: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
2423: fnd_message.raise_error;
2424: --
2425: else
2426: --
2427: if g_debug then
2654: if g_debug then
2655: hr_utility.set_location(l_proc,20);
2656: end if;
2657: --
2658: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
2659: fnd_message.raise_error;
2660: --
2661: else
2662: --
2655: hr_utility.set_location(l_proc,20);
2656: end if;
2657: --
2658: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
2659: fnd_message.raise_error;
2660: --
2661: else
2662: --
2663: if g_debug then
2896: if g_debug then
2897: hr_utility.set_location(l_proc,20);
2898: end if;
2899: --
2900: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
2901: fnd_message.raise_error;
2902: --
2903: else
2904: --
2897: hr_utility.set_location(l_proc,20);
2898: end if;
2899: --
2900: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
2901: fnd_message.raise_error;
2902: --
2903: else
2904: --
2905: if g_debug then
3211: if g_debug then
3212: hr_utility.set_location(l_proc,20);
3213: end if;
3214: --
3215: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
3216: fnd_message.raise_error;
3217: --
3218: else
3219: --
3212: hr_utility.set_location(l_proc,20);
3213: end if;
3214: --
3215: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
3216: fnd_message.raise_error;
3217: --
3218: else
3219: --
3220: if g_debug then
3526: if g_debug then
3527: hr_utility.set_location(l_proc,20);
3528: end if;
3529: --
3530: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
3531: fnd_message.raise_error;
3532: --
3533: else
3534: --
3527: hr_utility.set_location(l_proc,20);
3528: end if;
3529: --
3530: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
3531: fnd_message.raise_error;
3532: --
3533: else
3534: --
3535: if g_debug then
6691: if g_debug then
6692: hr_utility.set_location(l_proc,20);
6693: end if;
6694: --
6695: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
6696: fnd_message.raise_error;
6697: --
6698: else
6699: --
6692: hr_utility.set_location(l_proc,20);
6693: end if;
6694: --
6695: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
6696: fnd_message.raise_error;
6697: --
6698: else
6699: --
6700: if g_debug then
6935: if g_debug then
6936: hr_utility.set_location(l_proc,20);
6937: end if;
6938: --
6939: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
6940: fnd_message.raise_error;
6941: --
6942: else
6943: --
6936: hr_utility.set_location(l_proc,20);
6937: end if;
6938: --
6939: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
6940: fnd_message.raise_error;
6941: --
6942: else
6943: --
6944: if g_debug then
7047: if g_debug then
7048: hr_utility.set_location(l_proc,20);
7049: end if;
7050: --
7051: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
7052: fnd_message.raise_error;
7053: --
7054: else
7055: --
7048: hr_utility.set_location(l_proc,20);
7049: end if;
7050: --
7051: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
7052: fnd_message.raise_error;
7053: --
7054: else
7055: --
7056: if g_debug then
7242: if g_debug then
7243: hr_utility.set_location(l_proc,20);
7244: end if;
7245: --
7246: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
7247: fnd_message.raise_error;
7248: --
7249: else
7250: --
7243: hr_utility.set_location(l_proc,20);
7244: end if;
7245: --
7246: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
7247: fnd_message.raise_error;
7248: --
7249: else
7250: --
7251: if g_debug then
7424: if g_debug then
7425: hr_utility.set_location(l_proc,20);
7426: end if;
7427: --
7428: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
7429: fnd_message.raise_error;
7430: --
7431: else
7432: --
7425: hr_utility.set_location(l_proc,20);
7426: end if;
7427: --
7428: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
7429: fnd_message.raise_error;
7430: --
7431: else
7432: --
7433: if g_debug then
7697: if g_debug then
7698: hr_utility.set_location(l_proc,20);
7699: end if;
7700: --
7701: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
7702: fnd_message.raise_error;
7703: --
7704: else
7705: --
7698: hr_utility.set_location(l_proc,20);
7699: end if;
7700: --
7701: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
7702: fnd_message.raise_error;
7703: --
7704: else
7705: --
7706: if g_debug then
7963: if g_debug then
7964: hr_utility.set_location(l_proc,20);
7965: end if;
7966: --
7967: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
7968: fnd_message.raise_error;
7969: --
7970: else
7971: --
7964: hr_utility.set_location(l_proc,20);
7965: end if;
7966: --
7967: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
7968: fnd_message.raise_error;
7969: --
7970: else
7971: --
7972: if g_debug then
8188: if g_debug then
8189: hr_utility.set_location(l_proc,20);
8190: end if;
8191: --
8192: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
8193: fnd_message.raise_error;
8194: --
8195: else
8196: --
8189: hr_utility.set_location(l_proc,20);
8190: end if;
8191: --
8192: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
8193: fnd_message.raise_error;
8194: --
8195: else
8196: --
8197: if g_debug then
8307: if g_debug then
8308: hr_utility.set_location(l_proc,20);
8309: end if;
8310: --
8311: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
8312: fnd_message.raise_error;
8313: --
8314: else
8315: --
8308: hr_utility.set_location(l_proc,20);
8309: end if;
8310: --
8311: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
8312: fnd_message.raise_error;
8313: --
8314: else
8315: --
8316: if g_debug then
9316: close csr_itax_org;
9317: --
9318: if l_itax_organization_id is null then
9319: --
9320: fnd_message.set_name('FND','SYSTEM-INVALID ARGS');
9321: fnd_message.set_token('ROUTINE', 'p_itax_organization_id');
9322: fnd_message.raise_error;
9323: --
9324: end if;
9317: --
9318: if l_itax_organization_id is null then
9319: --
9320: fnd_message.set_name('FND','SYSTEM-INVALID ARGS');
9321: fnd_message.set_token('ROUTINE', 'p_itax_organization_id');
9322: fnd_message.raise_error;
9323: --
9324: end if;
9325: --
9318: if l_itax_organization_id is null then
9319: --
9320: fnd_message.set_name('FND','SYSTEM-INVALID ARGS');
9321: fnd_message.set_token('ROUTINE', 'p_itax_organization_id');
9322: fnd_message.raise_error;
9323: --
9324: end if;
9325: --
9326: hr_api.mandatory_arg_error(l_proc, 'p_effective_date', p_effective_date);
9332: close csr_payroll;
9333: --
9334: if l_payroll_id is null then
9335: --
9336: fnd_message.set_name('FND','SYSTEM-INVALID ARGS');
9337: fnd_message.set_token('ROUTINE', 'p_payroll_id');
9338: fnd_message.raise_error;
9339: --
9340: end if;
9333: --
9334: if l_payroll_id is null then
9335: --
9336: fnd_message.set_name('FND','SYSTEM-INVALID ARGS');
9337: fnd_message.set_token('ROUTINE', 'p_payroll_id');
9338: fnd_message.raise_error;
9339: --
9340: end if;
9341: --
9334: if l_payroll_id is null then
9335: --
9336: fnd_message.set_name('FND','SYSTEM-INVALID ARGS');
9337: fnd_message.set_token('ROUTINE', 'p_payroll_id');
9338: fnd_message.raise_error;
9339: --
9340: end if;
9341: --
9342: if p_category not in ('SAL_ERN','BON_ERN','WRK','SAL_DCT','BON_DCT') then
9340: end if;
9341: --
9342: if p_category not in ('SAL_ERN','BON_ERN','WRK','SAL_DCT','BON_DCT') then
9343: --
9344: fnd_message.set_name('FND','SYSTEM-INVALID ARGS');
9345: fnd_message.set_token('ROUTINE', 'p_category');
9346: fnd_message.raise_error;
9347: --
9348: end if;
9341: --
9342: if p_category not in ('SAL_ERN','BON_ERN','WRK','SAL_DCT','BON_DCT') then
9343: --
9344: fnd_message.set_name('FND','SYSTEM-INVALID ARGS');
9345: fnd_message.set_token('ROUTINE', 'p_category');
9346: fnd_message.raise_error;
9347: --
9348: end if;
9349: --
9342: if p_category not in ('SAL_ERN','BON_ERN','WRK','SAL_DCT','BON_DCT') then
9343: --
9344: fnd_message.set_name('FND','SYSTEM-INVALID ARGS');
9345: fnd_message.set_token('ROUTINE', 'p_category');
9346: fnd_message.raise_error;
9347: --
9348: end if;
9349: --
9350: if p_type not in ('IV','DBAL') then
9348: end if;
9349: --
9350: if p_type not in ('IV','DBAL') then
9351: --
9352: fnd_message.set_name('FND','SYSTEM-INVALID ARGS');
9353: fnd_message.set_token('ROUTINE', 'p_type');
9354: fnd_message.raise_error;
9355: --
9356: end if;
9349: --
9350: if p_type not in ('IV','DBAL') then
9351: --
9352: fnd_message.set_name('FND','SYSTEM-INVALID ARGS');
9353: fnd_message.set_token('ROUTINE', 'p_type');
9354: fnd_message.raise_error;
9355: --
9356: end if;
9357: --
9350: if p_type not in ('IV','DBAL') then
9351: --
9352: fnd_message.set_name('FND','SYSTEM-INVALID ARGS');
9353: fnd_message.set_token('ROUTINE', 'p_type');
9354: fnd_message.raise_error;
9355: --
9356: end if;
9357: --
9358: if p_type = 'IV' then
9365: close csr_iv;
9366: --
9367: if l_input_value_id is null then
9368: --
9369: fnd_message.set_name('FND','SYSTEM-INVALID ARGS');
9370: fnd_message.set_token('ROUTINE', 'p_input_value_id');
9371: fnd_message.raise_error;
9372: --
9373: end if;
9366: --
9367: if l_input_value_id is null then
9368: --
9369: fnd_message.set_name('FND','SYSTEM-INVALID ARGS');
9370: fnd_message.set_token('ROUTINE', 'p_input_value_id');
9371: fnd_message.raise_error;
9372: --
9373: end if;
9374: --
9367: if l_input_value_id is null then
9368: --
9369: fnd_message.set_name('FND','SYSTEM-INVALID ARGS');
9370: fnd_message.set_token('ROUTINE', 'p_input_value_id');
9371: fnd_message.raise_error;
9372: --
9373: end if;
9374: --
9375: elsif p_type = 'DBAL' then
9382: close csr_dbal;
9383: --
9384: if l_defined_balance_id is null then
9385: --
9386: fnd_message.set_name('FND','SYSTEM-INVALID ARGS');
9387: fnd_message.set_token('ROUTINE', 'p_defined_balance_id');
9388: fnd_message.raise_error;
9389: --
9390: end if;
9383: --
9384: if l_defined_balance_id is null then
9385: --
9386: fnd_message.set_name('FND','SYSTEM-INVALID ARGS');
9387: fnd_message.set_token('ROUTINE', 'p_defined_balance_id');
9388: fnd_message.raise_error;
9389: --
9390: end if;
9391: --
9384: if l_defined_balance_id is null then
9385: --
9386: fnd_message.set_name('FND','SYSTEM-INVALID ARGS');
9387: fnd_message.set_token('ROUTINE', 'p_defined_balance_id');
9388: fnd_message.raise_error;
9389: --
9390: end if;
9391: --
9392: end if;
9395: hr_api.mandatory_arg_error(l_proc, 'p_report_sequence', p_report_sequence);
9396: --
9397: if nvl(p_null_valid,'N') not in ('Y','N') then
9398: --
9399: fnd_message.set_name('FND','SYSTEM-INVALID ARGS');
9400: fnd_message.set_token('ROUTINE', 'p_null_valid');
9401: fnd_message.raise_error;
9402: --
9403: end if;
9396: --
9397: if nvl(p_null_valid,'N') not in ('Y','N') then
9398: --
9399: fnd_message.set_name('FND','SYSTEM-INVALID ARGS');
9400: fnd_message.set_token('ROUTINE', 'p_null_valid');
9401: fnd_message.raise_error;
9402: --
9403: end if;
9404: --
9397: if nvl(p_null_valid,'N') not in ('Y','N') then
9398: --
9399: fnd_message.set_name('FND','SYSTEM-INVALID ARGS');
9400: fnd_message.set_token('ROUTINE', 'p_null_valid');
9401: fnd_message.raise_error;
9402: --
9403: end if;
9404: --
9405: open csr_duplicate;
9407: close csr_duplicate;
9408: --
9409: if l_org_information_id is not null then
9410: --
9411: fnd_message.set_name('PAY','PER_7901_SYS_DUPLICATE_RECORDS');
9412: fnd_message.raise_error;
9413: --
9414: end if;
9415: --
9408: --
9409: if l_org_information_id is not null then
9410: --
9411: fnd_message.set_name('PAY','PER_7901_SYS_DUPLICATE_RECORDS');
9412: fnd_message.raise_error;
9413: --
9414: end if;
9415: --
9416: if g_debug then