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

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

370: l_proc varchar2(150) := g_package||'update_pension_provider';
371: l_org_rec csr_org%ROWTYPE;
372:
373: Begin
374: hr_utility.set_location('Entering:'|| l_proc, 10);
375: Open csr_org;
376: Fetch csr_org Into l_org_rec;
377: If csr_org%NOTFOUND Then
378: Close csr_org;

Line 428: hr_utility.set_location('Leaving:'|| l_proc, 70);

424: x_Attribute18 => l_org_rec.Attribute18,
425: x_Attribute19 => l_org_rec.Attribute19,
426: x_Attribute20 => l_org_rec.Attribute20
427: );
428: hr_utility.set_location('Leaving:'|| l_proc, 70);
429:
430: End update_pension_provider;
431:
432:

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

678: l_hoi_rowid rowid;
679: l_assigned_pen_type varchar2(150);
680:
681: Begin
682: hr_utility.set_location('Entering:'|| l_proc, 10);
683: --
684: -- Check the start date and end date of the information
685: --
686: savepoint assign_pension_type_to_org;

Line 706: hr_utility.set_location(' INSERT Mode, Calling: hr_org_information_pkg.Insert_Row', 15);

702: Close csr_pen_type;
703: End If;
704: -- Insert the information into the hr_organization_information table
705: If p_transaction_mode = 'INSERT' Then
706: hr_utility.set_location(' INSERT Mode, Calling: hr_org_information_pkg.Insert_Row', 15);
707:
708: open csr_assigned_pen_types;
709: Fetch csr_assigned_pen_types Into l_assigned_pen_type;
710: If csr_assigned_pen_types%Found Then

Line 768: hr_utility.set_location(' UPDATE Mode, Calling: hr_org_information_pkg.Update_Row', 25);

764: );
765: p_org_information_id := l_org_information_id;
766: ElsIf p_transaction_mode = 'UPDATE' Then
767:
768: hr_utility.set_location(' UPDATE Mode, Calling: hr_org_information_pkg.Update_Row', 25);
769: --
770: -- Get the rowid for the org_information_id passed
771: --
772: Open csr_org_info;

Line 834: hr_utility.set_location(' Leaving:'|| l_proc, 60);

830: x_attribute19 => NULL,
831: x_attribute20 => NULL
832: );
833: End If;
834: hr_utility.set_location(' Leaving:'|| l_proc, 60);
835: Exception
836: When Others Then
837: Rollback to assign_pension_type_to_org;
838: Raise;

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

835: Exception
836: When Others Then
837: Rollback to assign_pension_type_to_org;
838: Raise;
839: hr_utility.set_location(' Leaving:'|| l_proc, 80);
840:
841: End assign_pension_type_to_org;
842: --
843: -- ----------------------------------------------------------------------------

Line 1089: hr_utility.set_location(' Leaving:' ,20);

1085:
1086:
1087: BEGIN
1088:
1089: hr_utility.set_location(' Leaving:' ,20);
1090: open csr_is_provider_assigned;
1091: Fetch csr_is_provider_assigned Into l_assigned_provider;
1092: If csr_is_provider_assigned%Found Then
1093: Close csr_is_provider_assigned;

Line 1134: hr_utility.set_location(' Leaving:' ,40);

1130: fetch csr_org_info into l_org_info_rowid,l_org_information_id,
1131: l_org_information_context,l_org_classification;
1132: close csr_org_info;
1133:
1134: hr_utility.set_location(' Leaving:' ,40);
1135: -- Disable the Organization classification of Pension Provider of the Org
1136: hr_org_information_pkg.update_row(
1137: x_rowid => l_org_info_rowid,
1138: x_org_information_id => l_org_information_id,

Line 1182: hr_utility.set_location(' Leaving:' ,50);

1178: x_attribute17 => NULL,
1179: x_attribute18 => NULL,
1180: x_attribute19 => NULL,
1181: x_attribute20 => NULL);
1182: hr_utility.set_location(' Leaving:' ,50);
1183:
1184: End delete_pension_provider_nl;
1185:
1186: --

Line 1240: hr_utility.set_location(' Leaving:' ,20);

1236: l_org_rec csr_org%ROWTYPE;
1237:
1238:
1239: BEGIN
1240: hr_utility.set_location(' Leaving:' ,20);
1241: open csr_is_provider_assigned;
1242: Fetch csr_is_provider_assigned Into l_assigned_provider;
1243: If csr_is_provider_assigned%Found Then
1244: Close csr_is_provider_assigned;

Line 1258: hr_utility.set_location(' Leaving:' ,40);

1254: open csr_org_info;
1255: fetch csr_org_info into l_org_info_rowid,l_org_information_id,
1256: l_org_information_context,l_org_classification;
1257: close csr_org_info;
1258: hr_utility.set_location(' Leaving:' ,40);
1259: -- Disable the Organization classification of Pension Provider of the Org
1260: hr_org_information_pkg.update_row(
1261: x_rowid => l_org_info_rowid,
1262: x_org_information_id => l_org_information_id,

Line 1306: hr_utility.set_location(' Leaving:' ,50);

1302: x_attribute17 => NULL,
1303: x_attribute18 => NULL,
1304: x_attribute19 => NULL,
1305: x_attribute20 => NULL);
1306: hr_utility.set_location(' Leaving:' ,50);
1307: -- remove all the org_information rows containing the pension types
1308: --attached to this provider
1309: Open csr_pen_types_org_info;
1310:

Line 1325: hr_utility.set_location(' Leaving:' ,60);

1321: -- if a third party payment classification exists, disable that too
1322: open csr_third_party_org_info;
1323: fetch csr_third_party_org_info into l_org_info_rowid,l_org_information_id,
1324: l_org_information_context,l_org_classification;
1325: hr_utility.set_location(' Leaving:' ,60);
1326: if csr_third_party_org_info%Found Then
1327: -- Disable the Third Party Payment Organization classification
1328: -- of Pension Provider
1329: close csr_third_party_org_info;

Line 1380: hr_utility.set_location(' Leaving:' ,70);

1376:
1377: else
1378: close csr_third_party_org_info;
1379: End If;
1380: hr_utility.set_location(' Leaving:' ,70);
1381:
1382: -- end-date the pension provider organization with the current effective date
1383: Open csr_org;
1384: Fetch csr_org into l_org_rec;

Line 1428: hr_utility.set_location(' Leaving:' ,80);

1424: x_Attribute18 => l_org_rec.Attribute18,
1425: x_Attribute19 => l_org_rec.Attribute19,
1426: x_Attribute20 => l_org_rec.Attribute20
1427: );
1428: hr_utility.set_location(' Leaving:' ,80);
1429:
1430: End delete_pension_provider_gb;
1431:
1432: --

Line 1486: hr_utility.set_location(' Leaving:' ,20);

1482: l_org_rec csr_org%ROWTYPE;
1483:
1484:
1485: BEGIN
1486: hr_utility.set_location(' Leaving:' ,20);
1487: open csr_is_provider_assigned;
1488: Fetch csr_is_provider_assigned Into l_assigned_provider;
1489: If csr_is_provider_assigned%Found Then
1490: Close csr_is_provider_assigned;

Line 1504: hr_utility.set_location(' Leaving:' ,40);

1500: open csr_org_info;
1501: fetch csr_org_info into l_org_info_rowid,l_org_information_id,
1502: l_org_information_context,l_org_classification;
1503: close csr_org_info;
1504: hr_utility.set_location(' Leaving:' ,40);
1505: -- Disable the Organization classification of Pension Provider of the Org
1506: hr_org_information_pkg.update_row(
1507: x_rowid => l_org_info_rowid,
1508: x_org_information_id => l_org_information_id,

Line 1552: hr_utility.set_location(' Leaving:' ,50);

1548: x_attribute17 => NULL,
1549: x_attribute18 => NULL,
1550: x_attribute19 => NULL,
1551: x_attribute20 => NULL);
1552: hr_utility.set_location(' Leaving:' ,50);
1553: -- remove all the org_information rows containing the pension types
1554: --attached to this provider
1555: Open csr_pen_types_org_info;
1556:

Line 1571: hr_utility.set_location(' Leaving:' ,60);

1567: -- if a third party payment classification exists, disable that too
1568: open csr_third_party_org_info;
1569: fetch csr_third_party_org_info into l_org_info_rowid,l_org_information_id,
1570: l_org_information_context,l_org_classification;
1571: hr_utility.set_location(' Leaving:' ,60);
1572: if csr_third_party_org_info%Found Then
1573: -- Disable the Third Party Payment Organization classification
1574: -- of Pension Provider
1575: close csr_third_party_org_info;

Line 1626: hr_utility.set_location(' Leaving:' ,70);

1622:
1623: else
1624: close csr_third_party_org_info;
1625: End If;
1626: hr_utility.set_location(' Leaving:' ,70);
1627:
1628: -- end-date the pension provider organization with the current effective date
1629: Open csr_org;
1630: Fetch csr_org into l_org_rec;

Line 1674: hr_utility.set_location(' Leaving:' ,80);

1670: x_Attribute18 => l_org_rec.Attribute18,
1671: x_Attribute19 => l_org_rec.Attribute19,
1672: x_Attribute20 => l_org_rec.Attribute20
1673: );
1674: hr_utility.set_location(' Leaving:' ,80);
1675:
1676: End delete_pension_provider_hu;
1677: --
1678: -- ----------------------------------------------------------------------------

Line 1731: hr_utility.set_location(' Leaving:' ,20);

1727: l_org_rec csr_org%ROWTYPE;
1728:
1729:
1730: BEGIN
1731: hr_utility.set_location(' Leaving:' ,20);
1732: open csr_is_provider_assigned;
1733: Fetch csr_is_provider_assigned Into l_assigned_provider;
1734: If csr_is_provider_assigned%Found Then
1735: Close csr_is_provider_assigned;

Line 1749: hr_utility.set_location(' Leaving:' ,40);

1745: open csr_org_info;
1746: fetch csr_org_info into l_org_info_rowid,l_org_information_id,
1747: l_org_information_context,l_org_classification;
1748: close csr_org_info;
1749: hr_utility.set_location(' Leaving:' ,40);
1750: -- Disable the Organization classification of Pension Provider of the Org
1751: hr_org_information_pkg.update_row(
1752: x_rowid => l_org_info_rowid,
1753: x_org_information_id => l_org_information_id,

Line 1797: hr_utility.set_location(' Leaving:' ,50);

1793: x_attribute17 => NULL,
1794: x_attribute18 => NULL,
1795: x_attribute19 => NULL,
1796: x_attribute20 => NULL);
1797: hr_utility.set_location(' Leaving:' ,50);
1798: -- remove all the org_information rows containing the pension types
1799: --attached to this provider
1800: Open csr_pen_types_org_info;
1801:

Line 1816: hr_utility.set_location(' Leaving:' ,60);

1812: -- if a third party payment classification exists, disable that too
1813: open csr_third_party_org_info;
1814: fetch csr_third_party_org_info into l_org_info_rowid,l_org_information_id,
1815: l_org_information_context,l_org_classification;
1816: hr_utility.set_location(' Leaving:' ,60);
1817: if csr_third_party_org_info%Found Then
1818: -- Disable the Third Party Payment Organization classification
1819: -- of Pension Provider
1820: close csr_third_party_org_info;

Line 1871: hr_utility.set_location(' Leaving:' ,70);

1867:
1868: else
1869: close csr_third_party_org_info;
1870: End If;
1871: hr_utility.set_location(' Leaving:' ,70);
1872:
1873: -- end-date the pension provider organization with the current effective date
1874: Open csr_org;
1875: Fetch csr_org into l_org_rec;

Line 1919: hr_utility.set_location(' Leaving:' ,80);

1915: x_Attribute18 => l_org_rec.Attribute18,
1916: x_Attribute19 => l_org_rec.Attribute19,
1917: x_Attribute20 => l_org_rec.Attribute20
1918: );
1919: hr_utility.set_location(' Leaving:' ,80);
1920:
1921: End delete_pension_provider_ie;
1922:
1923:

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

1998: -- Other variables
1999: l_return_status varchar2(1);
2000: l_proc varchar2(72) := 'create_pension_provider';
2001: Begin
2002: hr_utility.set_location(' Entering:' || l_proc,10);
2003: --
2004: -- Issue a savepoint
2005: --
2006: savepoint create_pension_provider;

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

2096: -- messages of any type exist in the Multiple Message List.
2097: -- Also disable Multiple Message Detection.
2098: --
2099: l_return_status := hr_multi_message.get_return_status_disable;
2100: hr_utility.set_location(' Leaving:' || l_proc,20);
2101: --
2102: exception
2103: when hr_multi_message.error_message_exist then
2104: --

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

2110: --
2111: -- Reset IN OUT parameters and set OUT parameters
2112: --
2113:
2114: hr_utility.set_location(' Leaving:' || l_proc, 30);
2115:
2116: when others then
2117: --
2118: -- When Multiple Message Detection is enabled catch

Line 2126: hr_utility.set_location(' Leaving:' || l_proc,40);

2122: -- error.
2123: --
2124: rollback to create_pension_provider;
2125: if hr_multi_message.unexpected_error_add(l_proc) then
2126: hr_utility.set_location(' Leaving:' || l_proc,40);
2127: raise;
2128: end if;
2129: --
2130: -- Reset IN OUT and set OUT parameters

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

2129: --
2130: -- Reset IN OUT and set OUT parameters
2131: --
2132: l_return_status := hr_multi_message.get_return_status_disable;
2133: hr_utility.set_location(' Leaving:' || l_proc,50);
2134:
2135: END create_pension_provider_swi;
2136:
2137: --

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

2156: -- Other variables
2157: l_return_status varchar2(1);
2158: l_proc varchar2(72) := 'update_pension_provider';
2159: Begin
2160: hr_utility.set_location(' Entering:' || l_proc,10);
2161: --
2162: -- Issue a savepoint
2163: --
2164: savepoint update_pension_provider;

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

2201: -- messages of any type exist in the Multiple Message List.
2202: -- Also disable Multiple Message Detection.
2203: --
2204: l_return_status := hr_multi_message.get_return_status_disable;
2205: hr_utility.set_location(' Leaving:' || l_proc,20);
2206: --
2207: exception
2208: when hr_multi_message.error_message_exist then
2209: --

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

2215: --
2216: -- Reset IN OUT parameters and set OUT parameters
2217: --
2218:
2219: hr_utility.set_location(' Leaving:' || l_proc, 30);
2220:
2221: when others then
2222: --
2223: -- When Multiple Message Detection is enabled catch

Line 2231: hr_utility.set_location(' Leaving:' || l_proc,40);

2227: -- error.
2228: --
2229: rollback to update_pension_provider;
2230: if hr_multi_message.unexpected_error_add(l_proc) then
2231: hr_utility.set_location(' Leaving:' || l_proc,40);
2232: raise;
2233: end if;
2234: --
2235: -- Reset IN OUT and set OUT parameters

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

2234: --
2235: -- Reset IN OUT and set OUT parameters
2236: --
2237: l_return_status := hr_multi_message.get_return_status_disable;
2238: hr_utility.set_location(' Leaving:' || l_proc,50);
2239:
2240: End update_pension_provider_swi;
2241:
2242: --

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

2261: l_proc varchar2(72) := 'delete_pension_provider';
2262: l_leg_code varchar2(5);
2263:
2264: Begin
2265: hr_utility.set_location(' Entering:' || l_proc,10);
2266: --
2267: -- Issue a savepoint
2268: --
2269: savepoint delete_pension_provider;

Line 2320: hr_utility.set_location(' Called:' || l_proc,15);

2316:
2317:
2318: END IF;
2319:
2320: hr_utility.set_location(' Called:' || l_proc,15);
2321: --
2322: -- Convert API warning boolean parameter values to specific
2323: -- messages and add them to Multiple Message List
2324: --

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

2330: -- messages of any type exist in the Multiple Message List.
2331: -- Also disable Multiple Message Detection.
2332: --
2333: l_return_status := hr_multi_message.get_return_status_disable;
2334: hr_utility.set_location(' Leaving:' || l_proc,20);
2335: --
2336: exception
2337: when hr_multi_message.error_message_exist then
2338: --

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

2344: --
2345: -- Reset IN OUT parameters and set OUT parameters
2346: --
2347:
2348: hr_utility.set_location(' Leaving:' || l_proc, 30);
2349:
2350: when others then
2351: --
2352: -- When Multiple Message Detection is enabled catch

Line 2360: hr_utility.set_location(' Leaving:' || l_proc,40);

2356: -- error.
2357: --
2358: rollback to delete_pension_provider;
2359: if hr_multi_message.unexpected_error_add(l_proc) then
2360: hr_utility.set_location(' Leaving:' || l_proc,40);
2361: raise;
2362: end if;
2363: --
2364: -- Reset IN OUT and set OUT parameters

Line 2367: hr_utility.set_location(' Leaving:' || l_return_status,45);

2363: --
2364: -- Reset IN OUT and set OUT parameters
2365: --
2366: l_return_status := hr_multi_message.get_return_status_disable;
2367: hr_utility.set_location(' Leaving:' || l_return_status,45);
2368: hr_utility.set_location(' Leaving:' || l_proc,50);
2369: End delete_pension_provider_swi;
2370:
2371: -- ----------------------------------------------------------------------------

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

2364: -- Reset IN OUT and set OUT parameters
2365: --
2366: l_return_status := hr_multi_message.get_return_status_disable;
2367: hr_utility.set_location(' Leaving:' || l_return_status,45);
2368: hr_utility.set_location(' Leaving:' || l_proc,50);
2369: End delete_pension_provider_swi;
2370:
2371: -- ----------------------------------------------------------------------------
2372: -- |-------------------< add_pension_types_swi >-------------------------------|

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

2390: -- Other variables
2391: l_return_status varchar2(1);
2392: l_proc varchar2(72) := 'add_pension_types';
2393: Begin
2394: hr_utility.set_location(' Entering:' || l_proc,10);
2395: --
2396: -- Issue a savepoint
2397: --
2398: savepoint add_pension_types;

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

2435: -- messages of any type exist in the Multiple Message List.
2436: -- Also disable Multiple Message Detection.
2437: --
2438: l_return_status := hr_multi_message.get_return_status_disable;
2439: hr_utility.set_location(' Leaving:' || l_proc,20);
2440: --
2441: exception
2442: when hr_multi_message.error_message_exist then
2443: --

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

2449: --
2450: -- Reset IN OUT parameters and set OUT parameters
2451: --
2452:
2453: hr_utility.set_location(' Leaving:' || l_proc, 30);
2454:
2455: when others then
2456: --
2457: -- When Multiple Message Detection is enabled catch

Line 2465: hr_utility.set_location(' Leaving:' || l_proc,40);

2461: -- error.
2462: --
2463: rollback to add_pension_types;
2464: if hr_multi_message.unexpected_error_add(l_proc) then
2465: hr_utility.set_location(' Leaving:' || l_proc,40);
2466: raise;
2467: end if;
2468: --
2469: -- Reset IN OUT and set OUT parameters

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

2468: --
2469: -- Reset IN OUT and set OUT parameters
2470: --
2471: l_return_status := hr_multi_message.get_return_status_disable;
2472: hr_utility.set_location(' Leaving:' || l_proc,50);
2473:
2474:
2475: END add_pension_types_swi;
2476: -- ----------------------------------------------------------------------------

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

2495: -- Other variables
2496: l_return_status varchar2(1);
2497: l_proc varchar2(72) := 'add_provider_ref_number_swi';
2498: Begin
2499: hr_utility.set_location(' Entering:' || l_proc,10);
2500: --
2501: -- Issue a savepoint
2502: --
2503: savepoint add_provider_ref_number;

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

2540: -- messages of any type exist in the Multiple Message List.
2541: -- Also disable Multiple Message Detection.
2542: --
2543: l_return_status := hr_multi_message.get_return_status_disable;
2544: hr_utility.set_location(' Leaving:' || l_proc,20);
2545: --
2546: exception
2547: when hr_multi_message.error_message_exist then
2548: --

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

2554: --
2555: -- Reset IN OUT parameters and set OUT parameters
2556: --
2557:
2558: hr_utility.set_location(' Leaving:' || l_proc, 30);
2559:
2560: when others then
2561: --
2562: -- When Multiple Message Detection is enabled catch

Line 2570: hr_utility.set_location(' Leaving:' || l_proc,40);

2566: -- error.
2567: --
2568: rollback to add_provider_ref_number;
2569: if hr_multi_message.unexpected_error_add(l_proc) then
2570: hr_utility.set_location(' Leaving:' || l_proc,40);
2571: raise;
2572: end if;
2573: --
2574: -- Reset IN OUT and set OUT parameters

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

2573: --
2574: -- Reset IN OUT and set OUT parameters
2575: --
2576: l_return_status := hr_multi_message.get_return_status_disable;
2577: hr_utility.set_location(' Leaving:' || l_proc,50);
2578:
2579:
2580: END add_provider_ref_number_swi;
2581:

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

2600: -- Other variables
2601: l_return_status varchar2(1);
2602: l_proc varchar2(72) := 'create_third_party_paymnt_swi';
2603: Begin
2604: hr_utility.set_location(' Entering:' || l_proc,10);
2605: --
2606: -- Issue a savepoint
2607: --
2608: savepoint create_third_party_paymnt_swi;

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

2641: -- messages of any type exist in the Multiple Message List.
2642: -- Also disable Multiple Message Detection.
2643: --
2644: l_return_status := hr_multi_message.get_return_status_disable;
2645: hr_utility.set_location(' Leaving:' || l_proc,20);
2646: --
2647: exception
2648: when hr_multi_message.error_message_exist then
2649: --

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

2655: --
2656: -- Reset IN OUT parameters and set OUT parameters
2657: --
2658:
2659: hr_utility.set_location(' Leaving:' || l_proc, 30);
2660:
2661: when others then
2662: --
2663: -- When Multiple Message Detection is enabled catch

Line 2671: hr_utility.set_location(' Leaving:' || l_proc,40);

2667: -- error.
2668: --
2669: rollback to create_third_party_paymnt_swi;
2670: if hr_multi_message.unexpected_error_add(l_proc) then
2671: hr_utility.set_location(' Leaving:' || l_proc,40);
2672: raise;
2673: end if;
2674: --
2675: -- Reset IN OUT and set OUT parameters

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

2674: --
2675: -- Reset IN OUT and set OUT parameters
2676: --
2677: l_return_status := hr_multi_message.get_return_status_disable;
2678: hr_utility.set_location(' Leaving:' || l_proc,50);
2679:
2680:
2681: END create_third_party_paymnt_swi;
2682:

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

2702: -- Other variables
2703: l_return_status varchar2(1);
2704: l_proc varchar2(72) := 'delete_pension_types';
2705: Begin
2706: hr_utility.set_location(' Entering:' || l_proc,10);
2707: --
2708: -- Issue a savepoint
2709: --
2710: savepoint delete_pension_types;

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

2746: -- messages of any type exist in the Multiple Message List.
2747: -- Also disable Multiple Message Detection.
2748: --
2749: l_return_status := hr_multi_message.get_return_status_disable;
2750: hr_utility.set_location(' Leaving:' || l_proc,20);
2751: --
2752: exception
2753: when hr_multi_message.error_message_exist then
2754: --

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

2760: --
2761: -- Reset IN OUT parameters and set OUT parameters
2762: --
2763:
2764: hr_utility.set_location(' Leaving:' || l_proc, 30);
2765:
2766: when others then
2767: --
2768: -- When Multiple Message Detection is enabled catch

Line 2776: hr_utility.set_location(' Leaving:' || l_proc,40);

2772: -- error.
2773: --
2774: rollback to delete_pension_types;
2775: if hr_multi_message.unexpected_error_add(l_proc) then
2776: hr_utility.set_location(' Leaving:' || l_proc,40);
2777: raise;
2778: end if;
2779: --
2780: -- Reset IN OUT and set OUT parameters

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

2779: --
2780: -- Reset IN OUT and set OUT parameters
2781: --
2782: l_return_status := hr_multi_message.get_return_status_disable;
2783: hr_utility.set_location(' Leaving:' || l_proc,50);
2784:
2785: END delete_pension_types_swi;
2786:
2787: --

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

2802: -- Other variables
2803: l_return_status varchar2(1);
2804: l_proc varchar2(72) := 'delete_third_party_paymnt_swi';
2805: Begin
2806: hr_utility.set_location(' Entering:' || l_proc,10);
2807: --
2808: -- Issue a savepoint
2809: --
2810: savepoint delete_third_party_paymnt;

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

2842: -- messages of any type exist in the Multiple Message List.
2843: -- Also disable Multiple Message Detection.
2844: --
2845: l_return_status := hr_multi_message.get_return_status_disable;
2846: hr_utility.set_location(' Leaving:' || l_proc,20);
2847: --
2848: exception
2849: when hr_multi_message.error_message_exist then
2850: --

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

2856: --
2857: -- Reset IN OUT parameters and set OUT parameters
2858: --
2859:
2860: hr_utility.set_location(' Leaving:' || l_proc, 30);
2861:
2862: when others then
2863: --
2864: -- When Multiple Message Detection is enabled catch

Line 2872: hr_utility.set_location(' Leaving:' || l_proc,40);

2868: -- error.
2869: --
2870: rollback to delete_third_party_paymnt;
2871: if hr_multi_message.unexpected_error_add(l_proc) then
2872: hr_utility.set_location(' Leaving:' || l_proc,40);
2873: raise;
2874: end if;
2875: --
2876: -- Reset IN OUT and set OUT parameters

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

2875: --
2876: -- Reset IN OUT and set OUT parameters
2877: --
2878: l_return_status := hr_multi_message.get_return_status_disable;
2879: hr_utility.set_location(' Leaving:' || l_proc,50);
2880:
2881: END delete_third_party_paymnt_swi;
2882:
2883: --

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

2908: l_return_status varchar2(1);
2909: l_proc varchar2(72) := 'assign_pension_type_to_org';
2910: Begin
2911:
2912: hr_utility.set_location(' Entering:' || l_proc,10);
2913: --
2914: -- Issue a savepoint
2915: --
2916: savepoint assign_pension_type_to_org;

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

2957: -- messages of any type exist in the Multiple Message List.
2958: -- Also disable Multiple Message Detection.
2959: --
2960: l_return_status := hr_multi_message.get_return_status_disable;
2961: hr_utility.set_location(' Leaving:' || l_proc,20);
2962: --
2963: exception
2964: when hr_multi_message.error_message_exist then
2965: --

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

2971: --
2972: -- Reset IN OUT parameters and set OUT parameters
2973: --
2974:
2975: hr_utility.set_location(' Leaving:' || l_proc, 30);
2976:
2977: when others then
2978: --
2979: -- When Multiple Message Detection is enabled catch

Line 2987: hr_utility.set_location(' Leaving:' || l_proc,40);

2983: -- error.
2984: --
2985: rollback to assign_pension_type_to_org;
2986: if hr_multi_message.unexpected_error_add(l_proc) then
2987: hr_utility.set_location(' Leaving:' || l_proc,40);
2988: raise;
2989: end if;
2990: --
2991: -- Reset IN OUT and set OUT parameters

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

2990: --
2991: -- Reset IN OUT and set OUT parameters
2992: --
2993: l_return_status := hr_multi_message.get_return_status_disable;
2994: hr_utility.set_location(' Leaving:' || l_proc,50);
2995:
2996: End assign_pension_type_to_org_swi;
2997:
2998: --

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

3015: l_return_status varchar2(1);
3016: l_proc varchar2(72) := 'del_assigned_providers_swi';
3017: Begin
3018:
3019: hr_utility.set_location(' Entering:' || l_proc,10);
3020: --
3021: -- Issue a savepoint
3022: --
3023: savepoint del_assigned_provider_swi;

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

3056: -- messages of any type exist in the Multiple Message List.
3057: -- Also disable Multiple Message Detection.
3058: --
3059: l_return_status := hr_multi_message.get_return_status_disable;
3060: hr_utility.set_location(' Leaving:' || l_proc,20);
3061: --
3062: exception
3063: when hr_multi_message.error_message_exist then
3064: --

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

3070: --
3071: -- Reset IN OUT parameters and set OUT parameters
3072: --
3073:
3074: hr_utility.set_location(' Leaving:' || l_proc, 30);
3075:
3076: when others then
3077: --
3078: -- When Multiple Message Detection is enabled catch

Line 3086: hr_utility.set_location(' Leaving:' || l_proc,40);

3082: -- error.
3083: --
3084: rollback to del_assigned_provider_swi;
3085: if hr_multi_message.unexpected_error_add(l_proc) then
3086: hr_utility.set_location(' Leaving:' || l_proc,40);
3087: raise;
3088: end if;
3089: --
3090: -- Reset IN OUT and set OUT parameters

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

3089: --
3090: -- Reset IN OUT and set OUT parameters
3091: --
3092: l_return_status := hr_multi_message.get_return_status_disable;
3093: hr_utility.set_location(' Leaving:' || l_proc,50);
3094:
3095: End delete_assigned_providers_swi;
3096:
3097: --