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_API

Line 650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
653: close get_payroll_id_csr ;
654:

Line 669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
672: close get_set_of_books_csr;
673:

Line 680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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');
683: fnd_msg_pub.add;
684: close get_set_of_books_csr;

Line 685: 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:
688: close get_set_of_books_csr;
689: End of comment for bug fix 3098050 *****/

Line 738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
742: -- Introduced the following for bug fix 2916848

Line 770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
773:
774: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_clearing_account ='||l_clearing_account );

Line 1015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
1019: OPEN project_id_cur;

Line 1035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
1039: OPEN org_id_cur;

Line 1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
1059: OPEN task_id_cur;

Line 1075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
1079: IF (l_or_award_id IS NOT NULL) THEN

Line 1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
1100:

Line 1117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
1121:

Line 1148: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1144:
1145: hr_utility.trace(' UPDATE_WCAL_ASG_END_DATE');
1146: UPDATE_WCAL_ASG_END_DATE(X_ASSIGNMENT_ID => l_assignment_id,
1147: X_RETURN_STATUS => l_return_status);
1148: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1149: l_error_api_name := 'UPDATE_WCAL_ASG_END_DATE : ';
1150: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1151: end if;
1152:

Line 1150: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1146: UPDATE_WCAL_ASG_END_DATE(X_ASSIGNMENT_ID => l_assignment_id,
1147: X_RETURN_STATUS => l_return_status);
1148: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1149: l_error_api_name := 'UPDATE_WCAL_ASG_END_DATE : ';
1150: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1151: end if;
1152:
1153: hr_utility.trace(' UPDATE_WCAL_ASG_BEGIN_DATE');
1154: UPDATE_WCAL_ASG_BEGIN_DATE(X_ASSIGNMENT_ID => l_assignment_id,

Line 1156: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1152:
1153: hr_utility.trace(' UPDATE_WCAL_ASG_BEGIN_DATE');
1154: UPDATE_WCAL_ASG_BEGIN_DATE(X_ASSIGNMENT_ID => l_assignment_id,
1155: X_RETURN_STATUS => l_return_status);
1156: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1157: l_error_api_name := 'UPDATE_WCAL_ASG_BEGIN_DATE : ';
1158: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1159: end if;
1160:

Line 1158: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1154: UPDATE_WCAL_ASG_BEGIN_DATE(X_ASSIGNMENT_ID => l_assignment_id,
1155: X_RETURN_STATUS => l_return_status);
1156: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1157: l_error_api_name := 'UPDATE_WCAL_ASG_BEGIN_DATE : ';
1158: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1159: end if;
1160:
1161: -- This procedure looks into per_assignments_f for assignment
1162: -- status. If the assignment status is 'Suspend' or 'Terminate' for any of the days

Line 1168: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1164:
1165: hr_utility.trace(' UPDATE_WCAL_ASG_STATUS');
1166: UPDATE_WCAL_ASG_STATUS(X_ASSIGNMENT_ID => l_assignment_id,
1167: X_RETURN_STATUS => l_return_status);
1168: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1169: l_error_api_name := 'UPDATE_WCAL_ASG_STATUS : ';
1170: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1171: end if;
1172: hr_utility.trace(' AFTER UPDATE_WCAL_ASG_STATUS');

Line 1170: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1166: UPDATE_WCAL_ASG_STATUS(X_ASSIGNMENT_ID => l_assignment_id,
1167: X_RETURN_STATUS => l_return_status);
1168: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1169: l_error_api_name := 'UPDATE_WCAL_ASG_STATUS : ';
1170: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1171: end if;
1172: hr_utility.trace(' AFTER UPDATE_WCAL_ASG_STATUS');
1173: begin
1174: l_export_id := null;

Line 1212: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1208: x_start_date => TRUNC(g_start_date), --Bug 6046087
1209: x_end_date => TRUNC(g_end_date), --Bug 6046087
1210: X_RETURN_STATUS => l_return_status);
1211:
1212: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1213: l_error_api_name := 'CHECK_ZERO_WORK_DAYS : ';
1214: RAISE ZERO_WORK_DAYS;
1215: end if;
1216: /*END IF;*/

Line 1362: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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);
1366: l_error_api_name := 'GET_GL_CCID : ';

Line 1372: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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);
1375:
1376: SELECT PSP_PAYROLL_LINES_S.NEXTVAL into l_line_id

Line 1472: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

1468: CREATE_SLINE_TERM_EMP( X_PAYROLL_LINE_ID => l_line_id,
1469: X_REASON => l_reason,
1470: X_RETURN_STATUS => l_return_status);
1471:
1472: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1473: l_error_api_name := 'CREATE_SLINE_TERM_EMP'||' '||l_reason;
1474: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1475: END IF;
1476:

Line 1474: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1470: X_RETURN_STATUS => l_return_status);
1471:
1472: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1473: l_error_api_name := 'CREATE_SLINE_TERM_EMP'||' '||l_reason;
1474: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1475: END IF;
1476:
1477: ELSE
1478: ---End of changes made for Non active assignments: Done as part of Bug 1994421 -Zero Work Days Build -lveerubh

Line 1521: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

1517: X_ASSIGNMENT_ID => l_assignment_id,
1518: X_time_period_id => p_time_period_id,
1519: X_ELEMENT_TYPE_ID => g_pay_costs_rec.element_type_id,
1520: X_RETURN_STATUS => l_return_status);
1521: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1522: l_error_api_name := 'CREATE_DAILY_RATE_CALENDAR : ';
1523: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1524: END IF;
1525:

Line 1523: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1519: X_ELEMENT_TYPE_ID => g_pay_costs_rec.element_type_id,
1520: X_RETURN_STATUS => l_return_status);
1521: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1522: l_error_api_name := 'CREATE_DAILY_RATE_CALENDAR : ';
1523: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1524: END IF;
1525:
1526:
1527: -- Sum up the salary from daily calendar array

Line 1534: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1530:
1531: CALCULATE_BALANCE_AMOUNT(X_PAY_AMOUNT => g_pay_costs_rec.costed_value,
1532: X_BALANCE_AMOUNT => l_balance_amount,
1533: X_RETURN_STATUS => l_return_status);
1534: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1535: l_error_api_name := 'CREATE_BALANCE_AMOUNT : ';
1536: --dbms_output.PUT_LINE('...CREATE_BALANCE_AMOUNT :');
1537: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1538: end if;

Line 1537: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1533: X_RETURN_STATUS => l_return_status);
1534: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1535: l_error_api_name := 'CREATE_BALANCE_AMOUNT : ';
1536: --dbms_output.PUT_LINE('...CREATE_BALANCE_AMOUNT :');
1537: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1538: end if;
1539:
1540: /* commented for 4897071
1541: -- Introduced the following for bug fix 2916848

Line 1550: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1546: p_pay_amount => g_pay_costs_rec.costed_value,
1547: p_payroll_line_id => l_line_id,
1548: p_balance_amount => l_balance_amount,
1549: p_return_status => l_return_status);
1550: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1551: l_error_api_name := 'CREATE_PRORATE_CALENDAR : ';
1552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1553: END IF;
1554:

Line 1552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1548: p_balance_amount => l_balance_amount,
1549: p_return_status => l_return_status);
1550: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1551: l_error_api_name := 'CREATE_PRORATE_CALENDAR : ';
1552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1553: END IF;
1554:
1555:
1556: END IF;

Line 1600: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

1596: x_end_date => TRUNC(g_end_date), -- Bug 6046087
1597: X_RETURN_STATUS => l_return_status);
1598:
1599:
1600: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1601: l_error_api_name := 'CREATE_SLINE_SALARY_CHANGE : ';
1602: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1603: END IF;
1604:

Line 1602: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1598:
1599:
1600: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1601: l_error_api_name := 'CREATE_SLINE_SALARY_CHANGE : ';
1602: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1603: END IF;
1604:
1605: ----END IF; -- Introduced for bug fix 2916848
1606:

Line 1617: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1613:
1614: CREATE_SLINE_ASG_CHANGE (X_PAYROLL_LINE_ID => l_line_id,
1615: X_ASSIGNMENT_ID => l_assignment_id,
1616: X_RETURN_STATUS => l_return_status);
1617: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1618: l_error_api_name := 'CREATE_SLINE_ASG_CHANGE : ';
1619: ----dbms_output.PUT_LINE('...CREATE_SLINE_ASG_CHANGE :');
1620: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1621: end if;

Line 1620: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1616: X_RETURN_STATUS => l_return_status);
1617: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1618: l_error_api_name := 'CREATE_SLINE_ASG_CHANGE : ';
1619: ----dbms_output.PUT_LINE('...CREATE_SLINE_ASG_CHANGE :');
1620: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1621: end if;
1622:
1623:
1624: -- Looks in to per_assignments_f for assignment statuses either

Line 1633: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1629: CREATE_SLINE_ASG_STATUS_CHANGE (X_PAYROLL_LINE_ID => l_line_id,
1630: X_ASSIGNMENT_ID => l_assignment_id,
1631: X_BALANCE_AMOUNT => l_balance_amount,
1632: X_RETURN_STATUS => l_return_status);
1633: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1634: l_error_api_name := 'CREATE_SLINE_ASG_STATUS_CHANGE : ';
1635: ----dbms_output.PUT_LINE('...CREATE_SLINE_ASG_STATUS_CHANGE :');
1636: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1637: end if;

Line 1636: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1632: X_RETURN_STATUS => l_return_status);
1633: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1634: l_error_api_name := 'CREATE_SLINE_ASG_STATUS_CHANGE : ';
1635: ----dbms_output.PUT_LINE('...CREATE_SLINE_ASG_STATUS_CHANGE :');
1636: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1637: end if;
1638:
1639:
1640: -- Looks into per_periods_of_service for ending employment.

Line 1647: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1643:
1644: CREATE_SLINE_EMP_END_DATE(X_PAYROLL_LINE_ID => l_line_id,
1645: X_PERSON_ID => l_person_id,
1646: X_RETURN_STATUS => l_return_status);
1647: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1648: l_error_api_name := 'CREATE_SLINE_EMP_END_DATE : ';
1649: ----dbms_output.PUT_LINE('...CREATE_SLINE_EMP_END_DATE :');
1650: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1651: end if;

Line 1650: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1646: X_RETURN_STATUS => l_return_status);
1647: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1648: l_error_api_name := 'CREATE_SLINE_EMP_END_DATE : ';
1649: ----dbms_output.PUT_LINE('...CREATE_SLINE_EMP_END_DATE :');
1650: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1651: end if;
1652:
1653: -- Looks into per_assignments_f for Organization change during the pay period.
1654: -- If found split the sub-line into two sub-lines and delete the existing sub-line.

Line 1660: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1656: CREATE_SLINE_ORG_CHANGE(X_PAYROLL_LINE_ID => l_line_id,
1657: X_ASSIGNMENT_ID => l_assignment_id,
1658: X_BALANCE_AMOUNT => l_balance_amount,
1659: X_RETURN_STATUS => l_return_status);
1660: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1661: l_error_api_name := 'CREATE_SLINE_ORG_CHANGE : ';
1662: ----dbms_output.PUT_LINE('...CREATE_SLINE_ORG_CHANGE :');
1663: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1664: end if;

Line 1663: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1659: X_RETURN_STATUS => l_return_status);
1660: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1661: l_error_api_name := 'CREATE_SLINE_ORG_CHANGE : ';
1662: ----dbms_output.PUT_LINE('...CREATE_SLINE_ORG_CHANGE :');
1663: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1664: end if;
1665:
1666:
1667: -- Looks into per_assignments_f for Job change during the pay period.

Line 1676: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1672: X_ASSIGNMENT_ID => l_assignment_id,
1673: X_BALANCE_AMOUNT => l_balance_amount,
1674: X_RETURN_STATUS => l_return_status);
1675:
1676: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1677: l_error_api_name := 'CREATE_SLINE_JOB_CHANGE : ';
1678: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1679: end if;
1680:

Line 1678: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1674: X_RETURN_STATUS => l_return_status);
1675:
1676: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1677: l_error_api_name := 'CREATE_SLINE_JOB_CHANGE : ';
1678: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1679: end if;
1680:
1681:
1682: -- Looks into per_assignments_f for Position change during the pay period.

Line 1690: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1686: X_ASSIGNMENT_ID => l_assignment_id,
1687: X_BALANCE_AMOUNT => l_balance_amount,
1688: X_RETURN_STATUS => l_return_status);
1689:
1690: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1691: l_error_api_name := 'CREATE_SLINE_POSITION_CHANGE : ';
1692: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1693: end if;
1694:

Line 1692: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1688: X_RETURN_STATUS => l_return_status);
1689:
1690: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1691: l_error_api_name := 'CREATE_SLINE_POSITION_CHANGE : ';
1692: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1693: end if;
1694:
1695: /* New Procedures added for splitting sublines by garde and people group */
1696:

Line 1703: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1699: X_ASSIGNMENT_ID => l_assignment_id,
1700: X_BALANCE_AMOUNT => l_balance_amount,
1701: X_RETURN_STATUS => l_return_status);
1702:
1703: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1704: l_error_api_name := 'CREATE_SLINE_GRADE_CHANGE : ';
1705: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1706: end if;
1707:

Line 1705: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1701: X_RETURN_STATUS => l_return_status);
1702:
1703: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1704: l_error_api_name := 'CREATE_SLINE_GRADE_CHANGE : ';
1705: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1706: end if;
1707:
1708:
1709:

Line 1716: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1712: X_ASSIGNMENT_ID => l_assignment_id,
1713: X_BALANCE_AMOUNT => l_balance_amount,
1714: X_RETURN_STATUS => l_return_status);
1715:
1716: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1717: l_error_api_name := 'CREATE_SLINE_PPGROUP_CHANGE : ';
1718: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1719: end if;
1720:

Line 1718: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1714: X_RETURN_STATUS => l_return_status);
1715:
1716: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1717: l_error_api_name := 'CREATE_SLINE_PPGROUP_CHANGE : ';
1718: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1719: end if;
1720:
1721:
1722:

Line 1734: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1730: X_ASSIGNMENT_ID => l_assignment_id,
1731: X_BALANCE_AMOUNT => l_balance_amount,
1732: X_RETURN_STATUS => l_return_status);
1733:
1734: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1735: l_error_api_name := 'CREATE_SLINE_FTE_CHANGE : ';
1736: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1737: end if;
1738: End of code changes for bug 4055483 */

Line 1736: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1732: X_RETURN_STATUS => l_return_status);
1733:
1734: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1735: l_error_api_name := 'CREATE_SLINE_FTE_CHANGE : ';
1736: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1737: end if;
1738: End of code changes for bug 4055483 */
1739:
1740: CREATE_SLINE_BUDGET_CHANGE(X_PAYROLL_LINE_ID => l_line_id,

Line 1745: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1741: X_ASSIGNMENT_ID => l_assignment_id,
1742: X_BALANCE_AMOUNT => l_balance_amount,
1743: X_RETURN_STATUS => l_return_status);
1744:
1745: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1746: l_error_api_name := 'CREATE_SLINE_BUDGET_CHANGE : ';
1747: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1748: end if;
1749:

Line 1747: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1743: X_RETURN_STATUS => l_return_status);
1744:
1745: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1746: l_error_api_name := 'CREATE_SLINE_BUDGET_CHANGE : ';
1747: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1748: end if;
1749:
1750: hr_utility.trace(' Opening get_difference_csr cursor');
1751:

Line 1757: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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
1761: if (NVL(to_number(g_pay_costs_rec.costed_value),0) - NVL(l_subline_sum,0)) <> 0 then

Line 1770: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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:
1774: end if;

Line 1785: retcode:= FND_API.G_RET_STS_SUCCESS;

1781: /* Added to let the program continue with next record if zero work days is encountered for any assignment */
1782: EXCEPTION
1783: WHEN ZERO_WORK_DAYS then
1784:
1785: retcode:= FND_API.G_RET_STS_SUCCESS;
1786:
1787: END;
1788: END LOOP; -- LOOP1 end
1789: close get_pay_costs_csr;

Line 1793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then

1789: close get_pay_costs_csr;
1790:
1791: EXCEPTION
1792:
1793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
1794: rollback;
1795: retcode := 2;
1796:
1797:

Line 1799: p_print_header=>FND_API.G_TRUE

1795: retcode := 2;
1796:
1797:
1798: psp_message_s.print_error(p_mode=>FND_FILE.log,
1799: p_print_header=>FND_API.G_TRUE
1800: );
1801:
1802: return;
1803: WHEN NO_DATA_FOUND then

Line 1819: retcode:= FND_API.G_RET_STS_SUCCESS;

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
1822: retcode := 2;
1823: rollback;

Line 1828: p_print_header=>FND_API.G_TRUE

1824:
1825: hr_utility.trace(' Process failed here');
1826:
1827: psp_message_s.print_error(p_mode=>FND_FILE.log,
1828: p_print_header=>FND_API.G_TRUE
1829: );
1830:
1831:
1832: return;

Line 1877: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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
1881: fnd_message.set_name('PSP','PSP_PI_NO_PAYROLL_TRXN');

Line 1906: retcode:= FND_API.G_RET_STS_SUCCESS;

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:
1910: psp_message_s.print_error(p_mode=>FND_FILE.log,

Line 1911: p_print_header=>FND_API.G_FALSE);

1907:
1908: COMMIT;
1909:
1910: psp_message_s.print_error(p_mode=>FND_FILE.log,
1911: p_print_header=>FND_API.G_FALSE);
1912:
1913: fnd_file.put_line(fnd_file.log,'********************************************************');
1914: fnd_file.put_line(fnd_file.log, '');
1915:

Line 1979: retcode:= FND_API.G_RET_STS_SUCCESS;

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,
1983: p_print_header=>FND_API.G_FALSE);

Line 1983: p_print_header=>FND_API.G_FALSE);

1979: retcode:= FND_API.G_RET_STS_SUCCESS;
1980:
1981:
1982: psp_message_s.print_error(p_mode=>FND_FILE.log,
1983: p_print_header=>FND_API.G_FALSE);
1984: return;
1985:
1986: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
1987: retcode := 2;

Line 1986: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then

1982: psp_message_s.print_error(p_mode=>FND_FILE.log,
1983: p_print_header=>FND_API.G_FALSE);
1984: return;
1985:
1986: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
1987: retcode := 2;
1988: rollback;
1989:
1990:

Line 1992: p_print_header=>FND_API.G_TRUE

1988: rollback;
1989:
1990:
1991: psp_message_s.print_error(p_mode=>FND_FILE.log,
1992: p_print_header=>FND_API.G_TRUE
1993: );
1994:
1995: return;
1996: /* Added Exceptions for bug 2056877 */

Line 2001: p_print_header=>FND_API.G_TRUE);

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:
2004:
2005: WHEN NO_VAL_DATE_MATCHES THEN

Line 2010: p_print_header=>FND_API.G_TRUE);

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:
2013: WHEN NO_GLOBAL_ACCT_EXISTS THEN
2014: -- commented the below line and replaced it with the next line, fix done is fixing the gscc warning on not to use chr(x)

Line 2022: p_print_header=>FND_API.G_TRUE);

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:
2025: WHEN OTHERS then
2026: retcode := 2;

Line 2032: p_print_header=>FND_API.G_TRUE

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
2033: );
2034:
2035: return;
2036: END;

Line 2132: x_return_status := FND_API.G_RET_STS_SUCCESS;

2128: end loop;
2129: end if;
2130: end if;
2131: close get_asg_end_date_csr;
2132: x_return_status := FND_API.G_RET_STS_SUCCESS;
2133: return;
2134: EXCEPTION
2135: WHEN OTHERS then
2136: ------dbms_output.put_line('When others Error...........');

Line 2138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
2142: --------------------------UPDATE_WCAL_ASG_BEGIN_DATE------------------------------

Line 2228: x_return_status := FND_API.G_RET_STS_SUCCESS;

2224: i:= i+1;
2225: end loop;
2226: end if;
2227: end if;
2228: x_return_status := FND_API.G_RET_STS_SUCCESS;
2229: return;
2230: EXCEPTION
2231: WHEN OTHERS then
2232: -- ------dbms_output.put_line('When others Error...........'||SUBSTR(SQLERRM,1,200));

Line 2234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
2238: /*

Line 2283: x_return_status := FND_API.G_RET_STS_SUCCESS;

2279: end loop;
2280: end if;
2281: end if;
2282: close get_asg_begin_date_csr;
2283: x_return_status := FND_API.G_RET_STS_SUCCESS;
2284: return;
2285: EXCEPTION
2286: WHEN OTHERS then
2287: ----dbms_output.put_line('When others Error...........');

Line 2289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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: */
2293: ---------------------------UPDATE_WCAL_ASG_STATUS-----------------------------------

Line 2343: x_return_status := FND_API.G_RET_STS_SUCCESS;

2339: i := i + 1;
2340: end loop;
2341: END LOOP;
2342: close get_asg_status_csr;
2343: x_return_status := FND_API.G_RET_STS_SUCCESS;
2344: return;
2345: EXCEPTION
2346: WHEN OTHERS then
2347: close get_asg_status_csr;

Line 2349: x_return_status := FND_API.G_RET_STS_SUCCESS;

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: --
2353: ----------------------CREATE_DAILY_RATE_CALENDAR---------------------------

Line 2504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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));
2508: l_change_start_date := trunc(g_start_date);

Line 2664: x_return_status := FND_API.G_RET_STS_SUCCESS;

2660: --dbms_output.PUT_LINE('i ............' || to_char(l_change_start_date,'YYYY/MM/DD HH24:MI:SS'));
2661: end loop;
2662:
2663: close get_proposal_csr;
2664: x_return_status := FND_API.G_RET_STS_SUCCESS;
2665: EXCEPTION
2666: WHEN NO_DATA_FOUND then
2667: begin
2668: i := 1;

Line 2717: x_return_status := FND_API.G_RET_STS_SUCCESS;

2713: end;
2714: --dbms_output.PUT_LINE( 'Daily Rate ' || to_char(l_daily_rate));
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:

Line 2718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then

2714: --dbms_output.PUT_LINE( 'Daily Rate ' || to_char(l_daily_rate));
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

Line 2720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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');
2724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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--------------------------------
2728: --

Line 2755: x_return_status := FND_API.G_RET_STS_SUCCESS;

2751: x_balance_amount := x_pay_amount - l_total_salary;
2752: else
2753: x_balance_amount := 0.00;
2754: end if;
2755: x_return_status := FND_API.G_RET_STS_SUCCESS;
2756:
2757: hr_utility.trace(' Leaving CALCULATE_BALANCE_AMOUNT');
2758:
2759: EXCEPTION

Line 2762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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-----------------------------------
2766: --

Line 2936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
2939: ---hr_utility.trace(' Pay amount .. ' || to_char(g_payroll_line_rec.pay_amount));
2940: ---hr_utility.trace(' Balance amount .. ' || to_char(g_payroll_line_rec.balance_amount));

Line 3174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then

3170: hr_utility.trace(' Leaving CREATE_SLINE_SALARY_CHANGE');
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:

Line 3177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
3181: ----hr_utility.trace(' Entered NO_DATA_FOUND');

Line 3336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
3340: ---------------------CREATE_SLINE_ASG_CHANGE--------------------------------

Line 3415: x_return_status := FND_API.G_RET_STS_SUCCESS;

3411: end if;
3412: close get_sublines_csr;
3413: end if;
3414: close get_asg_end_date_csr;
3415: x_return_status := FND_API.G_RET_STS_SUCCESS;
3416:
3417: hr_utility.trace(' Leaving CREATE_SLINE_ASG_CHANGE');
3418:
3419: EXCEPTION

Line 3423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
3427:

Line 4167: x_return_status := FND_API.G_RET_STS_SUCCESS;

4163: end;
4164: end if;
4165: end loop;
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;

Line 4171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
4175: close get_asg_status_csr;

Line 4176: x_return_status := FND_API.G_RET_STS_SUCCESS;

4172: close get_sublines_csr;
4173: end;
4174: END LOOP;
4175: close get_asg_status_csr;
4176: x_return_status := FND_API.G_RET_STS_SUCCESS;
4177:
4178: hr_utility.trace(' Leaving CREATE_SLINE_ASG_STATUS_CHANGE');
4179: EXCEPTION
4180: WHEN NO_DATA_FOUND then

Line 4181: x_return_status := FND_API.G_RET_STS_SUCCESS;

4177:
4178: hr_utility.trace(' Leaving CREATE_SLINE_ASG_STATUS_CHANGE');
4179: EXCEPTION
4180: WHEN NO_DATA_FOUND then
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');

Line 4186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
4190:

Line 4459: x_return_status := FND_API.G_RET_STS_SUCCESS;

4455: close get_sublines_csr; -- bug fix 2806589
4456:
4457: END LOOP;
4458: close check_service_period_end_csr; -- bug fix 2806589
4459: x_return_status := FND_API.G_RET_STS_SUCCESS;
4460:
4461: hr_utility.trace(' Leaving CREATE_SLINE_EMP_END_DATE');
4462:
4463: EXCEPTION

Line 4466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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: ---
4470: PROCEDURE CREATE_SLINE_ORG_CHANGE(X_PAYROLL_LINE_ID IN NUMBER,

Line 5046: x_return_status := FND_API.G_RET_STS_SUCCESS;

5042: end;
5043: end if;
5044: END LOOP;
5045: close get_assg_csr;
5046: x_return_status := FND_API.G_RET_STS_SUCCESS;
5047:
5048: hr_utility.trace(' Leaving CREATE_SLINE_ORG_CHANGE');
5049:
5050: EXCEPTION

Line 5052: x_return_status := FND_API.G_RET_STS_SUCCESS;

5048: hr_utility.trace(' Leaving CREATE_SLINE_ORG_CHANGE');
5049:
5050: EXCEPTION
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;

Line 5056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
5060:

Line 5627: x_return_status := FND_API.G_RET_STS_SUCCESS;

5623: end if;
5624: l_old_job_id := l_new_job_id;
5625: END LOOP;
5626: close get_sublines_csr;
5627: x_return_status := FND_API.G_RET_STS_SUCCESS;
5628: EXCEPTION
5629: WHEN NO_DATA_FOUND then
5630: x_return_status := FND_API.G_RET_STS_SUCCESS;
5631: close get_sublines_csr;

Line 5630: x_return_status := FND_API.G_RET_STS_SUCCESS;

5626: close get_sublines_csr;
5627: x_return_status := FND_API.G_RET_STS_SUCCESS;
5628: EXCEPTION
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;

Line 5634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
5638: END LOOP;

Line 5640: x_return_status := FND_API.G_RET_STS_SUCCESS;

5636: end;
5637: end if;
5638: END LOOP;
5639: close get_assg_csr;
5640: x_return_status := FND_API.G_RET_STS_SUCCESS;
5641: hr_utility.trace(' Leaving CREATE_SLINE_JOB_CHANGE');
5642: EXCEPTION
5643: WHEN NO_DATA_FOUND then
5644: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5644: x_return_status := FND_API.G_RET_STS_SUCCESS;

5640: x_return_status := FND_API.G_RET_STS_SUCCESS;
5641: hr_utility.trace(' Leaving CREATE_SLINE_JOB_CHANGE');
5642: EXCEPTION
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;

Line 5648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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--------------
5652: ---

Line 6217: x_return_status := FND_API.G_RET_STS_SUCCESS;

6213: end if;
6214: l_old_position_id := l_new_position_id;
6215: END LOOP;
6216: close get_sublines_csr;
6217: x_return_status := FND_API.G_RET_STS_SUCCESS;
6218: EXCEPTION
6219: WHEN NO_DATA_FOUND then
6220: x_return_status := FND_API.G_RET_STS_SUCCESS;
6221: close get_sublines_csr;

Line 6220: x_return_status := FND_API.G_RET_STS_SUCCESS;

6216: close get_sublines_csr;
6217: x_return_status := FND_API.G_RET_STS_SUCCESS;
6218: EXCEPTION
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;

Line 6224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
6228: END LOOP;

Line 6230: x_return_status := FND_API.G_RET_STS_SUCCESS;

6226: end;
6227: end if;
6228: END LOOP;
6229: close get_assg_csr;
6230: x_return_status := FND_API.G_RET_STS_SUCCESS;
6231: hr_utility.trace(' Leaving CREATE_SLINE_POSITION_CHANGE');
6232: EXCEPTION
6233: WHEN NO_DATA_FOUND then
6234: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6234: x_return_status := FND_API.G_RET_STS_SUCCESS;

6230: x_return_status := FND_API.G_RET_STS_SUCCESS;
6231: hr_utility.trace(' Leaving CREATE_SLINE_POSITION_CHANGE');
6232: EXCEPTION
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;

Line 6238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
6242:

Line 6808: x_return_status := FND_API.G_RET_STS_SUCCESS;

6804: end if;
6805: l_old_grade_id := l_new_grade_id;
6806: END LOOP;
6807: close get_sublines_csr;
6808: x_return_status := FND_API.G_RET_STS_SUCCESS;
6809: hr_utility.trace(' Leaving CREATE_SLINE_GRADE_CHANGE');
6810: EXCEPTION
6811: WHEN NO_DATA_FOUND then
6812: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6812: x_return_status := FND_API.G_RET_STS_SUCCESS;

6808: x_return_status := FND_API.G_RET_STS_SUCCESS;
6809: hr_utility.trace(' Leaving CREATE_SLINE_GRADE_CHANGE');
6810: EXCEPTION
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;

Line 6816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
6820: END LOOP;

Line 6822: x_return_status := FND_API.G_RET_STS_SUCCESS;

6818: end;
6819: end if;
6820: END LOOP;
6821: close get_assg_csr;
6822: x_return_status := FND_API.G_RET_STS_SUCCESS;
6823: EXCEPTION
6824: WHEN NO_DATA_FOUND then
6825: x_return_status := FND_API.G_RET_STS_SUCCESS;
6826: close get_assg_csr;

Line 6825: x_return_status := FND_API.G_RET_STS_SUCCESS;

6821: close get_assg_csr;
6822: x_return_status := FND_API.G_RET_STS_SUCCESS;
6823: EXCEPTION
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;

Line 6829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
6833:

Line 7403: x_return_status := FND_API.G_RET_STS_SUCCESS;

7399: end if;
7400: l_old_ppgroup_id := l_new_ppgroup_id;
7401: END LOOP;
7402: close get_sublines_csr;
7403: x_return_status := FND_API.G_RET_STS_SUCCESS;
7404: EXCEPTION
7405: WHEN NO_DATA_FOUND then
7406: x_return_status := FND_API.G_RET_STS_SUCCESS;
7407: close get_sublines_csr;

Line 7406: x_return_status := FND_API.G_RET_STS_SUCCESS;

7402: close get_sublines_csr;
7403: x_return_status := FND_API.G_RET_STS_SUCCESS;
7404: EXCEPTION
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;

Line 7410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
7414: END LOOP;

Line 7416: x_return_status := FND_API.G_RET_STS_SUCCESS;

7412: end;
7413: end if;
7414: END LOOP;
7415: close get_assg_csr;
7416: x_return_status := FND_API.G_RET_STS_SUCCESS;
7417: hr_utility.trace(' Leaving CREATE_SLINE_PPGROUP_CHANGE');
7418: EXCEPTION
7419: WHEN NO_DATA_FOUND then
7420: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7420: x_return_status := FND_API.G_RET_STS_SUCCESS;

7416: x_return_status := FND_API.G_RET_STS_SUCCESS;
7417: hr_utility.trace(' Leaving CREATE_SLINE_PPGROUP_CHANGE');
7418: EXCEPTION
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;

Line 7424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
7428:

Line 7479: x_return_status := FND_API.G_RET_STS_SUCCESS;

7475: hr_utility.trace(' Entering CREATE_SLINE_FTE_CHANGE');
7476: -- l_fte_option_value := FND_PROFILE.VALue('PSP_FTE_OPTIONS');
7477: l_fte_option_value :=psp_general.get_specific_profile('PSP_FTE_OPTIONS');
7478: if NVL(l_fte_option_value,' ') = 'BUDGET_VALUES' or l_fte_option_value IS NULL then
7479: x_return_status := FND_API.G_RET_STS_SUCCESS;
7480: return;
7481: end if;
7482: ----dbms_output.PUT_LINE('Crossed First if of FTE Change... '|| l_fte_option_value );
7483: -- l_fte_value := FND_PROFILE.VALUE('PSP_FTE_ATTRIBUTE');

Line 7486: x_return_status := FND_API.G_RET_STS_SUCCESS;

7482: ----dbms_output.PUT_LINE('Crossed First if of FTE Change... '|| l_fte_option_value );
7483: -- l_fte_value := FND_PROFILE.VALUE('PSP_FTE_ATTRIBUTE');
7484: l_fte_value:=psp_general.get_specific_profile('PSP_FTE_ATTRIBUTE');
7485: if l_fte_value IS NULL then
7486: x_return_status := FND_API.G_RET_STS_SUCCESS;
7487: return;
7488: end if;
7489: ----dbms_output.PUT_LINE('Crossed Second if of FTE Change...' || l_fte_value);
7490: l_cur_handle := dbms_sql.open_cursor;

Line 8080: x_return_status := FND_API.G_RET_STS_SUCCESS;

8076: end if;
8077: l_old_fte := l_new_fte;
8078: END LOOP;
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;

Line 8084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
8088:

Line 8091: x_return_status := FND_API.G_RET_STS_SUCCESS;

8087: end if;
8088:
8089: END LOOP;
8090: dbms_sql.close_cursor(l_cur_handle);
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');

Line 8096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
8100:

Line 8172: x_return_status := FND_API.G_RET_STS_SUCCESS;

8168: -- l_fte_option_value:= psp_general.get_specific_profile('PSP_FTE_OPTIONS'); Commented for bug 4055483
8169: /*
8170: Commented for Bug 4055483
8171: if l_fte_option_value IS NULL or l_fte_option_value <> 'BUDGET_VALUES' then
8172: x_return_status := FND_API.G_RET_STS_SUCCESS;
8173: return;
8174: end if;
8175: */
8176:

Line 8685: x_return_status := FND_API.G_RET_STS_SUCCESS;

8681: end if;
8682: l_old_value := l_new_value;
8683: END LOOP;
8684: close get_sublines_csr;
8685: x_return_status := FND_API.G_RET_STS_SUCCESS;
8686: EXCEPTION
8687: WHEN NO_DATA_FOUND then
8688: x_return_status := FND_API.G_RET_STS_SUCCESS;
8689: close get_sublines_csr;

Line 8688: x_return_status := FND_API.G_RET_STS_SUCCESS;

8684: close get_sublines_csr;
8685: x_return_status := FND_API.G_RET_STS_SUCCESS;
8686: EXCEPTION
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;

Line 8692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
8696: END LOOP;

Line 8698: x_return_status := FND_API.G_RET_STS_SUCCESS;

8694: end;
8695: end if;
8696: END LOOP;
8697: close get_assg_csr;
8698: x_return_status := FND_API.G_RET_STS_SUCCESS;
8699: hr_utility.trace(' Leaving CREATE_SLINE_BUDGET_CHANGE');
8700: EXCEPTION
8701: WHEN NO_DATA_FOUND then
8702: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8702: x_return_status := FND_API.G_RET_STS_SUCCESS;

8698: x_return_status := FND_API.G_RET_STS_SUCCESS;
8699: hr_utility.trace(' Leaving CREATE_SLINE_BUDGET_CHANGE');
8700: EXCEPTION
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;

Line 8706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
8710:

Line 8765: x_return_status:=FND_API.G_RET_STS_SUCCESS;

8761:
8762: IF l_count_asg_active > 0 THEN
8763: hr_utility.trace(' assignment_id l_count_asg_active > 0 asg = '||x_assignment_id);
8764: g_non_active_flag := 'Y';
8765: x_return_status:=FND_API.G_RET_STS_SUCCESS;
8766: return;
8767: END IF;
8768:
8769: OPEN hire_zero_days_csr;

Line 8779: x_return_status:=FND_API.G_RET_STS_SUCCESS;

8775: -- IF to_char(l_effective_start_date,'DY', 'nls_date_language=english') IN ('SUN','SAT') THEN
8776: IF (psp_general.business_days(l_effective_start_date, l_effective_start_date, x_assignment_id) = 0) THEN
8777: hr_utility.trace(' assignment starts in non working day = '||x_assignment_id);
8778: g_hire_zero_work_days := 'Y';
8779: x_return_status:=FND_API.G_RET_STS_SUCCESS;
8780: return;
8781: END IF;
8782: -- End of the changes -lveerubh
8783:

Line 8787: x_return_status:=FND_API.G_RET_STS_SUCCESS;

8783:
8784: /*Bug 5642002: Added element only on Sat Sun condition*/
8785: IF trunc(x_end_date) - trunc(x_start_date) <= 1 AND psp_general.business_days(trunc(x_start_date), trunc(x_end_date)) <= 0 THEN
8786: g_all_holiday_zero_work_days := 'Y';
8787: x_return_status:=FND_API.G_RET_STS_SUCCESS;
8788: return;
8789: END IF;
8790:
8791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8787: x_return_status:=FND_API.G_RET_STS_SUCCESS;
8788: return;
8789: END IF;
8790:
8791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8792: END IF;
8793: x_return_status:=FND_API.G_RET_STS_SUCCESS;
8794:
8795: hr_utility.trace(' Leaving CHECK_ZERO_WORK_DAYS');

Line 8793: x_return_status:=FND_API.G_RET_STS_SUCCESS;

8789: END IF;
8790:
8791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8792: END IF;
8793: x_return_status:=FND_API.G_RET_STS_SUCCESS;
8794:
8795: hr_utility.trace(' Leaving CHECK_ZERO_WORK_DAYS');
8796:
8797: EXCEPTION

Line 8809: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

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:
8813: /***************************************************************************************************

Line 8913: x_return_status := FND_API.G_RET_STS_SUCCESS;

8909: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8910: X_REASON_CODE => x_reason,
8911: X_PARENT_LINE_ID => l_sub_line_id,
8912: X_MODE => 'R');
8913: x_return_status := FND_API.G_RET_STS_SUCCESS;
8914:
8915: hr_utility.trace(' Leaving CREATE_SLINE_TERM_EMP');
8916:
8917: EXCEPTION

Line 8918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8914:
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');

Line 8920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
8924:

Line 8923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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 =================
8927:

Line 9099: p_return_status := FND_API.G_RET_STS_SUCCESS;

9095: X_PARENT_LINE_ID => l_sub_line_id,
9096: X_MODE => 'R');
9097:
9098: p_balance_amount :=l_balance_amount;
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');

Line 9102: WHEN fnd_api.g_exc_unexpected_error THEN

9098: p_balance_amount :=l_balance_amount;
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');

Line 9104: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
9108: END create_prorate_calendar;

Line 9107: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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