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.PSP_ENC_CREATE_LINES dependencies on FND_API

Line 676: p_return_status := fnd_api.g_ret_sts_success;

672: Begin
673: p_enc_org_end_date := NULL;
674: -- check for Generic Encumbrance Period
675:
676: p_return_status := fnd_api.g_ret_sts_success;
677:
678: -- moved the select to Cursor
679: OPEN c_cnt_default_org;
680: FETCH c_cnt_default_org INTO l_count;

Line 686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

682:
683: IF l_count = 0 THEN
684: fnd_message.set_name('PSP', 'PSP_ENC_GEN_PERIOD_NOT_FOUND');
685: fnd_msg_pub.add;
686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
687: END IF;
688:
689: OPEN time_pct_def_cur;
690: FETCH time_pct_def_cur INTO p_enc_org_end_date, l_enc_end_date_id, l_prev_enc_end_date;

Line 696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

692: p_enc_org_end_date := NULL;
693: fnd_message.set_name('PSP', 'PSP_ENC_MUL_END_DATES');
694: fnd_msg_pub.add;
695: g_error_message := fnd_message.get;
696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
697: END IF;
698: CLOSE time_pct_def_cur;
699:
700: --For Enhancement Enc Redesign:Bug 2259310 : Updating the Organization End date

Line 714: p_return_status := fnd_api.g_ret_sts_unexp_error;

710: IF (g_error_message IS NULL) THEN
711: g_error_message := 'OBTAIN_ENC_ORG_END_DATE: ' || SQLERRM;
712: END IF;
713: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'OBTAIN_ENC_ORG_END_DATE');
714: p_return_status := fnd_api.g_ret_sts_unexp_error;
715: return;
716: End obtain_enc_org_end_date;
717:
718: ---------------------- O B T A I N E N C P O E T A E N D D A T E -----------------------

Line 750: p_return_status := fnd_api.g_ret_sts_success;

746: l_enc_end_date := NULL;
747: END IF;
748: --Assigning values to the out parameters
749: p_enc_end_date := LEAST(l_enc_end_date, NVL(g_actual_term_date, l_enc_end_date));
750: p_return_status := fnd_api.g_ret_sts_success;
751:
752: EXCEPTION
753: WHEN OTHERS THEN
754: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

Line 760: p_return_status := fnd_api.g_ret_sts_unexp_error;

756: g_error_message := 'OBTAIN_ENC_POETA_END_DATE: ' || SQLERRM;
757: END IF;
758: g_error_api_path := SUBSTR(' OBTAIN_ENC_POETA_END_DATE:'||g_error_api_path,1,230);
759: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' OBTAIN_ENC_POETA_END_DATE ');
760: p_return_status := fnd_api.g_ret_sts_unexp_error;
761: END obtain_enc_poeta_end_date;
762:
763:
764:

Line 1533: p_return_status := fnd_api.g_ret_sts_success;

1529: RPAD(r_enc_period.r_reason_code(recno), 50, ' '));
1530: END LOOP;
1531: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
1532:
1533: p_return_status := fnd_api.g_ret_sts_success;
1534: EXCEPTION
1535: WHEN DIVIDE_BY_ZERO THEN
1536: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_ENC_AMOUNT ');
1537: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);

Line 1539: p_return_status := fnd_api.g_ret_sts_unexp_error;

1535: WHEN DIVIDE_BY_ZERO THEN
1536: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_ENC_AMOUNT ');
1537: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1538: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
1539: p_return_status := fnd_api.g_ret_sts_unexp_error;
1540: WHEN OTHERS THEN
1541: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1542: IF (g_error_message IS NULL) THEN
1543: g_error_message := l_proc_name || ': ' || SQLERRM;

Line 1548: p_return_status := fnd_api.g_ret_sts_unexp_error;

1544: END IF;
1545: fnd_msg_pub.add_exc_msg('PSP', 'DETERMINE_ENC_AMOUNT');
1546: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1547: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
1548: p_return_status := fnd_api.g_ret_sts_unexp_error;
1549: END determine_enc_amount;
1550: -- End of changes for bug fix 3488734
1551:
1552: ---------------------- C R E A T E L I N E S -------------------------------------

Line 1790: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1786: p_ls_end_date => l_end_date_active,
1787: p_poeta_end_date => l_poeta_end_date,
1788: p_enc_end_date => l_last_enc_date,
1789: p_return_status => l_return_status);
1790: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1792: END IF;
1793: END IF;
1794: hr_utility.trace(' l_last_enc_date: ' || TO_CHAR(l_last_enc_date, 'DD-MON-RRRR'));

Line 1791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1787: p_poeta_end_date => l_poeta_end_date,
1788: p_enc_end_date => l_last_enc_date,
1789: p_return_status => l_return_status);
1790: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1792: END IF;
1793: END IF;
1794: hr_utility.trace(' l_last_enc_date: ' || TO_CHAR(l_last_enc_date, 'DD-MON-RRRR'));
1795:

Line 1816: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1812: p_asg_end_date => p_asg_end_date,
1813: p_asg_amount => l_daily_rate,
1814: p_poeta_gl_hier_array => t_poeta_gl_hier_array,
1815: p_return_status => l_return_status);
1816: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1818: END IF;
1819:
1820: hr_utility.trace(' t_poeta_gl_hier_array.COUNT: ' || t_poeta_gl_hier_array.COUNT);

Line 1817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1813: p_asg_amount => l_daily_rate,
1814: p_poeta_gl_hier_array => t_poeta_gl_hier_array,
1815: p_return_status => l_return_status);
1816: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1818: END IF;
1819:
1820: hr_utility.trace(' t_poeta_gl_hier_array.COUNT: ' || t_poeta_gl_hier_array.COUNT);
1821: FOR I IN 1..t_poeta_gl_hier_array.COUNT

Line 1881: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1877: l_orig_expenditure_org_id,
1878: l_orig_expenditure_type,
1879: l_process_flag,
1880: l_return_status);
1881: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1883: END IF;
1884: ELSE
1885: psp_general.poeta_effective_date (t_poeta_gl_hier_array(I).r_enc_end_date,

Line 1882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1878: l_orig_expenditure_type,
1879: l_process_flag,
1880: l_return_status);
1881: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1883: END IF;
1884: ELSE
1885: psp_general.poeta_effective_date (t_poeta_gl_hier_array(I).r_enc_end_date,
1886: l_project_id,

Line 1891: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1887: l_award_id,
1888: l_task_id,
1889: l_effective_date,
1890: l_return_status);
1891: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1892: fnd_message.set_name('PSP', 'PSP_POETA_EFFECTIVE_DATE_ERROR');
1893: g_error_message := fnd_message.get;
1894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1895: END IF;

Line 1894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1890: l_return_status);
1891: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1892: fnd_message.set_name('PSP', 'PSP_POETA_EFFECTIVE_DATE_ERROR');
1893: g_error_message := fnd_message.get;
1894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1895: END IF;
1896:
1897: -- R12 moac uptake. Set the MOAC Context to Single
1898: l_org_id := psp_general.get_transaction_org_id( l_project_id, l_expenditure_org_id);

Line 2079: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2075: l_orig_expenditure_org_id,
2076: l_orig_expenditure_type,
2077: l_process_flag,
2078: l_return_status);
2079: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2081: END IF;
2082: END IF;
2083: END IF;

Line 2080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2076: l_orig_expenditure_type,
2077: l_process_flag,
2078: l_return_status);
2079: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2081: END IF;
2082: END IF;
2083: END IF;
2084: ELSE

Line 2093: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2089: l_award_id,
2090: l_task_id,
2091: l_effective_date,
2092: l_return_status);
2093: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2094: fnd_message.set_name('PSP', 'PSP_POETA_EFFECTIVE_DATE_ERROR');
2095: g_error_message := fnd_message.get;
2096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2097: END IF;

Line 2096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2092: l_return_status);
2093: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2094: fnd_message.set_name('PSP', 'PSP_POETA_EFFECTIVE_DATE_ERROR');
2095: g_error_message := fnd_message.get;
2096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2097: END IF;
2098:
2099: -- R12 moac uptake. Set the MOAC Context to Single
2100: l_org_id := psp_general.get_transaction_org_id( l_project_id, l_expenditure_org_id);

Line 2252: p_return_status := fnd_api.g_ret_sts_success;

2248: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
2249: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
2250: ' p_last_paid_date: ' || fnd_date.date_to_canonical(p_last_paid_date));
2251:
2252: p_return_status := fnd_api.g_ret_sts_success;
2253:
2254: OPEN c_person_id;
2255: FETCH c_person_id INTO l_person_id;
2256: CLOSE c_person_id;

Line 2275: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

2271: l_proc_step := 30;
2272:
2273: IF (r_enc_period.r_time_period_id.COUNT > 0) THEN
2274: load_sch_hierarchy(p_assignment_id, p_payroll_id, p_element_type_id, g_business_group_id, g_set_of_books_id, p_return_status);
2275: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
2276: RAISE fnd_api.g_exc_unexpected_error;
2277: END IF;
2278: END IF;
2279:

Line 2276: RAISE fnd_api.g_exc_unexpected_error;

2272:
2273: IF (r_enc_period.r_time_period_id.COUNT > 0) THEN
2274: load_sch_hierarchy(p_assignment_id, p_payroll_id, p_element_type_id, g_business_group_id, g_set_of_books_id, p_return_status);
2275: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
2276: RAISE fnd_api.g_exc_unexpected_error;
2277: END IF;
2278: END IF;
2279:
2280: OPEN enc_period_cur;

Line 2294: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

2290: l_proc_step := 40;
2291:
2292: IF (r_enc_period.r_time_period_id.COUNT > 0) THEN
2293: sub_slice_asg_chunk(p_assignment_id, p_element_type_id, g_business_group_id, g_set_of_books_id, p_return_status);
2294: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
2295: RAISE fnd_api.g_exc_unexpected_error;
2296: END IF;
2297: END IF;
2298:

Line 2295: RAISE fnd_api.g_exc_unexpected_error;

2291:
2292: IF (r_enc_period.r_time_period_id.COUNT > 0) THEN
2293: sub_slice_asg_chunk(p_assignment_id, p_element_type_id, g_business_group_id, g_set_of_books_id, p_return_status);
2294: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
2295: RAISE fnd_api.g_exc_unexpected_error;
2296: END IF;
2297: END IF;
2298:
2299: hr_utility.trace('r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));

Line 2310: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2306: p_business_group_id => g_business_group_id,
2307: p_set_of_books_id => g_set_of_books_id,
2308: p_payroll_id => p_payroll_id,
2309: p_return_status => l_return_status);
2310: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2311: RAISE fnd_api.g_exc_unexpected_error;
2312: END IF;
2313: END IF;
2314:

Line 2311: RAISE fnd_api.g_exc_unexpected_error;

2307: p_set_of_books_id => g_set_of_books_id,
2308: p_payroll_id => p_payroll_id,
2309: p_return_status => l_return_status);
2310: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2311: RAISE fnd_api.g_exc_unexpected_error;
2312: END IF;
2313: END IF;
2314:
2315: l_proc_step := 60;

Line 2452: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR

2448: ret_expenditure_type => l_new_expenditure_type,
2449: ret_gl_code_combination_id => l_new_gl_code_combination_id,
2450: retcode => l_autopop_status);
2451:
2452: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
2453: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2454: l_autopop_error := 'AUTO_POP_EXP_ERROR';
2455: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2456: l_autopop_error := 'AUTO_POP_NO_VALUE';

Line 2453: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

2449: ret_gl_code_combination_id => l_new_gl_code_combination_id,
2450: retcode => l_autopop_status);
2451:
2452: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
2453: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2454: l_autopop_error := 'AUTO_POP_EXP_ERROR';
2455: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2456: l_autopop_error := 'AUTO_POP_NO_VALUE';
2457: END IF;

Line 2455: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

2451:
2452: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
2453: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2454: l_autopop_error := 'AUTO_POP_EXP_ERROR';
2455: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2456: l_autopop_error := 'AUTO_POP_NO_VALUE';
2457: END IF;
2458: IF (l_asg_start_date <= g_enc_org_end_date) THEN
2459: orig_ci.gl_code_combination_id(g_orig_pointer) := l_gl_code_combination_id;

Line 2506: IF p_return_status <> fnd_api.g_ret_sts_success THEN

2502: p_payroll_id => p_payroll_id,
2503: p_start_date => l_poeta_start_date,
2504: p_end_date => l_poeta_end_date,
2505: p_return_status => p_return_status);
2506: IF p_return_status <> fnd_api.g_ret_sts_success THEN
2507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2508: END IF;
2509: l_expenditure_type := l_new_expenditure_type;
2510: ELSE

Line 2507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2503: p_start_date => l_poeta_start_date,
2504: p_end_date => l_poeta_end_date,
2505: p_return_status => p_return_status);
2506: IF p_return_status <> fnd_api.g_ret_sts_success THEN
2507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2508: END IF;
2509: l_expenditure_type := l_new_expenditure_type;
2510: ELSE
2511: l_gl_code_combination_id := l_new_gl_code_combination_id;

Line 2573: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR

2569: ret_expenditure_type => l_new_expenditure_type,
2570: ret_gl_code_combination_id => l_new_gl_code_combination_id,
2571: retcode => l_autopop_status);
2572:
2573: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
2574: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2575: l_autopop_error := 'AUTO_POP_EXP_ERROR';
2576: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2577: l_autopop_error := 'AUTO_POP_NO_VALUE';

Line 2574: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

2570: ret_gl_code_combination_id => l_new_gl_code_combination_id,
2571: retcode => l_autopop_status);
2572:
2573: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
2574: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2575: l_autopop_error := 'AUTO_POP_EXP_ERROR';
2576: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2577: l_autopop_error := 'AUTO_POP_NO_VALUE';
2578: END IF;

Line 2576: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

2572:
2573: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
2574: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2575: l_autopop_error := 'AUTO_POP_EXP_ERROR';
2576: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2577: l_autopop_error := 'AUTO_POP_NO_VALUE';
2578: END IF;
2579: IF (l_asg_start_date <= g_enc_org_end_date) THEN
2580: orig_ci.gl_code_combination_id(g_orig_pointer) := l_gl_code_combination_id;

Line 2627: IF p_return_status <> fnd_api.g_ret_sts_success THEN

2623: p_payroll_id => p_payroll_id,
2624: p_start_date => l_poeta_start_date,
2625: p_end_date => l_poeta_end_date,
2626: p_return_status => p_return_status);
2627: IF p_return_status <> fnd_api.g_ret_sts_success THEN
2628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2629: END IF;
2630: l_expenditure_type := l_new_expenditure_type;
2631: ELSE

Line 2628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2624: p_start_date => l_poeta_start_date,
2625: p_end_date => l_poeta_end_date,
2626: p_return_status => p_return_status);
2627: IF p_return_status <> fnd_api.g_ret_sts_success THEN
2628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2629: END IF;
2630: l_expenditure_type := l_new_expenditure_type;
2631: ELSE
2632: l_gl_code_combination_id := l_new_gl_code_combination_id;

Line 2694: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR

2690: ret_expenditure_type => l_new_expenditure_type,
2691: ret_gl_code_combination_id => l_new_gl_code_combination_id,
2692: retcode => l_autopop_status);
2693:
2694: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
2695: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2696: l_autopop_error := 'AUTO_POP_EXP_ERROR';
2697: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2698: l_autopop_error := 'AUTO_POP_NO_VALUE';

Line 2695: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

2691: ret_gl_code_combination_id => l_new_gl_code_combination_id,
2692: retcode => l_autopop_status);
2693:
2694: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
2695: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2696: l_autopop_error := 'AUTO_POP_EXP_ERROR';
2697: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2698: l_autopop_error := 'AUTO_POP_NO_VALUE';
2699: END IF;

Line 2697: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

2693:
2694: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
2695: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2696: l_autopop_error := 'AUTO_POP_EXP_ERROR';
2697: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2698: l_autopop_error := 'AUTO_POP_NO_VALUE';
2699: END IF;
2700: IF (l_asg_start_date <= g_enc_org_end_date) THEN
2701: orig_ci.gl_code_combination_id(g_orig_pointer) := l_gl_code_combination_id;

Line 2748: IF p_return_status <> fnd_api.g_ret_sts_success THEN

2744: p_payroll_id => p_payroll_id,
2745: p_start_date => l_poeta_start_date,
2746: p_end_date => l_poeta_end_date,
2747: p_return_status => p_return_status);
2748: IF p_return_status <> fnd_api.g_ret_sts_success THEN
2749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2750: END IF;
2751: l_expenditure_type := l_new_expenditure_type;
2752: ELSE

Line 2749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2745: p_start_date => l_poeta_start_date,
2746: p_end_date => l_poeta_end_date,
2747: p_return_status => p_return_status);
2748: IF p_return_status <> fnd_api.g_ret_sts_success THEN
2749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2750: END IF;
2751: l_expenditure_type := l_new_expenditure_type;
2752: ELSE
2753: l_gl_code_combination_id := l_new_gl_code_combination_id;

Line 2823: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR

2819: ret_expenditure_type => l_new_expenditure_type,
2820: ret_gl_code_combination_id => l_new_gl_code_combination_id,
2821: retcode => l_autopop_status);
2822:
2823: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
2824: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2825: l_autopop_error := 'AUTO_POP_EXP_ERROR';
2826: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2827: l_autopop_error := 'AUTO_POP_NO_VALUE';

Line 2824: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

2820: ret_gl_code_combination_id => l_new_gl_code_combination_id,
2821: retcode => l_autopop_status);
2822:
2823: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
2824: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2825: l_autopop_error := 'AUTO_POP_EXP_ERROR';
2826: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2827: l_autopop_error := 'AUTO_POP_NO_VALUE';
2828: END IF;

Line 2826: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

2822:
2823: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
2824: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2825: l_autopop_error := 'AUTO_POP_EXP_ERROR';
2826: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2827: l_autopop_error := 'AUTO_POP_NO_VALUE';
2828: END IF;
2829: IF (l_asg_start_date <= g_enc_org_end_date) THEN
2830: orig_ci.gl_code_combination_id(g_orig_pointer) := l_gl_code_combination_id;

Line 2877: IF p_return_status <> fnd_api.g_ret_sts_success THEN

2873: p_payroll_id => p_payroll_id,
2874: p_start_date => l_poeta_start_date,
2875: p_end_date => l_poeta_end_date,
2876: p_return_status => p_return_status);
2877: IF p_return_status <> fnd_api.g_ret_sts_success THEN
2878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2879: END IF;
2880: l_expenditure_type := l_new_expenditure_type;
2881: ELSE

Line 2878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2874: p_start_date => l_poeta_start_date,
2875: p_end_date => l_poeta_end_date,
2876: p_return_status => p_return_status);
2877: IF p_return_status <> fnd_api.g_ret_sts_success THEN
2878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2879: END IF;
2880: l_expenditure_type := l_new_expenditure_type;
2881: ELSE
2882: l_gl_code_combination_id := l_new_gl_code_combination_id;

Line 2950: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR

2946: ret_expenditure_type => l_new_expenditure_type,
2947: ret_gl_code_combination_id => l_new_gl_code_combination_id,
2948: retcode => l_autopop_status);
2949:
2950: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
2951: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2952: l_autopop_error := 'AUTO_POP_EXP_ERROR';
2953: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2954: l_autopop_error := 'AUTO_POP_NO_VALUE';

Line 2951: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

2947: ret_gl_code_combination_id => l_new_gl_code_combination_id,
2948: retcode => l_autopop_status);
2949:
2950: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
2951: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2952: l_autopop_error := 'AUTO_POP_EXP_ERROR';
2953: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2954: l_autopop_error := 'AUTO_POP_NO_VALUE';
2955: END IF;

Line 2953: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

2949:
2950: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
2951: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2952: l_autopop_error := 'AUTO_POP_EXP_ERROR';
2953: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
2954: l_autopop_error := 'AUTO_POP_NO_VALUE';
2955: END IF;
2956: IF (l_asg_start_date <= g_enc_org_end_date) THEN
2957: orig_ci.gl_code_combination_id(g_orig_pointer) := l_gl_code_combination_id;

Line 3004: IF p_return_status <> fnd_api.g_ret_sts_success THEN

3000: p_payroll_id => p_payroll_id,
3001: p_start_date => l_poeta_start_date,
3002: p_end_date => l_poeta_end_date,
3003: p_return_status => p_return_status);
3004: IF p_return_status <> fnd_api.g_ret_sts_success THEN
3005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3006: END IF;
3007: l_expenditure_type := l_new_expenditure_type;
3008: ELSE

Line 3005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3001: p_start_date => l_poeta_start_date,
3002: p_end_date => l_poeta_end_date,
3003: p_return_status => p_return_status);
3004: IF p_return_status <> fnd_api.g_ret_sts_success THEN
3005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3006: END IF;
3007: l_expenditure_type := l_new_expenditure_type;
3008: ELSE
3009: l_gl_code_combination_id := l_new_gl_code_combination_id;

Line 3079: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR

3075: ret_expenditure_type => l_new_expenditure_type,
3076: ret_gl_code_combination_id => l_new_gl_code_combination_id,
3077: retcode => l_autopop_status);
3078:
3079: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
3080: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
3081: l_autopop_error := 'AUTO_POP_EXP_ERROR';
3082: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
3083: l_autopop_error := 'AUTO_POP_NO_VALUE';

Line 3080: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

3076: ret_gl_code_combination_id => l_new_gl_code_combination_id,
3077: retcode => l_autopop_status);
3078:
3079: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
3080: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
3081: l_autopop_error := 'AUTO_POP_EXP_ERROR';
3082: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
3083: l_autopop_error := 'AUTO_POP_NO_VALUE';
3084: END IF;

Line 3082: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

3078:
3079: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
3080: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
3081: l_autopop_error := 'AUTO_POP_EXP_ERROR';
3082: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
3083: l_autopop_error := 'AUTO_POP_NO_VALUE';
3084: END IF;
3085: IF (l_asg_start_date <= g_enc_org_end_date) THEN
3086: orig_ci.gl_code_combination_id(g_orig_pointer) := l_gl_code_combination_id;

Line 3133: IF p_return_status <> fnd_api.g_ret_sts_success THEN

3129: p_payroll_id => p_payroll_id,
3130: p_start_date => l_poeta_start_date,
3131: p_end_date => l_poeta_end_date,
3132: p_return_status => p_return_status);
3133: IF p_return_status <> fnd_api.g_ret_sts_success THEN
3134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3135: END IF;
3136: l_expenditure_type := l_new_expenditure_type;
3137: ELSE

Line 3134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3130: p_start_date => l_poeta_start_date,
3131: p_end_date => l_poeta_end_date,
3132: p_return_status => p_return_status);
3133: IF p_return_status <> fnd_api.g_ret_sts_success THEN
3134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3135: END IF;
3136: l_expenditure_type := l_new_expenditure_type;
3137: ELSE
3138: l_gl_code_combination_id := l_new_gl_code_combination_id;

Line 3234: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR

3230: ret_expenditure_type => l_new_expenditure_type,
3231: ret_gl_code_combination_id => l_new_gl_code_combination_id,
3232: retcode => l_autopop_status);
3233:
3234: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
3235: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
3236: l_autopop_error := 'AUTO_POP_EXP_ERROR';
3237: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
3238: l_autopop_error := 'AUTO_POP_NO_VALUE';

Line 3235: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

3231: ret_gl_code_combination_id => l_new_gl_code_combination_id,
3232: retcode => l_autopop_status);
3233:
3234: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
3235: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
3236: l_autopop_error := 'AUTO_POP_EXP_ERROR';
3237: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
3238: l_autopop_error := 'AUTO_POP_NO_VALUE';
3239: END IF;

Line 3237: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

3233:
3234: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
3235: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
3236: l_autopop_error := 'AUTO_POP_EXP_ERROR';
3237: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
3238: l_autopop_error := 'AUTO_POP_NO_VALUE';
3239: END IF;
3240: IF (l_acct_type = 'E') THEN
3241: OPEN project_number_cur;

Line 3284: IF p_return_status <> fnd_api.g_ret_sts_success THEN

3280: p_payroll_id => p_payroll_id,
3281: p_start_date => l_poeta_start_date,
3282: p_end_date => l_poeta_end_date,
3283: p_return_status => p_return_status);
3284: IF p_return_status <> fnd_api.g_ret_sts_success THEN
3285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3286: END IF;
3287: l_expenditure_type := l_new_expenditure_type;
3288: ELSE

Line 3285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3281: p_start_date => l_poeta_start_date,
3282: p_end_date => l_poeta_end_date,
3283: p_return_status => p_return_status);
3284: IF p_return_status <> fnd_api.g_ret_sts_success THEN
3285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3286: END IF;
3287: l_expenditure_type := l_new_expenditure_type;
3288: ELSE
3289: l_gl_code_combination_id := l_new_gl_code_combination_id;

Line 3368: p_return_status := fnd_api.g_ret_sts_unexp_error;

3364: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
3365: EXCEPTION
3366: WHEN suspense_autopop_failed THEN
3367: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES ');
3368: p_return_status := fnd_api.g_ret_sts_unexp_error;
3369: fnd_file.put_line(fnd_file.log, 'l_reason_code: ' || l_reason_code);
3370: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
3371: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
3372: WHEN OTHERS THEN

Line 3378: p_return_status := fnd_api.g_ret_sts_unexp_error;

3374: IF (g_error_message IS NULL) THEN
3375: g_error_message := l_proc_name || ': ' || SQLERRM;
3376: END IF;
3377: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES');
3378: p_return_status := fnd_api.g_ret_sts_unexp_error;
3379: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
3380: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
3381: END create_lines;
3382:

Line 3563: p_return_status := fnd_api.g_ret_sts_success;

3559: t_enc_lines_array.r_hierarchy_code(g_enc_lines_counter) := p_hierarchy_code;
3560:
3561: g_enc_lines_counter := g_enc_lines_counter +1;
3562: END IF; /* skip inserting lines of zero dollars */
3563: p_return_status := fnd_api.g_ret_sts_success;
3564: EXCEPTION
3565: WHEN OTHERS THEN
3566: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3567: IF (g_error_message IS NULL) THEN

Line 3571: p_return_status := fnd_api.g_ret_sts_unexp_error;

3567: IF (g_error_message IS NULL) THEN
3568: g_error_message := 'INSERT_INTO_ENC_LINES: ' || SQLERRM;
3569: END IF;
3570: fnd_msg_pub.add_exc_msg('PSP_ENC_LINES','INSERT_INTO_ENC_LINES');
3571: p_return_status := fnd_api.g_ret_sts_unexp_error;
3572: END insert_into_enc_lines;
3573:
3574: --------------------------- INSERT INTO CONTROL TABLES --------------------------------------
3575: PROCEDURE Create_Controls(p_payroll_action_id IN NUMBER,

Line 3667: p_return_status := fnd_api.g_ret_sts_success;

3663: enc_control_tab.r_ogm_cr_amount.delete;
3664: enc_control_tab.r_uom.delete;
3665:
3666: COMMIT;
3667: p_return_status := fnd_api.g_ret_sts_success;
3668: EXCEPTION
3669: WHEN OTHERS THEN
3670: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3671: IF (g_error_message IS NULL) THEN

Line 3674: p_return_status := fnd_api.g_ret_sts_unexp_error;

3670: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3671: IF (g_error_message IS NULL) THEN
3672: g_error_message := 'CREATE_CONTROLS: ' || SQLERRM;
3673: END IF;
3674: p_return_status := fnd_api.g_ret_sts_unexp_error;
3675: fnd_message.set_name('PSP','PSP_ENC_INSERT_CONTROLS');
3676: FND_MSG_PUB.ADD;
3677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3678: END create_controls;

Line 3677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3673: END IF;
3674: p_return_status := fnd_api.g_ret_sts_unexp_error;
3675: fnd_message.set_name('PSP','PSP_ENC_INSERT_CONTROLS');
3676: FND_MSG_PUB.ADD;
3677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3678: END create_controls;
3679:
3680: /**********************************************************
3681: Created By: lveerubh

Line 3754: p_return_status := fnd_api.g_ret_sts_success;

3750: p_poeta_gl_hier_array(i).r_enc_start_date := l_start_date;
3751: p_poeta_gl_hier_array(i).r_enc_end_date := l_end_date;
3752: p_poeta_gl_hier_array(i).r_susp_flag := 'Y';
3753: /*******************************************
3754: p_return_status := fnd_api.g_ret_sts_success;
3755: RETURN;
3756: END IF;
3757: IF l_start_date < NVL(p_poeta_start_date,l_start_date) THEN
3758: l_start_date := NVL(p_poeta_start_date,l_start_date);

Line 3859: p_return_status := fnd_api.g_ret_sts_success;

3855: p_poeta_gl_hier_array(j).r_amount :=
3856: round(((p_asg_amount * l_bus_days_in_schedules) / l_bus_days_in_period),g_ext_precision);
3857: -- Introduced rounding for Bug 2916848 Ilo Mrc Ehnc.
3858: END LOOP;
3859: p_return_status := fnd_api.g_ret_sts_success;
3860:
3861: EXCEPTION
3862: WHEN DIVIDE_BY_ZERO THEN
3863: g_error_api_path := SUBSTR(' DETERMINE_PRO_RATA_DATES'||g_error_api_path,1,230);

Line 3865: p_return_status := fnd_api.g_ret_sts_unexp_error;

3861: EXCEPTION
3862: WHEN DIVIDE_BY_ZERO THEN
3863: g_error_api_path := SUBSTR(' DETERMINE_PRO_RATA_DATES'||g_error_api_path,1,230);
3864: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_PRO_RATA_DATES ');
3865: p_return_status := fnd_api.g_ret_sts_unexp_error;
3866:
3867: WHEN OTHERS THEN
3868: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3869: IF (g_error_message IS NULL) THEN

Line 3874: p_return_status := fnd_api.g_ret_sts_unexp_error;

3870: g_error_message := 'DETERMINE_PRO_RATA_DATES: ' || SQLERRM;
3871: END IF;
3872: g_error_api_path := SUBSTR(' DETERMINE_PRO_RATA_DATES'||g_error_api_path,1,230);
3873: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_PRO_RATA_DATES ');
3874: p_return_status := fnd_api.g_ret_sts_unexp_error;
3875:
3876: END determine_pro_rata_dates;
3877:
3878: /**************************************************************************************************************************

Line 4067: p_return_status := fnd_api.g_ret_sts_success;

4063: t_enc_lines_array2.r_orig_expenditure_type.delete;
4064: t_enc_lines_array2.r_orig_expenditure_org_id.delete;
4065: t_enc_lines_array2.r_hierarchy_code.delete;
4066:
4067: p_return_status := fnd_api.g_ret_sts_success;
4068:
4069: EXCEPTION
4070: WHEN OTHERS THEN
4071: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

Line 4077: p_return_status := fnd_api.g_ret_sts_unexp_error;

4073: g_error_message := 'INSERT_ENC_LINES_FROM_ARRAYS: ' || SQLERRM;
4074: END IF;
4075: g_error_api_path := SUBSTR(' INSERT_ENC_LINES_FROM_ARRAYS:'||g_error_api_path,1,230);
4076: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' INSERT_ENC_LINES_FROM_ARRAYS');
4077: p_return_status := fnd_api.g_ret_sts_unexp_error;
4078: END insert_enc_lines_from_arrays;
4079:
4080: -- Introduced the following procedure for bug fix 3462452
4081: PROCEDURE sub_slice_asg_chunk (p_assignment_id IN NUMBER,

Line 6571: p_return_status := fnd_api.g_ret_sts_success;

6567: r_enc_period.r_encumbrance_amount(recno) := 0;
6568: END LOOP;
6569: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
6570:
6571: p_return_status := fnd_api.g_ret_sts_success;
6572: EXCEPTION
6573: WHEN OTHERS THEN
6574: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6575: IF (g_error_message IS NULL) THEN

Line 6580: p_return_status := fnd_api.g_ret_sts_unexp_error;

6576: g_error_message := l_proc_name || ': ' || SQLERRM;
6577: END IF;
6578: g_error_api_path := SUBSTR(' SUB_SLICE_ASG_CHUNK:'||g_error_api_path,1,230);
6579: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' SUB_SLICE_ASG_CHUNK');
6580: p_return_status := fnd_api.g_ret_sts_unexp_error;
6581: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
6582: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
6583: END sub_slice_asg_chunk;
6584: -- End of bug fix 3462452

Line 6614: p_print_header => FND_API.G_TRUE);

6610: WHEN OTHERS THEN
6611: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6612: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_INIT: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
6613: psp_message_s.print_error(p_mode => FND_FILE.LOG,
6614: p_print_header => FND_API.G_TRUE);
6615: END cel_init;
6616:
6617: PROCEDURE cel_range_code (pactid IN NUMBER,
6618: sqlstr OUT NOCOPY VARCHAR2) IS

Line 6681: IF l_return_status <> fnd_api.g_ret_sts_success THEN

6677:
6678: IF ((l_payroll_id IS NOT NULL) OR (l_process_mode = 'TERMINATE')) THEN
6679: enc_pre_process(pactid, l_payroll_id, l_process_mode, l_return_status);
6680:
6681: IF l_return_status <> fnd_api.g_ret_sts_success THEN
6682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6683: END IF;
6684: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed enc_pre_process for l_payroll_id: ' || l_payroll_id || ' process_mode: ' || l_process_mode);
6685: ELSE

Line 6682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6678: IF ((l_payroll_id IS NOT NULL) OR (l_process_mode = 'TERMINATE')) THEN
6679: enc_pre_process(pactid, l_payroll_id, l_process_mode, l_return_status);
6680:
6681: IF l_return_status <> fnd_api.g_ret_sts_success THEN
6682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6683: END IF;
6684: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed enc_pre_process for l_payroll_id: ' || l_payroll_id || ' process_mode: ' || l_process_mode);
6685: ELSE
6686: OPEN enc_payrolls_cur;

Line 6692: IF l_return_status <> fnd_api.g_ret_sts_success THEN

6688: FETCH enc_payrolls_cur INTO l_payroll_id;
6689: EXIT WHEN enc_payrolls_cur%NOTFOUND;
6690:
6691: enc_pre_process(pactid, l_payroll_id, l_process_mode, l_return_status);
6692: IF l_return_status <> fnd_api.g_ret_sts_success THEN
6693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6694: END IF;
6695: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed enc_pre_process for l_payroll_id: ' || l_payroll_id || ' process_mode: ' || l_process_mode);
6696: END LOOP;

Line 6693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6689: EXIT WHEN enc_payrolls_cur%NOTFOUND;
6690:
6691: enc_pre_process(pactid, l_payroll_id, l_process_mode, l_return_status);
6692: IF l_return_status <> fnd_api.g_ret_sts_success THEN
6693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6694: END IF;
6695: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed enc_pre_process for l_payroll_id: ' || l_payroll_id || ' process_mode: ' || l_process_mode);
6696: END LOOP;
6697: CLOSE enc_payrolls_cur;

Line 6737: psp_message_s.print_error (p_mode => FND_FILE.LOG, p_print_header => FND_API.G_FALSE);

6733: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' sqlstr: ' || sqlstr);
6734: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6735: EXCEPTION
6736: WHEN NO_UPDATE_REC_FOUND THEN
6737: psp_message_s.print_error (p_mode => FND_FILE.LOG, p_print_header => FND_API.G_FALSE);
6738: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6739: WHEN OTHERS THEN
6740: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6741: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_RANGE_CODE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);

Line 6743: p_print_header => FND_API.G_TRUE);

6739: WHEN OTHERS THEN
6740: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6741: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_RANGE_CODE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
6742: psp_message_s.print_error(p_mode => FND_FILE.LOG,
6743: p_print_header => FND_API.G_TRUE);
6744: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6745: END cel_range_code;
6746:
6747: PROCEDURE cel_asg_action_code (p_pactid IN NUMBER,

Line 7313: IF l_return_status <> fnd_api.g_ret_sts_success THEN

7309: obtain_enc_org_end_date(p_enc_org_end_date => l_enc_org_end_date,
7310: p_business_group_id => l_business_group_id,
7311: p_set_of_books_id => l_set_of_books_id,
7312: p_return_status => l_return_status);
7313: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7315: END IF;
7316: g_enc_org_end_date := l_enc_org_end_date ;
7317: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_enc_org_end_date: ' || fnd_date.date_to_canonical(g_enc_org_end_date));

Line 7314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7310: p_business_group_id => l_business_group_id,
7311: p_set_of_books_id => l_set_of_books_id,
7312: p_return_status => l_return_status);
7313: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7315: END IF;
7316: g_enc_org_end_date := l_enc_org_end_date ;
7317: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_enc_org_end_date: ' || fnd_date.date_to_canonical(g_enc_org_end_date));
7318:

Line 7459: IF l_return_status <> fnd_api.g_ret_sts_success THEN

7455: -- p_set_of_books_id => l_set_of_books_id,
7456: p_last_paid_date => l_enc_begin_date,
7457: -- p_max_enc_date => l_max_enc_date,
7458: p_return_status => l_return_status);
7459: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7461: END IF;
7462: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed create_lines for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id || ' element_type_id: ' || l_element_type_id);
7463: log_cel_warnings;

Line 7460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7456: p_last_paid_date => l_enc_begin_date,
7457: -- p_max_enc_date => l_max_enc_date,
7458: p_return_status => l_return_status);
7459: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7461: END IF;
7462: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed create_lines for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id || ' element_type_id: ' || l_element_type_id);
7463: log_cel_warnings;
7464: END IF;

Line 7508: IF l_return_status <> fnd_api.g_ret_sts_success THEN

7504: -- p_set_of_books_id => l_set_of_books_id,
7505: p_last_paid_date => l_enc_begin_date,
7506: -- p_max_enc_date => l_max_enc_date,
7507: p_return_status => l_return_status);
7508: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7510: END IF;
7511: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed create_lines for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id || ' element_type_id: ' || l_element_type_id);
7512: log_cel_warnings;

Line 7509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7505: p_last_paid_date => l_enc_begin_date,
7506: -- p_max_enc_date => l_max_enc_date,
7507: p_return_status => l_return_status);
7508: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7510: END IF;
7511: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed create_lines for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id || ' element_type_id: ' || l_element_type_id);
7512: log_cel_warnings;
7513: END IF;

Line 7532: IF l_return_status <> fnd_api.g_ret_sts_success THEN

7528: p_set_of_books_id => l_set_of_books_id,
7529: p_enc_line_type => 'U',
7530: l_retcode => l_return_status);
7531:
7532: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7533: RAISE fnd_api.g_exc_unexpected_error;
7534: END IF;
7535: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed verify_changes for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id);
7536: ELSE

Line 7533: RAISE fnd_api.g_exc_unexpected_error;

7529: p_enc_line_type => 'U',
7530: l_retcode => l_return_status);
7531:
7532: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7533: RAISE fnd_api.g_exc_unexpected_error;
7534: END IF;
7535: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed verify_changes for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id);
7536: ELSE
7537: IF (l_liq_all_count > 0) THEN

Line 7598: IF l_return_status <> fnd_api.g_ret_sts_success THEN

7594: p_business_group_id => l_business_group_id,
7595: p_set_of_books_id => l_set_of_books_id,
7596: p_return_status => l_return_status);
7597:
7598: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7599: RAISE fnd_api.g_exc_unexpected_error;
7600: END IF;
7601: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed create_liq_lines for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id);
7602:

Line 7599: RAISE fnd_api.g_exc_unexpected_error;

7595: p_set_of_books_id => l_set_of_books_id,
7596: p_return_status => l_return_status);
7597:
7598: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7599: RAISE fnd_api.g_exc_unexpected_error;
7600: END IF;
7601: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed create_liq_lines for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id);
7602:
7603: create_sum_lines (p_payroll_action_id => p_payroll_action_id,

Line 7610: IF l_return_status <> fnd_api.g_ret_sts_success THEN

7606: p_business_group_id => l_business_group_id,
7607: p_set_of_books_id => l_set_of_books_id,
7608: p_return_status => l_return_status);
7609:
7610: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7611: RAISE fnd_api.g_exc_unexpected_error;
7612: END IF;
7613: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed create_sum_lines for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id);
7614:

Line 7611: RAISE fnd_api.g_exc_unexpected_error;

7607: p_set_of_books_id => l_set_of_books_id,
7608: p_return_status => l_return_status);
7609:
7610: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7611: RAISE fnd_api.g_exc_unexpected_error;
7612: END IF;
7613: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed create_sum_lines for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id);
7614:
7615: update_hierarchy_dates (p_payroll_action_id => p_payroll_action_id,

Line 7620: IF l_return_status <> fnd_api.g_ret_sts_success THEN

7616: p_payroll_id => l_payroll_id,
7617: p_assignment_id => l_assignment_id,
7618: p_return_status => l_return_status);
7619:
7620: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7621: RAISE fnd_api.g_exc_unexpected_error;
7622: END IF;
7623: END LOOP;
7624:

Line 7621: RAISE fnd_api.g_exc_unexpected_error;

7617: p_assignment_id => l_assignment_id,
7618: p_return_status => l_return_status);
7619:
7620: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7621: RAISE fnd_api.g_exc_unexpected_error;
7622: END IF;
7623: END LOOP;
7624:
7625: FORALL recno IN 1..t_assignments.asg_array.COUNT

Line 7724: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);

7720: p_return_status => l_return_status);
7721: END IF;
7722: END IF;
7723: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_ARCHIVE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
7724: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
7725: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_ARCHIVE (payroll_action_id: ' || p_payroll_action_id || ' chunk_number: ' || p_chunk_number ||')');
7726: ROLLBACK TO CEL_ARCHIVE;
7727: RAISE;
7728: END cel_archive;

Line 7814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7810: IF l_request_id = 0 THEN
7811: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Run Results Report submission failed');
7812: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
7813: fnd_msg_pub.add;
7814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7815: END IF;
7816: COMMIT;
7817: RAISE fnd_api.g_exc_unexpected_error;
7818: END IF;

Line 7817: RAISE fnd_api.g_exc_unexpected_error;

7813: fnd_msg_pub.add;
7814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7815: END IF;
7816: COMMIT;
7817: RAISE fnd_api.g_exc_unexpected_error;
7818: END IF;
7819:
7820: UPDATE psp_enc_process_assignments pepa
7821: SET assignment_status = 'B'

Line 7957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7953: IF l_request_id = 0 THEN
7954: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Run Results Report submission failed');
7955: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
7956: fnd_msg_pub.add;
7957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7958: END IF;
7959: COMMIT;
7960:
7961: -- 13566809 The delete statement deletes all the assignment information

Line 7992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7988: IF l_request_id = 0 THEN
7989: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer submission failed');
7990: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
7991: fnd_msg_pub.add;
7992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7993: END IF;
7994:
7995: UPDATE psp_enc_processes
7996: SET process_phase = 'deinit_st'

Line 8010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8006: IF call_status = FALSE THEN
8007: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer failed');
8008: fnd_message.set_name('PSP','PSP_ENC_STR_FAILED');
8009: fnd_msg_pub.add;
8010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8011: END IF;
8012: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer completed');
8013: ELSE
8014: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer not required as there arent any new summary lines');

Line 8449: IF l_return_status <> fnd_api.g_ret_sts_success THEN

8445: p_set_of_books_id => p_set_of_books_id,
8446: p_enc_line_type => 'U',
8447: p_return_status => l_return_status);
8448:
8449: IF l_return_status <> fnd_api.g_ret_sts_success THEN
8450: RAISE fnd_api.g_exc_unexpected_error;
8451: END IF;
8452:
8453: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving verify_changes

Line 8450: RAISE fnd_api.g_exc_unexpected_error;

8446: p_enc_line_type => 'U',
8447: p_return_status => l_return_status);
8448:
8449: IF l_return_status <> fnd_api.g_ret_sts_success THEN
8450: RAISE fnd_api.g_exc_unexpected_error;
8451: END IF;
8452:
8453: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving verify_changes
8454: p_payroll_id: ' || p_payroll_id || ' p_assignment_id: ' || p_assignment_id || '

Line 8457: l_retcode := FND_API.G_RET_STS_SUCCESS;

8453: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving verify_changes
8454: p_payroll_id: ' || p_payroll_id || ' p_assignment_id: ' || p_assignment_id || '
8455: p_business_group_id: ' || p_business_group_id || ' p_set_of_books_id: ' || p_set_of_books_id || '
8456: p_enc_line_type: ' || p_enc_line_type);
8457: l_retcode := FND_API.G_RET_STS_SUCCESS;
8458: EXCEPTION
8459: WHEN OTHERS THEN
8460: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
8461: IF (g_error_message IS NULL) THEN

Line 8466: l_retcode := fnd_api.g_ret_sts_unexp_error;

8462: g_error_message := 'VERIFY_CHANGES: ' || SQLERRM;
8463: END IF;
8464: g_error_api_path := SUBSTR('VERIFY_CHANGES:' || g_error_api_path,1,230);
8465: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES', 'VERIFY_CHANGES');
8466: l_retcode := fnd_api.g_ret_sts_unexp_error;
8467: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving verify_changes
8468: p_payroll_id: ' || p_payroll_id || '
8469: p_assignment_id: ' || p_assignment_id || '
8470: p_business_group_id: ' || p_business_group_id || '

Line 8554: p_return_status := fnd_api.g_ret_sts_success;

8550: AND pelh.assignment_id = p_assignment_id
8551: AND pelh.payroll_id = p_payroll_id);
8552: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' No of liquidation lines created: ' || SQL%ROWCOUNT);
8553:
8554: p_return_status := fnd_api.g_ret_sts_success;
8555: EXCEPTION
8556: WHEN OTHERS THEN
8557: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
8558: IF (g_error_message IS NULL) THEN

Line 8563: p_return_status := fnd_api.g_ret_sts_unexp_error;

8559: g_error_message := 'CREATE_LIQ_LINES: ' || SQLERRM;
8560: END IF;
8561: g_error_api_path := SUBSTR('CREATE_LIQ_LINES:' || g_error_api_path,1,230);
8562: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LIQ_LINES');
8563: p_return_status := fnd_api.g_ret_sts_unexp_error;
8564: END create_liq_lines;
8565:
8566: PROCEDURE create_sum_lines (p_payroll_action_id IN NUMBER,
8567: p_payroll_id IN NUMBER,

Line 8775: p_return_status := fnd_api.g_ret_sts_success;

8771: AND NVL(pel.expenditure_organization_id, -99) = NVL(t_sum_lines.expenditure_organization_id(recno), -99)
8772: AND pel.dr_cr_flag = t_sum_lines.dr_cr_flag(recno)
8773: AND pel.gl_project_flag = t_sum_lines.gl_project_flag(recno);
8774: END IF;
8775: p_return_status := fnd_api.g_ret_sts_success;
8776: EXCEPTION
8777: WHEN OTHERS THEN
8778: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
8779: IF (g_error_message IS NULL) THEN

Line 8784: p_return_status := fnd_api.g_ret_sts_unexp_error;

8780: g_error_message := 'CREATE_SUM_LINES: ' || SQLERRM;
8781: END IF;
8782: g_error_api_path := SUBSTR('CREATE_SUM_LINES:' || g_error_api_path,1,230);
8783: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_SUM_LINES');
8784: p_return_status := fnd_api.g_ret_sts_unexp_error;
8785: END create_sum_lines;
8786:
8787: PROCEDURE enc_pre_process (p_payroll_action_id IN NUMBER,
8788: p_payroll_id IN NUMBER,

Line 9024: IF l_return_status <> fnd_api.g_ret_sts_success THEN

9020: p_payroll_id => p_payroll_id,
9021: p_business_group_id => l_business_group_id,
9022: p_set_of_books_id => l_set_of_books_id,
9023: p_return_status => l_return_status);
9024: IF l_return_status <> fnd_api.g_ret_sts_success THEN
9025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9026: END IF;
9027: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed psp_enc_pre_process.poeta_pre_process');
9028:

Line 9025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9021: p_business_group_id => l_business_group_id,
9022: p_set_of_books_id => l_set_of_books_id,
9023: p_return_status => l_return_status);
9024: IF l_return_status <> fnd_api.g_ret_sts_success THEN
9025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9026: END IF;
9027: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed psp_enc_pre_process.poeta_pre_process');
9028:
9029: IF (l_pre_process_mode <>'F') THEN

Line 9035: IF l_return_status <> fnd_api.g_ret_sts_success THEN

9031: (p_enc_line_type => 'U',
9032: p_payroll_id => p_payroll_id,
9033: p_return_status => l_return_status);
9034:
9035: IF l_return_status <> fnd_api.g_ret_sts_success THEN
9036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9037: END IF;
9038: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed psp_enc_pre_process.labor_schedule_pre_process');
9039: END IF;

Line 9036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9032: p_payroll_id => p_payroll_id,
9033: p_return_status => l_return_status);
9034:
9035: IF l_return_status <> fnd_api.g_ret_sts_success THEN
9036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9037: END IF;
9038: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed psp_enc_pre_process.labor_schedule_pre_process');
9039: END IF;
9040:

Line 10055: p_return_status := fnd_api.g_ret_sts_success;

10051: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_PRE_PROCESS
10052: p_payroll_action_id: ' || p_payroll_action_id || '
10053: p_payroll_id: ' || p_payroll_id || '
10054: p_process_mode: ' || p_process_mode);
10055: p_return_status := fnd_api.g_ret_sts_success;
10056: EXCEPTION
10057: WHEN OTHERS THEN
10058: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
10059: IF (g_error_message IS NULL) THEN

Line 10063: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);

10059: IF (g_error_message IS NULL) THEN
10060: g_error_message := 'PSP_ENC_PROCESS: ' || SQLERRM;
10061: END IF;
10062: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ENC_PRE_PROCESS: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
10063: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
10064: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_PRE_PROCESS
10065: p_payroll_action_id: ' || p_payroll_action_id || '
10066: p_payroll_id: ' || p_payroll_id || '
10067: p_process_mode: ' || p_process_mode);

Line 10068: p_return_status := fnd_api.g_ret_sts_unexp_error;

10064: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_PRE_PROCESS
10065: p_payroll_action_id: ' || p_payroll_action_id || '
10066: p_payroll_id: ' || p_payroll_id || '
10067: p_process_mode: ' || p_process_mode);
10068: p_return_status := fnd_api.g_ret_sts_unexp_error;
10069: END enc_pre_process;
10070:
10071: PROCEDURE rollback_cel (errbuf OUT NOCOPY VARCHAR2,
10072: retcode OUT NOCOPY VARCHAR2,

Line 10312: retcode := fnd_api.g_ret_sts_success;

10308: END IF;
10309:
10310: COMMIT;
10311: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);
10312: retcode := fnd_api.g_ret_sts_success;
10313: EXCEPTION
10314: WHEN OTHERS THEN
10315: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
10316: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ROLLBACK_CEL: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);

Line 10317: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);

10313: EXCEPTION
10314: WHEN OTHERS THEN
10315: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
10316: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ROLLBACK_CEL: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
10317: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
10318: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);
10319: retcode := fnd_api.g_ret_sts_unexp_error;
10320: END rollback_cel;
10321:

Line 10319: retcode := fnd_api.g_ret_sts_unexp_error;

10315: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
10316: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ROLLBACK_CEL: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
10317: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
10318: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);
10319: retcode := fnd_api.g_ret_sts_unexp_error;
10320: END rollback_cel;
10321:
10322: PROCEDURE load_sch_hierarchy (p_assignment_id IN NUMBER,
10323: p_payroll_id IN NUMBER,

Line 11262: IF p_return_status <> fnd_api.g_ret_sts_success THEN

11258: p_start_date => r_gee.poeta_start_date(recno),
11259: p_end_date => r_gee.poeta_end_date(recno),
11260: p_return_status => p_return_status);
11261:
11262: IF p_return_status <> fnd_api.g_ret_sts_success THEN
11263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11264: END IF;
11265: END IF;
11266: g_pateo_end_date := GREATEST(g_pateo_end_date, NVL(r_gee.poeta_end_date(recno), g_pateo_end_date));

Line 11263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11259: p_end_date => r_gee.poeta_end_date(recno),
11260: p_return_status => p_return_status);
11261:
11262: IF p_return_status <> fnd_api.g_ret_sts_success THEN
11263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11264: END IF;
11265: END IF;
11266: g_pateo_end_date := GREATEST(g_pateo_end_date, NVL(r_gee.poeta_end_date(recno), g_pateo_end_date));
11267: END LOOP;

Line 11310: IF p_return_status <> fnd_api.g_ret_sts_success THEN

11306: p_start_date => r_et.poeta_start_date(recno),
11307: p_end_date => r_et.poeta_end_date(recno),
11308: p_return_status => p_return_status);
11309:
11310: IF p_return_status <> fnd_api.g_ret_sts_success THEN
11311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11312: END IF;
11313: END IF;
11314: g_pateo_end_date := GREATEST(g_pateo_end_date, NVL(r_et.poeta_end_date(recno), g_pateo_end_date));

Line 11311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11307: p_end_date => r_et.poeta_end_date(recno),
11308: p_return_status => p_return_status);
11309:
11310: IF p_return_status <> fnd_api.g_ret_sts_success THEN
11311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11312: END IF;
11313: END IF;
11314: g_pateo_end_date := GREATEST(g_pateo_end_date, NVL(r_et.poeta_end_date(recno), g_pateo_end_date));
11315: END LOOP;

Line 11358: IF p_return_status <> fnd_api.g_ret_sts_success THEN

11354: p_start_date => r_ec.poeta_start_date(recno),
11355: p_end_date => r_ec.poeta_end_date(recno),
11356: p_return_status => p_return_status);
11357:
11358: IF p_return_status <> fnd_api.g_ret_sts_success THEN
11359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11360: END IF;
11361: END IF;
11362: g_pateo_end_date := GREATEST(g_pateo_end_date, NVL(r_ec.poeta_end_date(recno), g_pateo_end_date));

Line 11359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11355: p_end_date => r_ec.poeta_end_date(recno),
11356: p_return_status => p_return_status);
11357:
11358: IF p_return_status <> fnd_api.g_ret_sts_success THEN
11359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11360: END IF;
11361: END IF;
11362: g_pateo_end_date := GREATEST(g_pateo_end_date, NVL(r_ec.poeta_end_date(recno), g_pateo_end_date));
11363: END LOOP;

Line 11406: IF p_return_status <> fnd_api.g_ret_sts_success THEN

11402: p_start_date => r_asg.poeta_start_date(recno),
11403: p_end_date => r_asg.poeta_end_date(recno),
11404: p_return_status => p_return_status);
11405:
11406: IF p_return_status <> fnd_api.g_ret_sts_success THEN
11407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11408: END IF;
11409: END IF;
11410: g_pateo_end_date := GREATEST(g_pateo_end_date, NVL(r_asg.poeta_end_date(recno), g_pateo_end_date));

Line 11407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11403: p_end_date => r_asg.poeta_end_date(recno),
11404: p_return_status => p_return_status);
11405:
11406: IF p_return_status <> fnd_api.g_ret_sts_success THEN
11407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11408: END IF;
11409: END IF;
11410: g_pateo_end_date := GREATEST(g_pateo_end_date, NVL(r_asg.poeta_end_date(recno), g_pateo_end_date));
11411: END LOOP;

Line 11454: IF p_return_status <> fnd_api.g_ret_sts_success THEN

11450: p_start_date => r_odls.poeta_start_date(recno),
11451: p_end_date => r_odls.poeta_end_date(recno),
11452: p_return_status => p_return_status);
11453:
11454: IF p_return_status <> fnd_api.g_ret_sts_success THEN
11455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11456: END IF;
11457: END IF;
11458: g_pateo_end_date := GREATEST(g_pateo_end_date, NVL(r_odls.poeta_end_date(recno), g_pateo_end_date));

Line 11455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11451: p_end_date => r_odls.poeta_end_date(recno),
11452: p_return_status => p_return_status);
11453:
11454: IF p_return_status <> fnd_api.g_ret_sts_success THEN
11455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11456: END IF;
11457: END IF;
11458: g_pateo_end_date := GREATEST(g_pateo_end_date, NVL(r_odls.poeta_end_date(recno), g_pateo_end_date));
11459: END LOOP;

Line 11502: IF p_return_status <> fnd_api.g_ret_sts_success THEN

11498: p_start_date => r_da.poeta_start_date(recno),
11499: p_end_date => r_da.poeta_end_date(recno),
11500: p_return_status => p_return_status);
11501:
11502: IF p_return_status <> fnd_api.g_ret_sts_success THEN
11503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11504: END IF;
11505: END IF;
11506: g_pateo_end_date := GREATEST(g_pateo_end_date, NVL(r_da.poeta_end_date(recno), g_pateo_end_date));

Line 11503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11499: p_end_date => r_da.poeta_end_date(recno),
11500: p_return_status => p_return_status);
11501:
11502: IF p_return_status <> fnd_api.g_ret_sts_success THEN
11503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11504: END IF;
11505: END IF;
11506: g_pateo_end_date := GREATEST(g_pateo_end_date, NVL(r_da.poeta_end_date(recno), g_pateo_end_date));
11507: END LOOP;

Line 11550: IF p_return_status <> fnd_api.g_ret_sts_success THEN

11546: p_start_date => r_sa.poeta_start_date(recno),
11547: p_end_date => r_sa.poeta_end_date(recno),
11548: p_return_status => p_return_status);
11549:
11550: IF p_return_status <> fnd_api.g_ret_sts_success THEN
11551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11552: END IF;
11553: END IF;
11554: g_pateo_end_date := GREATEST(g_pateo_end_date, NVL(r_sa.poeta_end_date(recno), g_pateo_end_date));

Line 11551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11547: p_end_date => r_sa.poeta_end_date(recno),
11548: p_return_status => p_return_status);
11549:
11550: IF p_return_status <> fnd_api.g_ret_sts_success THEN
11551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11552: END IF;
11553: END IF;
11554: g_pateo_end_date := GREATEST(g_pateo_end_date, NVL(r_sa.poeta_end_date(recno), g_pateo_end_date));
11555: END LOOP;

Line 11564: p_return_status := fnd_api.g_ret_sts_success;

11560: END IF;
11561: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_pateo_end_date: ' || TO_CHAR(g_pateo_end_date, 'DD-MON-RRRR'));
11562:
11563: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving LOAD_SCH_HIERARCHY');
11564: p_return_status := fnd_api.g_ret_sts_success;
11565: EXCEPTION
11566: WHEN OTHERS THEN
11567: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
11568: IF (g_error_message IS NULL) THEN

Line 11573: p_return_status := fnd_api.g_ret_sts_unexp_error;

11569: g_error_message := 'LOAD_SCH_HIERARCHY: ' || SQLERRM;
11570: END IF;
11571: g_error_api_path := SUBSTR(' LOAD_SCH_HIERARCHY:'||g_error_api_path,1,230);
11572: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' LOAD_SCH_HIERARCHY');
11573: p_return_status := fnd_api.g_ret_sts_unexp_error;
11574: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' ' || fnd_number.number_to_canonical(l_proc_step) || ': LOAD_SCH_HIERARCHY');
11575: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving LOAD_SCH_HIERARCHY');
11576: END load_sch_hierarchy;
11577:

Line 12134: p_return_status := fnd_api.g_ret_sts_success;

12130: AND expenditure_type = t_enc_nlines.exp_type(recno)
12131: AND enc_start_date <= t_enc_nlines.enc_end_date(recno)
12132: AND enc_end_date >= t_enc_nlines.enc_start_date(recno);
12133: END IF;
12134: p_return_status := fnd_api.g_ret_sts_success;
12135: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving UPDATE_HIERARCHY_DATES');
12136: EXCEPTION
12137: WHEN OTHERS THEN
12138: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

Line 12144: p_return_status := fnd_api.g_ret_sts_unexp_error;

12140: g_error_message := 'UPDATE_HIERARCHY_DATES: ' || SQLERRM;
12141: END IF;
12142: g_error_api_path := SUBSTR(' UPDATE_HIERARCHY_DATES:'||g_error_api_path,1,230);
12143: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' UPDATE_HIERARCHY_DATES');
12144: p_return_status := fnd_api.g_ret_sts_unexp_error;
12145: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving UPDATE_HIERARCHY_DATES');
12146: END update_hierarchy_dates;
12147:
12148: PROCEDURE clear_sch_hierarchy IS