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_PAYTRN dependencies on PSP_PAYTRN

Line 1: PACKAGE BODY PSP_PAYTRN AS

1: PACKAGE BODY PSP_PAYTRN AS
2: /* $Header: PSPPIPLB.pls 120.34.12020000.5 2013/03/27 00:40:32 lkodaman ship $ */
3:
4: -- Introduced the following for bug fix 2916848
5: g_precision NUMBER;

Line 84: l_api_name varchar2(30) := 'PSP_PAYTRN';

80: l_msg_count number;
81: l_msg_data varchar2(2000);
82: l_msg_index_out number;
83: --
84: l_api_name varchar2(30) := 'PSP_PAYTRN';
85: l_subline_message varchar2(200);
86: l_TGL_REVB_ACC_DATE varchar2(80); -- added for 3108109
87: l_TGL_DATE_USED varchar2(80); -- added for 3108109
88: l_prev_accounting_date date := to_date('01/01/1900','dd/mm/yyyy'); -- added for 3108109

Line 1818: l_error_api_name := 'PSP_PAYTRN : error at GET_DIFFERECE_CSR';

1814: -- Insert rounding routine here
1815: open get_difference_csr;
1816: fetch get_difference_csr into l_subline_sum;
1817: if get_difference_csr%NOTFOUND then
1818: l_error_api_name := 'PSP_PAYTRN : error at GET_DIFFERECE_CSR';
1819: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1820: end if;
1821: close get_difference_csr;
1822: -- Added daily rate not equal to 0 to where clause to fix bug no 89157

Line 1831: l_error_api_name := 'PSP_PAYTRN : error while updating subline for rounding';

1827: NVL(daily_rate,0) <> 0 and
1828: pay_amount <> 0 and --- rounding difference to nonzero amount .. 4670588
1829: rownum = 1;
1830: if SQL%NOTFOUND then
1831: l_error_api_name := 'PSP_PAYTRN : error while updating subline for rounding';
1832: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1833: end if;
1834: end if;
1835:

Line 1950: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','Error while Updating Sublines Total in Payroll Controls ');

1946: dr_cr_flag = 'C'))
1947: where payroll_control_id = r_payroll_control_array.r_payroll_control_id(K);
1948:
1949: IF sql%NOTFOUND then
1950: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','Error while Updating Sublines Total in Payroll Controls ');
1951: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1952: END IF;
1953:
1954: IF l_total_num_rec=0 then

Line 2102: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','IMPORT_PAY_TRNS');

2098:
2099: WHEN OTHERS then
2100: retcode := 2;
2101: rollback;
2102: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','IMPORT_PAY_TRNS');
2103:
2104:
2105: psp_message_s.print_error(p_mode=>FND_FILE.log,
2106: p_print_header=>FND_API.G_TRUE

Line 2211: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','UPDATE_WCAL_ASG_END_DATE');

2207: return;
2208: EXCEPTION
2209: WHEN OTHERS then
2210: ------dbms_output.put_line('When others Error...........');
2211: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','UPDATE_WCAL_ASG_END_DATE');
2212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2213:
2214: end;
2215:

Line 2307: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','UPDATE_WCAL_ASG_BEGIN_DATE',SUBSTR(SQLERRM,1,100));

2303: return;
2304: EXCEPTION
2305: WHEN OTHERS then
2306: -- ------dbms_output.put_line('When others Error...........'||SUBSTR(SQLERRM,1,200));
2307: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','UPDATE_WCAL_ASG_BEGIN_DATE',SUBSTR(SQLERRM,1,100));
2308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2309:
2310: end;
2311:

Line 2362: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','UPDATE_WCAL_ASG_BEGIN_DATE');

2358: return;
2359: EXCEPTION
2360: WHEN OTHERS then
2361: ----dbms_output.put_line('When others Error...........');
2362: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','UPDATE_WCAL_ASG_BEGIN_DATE');
2363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2364:
2365: end;
2366: */

Line 2422: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','UPDATE_WCAL_ASG_STATUS');

2418: return;
2419: EXCEPTION
2420: WHEN OTHERS then
2421: close get_asg_status_csr;
2422: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','UPDATE_WCAL_ASG_STATUS');
2423: x_return_status := FND_API.G_RET_STS_SUCCESS;
2424: return;
2425: end UPDATE_WCAL_ASG_STATUS;
2426: --

Line 2793: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_DAILY_RATE_CALENDAR');

2789: --dbms_output.PUT_LINE( 'Previous Salary ' || to_char(l_previous_salary));
2790: close get_previous_proposal_csr;
2791: x_return_status := FND_API.G_RET_STS_SUCCESS;
2792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
2793: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_DAILY_RATE_CALENDAR');
2794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2795:
2796: WHEN OTHERS then
2797: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_DAILY_RATE_CALENDAR');

Line 2797: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_DAILY_RATE_CALENDAR');

2793: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_DAILY_RATE_CALENDAR');
2794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2795:
2796: WHEN OTHERS then
2797: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_DAILY_RATE_CALENDAR');
2798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2799:
2800: end create_daily_rate_calendar;
2801: ----------------CALCULATE_BALANCE_AMOUNT--------------------------------

Line 2835: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CALCULATE_BALANCE_AMOUNT');

2831: hr_utility.trace(' Leaving CALCULATE_BALANCE_AMOUNT');
2832:
2833: EXCEPTION
2834: WHEN OTHERS then
2835: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CALCULATE_BALANCE_AMOUNT');
2836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2837:
2838: end calculate_balance_amount;
2839: --------------CREATE_SLINE_SALARY_CHANGE-----------------------------------

Line 3249: -- fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_DAILY_RATE_CALENDAR'); Commented for bug fix 2439207

3245:
3246:
3247: EXCEPTION
3248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
3249: -- fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_DAILY_RATE_CALENDAR'); Commented for bug fix 2439207
3250: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_SALARY_CHANGE'); -- Introduced for bug 2439207
3251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3252:
3253: WHEN NO_DATA_FOUND then

Line 3250: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_SALARY_CHANGE'); -- Introduced for bug 2439207

3246:
3247: EXCEPTION
3248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
3249: -- fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_DAILY_RATE_CALENDAR'); Commented for bug fix 2439207
3250: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_SALARY_CHANGE'); -- Introduced for bug 2439207
3251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3252:
3253: WHEN NO_DATA_FOUND then
3254: begin

Line 3408: -- fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_DAILY_RATE_CALENDAR'); Commented for bug fix 2439207

3404: WHEN OTHERS then
3405:
3406: hr_utility.trace(' Failing with the OTHERS exception');
3407: ----dbms_output.PUT_LINE('Error Num : ' || to_char(SQLCODE) || 'Err Msg : ' || SUBSTR(SQLERRM,1,100));
3408: -- fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_DAILY_RATE_CALENDAR'); Commented for bug fix 2439207
3409: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_SALARY_CHANGE'); -- Introduced for bug 2439207
3410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3411:
3412: end CREATE_SLINE_SALARY_CHANGE;

Line 3409: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_SALARY_CHANGE'); -- Introduced for bug 2439207

3405:
3406: hr_utility.trace(' Failing with the OTHERS exception');
3407: ----dbms_output.PUT_LINE('Error Num : ' || to_char(SQLCODE) || 'Err Msg : ' || SUBSTR(SQLERRM,1,100));
3408: -- fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_DAILY_RATE_CALENDAR'); Commented for bug fix 2439207
3409: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_SALARY_CHANGE'); -- Introduced for bug 2439207
3410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3411:
3412: end CREATE_SLINE_SALARY_CHANGE;
3413:

Line 3496: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_ASG_CHANGE');

3492:
3493: EXCEPTION
3494: WHEN OTHERS then
3495: close get_asg_end_date_csr;
3496: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_ASG_CHANGE');
3497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3498:
3499: end CREATE_SLINE_ASG_CHANGE;
3500:

Line 4244: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_ASG_STATUS_CHANGE');

4240: close get_sublines_csr;
4241: x_return_status := FND_API.G_RET_STS_SUCCESS;
4242: EXCEPTION
4243: WHEN OTHERS then
4244: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_ASG_STATUS_CHANGE');
4245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4246: close get_sublines_csr;
4247: end;
4248: END LOOP;

Line 4259: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_ASG_STATUS_CHANGE');

4255: x_return_status := FND_API.G_RET_STS_SUCCESS;
4256: close get_asg_status_csr;
4257:
4258: WHEN OTHERS then
4259: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_ASG_STATUS_CHANGE');
4260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4261: close get_asg_status_csr;
4262:
4263: end create_sline_asg_status_change;

Line 4539: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_EMP_END_DATE');

4535: hr_utility.trace(' Leaving CREATE_SLINE_EMP_END_DATE');
4536:
4537: EXCEPTION
4538: WHEN OTHERS then
4539: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_EMP_END_DATE');
4540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4541: end create_sline_emp_end_date;
4542: ------------------------------CREATE_SLINE_ORG_CHANGE-------------------
4543: ---

Line 5129: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_ORG_CHANGE');

5125: WHEN NO_DATA_FOUND then
5126: x_return_status := FND_API.G_RET_STS_SUCCESS;
5127: close get_assg_csr;
5128: WHEN OTHERS then
5129: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_ORG_CHANGE');
5130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5131: close get_assg_csr;
5132:
5133: end create_sline_org_change;

Line 5707: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_JOB_CHANGE');

5703: WHEN NO_DATA_FOUND then
5704: x_return_status := FND_API.G_RET_STS_SUCCESS;
5705: close get_sublines_csr;
5706: WHEN OTHERS then
5707: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_JOB_CHANGE');
5708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5709: close get_sublines_csr;
5710: end;
5711: end if;

Line 5721: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_JOB_CHANGE');

5717: WHEN NO_DATA_FOUND then
5718: x_return_status := FND_API.G_RET_STS_SUCCESS;
5719: close get_assg_csr;
5720: WHEN OTHERS then
5721: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_JOB_CHANGE');
5722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5723: close get_assg_csr;
5724: end create_sline_job_change;
5725: --------------------------------CREATE_SLINE_POSITION_CHANGE--------------

Line 6297: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_POSITION_CHANGE');

6293: WHEN NO_DATA_FOUND then
6294: x_return_status := FND_API.G_RET_STS_SUCCESS;
6295: close get_sublines_csr;
6296: WHEN OTHERS then
6297: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_POSITION_CHANGE');
6298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6299: close get_sublines_csr;
6300: end;
6301: end if;

Line 6311: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_POSITION_CHANGE');

6307: WHEN NO_DATA_FOUND then
6308: x_return_status := FND_API.G_RET_STS_SUCCESS;
6309: close get_assg_csr;
6310: WHEN OTHERS then
6311: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_POSITION_CHANGE');
6312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6313: close get_assg_csr;
6314:
6315: end create_sline_position_change;

Line 6889: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_GRADE_CHANGE');

6885: WHEN NO_DATA_FOUND then
6886: x_return_status := FND_API.G_RET_STS_SUCCESS;
6887: close get_sublines_csr;
6888: WHEN OTHERS then
6889: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_GRADE_CHANGE');
6890: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6891: close get_sublines_csr;
6892: end;
6893: end if;

Line 6902: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_GRADE_CHANGE');

6898: WHEN NO_DATA_FOUND then
6899: x_return_status := FND_API.G_RET_STS_SUCCESS;
6900: close get_assg_csr;
6901: WHEN OTHERS then
6902: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_GRADE_CHANGE');
6903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6904: close get_assg_csr;
6905:
6906: end create_sline_grade_change;

Line 7483: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_POSITION_CHANGE');

7479: WHEN NO_DATA_FOUND then
7480: x_return_status := FND_API.G_RET_STS_SUCCESS;
7481: close get_sublines_csr;
7482: WHEN OTHERS then
7483: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_POSITION_CHANGE');
7484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7485: close get_sublines_csr;
7486: end;
7487: end if;

Line 7497: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_PPGROUP_CHANGE');

7493: WHEN NO_DATA_FOUND then
7494: x_return_status := FND_API.G_RET_STS_SUCCESS;
7495: close get_assg_csr;
7496: WHEN OTHERS then
7497: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_PPGROUP_CHANGE');
7498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7499: close get_assg_csr;
7500:
7501: end create_sline_ppgroup_change;

Line 8157: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_FTE_CHANGE');

8153: close get_sublines_csr;
8154: x_return_status := FND_API.G_RET_STS_SUCCESS;
8155: EXCEPTION
8156: WHEN OTHERS then
8157: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_FTE_CHANGE');
8158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8159: close get_sublines_csr;
8160: end;
8161: end if;

Line 8169: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_FTE_CHANGE');

8165: x_return_status := FND_API.G_RET_STS_SUCCESS;
8166: hr_utility.trace(' Leaving CREATE_SLINE_FTE_CHANGE');
8167: EXCEPTION
8168: WHEN OTHERS then
8169: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_FTE_CHANGE');
8170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8171: dbms_sql.close_cursor(l_cur_handle);
8172:
8173: end create_sline_fte_change;

Line 8765: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_BUDGET_CHANGE');

8761: WHEN NO_DATA_FOUND then
8762: x_return_status := FND_API.G_RET_STS_SUCCESS;
8763: close get_sublines_csr;
8764: WHEN OTHERS then
8765: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_BUDGET_CHANGE');
8766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8767: close get_sublines_csr;
8768: end;
8769: end if;

Line 8779: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_BUDGET_CHANGE');

8775: WHEN NO_DATA_FOUND then
8776: x_return_status := FND_API.G_RET_STS_SUCCESS;
8777: close get_assg_csr;
8778: WHEN OTHERS then
8779: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_BUDGET_CHANGE');
8780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8781: close get_assg_csr;
8782:
8783: end create_sline_budget_change;

Line 8882: -- fnd_msg_pub.add_exc_msg('PSP-PAYTRN','CHECK_ZERO_WORK_DAYS','Assg_ID '||x_assignment_id||' Amt '||x_costed_value);

8878: fnd_message.set_token('ASSIGNMENT_NO',l_assignment_number);
8879: fnd_message.set_token('LINE_AMT',x_costed_value );
8880: fnd_msg_pub.add;
8881:
8882: -- fnd_msg_pub.add_exc_msg('PSP-PAYTRN','CHECK_ZERO_WORK_DAYS','Assg_ID '||x_assignment_id||' Amt '||x_costed_value);
8883: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
8884:
8885: END check_zero_work_days;
8886:

Line 8993: FND_MSG_PUB.ADD_EXC_MSG('PSP_PAYTRN','CREATE_SLINE_TERM_EMP');

8989: hr_utility.trace(' Leaving CREATE_SLINE_TERM_EMP');
8990:
8991: EXCEPTION
8992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8993: FND_MSG_PUB.ADD_EXC_MSG('PSP_PAYTRN','CREATE_SLINE_TERM_EMP');
8994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8995: WHEN OTHERS THEN
8996: FND_MSG_PUB.ADD_EXC_MSG('PSP_PAYTRN','CREATE_SLINE_TERM_EMP');
8997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8996: FND_MSG_PUB.ADD_EXC_MSG('PSP_PAYTRN','CREATE_SLINE_TERM_EMP');

8992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8993: FND_MSG_PUB.ADD_EXC_MSG('PSP_PAYTRN','CREATE_SLINE_TERM_EMP');
8994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8995: WHEN OTHERS THEN
8996: FND_MSG_PUB.ADD_EXC_MSG('PSP_PAYTRN','CREATE_SLINE_TERM_EMP');
8997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8998:
8999: END create_sline_term_emp;
9000: --======================= End of procedure =================

Line 9177: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_PRORATE_CALENDAR');

9173: p_return_status := FND_API.G_RET_STS_SUCCESS;
9174: hr_utility.trace(' Leaving CREATE PRORATE CALENDAR');
9175: EXCEPTION
9176: WHEN fnd_api.g_exc_unexpected_error THEN
9177: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_PRORATE_CALENDAR');
9178: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9179: WHEN OTHERS THEN
9180: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_PRORATE_CALENDAR');
9181: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9180: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_PRORATE_CALENDAR');

9176: WHEN fnd_api.g_exc_unexpected_error THEN
9177: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_PRORATE_CALENDAR');
9178: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9179: WHEN OTHERS THEN
9180: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_PRORATE_CALENDAR');
9181: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9182: END create_prorate_calendar;
9183:
9184: END PSP_PAYTRN; -- End of Package Body

Line 9184: END PSP_PAYTRN; -- End of Package Body

9180: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_PRORATE_CALENDAR');
9181: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9182: END create_prorate_calendar;
9183:
9184: END PSP_PAYTRN; -- End of Package Body