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 1216: hr_api.mandatory_arg_error

1212: hr_utility.set_location('Entering:'|| v_proc, 5);
1213: --
1214: -- Check mandatory parameters have been set
1215: --
1216: hr_api.mandatory_arg_error
1217: (p_api_name => v_proc
1218: ,p_argument => 'date_earned'
1219: ,p_argument_value => p_date_earned
1220: );

Line 1221: hr_api.mandatory_arg_error

1217: (p_api_name => v_proc
1218: ,p_argument => 'date_earned'
1219: ,p_argument_value => p_date_earned
1220: );
1221: hr_api.mandatory_arg_error
1222: (p_api_name => v_proc
1223: ,p_argument => 'assignment_id'
1224: ,p_argument_value => p_assignment_id
1225: );

Line 1226: hr_api.mandatory_arg_error

1222: (p_api_name => v_proc
1223: ,p_argument => 'assignment_id'
1224: ,p_argument_value => p_assignment_id
1225: );
1226: hr_api.mandatory_arg_error
1227: (p_api_name => v_proc
1228: ,p_argument => 'legislation_code'
1229: ,p_argument_value => p_legislation_code
1230: );

Line 1232: hr_api.mandatory_arg_error

1228: ,p_argument => 'legislation_code'
1229: ,p_argument_value => p_legislation_code
1230: );
1231: if p_legislation_code = 'GB' then
1232: hr_api.mandatory_arg_error
1233: (p_api_name => v_proc
1234: ,p_argument => 'effective_date'
1235: ,p_argument_value => p_effective_date
1236: );

Line 1857: -- The exception hr_api.check_integrity_violated,

1853: -- {Start Of Comments}
1854: --
1855: -- Description:
1856: -- This procedure is called when a constraint has been violated (i.e.
1857: -- The exception hr_api.check_integrity_violated,
1858: -- hr_api.parent_integrity_violated or hr_api.child_integrity_violated has
1859: -- been raised).
1860: -- The exceptions can only be raised as follows:
1861: -- 1) A check constraint can only be violated during an INSERT or UPDATE

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

1854: --
1855: -- Description:
1856: -- This procedure is called when a constraint has been violated (i.e.
1857: -- The exception hr_api.check_integrity_violated,
1858: -- hr_api.parent_integrity_violated or hr_api.child_integrity_violated has
1859: -- been raised).
1860: -- The exceptions can only be raised as follows:
1861: -- 1) A check constraint can only be violated during an INSERT or UPDATE
1862: -- dml operation.

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

1865: -- 3) A child integrity constraint can only be violated during an
1866: -- DELETE dml operation.
1867: --
1868: -- Pre Conditions:
1869: -- Either hr_api.check_integrity_violated, hr_api.parent_integrity_violated
1870: -- or hr_api.child_integrity_violated has been raised with the subsequent
1871: -- stripping of the constraint name from the generated error message text.
1872: --
1873: -- In Arguments:

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

1866: -- DELETE dml operation.
1867: --
1868: -- Pre Conditions:
1869: -- Either hr_api.check_integrity_violated, hr_api.parent_integrity_violated
1870: -- or hr_api.child_integrity_violated has been raised with the subsequent
1871: -- stripping of the constraint name from the generated error message text.
1872: --
1873: -- In Arguments:
1874: -- p_constraint_name is in upper format and is just the constraint name

Line 2002: hr_api.mandatory_arg_error

1998: -- action_status because they are all set at by the pre-insert procedure.
1999: -- Consolidation_set_id is has been added to this procedure because it is
2000: -- mandatory for QuickPay Runs.
2001: --
2002: hr_api.mandatory_arg_error
2003: (p_api_name => v_proc
2004: ,p_argument => 'business_group_id'
2005: ,p_argument_value => p_rec.business_group_id
2006: );

Line 2007: hr_api.mandatory_arg_error

2003: (p_api_name => v_proc
2004: ,p_argument => 'business_group_id'
2005: ,p_argument_value => p_rec.business_group_id
2006: );
2007: hr_api.mandatory_arg_error
2008: (p_api_name => v_proc
2009: ,p_argument => 'effective_date'
2010: ,p_argument_value => p_rec.effective_date
2011: );

Line 2012: hr_api.mandatory_arg_error

2008: (p_api_name => v_proc
2009: ,p_argument => 'effective_date'
2010: ,p_argument_value => p_rec.effective_date
2011: );
2012: hr_api.mandatory_arg_error
2013: (p_api_name => v_proc
2014: ,p_argument => 'consolidation_set_id'
2015: ,p_argument_value => p_rec.consolidation_set_id
2016: );

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

2052: v_argument varchar2(30);
2053: --
2054: Begin
2055: hr_utility.set_location('Entering:'||v_proc, 5);
2056: if nvl(p_rec.business_group_id, hr_api.g_number) <>
2057: nvl(g_old_rec.business_group_id, hr_api.g_number) then
2058: v_argument := 'business_group_id';
2059: raise hr_api.argument_changed;
2060: end if;

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

2053: --
2054: Begin
2055: hr_utility.set_location('Entering:'||v_proc, 5);
2056: if nvl(p_rec.business_group_id, hr_api.g_number) <>
2057: nvl(g_old_rec.business_group_id, hr_api.g_number) then
2058: v_argument := 'business_group_id';
2059: raise hr_api.argument_changed;
2060: end if;
2061: hr_utility.set_location(v_proc, 6);

Line 2059: raise hr_api.argument_changed;

2055: hr_utility.set_location('Entering:'||v_proc, 5);
2056: if nvl(p_rec.business_group_id, hr_api.g_number) <>
2057: nvl(g_old_rec.business_group_id, hr_api.g_number) then
2058: v_argument := 'business_group_id';
2059: raise hr_api.argument_changed;
2060: end if;
2061: hr_utility.set_location(v_proc, 6);
2062: --
2063: if nvl(p_rec.effective_date, hr_api.g_date) <>

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

2059: raise hr_api.argument_changed;
2060: end if;
2061: hr_utility.set_location(v_proc, 6);
2062: --
2063: if nvl(p_rec.effective_date, hr_api.g_date) <>
2064: nvl(g_old_rec.effective_date, hr_api.g_date) then
2065: v_argument := 'effective_date';
2066: raise hr_api.argument_changed;
2067: end if;

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

2060: end if;
2061: hr_utility.set_location(v_proc, 6);
2062: --
2063: if nvl(p_rec.effective_date, hr_api.g_date) <>
2064: nvl(g_old_rec.effective_date, hr_api.g_date) then
2065: v_argument := 'effective_date';
2066: raise hr_api.argument_changed;
2067: end if;
2068: hr_utility.set_location(v_proc, 7);

Line 2066: raise hr_api.argument_changed;

2062: --
2063: if nvl(p_rec.effective_date, hr_api.g_date) <>
2064: nvl(g_old_rec.effective_date, hr_api.g_date) then
2065: v_argument := 'effective_date';
2066: raise hr_api.argument_changed;
2067: end if;
2068: hr_utility.set_location(v_proc, 7);
2069: --
2070: if nvl(p_rec.current_task, hr_api.g_varchar2) <>

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

2066: raise hr_api.argument_changed;
2067: end if;
2068: hr_utility.set_location(v_proc, 7);
2069: --
2070: if nvl(p_rec.current_task, hr_api.g_varchar2) <>
2071: nvl(g_old_rec.current_task, hr_api.g_varchar2) then
2072: v_argument := 'current_task';
2073: raise hr_api.argument_changed;
2074: end if;

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

2067: end if;
2068: hr_utility.set_location(v_proc, 7);
2069: --
2070: if nvl(p_rec.current_task, hr_api.g_varchar2) <>
2071: nvl(g_old_rec.current_task, hr_api.g_varchar2) then
2072: v_argument := 'current_task';
2073: raise hr_api.argument_changed;
2074: end if;
2075: hr_utility.set_location(v_proc, 8);

Line 2073: raise hr_api.argument_changed;

2069: --
2070: if nvl(p_rec.current_task, hr_api.g_varchar2) <>
2071: nvl(g_old_rec.current_task, hr_api.g_varchar2) then
2072: v_argument := 'current_task';
2073: raise hr_api.argument_changed;
2074: end if;
2075: hr_utility.set_location(v_proc, 8);
2076: --
2077: if nvl(p_rec.date_earned, hr_api.g_date) <>

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

2073: raise hr_api.argument_changed;
2074: end if;
2075: hr_utility.set_location(v_proc, 8);
2076: --
2077: if nvl(p_rec.date_earned, hr_api.g_date) <>
2078: nvl(g_old_rec.date_earned, hr_api.g_date) then
2079: v_argument := 'date_earned';
2080: raise hr_api.argument_changed;
2081: end if;

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

2074: end if;
2075: hr_utility.set_location(v_proc, 8);
2076: --
2077: if nvl(p_rec.date_earned, hr_api.g_date) <>
2078: nvl(g_old_rec.date_earned, hr_api.g_date) then
2079: v_argument := 'date_earned';
2080: raise hr_api.argument_changed;
2081: end if;
2082: --

Line 2080: raise hr_api.argument_changed;

2076: --
2077: if nvl(p_rec.date_earned, hr_api.g_date) <>
2078: nvl(g_old_rec.date_earned, hr_api.g_date) then
2079: v_argument := 'date_earned';
2080: raise hr_api.argument_changed;
2081: end if;
2082: --
2083: hr_utility.set_location(' Leaving:'||v_proc, 10);
2084: Exception

Line 2085: When hr_api.argument_changed Then

2081: end if;
2082: --
2083: hr_utility.set_location(' Leaving:'||v_proc, 10);
2084: Exception
2085: When hr_api.argument_changed Then
2086: --
2087: -- A non updatetable attribute has been changed therefore we
2088: -- must report this error
2089: --

Line 2090: hr_api.argument_changed_error

2086: --
2087: -- A non updatetable attribute has been changed therefore we
2088: -- must report this error
2089: --
2090: hr_api.argument_changed_error
2091: (p_api_name => v_proc
2092: ,p_argument => v_argument
2093: );
2094: --

Line 2506: When hr_api.check_integrity_violated Then

2502: g_api_dml := false; -- Unset the api dml status
2503: --
2504: hr_utility.set_location(' Leaving:'||v_proc, 10);
2505: Exception
2506: When hr_api.check_integrity_violated Then
2507: --
2508: -- A check constraint has been violated
2509: --
2510: -- Unset the api dml status

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

2509: --
2510: -- Unset the api dml status
2511: g_api_dml := false;
2512: constraint_error
2513: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2514: When hr_api.parent_integrity_violated then
2515: --
2516: -- Parent integrity has been violated
2517: --

Line 2514: When hr_api.parent_integrity_violated then

2510: -- Unset the api dml status
2511: g_api_dml := false;
2512: constraint_error
2513: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2514: When hr_api.parent_integrity_violated then
2515: --
2516: -- Parent integrity has been violated
2517: --
2518: -- Unset the api dml status

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

2517: --
2518: -- Unset the api dml status
2519: g_api_dml := false;
2520: constraint_error
2521: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2522: When hr_api.unique_integrity_violated Then
2523: --
2524: -- Unique integrity has been violated
2525: --

Line 2522: When hr_api.unique_integrity_violated Then

2518: -- Unset the api dml status
2519: g_api_dml := false;
2520: constraint_error
2521: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2522: When hr_api.unique_integrity_violated Then
2523: --
2524: -- Unique integrity has been violated
2525: --
2526: g_api_dml := false; -- Unset the api dml status

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

2524: -- Unique integrity has been violated
2525: --
2526: g_api_dml := false; -- Unset the api dml status
2527: constraint_error
2528: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2529: When Others Then
2530: --
2531: -- Unset the api dml status
2532: --

Line 2615: When hr_api.check_integrity_violated Then

2611: --
2612: hr_utility.set_location(' Leaving:'||v_proc, 10);
2613: --
2614: Exception
2615: When hr_api.check_integrity_violated Then
2616: --
2617: -- A check constraint has been violated
2618: --
2619: -- Unset the api dml status

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

2618: --
2619: -- Unset the api dml status
2620: g_api_dml := false;
2621: constraint_error
2622: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2623: When hr_api.parent_integrity_violated then
2624: --
2625: -- Parent integrity has been violated
2626: --

Line 2623: When hr_api.parent_integrity_violated then

2619: -- Unset the api dml status
2620: g_api_dml := false;
2621: constraint_error
2622: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2623: When hr_api.parent_integrity_violated then
2624: --
2625: -- Parent integrity has been violated
2626: --
2627: -- Unset the api dml status

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

2626: --
2627: -- Unset the api dml status
2628: g_api_dml := false;
2629: constraint_error
2630: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2631: When hr_api.unique_integrity_violated Then
2632: --
2633: -- Unique integrity has been violated
2634: --

Line 2631: When hr_api.unique_integrity_violated Then

2627: -- Unset the api dml status
2628: g_api_dml := false;
2629: constraint_error
2630: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2631: When hr_api.unique_integrity_violated Then
2632: --
2633: -- Unique integrity has been violated
2634: --
2635: g_api_dml := false; -- Unset the api dml status

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

2633: -- Unique integrity has been violated
2634: --
2635: g_api_dml := false; -- Unset the api dml status
2636: constraint_error
2637: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2638: When Others Then
2639: --
2640: -- Unset the api dml status
2641: --

Line 2708: When hr_api.child_integrity_violated then

2704: --
2705: hr_utility.set_location(' Leaving:'||v_proc, 10);
2706: --
2707: Exception
2708: When hr_api.child_integrity_violated then
2709: --
2710: -- Child integrity has been violated
2711: --
2712: -- Unset the api dml status

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

2711: --
2712: -- Unset the api dml status
2713: g_api_dml := false;
2714: constraint_error
2715: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2716: When Others Then
2717: --
2718: -- Unset the api dml status
2719: --

Line 2835: hr_api.mandatory_arg_error

2831: hr_utility.set_location('Entering:'|| v_proc, 5);
2832: --
2833: -- Check the mandatory args have been set
2834: --
2835: hr_api.mandatory_arg_error
2836: (p_api_name => v_proc
2837: ,p_argument => 'payroll_action_id'
2838: ,p_argument_value => p_payroll_action_id
2839: );

Line 2840: hr_api.mandatory_arg_error

2836: (p_api_name => v_proc
2837: ,p_argument => 'payroll_action_id'
2838: ,p_argument_value => p_payroll_action_id
2839: );
2840: hr_api.mandatory_arg_error
2841: (p_api_name => v_proc
2842: ,p_argument => 'p_object_version_number'
2843: ,p_argument_value => p_p_object_version_number
2844: );

Line 2845: hr_api.mandatory_arg_error

2841: (p_api_name => v_proc
2842: ,p_argument => 'p_object_version_number'
2843: ,p_argument_value => p_p_object_version_number
2844: );
2845: hr_api.mandatory_arg_error
2846: (p_api_name => v_proc
2847: ,p_argument => 'a_object_version_number'
2848: ,p_argument_value => p_a_object_version_number
2849: );

Line 2901: When HR_api.Object_Locked then

2897: --
2898: -- We need to trap the ORA LOCK exception
2899: --
2900: Exception
2901: When HR_api.Object_Locked then
2902: --
2903: -- The object is locked therefore we need to supply a meaningful
2904: -- error message.
2905: --

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

3061: -- p_rec plsql record structure
3062: -- to see if a system default is being used. If a system default
3063: -- is being used then we must set to the 'current' argument value.
3064: --
3065: If (p_rec.payroll_action_id = hr_api.g_number) then
3066: p_rec.payroll_action_id := g_old_rec.payroll_action_id;
3067: End If;
3068: If (p_rec.business_group_id = hr_api.g_number) then
3069: p_rec.business_group_id := g_old_rec.business_group_id;

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

3064: --
3065: If (p_rec.payroll_action_id = hr_api.g_number) then
3066: p_rec.payroll_action_id := g_old_rec.payroll_action_id;
3067: End If;
3068: If (p_rec.business_group_id = hr_api.g_number) then
3069: p_rec.business_group_id := g_old_rec.business_group_id;
3070: End If;
3071: If (p_rec.consolidation_set_id = hr_api.g_number) then
3072: p_rec.consolidation_set_id := g_old_rec.consolidation_set_id;

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

3067: End If;
3068: If (p_rec.business_group_id = hr_api.g_number) then
3069: p_rec.business_group_id := g_old_rec.business_group_id;
3070: End If;
3071: If (p_rec.consolidation_set_id = hr_api.g_number) then
3072: p_rec.consolidation_set_id := g_old_rec.consolidation_set_id;
3073: End If;
3074: If (p_rec.action_status = hr_api.g_varchar2) then
3075: p_rec.action_status := g_old_rec.action_status;

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

3070: End If;
3071: If (p_rec.consolidation_set_id = hr_api.g_number) then
3072: p_rec.consolidation_set_id := g_old_rec.consolidation_set_id;
3073: End If;
3074: If (p_rec.action_status = hr_api.g_varchar2) then
3075: p_rec.action_status := g_old_rec.action_status;
3076: End If;
3077: If (p_rec.effective_date = hr_api.g_date) then
3078: p_rec.effective_date := g_old_rec.effective_date;

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

3073: End If;
3074: If (p_rec.action_status = hr_api.g_varchar2) then
3075: p_rec.action_status := g_old_rec.action_status;
3076: End If;
3077: If (p_rec.effective_date = hr_api.g_date) then
3078: p_rec.effective_date := g_old_rec.effective_date;
3079: End If;
3080: If (p_rec.comments = hr_api.g_varchar2) then
3081: p_rec.comments := g_old_rec.comments;

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

3076: End If;
3077: If (p_rec.effective_date = hr_api.g_date) then
3078: p_rec.effective_date := g_old_rec.effective_date;
3079: End If;
3080: If (p_rec.comments = hr_api.g_varchar2) then
3081: p_rec.comments := g_old_rec.comments;
3082: End If;
3083: If (p_rec.current_task = hr_api.g_varchar2) then
3084: p_rec.current_task := g_old_rec.current_task;

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

3079: End If;
3080: If (p_rec.comments = hr_api.g_varchar2) then
3081: p_rec.comments := g_old_rec.comments;
3082: End If;
3083: If (p_rec.current_task = hr_api.g_varchar2) then
3084: p_rec.current_task := g_old_rec.current_task;
3085: End If;
3086: If (p_rec.legislative_parameters = hr_api.g_varchar2) then
3087: p_rec.legislative_parameters := g_old_rec.legislative_parameters;

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

3082: End If;
3083: If (p_rec.current_task = hr_api.g_varchar2) then
3084: p_rec.current_task := g_old_rec.current_task;
3085: End If;
3086: If (p_rec.legislative_parameters = hr_api.g_varchar2) then
3087: p_rec.legislative_parameters := g_old_rec.legislative_parameters;
3088: End If;
3089: If (p_rec.date_earned = hr_api.g_date) then
3090: p_rec.date_earned := g_old_rec.date_earned;

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

3085: End If;
3086: If (p_rec.legislative_parameters = hr_api.g_varchar2) then
3087: p_rec.legislative_parameters := g_old_rec.legislative_parameters;
3088: End If;
3089: If (p_rec.date_earned = hr_api.g_date) then
3090: p_rec.date_earned := g_old_rec.date_earned;
3091: End If;
3092: If (p_rec.pay_advice_date = hr_api.g_date) then
3093: p_rec.pay_advice_date := g_old_rec.pay_advice_date;

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

3088: End If;
3089: If (p_rec.date_earned = hr_api.g_date) then
3090: p_rec.date_earned := g_old_rec.date_earned;
3091: End If;
3092: If (p_rec.pay_advice_date = hr_api.g_date) then
3093: p_rec.pay_advice_date := g_old_rec.pay_advice_date;
3094: End If;
3095: If (p_rec.pay_advice_message = hr_api.g_varchar2) then
3096: p_rec.pay_advice_message := g_old_rec.pay_advice_message;

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

3091: End If;
3092: If (p_rec.pay_advice_date = hr_api.g_date) then
3093: p_rec.pay_advice_date := g_old_rec.pay_advice_date;
3094: End If;
3095: If (p_rec.pay_advice_message = hr_api.g_varchar2) then
3096: p_rec.pay_advice_message := g_old_rec.pay_advice_message;
3097: End If;
3098: If (p_rec.object_version_number = hr_api.g_number) then
3099: p_rec.object_version_number := g_old_rec.object_version_number;

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

3094: End If;
3095: If (p_rec.pay_advice_message = hr_api.g_varchar2) then
3096: p_rec.pay_advice_message := g_old_rec.pay_advice_message;
3097: End If;
3098: If (p_rec.object_version_number = hr_api.g_number) then
3099: p_rec.object_version_number := g_old_rec.object_version_number;
3100: End If;
3101: If (p_rec.run_type_id = hr_api.g_number) then
3102: p_rec.run_type_id := g_old_rec.run_type_id;

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

3097: End If;
3098: If (p_rec.object_version_number = hr_api.g_number) then
3099: p_rec.object_version_number := g_old_rec.object_version_number;
3100: End If;
3101: If (p_rec.run_type_id = hr_api.g_number) then
3102: p_rec.run_type_id := g_old_rec.run_type_id;
3103: End If;
3104: --
3105: -- Return the plsql record structure.

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

3168: hr_utility.set_location(v_proc, 6);
3169: --
3170: -- Validate business group id
3171: --
3172: hr_api.validate_bus_grp_id(p_rec.business_group_id);
3173: hr_utility.set_location(v_proc, 7);
3174: --
3175: -- Validate the assignment is in the same business group
3176: -- (Some other validate checks are done when the assignment action is

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

3337: end if;
3338: --
3339: -- If run type has changed, validate the new value is correct.
3340: --
3341: if nvl(p_rec.run_type_id, hr_api.g_number) <>
3342: nvl(g_old_rec.run_type_id, hr_api.g_number) then
3343: --
3344: -- Find out the legislation code for the current business group.
3345: v_legislation_code := get_legislation_code(p_rec.business_group_id);

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

3338: --
3339: -- If run type has changed, validate the new value is correct.
3340: --
3341: if nvl(p_rec.run_type_id, hr_api.g_number) <>
3342: nvl(g_old_rec.run_type_id, hr_api.g_number) then
3343: --
3344: -- Find out the legislation code for the current business group.
3345: v_legislation_code := get_legislation_code(p_rec.business_group_id);
3346: --

Line 3504: raise hr_api.validate_enabled;

3500: --
3501: -- If we are validating then raise the Validate_Enabled exception
3502: --
3503: if p_validate then
3504: raise hr_api.validate_enabled;
3505: end if;
3506: --
3507: hr_utility.set_location(' Leaving:'||v_proc, 10);
3508: exception

Line 3509: when hr_api.validate_enabled then

3505: end if;
3506: --
3507: hr_utility.set_location(' Leaving:'||v_proc, 10);
3508: exception
3509: when hr_api.validate_enabled then
3510: --
3511: -- As the Validate_Enabled exception has been raised
3512: -- we must rollback to the savepoint
3513: --

Line 3648: raise hr_api.validate_enabled;

3644: --
3645: -- If we are validating then raise the Validate_Enabled exception
3646: --
3647: if p_validate then
3648: raise hr_api.validate_enabled;
3649: end if;
3650: --
3651: hr_utility.set_location(' Leaving:'||v_proc, 10);
3652: exception

Line 3653: when hr_api.validate_enabled Then

3649: end if;
3650: --
3651: hr_utility.set_location(' Leaving:'||v_proc, 10);
3652: exception
3653: when hr_api.validate_enabled Then
3654: --
3655: -- As the Validate_Enabled exception has been raised
3656: -- we must rollback to the savepoint
3657: --

Line 3667: ,p_consolidation_set_id in number default hr_api.g_number

3663: -- ----------------------------------------------------------------------------
3664: --
3665: procedure upd
3666: (p_payroll_action_id in number
3667: ,p_consolidation_set_id in number default hr_api.g_number
3668: ,p_legislative_parameters in varchar2 default hr_api.g_varchar2
3669: ,p_run_type_id in number default hr_api.g_number
3670: ,p_pay_advice_date in date default hr_api.g_date
3671: ,p_pay_advice_message in varchar2 default hr_api.g_varchar2

Line 3668: ,p_legislative_parameters in varchar2 default hr_api.g_varchar2

3664: --
3665: procedure upd
3666: (p_payroll_action_id in number
3667: ,p_consolidation_set_id in number default hr_api.g_number
3668: ,p_legislative_parameters in varchar2 default hr_api.g_varchar2
3669: ,p_run_type_id in number default hr_api.g_number
3670: ,p_pay_advice_date in date default hr_api.g_date
3671: ,p_pay_advice_message in varchar2 default hr_api.g_varchar2
3672: ,p_action_status in varchar2 default hr_api.g_varchar2

Line 3669: ,p_run_type_id in number default hr_api.g_number

3665: procedure upd
3666: (p_payroll_action_id in number
3667: ,p_consolidation_set_id in number default hr_api.g_number
3668: ,p_legislative_parameters in varchar2 default hr_api.g_varchar2
3669: ,p_run_type_id in number default hr_api.g_number
3670: ,p_pay_advice_date in date default hr_api.g_date
3671: ,p_pay_advice_message in varchar2 default hr_api.g_varchar2
3672: ,p_action_status in varchar2 default hr_api.g_varchar2
3673: ,p_comments in varchar2 default hr_api.g_varchar2

Line 3670: ,p_pay_advice_date in date default hr_api.g_date

3666: (p_payroll_action_id in number
3667: ,p_consolidation_set_id in number default hr_api.g_number
3668: ,p_legislative_parameters in varchar2 default hr_api.g_varchar2
3669: ,p_run_type_id in number default hr_api.g_number
3670: ,p_pay_advice_date in date default hr_api.g_date
3671: ,p_pay_advice_message in varchar2 default hr_api.g_varchar2
3672: ,p_action_status in varchar2 default hr_api.g_varchar2
3673: ,p_comments in varchar2 default hr_api.g_varchar2
3674: ,p_assignment_action_id in number

Line 3671: ,p_pay_advice_message in varchar2 default hr_api.g_varchar2

3667: ,p_consolidation_set_id in number default hr_api.g_number
3668: ,p_legislative_parameters in varchar2 default hr_api.g_varchar2
3669: ,p_run_type_id in number default hr_api.g_number
3670: ,p_pay_advice_date in date default hr_api.g_date
3671: ,p_pay_advice_message in varchar2 default hr_api.g_varchar2
3672: ,p_action_status in varchar2 default hr_api.g_varchar2
3673: ,p_comments in varchar2 default hr_api.g_varchar2
3674: ,p_assignment_action_id in number
3675: ,p_p_object_version_number in out nocopy number

Line 3672: ,p_action_status in varchar2 default hr_api.g_varchar2

3668: ,p_legislative_parameters in varchar2 default hr_api.g_varchar2
3669: ,p_run_type_id in number default hr_api.g_number
3670: ,p_pay_advice_date in date default hr_api.g_date
3671: ,p_pay_advice_message in varchar2 default hr_api.g_varchar2
3672: ,p_action_status in varchar2 default hr_api.g_varchar2
3673: ,p_comments in varchar2 default hr_api.g_varchar2
3674: ,p_assignment_action_id in number
3675: ,p_p_object_version_number in out nocopy number
3676: ,p_a_object_version_number in number

Line 3673: ,p_comments in varchar2 default hr_api.g_varchar2

3669: ,p_run_type_id in number default hr_api.g_number
3670: ,p_pay_advice_date in date default hr_api.g_date
3671: ,p_pay_advice_message in varchar2 default hr_api.g_varchar2
3672: ,p_action_status in varchar2 default hr_api.g_varchar2
3673: ,p_comments in varchar2 default hr_api.g_varchar2
3674: ,p_assignment_action_id in number
3675: ,p_p_object_version_number in out nocopy number
3676: ,p_a_object_version_number in number
3677: ,p_validate in boolean default false

Line 3692: ,p_business_group_id => hr_api.g_number

3688: --
3689: v_rec :=
3690: convert_args
3691: (p_payroll_action_id => p_payroll_action_id
3692: ,p_business_group_id => hr_api.g_number
3693: ,p_consolidation_set_id => p_consolidation_set_id
3694: ,p_action_status => p_action_status
3695: ,p_effective_date => hr_api.g_date
3696: ,p_comments => p_comments

Line 3695: ,p_effective_date => hr_api.g_date

3691: (p_payroll_action_id => p_payroll_action_id
3692: ,p_business_group_id => hr_api.g_number
3693: ,p_consolidation_set_id => p_consolidation_set_id
3694: ,p_action_status => p_action_status
3695: ,p_effective_date => hr_api.g_date
3696: ,p_comments => p_comments
3697: ,p_current_task => hr_api.g_varchar2
3698: ,p_legislative_parameters => p_legislative_parameters
3699: ,p_run_type_id => p_run_type_id

Line 3697: ,p_current_task => hr_api.g_varchar2

3693: ,p_consolidation_set_id => p_consolidation_set_id
3694: ,p_action_status => p_action_status
3695: ,p_effective_date => hr_api.g_date
3696: ,p_comments => p_comments
3697: ,p_current_task => hr_api.g_varchar2
3698: ,p_legislative_parameters => p_legislative_parameters
3699: ,p_run_type_id => p_run_type_id
3700: ,p_date_earned => hr_api.g_date
3701: ,p_pay_advice_date => p_pay_advice_date

Line 3700: ,p_date_earned => hr_api.g_date

3696: ,p_comments => p_comments
3697: ,p_current_task => hr_api.g_varchar2
3698: ,p_legislative_parameters => p_legislative_parameters
3699: ,p_run_type_id => p_run_type_id
3700: ,p_date_earned => hr_api.g_date
3701: ,p_pay_advice_date => p_pay_advice_date
3702: ,p_pay_advice_message => p_pay_advice_message
3703: ,p_object_version_number => p_p_object_version_number
3704: );

Line 3773: raise hr_api.validate_enabled;

3769: --
3770: -- If we are validating then raise the Validate_Enabled exception
3771: --
3772: if p_validate then
3773: raise hr_api.validate_enabled;
3774: end if;
3775: --
3776: hr_utility.set_location(' Leaving:'||v_proc, 10);
3777: exception

Line 3778: when hr_api.validate_enabled Then

3774: end if;
3775: --
3776: hr_utility.set_location(' Leaving:'||v_proc, 10);
3777: exception
3778: when hr_api.validate_enabled Then
3779: --
3780: -- As the Validate_Enabled exception has been raised
3781: -- we must rollback to the savepoint
3782: --

Line 4151: hr_api.mandatory_arg_error

4147: hr_utility.set_location('Entering:'|| v_proc, 5);
4148: --
4149: -- Check mandatory parameters have been set
4150: --
4151: hr_api.mandatory_arg_error
4152: (p_api_name => v_proc
4153: ,p_argument => 'payroll_action_id'
4154: ,p_argument_value => p_payroll_action_id
4155: );

Line 4347: hr_api.mandatory_arg_error

4343: hr_utility.set_location('Entering:'|| v_proc, 5);
4344: --
4345: -- Check mandatory parameters have been set
4346: --
4347: hr_api.mandatory_arg_error
4348: (p_api_name => v_proc
4349: ,p_argument => 'payroll_action_id'
4350: ,p_argument_value => p_payroll_action_id
4351: );

Line 4528: hr_api.mandatory_arg_error

4524: hr_utility.set_location('Entering:'|| v_proc, 5);
4525: --
4526: -- Check mandatory parameters have been set
4527: --
4528: hr_api.mandatory_arg_error
4529: (p_api_name => v_proc
4530: ,p_argument => 'payroll_action_id'
4531: ,p_argument_value => p_payroll_action_id
4532: );