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.HR_PERSONAL_PAY_METHOD_API dependencies on HR_UTILITY

Line 6: g_debug boolean := hr_utility.debug_enabled;

2: /* $Header: pyppmapi.pkb 120.5.12010000.3 2008/08/06 08:13:31 ubhat ship $ */
3: --
4: -- Package Variables
5: --
6: g_debug boolean := hr_utility.debug_enabled;
7: g_package varchar2(33) := 'hr_personal_pay_method_api.';
8: --
9: -- ----------------------------------------------------------------------------
10: -- |-------------------------< check_insert_legislation >-------------------------|

Line 66: hr_utility.set_location('Entering:'|| l_proc, 5);

62: --
63: begin
64: if g_debug then
65: l_proc := g_package||'chk_insert_legislation';
66: hr_utility.set_location('Entering:'|| l_proc, 5);
67: end if;
68: --
69: -- Check that p_assignment_id and p_effective_date are not null as they
70: -- are used by the cursor to validate the business group.

Line 83: hr_utility.set_location(l_proc, 6);

79: p_argument => 'effective_date',
80: p_argument_value => p_effective_date);
81: --
82: if g_debug then
83: hr_utility.set_location(l_proc, 6);
84: end if;
85: --
86: -- Ensure that the legislation rule for the employee assignment
87: -- business group is that of p_leg_code.

Line 95: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');

91: into l_valid;
92: --
93: if legsel%notfound then
94: close legsel;
95: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
96: hr_utility.raise_error;
97: end if;
98: if legsel%found and l_valid <> p_leg_code then
99: close legsel;

Line 96: hr_utility.raise_error;

92: --
93: if legsel%notfound then
94: close legsel;
95: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
96: hr_utility.raise_error;
97: end if;
98: if legsel%found and l_valid <> p_leg_code then
99: close legsel;
100: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');

Line 100: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');

96: hr_utility.raise_error;
97: end if;
98: if legsel%found and l_valid <> p_leg_code then
99: close legsel;
100: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');
101: hr_utility.raise_error;
102: end if;
103: --
104: close legsel;

Line 101: hr_utility.raise_error;

97: end if;
98: if legsel%found and l_valid <> p_leg_code then
99: close legsel;
100: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');
101: hr_utility.raise_error;
102: end if;
103: --
104: close legsel;
105: if g_debug then

Line 106: hr_utility.set_location(l_proc, 7);

102: end if;
103: --
104: close legsel;
105: if g_debug then
106: hr_utility.set_location(l_proc, 7);
107: end if;
108: --
109: -- Assign out parameter after truncating the date by using a local
110: -- variable.

Line 116: hr_utility.set_location('Leaving:'|| l_proc, 8);

112: l_effective_date := trunc(p_effective_date);
113: p_effective_date := l_effective_date;
114: --
115: if g_debug then
116: hr_utility.set_location('Leaving:'|| l_proc, 8);
117: end if;
118: --
119: end check_insert_legislation;
120: --

Line 182: hr_utility.set_location('Entering:'|| l_proc, 10);

178: -- group is that of p_leg_code.
179: --
180: if g_debug then
181: l_proc := g_package||'check_update_legislation';
182: hr_utility.set_location('Entering:'|| l_proc, 10);
183: end if;
184: open legsel;
185: fetch legsel
186: into l_valid;

Line 190: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

186: into l_valid;
187: --
188: if legsel%notfound then
189: close legsel;
190: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
191: hr_utility.raise_error;
192: end if;
193: if legsel%found and l_valid <> p_leg_code then
194: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');

Line 191: hr_utility.raise_error;

187: --
188: if legsel%notfound then
189: close legsel;
190: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
191: hr_utility.raise_error;
192: end if;
193: if legsel%found and l_valid <> p_leg_code then
194: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');
195: hr_utility.raise_error;

Line 194: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');

190: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
191: hr_utility.raise_error;
192: end if;
193: if legsel%found and l_valid <> p_leg_code then
194: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');
195: hr_utility.raise_error;
196: end if;
197: --
198: close legsel;

Line 195: hr_utility.raise_error;

191: hr_utility.raise_error;
192: end if;
193: if legsel%found and l_valid <> p_leg_code then
194: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');
195: hr_utility.raise_error;
196: end if;
197: --
198: close legsel;
199: if g_debug then

Line 200: hr_utility.set_location('Leaving:'|| l_proc, 20);

196: end if;
197: --
198: close legsel;
199: if g_debug then
200: hr_utility.set_location('Leaving:'|| l_proc, 20);
201: end if;
202: --
203: end check_update_legislation;
204: --

Line 307: hr_utility.set_location('Entering:'|| l_proc, 10);

303: ;
304: begin
305: if g_debug then
306: l_proc := g_package || 'stamp_prenote_date';
307: hr_utility.set_location('Entering:'|| l_proc, 10);
308: end if;
309: --
310: -- Prenotification is allowed by default.
311: --

Line 325: hr_utility.set_location('Leaving (csr_payment_details):'|| l_proc, 20);

321: into l_3rd_party_payment
322: , l_validation_days;
323: if csr_payment_details%notfound then
324: if g_debug then
325: hr_utility.set_location('Leaving (csr_payment_details):'|| l_proc, 20);
326: end if;
327: close csr_payment_details;
328: --
329: -- There must've been an invalid primary key for the query to

Line 332: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

328: --
329: -- There must've been an invalid primary key for the query to
330: -- return no rows.
331: --
332: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
333: hr_utility.raise_error;
334: end if;
335: close csr_payment_details;
336: --

Line 333: hr_utility.raise_error;

329: -- There must've been an invalid primary key for the query to
330: -- return no rows.
331: --
332: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
333: hr_utility.raise_error;
334: end if;
335: close csr_payment_details;
336: --
337: -- Standard prenote date.

Line 358: hr_utility.set_location('Leaving (csr_payroll_details):'|| l_proc, 30);

354: fetch csr_payroll_details
355: into l_prenote_allowed;
356: if csr_payroll_details%notfound then
357: if g_debug then
358: hr_utility.set_location('Leaving (csr_payroll_details):'|| l_proc, 30);
359: end if;
360: close csr_payroll_details;
361: --
362: -- There must've been an invalid primary key for the query to

Line 365: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

361: --
362: -- There must've been an invalid primary key for the query to
363: -- return no rows.
364: --
365: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
366: hr_utility.raise_error;
367: end if;
368: close csr_payroll_details;
369: end if;

Line 366: hr_utility.raise_error;

362: -- There must've been an invalid primary key for the query to
363: -- return no rows.
364: --
365: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
366: hr_utility.raise_error;
367: end if;
368: close csr_payroll_details;
369: end if;
370: --

Line 386: hr_utility.set_location

382: fetch csr_curr_prenote_date
383: into l_prenote_date;
384: if csr_curr_prenote_date%notfound then
385: if g_debug then
386: hr_utility.set_location
387: ('Leaving (csr_curr_prenote_date):'|| l_proc, 35);
388: end if;
389: close csr_curr_prenote_date;
390: --

Line 394: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

390: --
391: -- There must've been an invalid primary key for the query to
392: -- return no rows.
393: --
394: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
395: hr_utility.raise_error;
396: end if;
397: close csr_curr_prenote_date;
398: --

Line 395: hr_utility.raise_error;

391: -- There must've been an invalid primary key for the query to
392: -- return no rows.
393: --
394: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
395: hr_utility.raise_error;
396: end if;
397: close csr_curr_prenote_date;
398: --
399: if l_prenote_date is null then

Line 401: hr_utility.set_location('Stamp the prenote date:'|| l_proc, 40);

397: close csr_curr_prenote_date;
398: --
399: if l_prenote_date is null then
400: if g_debug then
401: hr_utility.set_location('Stamp the prenote date:'|| l_proc, 40);
402: end if;
403: pay_exa_upd.upd
404: (p_external_account_id => p_external_account_id
405: ,p_object_version_number => p_external_account_ovn

Line 413: hr_utility.set_location('Leaving:'|| l_proc, 50);

409: );
410: end if;
411: end if;
412: if g_debug then
413: hr_utility.set_location('Leaving:'|| l_proc, 50);
414: end if;
415: end stamp_prenote_date;
416: --
417: -- ----------------------------------------------------------------------------

Line 488: hr_utility.set_location('Entering: '|| l_proc, 5);

484: --
485: begin
486: --
487: if g_debug then
488: hr_utility.set_location('Entering: '|| l_proc, 5);
489: end if;
490: --
491: open csr_payroll_details
492: (p_personal_payment_method_id => p_personal_payment_method_id

Line 498: hr_utility.set_location('Leaving (csr_payroll_details):'|| l_proc, 8);

494: );
495: fetch csr_payroll_details into l_prenote_allowed;
496: if csr_payroll_details%notfound then
497: if g_debug then
498: hr_utility.set_location('Leaving (csr_payroll_details):'|| l_proc, 8);
499: end if;
500: close csr_payroll_details;
501: --
502: -- There must've been an invalid primary key for the query to

Line 516: hr_utility.set_location('Leaving (csr_exa_ovn):'|| l_proc, 9);

512: open csr_exa_ovn(p_external_account_id);
513: fetch csr_exa_ovn into l_exa_ovn;
514: if csr_exa_ovn%notfound then
515: if g_debug then
516: hr_utility.set_location('Leaving (csr_exa_ovn):'|| l_proc, 9);
517: end if;
518: close csr_exa_ovn;
519: --
520: -- There must've been an invalid primary key for the query to

Line 539: hr_utility.set_location('Leaving: '|| l_proc, 10);

535: --
536: end if;
537: --
538: if g_debug then
539: hr_utility.set_location('Leaving: '|| l_proc, 10);
540: end if;
541: --
542: end upd_prenote_date;
543: -- ----------------------------------------------------------------------------

Line 709: g_debug := hr_utility.debug_enabled;

705: and p_effective_date between opm.effective_start_date and opm.effective_end_date
706: and opm.payment_type_id = ppt.payment_type_id;
707: --
708: begin
709: g_debug := hr_utility.debug_enabled;
710: if g_debug then
711: l_proc := g_package||'create_personal_pay_method';
712: hr_utility.set_location('Entering:'|| l_proc, 10);
713: end if;

Line 712: hr_utility.set_location('Entering:'|| l_proc, 10);

708: begin
709: g_debug := hr_utility.debug_enabled;
710: if g_debug then
711: l_proc := g_package||'create_personal_pay_method';
712: hr_utility.set_location('Entering:'|| l_proc, 10);
713: end if;
714: --
715: -- Issue a savepoint.
716: --

Line 743: hr_utility.set_location(l_proc, 20);

739: (p_api_name => l_proc,
740: p_argument => 'effective_date',
741: p_argument_value => p_effective_date);
742: if g_debug then
743: hr_utility.set_location(l_proc, 20);
744: end if;
745: --
746: l_effective_date := trunc(p_effective_date);
747: --

Line 863: hr_utility.set_location(l_proc, 30);

859: open bgsel;
860: fetch bgsel
861: into l_business_group_id;
862: if g_debug then
863: hr_utility.set_location(l_proc, 30);
864: end if;
865: --
866: if bgsel%notfound then
867: close bgsel;

Line 868: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');

864: end if;
865: --
866: if bgsel%notfound then
867: close bgsel;
868: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
869: Hr_utility.raise_error;
870: end if;
871: close bgsel;
872: if g_debug then

Line 869: Hr_utility.raise_error;

865: --
866: if bgsel%notfound then
867: close bgsel;
868: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
869: Hr_utility.raise_error;
870: end if;
871: close bgsel;
872: if g_debug then
873: hr_utility.set_location(l_proc, 40);

Line 873: hr_utility.set_location(l_proc, 40);

869: Hr_utility.raise_error;
870: end if;
871: close bgsel;
872: if g_debug then
873: hr_utility.set_location(l_proc, 40);
874: end if;
875: --
876: -- Validate the organization payment method
877: --

Line 883: hr_utility.set_message(801, 'HR_7347_PPM_INVALID_PAY_TYPE');

879: fetch csr_is_valid into l_exists;
880: if csr_is_valid%notfound then
881: close csr_is_valid;
882:
883: hr_utility.set_message(801, 'HR_7347_PPM_INVALID_PAY_TYPE');
884: hr_utility.raise_error;
885: end if;
886: close csr_is_valid;
887: if g_debug then

Line 884: hr_utility.raise_error;

880: if csr_is_valid%notfound then
881: close csr_is_valid;
882:
883: hr_utility.set_message(801, 'HR_7347_PPM_INVALID_PAY_TYPE');
884: hr_utility.raise_error;
885: end if;
886: close csr_is_valid;
887: if g_debug then
888: hr_utility.set_location(l_proc, 40);

Line 888: hr_utility.set_location(l_proc, 40);

884: hr_utility.raise_error;
885: end if;
886: close csr_is_valid;
887: if g_debug then
888: hr_utility.set_location(l_proc, 40);
889: end if;
890: --
891: -- Bug 3940935. Derive PPM_INFORMATION_CATEGORY.
892: --

Line 981: hr_utility.set_message(801, 'HR_51377_PPM_NON_MAG_TAPE_SEGM');

977: p_segment29 is not null or
978: p_segment30 is not null ) then
979: --
980: -- Raise Error
981: hr_utility.set_message(801, 'HR_51377_PPM_NON_MAG_TAPE_SEGM');
982: hr_utility.raise_error;
983: --
984: elsif l_category = 'MT' then
985: --

Line 982: hr_utility.raise_error;

978: p_segment30 is not null ) then
979: --
980: -- Raise Error
981: hr_utility.set_message(801, 'HR_51377_PPM_NON_MAG_TAPE_SEGM');
982: hr_utility.raise_error;
983: --
984: elsif l_category = 'MT' then
985: --
986: if g_debug then

Line 987: hr_utility.set_location(l_proc, 50);

983: --
984: elsif l_category = 'MT' then
985: --
986: if g_debug then
987: hr_utility.set_location(l_proc, 50);
988: end if;
989: --
990: -- call table handler pay_exa_ins to control the processing of the external
991: -- account combination keyflex, discarding the returning parameter

Line 1041: hr_utility.set_location(l_proc, 60);

1037: );
1038: end if;
1039: --
1040: if g_debug then
1041: hr_utility.set_location(l_proc, 60);
1042: end if;
1043: --
1044: -- Call the row handler to insert the personal payment method.
1045: --

Line 1123: hr_utility.set_location(l_proc, 65);

1119: -- Stamp the prenote_date on the external accounts row for 'US' magtape
1120: -- payments only.
1121: --
1122: if g_debug then
1123: hr_utility.set_location(l_proc, 65);
1124: end if;
1125: if p_territory_code = 'US' and l_category = 'MT' then
1126: stamp_prenote_date
1127: (p_personal_payment_method_id => l_personal_payment_method_id

Line 1135: hr_utility.set_location(l_proc, 70);

1131: );
1132: end if;
1133: --
1134: if g_debug then
1135: hr_utility.set_location(l_proc, 70);
1136: end if;
1137: --
1138: begin
1139: --

Line 1269: hr_utility.set_location(' Leaving:'||l_proc, 80);

1265: p_effective_end_date := l_effective_end_date;
1266: p_comment_id := l_comment_id;
1267: --
1268: if g_debug then
1269: hr_utility.set_location(' Leaving:'||l_proc, 80);
1270: end if;
1271: exception
1272: when hr_api.validate_enabled then
1273: --

Line 1308: hr_utility.set_location(' Leaving:'||l_proc, 90);

1304: --
1305: -- End of fix.
1306: --
1307: if g_debug then
1308: hr_utility.set_location(' Leaving:'||l_proc, 90);
1309: end if;
1310: --
1311: end create_personal_pay_method;
1312: --

Line 1397: g_debug := hr_utility.debug_enabled;

1393: l_effective_date date;
1394: l_territory_code varchar2(30);
1395: --
1396: begin
1397: g_debug := hr_utility.debug_enabled;
1398: --
1399: if g_debug then
1400: l_proc := g_package||'create_gb_personal_pay_method';
1401: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 1401: hr_utility.set_location('Entering:'|| l_proc, 5);

1397: g_debug := hr_utility.debug_enabled;
1398: --
1399: if g_debug then
1400: l_proc := g_package||'create_gb_personal_pay_method';
1401: hr_utility.set_location('Entering:'|| l_proc, 5);
1402: end if;
1403: --
1404: l_effective_date := p_effective_date;
1405: --

Line 1412: hr_utility.set_location(l_proc, 7);

1408: ,p_effective_date => l_effective_date
1409: ,p_leg_code => 'GB');
1410: --
1411: if g_debug then
1412: hr_utility.set_location(l_proc, 7);
1413: end if;
1414: --
1415: if p_territory_code is null then
1416: l_territory_code := 'GB';

Line 1496: hr_utility.set_location(' Leaving:'||l_proc, 8);

1492: ,p_segment30 => p_segment30 -- Bug 7185344
1493: );
1494: --
1495: if g_debug then
1496: hr_utility.set_location(' Leaving:'||l_proc, 8);
1497: end if;
1498: end create_gb_personal_pay_method;
1499: --
1500: -- ----------------------------------------------------------------------------

Line 1561: g_debug := hr_utility.debug_enabled;

1557: l_effective_date date;
1558: l_territory_code varchar2(30);
1559: --
1560: begin
1561: g_debug := hr_utility.debug_enabled;
1562: if g_debug then
1563: l_proc := g_package||'create_us_personal_pay_method';
1564: hr_utility.set_location('Entering:'|| l_proc, 5);
1565: end if;

Line 1564: hr_utility.set_location('Entering:'|| l_proc, 5);

1560: begin
1561: g_debug := hr_utility.debug_enabled;
1562: if g_debug then
1563: l_proc := g_package||'create_us_personal_pay_method';
1564: hr_utility.set_location('Entering:'|| l_proc, 5);
1565: end if;
1566: --
1567: l_effective_date := p_effective_date;
1568: --

Line 1576: hr_utility.set_location(l_proc, 7);

1572: ,p_effective_date => l_effective_date
1573: ,p_leg_code => 'US');
1574: --
1575: if g_debug then
1576: hr_utility.set_location(l_proc, 7);
1577: end if;
1578: --
1579: if p_territory_code is null then
1580: l_territory_code := 'US';

Line 1648: hr_utility.set_location(' Leaving:'||l_proc, 10);

1644: --
1645: end if;
1646: --
1647: if g_debug then
1648: hr_utility.set_location(' Leaving:'||l_proc, 10);
1649: end if;
1650: end create_us_personal_pay_method;
1651: --
1652: -- ----------------------------------------------------------------------------

Line 1713: g_debug := hr_utility.debug_enabled;

1709: l_effective_date date;
1710: l_territory_code varchar2(30);
1711: --
1712: begin
1713: g_debug := hr_utility.debug_enabled;
1714: if g_debug then
1715: l_proc := g_package||'create_ca_personal_pay_method';
1716: hr_utility.set_location('Entering:'|| l_proc, 5);
1717: end if;

Line 1716: hr_utility.set_location('Entering:'|| l_proc, 5);

1712: begin
1713: g_debug := hr_utility.debug_enabled;
1714: if g_debug then
1715: l_proc := g_package||'create_ca_personal_pay_method';
1716: hr_utility.set_location('Entering:'|| l_proc, 5);
1717: end if;
1718: --
1719: l_effective_date := p_effective_date;
1720: --

Line 1728: hr_utility.set_location(l_proc, 7);

1724: ,p_effective_date => l_effective_date
1725: ,p_leg_code => 'CA');
1726: --
1727: if g_debug then
1728: hr_utility.set_location(l_proc, 7);
1729: end if;
1730: --
1731: if p_territory_code is null then
1732: l_territory_code := 'CA';

Line 1789: hr_utility.set_location(' Leaving:'||l_proc, 8);

1785: ,p_comment_id => p_comment_id
1786: );
1787: --
1788: if g_debug then
1789: hr_utility.set_location(' Leaving:'||l_proc, 8);
1790: end if;
1791: end create_ca_personal_pay_method;
1792: --
1793: -- ----------------------------------------------------------------------------

Line 1972: g_debug := hr_utility.debug_enabled;

1968: --
1969: l_object_version_number1 number;
1970: --
1971: begin
1972: g_debug := hr_utility.debug_enabled;
1973: if g_debug then
1974: l_proc := g_package||'update_personal_pay_method';
1975: hr_utility.set_location('Entering:'|| l_proc, 5);
1976: end if;

Line 1975: hr_utility.set_location('Entering:'|| l_proc, 5);

1971: begin
1972: g_debug := hr_utility.debug_enabled;
1973: if g_debug then
1974: l_proc := g_package||'update_personal_pay_method';
1975: hr_utility.set_location('Entering:'|| l_proc, 5);
1976: end if;
1977: --
1978: -- Assign in-out parameters to local variable
1979: -- and issue the savepoint.

Line 2000: hr_utility.set_location(l_proc, 6);

1996: p_argument => 'effective_date',
1997: p_argument_value => p_effective_date);
1998: --
1999: if g_debug then
2000: hr_utility.set_location(l_proc, 6);
2001: end if;
2002: --
2003: l_effective_date := trunc(p_effective_date);
2004: --

Line 2124: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

2120: l_external_account_id;
2121: --
2122: if bgsel%notfound then
2123: close bgsel;
2124: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
2125: Hr_utility.raise_error;
2126: end if;
2127: --
2128: close bgsel;

Line 2125: Hr_utility.raise_error;

2121: --
2122: if bgsel%notfound then
2123: close bgsel;
2124: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
2125: Hr_utility.raise_error;
2126: end if;
2127: --
2128: close bgsel;
2129: --

Line 2140: hr_utility.set_message(801, 'HR_51457_PPM_INVALID_OVN');

2136: close ovnsel;
2137: --
2138: -- The external account primary key is invalid, so raise an error.
2139: --
2140: hr_utility.set_message(801, 'HR_51457_PPM_INVALID_OVN');
2141: hr_utility.raise_error;
2142: end if;
2143: close ovnsel;
2144: end if;

Line 2141: hr_utility.raise_error;

2137: --
2138: -- The external account primary key is invalid, so raise an error.
2139: --
2140: hr_utility.set_message(801, 'HR_51457_PPM_INVALID_OVN');
2141: hr_utility.raise_error;
2142: end if;
2143: close ovnsel;
2144: end if;
2145: --

Line 2147: hr_utility.set_location(l_proc, 7);

2143: close ovnsel;
2144: end if;
2145: --
2146: if g_debug then
2147: hr_utility.set_location(l_proc, 7);
2148: end if;
2149: --
2150: -- Check that if payment type of the organization payment method
2151: -- is not 'MT' then all external account details should be null.

Line 2193: hr_utility.set_message(801, 'HR_51377_PPM_NON_MAG_TAPE_SEGM');

2189: nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2) then
2190: --
2191: -- Raise Error
2192: --
2193: hr_utility.set_message(801, 'HR_51377_PPM_NON_MAG_TAPE_SEGM');
2194: hr_utility.raise_error;
2195: --
2196: elsif l_category = 'MT' then
2197: --

Line 2194: hr_utility.raise_error;

2190: --
2191: -- Raise Error
2192: --
2193: hr_utility.set_message(801, 'HR_51377_PPM_NON_MAG_TAPE_SEGM');
2194: hr_utility.raise_error;
2195: --
2196: elsif l_category = 'MT' then
2197: --
2198: -- Call table handler pay_exa_upd to control the processing of the external

Line 2311: hr_utility.set_location(l_proc, 8);

2307: l_ppm_information_category := p_ppm_information_category;
2308: end if;
2309: --
2310: if g_debug then
2311: hr_utility.set_location(l_proc, 8);
2312: end if;
2313: --
2314: -- Call the row handler to update the personal payment method.
2315: --

Line 2390: hr_utility.set_location(l_proc, 9);

2386: -- Stamp the prenote_date on the external accounts row for 'US' magtape
2387: -- payments only.
2388: --
2389: if g_debug then
2390: hr_utility.set_location(l_proc, 9);
2391: end if;
2392: if l_territory_code = 'US' and l_category = 'MT' then
2393: stamp_prenote_date
2394: (p_personal_payment_method_id => p_personal_payment_method_id

Line 2402: hr_utility.set_location(l_proc, 10);

2398: );
2399: end if;
2400: --
2401: if g_debug then
2402: hr_utility.set_location(l_proc, 10);
2403: end if;
2404: --
2405: begin
2406: --

Line 2533: hr_utility.set_location(' Leaving:'||l_proc, 10);

2529: p_effective_start_date := l_effective_start_date;
2530: p_effective_end_date := l_effective_end_date;
2531: --
2532: if g_debug then
2533: hr_utility.set_location(' Leaving:'||l_proc, 10);
2534: end if;
2535: --
2536: exception
2537: when hr_api.validate_enabled then

Line 2571: hr_utility.set_location(' Leaving:'||l_proc, 11);

2567: --
2568: -- End of fix.
2569: --
2570: if g_debug then
2571: hr_utility.set_location(' Leaving:'||l_proc, 11);
2572: end if;
2573: end update_personal_pay_method;
2574: --
2575: -- ----------------------------------------------------------------------------

Line 2654: g_debug := hr_utility.debug_enabled;

2650: --
2651: l_proc varchar2(72);
2652: --
2653: begin
2654: g_debug := hr_utility.debug_enabled;
2655: if g_debug then
2656: l_proc := g_package||'update_gb_personal_pay_method';
2657: hr_utility.set_location('Entering:'|| l_proc, 5);
2658: end if;

Line 2657: hr_utility.set_location('Entering:'|| l_proc, 5);

2653: begin
2654: g_debug := hr_utility.debug_enabled;
2655: if g_debug then
2656: l_proc := g_package||'update_gb_personal_pay_method';
2657: hr_utility.set_location('Entering:'|| l_proc, 5);
2658: end if;
2659: --
2660: -- Ensure that the legislation rule for the employee assignment business
2661: -- group is 'GB'.

Line 2669: hr_utility.set_location(l_proc, 6);

2665: ,p_effective_date => p_effective_date
2666: ,p_leg_code => 'GB');
2667: --
2668: if g_debug then
2669: hr_utility.set_location(l_proc, 6);
2670: end if;
2671: --
2672: -- Call the business process to update the personal payment method
2673: --

Line 2745: hr_utility.set_location(' Leaving:'||l_proc, 7);

2741: ,p_segment30 => p_segment30 -- Bug 7185344
2742: );
2743: --
2744: if g_debug then
2745: hr_utility.set_location(' Leaving:'||l_proc, 7);
2746: end if;
2747: end update_gb_personal_pay_method;
2748: --
2749: -- ----------------------------------------------------------------------------

Line 2805: g_debug := hr_utility.debug_enabled;

2801: --
2802: l_proc varchar2(72);
2803: --
2804: begin
2805: g_debug := hr_utility.debug_enabled;
2806: if g_debug then
2807: l_proc := g_package||'update_gb_personal_pay_method';
2808: hr_utility.set_location('Entering:'|| l_proc, 5);
2809: end if;

Line 2808: hr_utility.set_location('Entering:'|| l_proc, 5);

2804: begin
2805: g_debug := hr_utility.debug_enabled;
2806: if g_debug then
2807: l_proc := g_package||'update_gb_personal_pay_method';
2808: hr_utility.set_location('Entering:'|| l_proc, 5);
2809: end if;
2810: --
2811: -- Ensure that the legislation rule for the employee assignment business
2812: -- group is 'US'.

Line 2820: hr_utility.set_location(l_proc, 6);

2816: ,p_effective_date => p_effective_date
2817: ,p_leg_code => 'US');
2818: --
2819: if g_debug then
2820: hr_utility.set_location(l_proc, 6);
2821: end if;
2822: --
2823: -- Call the business process to update the personal payment method
2824: --

Line 2884: hr_utility.set_location(' Leaving:'||l_proc, 7);

2880: --
2881: end if;
2882: --
2883: if g_debug then
2884: hr_utility.set_location(' Leaving:'||l_proc, 7);
2885: end if;
2886: end update_us_personal_pay_method;
2887: --
2888: -- ----------------------------------------------------------------------------

Line 2944: g_debug := hr_utility.debug_enabled;

2940: --
2941: l_proc varchar2(72);
2942: --
2943: begin
2944: g_debug := hr_utility.debug_enabled;
2945: if g_debug then
2946: l_proc := g_package||'update_gb_personal_pay_method';
2947: hr_utility.set_location('Entering:'|| l_proc, 5);
2948: end if;

Line 2947: hr_utility.set_location('Entering:'|| l_proc, 5);

2943: begin
2944: g_debug := hr_utility.debug_enabled;
2945: if g_debug then
2946: l_proc := g_package||'update_gb_personal_pay_method';
2947: hr_utility.set_location('Entering:'|| l_proc, 5);
2948: end if;
2949: --
2950: -- Ensure that the legislation rule for the employee assignment business
2951: -- group is 'US'.

Line 2959: hr_utility.set_location(l_proc, 6);

2955: ,p_effective_date => p_effective_date
2956: ,p_leg_code => 'CA');
2957: --
2958: if g_debug then
2959: hr_utility.set_location(l_proc, 6);
2960: end if;
2961: --
2962: -- Call the business process to update the personal payment method
2963: --

Line 3012: hr_utility.set_location(' Leaving:'||l_proc, 7);

3008: ,p_effective_end_date => p_effective_end_date
3009: );
3010: --
3011: if g_debug then
3012: hr_utility.set_location(' Leaving:'||l_proc, 7);
3013: end if;
3014: end update_ca_personal_pay_method;
3015: --
3016: -- ----------------------------------------------------------------------------

Line 3036: g_debug := hr_utility.debug_enabled;

3032: l_proc varchar2(72);
3033: l_validate boolean := FALSE;
3034: --
3035: begin
3036: g_debug := hr_utility.debug_enabled;
3037: if g_debug then
3038: l_proc := g_package||'delete_personal_pay_method';
3039: hr_utility.set_location('Entering:'|| l_proc, 5);
3040: end if;

Line 3039: hr_utility.set_location('Entering:'|| l_proc, 5);

3035: begin
3036: g_debug := hr_utility.debug_enabled;
3037: if g_debug then
3038: l_proc := g_package||'delete_personal_pay_method';
3039: hr_utility.set_location('Entering:'|| l_proc, 5);
3040: end if;
3041: --
3042: -- Issue a savepoint.
3043: --

Line 3047: hr_utility.set_location(l_proc, 6);

3043: --
3044: savepoint delete_personal_pay_method;
3045: --
3046: if g_debug then
3047: hr_utility.set_location(l_proc, 6);
3048: end if;
3049: --
3050: -- Call the row handler to delete the personal payment method.
3051: --

Line 3063: hr_utility.set_location(l_proc, 7);

3059: ,p_validate => l_validate
3060: );
3061: --
3062: if g_debug then
3063: hr_utility.set_location(l_proc, 7);
3064: end if;
3065: --
3066: -- When in validation only mode raise the Validate_Enabled exception
3067: --

Line 3073: hr_utility.set_location(' Leaving:'||l_proc, 8);

3069: raise hr_api.validate_enabled;
3070: end if;
3071: --
3072: if g_debug then
3073: hr_utility.set_location(' Leaving:'||l_proc, 8);
3074: end if;
3075: exception
3076: when hr_api.validate_enabled then
3077: --

Line 3106: hr_utility.set_location(' Leaving:'||l_proc, 9);

3102: --
3103: -- End of fix.
3104: --
3105: if g_debug then
3106: hr_utility.set_location(' Leaving:'||l_proc, 9);
3107: end if;
3108: end delete_personal_pay_method;
3109: --
3110: end hr_personal_pay_method_api;