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.10 2010/08/02 11:33:01 kskoduri noship $ */
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: -- For bug 9766116

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

401: -- the prenote_date already present in pay_external_accounts
402: -- then updating the prenote_date with the new value
403: if l_prenote_date is null OR ( l_new_prenote_date < l_prenote_date )then
404: if g_debug then
405: hr_utility.set_location('Stamp the prenote date:'|| l_proc, 40);
406: end if;
407: pay_exa_upd.upd
408: (p_external_account_id => p_external_account_id
409: ,p_object_version_number => p_external_account_ovn

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

413: );
414: end if;
415: end if;
416: if g_debug then
417: hr_utility.set_location('Leaving:'|| l_proc, 50);
418: end if;
419: end stamp_prenote_date;
420: --
421: -- ----------------------------------------------------------------------------

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

488: --
489: begin
490: --
491: if g_debug then
492: hr_utility.set_location('Entering: '|| l_proc, 5);
493: end if;
494: --
495: open csr_payroll_details
496: (p_personal_payment_method_id => p_personal_payment_method_id

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

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

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

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

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

539: --
540: end if;
541: --
542: if g_debug then
543: hr_utility.set_location('Leaving: '|| l_proc, 10);
544: end if;
545: --
546: end upd_prenote_date;
547: -- ----------------------------------------------------------------------------

Line 713: g_debug := hr_utility.debug_enabled;

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

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

712: begin
713: g_debug := hr_utility.debug_enabled;
714: if g_debug then
715: l_proc := g_package||'create_personal_pay_method';
716: hr_utility.set_location('Entering:'|| l_proc, 10);
717: end if;
718: --
719: -- Issue a savepoint.
720: --

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

743: (p_api_name => l_proc,
744: p_argument => 'effective_date',
745: p_argument_value => p_effective_date);
746: if g_debug then
747: hr_utility.set_location(l_proc, 20);
748: end if;
749: --
750: l_effective_date := trunc(p_effective_date);
751: --

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

864: open bgsel;
865: fetch bgsel
866: into l_business_group_id;
867: if g_debug then
868: hr_utility.set_location(l_proc, 30);
869: end if;
870: --
871: if bgsel%notfound then
872: close bgsel;

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

869: end if;
870: --
871: if bgsel%notfound then
872: close bgsel;
873: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
874: Hr_utility.raise_error;
875: end if;
876: close bgsel;
877: if g_debug then

Line 874: Hr_utility.raise_error;

870: --
871: if bgsel%notfound then
872: close bgsel;
873: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
874: Hr_utility.raise_error;
875: end if;
876: close bgsel;
877: if g_debug then
878: hr_utility.set_location(l_proc, 40);

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

874: Hr_utility.raise_error;
875: end if;
876: close bgsel;
877: if g_debug then
878: hr_utility.set_location(l_proc, 40);
879: end if;
880: --
881: -- Validate the organization payment method
882: --

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

884: fetch csr_is_valid into l_exists;
885: if csr_is_valid%notfound then
886: close csr_is_valid;
887:
888: hr_utility.set_message(801, 'HR_7347_PPM_INVALID_PAY_TYPE');
889: hr_utility.raise_error;
890: end if;
891: close csr_is_valid;
892: if g_debug then

Line 889: hr_utility.raise_error;

885: if csr_is_valid%notfound then
886: close csr_is_valid;
887:
888: hr_utility.set_message(801, 'HR_7347_PPM_INVALID_PAY_TYPE');
889: hr_utility.raise_error;
890: end if;
891: close csr_is_valid;
892: if g_debug then
893: hr_utility.set_location(l_proc, 40);

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

889: hr_utility.raise_error;
890: end if;
891: close csr_is_valid;
892: if g_debug then
893: hr_utility.set_location(l_proc, 40);
894: end if;
895: --
896: -- Bug 3940935. Derive PPM_INFORMATION_CATEGORY.
897: --

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

982: p_segment29 is not null or
983: p_segment30 is not null ) then
984: --
985: -- Raise Error
986: hr_utility.set_message(801, 'HR_51377_PPM_NON_MAG_TAPE_SEGM');
987: hr_utility.raise_error;
988: --
989: elsif l_category = 'MT' then
990: --

Line 987: hr_utility.raise_error;

983: p_segment30 is not null ) then
984: --
985: -- Raise Error
986: hr_utility.set_message(801, 'HR_51377_PPM_NON_MAG_TAPE_SEGM');
987: hr_utility.raise_error;
988: --
989: elsif l_category = 'MT' then
990: --
991: if g_debug then

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

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

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

1042: );
1043: end if;
1044: --
1045: if g_debug then
1046: hr_utility.set_location(l_proc, 60);
1047: end if;
1048: --
1049: -- Call the row handler to insert the personal payment method.
1050: --

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

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

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

1136: );
1137: end if;
1138: --
1139: if g_debug then
1140: hr_utility.set_location(l_proc, 70);
1141: end if;
1142: --
1143: begin
1144: --

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

1271: p_effective_end_date := l_effective_end_date;
1272: p_comment_id := l_comment_id;
1273: --
1274: if g_debug then
1275: hr_utility.set_location(' Leaving:'||l_proc, 80);
1276: end if;
1277: exception
1278: when hr_api.validate_enabled then
1279: --

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

1310: --
1311: -- End of fix.
1312: --
1313: if g_debug then
1314: hr_utility.set_location(' Leaving:'||l_proc, 90);
1315: end if;
1316: --
1317: end create_personal_pay_method;
1318: --

Line 1435: g_debug := hr_utility.debug_enabled;

1431: l_effective_date date;
1432: l_territory_code varchar2(30);
1433: --
1434: begin
1435: g_debug := hr_utility.debug_enabled;
1436: --
1437: if g_debug then
1438: l_proc := g_package||'create_gb_personal_pay_method';
1439: hr_utility.set_location('Entering:'|| l_proc, 5);

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

1435: g_debug := hr_utility.debug_enabled;
1436: --
1437: if g_debug then
1438: l_proc := g_package||'create_gb_personal_pay_method';
1439: hr_utility.set_location('Entering:'|| l_proc, 5);
1440: end if;
1441: --
1442: l_effective_date := p_effective_date;
1443: --

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

1446: ,p_effective_date => l_effective_date
1447: ,p_leg_code => 'GB');
1448: --
1449: if g_debug then
1450: hr_utility.set_location(l_proc, 7);
1451: end if;
1452: --
1453: if p_territory_code is null then
1454: l_territory_code := 'GB';

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

1561: ,p_ppm_information30 => p_ppm_information30
1562: );
1563: --
1564: if g_debug then
1565: hr_utility.set_location(' Leaving:'||l_proc, 8);
1566: end if;
1567: end create_gb_personal_pay_method;
1568: --
1569: -- ----------------------------------------------------------------------------

Line 1662: g_debug := hr_utility.debug_enabled;

1658: l_effective_date date;
1659: l_territory_code varchar2(30);
1660: --
1661: begin
1662: g_debug := hr_utility.debug_enabled;
1663: if g_debug then
1664: l_proc := g_package||'create_us_personal_pay_method';
1665: hr_utility.set_location('Entering:'|| l_proc, 5);
1666: end if;

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

1661: begin
1662: g_debug := hr_utility.debug_enabled;
1663: if g_debug then
1664: l_proc := g_package||'create_us_personal_pay_method';
1665: hr_utility.set_location('Entering:'|| l_proc, 5);
1666: end if;
1667: --
1668: l_effective_date := p_effective_date;
1669: --

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

1673: ,p_effective_date => l_effective_date
1674: ,p_leg_code => 'US');
1675: --
1676: if g_debug then
1677: hr_utility.set_location(l_proc, 7);
1678: end if;
1679: --
1680: if p_territory_code is null then
1681: l_territory_code := 'US';

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

1776: --
1777: end if;
1778: --
1779: if g_debug then
1780: hr_utility.set_location(' Leaving:'||l_proc, 10);
1781: end if;
1782: end create_us_personal_pay_method;
1783: --
1784: -- ----------------------------------------------------------------------------

Line 1877: g_debug := hr_utility.debug_enabled;

1873: l_effective_date date;
1874: l_territory_code varchar2(30);
1875: --
1876: begin
1877: g_debug := hr_utility.debug_enabled;
1878: if g_debug then
1879: l_proc := g_package||'create_ca_personal_pay_method';
1880: hr_utility.set_location('Entering:'|| l_proc, 5);
1881: end if;

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

1876: begin
1877: g_debug := hr_utility.debug_enabled;
1878: if g_debug then
1879: l_proc := g_package||'create_ca_personal_pay_method';
1880: hr_utility.set_location('Entering:'|| l_proc, 5);
1881: end if;
1882: --
1883: l_effective_date := p_effective_date;
1884: --

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

1888: ,p_effective_date => l_effective_date
1889: ,p_leg_code => 'CA');
1890: --
1891: if g_debug then
1892: hr_utility.set_location(l_proc, 7);
1893: end if;
1894: --
1895: if p_territory_code is null then
1896: l_territory_code := 'CA';

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

1980: ,p_comment_id => p_comment_id
1981: );
1982: --
1983: if g_debug then
1984: hr_utility.set_location(' Leaving:'||l_proc, 8);
1985: end if;
1986: end create_ca_personal_pay_method;
1987: --
1988: -- ----------------------------------------------------------------------------

Line 2167: g_debug := hr_utility.debug_enabled;

2163: --
2164: l_object_version_number1 number;
2165: --
2166: begin
2167: g_debug := hr_utility.debug_enabled;
2168: if g_debug then
2169: l_proc := g_package||'update_personal_pay_method';
2170: hr_utility.set_location('Entering:'|| l_proc, 5);
2171: end if;

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

2166: begin
2167: g_debug := hr_utility.debug_enabled;
2168: if g_debug then
2169: l_proc := g_package||'update_personal_pay_method';
2170: hr_utility.set_location('Entering:'|| l_proc, 5);
2171: end if;
2172: --
2173: -- Assign in-out parameters to local variable
2174: -- and issue the savepoint.

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

2191: p_argument => 'effective_date',
2192: p_argument_value => p_effective_date);
2193: --
2194: if g_debug then
2195: hr_utility.set_location(l_proc, 6);
2196: end if;
2197: --
2198: l_effective_date := trunc(p_effective_date);
2199: --

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

2316: l_external_account_id;
2317: --
2318: if bgsel%notfound then
2319: close bgsel;
2320: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
2321: Hr_utility.raise_error;
2322: end if;
2323: --
2324: close bgsel;

Line 2321: Hr_utility.raise_error;

2317: --
2318: if bgsel%notfound then
2319: close bgsel;
2320: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
2321: Hr_utility.raise_error;
2322: end if;
2323: --
2324: close bgsel;
2325: --

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

2332: close ovnsel;
2333: --
2334: -- The external account primary key is invalid, so raise an error.
2335: --
2336: hr_utility.set_message(801, 'HR_51457_PPM_INVALID_OVN');
2337: hr_utility.raise_error;
2338: end if;
2339: close ovnsel;
2340: end if;

Line 2337: hr_utility.raise_error;

2333: --
2334: -- The external account primary key is invalid, so raise an error.
2335: --
2336: hr_utility.set_message(801, 'HR_51457_PPM_INVALID_OVN');
2337: hr_utility.raise_error;
2338: end if;
2339: close ovnsel;
2340: end if;
2341: --

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

2339: close ovnsel;
2340: end if;
2341: --
2342: if g_debug then
2343: hr_utility.set_location(l_proc, 7);
2344: end if;
2345: --
2346: -- Check that if payment type of the organization payment method
2347: -- is not 'MT' then all external account details should be null.

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

2385: nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2) then
2386: --
2387: -- Raise Error
2388: --
2389: hr_utility.set_message(801, 'HR_51377_PPM_NON_MAG_TAPE_SEGM');
2390: hr_utility.raise_error;
2391: --
2392: elsif l_category = 'MT' then
2393: --

Line 2390: hr_utility.raise_error;

2386: --
2387: -- Raise Error
2388: --
2389: hr_utility.set_message(801, 'HR_51377_PPM_NON_MAG_TAPE_SEGM');
2390: hr_utility.raise_error;
2391: --
2392: elsif l_category = 'MT' then
2393: --
2394: -- Call table handler pay_exa_upd to control the processing of the external

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

2503: l_ppm_information_category := p_ppm_information_category;
2504: end if;
2505: --
2506: if g_debug then
2507: hr_utility.set_location(l_proc, 8);
2508: end if;
2509: --
2510: -- Call the row handler to update the personal payment method.
2511: --

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

2582: -- Stamp the prenote_date on the external accounts row for 'US' magtape
2583: -- payments only.
2584: --
2585: if g_debug then
2586: hr_utility.set_location(l_proc, 9);
2587: end if;
2588: if l_territory_code = 'US' and l_category = 'MT' then
2589: stamp_prenote_date
2590: (p_personal_payment_method_id => p_personal_payment_method_id

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

2594: );
2595: end if;
2596: --
2597: if g_debug then
2598: hr_utility.set_location(l_proc, 10);
2599: end if;
2600: --
2601: begin
2602: --

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

2726: p_effective_start_date := l_effective_start_date;
2727: p_effective_end_date := l_effective_end_date;
2728: --
2729: if g_debug then
2730: hr_utility.set_location(' Leaving:'||l_proc, 10);
2731: end if;
2732: --
2733: exception
2734: when hr_api.validate_enabled then

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

2764: --
2765: -- End of fix.
2766: --
2767: if g_debug then
2768: hr_utility.set_location(' Leaving:'||l_proc, 11);
2769: end if;
2770: end update_personal_pay_method;
2771: --
2772: -- ----------------------------------------------------------------------------

Line 2884: g_debug := hr_utility.debug_enabled;

2880: --
2881: l_proc varchar2(72);
2882: --
2883: begin
2884: g_debug := hr_utility.debug_enabled;
2885: if g_debug then
2886: l_proc := g_package||'update_gb_personal_pay_method';
2887: hr_utility.set_location('Entering:'|| l_proc, 5);
2888: end if;

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

2883: begin
2884: g_debug := hr_utility.debug_enabled;
2885: if g_debug then
2886: l_proc := g_package||'update_gb_personal_pay_method';
2887: hr_utility.set_location('Entering:'|| l_proc, 5);
2888: end if;
2889: --
2890: -- Ensure that the legislation rule for the employee assignment business
2891: -- group is 'GB'.

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

2895: ,p_effective_date => p_effective_date
2896: ,p_leg_code => 'GB');
2897: --
2898: if g_debug then
2899: hr_utility.set_location(l_proc, 6);
2900: end if;
2901: --
2902: -- Call the business process to update the personal payment method
2903: --

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

3002: ,p_ppm_information30 => p_ppm_information30
3003: );
3004: --
3005: if g_debug then
3006: hr_utility.set_location(' Leaving:'||l_proc, 7);
3007: end if;
3008: end update_gb_personal_pay_method;
3009: --
3010: -- ----------------------------------------------------------------------------

Line 3098: g_debug := hr_utility.debug_enabled;

3094: --
3095: l_proc varchar2(72);
3096: --
3097: begin
3098: g_debug := hr_utility.debug_enabled;
3099: if g_debug then
3100: l_proc := g_package||'update_gb_personal_pay_method';
3101: hr_utility.set_location('Entering:'|| l_proc, 5);
3102: end if;

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

3097: begin
3098: g_debug := hr_utility.debug_enabled;
3099: if g_debug then
3100: l_proc := g_package||'update_gb_personal_pay_method';
3101: hr_utility.set_location('Entering:'|| l_proc, 5);
3102: end if;
3103: --
3104: -- Ensure that the legislation rule for the employee assignment business
3105: -- group is 'US'.

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

3109: ,p_effective_date => p_effective_date
3110: ,p_leg_code => 'US');
3111: --
3112: if g_debug then
3113: hr_utility.set_location(l_proc, 6);
3114: end if;
3115: --
3116: -- Call the business process to update the personal payment method
3117: --

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

3204: --
3205: end if;
3206: --
3207: if g_debug then
3208: hr_utility.set_location(' Leaving:'||l_proc, 7);
3209: end if;
3210: end update_us_personal_pay_method;
3211: --
3212: -- ----------------------------------------------------------------------------

Line 3300: g_debug := hr_utility.debug_enabled;

3296: --
3297: l_proc varchar2(72);
3298: --
3299: begin
3300: g_debug := hr_utility.debug_enabled;
3301: if g_debug then
3302: l_proc := g_package||'update_gb_personal_pay_method';
3303: hr_utility.set_location('Entering:'|| l_proc, 5);
3304: end if;

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

3299: begin
3300: g_debug := hr_utility.debug_enabled;
3301: if g_debug then
3302: l_proc := g_package||'update_gb_personal_pay_method';
3303: hr_utility.set_location('Entering:'|| l_proc, 5);
3304: end if;
3305: --
3306: -- Ensure that the legislation rule for the employee assignment business
3307: -- group is 'US'.

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

3311: ,p_effective_date => p_effective_date
3312: ,p_leg_code => 'CA');
3313: --
3314: if g_debug then
3315: hr_utility.set_location(l_proc, 6);
3316: end if;
3317: --
3318: -- Call the business process to update the personal payment method
3319: --

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

3395: ,p_effective_end_date => p_effective_end_date
3396: );
3397: --
3398: if g_debug then
3399: hr_utility.set_location(' Leaving:'||l_proc, 7);
3400: end if;
3401: end update_ca_personal_pay_method;
3402: --
3403: -- ----------------------------------------------------------------------------

Line 3423: g_debug := hr_utility.debug_enabled;

3419: l_proc varchar2(72);
3420: l_validate boolean := FALSE;
3421: --
3422: begin
3423: g_debug := hr_utility.debug_enabled;
3424: if g_debug then
3425: l_proc := g_package||'delete_personal_pay_method';
3426: hr_utility.set_location('Entering:'|| l_proc, 5);
3427: end if;

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

3422: begin
3423: g_debug := hr_utility.debug_enabled;
3424: if g_debug then
3425: l_proc := g_package||'delete_personal_pay_method';
3426: hr_utility.set_location('Entering:'|| l_proc, 5);
3427: end if;
3428: --
3429: -- Issue a savepoint.
3430: --

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

3430: --
3431: savepoint delete_personal_pay_method;
3432: --
3433: if g_debug then
3434: hr_utility.set_location(l_proc, 6);
3435: end if;
3436: --
3437: -- Call the row handler to delete the personal payment method.
3438: --

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

3446: ,p_validate => l_validate
3447: );
3448: --
3449: if g_debug then
3450: hr_utility.set_location(l_proc, 7);
3451: end if;
3452: --
3453: -- When in validation only mode raise the Validate_Enabled exception
3454: --

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

3456: raise hr_api.validate_enabled;
3457: end if;
3458: --
3459: if g_debug then
3460: hr_utility.set_location(' Leaving:'||l_proc, 8);
3461: end if;
3462: exception
3463: when hr_api.validate_enabled then
3464: --

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

3489: --
3490: -- End of fix.
3491: --
3492: if g_debug then
3493: hr_utility.set_location(' Leaving:'||l_proc, 9);
3494: end if;
3495: end delete_personal_pay_method;
3496: --
3497: end hr_personal_pay_method_api;