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 FND_MSG_PUB

Line 602: FND_MSG_PUB.Initialize;

598: WHERE expenditure_type = l_or_expenditure_type;
599:
600: BEGIN
601:
602: FND_MSG_PUB.Initialize;
603: ---hr_utility.trace_on('Y','IMPORT-1');
604: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Import process started');
605: hr_utility.trace(' Entering IMPORT_PAYTRANS');
606:

Line 648: fnd_msg_pub.add;

644: fetch get_payroll_id_csr into l_start_date, l_end_date, l_payroll_id;
645:
646: if get_payroll_id_csr%NOTFOUND then
647: FND_MESSAGE.SET_NAME('PSP','PSP_INVALID_PERIOD');
648: fnd_msg_pub.add;
649: close get_payroll_id_csr;
650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
651: end if;
652:

Line 667: fnd_msg_pub.add;

663: EXIT WHEN get_set_of_books_csr%NOTFOUND ;
664: l_record_count := l_record_count + 1;
665: if l_record_count > 1 then
666: FND_MESSAGE.SET_NAME('PSP','PSP_INVALID_NO_OF_BOOKS');
667: fnd_msg_pub.add;
668: close get_set_of_books_csr;
669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
670: end if;
671: end loop;

Line 678: fnd_msg_pub.add;

674: open get_set_of_books_csr ;
675: fetch get_set_of_books_csr into l_resp_set_of_books_id ,l_resp_business_group_id;
676: if get_set_of_books_csr%NOTFOUND then
677: FND_MESSAGE.SET_NAME('PSP','PSP_NO_SET_OF_BOOKS');
678: fnd_msg_pub.add;
679: close get_set_of_books_csr;
680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
681: elsif NVL(l_resp_set_of_books_id, 0) = 0 then
682: FND_MESSAGE.SET_NAME('PSP','PSP_PI_NO_SOB_FOR_PAYROLL');

Line 683: fnd_msg_pub.add;

679: close get_set_of_books_csr;
680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
681: elsif NVL(l_resp_set_of_books_id, 0) = 0 then
682: FND_MESSAGE.SET_NAME('PSP','PSP_PI_NO_SOB_FOR_PAYROLL');
683: fnd_msg_pub.add;
684: close get_set_of_books_csr;
685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
686: end if;
687:

Line 737: fnd_msg_pub.add;

733: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_column_count ='||l_column_count );
734:
735: IF (l_column_count > 1) AND (l_column_count < 4) THEN
736: fnd_message.set_name('PSP', 'PSP_EE_INCOMPLETE_CI');
737: fnd_msg_pub.add;
738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
739: END IF;
740:
741:

Line 768: fnd_msg_pub.add;

764: open get_clearing_account_csr;
765: fetch get_clearing_account_csr into l_clearing_account;
766: if get_clearing_account_csr%NOTFOUND or l_clearing_account = 0 then
767: FND_MESSAGE.SET_NAME('PSP','PSP_NO_CLEARING_ACCOUNT');
768: fnd_msg_pub.add;
769: close get_clearing_account_csr;
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771: end if;
772: close get_clearing_account_csr;

Line 1014: fnd_msg_pub.add;

1010: fnd_message.set_token('VALUE', l_value);
1011: fnd_message.set_token('TABLE', l_table);
1012: fnd_message.set_token('BATCH_NAME', NULL);
1013: fnd_message.set_token('PERSON_NAME', l_employee_name);
1014: fnd_msg_pub.add;
1015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1016: END IF;
1017: CLOSE exp_org_cur;
1018:

Line 1034: fnd_msg_pub.add;

1030: fnd_message.set_token('VALUE',l_value);
1031: fnd_message.set_token('TABLE',l_table);
1032: fnd_message.set_token('BATCH_NAME', NULL);
1033: fnd_message.set_token('PERSON_NAME', l_employee_name);
1034: fnd_msg_pub.add;
1035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1036: END IF;
1037: CLOSE project_id_cur;
1038:

Line 1054: fnd_msg_pub.add;

1050: fnd_message.set_token('VALUE',l_value);
1051: fnd_message.set_token('TABLE',l_table);
1052: fnd_message.set_token('BATCH_NAME', NULL);
1053: fnd_message.set_token('PERSON_NAME', l_employee_name);
1054: fnd_msg_pub.add;
1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1056: END IF;
1057: CLOSE org_id_cur;
1058:

Line 1074: fnd_msg_pub.add;

1070: fnd_message.set_token('VALUE',l_value);
1071: fnd_message.set_token('TABLE',l_table);
1072: fnd_message.set_token('BATCH_NAME', NULL);
1073: fnd_message.set_token('PERSON_NAME', l_employee_name);
1074: fnd_msg_pub.add;
1075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1076: END IF;
1077: CLOSE task_id_cur;
1078:

Line 1095: fnd_msg_pub.add;

1091: fnd_message.set_token('VALUE',l_value);
1092: fnd_message.set_token('TABLE',l_table);
1093: fnd_message.set_token('BATCH_NAME', NULL);
1094: fnd_message.set_token('PERSON_NAME', l_employee_name);
1095: fnd_msg_pub.add;
1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: END IF;
1098: CLOSE award_id_cur;
1099: END IF;

Line 1116: fnd_msg_pub.add;

1112: fnd_message.set_token('VALUE',l_value);
1113: fnd_message.set_token('TABLE',l_table);
1114: fnd_message.set_token('BATCH_NAME', NULL);
1115: fnd_message.set_token('PERSON_NAME', l_employee_name);
1116: fnd_msg_pub.add;
1117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1118: END IF;
1119: CLOSE expenditure_type_cur;
1120: END IF;

Line 1361: fnd_msg_pub.add;

1357: IF l_gl_ccid = 0 or l_gl_ccid IS NULL then
1358: l_error_api_name := 'GET_GL_CCID : ';
1359: fnd_message.set_name('PSP','PSP_NO_GL_FOR_COSTING');
1360: fnd_message.set_token('COST_ID', g_pay_costs_rec.cost_allocation_keyflex_id);
1361: fnd_msg_pub.add;
1362: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1363: ELSIF l_gl_ccid <> l_clearing_account then
1364: l_gl_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_gl_ccid);
1365: l_clearing_account_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_clearing_account);

Line 1370: fnd_msg_pub.add;

1366: l_error_api_name := 'GET_GL_CCID : ';
1367: fnd_message.set_name('PSP','PSP_CLEARING_ACCT_MISMATCH');
1368: fnd_message.set_token('GL_ACCOUNT', l_gl_value);
1369: fnd_message.set_token('CLEARING', l_clearing_account_value);
1370: fnd_msg_pub.add;
1371: hr_utility.trace(' fail kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);
1372: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1373: END IF;
1374: hr_utility.trace(' pass kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);

Line 1394: FND_MSG_PUB.ADD;

1390: where person_id = l_person_id and
1391: g_pay_costs_rec.date_earned between effective_start_date and effective_end_date;
1392: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_PRMRY_ASG_INACTIVE');
1393: FND_MESSAGE.set_token('Employee',l_employee_name);
1394: FND_MSG_PUB.ADD;
1395: g_non_active_flag := 'E'; --ERROR, skip this assg, bcos not a single day it is active
1396: END IF;
1397: END IF;
1398:

Line 1817: FND_MSG_PUB.ADD;

1813: sysdate between effective_start_date and effective_end_date;
1814: */
1815: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_NO_COSTING_EMP');
1816: FND_MESSAGE.set_token('Employee',l_employee_name);
1817: FND_MSG_PUB.ADD;
1818:
1819: retcode:= FND_API.G_RET_STS_SUCCESS;
1820:
1821: WHEN OTHERS then

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 1882: fnd_msg_pub.add;

1878: END IF;
1879:
1880: IF l_total_num_rec=0 then
1881: fnd_message.set_name('PSP','PSP_PI_NO_PAYROLL_TRXN');
1882: fnd_msg_pub.add;
1883:
1884: ELSE
1885:
1886: --- Delete the record of arrays

Line 1905: fnd_msg_pub.add;

1901:
1902: fnd_file.put_line(fnd_file.log,'********************************************************');
1903:
1904: fnd_message.set_name('PSP','PSP_PROGRAM_SUCCESS') ;
1905: fnd_msg_pub.add;
1906: retcode:= FND_API.G_RET_STS_SUCCESS;
1907:
1908: COMMIT;
1909:

Line 1976: fnd_msg_pub.add;

1972: EXCEPTION
1973: WHEN NO_DATA_FOUND then
1974: close get_payroll_assig_actions_csr;
1975: fnd_message.set_name('PSP','PSP_PI_NO_PAYROLL_TRXN');
1976: fnd_msg_pub.add;
1977: fnd_message.set_name('PSP','PSP_PROGRAM_SUCCESS') ;
1978: fnd_msg_pub.add;
1979: retcode:= FND_API.G_RET_STS_SUCCESS;
1980:

Line 1978: fnd_msg_pub.add;

1974: close get_payroll_assig_actions_csr;
1975: fnd_message.set_name('PSP','PSP_PI_NO_PAYROLL_TRXN');
1976: fnd_msg_pub.add;
1977: fnd_message.set_name('PSP','PSP_PROGRAM_SUCCESS') ;
1978: fnd_msg_pub.add;
1979: retcode:= FND_API.G_RET_STS_SUCCESS;
1980:
1981:
1982: psp_message_s.print_error(p_mode=>FND_FILE.log,

Line 1999: fnd_msg_pub.add;

1995: return;
1996: /* Added Exceptions for bug 2056877 */
1997: WHEN NO_PROFILE_EXISTS THEN
1998: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
1999: fnd_msg_pub.add;
2000: psp_message_s.print_error(p_mode=>FND_FILE.log,
2001: p_print_header=>FND_API.G_TRUE);
2002: retcode := 2;
2003:

Line 2008: fnd_msg_pub.add;

2004:
2005: WHEN NO_VAL_DATE_MATCHES THEN
2006: fnd_message.set_name('PSP','PSP_IMP_NO_VAL_DATE_MATCHES');
2007: fnd_message.set_token('PAYROLL_DATE',l_end_date);
2008: fnd_msg_pub.add;
2009: psp_message_s.print_error(p_mode=>FND_FILE.log,
2010: p_print_header=>FND_API.G_TRUE);
2011: retcode := 2;
2012:

Line 2020: fnd_msg_pub.add;

2016: --errbuf := l_error_api_name || chr(10) || l_msg_data || chr(10);
2017: errbuf := l_error_api_name || fnd_global.local_chr(10) || l_msg_data || fnd_global.local_chr(10);
2018: fnd_message.set_name('PSP','PSP_IMP_NO_GLOBAL_ACCT_EXISTS');
2019: fnd_message.set_token('PAYROLL_DATE',l_end_date);
2020: fnd_msg_pub.add;
2021: psp_message_s.print_error(p_mode=>FND_FILE.log,
2022: p_print_header=>FND_API.G_TRUE);
2023: retcode := 2; --End of Modification for Bug 2056877.
2024:

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 2503: FND_MSG_PUB.Add;

2499: --dbms_output.PUT_LINE(' Just entered... ' );
2500: if get_no_per_fiscal_year_csr%NOTFOUND then
2501: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_NO_PERIOD_TYPES');
2502: FND_MESSAGE.Set_Token('TIME_PERIOD_ID',x_time_period_id);
2503: FND_MSG_PUB.Add;
2504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2505: end if;
2506: close get_no_per_fiscal_year_csr;
2507: --dbms_output.PUT_LINE('No. of periods for fiscal year... ' || to_char(l_no_fiscal_year));

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 2934: fnd_msg_pub.add;

2930: open get_payroll_line_csr;
2931: fetch get_payroll_line_csr into g_payroll_line_rec;
2932: if get_payroll_line_csr%NOTFOUND then
2933: fnd_message.set_name('PSP', 'PSP_NO_PAYROLL_LINES');
2934: fnd_msg_pub.add;
2935: close get_payroll_line_csr;
2936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2937: end if;
2938: close get_payroll_line_csr;

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 8806: fnd_msg_pub.add;

8802: assignment_id=x_assignment_id);
8803: fnd_message.set_name('PSP','PSP_ZERO_WORK_DAYS');
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:

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