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 604: FND_MSG_PUB.Initialize;

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

Line 650: fnd_msg_pub.add;

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

Line 669: fnd_msg_pub.add;

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

Line 680: fnd_msg_pub.add;

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

Line 685: fnd_msg_pub.add;

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

Line 739: fnd_msg_pub.add;

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

Line 770: fnd_msg_pub.add;

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

Line 1047: fnd_msg_pub.add;

1043: fnd_message.set_token('VALUE', l_value);
1044: fnd_message.set_token('TABLE', l_table);
1045: fnd_message.set_token('BATCH_NAME', NULL);
1046: fnd_message.set_token('PERSON_NAME', l_employee_name);
1047: fnd_msg_pub.add;
1048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1049: END IF;
1050: CLOSE exp_org_cur;
1051:

Line 1067: fnd_msg_pub.add;

1063: fnd_message.set_token('VALUE',l_value);
1064: fnd_message.set_token('TABLE',l_table);
1065: fnd_message.set_token('BATCH_NAME', NULL);
1066: fnd_message.set_token('PERSON_NAME', l_employee_name);
1067: fnd_msg_pub.add;
1068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1069: END IF;
1070: CLOSE project_id_cur;
1071:

Line 1087: fnd_msg_pub.add;

1083: fnd_message.set_token('VALUE',l_value);
1084: fnd_message.set_token('TABLE',l_table);
1085: fnd_message.set_token('BATCH_NAME', NULL);
1086: fnd_message.set_token('PERSON_NAME', l_employee_name);
1087: fnd_msg_pub.add;
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1089: END IF;
1090: CLOSE org_id_cur;
1091:

Line 1107: fnd_msg_pub.add;

1103: fnd_message.set_token('VALUE',l_value);
1104: fnd_message.set_token('TABLE',l_table);
1105: fnd_message.set_token('BATCH_NAME', NULL);
1106: fnd_message.set_token('PERSON_NAME', l_employee_name);
1107: fnd_msg_pub.add;
1108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1109: END IF;
1110: CLOSE task_id_cur;
1111:

Line 1128: fnd_msg_pub.add;

1124: fnd_message.set_token('VALUE',l_value);
1125: fnd_message.set_token('TABLE',l_table);
1126: fnd_message.set_token('BATCH_NAME', NULL);
1127: fnd_message.set_token('PERSON_NAME', l_employee_name);
1128: fnd_msg_pub.add;
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1130: END IF;
1131: CLOSE award_id_cur;
1132: END IF;

Line 1149: fnd_msg_pub.add;

1145: fnd_message.set_token('VALUE',l_value);
1146: fnd_message.set_token('TABLE',l_table);
1147: fnd_message.set_token('BATCH_NAME', NULL);
1148: fnd_message.set_token('PERSON_NAME', l_employee_name);
1149: fnd_msg_pub.add;
1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1151: END IF;
1152: CLOSE expenditure_type_cur;
1153: END IF;

Line 1400: fnd_msg_pub.add;

1396: IF l_gl_ccid = 0 or l_gl_ccid IS NULL then
1397: l_error_api_name := 'GET_GL_CCID : ';
1398: fnd_message.set_name('PSP','PSP_NO_GL_FOR_COSTING');
1399: fnd_message.set_token('COST_ID', g_pay_costs_rec.cost_allocation_keyflex_id);
1400: fnd_msg_pub.add;
1401: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1402: ELSIF l_gl_ccid <> l_clearing_account then
1403: l_gl_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_gl_ccid);
1404: l_clearing_account_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_clearing_account);

Line 1409: fnd_msg_pub.add;

1405: l_error_api_name := 'GET_GL_CCID : ';
1406: fnd_message.set_name('PSP','PSP_CLEARING_ACCT_MISMATCH');
1407: fnd_message.set_token('GL_ACCOUNT', l_gl_value);
1408: fnd_message.set_token('CLEARING', l_clearing_account_value);
1409: fnd_msg_pub.add;
1410: hr_utility.trace(' fail kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);
1411: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1412: END IF;
1413: hr_utility.trace(' pass kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);

Line 1450: FND_MSG_PUB.ADD;

1446: hr_utility.trace('Am i successful');
1447:
1448: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_PRMRY_ASG_INACTIVE');
1449: FND_MESSAGE.set_token('Employee',l_employee_name);
1450: FND_MSG_PUB.ADD;
1451: g_non_active_flag := 'E'; --ERROR, skip this assg, bcos not a single day it is active
1452: END IF;
1453: END IF;
1454:

Line 1889: FND_MSG_PUB.ADD;

1885: hr_utility.trace('-inside exception 10-');
1886:
1887: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_NO_COSTING_EMP');
1888: FND_MESSAGE.set_token('Employee',l_employee_name);
1889: FND_MSG_PUB.ADD;
1890:
1891: retcode:= FND_API.G_RET_STS_SUCCESS;
1892:
1893: WHEN OTHERS then

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

1952: END IF;
1953:
1954: IF l_total_num_rec=0 then
1955: fnd_message.set_name('PSP','PSP_PI_NO_PAYROLL_TRXN');
1956: fnd_msg_pub.add;
1957:
1958: ELSE
1959:
1960: --- Delete the record of arrays

Line 1979: fnd_msg_pub.add;

1975:
1976: fnd_file.put_line(fnd_file.log,'********************************************************');
1977:
1978: fnd_message.set_name('PSP','PSP_PROGRAM_SUCCESS') ;
1979: fnd_msg_pub.add;
1980: retcode:= FND_API.G_RET_STS_SUCCESS;
1981:
1982: COMMIT;
1983:

Line 2050: fnd_msg_pub.add;

2046: EXCEPTION
2047: WHEN NO_DATA_FOUND then
2048: close get_payroll_assig_actions_csr;
2049: fnd_message.set_name('PSP','PSP_PI_NO_PAYROLL_TRXN');
2050: fnd_msg_pub.add;
2051: fnd_message.set_name('PSP','PSP_PROGRAM_SUCCESS') ;
2052: fnd_msg_pub.add;
2053: retcode:= FND_API.G_RET_STS_SUCCESS;
2054:

Line 2052: fnd_msg_pub.add;

2048: close get_payroll_assig_actions_csr;
2049: fnd_message.set_name('PSP','PSP_PI_NO_PAYROLL_TRXN');
2050: fnd_msg_pub.add;
2051: fnd_message.set_name('PSP','PSP_PROGRAM_SUCCESS') ;
2052: fnd_msg_pub.add;
2053: retcode:= FND_API.G_RET_STS_SUCCESS;
2054:
2055:
2056: psp_message_s.print_error(p_mode=>FND_FILE.log,

Line 2073: fnd_msg_pub.add;

2069: return;
2070: /* Added Exceptions for bug 2056877 */
2071: WHEN NO_PROFILE_EXISTS THEN
2072: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
2073: fnd_msg_pub.add;
2074: psp_message_s.print_error(p_mode=>FND_FILE.log,
2075: p_print_header=>FND_API.G_TRUE);
2076: retcode := 2;
2077:

Line 2082: fnd_msg_pub.add;

2078:
2079: WHEN NO_VAL_DATE_MATCHES THEN
2080: fnd_message.set_name('PSP','PSP_IMP_NO_VAL_DATE_MATCHES');
2081: fnd_message.set_token('PAYROLL_DATE',l_end_date);
2082: fnd_msg_pub.add;
2083: psp_message_s.print_error(p_mode=>FND_FILE.log,
2084: p_print_header=>FND_API.G_TRUE);
2085: retcode := 2;
2086:

Line 2094: fnd_msg_pub.add;

2090: --errbuf := l_error_api_name || chr(10) || l_msg_data || chr(10);
2091: errbuf := l_error_api_name || fnd_global.local_chr(10) || l_msg_data || fnd_global.local_chr(10);
2092: fnd_message.set_name('PSP','PSP_IMP_NO_GLOBAL_ACCT_EXISTS');
2093: fnd_message.set_token('PAYROLL_DATE',l_end_date);
2094: fnd_msg_pub.add;
2095: psp_message_s.print_error(p_mode=>FND_FILE.log,
2096: p_print_header=>FND_API.G_TRUE);
2097: retcode := 2; --End of Modification for Bug 2056877.
2098:

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

2573: --dbms_output.PUT_LINE(' Just entered... ' );
2574: if get_no_per_fiscal_year_csr%NOTFOUND then
2575: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_NO_PERIOD_TYPES');
2576: FND_MESSAGE.Set_Token('TIME_PERIOD_ID',x_time_period_id);
2577: FND_MSG_PUB.Add;
2578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2579: end if;
2580: close get_no_per_fiscal_year_csr;
2581: --dbms_output.PUT_LINE('No. of periods for fiscal year... ' || to_char(l_no_fiscal_year));

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

3004: open get_payroll_line_csr;
3005: fetch get_payroll_line_csr into g_payroll_line_rec;
3006: if get_payroll_line_csr%NOTFOUND then
3007: fnd_message.set_name('PSP', 'PSP_NO_PAYROLL_LINES');
3008: fnd_msg_pub.add;
3009: close get_payroll_line_csr;
3010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3011: end if;
3012: close get_payroll_line_csr;

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

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

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