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.PA_R_PROJECT_RESOURCES_PVT dependencies on FND_API

Line 579: X_RETURN_STATUS := fnd_api.g_ret_sts_success;

575: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
576: END IF;
577: log_message('Inside insert_into_crm procedure');
578:
579: X_RETURN_STATUS := fnd_api.g_ret_sts_success;
580:
581: open cur_crmid(l_person_id,l_category);
582: fetch cur_crmid into l_crm_resource_id;
583: close cur_crmid;

Line 613: x_return_status := FND_API.G_RET_STS_ERROR;

609: END IF;
610: PA_UTILS.Add_Message(
611: p_app_short_name => 'PA'
612: ,p_msg_name => 'PA_INVALID_CAL_SETUP');
613: x_return_status := FND_API.G_RET_STS_ERROR;
614: RAISE FND_API.G_EXC_ERROR;
615: end if;
616:
617: -------------------------------------------

Line 614: RAISE FND_API.G_EXC_ERROR;

610: PA_UTILS.Add_Message(
611: p_app_short_name => 'PA'
612: ,p_msg_name => 'PA_INVALID_CAL_SETUP');
613: x_return_status := FND_API.G_RET_STS_ERROR;
614: RAISE FND_API.G_EXC_ERROR;
615: end if;
616:
617: -------------------------------------------
618: -- Resource does not exist in CRM

Line 667: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

663: p_assignment_start_date => p_assignment_start_date,
664: x_return_status => x_return_status,
665: x_error_message_code => l_msg_data);
666:
667: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
668: log_message('Error in CRM Public API');
669: pa_debug.g_err_stage := 'Log: Error in CRM Workaround Workflow API';
670: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
671: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

Line 673: x_return_status := FND_API.G_RET_STS_ERROR;

669: pa_debug.g_err_stage := 'Log: Error in CRM Workaround Workflow API';
670: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
671: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
672: END IF;
673: x_return_status := FND_API.G_RET_STS_ERROR;
674: CLOSE c_per_active;
675: RAISE FND_API.G_EXC_ERROR;
676: END IF;
677:

Line 675: RAISE FND_API.G_EXC_ERROR;

671: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
672: END IF;
673: x_return_status := FND_API.G_RET_STS_ERROR;
674: CLOSE c_per_active;
675: RAISE FND_API.G_EXC_ERROR;
676: END IF;
677:
678: G_p_crmwf_id := p_person_id;
679: end if;

Line 685: P_INIT_MSG_LIST => FND_API.G_FALSE,

681: ELSE
682:
683: jtf_rs_resource_pub.create_resource(
684: P_API_VERSION => 1.0,
685: P_INIT_MSG_LIST => FND_API.G_FALSE,
686: P_COMMIT => FND_API.G_FALSE,
687: P_CATEGORY => l_category,
688: P_SOURCE_ID => l_person_id,
689: P_ADDRESS_ID => NULL,

Line 686: P_COMMIT => FND_API.G_FALSE,

682:
683: jtf_rs_resource_pub.create_resource(
684: P_API_VERSION => 1.0,
685: P_INIT_MSG_LIST => FND_API.G_FALSE,
686: P_COMMIT => FND_API.G_FALSE,
687: P_CATEGORY => l_category,
688: P_SOURCE_ID => l_person_id,
689: P_ADDRESS_ID => NULL,
690: P_CONTACT_ID => NULL,

Line 738: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

734: P_SOURCE_FIRST_NAME => P_SOURCE_FIRST_NAME,
735: P_SOURCE_LAST_NAME => P_SOURCE_LAST_NAME,
736: P_SOURCE_MIDDLE_NAME => P_SOURCE_MIDDLE_NAME );
737:
738: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
739: log_message('Error in CRM Public API');
740: pa_debug.g_err_stage := 'Log: Error in CRM Public API';
741: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
742: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

Line 745: x_return_status := FND_API.G_RET_STS_ERROR;

741: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
742: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
743: END IF;
744:
745: x_return_status := FND_API.G_RET_STS_ERROR;
746: CLOSE c_per_active;
747: RAISE FND_API.G_EXC_ERROR;
748: END IF;
749:

Line 747: RAISE FND_API.G_EXC_ERROR;

743: END IF;
744:
745: x_return_status := FND_API.G_RET_STS_ERROR;
746: CLOSE c_per_active;
747: RAISE FND_API.G_EXC_ERROR;
748: END IF;
749:
750: pa_debug.g_err_stage := 'Log: After call to CRM Public API. CRM_RESOURCE_ID := ' || to_char(l_crm_resource_id);
751: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 1054: x_return_status := FND_API.G_RET_STS_ERROR;

1050: pa_debug.g_err_stage := 'Log: Error in CRM Table Handler API for INSERT_ROW';
1051: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1052: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1053: END IF;
1054: x_return_status := FND_API.G_RET_STS_ERROR;
1055: RAISE FND_API.G_EXC_ERROR;
1056: END IF;
1057:
1058:

Line 1055: RAISE FND_API.G_EXC_ERROR;

1051: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1052: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1053: END IF;
1054: x_return_status := FND_API.G_RET_STS_ERROR;
1055: RAISE FND_API.G_EXC_ERROR;
1056: END IF;
1057:
1058:
1059: OPEN c_jtf_cal(l_cal_resource_assign_id);

Line 1064: x_return_status := FND_API.G_RET_STS_ERROR;

1060: FETCH c_jtf_cal into l_rowid;
1061: IF (c_jtf_cal%NOTFOUND) THEN
1062: log_message('c_jtf_cal not found');
1063: CLOSE c_jtf_cal;
1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065: RAISE fnd_api.g_exc_error;
1066: END IF;
1067: CLOSE c_jtf_cal;
1068:

Line 1065: RAISE fnd_api.g_exc_error;

1061: IF (c_jtf_cal%NOTFOUND) THEN
1062: log_message('c_jtf_cal not found');
1063: CLOSE c_jtf_cal;
1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065: RAISE fnd_api.g_exc_error;
1066: END IF;
1067: CLOSE c_jtf_cal;
1068:
1069:

Line 1084: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1080: X_MSG_DATA => l_msg_data );
1081:
1082: log_message('return status for calendar validity: ' || x_return_status);
1083:
1084: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1085: pa_debug.g_err_stage := 'Log: Calendar is not valid';
1086: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1087: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1088: END IF;

Line 1089: x_return_status := FND_API.G_RET_STS_ERROR;

1085: pa_debug.g_err_stage := 'Log: Calendar is not valid';
1086: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1087: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1088: END IF;
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090: RAISE FND_API.G_EXC_ERROR;
1091: END IF;
1092:
1093: pa_debug.g_err_stage := 'Log: After insert into jtf_cal_resource_assign';

Line 1090: RAISE FND_API.G_EXC_ERROR;

1086: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1087: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1088: END IF;
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090: RAISE FND_API.G_EXC_ERROR;
1091: END IF;
1092:
1093: pa_debug.g_err_stage := 'Log: After insert into jtf_cal_resource_assign';
1094: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 1112: WHEN fnd_api.g_exc_error THEN

1108:
1109: PA_DEBUG.Reset_Err_Stack;
1110:
1111: EXCEPTION
1112: WHEN fnd_api.g_exc_error THEN
1113: x_return_status := FND_API.G_RET_STS_ERROR;
1114: X_CRM_RESOURCE_ID := NULL ; -- 4537865 RESET OUT PARAM
1115: WHEN OTHERS THEN
1116: X_CRM_RESOURCE_ID := NULL ; -- 4537865 RESET OUT PARAM

Line 1113: x_return_status := FND_API.G_RET_STS_ERROR;

1109: PA_DEBUG.Reset_Err_Stack;
1110:
1111: EXCEPTION
1112: WHEN fnd_api.g_exc_error THEN
1113: x_return_status := FND_API.G_RET_STS_ERROR;
1114: X_CRM_RESOURCE_ID := NULL ; -- 4537865 RESET OUT PARAM
1115: WHEN OTHERS THEN
1116: X_CRM_RESOURCE_ID := NULL ; -- 4537865 RESET OUT PARAM
1117: -- Set the exception Message and the stack

Line 1120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1116: X_CRM_RESOURCE_ID := NULL ; -- 4537865 RESET OUT PARAM
1117: -- Set the exception Message and the stack
1118: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Insert_into_CRM'
1119: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1121: RAISE;
1122: END INSERT_INTO_CRM;
1123:
1124: /*Procedure : PA Insert

Line 1181: X_RETURN_STATUS := fnd_api.g_ret_sts_success;

1177: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1178: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1179: END IF;
1180:
1181: X_RETURN_STATUS := fnd_api.g_ret_sts_success;
1182:
1183: --Fetch unique resource_id from sequence.
1184: LOOP
1185: Select pa_resources_s.nextval

Line 1310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1306: WHEN OTHERS THEN
1307: -- Set the exception Message and the stack
1308: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Insert_into_PA'
1309: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1311: -- 4537865
1312: x_resource_id := NULL ;
1313: RAISE;
1314:

Line 1340: X_RETURN_STATUS := fnd_api.g_ret_sts_success;

1336: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1337: END IF;
1338: log_message('Start of check_ou procedure');
1339:
1340: X_RETURN_STATUS := fnd_api.g_ret_sts_success;
1341:
1342: IF (p_default_OU IS NOT NULL) THEN
1343: --Check if OU is Expenditure OU
1344: log_message('Calling Check_Exp_OU');

Line 1351: IF (l_valid = fnd_api.g_ret_sts_success) THEN

1347: ,x_return_status => l_valid
1348: ,x_error_message_code => l_code);
1349: log_message('After Check_Exp_OU');
1350:
1351: IF (l_valid = fnd_api.g_ret_sts_success) THEN
1352: --If OU is Exp OU
1353: x_exp_ou := 'Y';
1354: x_return_status := fnd_api.g_ret_sts_success;
1355: ELSE

Line 1354: x_return_status := fnd_api.g_ret_sts_success;

1350:
1351: IF (l_valid = fnd_api.g_ret_sts_success) THEN
1352: --If OU is Exp OU
1353: x_exp_ou := 'Y';
1354: x_return_status := fnd_api.g_ret_sts_success;
1355: ELSE
1356: --If OU is not Exp OU
1357: --The code below is commented because for singlr org
1358: --implementations the default OU need not be

Line 1385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1381: WHEN OTHERS THEN
1382: -- Set the exception Message and the stack
1383: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Check_OU'
1384: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1386: -- 4537865
1387: x_exp_ou := NULL ;
1388: raise;
1389:

Line 1475: X_RETURN_STATUS := fnd_api.g_ret_sts_success;

1471: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1472: END IF;
1473: log_message('Inside create_internal_resource procedure');
1474:
1475: X_RETURN_STATUS := fnd_api.g_ret_sts_success;
1476:
1477: --Check to see if resource exists in PA
1478: IF (p_res_exists = 'NOT EXISTS') THEN
1479:

Line 1526: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1522: P_SOURCE_FIRST_NAME => P_SOURCE_FIRST_NAME,
1523: P_SOURCE_LAST_NAME => P_SOURCE_LAST_NAME,
1524: P_SOURCE_MIDDLE_NAME => P_SOURCE_MIDDLE_NAME);
1525:
1526: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1527: RAISE FND_API.G_EXC_ERROR;
1528: END IF;
1529:
1530: pa_debug.g_err_stage := 'Log: After Insert_into_CRM procedure ';

Line 1527: RAISE FND_API.G_EXC_ERROR;

1523: P_SOURCE_LAST_NAME => P_SOURCE_LAST_NAME,
1524: P_SOURCE_MIDDLE_NAME => P_SOURCE_MIDDLE_NAME);
1525:
1526: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1527: RAISE FND_API.G_EXC_ERROR;
1528: END IF;
1529:
1530: pa_debug.g_err_stage := 'Log: After Insert_into_CRM procedure ';
1531: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 1659: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1655: log_message(' Out of insert_into_crm procedure');
1656: log_message('x_crm_resource_id = ' || x_crm_resource_id);
1657: log_message('p_person_id = ' || p_person_id);
1658:
1659: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1660: RAISE FND_API.G_EXC_ERROR;
1661: END IF;
1662:
1663: pa_debug.g_err_stage := 'Log: Get resource_id for person_id';

Line 1660: RAISE FND_API.G_EXC_ERROR;

1656: log_message('x_crm_resource_id = ' || x_crm_resource_id);
1657: log_message('p_person_id = ' || p_person_id);
1658:
1659: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1660: RAISE FND_API.G_EXC_ERROR;
1661: END IF;
1662:
1663: pa_debug.g_err_stage := 'Log: Get resource_id for person_id';
1664: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 1699: RAISE fnd_api.g_exc_error;

1695: -- and do nothing
1696: -- person not pulled because of above reason
1697: ----------------------------------------------------
1698: IF SQL%FOUND THEN
1699: RAISE fnd_api.g_exc_error;
1700: END IF;
1701: EXCEPTION
1702: WHEN NO_DATA_FOUND THEN
1703: NULL;

Line 1765: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1761: P_SOURCE_FIRST_NAME => P_SOURCE_FIRST_NAME,
1762: P_SOURCE_LAST_NAME => P_SOURCE_LAST_NAME,
1763: P_SOURCE_MIDDLE_NAME => P_SOURCE_MIDDLE_NAME);
1764:
1765: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1766: RAISE FND_API.G_EXC_ERROR;
1767: END IF;
1768:
1769: pa_debug.g_err_stage := 'Log: After Insert_into_CRM procedure';

Line 1766: RAISE FND_API.G_EXC_ERROR;

1762: P_SOURCE_LAST_NAME => P_SOURCE_LAST_NAME,
1763: P_SOURCE_MIDDLE_NAME => P_SOURCE_MIDDLE_NAME);
1764:
1765: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1766: RAISE FND_API.G_EXC_ERROR;
1767: END IF;
1768:
1769: pa_debug.g_err_stage := 'Log: After Insert_into_CRM procedure';
1770: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 1787: WHEN FND_API.G_EXC_ERROR THEN

1783: log_message('End of create_internal_resource procedure');
1784:
1785: PA_DEBUG.Reset_Err_Stack;
1786: EXCEPTION
1787: WHEN FND_API.G_EXC_ERROR THEN
1788: x_return_status := FND_API.G_RET_STS_ERROR;
1789: -- 4537865
1790: x_resource_id := NULL ;
1791: WHEN OTHERS THEN

Line 1788: x_return_status := FND_API.G_RET_STS_ERROR;

1784:
1785: PA_DEBUG.Reset_Err_Stack;
1786: EXCEPTION
1787: WHEN FND_API.G_EXC_ERROR THEN
1788: x_return_status := FND_API.G_RET_STS_ERROR;
1789: -- 4537865
1790: x_resource_id := NULL ;
1791: WHEN OTHERS THEN
1792: -- Set the exception Message and the stack

Line 1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1791: WHEN OTHERS THEN
1792: -- Set the exception Message and the stack
1793: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Create_Internal_Resource'
1794: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1796: -- 4537865
1797: x_resource_id := NULL ;
1798:
1799: RAISE;

Line 1836: X_RETURN_STATUS := fnd_api.g_ret_sts_success;

1832: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1833: END IF;
1834: log_message('Inside create_external_resource procedure');
1835:
1836: X_RETURN_STATUS := fnd_api.g_ret_sts_success;
1837:
1838: --to get the resource type id for code HZ_PARTY
1839: select resource_type_id into l_resource_type_id
1840: from pa_resource_types

Line 1919: WHEN FND_API.G_EXC_ERROR THEN

1915: log_message('End of create_external_resource procedure');
1916:
1917: PA_DEBUG.Reset_Err_Stack;
1918: EXCEPTION
1919: WHEN FND_API.G_EXC_ERROR THEN
1920: x_return_status := FND_API.G_RET_STS_ERROR;
1921: -- 4537865
1922: x_resource_id := NULL ;
1923: WHEN OTHERS THEN

Line 1920: x_return_status := FND_API.G_RET_STS_ERROR;

1916:
1917: PA_DEBUG.Reset_Err_Stack;
1918: EXCEPTION
1919: WHEN FND_API.G_EXC_ERROR THEN
1920: x_return_status := FND_API.G_RET_STS_ERROR;
1921: -- 4537865
1922: x_resource_id := NULL ;
1923: WHEN OTHERS THEN
1924: -- Set the exception Message and the stack

Line 1927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1923: WHEN OTHERS THEN
1924: -- Set the exception Message and the stack
1925: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Create_External_Resource'
1926: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1928: -- 4537865
1929: x_resource_id := NULL ;
1930: RAISE;
1931: END CREATE_EXTERNAL_RESOURCE;

Line 2170: IF p_commit = fnd_api.g_true THEN

2166:
2167:
2168: BEGIN
2169:
2170: IF p_commit = fnd_api.g_true THEN
2171: SAVEPOINT res_pvt_create_resource;
2172: END IF;
2173:
2174: PA_DEBUG.set_err_stack('Create_Resource');

Line 2184: X_RETURN_STATUS := fnd_api.g_ret_sts_success;

2180: G_user_id := '1014';
2181: G_login_id := '-1';
2182: end if;
2183:
2184: X_RETURN_STATUS := fnd_api.g_ret_sts_success;
2185:
2186: --If internal resource
2187: IF (l_internal = 'Y' ) THEN
2188: pa_debug.g_err_stage := 'Log: For Internal Resources';

Line 2214: IF p_commit = fnd_api.g_true THEN

2210: BEGIN
2211:
2212: -- do savepoint for every assignment
2213: -- if error occurs, it will rollback the assignment
2214: IF p_commit = fnd_api.g_true THEN
2215: SAVEPOINT res_pvt_create_resource;
2216: END IF;
2217: log_message('do SAVEPOINT for person:' || eRec.person_id || ' and assignment: ' || eRec.assignment_start_date);
2218:

Line 2322: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2318: x_resource_id := l_res_id ;
2319:
2320: END IF;
2321:
2322: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2323: x_return_status := FND_API.G_RET_STS_ERROR;
2324: RAISE FND_API.G_EXC_ERROR;
2325: END IF;
2326:

Line 2323: x_return_status := FND_API.G_RET_STS_ERROR;

2319:
2320: END IF;
2321:
2322: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2323: x_return_status := FND_API.G_RET_STS_ERROR;
2324: RAISE FND_API.G_EXC_ERROR;
2325: END IF;
2326:
2327: RETURN; --Exit out of resource API

Line 2324: RAISE FND_API.G_EXC_ERROR;

2320: END IF;
2321:
2322: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2323: x_return_status := FND_API.G_RET_STS_ERROR;
2324: RAISE FND_API.G_EXC_ERROR;
2325: END IF;
2326:
2327: RETURN; --Exit out of resource API
2328:

Line 2367: x_return_status := FND_API.G_RET_STS_ERROR;

2363: PA_UTILS.Add_Message(
2364: p_app_short_name => 'PA'
2365: ,p_msg_name => 'PA_NO_EXP_HIER');
2366:
2367: x_return_status := FND_API.G_RET_STS_ERROR;
2368: RAISE FND_API.G_EXC_ERROR;
2369: End If;
2370:
2371: -----------------------------------------------------

Line 2368: RAISE FND_API.G_EXC_ERROR;

2364: p_app_short_name => 'PA'
2365: ,p_msg_name => 'PA_NO_EXP_HIER');
2366:
2367: x_return_status := FND_API.G_RET_STS_ERROR;
2368: RAISE FND_API.G_EXC_ERROR;
2369: End If;
2370:
2371: -----------------------------------------------------
2372: -- Check if Job Utilizable_flag=N, if so, error out

Line 2389: x_return_status := FND_API.G_RET_STS_ERROR;

2385: -- Changed the msg since the utilizable_job doesn't
2386: -- really make sense for the Add Team Member page.
2387: -- ,p_msg_name => 'PA_NON_UTILIZABLE_JOB');
2388:
2389: x_return_status := FND_API.G_RET_STS_ERROR;
2390: RAISE FND_API.G_EXC_ERROR;
2391: END IF;
2392: END IF;
2393: END IF;

Line 2390: RAISE FND_API.G_EXC_ERROR;

2386: -- really make sense for the Add Team Member page.
2387: -- ,p_msg_name => 'PA_NON_UTILIZABLE_JOB');
2388:
2389: x_return_status := FND_API.G_RET_STS_ERROR;
2390: RAISE FND_API.G_EXC_ERROR;
2391: END IF;
2392: END IF;
2393: END IF;
2394:

Line 2429: IF p_commit = fnd_api.g_true THEN

2425:
2426: -- do timeline savepoint ONCE for the resource
2427: -- if timeline error occurs, it will rollback for every assignments
2428: -- of this resource and raise an error
2429: IF p_commit = fnd_api.g_true THEN
2430: SAVEPOINT timeline_save;
2431: END IF;
2432:
2433: --Call check_res_exists procedure

Line 2487: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2483: P_SOURCE_LAST_NAME => eRec.per_last_name,
2484: P_SOURCE_MIDDLE_NAME => eRec.per_middle_name);
2485: log_message('After Create internal resource'|| x_return_status);
2486:
2487: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2488: x_return_status := FND_API.G_RET_STS_ERROR;
2489: RAISE FND_API.G_EXC_ERROR;
2490: END IF;
2491:

Line 2488: x_return_status := FND_API.G_RET_STS_ERROR;

2484: P_SOURCE_MIDDLE_NAME => eRec.per_middle_name);
2485: log_message('After Create internal resource'|| x_return_status);
2486:
2487: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2488: x_return_status := FND_API.G_RET_STS_ERROR;
2489: RAISE FND_API.G_EXC_ERROR;
2490: END IF;
2491:
2492: -------------------------------------------------------------------------------

Line 2489: RAISE FND_API.G_EXC_ERROR;

2485: log_message('After Create internal resource'|| x_return_status);
2486:
2487: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2488: x_return_status := FND_API.G_RET_STS_ERROR;
2489: RAISE FND_API.G_EXC_ERROR;
2490: END IF;
2491:
2492: -------------------------------------------------------------------------------
2493: --Adding call to check if OU implements Projects only if the org is a multi-org

Line 2519: x_return_status := FND_API.G_RET_STS_ERROR;

2515: END IF;
2516: PA_UTILS.Add_Message(
2517: p_app_short_name => 'PA'
2518: ,p_msg_name => 'PA_OU_NO_PROJECTS');
2519: x_return_status := FND_API.G_RET_STS_ERROR;
2520:
2521: RAISE FND_API.G_EXC_ERROR;
2522: END IF;
2523:

Line 2521: RAISE FND_API.G_EXC_ERROR;

2517: p_app_short_name => 'PA'
2518: ,p_msg_name => 'PA_OU_NO_PROJECTS');
2519: x_return_status := FND_API.G_RET_STS_ERROR;
2520:
2521: RAISE FND_API.G_EXC_ERROR;
2522: END IF;
2523:
2524: log_message('After check_ou '|| x_return_status);
2525:

Line 2615: , p_commit => fnd_api.G_false

2611: , p_manager_name => l_supervisor_name
2612: , p_request_id => G_request_id
2613: , p_program_application_id => G_application_id
2614: , p_program_id => G_program_id
2615: , p_commit => fnd_api.G_false
2616: , p_validate_only => fnd_api.G_false
2617: , x_msg_data => x_msg_data
2618: , x_msg_count => x_msg_count
2619: , x_return_status => x_return_status);

Line 2616: , p_validate_only => fnd_api.G_false

2612: , p_request_id => G_request_id
2613: , p_program_application_id => G_application_id
2614: , p_program_id => G_program_id
2615: , p_commit => fnd_api.G_false
2616: , p_validate_only => fnd_api.G_false
2617: , x_msg_data => x_msg_data
2618: , x_msg_count => x_msg_count
2619: , x_return_status => x_return_status);
2620:

Line 2632: WHEN FND_API.G_EXC_ERROR THEN

2628:
2629: END IF; /* End l_exp_org=YES check - for scheduled member only */
2630:
2631: EXCEPTION
2632: WHEN FND_API.G_EXC_ERROR THEN
2633: IF p_commit = fnd_api.g_true THEN
2634: ROLLBACK TO res_pvt_create_resource;
2635: END IF;
2636:

Line 2633: IF p_commit = fnd_api.g_true THEN

2629: END IF; /* End l_exp_org=YES check - for scheduled member only */
2630:
2631: EXCEPTION
2632: WHEN FND_API.G_EXC_ERROR THEN
2633: IF p_commit = fnd_api.g_true THEN
2634: ROLLBACK TO res_pvt_create_resource;
2635: END IF;
2636:
2637: log_message('ROLLBACK for this assignment');

Line 2650: RAISE FND_API.G_EXC_ERROR;

2646: log_message('The value of l_res_found is ' || l_res_found);
2647:
2648: IF (l_res_found = 'N') THEN
2649: validate_person(P_PERSON_ID);
2650: RAISE FND_API.G_EXC_ERROR;
2651:
2652: -- for scheduled resource found in loop
2653: ELSIF (l_res_found = 'Y') THEN
2654:

Line 2658: x_return_status := FND_API.G_RET_STS_ERROR;

2654:
2655: -- if all HR assignments fail, then just rollback and
2656: -- raise an expected error
2657: IF l_at_least_one_success = 'N' THEN
2658: x_return_status := FND_API.G_RET_STS_ERROR;
2659: log_message('All HR assignments failed - raise an expected error');
2660:
2661: RAISE FND_API.G_EXC_ERROR;
2662: END IF;

Line 2661: RAISE FND_API.G_EXC_ERROR;

2657: IF l_at_least_one_success = 'N' THEN
2658: x_return_status := FND_API.G_RET_STS_ERROR;
2659: log_message('All HR assignments failed - raise an expected error');
2660:
2661: RAISE FND_API.G_EXC_ERROR;
2662: END IF;
2663:
2664: -- create timeline when check resource No OR
2665: -- check resource Yes and resource does not exist

Line 2679: IF ((l_invol_term = 'N') AND (x_return_status = FND_API.G_RET_STS_SUCCESS )) THEN

2675: x_msg_count => x_msg_count);
2676: log_message('After Calling pa_resource_utils.init_fte_sync_wf, x_return_status: '||x_return_status); --bug 5683340
2677:
2678: /*IF - ELSIF block added for bug 5683340*/
2679: IF ((l_invol_term = 'N') AND (x_return_status = FND_API.G_RET_STS_SUCCESS )) THEN
2680:
2681: -- Call Create Timeline after all assignments are in
2682: -- resource denorm table
2683: log_message('Calling Create_Timeline procedure');

Line 2698: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2694:
2695: log_message('After timeline call: '|| x_return_status);
2696: log_message('Out of Create_Timeline procedure');
2697:
2698: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2699: x_return_status := FND_API.G_RET_STS_ERROR;
2700:
2701: -- timeline error occurs
2702: -- rollback for all assignments of this resource

Line 2699: x_return_status := FND_API.G_RET_STS_ERROR;

2695: log_message('After timeline call: '|| x_return_status);
2696: log_message('Out of Create_Timeline procedure');
2697:
2698: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2699: x_return_status := FND_API.G_RET_STS_ERROR;
2700:
2701: -- timeline error occurs
2702: -- rollback for all assignments of this resource
2703: -- also raise an error

Line 2704: IF p_commit = fnd_api.g_true THEN

2700:
2701: -- timeline error occurs
2702: -- rollback for all assignments of this resource
2703: -- also raise an error
2704: IF p_commit = fnd_api.g_true THEN
2705: ROLLBACK TO timeline_save;
2706: END IF;
2707:
2708: log_message('Timeline errors out - rollback all assignments for this resource');

Line 2710: RAISE FND_API.G_EXC_ERROR;

2706: END IF;
2707:
2708: log_message('Timeline errors out - rollback all assignments for this resource');
2709:
2710: RAISE FND_API.G_EXC_ERROR;
2711: END IF;
2712:
2713: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN -- for bug 5683340
2714: log_message(' Call to pa_resource_utils.init_fte_sync_wf errored in individual pull');

Line 2713: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN -- for bug 5683340

2709:
2710: RAISE FND_API.G_EXC_ERROR;
2711: END IF;
2712:
2713: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN -- for bug 5683340
2714: log_message(' Call to pa_resource_utils.init_fte_sync_wf errored in individual pull');
2715: RAISE FND_API.G_EXC_ERROR;
2716:
2717: END IF ; --IF ((l_invol_term = 'N') AND (x_return_status = FND_API.G_RET_STS_SUCCESS )) bug 5683340

Line 2715: RAISE FND_API.G_EXC_ERROR;

2711: END IF;
2712:
2713: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN -- for bug 5683340
2714: log_message(' Call to pa_resource_utils.init_fte_sync_wf errored in individual pull');
2715: RAISE FND_API.G_EXC_ERROR;
2716:
2717: END IF ; --IF ((l_invol_term = 'N') AND (x_return_status = FND_API.G_RET_STS_SUCCESS )) bug 5683340
2718:
2719: END IF;

Line 2717: END IF ; --IF ((l_invol_term = 'N') AND (x_return_status = FND_API.G_RET_STS_SUCCESS )) bug 5683340

2713: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN -- for bug 5683340
2714: log_message(' Call to pa_resource_utils.init_fte_sync_wf errored in individual pull');
2715: RAISE FND_API.G_EXC_ERROR;
2716:
2717: END IF ; --IF ((l_invol_term = 'N') AND (x_return_status = FND_API.G_RET_STS_SUCCESS )) bug 5683340
2718:
2719: END IF;
2720:
2721: -- remove unwanted error message from the stack

Line 2738: x_return_status := FND_API.G_RET_STS_SUCCESS;

2734: END LOOP;
2735:
2736: end if;
2737:
2738: x_return_status := FND_API.G_RET_STS_SUCCESS;
2739: log_message('Return success if at least one assignment is a success');
2740: end if;
2741:
2742: END IF;

Line 3027: IF (fnd_api.to_boolean(p_commit)) THEN

3023: end if;
3024:
3025:
3026: IF (i = l_max_count and G_person_id <> l_person_id ) THEN
3027: IF (fnd_api.to_boolean(p_commit)) THEN
3028: COMMIT WORK;
3029: log_message('Commit work - lock released');
3030: pa_debug.g_err_stage := 'Log: COMMIT for person_id = ' || G_person_id;
3031: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 3068: IF (fnd_api.to_boolean(p_commit)) THEN

3064:
3065: G_person_id := l_person_id;
3066: log_message('G_person_id value - enter if condition = ' || G_person_id);
3067:
3068: IF (fnd_api.to_boolean(p_commit)) THEN
3069: log_message('set SAVEPOINT for G_person_id' || G_person_id);
3070: SAVEPOINT res_pvt_create_resource;
3071: END IF;
3072:

Line 3100: RAISE FND_API.G_EXC_ERROR;

3096: -- set the variable to N so in the next loop, if it is the same person Id
3097: -- too, that will raise person_error_exception and the code will not
3098: -- process this person
3099: l_per_success := 'N';
3100: RAISE FND_API.G_EXC_ERROR;
3101:
3102: else
3103: pa_debug.g_err_stage := 'Log: Able to acquire LOCK for person_id = ' || l_person_id;
3104: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 3254: -- IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3250: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3251: END IF;
3252:
3253: -- Commenting For bug 4087022
3254: -- IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3255: -- x_return_status := FND_API.G_RET_STS_ERROR;
3256: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3257: l_return_status := FND_API.G_RET_STS_ERROR;
3258: l_per_success := 'N';

Line 3255: -- x_return_status := FND_API.G_RET_STS_ERROR;

3251: END IF;
3252:
3253: -- Commenting For bug 4087022
3254: -- IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3255: -- x_return_status := FND_API.G_RET_STS_ERROR;
3256: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3257: l_return_status := FND_API.G_RET_STS_ERROR;
3258: l_per_success := 'N';
3259: RAISE FND_API.G_EXC_ERROR;

Line 3256: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3252:
3253: -- Commenting For bug 4087022
3254: -- IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3255: -- x_return_status := FND_API.G_RET_STS_ERROR;
3256: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3257: l_return_status := FND_API.G_RET_STS_ERROR;
3258: l_per_success := 'N';
3259: RAISE FND_API.G_EXC_ERROR;
3260: END IF;

Line 3257: l_return_status := FND_API.G_RET_STS_ERROR;

3253: -- Commenting For bug 4087022
3254: -- IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3255: -- x_return_status := FND_API.G_RET_STS_ERROR;
3256: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3257: l_return_status := FND_API.G_RET_STS_ERROR;
3258: l_per_success := 'N';
3259: RAISE FND_API.G_EXC_ERROR;
3260: END IF;
3261:

Line 3259: RAISE FND_API.G_EXC_ERROR;

3255: -- x_return_status := FND_API.G_RET_STS_ERROR;
3256: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3257: l_return_status := FND_API.G_RET_STS_ERROR;
3258: l_per_success := 'N';
3259: RAISE FND_API.G_EXC_ERROR;
3260: END IF;
3261:
3262: log_message('After calling CREATE_INTERNAL_RESOURCE procedure');
3263:

Line 3297: -- x_return_status := FND_API.G_RET_STS_ERROR; -- Commenting For bug 4087022

3293: END IF;
3294: PA_UTILS.Add_Message(
3295: p_app_short_name => 'PA'
3296: ,p_msg_name => 'PA_OU_NO_PROJECTS');
3297: -- x_return_status := FND_API.G_RET_STS_ERROR; -- Commenting For bug 4087022
3298: l_return_status := FND_API.G_RET_STS_ERROR;
3299: l_per_success := 'N';
3300:
3301: RAISE FND_API.G_EXC_ERROR;

Line 3298: l_return_status := FND_API.G_RET_STS_ERROR;

3294: PA_UTILS.Add_Message(
3295: p_app_short_name => 'PA'
3296: ,p_msg_name => 'PA_OU_NO_PROJECTS');
3297: -- x_return_status := FND_API.G_RET_STS_ERROR; -- Commenting For bug 4087022
3298: l_return_status := FND_API.G_RET_STS_ERROR;
3299: l_per_success := 'N';
3300:
3301: RAISE FND_API.G_EXC_ERROR;
3302: END IF;

Line 3301: RAISE FND_API.G_EXC_ERROR;

3297: -- x_return_status := FND_API.G_RET_STS_ERROR; -- Commenting For bug 4087022
3298: l_return_status := FND_API.G_RET_STS_ERROR;
3299: l_per_success := 'N';
3300:
3301: RAISE FND_API.G_EXC_ERROR;
3302: END IF;
3303:
3304: -- log_message('After check_ou '|| x_return_status); -- Commenting For bug 4087022
3305: log_message('After check_ou '|| l_return_status);

Line 3361: , p_commit => fnd_api.G_false

3357: , p_manager_name => l_supervisor_name
3358: , p_request_id => G_request_id
3359: , p_program_application_id => G_application_id
3360: , p_program_id => G_program_id
3361: , p_commit => fnd_api.G_false
3362: , p_validate_only => fnd_api.G_false
3363: , x_msg_data => x_msg_data
3364: , x_msg_count => x_msg_count
3365: -- , x_return_status => x_return_status); -- Commenting For bug 4087022

Line 3362: , p_validate_only => fnd_api.G_false

3358: , p_request_id => G_request_id
3359: , p_program_application_id => G_application_id
3360: , p_program_id => G_program_id
3361: , p_commit => fnd_api.G_false
3362: , p_validate_only => fnd_api.G_false
3363: , x_msg_data => x_msg_data
3364: , x_msg_count => x_msg_count
3365: -- , x_return_status => x_return_status); -- Commenting For bug 4087022
3366: , x_return_status => l_return_status);

Line 3475: -- IF ((l_invol_term = 'N') AND (x_return_status = fnd_api.g_ret_sts_success )) THEN -- Commenting For bug 4087022

3471: END IF;
3472:
3473:
3474: /*IF - ELSIF block added for bug 5683340*/
3475: -- IF ((l_invol_term = 'N') AND (x_return_status = fnd_api.g_ret_sts_success )) THEN -- Commenting For bug 4087022
3476: IF ((l_invol_term = 'N') AND (l_return_status = fnd_api.g_ret_sts_success )) THEN
3477: pa_debug.g_err_stage := 'Log: Calling Create_Timeline procedure for PersonId =' || to_char(l_person_id) ;
3478: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3479: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

Line 3476: IF ((l_invol_term = 'N') AND (l_return_status = fnd_api.g_ret_sts_success )) THEN

3472:
3473:
3474: /*IF - ELSIF block added for bug 5683340*/
3475: -- IF ((l_invol_term = 'N') AND (x_return_status = fnd_api.g_ret_sts_success )) THEN -- Commenting For bug 4087022
3476: IF ((l_invol_term = 'N') AND (l_return_status = fnd_api.g_ret_sts_success )) THEN
3477: pa_debug.g_err_stage := 'Log: Calling Create_Timeline procedure for PersonId =' || to_char(l_person_id) ;
3478: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3479: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3480: END IF;

Line 3505: -- IF (x_return_status <> fnd_api.g_ret_sts_success) THEN -- Commenting For bug 4087022

3501: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3502: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3503: END IF;
3504:
3505: -- IF (x_return_status <> fnd_api.g_ret_sts_success) THEN -- Commenting For bug 4087022
3506: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3507: log_message('it will raise exception');
3508: pa_debug.g_err_stage := 'Log: Timeline API returned error';
3509: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 3506: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

3502: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3503: END IF;
3504:
3505: -- IF (x_return_status <> fnd_api.g_ret_sts_success) THEN -- Commenting For bug 4087022
3506: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3507: log_message('it will raise exception');
3508: pa_debug.g_err_stage := 'Log: Timeline API returned error';
3509: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3510: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

Line 3513: RAISE FND_API.G_EXC_ERROR;

3509: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3510: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3511: END IF;
3512: l_per_success := 'N';
3513: RAISE FND_API.G_EXC_ERROR;
3514: END IF;
3515:
3516: -- log_message('After timeline call: ' || x_return_status); -- Commenting For bug 4087022
3517: log_message('After timeline call: ' || l_return_status);

Line 3519: -- ELSIF (x_return_status <> fnd_api.g_ret_sts_success ) THEN -- for bug 5683340 -- Commenting For bug 4087022

3515:
3516: -- log_message('After timeline call: ' || x_return_status); -- Commenting For bug 4087022
3517: log_message('After timeline call: ' || l_return_status);
3518:
3519: -- ELSIF (x_return_status <> fnd_api.g_ret_sts_success ) THEN -- for bug 5683340 -- Commenting For bug 4087022
3520: ELSIF (l_return_status <> fnd_api.g_ret_sts_success ) THEN -- for bug 5683340
3521: pa_debug.g_err_stage := 'Log: init_fte_sync_wf API returned error';
3522: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3523: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

Line 3520: ELSIF (l_return_status <> fnd_api.g_ret_sts_success ) THEN -- for bug 5683340

3516: -- log_message('After timeline call: ' || x_return_status); -- Commenting For bug 4087022
3517: log_message('After timeline call: ' || l_return_status);
3518:
3519: -- ELSIF (x_return_status <> fnd_api.g_ret_sts_success ) THEN -- for bug 5683340 -- Commenting For bug 4087022
3520: ELSIF (l_return_status <> fnd_api.g_ret_sts_success ) THEN -- for bug 5683340
3521: pa_debug.g_err_stage := 'Log: init_fte_sync_wf API returned error';
3522: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3523: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3524: END IF;

Line 3527: RAISE FND_API.G_EXC_ERROR;

3523: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3524: END IF;
3525: l_per_success := 'N';
3526: log_message(' Call to pa_resource_utils.init_fte_sync_wf errored in mass pull');
3527: RAISE FND_API.G_EXC_ERROR;
3528:
3529: END IF ; --IF ((l_invol_term = 'N') AND (l_return_status = fnd_api.g_ret_sts_success ))
3530:
3531: END IF;

Line 3529: END IF ; --IF ((l_invol_term = 'N') AND (l_return_status = fnd_api.g_ret_sts_success ))

3525: l_per_success := 'N';
3526: log_message(' Call to pa_resource_utils.init_fte_sync_wf errored in mass pull');
3527: RAISE FND_API.G_EXC_ERROR;
3528:
3529: END IF ; --IF ((l_invol_term = 'N') AND (l_return_status = fnd_api.g_ret_sts_success ))
3530:
3531: END IF;
3532:
3533: -----------------------------------------------------------------------

Line 3559: ,p_commit => FND_API.G_FALSE --p_commit

3555: ,p_context10 => 'NO_JOB_MAP'
3556: ,p_date_context1 => l_assignment_start_date
3557: ,p_date_context2 => l_assignment_end_date
3558: ,p_use_fnd_msg => 'N'
3559: ,p_commit => FND_API.G_FALSE --p_commit
3560: ,x_return_status => l_return_status);
3561: END IF;
3562:
3563: l_job_schedulable := PA_HR_UPDATE_API.check_job_schedulable

Line 3580: ,p_commit => FND_API.G_FALSE --p_commit

3576: ,p_context10 => 'NON_SCHEDULABLE'
3577: ,p_date_context1 => l_assignment_start_date
3578: ,p_date_context2 => l_assignment_end_date
3579: ,p_use_fnd_msg => 'N'
3580: ,p_commit => FND_API.G_FALSE --p_commit
3581: ,x_return_status => l_return_status);
3582: END IF;
3583: END IF; -- bug 8669156
3584: EXCEPTION

Line 3585: WHEN FND_API.G_EXC_ERROR THEN

3581: ,x_return_status => l_return_status);
3582: END IF;
3583: END IF; -- bug 8669156
3584: EXCEPTION
3585: WHEN FND_API.G_EXC_ERROR THEN
3586: --x_return_status := FND_API.G_RET_STS_ERROR;
3587:
3588: l_excep := 'Y' ; -- Adding For bug 4087022
3589:

Line 3586: --x_return_status := FND_API.G_RET_STS_ERROR;

3582: END IF;
3583: END IF; -- bug 8669156
3584: EXCEPTION
3585: WHEN FND_API.G_EXC_ERROR THEN
3586: --x_return_status := FND_API.G_RET_STS_ERROR;
3587:
3588: l_excep := 'Y' ; -- Adding For bug 4087022
3589:
3590: IF p_commit = fnd_api.g_true THEN

Line 3590: IF p_commit = fnd_api.g_true THEN

3586: --x_return_status := FND_API.G_RET_STS_ERROR;
3587:
3588: l_excep := 'Y' ; -- Adding For bug 4087022
3589:
3590: IF p_commit = fnd_api.g_true THEN
3591: log_message('rollback in inner exception block');
3592: ROLLBACK TO res_pvt_create_resource; --line 2813
3593: log_message('after rollback in inner exception block');
3594: END IF;

Line 3598: p_encoded => FND_API.G_FALSE,

3594: END IF;
3595:
3596: -- will still do this to display the error message in the log file
3597: FND_MSG_PUB.get (
3598: p_encoded => FND_API.G_FALSE,
3599: p_msg_index => 1,
3600: p_data => x_msg_data,
3601: p_msg_index_out => x_msg_count );
3602:

Line 3649: IF p_commit = fnd_api.g_true THEN

3645: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Create_Resource'
3646: ,p_procedure_name =>'Create_Resource' );
3647: /*For bug 4087022*/
3648:
3649: IF p_commit = fnd_api.g_true THEN
3650: log_message('when others rollback in inner exception block') ;
3651: ROLLBACK TO res_pvt_create_resource;
3652: END IF;
3653:

Line 3656: p_encoded => FND_API.G_FALSE,

3652: END IF;
3653:
3654: -- will still do this to display the error message inthe log file
3655: FND_MSG_PUB.get (
3656: p_encoded => FND_API.G_FALSE,
3657: p_msg_index => 1,
3658: p_data => x_msg_data,
3659: p_msg_index_out => x_msg_count );
3660: log_message('*** When Others Un Expected error for Person = ' || TO_CHAR (l_person_id));

Line 3752: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3748: X_RESOURCE_ID => x_resource_id,
3749: X_RETURN_STATUS => x_return_status);
3750:
3751:
3752: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3753: x_return_status := FND_API.G_RET_STS_ERROR;
3754: RAISE FND_API.G_EXC_ERROR;
3755: END IF;
3756:

Line 3753: x_return_status := FND_API.G_RET_STS_ERROR;

3749: X_RETURN_STATUS => x_return_status);
3750:
3751:
3752: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3753: x_return_status := FND_API.G_RET_STS_ERROR;
3754: RAISE FND_API.G_EXC_ERROR;
3755: END IF;
3756:
3757: RETURN;

Line 3754: RAISE FND_API.G_EXC_ERROR;

3750:
3751:
3752: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3753: x_return_status := FND_API.G_RET_STS_ERROR;
3754: RAISE FND_API.G_EXC_ERROR;
3755: END IF;
3756:
3757: RETURN;
3758:

Line 3771: IF fnd_api.to_boolean(p_commit) THEN

3767: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3768: END IF;
3769: log_message('End of create_resource procedure');
3770:
3771: IF fnd_api.to_boolean(p_commit) THEN
3772: COMMIT WORK;
3773: END IF;
3774:
3775: --Reset all Global Variables.

Line 3801: x_return_status := FND_API.G_RET_STS_ERROR;

3797:
3798: EXCEPTION
3799:
3800: WHEN TERM_DATE_EXCEPTION THEN
3801: x_return_status := FND_API.G_RET_STS_ERROR;
3802: PA_UTILS.Add_Message(
3803: p_app_short_name => 'PA'
3804: ,p_msg_name => 'PA_TERM_DATE_OVER_MAX');
3805:

Line 3806: WHEN FND_API.G_EXC_ERROR THEN

3802: PA_UTILS.Add_Message(
3803: p_app_short_name => 'PA'
3804: ,p_msg_name => 'PA_TERM_DATE_OVER_MAX');
3805:
3806: WHEN FND_API.G_EXC_ERROR THEN
3807:
3808: x_return_status := FND_API.G_RET_STS_ERROR;
3809: -- 4537865
3810: x_resource_id := NULL ;

Line 3808: x_return_status := FND_API.G_RET_STS_ERROR;

3804: ,p_msg_name => 'PA_TERM_DATE_OVER_MAX');
3805:
3806: WHEN FND_API.G_EXC_ERROR THEN
3807:
3808: x_return_status := FND_API.G_RET_STS_ERROR;
3809: -- 4537865
3810: x_resource_id := NULL ;
3811:
3812: WHEN OTHERS THEN

Line 3817: IF p_commit = fnd_api.g_true THEN

3813: log_message (' =============== ');
3814: log_message (' Raised Others in Create Resource Private');
3815:
3816: log_message (SQLCODE || SQLERRM);
3817: IF p_commit = fnd_api.g_true THEN
3818: log_message('rollback in outer exception block');
3819: ROLLBACK TO res_pvt_create_resource; -- line 3005
3820: END IF;
3821: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Create_Resource'

Line 3823: X_RETURN_STATUS := fnd_api.g_ret_sts_unexp_error;

3819: ROLLBACK TO res_pvt_create_resource; -- line 3005
3820: END IF;
3821: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Create_Resource'
3822: ,p_procedure_name =>PA_DEBUG.G_Err_Stack );
3823: X_RETURN_STATUS := fnd_api.g_ret_sts_unexp_error;
3824: -- 4537865
3825: x_resource_id := NULL ;
3826: raise;
3827:

Line 4008: ,p_commit => FND_API.G_FALSE

4004: IF (l_current_asgn_start_date IS NOT NULL) AND (l_current_asgn_start_date = l_assignment_start_date) THEN
4005: pa_r_project_resources_pub.create_resource (
4006: p_api_version => 1.0
4007: ,p_init_msg_list => NULL
4008: ,p_commit => FND_API.G_FALSE
4009: ,p_validate_only => NULL
4010: ,p_max_msg_count => NULL
4011: ,p_internal => 'Y'
4012: ,p_person_id => l_person_id