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.PAY_QPQ_API dependencies on HR_API

Line 422: hr_api.mandatory_arg_error

418: hr_utility.set_location('Entering:'|| v_proc, 5);
419: --
420: -- Check mandatory parameters have been set
421: --
422: hr_api.mandatory_arg_error
423: (p_api_name => v_proc
424: ,p_argument => 'assignment_id'
425: ,p_argument_value => p_assignment_id
426: );

Line 470: hr_api.mandatory_arg_error

466: hr_utility.set_location('Entering:'|| v_proc, 5);
467: --
468: -- Check mandatory parameters have been set
469: --
470: hr_api.mandatory_arg_error
471: (p_api_name => v_proc
472: ,p_argument => 'assignment_id'
473: ,p_argument_value => p_assignment_id
474: );

Line 475: hr_api.mandatory_arg_error

471: (p_api_name => v_proc
472: ,p_argument => 'assignment_id'
473: ,p_argument_value => p_assignment_id
474: );
475: hr_api.mandatory_arg_error
476: (p_api_name => v_proc
477: ,p_argument => 'new_date'
478: ,p_argument_value => p_new_date
479: );

Line 1016: hr_api.mandatory_arg_error

1012: hr_utility.set_location('Entering:'|| v_proc, 5);
1013: --
1014: -- Check mandatory arguments have been set
1015: --
1016: hr_api.mandatory_arg_error
1017: (p_api_name => v_proc
1018: ,p_argument => 'effective_date'
1019: ,p_argument_value => p_effective_date
1020: );

Line 1021: hr_api.mandatory_arg_error

1017: (p_api_name => v_proc
1018: ,p_argument => 'effective_date'
1019: ,p_argument_value => p_effective_date
1020: );
1021: hr_api.mandatory_arg_error
1022: (p_api_name => v_proc
1023: ,p_argument => 'assignment_id'
1024: ,p_argument_value => p_assignment_id
1025: );

Line 1026: hr_api.mandatory_arg_error

1022: (p_api_name => v_proc
1023: ,p_argument => 'assignment_id'
1024: ,p_argument_value => p_assignment_id
1025: );
1026: hr_api.mandatory_arg_error
1027: (p_api_name => v_proc
1028: ,p_argument => 'legislation_code'
1029: ,p_argument_value => p_legislation_code
1030: );

Line 1206: hr_api.mandatory_arg_error

1202: hr_utility.set_location('Entering:'|| v_proc, 5);
1203: --
1204: -- Check mandatory parameters have been set
1205: --
1206: hr_api.mandatory_arg_error
1207: (p_api_name => v_proc
1208: ,p_argument => 'date_earned'
1209: ,p_argument_value => p_date_earned
1210: );

Line 1211: hr_api.mandatory_arg_error

1207: (p_api_name => v_proc
1208: ,p_argument => 'date_earned'
1209: ,p_argument_value => p_date_earned
1210: );
1211: hr_api.mandatory_arg_error
1212: (p_api_name => v_proc
1213: ,p_argument => 'assignment_id'
1214: ,p_argument_value => p_assignment_id
1215: );

Line 1216: hr_api.mandatory_arg_error

1212: (p_api_name => v_proc
1213: ,p_argument => 'assignment_id'
1214: ,p_argument_value => p_assignment_id
1215: );
1216: hr_api.mandatory_arg_error
1217: (p_api_name => v_proc
1218: ,p_argument => 'legislation_code'
1219: ,p_argument_value => p_legislation_code
1220: );

Line 1222: hr_api.mandatory_arg_error

1218: ,p_argument => 'legislation_code'
1219: ,p_argument_value => p_legislation_code
1220: );
1221: if p_legislation_code = 'GB' then
1222: hr_api.mandatory_arg_error
1223: (p_api_name => v_proc
1224: ,p_argument => 'effective_date'
1225: ,p_argument_value => p_effective_date
1226: );

Line 1838: -- The exception hr_api.check_integrity_violated,

1834: -- {Start Of Comments}
1835: --
1836: -- Description:
1837: -- This procedure is called when a constraint has been violated (i.e.
1838: -- The exception hr_api.check_integrity_violated,
1839: -- hr_api.parent_integrity_violated or hr_api.child_integrity_violated has
1840: -- been raised).
1841: -- The exceptions can only be raised as follows:
1842: -- 1) A check constraint can only be violated during an INSERT or UPDATE

Line 1839: -- hr_api.parent_integrity_violated or hr_api.child_integrity_violated has

1835: --
1836: -- Description:
1837: -- This procedure is called when a constraint has been violated (i.e.
1838: -- The exception hr_api.check_integrity_violated,
1839: -- hr_api.parent_integrity_violated or hr_api.child_integrity_violated has
1840: -- been raised).
1841: -- The exceptions can only be raised as follows:
1842: -- 1) A check constraint can only be violated during an INSERT or UPDATE
1843: -- dml operation.

Line 1850: -- Either hr_api.check_integrity_violated, hr_api.parent_integrity_violated

1846: -- 3) A child integrity constraint can only be violated during an
1847: -- DELETE dml operation.
1848: --
1849: -- Pre Conditions:
1850: -- Either hr_api.check_integrity_violated, hr_api.parent_integrity_violated
1851: -- or hr_api.child_integrity_violated has been raised with the subsequent
1852: -- stripping of the constraint name from the generated error message text.
1853: --
1854: -- In Arguments:

Line 1851: -- or hr_api.child_integrity_violated has been raised with the subsequent

1847: -- DELETE dml operation.
1848: --
1849: -- Pre Conditions:
1850: -- Either hr_api.check_integrity_violated, hr_api.parent_integrity_violated
1851: -- or hr_api.child_integrity_violated has been raised with the subsequent
1852: -- stripping of the constraint name from the generated error message text.
1853: --
1854: -- In Arguments:
1855: -- p_constraint_name is in upper format and is just the constraint name

Line 1983: hr_api.mandatory_arg_error

1979: -- action_status because they are all set at by the pre-insert procedure.
1980: -- Consolidation_set_id is has been added to this procedure because it is
1981: -- mandatory for QuickPay Runs.
1982: --
1983: hr_api.mandatory_arg_error
1984: (p_api_name => v_proc
1985: ,p_argument => 'business_group_id'
1986: ,p_argument_value => p_rec.business_group_id
1987: );

Line 1988: hr_api.mandatory_arg_error

1984: (p_api_name => v_proc
1985: ,p_argument => 'business_group_id'
1986: ,p_argument_value => p_rec.business_group_id
1987: );
1988: hr_api.mandatory_arg_error
1989: (p_api_name => v_proc
1990: ,p_argument => 'effective_date'
1991: ,p_argument_value => p_rec.effective_date
1992: );

Line 1993: hr_api.mandatory_arg_error

1989: (p_api_name => v_proc
1990: ,p_argument => 'effective_date'
1991: ,p_argument_value => p_rec.effective_date
1992: );
1993: hr_api.mandatory_arg_error
1994: (p_api_name => v_proc
1995: ,p_argument => 'consolidation_set_id'
1996: ,p_argument_value => p_rec.consolidation_set_id
1997: );

Line 2037: if nvl(p_rec.business_group_id, hr_api.g_number) <>

2033: v_argument varchar2(30);
2034: --
2035: Begin
2036: hr_utility.set_location('Entering:'||v_proc, 5);
2037: if nvl(p_rec.business_group_id, hr_api.g_number) <>
2038: nvl(g_old_rec.business_group_id, hr_api.g_number) then
2039: v_argument := 'business_group_id';
2040: raise hr_api.argument_changed;
2041: end if;

Line 2038: nvl(g_old_rec.business_group_id, hr_api.g_number) then

2034: --
2035: Begin
2036: hr_utility.set_location('Entering:'||v_proc, 5);
2037: if nvl(p_rec.business_group_id, hr_api.g_number) <>
2038: nvl(g_old_rec.business_group_id, hr_api.g_number) then
2039: v_argument := 'business_group_id';
2040: raise hr_api.argument_changed;
2041: end if;
2042: hr_utility.set_location(v_proc, 6);

Line 2040: raise hr_api.argument_changed;

2036: hr_utility.set_location('Entering:'||v_proc, 5);
2037: if nvl(p_rec.business_group_id, hr_api.g_number) <>
2038: nvl(g_old_rec.business_group_id, hr_api.g_number) then
2039: v_argument := 'business_group_id';
2040: raise hr_api.argument_changed;
2041: end if;
2042: hr_utility.set_location(v_proc, 6);
2043: --
2044: if nvl(p_rec.effective_date, hr_api.g_date) <>

Line 2044: if nvl(p_rec.effective_date, hr_api.g_date) <>

2040: raise hr_api.argument_changed;
2041: end if;
2042: hr_utility.set_location(v_proc, 6);
2043: --
2044: if nvl(p_rec.effective_date, hr_api.g_date) <>
2045: nvl(g_old_rec.effective_date, hr_api.g_date) then
2046: v_argument := 'effective_date';
2047: raise hr_api.argument_changed;
2048: end if;

Line 2045: nvl(g_old_rec.effective_date, hr_api.g_date) then

2041: end if;
2042: hr_utility.set_location(v_proc, 6);
2043: --
2044: if nvl(p_rec.effective_date, hr_api.g_date) <>
2045: nvl(g_old_rec.effective_date, hr_api.g_date) then
2046: v_argument := 'effective_date';
2047: raise hr_api.argument_changed;
2048: end if;
2049: hr_utility.set_location(v_proc, 7);

Line 2047: raise hr_api.argument_changed;

2043: --
2044: if nvl(p_rec.effective_date, hr_api.g_date) <>
2045: nvl(g_old_rec.effective_date, hr_api.g_date) then
2046: v_argument := 'effective_date';
2047: raise hr_api.argument_changed;
2048: end if;
2049: hr_utility.set_location(v_proc, 7);
2050: --
2051: if nvl(p_rec.current_task, hr_api.g_varchar2) <>

Line 2051: if nvl(p_rec.current_task, hr_api.g_varchar2) <>

2047: raise hr_api.argument_changed;
2048: end if;
2049: hr_utility.set_location(v_proc, 7);
2050: --
2051: if nvl(p_rec.current_task, hr_api.g_varchar2) <>
2052: nvl(g_old_rec.current_task, hr_api.g_varchar2) then
2053: v_argument := 'current_task';
2054: raise hr_api.argument_changed;
2055: end if;

Line 2052: nvl(g_old_rec.current_task, hr_api.g_varchar2) then

2048: end if;
2049: hr_utility.set_location(v_proc, 7);
2050: --
2051: if nvl(p_rec.current_task, hr_api.g_varchar2) <>
2052: nvl(g_old_rec.current_task, hr_api.g_varchar2) then
2053: v_argument := 'current_task';
2054: raise hr_api.argument_changed;
2055: end if;
2056: hr_utility.set_location(v_proc, 8);

Line 2054: raise hr_api.argument_changed;

2050: --
2051: if nvl(p_rec.current_task, hr_api.g_varchar2) <>
2052: nvl(g_old_rec.current_task, hr_api.g_varchar2) then
2053: v_argument := 'current_task';
2054: raise hr_api.argument_changed;
2055: end if;
2056: hr_utility.set_location(v_proc, 8);
2057: --
2058: if nvl(p_rec.date_earned, hr_api.g_date) <>

Line 2058: if nvl(p_rec.date_earned, hr_api.g_date) <>

2054: raise hr_api.argument_changed;
2055: end if;
2056: hr_utility.set_location(v_proc, 8);
2057: --
2058: if nvl(p_rec.date_earned, hr_api.g_date) <>
2059: nvl(g_old_rec.date_earned, hr_api.g_date) then
2060: v_argument := 'date_earned';
2061: raise hr_api.argument_changed;
2062: end if;

Line 2059: nvl(g_old_rec.date_earned, hr_api.g_date) then

2055: end if;
2056: hr_utility.set_location(v_proc, 8);
2057: --
2058: if nvl(p_rec.date_earned, hr_api.g_date) <>
2059: nvl(g_old_rec.date_earned, hr_api.g_date) then
2060: v_argument := 'date_earned';
2061: raise hr_api.argument_changed;
2062: end if;
2063: --

Line 2061: raise hr_api.argument_changed;

2057: --
2058: if nvl(p_rec.date_earned, hr_api.g_date) <>
2059: nvl(g_old_rec.date_earned, hr_api.g_date) then
2060: v_argument := 'date_earned';
2061: raise hr_api.argument_changed;
2062: end if;
2063: --
2064: hr_utility.set_location(' Leaving:'||v_proc, 10);
2065: Exception

Line 2066: When hr_api.argument_changed Then

2062: end if;
2063: --
2064: hr_utility.set_location(' Leaving:'||v_proc, 10);
2065: Exception
2066: When hr_api.argument_changed Then
2067: --
2068: -- A non updatetable attribute has been changed therefore we
2069: -- must report this error
2070: --

Line 2071: hr_api.argument_changed_error

2067: --
2068: -- A non updatetable attribute has been changed therefore we
2069: -- must report this error
2070: --
2071: hr_api.argument_changed_error
2072: (p_api_name => v_proc
2073: ,p_argument => v_argument
2074: );
2075: --

Line 2487: When hr_api.check_integrity_violated Then

2483: g_api_dml := false; -- Unset the api dml status
2484: --
2485: hr_utility.set_location(' Leaving:'||v_proc, 10);
2486: Exception
2487: When hr_api.check_integrity_violated Then
2488: --
2489: -- A check constraint has been violated
2490: --
2491: -- Unset the api dml status

Line 2494: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

2490: --
2491: -- Unset the api dml status
2492: g_api_dml := false;
2493: constraint_error
2494: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2495: When hr_api.parent_integrity_violated then
2496: --
2497: -- Parent integrity has been violated
2498: --

Line 2495: When hr_api.parent_integrity_violated then

2491: -- Unset the api dml status
2492: g_api_dml := false;
2493: constraint_error
2494: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2495: When hr_api.parent_integrity_violated then
2496: --
2497: -- Parent integrity has been violated
2498: --
2499: -- Unset the api dml status

Line 2502: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

2498: --
2499: -- Unset the api dml status
2500: g_api_dml := false;
2501: constraint_error
2502: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2503: When hr_api.unique_integrity_violated Then
2504: --
2505: -- Unique integrity has been violated
2506: --

Line 2503: When hr_api.unique_integrity_violated Then

2499: -- Unset the api dml status
2500: g_api_dml := false;
2501: constraint_error
2502: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2503: When hr_api.unique_integrity_violated Then
2504: --
2505: -- Unique integrity has been violated
2506: --
2507: g_api_dml := false; -- Unset the api dml status

Line 2509: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

2505: -- Unique integrity has been violated
2506: --
2507: g_api_dml := false; -- Unset the api dml status
2508: constraint_error
2509: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2510: When Others Then
2511: --
2512: -- Unset the api dml status
2513: --

Line 2596: When hr_api.check_integrity_violated Then

2592: --
2593: hr_utility.set_location(' Leaving:'||v_proc, 10);
2594: --
2595: Exception
2596: When hr_api.check_integrity_violated Then
2597: --
2598: -- A check constraint has been violated
2599: --
2600: -- Unset the api dml status

Line 2603: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

2599: --
2600: -- Unset the api dml status
2601: g_api_dml := false;
2602: constraint_error
2603: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2604: When hr_api.parent_integrity_violated then
2605: --
2606: -- Parent integrity has been violated
2607: --

Line 2604: When hr_api.parent_integrity_violated then

2600: -- Unset the api dml status
2601: g_api_dml := false;
2602: constraint_error
2603: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2604: When hr_api.parent_integrity_violated then
2605: --
2606: -- Parent integrity has been violated
2607: --
2608: -- Unset the api dml status

Line 2611: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

2607: --
2608: -- Unset the api dml status
2609: g_api_dml := false;
2610: constraint_error
2611: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2612: When hr_api.unique_integrity_violated Then
2613: --
2614: -- Unique integrity has been violated
2615: --

Line 2612: When hr_api.unique_integrity_violated Then

2608: -- Unset the api dml status
2609: g_api_dml := false;
2610: constraint_error
2611: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2612: When hr_api.unique_integrity_violated Then
2613: --
2614: -- Unique integrity has been violated
2615: --
2616: g_api_dml := false; -- Unset the api dml status

Line 2618: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

2614: -- Unique integrity has been violated
2615: --
2616: g_api_dml := false; -- Unset the api dml status
2617: constraint_error
2618: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2619: When Others Then
2620: --
2621: -- Unset the api dml status
2622: --

Line 2689: When hr_api.child_integrity_violated then

2685: --
2686: hr_utility.set_location(' Leaving:'||v_proc, 10);
2687: --
2688: Exception
2689: When hr_api.child_integrity_violated then
2690: --
2691: -- Child integrity has been violated
2692: --
2693: -- Unset the api dml status

Line 2696: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

2692: --
2693: -- Unset the api dml status
2694: g_api_dml := false;
2695: constraint_error
2696: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2697: When Others Then
2698: --
2699: -- Unset the api dml status
2700: --

Line 2816: hr_api.mandatory_arg_error

2812: hr_utility.set_location('Entering:'|| v_proc, 5);
2813: --
2814: -- Check the mandatory args have been set
2815: --
2816: hr_api.mandatory_arg_error
2817: (p_api_name => v_proc
2818: ,p_argument => 'payroll_action_id'
2819: ,p_argument_value => p_payroll_action_id
2820: );

Line 2821: hr_api.mandatory_arg_error

2817: (p_api_name => v_proc
2818: ,p_argument => 'payroll_action_id'
2819: ,p_argument_value => p_payroll_action_id
2820: );
2821: hr_api.mandatory_arg_error
2822: (p_api_name => v_proc
2823: ,p_argument => 'p_object_version_number'
2824: ,p_argument_value => p_p_object_version_number
2825: );

Line 2826: hr_api.mandatory_arg_error

2822: (p_api_name => v_proc
2823: ,p_argument => 'p_object_version_number'
2824: ,p_argument_value => p_p_object_version_number
2825: );
2826: hr_api.mandatory_arg_error
2827: (p_api_name => v_proc
2828: ,p_argument => 'a_object_version_number'
2829: ,p_argument_value => p_a_object_version_number
2830: );

Line 2882: When HR_api.Object_Locked then

2878: --
2879: -- We need to trap the ORA LOCK exception
2880: --
2881: Exception
2882: When HR_api.Object_Locked then
2883: --
2884: -- The object is locked therefore we need to supply a meaningful
2885: -- error message.
2886: --

Line 3046: If (p_rec.payroll_action_id = hr_api.g_number) then

3042: -- p_rec plsql record structure
3043: -- to see if a system default is being used. If a system default
3044: -- is being used then we must set to the 'current' argument value.
3045: --
3046: If (p_rec.payroll_action_id = hr_api.g_number) then
3047: p_rec.payroll_action_id := g_old_rec.payroll_action_id;
3048: End If;
3049: If (p_rec.business_group_id = hr_api.g_number) then
3050: p_rec.business_group_id := g_old_rec.business_group_id;

Line 3049: If (p_rec.business_group_id = hr_api.g_number) then

3045: --
3046: If (p_rec.payroll_action_id = hr_api.g_number) then
3047: p_rec.payroll_action_id := g_old_rec.payroll_action_id;
3048: End If;
3049: If (p_rec.business_group_id = hr_api.g_number) then
3050: p_rec.business_group_id := g_old_rec.business_group_id;
3051: End If;
3052: If (p_rec.consolidation_set_id = hr_api.g_number) then
3053: p_rec.consolidation_set_id := g_old_rec.consolidation_set_id;

Line 3052: If (p_rec.consolidation_set_id = hr_api.g_number) then

3048: End If;
3049: If (p_rec.business_group_id = hr_api.g_number) then
3050: p_rec.business_group_id := g_old_rec.business_group_id;
3051: End If;
3052: If (p_rec.consolidation_set_id = hr_api.g_number) then
3053: p_rec.consolidation_set_id := g_old_rec.consolidation_set_id;
3054: End If;
3055: If (p_rec.action_status = hr_api.g_varchar2) then
3056: p_rec.action_status := g_old_rec.action_status;

Line 3055: If (p_rec.action_status = hr_api.g_varchar2) then

3051: End If;
3052: If (p_rec.consolidation_set_id = hr_api.g_number) then
3053: p_rec.consolidation_set_id := g_old_rec.consolidation_set_id;
3054: End If;
3055: If (p_rec.action_status = hr_api.g_varchar2) then
3056: p_rec.action_status := g_old_rec.action_status;
3057: End If;
3058: If (p_rec.effective_date = hr_api.g_date) then
3059: p_rec.effective_date := g_old_rec.effective_date;

Line 3058: If (p_rec.effective_date = hr_api.g_date) then

3054: End If;
3055: If (p_rec.action_status = hr_api.g_varchar2) then
3056: p_rec.action_status := g_old_rec.action_status;
3057: End If;
3058: If (p_rec.effective_date = hr_api.g_date) then
3059: p_rec.effective_date := g_old_rec.effective_date;
3060: End If;
3061: If (p_rec.comments = hr_api.g_varchar2) then
3062: p_rec.comments := g_old_rec.comments;

Line 3061: If (p_rec.comments = hr_api.g_varchar2) then

3057: End If;
3058: If (p_rec.effective_date = hr_api.g_date) then
3059: p_rec.effective_date := g_old_rec.effective_date;
3060: End If;
3061: If (p_rec.comments = hr_api.g_varchar2) then
3062: p_rec.comments := g_old_rec.comments;
3063: End If;
3064: If (p_rec.current_task = hr_api.g_varchar2) then
3065: p_rec.current_task := g_old_rec.current_task;

Line 3064: If (p_rec.current_task = hr_api.g_varchar2) then

3060: End If;
3061: If (p_rec.comments = hr_api.g_varchar2) then
3062: p_rec.comments := g_old_rec.comments;
3063: End If;
3064: If (p_rec.current_task = hr_api.g_varchar2) then
3065: p_rec.current_task := g_old_rec.current_task;
3066: End If;
3067: If (p_rec.legislative_parameters = hr_api.g_varchar2) then
3068: p_rec.legislative_parameters := g_old_rec.legislative_parameters;

Line 3067: If (p_rec.legislative_parameters = hr_api.g_varchar2) then

3063: End If;
3064: If (p_rec.current_task = hr_api.g_varchar2) then
3065: p_rec.current_task := g_old_rec.current_task;
3066: End If;
3067: If (p_rec.legislative_parameters = hr_api.g_varchar2) then
3068: p_rec.legislative_parameters := g_old_rec.legislative_parameters;
3069: End If;
3070: If (p_rec.date_earned = hr_api.g_date) then
3071: p_rec.date_earned := g_old_rec.date_earned;

Line 3070: If (p_rec.date_earned = hr_api.g_date) then

3066: End If;
3067: If (p_rec.legislative_parameters = hr_api.g_varchar2) then
3068: p_rec.legislative_parameters := g_old_rec.legislative_parameters;
3069: End If;
3070: If (p_rec.date_earned = hr_api.g_date) then
3071: p_rec.date_earned := g_old_rec.date_earned;
3072: End If;
3073: If (p_rec.pay_advice_date = hr_api.g_date) then
3074: p_rec.pay_advice_date := g_old_rec.pay_advice_date;

Line 3073: If (p_rec.pay_advice_date = hr_api.g_date) then

3069: End If;
3070: If (p_rec.date_earned = hr_api.g_date) then
3071: p_rec.date_earned := g_old_rec.date_earned;
3072: End If;
3073: If (p_rec.pay_advice_date = hr_api.g_date) then
3074: p_rec.pay_advice_date := g_old_rec.pay_advice_date;
3075: End If;
3076: If (p_rec.pay_advice_message = hr_api.g_varchar2) then
3077: p_rec.pay_advice_message := g_old_rec.pay_advice_message;

Line 3076: If (p_rec.pay_advice_message = hr_api.g_varchar2) then

3072: End If;
3073: If (p_rec.pay_advice_date = hr_api.g_date) then
3074: p_rec.pay_advice_date := g_old_rec.pay_advice_date;
3075: End If;
3076: If (p_rec.pay_advice_message = hr_api.g_varchar2) then
3077: p_rec.pay_advice_message := g_old_rec.pay_advice_message;
3078: End If;
3079: If (p_rec.object_version_number = hr_api.g_number) then
3080: p_rec.object_version_number := g_old_rec.object_version_number;

Line 3079: If (p_rec.object_version_number = hr_api.g_number) then

3075: End If;
3076: If (p_rec.pay_advice_message = hr_api.g_varchar2) then
3077: p_rec.pay_advice_message := g_old_rec.pay_advice_message;
3078: End If;
3079: If (p_rec.object_version_number = hr_api.g_number) then
3080: p_rec.object_version_number := g_old_rec.object_version_number;
3081: End If;
3082: If (p_rec.run_type_id = hr_api.g_number) then
3083: p_rec.run_type_id := g_old_rec.run_type_id;

Line 3082: If (p_rec.run_type_id = hr_api.g_number) then

3078: End If;
3079: If (p_rec.object_version_number = hr_api.g_number) then
3080: p_rec.object_version_number := g_old_rec.object_version_number;
3081: End If;
3082: If (p_rec.run_type_id = hr_api.g_number) then
3083: p_rec.run_type_id := g_old_rec.run_type_id;
3084: End If;
3085: --
3086: -- Return the plsql record structure.

Line 3153: hr_api.validate_bus_grp_id(p_rec.business_group_id);

3149: hr_utility.set_location(v_proc, 6);
3150: --
3151: -- Validate business group id
3152: --
3153: hr_api.validate_bus_grp_id(p_rec.business_group_id);
3154: hr_utility.set_location(v_proc, 7);
3155: --
3156: -- Validate the assignment is in the same business group
3157: -- (Some other validate checks are done when the assignment action is

Line 3319: if nvl(p_rec.run_type_id, hr_api.g_number) <>

3315: end if;
3316: --
3317: -- If run type has changed, validate the new value is correct.
3318: --
3319: if nvl(p_rec.run_type_id, hr_api.g_number) <>
3320: nvl(g_old_rec.run_type_id, hr_api.g_number) then
3321: --
3322: -- Find out the legislation code for the current business group.
3323: v_legislation_code := get_legislation_code(p_rec.business_group_id);

Line 3320: nvl(g_old_rec.run_type_id, hr_api.g_number) then

3316: --
3317: -- If run type has changed, validate the new value is correct.
3318: --
3319: if nvl(p_rec.run_type_id, hr_api.g_number) <>
3320: nvl(g_old_rec.run_type_id, hr_api.g_number) then
3321: --
3322: -- Find out the legislation code for the current business group.
3323: v_legislation_code := get_legislation_code(p_rec.business_group_id);
3324: --

Line 3482: raise hr_api.validate_enabled;

3478: --
3479: -- If we are validating then raise the Validate_Enabled exception
3480: --
3481: if p_validate then
3482: raise hr_api.validate_enabled;
3483: end if;
3484: --
3485: hr_utility.set_location(' Leaving:'||v_proc, 10);
3486: exception

Line 3487: when hr_api.validate_enabled then

3483: end if;
3484: --
3485: hr_utility.set_location(' Leaving:'||v_proc, 10);
3486: exception
3487: when hr_api.validate_enabled then
3488: --
3489: -- As the Validate_Enabled exception has been raised
3490: -- we must rollback to the savepoint
3491: --

Line 3626: raise hr_api.validate_enabled;

3622: --
3623: -- If we are validating then raise the Validate_Enabled exception
3624: --
3625: if p_validate then
3626: raise hr_api.validate_enabled;
3627: end if;
3628: --
3629: hr_utility.set_location(' Leaving:'||v_proc, 10);
3630: exception

Line 3631: when hr_api.validate_enabled Then

3627: end if;
3628: --
3629: hr_utility.set_location(' Leaving:'||v_proc, 10);
3630: exception
3631: when hr_api.validate_enabled Then
3632: --
3633: -- As the Validate_Enabled exception has been raised
3634: -- we must rollback to the savepoint
3635: --

Line 3645: ,p_consolidation_set_id in number default hr_api.g_number

3641: -- ----------------------------------------------------------------------------
3642: --
3643: procedure upd
3644: (p_payroll_action_id in number
3645: ,p_consolidation_set_id in number default hr_api.g_number
3646: ,p_legislative_parameters in varchar2 default hr_api.g_varchar2
3647: ,p_run_type_id in number default hr_api.g_number
3648: ,p_pay_advice_date in date default hr_api.g_date
3649: ,p_pay_advice_message in varchar2 default hr_api.g_varchar2

Line 3646: ,p_legislative_parameters in varchar2 default hr_api.g_varchar2

3642: --
3643: procedure upd
3644: (p_payroll_action_id in number
3645: ,p_consolidation_set_id in number default hr_api.g_number
3646: ,p_legislative_parameters in varchar2 default hr_api.g_varchar2
3647: ,p_run_type_id in number default hr_api.g_number
3648: ,p_pay_advice_date in date default hr_api.g_date
3649: ,p_pay_advice_message in varchar2 default hr_api.g_varchar2
3650: ,p_action_status in varchar2 default hr_api.g_varchar2

Line 3647: ,p_run_type_id in number default hr_api.g_number

3643: procedure upd
3644: (p_payroll_action_id in number
3645: ,p_consolidation_set_id in number default hr_api.g_number
3646: ,p_legislative_parameters in varchar2 default hr_api.g_varchar2
3647: ,p_run_type_id in number default hr_api.g_number
3648: ,p_pay_advice_date in date default hr_api.g_date
3649: ,p_pay_advice_message in varchar2 default hr_api.g_varchar2
3650: ,p_action_status in varchar2 default hr_api.g_varchar2
3651: ,p_comments in varchar2 default hr_api.g_varchar2

Line 3648: ,p_pay_advice_date in date default hr_api.g_date

3644: (p_payroll_action_id in number
3645: ,p_consolidation_set_id in number default hr_api.g_number
3646: ,p_legislative_parameters in varchar2 default hr_api.g_varchar2
3647: ,p_run_type_id in number default hr_api.g_number
3648: ,p_pay_advice_date in date default hr_api.g_date
3649: ,p_pay_advice_message in varchar2 default hr_api.g_varchar2
3650: ,p_action_status in varchar2 default hr_api.g_varchar2
3651: ,p_comments in varchar2 default hr_api.g_varchar2
3652: ,p_assignment_action_id in number

Line 3649: ,p_pay_advice_message in varchar2 default hr_api.g_varchar2

3645: ,p_consolidation_set_id in number default hr_api.g_number
3646: ,p_legislative_parameters in varchar2 default hr_api.g_varchar2
3647: ,p_run_type_id in number default hr_api.g_number
3648: ,p_pay_advice_date in date default hr_api.g_date
3649: ,p_pay_advice_message in varchar2 default hr_api.g_varchar2
3650: ,p_action_status in varchar2 default hr_api.g_varchar2
3651: ,p_comments in varchar2 default hr_api.g_varchar2
3652: ,p_assignment_action_id in number
3653: ,p_p_object_version_number in out nocopy number

Line 3650: ,p_action_status in varchar2 default hr_api.g_varchar2

3646: ,p_legislative_parameters in varchar2 default hr_api.g_varchar2
3647: ,p_run_type_id in number default hr_api.g_number
3648: ,p_pay_advice_date in date default hr_api.g_date
3649: ,p_pay_advice_message in varchar2 default hr_api.g_varchar2
3650: ,p_action_status in varchar2 default hr_api.g_varchar2
3651: ,p_comments in varchar2 default hr_api.g_varchar2
3652: ,p_assignment_action_id in number
3653: ,p_p_object_version_number in out nocopy number
3654: ,p_a_object_version_number in number

Line 3651: ,p_comments in varchar2 default hr_api.g_varchar2

3647: ,p_run_type_id in number default hr_api.g_number
3648: ,p_pay_advice_date in date default hr_api.g_date
3649: ,p_pay_advice_message in varchar2 default hr_api.g_varchar2
3650: ,p_action_status in varchar2 default hr_api.g_varchar2
3651: ,p_comments in varchar2 default hr_api.g_varchar2
3652: ,p_assignment_action_id in number
3653: ,p_p_object_version_number in out nocopy number
3654: ,p_a_object_version_number in number
3655: ,p_validate in boolean default false

Line 3670: ,p_business_group_id => hr_api.g_number

3666: --
3667: v_rec :=
3668: convert_args
3669: (p_payroll_action_id => p_payroll_action_id
3670: ,p_business_group_id => hr_api.g_number
3671: ,p_consolidation_set_id => p_consolidation_set_id
3672: ,p_action_status => p_action_status
3673: ,p_effective_date => hr_api.g_date
3674: ,p_comments => p_comments

Line 3673: ,p_effective_date => hr_api.g_date

3669: (p_payroll_action_id => p_payroll_action_id
3670: ,p_business_group_id => hr_api.g_number
3671: ,p_consolidation_set_id => p_consolidation_set_id
3672: ,p_action_status => p_action_status
3673: ,p_effective_date => hr_api.g_date
3674: ,p_comments => p_comments
3675: ,p_current_task => hr_api.g_varchar2
3676: ,p_legislative_parameters => p_legislative_parameters
3677: ,p_run_type_id => p_run_type_id

Line 3675: ,p_current_task => hr_api.g_varchar2

3671: ,p_consolidation_set_id => p_consolidation_set_id
3672: ,p_action_status => p_action_status
3673: ,p_effective_date => hr_api.g_date
3674: ,p_comments => p_comments
3675: ,p_current_task => hr_api.g_varchar2
3676: ,p_legislative_parameters => p_legislative_parameters
3677: ,p_run_type_id => p_run_type_id
3678: ,p_date_earned => hr_api.g_date
3679: ,p_pay_advice_date => p_pay_advice_date

Line 3678: ,p_date_earned => hr_api.g_date

3674: ,p_comments => p_comments
3675: ,p_current_task => hr_api.g_varchar2
3676: ,p_legislative_parameters => p_legislative_parameters
3677: ,p_run_type_id => p_run_type_id
3678: ,p_date_earned => hr_api.g_date
3679: ,p_pay_advice_date => p_pay_advice_date
3680: ,p_pay_advice_message => p_pay_advice_message
3681: ,p_object_version_number => p_p_object_version_number
3682: );

Line 3751: raise hr_api.validate_enabled;

3747: --
3748: -- If we are validating then raise the Validate_Enabled exception
3749: --
3750: if p_validate then
3751: raise hr_api.validate_enabled;
3752: end if;
3753: --
3754: hr_utility.set_location(' Leaving:'||v_proc, 10);
3755: exception

Line 3756: when hr_api.validate_enabled Then

3752: end if;
3753: --
3754: hr_utility.set_location(' Leaving:'||v_proc, 10);
3755: exception
3756: when hr_api.validate_enabled Then
3757: --
3758: -- As the Validate_Enabled exception has been raised
3759: -- we must rollback to the savepoint
3760: --

Line 4129: hr_api.mandatory_arg_error

4125: hr_utility.set_location('Entering:'|| v_proc, 5);
4126: --
4127: -- Check mandatory parameters have been set
4128: --
4129: hr_api.mandatory_arg_error
4130: (p_api_name => v_proc
4131: ,p_argument => 'payroll_action_id'
4132: ,p_argument_value => p_payroll_action_id
4133: );

Line 4325: hr_api.mandatory_arg_error

4321: hr_utility.set_location('Entering:'|| v_proc, 5);
4322: --
4323: -- Check mandatory parameters have been set
4324: --
4325: hr_api.mandatory_arg_error
4326: (p_api_name => v_proc
4327: ,p_argument => 'payroll_action_id'
4328: ,p_argument_value => p_payroll_action_id
4329: );

Line 4506: hr_api.mandatory_arg_error

4502: hr_utility.set_location('Entering:'|| v_proc, 5);
4503: --
4504: -- Check mandatory parameters have been set
4505: --
4506: hr_api.mandatory_arg_error
4507: (p_api_name => v_proc
4508: ,p_argument => 'payroll_action_id'
4509: ,p_argument_value => p_payroll_action_id
4510: );