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.28.12010000.5 2008/10/17 07:54:16 aniagarw 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 1756: l_error_api_name := 'PSP_PAYTRN : error at GET_DIFFERECE_CSR';

1752: -- Insert rounding routine here
1753: open get_difference_csr;
1754: fetch get_difference_csr into l_subline_sum;
1755: if get_difference_csr%NOTFOUND then
1756: l_error_api_name := 'PSP_PAYTRN : error at GET_DIFFERECE_CSR';
1757: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1758: end if;
1759: close get_difference_csr;
1760: -- Added daily rate not equal to 0 to where clause to fix bug no 89157

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

1765: NVL(daily_rate,0) <> 0 and
1766: pay_amount <> 0 and --- rounding difference to nonzero amount .. 4670588
1767: rownum = 1;
1768: if SQL%NOTFOUND then
1769: l_error_api_name := 'PSP_PAYTRN : error while updating subline for rounding';
1770: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1771: end if;
1772: end if;
1773:

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

1872: dr_cr_flag = 'C'))
1873: where payroll_control_id = r_payroll_control_array.r_payroll_control_id(K);
1874:
1875: IF sql%NOTFOUND then
1876: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','Error while Updating Sublines Total in Payroll Controls ');
1877: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1878: END IF;
1879:
1880: IF l_total_num_rec=0 then

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

2024:
2025: WHEN OTHERS then
2026: retcode := 2;
2027: rollback;
2028: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','IMPORT_PAY_TRNS');
2029:
2030:
2031: psp_message_s.print_error(p_mode=>FND_FILE.log,
2032: p_print_header=>FND_API.G_TRUE

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

2133: return;
2134: EXCEPTION
2135: WHEN OTHERS then
2136: ------dbms_output.put_line('When others Error...........');
2137: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','UPDATE_WCAL_ASG_END_DATE');
2138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2139:
2140: end;
2141:

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

2229: return;
2230: EXCEPTION
2231: WHEN OTHERS then
2232: -- ------dbms_output.put_line('When others Error...........'||SUBSTR(SQLERRM,1,200));
2233: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','UPDATE_WCAL_ASG_BEGIN_DATE',SUBSTR(SQLERRM,1,100));
2234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2235:
2236: end;
2237:

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

2284: return;
2285: EXCEPTION
2286: WHEN OTHERS then
2287: ----dbms_output.put_line('When others Error...........');
2288: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','UPDATE_WCAL_ASG_BEGIN_DATE');
2289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2290:
2291: end;
2292: */

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

2344: return;
2345: EXCEPTION
2346: WHEN OTHERS then
2347: close get_asg_status_csr;
2348: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','UPDATE_WCAL_ASG_STATUS');
2349: x_return_status := FND_API.G_RET_STS_SUCCESS;
2350: return;
2351: end UPDATE_WCAL_ASG_STATUS;
2352: --

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

2715: --dbms_output.PUT_LINE( 'Previous Salary ' || to_char(l_previous_salary));
2716: close get_previous_proposal_csr;
2717: x_return_status := FND_API.G_RET_STS_SUCCESS;
2718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
2719: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_DAILY_RATE_CALENDAR');
2720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2721:
2722: WHEN OTHERS then
2723: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_DAILY_RATE_CALENDAR');

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

2719: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_DAILY_RATE_CALENDAR');
2720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2721:
2722: WHEN OTHERS then
2723: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_DAILY_RATE_CALENDAR');
2724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2725:
2726: end create_daily_rate_calendar;
2727: ----------------CALCULATE_BALANCE_AMOUNT--------------------------------

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

2757: hr_utility.trace(' Leaving CALCULATE_BALANCE_AMOUNT');
2758:
2759: EXCEPTION
2760: WHEN OTHERS then
2761: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CALCULATE_BALANCE_AMOUNT');
2762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2763:
2764: end calculate_balance_amount;
2765: --------------CREATE_SLINE_SALARY_CHANGE-----------------------------------

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

3171:
3172:
3173: EXCEPTION
3174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
3175: -- fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_DAILY_RATE_CALENDAR'); Commented for bug fix 2439207
3176: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_SALARY_CHANGE'); -- Introduced for bug 2439207
3177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3178:
3179: WHEN NO_DATA_FOUND then

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

3172:
3173: EXCEPTION
3174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
3175: -- fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_DAILY_RATE_CALENDAR'); Commented for bug fix 2439207
3176: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_SALARY_CHANGE'); -- Introduced for bug 2439207
3177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3178:
3179: WHEN NO_DATA_FOUND then
3180: begin

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

3330: WHEN OTHERS then
3331:
3332: hr_utility.trace(' Failing with the OTHERS exception');
3333: ----dbms_output.PUT_LINE('Error Num : ' || to_char(SQLCODE) || 'Err Msg : ' || SUBSTR(SQLERRM,1,100));
3334: -- fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_DAILY_RATE_CALENDAR'); Commented for bug fix 2439207
3335: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_SALARY_CHANGE'); -- Introduced for bug 2439207
3336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3337:
3338: end CREATE_SLINE_SALARY_CHANGE;

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

3331:
3332: hr_utility.trace(' Failing with the OTHERS exception');
3333: ----dbms_output.PUT_LINE('Error Num : ' || to_char(SQLCODE) || 'Err Msg : ' || SUBSTR(SQLERRM,1,100));
3334: -- fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_DAILY_RATE_CALENDAR'); Commented for bug fix 2439207
3335: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_SALARY_CHANGE'); -- Introduced for bug 2439207
3336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3337:
3338: end CREATE_SLINE_SALARY_CHANGE;
3339:

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

3418:
3419: EXCEPTION
3420: WHEN OTHERS then
3421: close get_asg_end_date_csr;
3422: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_ASG_CHANGE');
3423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3424:
3425: end CREATE_SLINE_ASG_CHANGE;
3426:

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

4166: close get_sublines_csr;
4167: x_return_status := FND_API.G_RET_STS_SUCCESS;
4168: EXCEPTION
4169: WHEN OTHERS then
4170: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_ASG_STATUS_CHANGE');
4171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4172: close get_sublines_csr;
4173: end;
4174: END LOOP;

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

4181: x_return_status := FND_API.G_RET_STS_SUCCESS;
4182: close get_asg_status_csr;
4183:
4184: WHEN OTHERS then
4185: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_ASG_STATUS_CHANGE');
4186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4187: close get_asg_status_csr;
4188:
4189: end create_sline_asg_status_change;

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

4461: hr_utility.trace(' Leaving CREATE_SLINE_EMP_END_DATE');
4462:
4463: EXCEPTION
4464: WHEN OTHERS then
4465: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_EMP_END_DATE');
4466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4467: end create_sline_emp_end_date;
4468: ------------------------------CREATE_SLINE_ORG_CHANGE-------------------
4469: ---

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

5051: WHEN NO_DATA_FOUND then
5052: x_return_status := FND_API.G_RET_STS_SUCCESS;
5053: close get_assg_csr;
5054: WHEN OTHERS then
5055: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_ORG_CHANGE');
5056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5057: close get_assg_csr;
5058:
5059: end create_sline_org_change;

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

5629: WHEN NO_DATA_FOUND then
5630: x_return_status := FND_API.G_RET_STS_SUCCESS;
5631: close get_sublines_csr;
5632: WHEN OTHERS then
5633: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_JOB_CHANGE');
5634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5635: close get_sublines_csr;
5636: end;
5637: end if;

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

5643: WHEN NO_DATA_FOUND then
5644: x_return_status := FND_API.G_RET_STS_SUCCESS;
5645: close get_assg_csr;
5646: WHEN OTHERS then
5647: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_JOB_CHANGE');
5648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5649: close get_assg_csr;
5650: end create_sline_job_change;
5651: --------------------------------CREATE_SLINE_POSITION_CHANGE--------------

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

6219: WHEN NO_DATA_FOUND then
6220: x_return_status := FND_API.G_RET_STS_SUCCESS;
6221: close get_sublines_csr;
6222: WHEN OTHERS then
6223: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_POSITION_CHANGE');
6224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6225: close get_sublines_csr;
6226: end;
6227: end if;

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

6233: WHEN NO_DATA_FOUND then
6234: x_return_status := FND_API.G_RET_STS_SUCCESS;
6235: close get_assg_csr;
6236: WHEN OTHERS then
6237: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_POSITION_CHANGE');
6238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6239: close get_assg_csr;
6240:
6241: end create_sline_position_change;

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

6811: WHEN NO_DATA_FOUND then
6812: x_return_status := FND_API.G_RET_STS_SUCCESS;
6813: close get_sublines_csr;
6814: WHEN OTHERS then
6815: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_GRADE_CHANGE');
6816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6817: close get_sublines_csr;
6818: end;
6819: end if;

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

6824: WHEN NO_DATA_FOUND then
6825: x_return_status := FND_API.G_RET_STS_SUCCESS;
6826: close get_assg_csr;
6827: WHEN OTHERS then
6828: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_GRADE_CHANGE');
6829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6830: close get_assg_csr;
6831:
6832: end create_sline_grade_change;

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

7405: WHEN NO_DATA_FOUND then
7406: x_return_status := FND_API.G_RET_STS_SUCCESS;
7407: close get_sublines_csr;
7408: WHEN OTHERS then
7409: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_POSITION_CHANGE');
7410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7411: close get_sublines_csr;
7412: end;
7413: end if;

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

7419: WHEN NO_DATA_FOUND then
7420: x_return_status := FND_API.G_RET_STS_SUCCESS;
7421: close get_assg_csr;
7422: WHEN OTHERS then
7423: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_PPGROUP_CHANGE');
7424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7425: close get_assg_csr;
7426:
7427: end create_sline_ppgroup_change;

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

8079: close get_sublines_csr;
8080: x_return_status := FND_API.G_RET_STS_SUCCESS;
8081: EXCEPTION
8082: WHEN OTHERS then
8083: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_FTE_CHANGE');
8084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8085: close get_sublines_csr;
8086: end;
8087: end if;

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

8091: x_return_status := FND_API.G_RET_STS_SUCCESS;
8092: hr_utility.trace(' Leaving CREATE_SLINE_FTE_CHANGE');
8093: EXCEPTION
8094: WHEN OTHERS then
8095: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_FTE_CHANGE');
8096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8097: dbms_sql.close_cursor(l_cur_handle);
8098:
8099: end create_sline_fte_change;

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

8687: WHEN NO_DATA_FOUND then
8688: x_return_status := FND_API.G_RET_STS_SUCCESS;
8689: close get_sublines_csr;
8690: WHEN OTHERS then
8691: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_BUDGET_CHANGE');
8692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8693: close get_sublines_csr;
8694: end;
8695: end if;

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

8701: WHEN NO_DATA_FOUND then
8702: x_return_status := FND_API.G_RET_STS_SUCCESS;
8703: close get_assg_csr;
8704: WHEN OTHERS then
8705: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_BUDGET_CHANGE');
8706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8707: close get_assg_csr;
8708:
8709: end create_sline_budget_change;

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

8804: fnd_message.set_token('ASSIGNMENT_NO',l_assignment_number);
8805: fnd_message.set_token('LINE_AMT',x_costed_value );
8806: fnd_msg_pub.add;
8807:
8808: -- fnd_msg_pub.add_exc_msg('PSP-PAYTRN','CHECK_ZERO_WORK_DAYS','Assg_ID '||x_assignment_id||' Amt '||x_costed_value);
8809: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
8810:
8811: END check_zero_work_days;
8812:

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

8915: hr_utility.trace(' Leaving CREATE_SLINE_TERM_EMP');
8916:
8917: EXCEPTION
8918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8919: FND_MSG_PUB.ADD_EXC_MSG('PSP_PAYTRN','CREATE_SLINE_TERM_EMP');
8920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8921: WHEN OTHERS THEN
8922: FND_MSG_PUB.ADD_EXC_MSG('PSP_PAYTRN','CREATE_SLINE_TERM_EMP');
8923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

8918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8919: FND_MSG_PUB.ADD_EXC_MSG('PSP_PAYTRN','CREATE_SLINE_TERM_EMP');
8920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8921: WHEN OTHERS THEN
8922: FND_MSG_PUB.ADD_EXC_MSG('PSP_PAYTRN','CREATE_SLINE_TERM_EMP');
8923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8924:
8925: END create_sline_term_emp;
8926: --======================= End of procedure =================

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

9099: p_return_status := FND_API.G_RET_STS_SUCCESS;
9100: hr_utility.trace(' Leaving CREATE PRORATE CALENDAR');
9101: EXCEPTION
9102: WHEN fnd_api.g_exc_unexpected_error THEN
9103: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_PRORATE_CALENDAR');
9104: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9105: WHEN OTHERS THEN
9106: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_PRORATE_CALENDAR');
9107: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

9102: WHEN fnd_api.g_exc_unexpected_error THEN
9103: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_PRORATE_CALENDAR');
9104: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9105: WHEN OTHERS THEN
9106: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_PRORATE_CALENDAR');
9107: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9108: END create_prorate_calendar;
9109:
9110: END PSP_PAYTRN; -- End of Package Body

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

9106: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_PRORATE_CALENDAR');
9107: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9108: END create_prorate_calendar;
9109:
9110: END PSP_PAYTRN; -- End of Package Body