APPS.PSP_GENERAL dependencies on FND_API

Line 831: p_return_status := fnd_api.g_ret_sts_success;

827: p_effective_date := p_payroll_end_date ;
828: ELSE
829: p_effective_date := l_poeta_effective_date ;
830: END IF;
831: p_return_status := fnd_api.g_ret_sts_success;
832: EXCEPTION
833: WHEN OTHERS THEN
834: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','POETA_EFFECTIVE_DATE');
835: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 835: p_return_status := fnd_api.g_ret_sts_unexp_error;

831: p_return_status := fnd_api.g_ret_sts_success;
832: EXCEPTION
833: WHEN OTHERS THEN
834: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','POETA_EFFECTIVE_DATE');
835: p_return_status := fnd_api.g_ret_sts_unexp_error;
836: END poeta_effective_date;
837:
838: --------------- P O E T A E F F E C T I V E D A T E ---------------------------------
839: -- When GMS is not installed

Line 873: p_return_status := fnd_api.g_ret_sts_success;

869: p_effective_date := p_payroll_end_date ;
870: ELSE
871: p_effective_date := l_poeta_effective_date ;
872: END IF;
873: p_return_status := fnd_api.g_ret_sts_success;
874: EXCEPTION
875: WHEN OTHERS THEN
876: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','POETA_EFFECTIVE_DATE');
877: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 877: p_return_status := fnd_api.g_ret_sts_unexp_error;

873: p_return_status := fnd_api.g_ret_sts_success;
874: EXCEPTION
875: WHEN OTHERS THEN
876: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','POETA_EFFECTIVE_DATE');
877: p_return_status := fnd_api.g_ret_sts_unexp_error;
878: END poeta_effective_date;
879:
880:
881:

Line 1101: RETURN FND_API.G_TRUE ;

1097: BEGIN
1098:
1099: IF (CHECK_CLEARING_ACCT(P_BUSINESS_GROUP_ID) AND CHECK_GENERIC_SUSP_ACCT(P_BUSINESS_GROUP_ID))
1100: THEN
1101: RETURN FND_API.G_TRUE ;
1102: ELSE
1103: RETURN FND_API.G_FALSE;
1104: END IF;
1105:

Line 1103: RETURN FND_API.G_FALSE;

1099: IF (CHECK_CLEARING_ACCT(P_BUSINESS_GROUP_ID) AND CHECK_GENERIC_SUSP_ACCT(P_BUSINESS_GROUP_ID))
1100: THEN
1101: RETURN FND_API.G_TRUE ;
1102: ELSE
1103: RETURN FND_API.G_FALSE;
1104: END IF;
1105:
1106: EXCEPTION
1107: WHEN OTHERS THEN

Line 1108: RETURN FND_API.G_FALSE;

1104: END IF;
1105:
1106: EXCEPTION
1107: WHEN OTHERS THEN
1108: RETURN FND_API.G_FALSE;
1109: END;
1110:
1111: -- The following function is used to perform an Award Date Validation
1112: FUNCTION AWARD_DATE_VALIDATION(P_AWARD_ID IN NUMBER,

Line 1351: p_return_status := fnd_api.g_ret_sts_success;

1347: BEGIN
1348: OPEN percent_effort_cur;
1349: FETCH percent_effort_cur INTO p_percent_effort;
1350: CLOSE percent_effort_cur;
1351: p_return_status := fnd_api.g_ret_sts_success;
1352: EXCEPTION
1353: WHEN OTHERS THEN
1354: p_return_status := fnd_api.g_ret_sts_unexp_error;
1355: fnd_msg_pub.add_exc_msg

Line 1354: p_return_status := fnd_api.g_ret_sts_unexp_error;

1350: CLOSE percent_effort_cur;
1351: p_return_status := fnd_api.g_ret_sts_success;
1352: EXCEPTION
1353: WHEN OTHERS THEN
1354: p_return_status := fnd_api.g_ret_sts_unexp_error;
1355: fnd_msg_pub.add_exc_msg
1356: (p_pkg_name => 'PSP_GENERAL',
1357: p_procedure_name => 'IGW_PERCENT_EFFORT');
1358: fnd_msg_pub.count_and_get

Line 1619: RAISE fnd_api.g_exc_unexpected_error;

1615: IF get_curr_for_bg%NOTFOUND THEN
1616:
1617: FND_MESSAGE.SET_NAME('PSP' , 'PSP_HR_CUR_NOT_SET_UP');
1618: CLOSE get_curr_for_bg;
1619: RAISE fnd_api.g_exc_unexpected_error;
1620:
1621: ELSE
1622:
1623: CLOSE get_curr_for_bg;

Line 2893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2889: AND organization_id = p_expenditure_organization_id
2890: AND rownum=1;
2891: EXCEPTION
2892: WHEN NO_DATA_FOUND THEN
2893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2894: END;
2895: Else
2896: */
2897: -- get the org_id for the project..

Line 2905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2901: FROM pa_projects_all
2902: WHERE project_id = p_project_Id;
2903: EXCEPTION
2904: WHEN NO_DATA_FOUND THEN
2905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2906: END;
2907: -- END IF;
2908: G_PREV_PROJ_ID := p_project_id;
2909: G_PREV_ORG_ID := l_org_id;