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 PA_DEBUG

Line 17: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */

13: G_p_crmwf_id NUMBER := 0;
14:
15: --Forward declaration
16:
17: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
18:
19: PROCEDURE start_crm_workflow ( p_person_id IN NUMBER,
20: p_assignment_start_date IN DATE,
21: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 212: pa_debug.write('start_crm_workflow: ' || 'Resource Pull', 'log: ' || p_log_msg, 3);

208: IS
209: BEGIN
210: --dbms_output.put_line('log: ' || p_log_msg);
211: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
212: pa_debug.write('start_crm_workflow: ' || 'Resource Pull', 'log: ' || p_log_msg, 3);
213: END IF;
214: NULL;
215: END log_message;
216:

Line 571: PA_DEBUG.set_err_stack('Insert_into_CRM');

567: l_cal_exist_end VARCHAR(1);
568: l_fde VARCHAR(1); -- Added for bug4690946
569:
570: BEGIN
571: PA_DEBUG.set_err_stack('Insert_into_CRM');
572:
573: pa_debug.g_err_stage := 'Log: Start of Insert_into_CRM procedure';
574: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
575: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

Line 573: pa_debug.g_err_stage := 'Log: Start of Insert_into_CRM procedure';

569:
570: BEGIN
571: PA_DEBUG.set_err_stack('Insert_into_CRM');
572:
573: pa_debug.g_err_stage := 'Log: Start of Insert_into_CRM procedure';
574: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
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');

Line 575: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

571: PA_DEBUG.set_err_stack('Insert_into_CRM');
572:
573: pa_debug.g_err_stage := 'Log: Start of Insert_into_CRM procedure';
574: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
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;

Line 596: pa_debug.g_err_stage := 'Log: Calendar_id null, get from Profile options';

592: ----------------------------------
593:
594: --Get Calendar_Id from Profile Options if NULL
595: if l_calendar_id is null then
596: pa_debug.g_err_stage := 'Log: Calendar_id null, get from Profile options';
597: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
598: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
599: END IF;
600: l_calendar_id := fnd_profile.value_specific('PA_PRM_DEFAULT_CALENDAR');

Line 598: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

594: --Get Calendar_Id from Profile Options if NULL
595: if l_calendar_id is null then
596: pa_debug.g_err_stage := 'Log: Calendar_id null, get from Profile options';
597: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
598: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
599: END IF;
600: l_calendar_id := fnd_profile.value_specific('PA_PRM_DEFAULT_CALENDAR');
601: end if;
602:

Line 606: pa_debug.g_err_stage := 'Log: Calendar id null from Profile options - Invalid Calendar Setup';

602:
603: --Calendar_Id from Profile Options is NULL
604: --raise error
605: if l_calendar_id is null then
606: pa_debug.g_err_stage := 'Log: Calendar id null from Profile options - Invalid Calendar Setup';
607: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
608: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
609: END IF;
610: PA_UTILS.Add_Message(

Line 608: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

604: --raise error
605: if l_calendar_id is null then
606: pa_debug.g_err_stage := 'Log: Calendar id null from Profile options - Invalid Calendar Setup';
607: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
608: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
609: END IF;
610: PA_UTILS.Add_Message(
611: p_app_short_name => 'PA'
612: ,p_msg_name => 'PA_INVALID_CAL_SETUP');

Line 623: pa_debug.g_err_stage := 'Log: Resource does not exist in CRM, calling CRM Public API';

619: -- Get a crm_resource_id for this resource
620: -------------------------------------------
621: IF (l_crm_resource_id is null) THEN
622: --Call CRM public API
623: pa_debug.g_err_stage := 'Log: Resource does not exist in CRM, calling CRM Public API';
624: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
625: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
626: END IF;
627: log_message('Resource does not exist in CRM, call CRM Public API');

Line 625: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

621: IF (l_crm_resource_id is null) THEN
622: --Call CRM public API
623: pa_debug.g_err_stage := 'Log: Resource does not exist in CRM, calling CRM Public API';
624: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
625: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
626: END IF;
627: log_message('Resource does not exist in CRM, call CRM Public API');
628:
629: OPEN c_per_active ;

Line 669: pa_debug.g_err_stage := 'Log: Error in CRM Workaround Workflow API';

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);
672: END IF;
673: x_return_status := FND_API.G_RET_STS_ERROR;

Line 671: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

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);
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;

Line 740: pa_debug.g_err_stage := 'Log: Error in CRM Public API';

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);
743: END IF;
744:

Line 742: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

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);
743: END IF;
744:
745: x_return_status := FND_API.G_RET_STS_ERROR;
746: CLOSE c_per_active;

Line 750: pa_debug.g_err_stage := 'Log: After call to CRM Public API. CRM_RESOURCE_ID := ' || to_char(l_crm_resource_id);

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 */
752: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
753: END IF;
754: log_message('Out of CRM Public API');

Line 752: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

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 */
752: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
753: END IF;
754: log_message('Out of CRM Public API');
755:
756: END IF; /* end if for c_per_active%NOTFOUND */

Line 763: pa_debug.g_err_stage := 'Log: Fetch the resource_type_code based on category';

759: END IF; /* end if for creating a crm resource id for this person */
760:
761:
762: --Get the correct resource_type_code based on category
763: pa_debug.g_err_stage := 'Log: Fetch the resource_type_code based on category';
764: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
765: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
766: END IF;
767: log_message('Fetch the resource_type_code based on category');

Line 765: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

761:
762: --Get the correct resource_type_code based on category
763: pa_debug.g_err_stage := 'Log: Fetch the resource_type_code based on category';
764: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
765: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
766: END IF;
767: log_message('Fetch the resource_type_code based on category');
768:
769: IF p_category = 'EMPLOYEE' THEN

Line 993: pa_debug.g_err_stage := 'Log: Selected unique cal_resource_assign_id';

989: CLOSE c_dup_resource_assign_id;
990: END LOOP;
991: CLOSE c_dup_resource_assign_id;
992:
993: pa_debug.g_err_stage := 'Log: Selected unique cal_resource_assign_id';
994: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
995: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
996: END IF;
997: log_message('Selected unique cal_resource_assign_id');

Line 995: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

991: CLOSE c_dup_resource_assign_id;
992:
993: pa_debug.g_err_stage := 'Log: Selected unique cal_resource_assign_id';
994: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
995: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
996: END IF;
997: log_message('Selected unique cal_resource_assign_id');
998:
999: pa_debug.g_err_stage := 'Log: User CRM API to Insert calendar into jtf_cal_resource_assign from '|| to_char(l_assignment_start_date,'DD-MON-RR')||' to '|| to_char(l_assignment_end_date,'DD-MON-RR');

Line 999: pa_debug.g_err_stage := 'Log: User CRM API to Insert calendar into jtf_cal_resource_assign from '|| to_char(l_assignment_start_date,'DD-MON-RR')||' to '|| to_char(l_assignment_end_date,'DD-MON-RR');

995: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
996: END IF;
997: log_message('Selected unique cal_resource_assign_id');
998:
999: pa_debug.g_err_stage := 'Log: User CRM API to Insert calendar into jtf_cal_resource_assign from '|| to_char(l_assignment_start_date,'DD-MON-RR')||' to '|| to_char(l_assignment_end_date,'DD-MON-RR');
1000: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1001: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1002: END IF;
1003: log_message('Insert calendar into jtf_cal_resource_assign');

Line 1001: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

997: log_message('Selected unique cal_resource_assign_id');
998:
999: pa_debug.g_err_stage := 'Log: User CRM API to Insert calendar into jtf_cal_resource_assign from '|| to_char(l_assignment_start_date,'DD-MON-RR')||' to '|| to_char(l_assignment_end_date,'DD-MON-RR');
1000: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1001: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1002: END IF;
1003: log_message('Insert calendar into jtf_cal_resource_assign');
1004:
1005: --Added code to use CRM Table Handler API instead of direct insert

Line 1050: pa_debug.g_err_stage := 'Log: Error in CRM Table Handler API for INSERT_ROW';

1046: /* The jtf table handler returns N or Y based on
1047: if the function call was a success or failure */
1048: IF NOT (l_error = 'N') THEN
1049: log_message('Error in CRM Table Handler API for INSERT_ROW');
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;

Line 1052: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1048: IF NOT (l_error = 'N') THEN
1049: log_message('Error in CRM Table Handler API for INSERT_ROW');
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;

Line 1085: pa_debug.g_err_stage := 'Log: Calendar is not valid';

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;
1089: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1087: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

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;
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090: RAISE FND_API.G_EXC_ERROR;
1091: END IF;

Line 1093: pa_debug.g_err_stage := 'Log: After insert into jtf_cal_resource_assign';

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 */
1095: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1096: END IF;
1097:

Line 1095: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

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 */
1095: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1096: END IF;
1097:
1098: log_message('End of insert into jtf_cal_resource_assign');
1099:

Line 1103: pa_debug.g_err_stage := 'Log: End of Insert_into_CRM procedure';

1099:
1100: END IF;
1101: END IF; -- Bug 6411422
1102:
1103: pa_debug.g_err_stage := 'Log: End of Insert_into_CRM procedure';
1104: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1105: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1106: END IF;
1107: log_message('End of insert_into_crm procedure');

Line 1105: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1101: END IF; -- Bug 6411422
1102:
1103: pa_debug.g_err_stage := 'Log: End of Insert_into_CRM procedure';
1104: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1105: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1106: END IF;
1107: log_message('End of insert_into_crm procedure');
1108:
1109: PA_DEBUG.Reset_Err_Stack;

Line 1109: PA_DEBUG.Reset_Err_Stack;

1105: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1106: END IF;
1107: log_message('End of insert_into_crm procedure');
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;

Line 1119: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

1115: WHEN OTHERS THEN
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:

Line 1175: PA_DEBUG.set_err_stack('Insert_into_PA');

1171: FROM pa_resource_txn_attributes
1172: WHERE ROWID = l_rowid;
1173:
1174: BEGIN
1175: PA_DEBUG.set_err_stack('Insert_into_PA');
1176: pa_debug.g_err_stage := 'Log: Start of Insert_into_PA procedure';
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;

Line 1176: pa_debug.g_err_stage := 'Log: Start of Insert_into_PA procedure';

1172: WHERE ROWID = l_rowid;
1173:
1174: BEGIN
1175: PA_DEBUG.set_err_stack('Insert_into_PA');
1176: pa_debug.g_err_stage := 'Log: Start of Insert_into_PA procedure';
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:

Line 1178: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1174: BEGIN
1175: PA_DEBUG.set_err_stack('Insert_into_PA');
1176: pa_debug.g_err_stage := 'Log: Start of Insert_into_PA procedure';
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:

Line 1233: pa_debug.g_err_stage := 'Log: Calling Insert_row1 to insert into PA_RESOURCES table';

1229: l_track_as_labor_flag := 'Y';
1230: end if;
1231:
1232: --Insert into pa_resources table
1233: pa_debug.g_err_stage := 'Log: Calling Insert_row1 to insert into PA_RESOURCES table';
1234: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1235: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1236: END IF;
1237: log_message('Calling insert_row1 procedure to do the actual inserts into PA_RESOURCES table');

Line 1235: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1231:
1232: --Insert into pa_resources table
1233: pa_debug.g_err_stage := 'Log: Calling Insert_row1 to insert into PA_RESOURCES table';
1234: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1235: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1236: END IF;
1237: log_message('Calling insert_row1 procedure to do the actual inserts into PA_RESOURCES table');
1238:
1239: PA_RESOURCE_PKG.INSERT_ROW1 (

Line 1261: pa_debug.g_err_stage := 'Log: After Insert_row1 procedure';

1257: X_CREATED_BY => G_user_id,
1258: X_LAST_UPDATE_LOGIN => G_login_id,
1259: X_RETURN_STATUS => x_return_status);
1260:
1261: pa_debug.g_err_stage := 'Log: After Insert_row1 procedure';
1262: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1263: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1264: END IF;
1265: log_message('After Insert Row 1 Procedure');

Line 1263: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1259: X_RETURN_STATUS => x_return_status);
1260:
1261: pa_debug.g_err_stage := 'Log: After Insert_row1 procedure';
1262: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1263: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1264: END IF;
1265: log_message('After Insert Row 1 Procedure');
1266:
1267: pa_debug.g_err_stage := 'Log: Calling Insert_row2 to insert into PA_RESOURCE_TXN_ATTRIBUTES table';

Line 1267: pa_debug.g_err_stage := 'Log: Calling Insert_row2 to insert into PA_RESOURCE_TXN_ATTRIBUTES table';

1263: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1264: END IF;
1265: log_message('After Insert Row 1 Procedure');
1266:
1267: pa_debug.g_err_stage := 'Log: Calling Insert_row2 to insert into PA_RESOURCE_TXN_ATTRIBUTES table';
1268: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1269: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1270: END IF;
1271: log_message('Call insert_row2 procedure to do the actual inserts into PA_RESOURCE_TXN_ATTRIBUTES table');

Line 1269: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1265: log_message('After Insert Row 1 Procedure');
1266:
1267: pa_debug.g_err_stage := 'Log: Calling Insert_row2 to insert into PA_RESOURCE_TXN_ATTRIBUTES table';
1268: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1269: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1270: END IF;
1271: log_message('Call insert_row2 procedure to do the actual inserts into PA_RESOURCE_TXN_ATTRIBUTES table');
1272:
1273: --Insert into pa_resource_txn_attributes.

Line 1292: pa_debug.g_err_stage := 'Log: After Insert_row2 procedure';

1288: X_CREATED_BY => G_user_id,
1289: X_LAST_UPDATE_LOGIN => G_login_id,
1290: X_RETURN_STATUS => x_return_status ) ;
1291:
1292: pa_debug.g_err_stage := 'Log: After Insert_row2 procedure';
1293: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1294: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1295: END IF;
1296: log_message('End of insert_row2 procedure');

Line 1294: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1290: X_RETURN_STATUS => x_return_status ) ;
1291:
1292: pa_debug.g_err_stage := 'Log: After Insert_row2 procedure';
1293: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1294: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1295: END IF;
1296: log_message('End of insert_row2 procedure');
1297:
1298: pa_debug.g_err_stage := 'Log: End of Insert_into_PA procedure';

Line 1298: pa_debug.g_err_stage := 'Log: End of Insert_into_PA procedure';

1294: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1295: END IF;
1296: log_message('End of insert_row2 procedure');
1297:
1298: pa_debug.g_err_stage := 'Log: End of Insert_into_PA procedure';
1299: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1300: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1301: END IF;
1302: log_message('End of insert_into_pa procedure');

Line 1300: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1296: log_message('End of insert_row2 procedure');
1297:
1298: pa_debug.g_err_stage := 'Log: End of Insert_into_PA procedure';
1299: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1300: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1301: END IF;
1302: log_message('End of insert_into_pa procedure');
1303:
1304: PA_DEBUG.Reset_Err_Stack;

Line 1304: PA_DEBUG.Reset_Err_Stack;

1300: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1301: END IF;
1302: log_message('End of insert_into_pa procedure');
1303:
1304: PA_DEBUG.Reset_Err_Stack;
1305: EXCEPTION
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'

Line 1309: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

1305: EXCEPTION
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;

Line 1332: PA_DEBUG.set_err_stack('Check_OU');

1328: l_valid VARCHAR2(1);
1329: l_code VARCHAR2(100);
1330:
1331: BEGIN
1332: PA_DEBUG.set_err_stack('Check_OU');
1333:
1334: pa_debug.g_err_stage := 'Log: Start of Check_OU procedure';
1335: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1336: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

Line 1334: pa_debug.g_err_stage := 'Log: Start of Check_OU procedure';

1330:
1331: BEGIN
1332: PA_DEBUG.set_err_stack('Check_OU');
1333:
1334: pa_debug.g_err_stage := 'Log: Start of Check_OU procedure';
1335: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
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');

Line 1336: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1332: PA_DEBUG.set_err_stack('Check_OU');
1333:
1334: pa_debug.g_err_stage := 'Log: Start of Check_OU procedure';
1335: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
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;

Line 1373: pa_debug.g_err_stage := 'Log: End of Check_OU procedure';

1369:
1370: END IF;
1371: END IF;
1372:
1373: pa_debug.g_err_stage := 'Log: End of Check_OU procedure';
1374: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1375: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1376: END IF;
1377: log_message('End of check_ou procedure');

Line 1375: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1371: END IF;
1372:
1373: pa_debug.g_err_stage := 'Log: End of Check_OU procedure';
1374: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1375: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1376: END IF;
1377: log_message('End of check_ou procedure');
1378:
1379: PA_DEBUG.Reset_Err_Stack;

Line 1379: PA_DEBUG.Reset_Err_Stack;

1375: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1376: END IF;
1377: log_message('End of check_ou procedure');
1378:
1379: PA_DEBUG.Reset_Err_Stack;
1380: EXCEPTION
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'

Line 1384: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

1380: EXCEPTION
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;

Line 1467: PA_DEBUG.set_err_stack('Create_Internal_Resource');

1463: FROM pa_resources
1464: WHERE resource_id = l_res_id;
1465:
1466: BEGIN
1467: PA_DEBUG.set_err_stack('Create_Internal_Resource');
1468:
1469: pa_debug.g_err_stage := 'Log: Start of Create_Internal_Resource procedure';
1470: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1471: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

Line 1469: pa_debug.g_err_stage := 'Log: Start of Create_Internal_Resource procedure';

1465:
1466: BEGIN
1467: PA_DEBUG.set_err_stack('Create_Internal_Resource');
1468:
1469: pa_debug.g_err_stage := 'Log: Start of Create_Internal_Resource procedure';
1470: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
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');

Line 1471: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1467: PA_DEBUG.set_err_stack('Create_Internal_Resource');
1468:
1469: pa_debug.g_err_stage := 'Log: Start of Create_Internal_Resource procedure';
1470: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
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;

Line 1480: pa_debug.g_err_stage := 'Log: Resource does not exist in PA';

1476:
1477: --Check to see if resource exists in PA
1478: IF (p_res_exists = 'NOT EXISTS') THEN
1479:
1480: pa_debug.g_err_stage := 'Log: Resource does not exist in PA';
1481: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1482: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1483: END IF;
1484: log_message('Resource does not exist');

Line 1482: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1478: IF (p_res_exists = 'NOT EXISTS') THEN
1479:
1480: pa_debug.g_err_stage := 'Log: Resource does not exist in PA';
1481: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1482: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1483: END IF;
1484: log_message('Resource does not exist');
1485:
1486: pa_debug.g_err_stage := 'Log: Calling Insert_into_CRM procedure to check if resource exists in CRM';

Line 1486: pa_debug.g_err_stage := 'Log: Calling Insert_into_CRM procedure to check if resource exists in CRM';

1482: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1483: END IF;
1484: log_message('Resource does not exist');
1485:
1486: pa_debug.g_err_stage := 'Log: Calling Insert_into_CRM procedure to check if resource exists in CRM';
1487: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1488: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1489: END IF;
1490: log_message('Call insert_into_crm procedure to check if resource exists in CRM');

Line 1488: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1484: log_message('Resource does not exist');
1485:
1486: pa_debug.g_err_stage := 'Log: Calling Insert_into_CRM procedure to check if resource exists in CRM';
1487: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1488: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1489: END IF;
1490: log_message('Call insert_into_crm procedure to check if resource exists in CRM');
1491:
1492: --pa_debug.g_err_stage := 'Log: P_COUNT = ' || to_char(p_count);

Line 1492: --pa_debug.g_err_stage := 'Log: P_COUNT = ' || to_char(p_count);

1488: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1489: END IF;
1490: log_message('Call insert_into_crm procedure to check if resource exists in CRM');
1491:
1492: --pa_debug.g_err_stage := 'Log: P_COUNT = ' || to_char(p_count);
1493: --pa_debug.write_file('LOG',pa_debug.g_err_stage);
1494: --Call Insert_into_crm procedure
1495: insert_into_crm(
1496: P_CATEGORY => p_resource_type,

Line 1493: --pa_debug.write_file('LOG',pa_debug.g_err_stage);

1489: END IF;
1490: log_message('Call insert_into_crm procedure to check if resource exists in CRM');
1491:
1492: --pa_debug.g_err_stage := 'Log: P_COUNT = ' || to_char(p_count);
1493: --pa_debug.write_file('LOG',pa_debug.g_err_stage);
1494: --Call Insert_into_crm procedure
1495: insert_into_crm(
1496: P_CATEGORY => p_resource_type,
1497: P_PERSON_ID => p_person_id,

Line 1530: pa_debug.g_err_stage := 'Log: After Insert_into_CRM procedure ';

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 */
1532: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1533: END IF;
1534: log_message('Out of insert_into_crm procedure');

Line 1532: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

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 */
1532: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1533: END IF;
1534: log_message('Out of insert_into_crm procedure');
1535: log_message('x_crm_resource_id = ' || x_crm_resource_id);
1536: log_message('p_person_id = ' || p_person_id);

Line 1539: pa_debug.g_err_stage := 'Log: Get the resource_type_code based on the user_type';

1535: log_message('x_crm_resource_id = ' || x_crm_resource_id);
1536: log_message('p_person_id = ' || p_person_id);
1537:
1538: /*--Get the resource_type_code inorder to get the resource_type_id
1539: pa_debug.g_err_stage := 'Log: Get the resource_type_code based on the user_type';
1540: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1541: log_message('Get the resource_type_code based on the user_type');
1542:
1543: IF p_user_type = 'Employee' THEN

Line 1540: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1536: log_message('p_person_id = ' || p_person_id);
1537:
1538: /*--Get the resource_type_code inorder to get the resource_type_id
1539: pa_debug.g_err_stage := 'Log: Get the resource_type_code based on the user_type';
1540: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1541: log_message('Get the resource_type_code based on the user_type');
1542:
1543: IF p_user_type = 'Employee' THEN
1544: l_resource_type_code := 'EMPLOYEE';

Line 1550: pa_debug.g_err_stage := 'Log: Get the resource_type_id based on the resource_type_code';

1546: l_resource_type_code := 'CONTRACTOR';
1547: END IF;*/
1548:
1549: --fetch the resource_type_id
1550: pa_debug.g_err_stage := 'Log: Get the resource_type_id based on the resource_type_code';
1551: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1552: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1553: END IF;
1554: log_message('Get the resource_type_id from the resource_type_code');

Line 1552: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1548:
1549: --fetch the resource_type_id
1550: pa_debug.g_err_stage := 'Log: Get the resource_type_id based on the resource_type_code';
1551: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1552: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1553: END IF;
1554: log_message('Get the resource_type_id from the resource_type_code');
1555:
1556: select resource_type_id into l_resource_type_id

Line 1560: pa_debug.g_err_stage := 'Log: After getting the resource_type_id based on the resource_type_code';

1556: select resource_type_id into l_resource_type_id
1557: from pa_resource_types
1558: where resource_type_code = l_resource_type_code ;
1559:
1560: pa_debug.g_err_stage := 'Log: After getting the resource_type_id based on the resource_type_code';
1561: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1562: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1563: END IF;
1564:

Line 1562: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1558: where resource_type_code = l_resource_type_code ;
1559:
1560: pa_debug.g_err_stage := 'Log: After getting the resource_type_id based on the resource_type_code';
1561: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1562: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1563: END IF;
1564:
1565: --This check is to check the number of assignments the resource has
1566: if (p_person_id <> G_p_id) then

Line 1567: pa_debug.g_err_stage := 'Log: Calling Insert_into_PA procedure';

1563: END IF;
1564:
1565: --This check is to check the number of assignments the resource has
1566: if (p_person_id <> G_p_id) then
1567: pa_debug.g_err_stage := 'Log: Calling Insert_into_PA procedure';
1568: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1569: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1570: END IF;
1571: log_message('Calling insert_into_pa');

Line 1569: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1565: --This check is to check the number of assignments the resource has
1566: if (p_person_id <> G_p_id) then
1567: pa_debug.g_err_stage := 'Log: Calling Insert_into_PA procedure';
1568: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1569: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1570: END IF;
1571: log_message('Calling insert_into_pa');
1572:
1573: INSERT_INTO_PA(

Line 1582: pa_debug.g_err_stage := 'Log: After Insert_into_PA procedure';

1578: P_PERSON_ID => p_person_id,
1579: P_NAME => p_name,
1580: X_RETURN_STATUS => x_return_status );
1581:
1582: pa_debug.g_err_stage := 'Log: After Insert_into_PA procedure';
1583: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1584: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1585: END IF;
1586: log_message('Out of insert_into_pa');

Line 1584: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1580: X_RETURN_STATUS => x_return_status );
1581:
1582: pa_debug.g_err_stage := 'Log: After Insert_into_PA procedure';
1583: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1584: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1585: END IF;
1586: log_message('Out of insert_into_pa');
1587:
1588: G_p_id := p_person_id;

Line 1605: pa_debug.g_err_stage := 'Log: Resource exists in PA';

1601: x_resource_id := l_res_id;
1602:
1603: ELSE
1604: --If resource exists in PA
1605: pa_debug.g_err_stage := 'Log: Resource exists in PA';
1606: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1607: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1608: END IF;
1609: log_message('For already existing resource: Resource is already in PA');

Line 1607: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1603: ELSE
1604: --If resource exists in PA
1605: pa_debug.g_err_stage := 'Log: Resource exists in PA';
1606: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1607: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1608: END IF;
1609: log_message('For already existing resource: Resource is already in PA');
1610:
1611: --Check to see if CRM calendar is end dated.

Line 1614: pa_debug.g_err_stage := 'Log: Calling Insert_into_CRM procedure to check if resource exists in CRM';

1610:
1611: --Check to see if CRM calendar is end dated.
1612: --Call insert_into_crm
1613:
1614: pa_debug.g_err_stage := 'Log: Calling Insert_into_CRM procedure to check if resource exists in CRM';
1615: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1616: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1617: END IF;
1618: log_message('Call insert_into_crm procedure to check if resource exists in CRM');

Line 1616: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1612: --Call insert_into_crm
1613:
1614: pa_debug.g_err_stage := 'Log: Calling Insert_into_CRM procedure to check if resource exists in CRM';
1615: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1616: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1617: END IF;
1618: log_message('Call insert_into_crm procedure to check if resource exists in CRM');
1619:
1620: insert_into_crm(

Line 1651: pa_debug.g_err_stage := 'Log: After Insert_into_CRM procedure';

1647: P_SOURCE_FIRST_NAME => P_SOURCE_FIRST_NAME,
1648: P_SOURCE_LAST_NAME => P_SOURCE_LAST_NAME,
1649: P_SOURCE_MIDDLE_NAME => P_SOURCE_MIDDLE_NAME);
1650: log_message('After CRM '|| x_return_status);
1651: pa_debug.g_err_stage := 'Log: After Insert_into_CRM procedure';
1652: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1653: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1654: END IF;
1655: log_message(' Out of insert_into_crm procedure');

Line 1653: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1649: P_SOURCE_MIDDLE_NAME => P_SOURCE_MIDDLE_NAME);
1650: log_message('After CRM '|| x_return_status);
1651: pa_debug.g_err_stage := 'Log: After Insert_into_CRM procedure';
1652: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1653: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1654: END IF;
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);

Line 1663: pa_debug.g_err_stage := 'Log: Get resource_id for person_id';

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 */
1665: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1666: END IF;
1667: log_message('Get resource_id for person_id');

Line 1665: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

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 */
1665: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1666: END IF;
1667: log_message('Get resource_id for person_id');
1668:
1669: --Get resource_id from PA for the resource

Line 1714: pa_debug.g_err_stage := 'Log: PA_RESOURCES.JTF_RESOURCE_ID does not exist or not equal to the CRM resource_id';

1710: FETCH c_jtf_id_exist INTO l_jtf_id;
1711: CLOSE c_jtf_id_exist;
1712:
1713: IF (l_jtf_id is null) or (l_jtf_id <> x_crm_resource_id) THEN
1714: pa_debug.g_err_stage := 'Log: PA_RESOURCES.JTF_RESOURCE_ID does not exist or not equal to the CRM resource_id';
1715: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1716: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1717: END IF;
1718:

Line 1716: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1712:
1713: IF (l_jtf_id is null) or (l_jtf_id <> x_crm_resource_id) THEN
1714: pa_debug.g_err_stage := 'Log: PA_RESOURCES.JTF_RESOURCE_ID does not exist or not equal to the CRM resource_id';
1715: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1716: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1717: END IF;
1718:
1719: update pa_resources
1720: set jtf_resource_id = x_crm_resource_id,

Line 1730: pa_debug.g_err_stage := 'Log: Calling Insert_into_CRM procedure';

1726: last_updated_by = G_user_id,
1727: last_update_login = G_login_id
1728: where resource_id = l_res_id;
1729:
1730: pa_debug.g_err_stage := 'Log: Calling Insert_into_CRM procedure';
1731: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1732: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1733: END IF;
1734: insert_into_crm(

Line 1732: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1728: where resource_id = l_res_id;
1729:
1730: pa_debug.g_err_stage := 'Log: Calling Insert_into_CRM procedure';
1731: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1732: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1733: END IF;
1734: insert_into_crm(
1735: P_CATEGORY => p_resource_type,
1736: P_PERSON_ID => p_person_id,

Line 1769: pa_debug.g_err_stage := 'Log: After Insert_into_CRM procedure';

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 */
1771: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1772: END IF;
1773: log_message(' Out of insert_into_crm procedure');

Line 1771: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

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 */
1771: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1772: END IF;
1773: log_message(' Out of insert_into_crm procedure');
1774: log_message('x_crm_resource_id = ' || x_crm_resource_id);
1775: log_message('p_person_id = ' || p_person_id);

Line 1779: pa_debug.g_err_stage := 'Log: End of Create_Internal_Resource procedure';

1775: log_message('p_person_id = ' || p_person_id);
1776: log_message('After CRM '|| x_return_status);
1777: END IF;
1778: END IF;
1779: pa_debug.g_err_stage := 'Log: End of Create_Internal_Resource procedure';
1780: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1781: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1782: END IF;
1783: log_message('End of create_internal_resource procedure');

Line 1781: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1777: END IF;
1778: END IF;
1779: pa_debug.g_err_stage := 'Log: End of Create_Internal_Resource procedure';
1780: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1781: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1782: END IF;
1783: log_message('End of create_internal_resource procedure');
1784:
1785: PA_DEBUG.Reset_Err_Stack;

Line 1785: PA_DEBUG.Reset_Err_Stack;

1781: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1782: END IF;
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

Line 1794: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

1790: x_resource_id := NULL ;
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:

Line 1828: PA_DEBUG.set_err_stack('Create_External_Resource');

1824: l_end_date DATE;
1825: l_return_status VARCHAR2(1);
1826:
1827: BEGIN
1828: PA_DEBUG.set_err_stack('Create_External_Resource');
1829:
1830: pa_debug.g_err_stage := 'Log: Start of Create_External_Resource procedure';
1831: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1832: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

Line 1830: pa_debug.g_err_stage := 'Log: Start of Create_External_Resource procedure';

1826:
1827: BEGIN
1828: PA_DEBUG.set_err_stack('Create_External_Resource');
1829:
1830: pa_debug.g_err_stage := 'Log: Start of Create_External_Resource procedure';
1831: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
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');

Line 1832: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1828: PA_DEBUG.set_err_stack('Create_External_Resource');
1829:
1830: pa_debug.g_err_stage := 'Log: Start of Create_External_Resource procedure';
1831: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
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;

Line 1872: pa_debug.g_err_stage := 'Log: Before Insert_into_PA procedure for external people';

1868: into l_name, l_start_date, l_end_date
1869: from pa_party_resource_details_v
1870: where party_id = l_party_id;
1871:
1872: pa_debug.g_err_stage := 'Log: Before Insert_into_PA procedure for external people';
1873: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1874: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1875: END IF;
1876: --call insert into PA

Line 1874: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1870: where party_id = l_party_id;
1871:
1872: pa_debug.g_err_stage := 'Log: Before Insert_into_PA procedure for external people';
1873: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1874: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1875: END IF;
1876: --call insert into PA
1877:
1878: INSERT_INTO_PA(

Line 1888: pa_debug.g_err_stage := 'Log: After Insert_into_PA procedure for external people';

1884: P_PARTY_ID => l_party_id,
1885: P_NAME => l_name,
1886: X_RETURN_STATUS => x_return_status );
1887:
1888: pa_debug.g_err_stage := 'Log: After Insert_into_PA procedure for external people';
1889: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1890: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1891: END IF;
1892: log_message('** done with insert into PA for external people **');

Line 1890: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1886: X_RETURN_STATUS => x_return_status );
1887:
1888: pa_debug.g_err_stage := 'Log: After Insert_into_PA procedure for external people';
1889: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1890: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1891: END IF;
1892: log_message('** done with insert into PA for external people **');
1893:
1894: ELSE

Line 1895: pa_debug.g_err_stage := 'Log: External resource already in PA - retrieve resource_id';

1891: END IF;
1892: log_message('** done with insert into PA for external people **');
1893:
1894: ELSE
1895: pa_debug.g_err_stage := 'Log: External resource already in PA - retrieve resource_id';
1896: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1897: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1898: END IF;
1899:

Line 1897: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1893:
1894: ELSE
1895: pa_debug.g_err_stage := 'Log: External resource already in PA - retrieve resource_id';
1896: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1897: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1898: END IF;
1899:
1900: log_message('** external resource already in PA - retrieve resource_id **');
1901: --Get resource_id from PA for the resource

Line 1911: pa_debug.g_err_stage := 'Log: End of Create_External_Resource procedure';

1907:
1908: END IF;
1909:
1910:
1911: pa_debug.g_err_stage := 'Log: End of Create_External_Resource procedure';
1912: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1913: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1914: END IF;
1915: log_message('End of create_external_resource procedure');

Line 1913: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

1909:
1910:
1911: pa_debug.g_err_stage := 'Log: End of Create_External_Resource procedure';
1912: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1913: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1914: END IF;
1915: log_message('End of create_external_resource procedure');
1916:
1917: PA_DEBUG.Reset_Err_Stack;

Line 1917: PA_DEBUG.Reset_Err_Stack;

1913: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
1914: END IF;
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

Line 1926: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

1922: x_resource_id := NULL ;
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;

Line 2174: PA_DEBUG.set_err_stack('Create_Resource');

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');
2175:
2176: G_p_id := 0;
2177: G_p_crmwf_id := 0;
2178:

Line 2188: pa_debug.g_err_stage := 'Log: For Internal Resources';

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';
2189: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2190: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2191: END IF;
2192: log_message('For Internal Resources');

Line 2190: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

2186: --If internal resource
2187: IF (l_internal = 'Y' ) THEN
2188: pa_debug.g_err_stage := 'Log: For Internal Resources';
2189: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2190: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2191: END IF;
2192: log_message('For Internal Resources');
2193:
2194: ------------------------------------------------------------

Line 2199: pa_debug.g_err_stage := 'Log: For a single Resource';

2195: -- This is the individual case condition
2196: -- It goes through a loop using pa_r_project_resources_ind_v
2197: ------------------------------------------------------------
2198: IF (l_individual = 'Y') THEN
2199: pa_debug.g_err_stage := 'Log: For a single Resource';
2200: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2201: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2202: END IF;
2203: log_message('For Ind. Resource');

Line 2201: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

2197: ------------------------------------------------------------
2198: IF (l_individual = 'Y') THEN
2199: pa_debug.g_err_stage := 'Log: For a single Resource';
2200: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2201: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2202: END IF;
2203: log_message('For Ind. Resource');
2204:
2205: l_msg_stack_num_old := FND_MSG_PUB.Count_Msg;

Line 2223: pa_debug.g_err_stage := 'OLD PERSON_NAME ==> ' || eRec.NAME;

2219: l_res_found := 'Y';
2220: log_message('=========================');
2221:
2222: --Getting the latest name of person - bug 3273964
2223: pa_debug.g_err_stage := 'OLD PERSON_NAME ==> ' || eRec.NAME;
2224: IF P_DEBUG_MODE = 'Y' THEN
2225: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2226: END IF;
2227:

Line 2225: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

2221:
2222: --Getting the latest name of person - bug 3273964
2223: pa_debug.g_err_stage := 'OLD PERSON_NAME ==> ' || eRec.NAME;
2224: IF P_DEBUG_MODE = 'Y' THEN
2225: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2226: END IF;
2227:
2228: eRec.NAME := pa_resource_utils.get_person_name_no_date(P_PERSON_ID => eRec.person_id);
2229: pa_debug.g_err_stage := 'NEW PERSON_NAME ==> ' || eRec.NAME;

Line 2229: pa_debug.g_err_stage := 'NEW PERSON_NAME ==> ' || eRec.NAME;

2225: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2226: END IF;
2227:
2228: eRec.NAME := pa_resource_utils.get_person_name_no_date(P_PERSON_ID => eRec.person_id);
2229: pa_debug.g_err_stage := 'NEW PERSON_NAME ==> ' || eRec.NAME;
2230: IF P_DEBUG_MODE = 'Y' THEN
2231: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2232: END IF;
2233:

Line 2231: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

2227:
2228: eRec.NAME := pa_resource_utils.get_person_name_no_date(P_PERSON_ID => eRec.person_id);
2229: pa_debug.g_err_stage := 'NEW PERSON_NAME ==> ' || eRec.NAME;
2230: IF P_DEBUG_MODE = 'Y' THEN
2231: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2232: END IF;
2233:
2234: log_message('PERSON_NAME ==> '|| eRec.NAME);
2235: -- End Bug 3273964

Line 2285: pa_debug.g_err_stage := 'Log: Before Insert_into_PA procedure for non-scheduled';

2281: END IF;
2282:
2283: --insert into PA only if the record does not exists yet in the PA tables
2284: IF l_res_exists = 'NOT EXISTS' THEN
2285: pa_debug.g_err_stage := 'Log: Before Insert_into_PA procedure for non-scheduled';
2286: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2287: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2288: END IF;
2289: --call insert into PA

Line 2287: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

2283: --insert into PA only if the record does not exists yet in the PA tables
2284: IF l_res_exists = 'NOT EXISTS' THEN
2285: pa_debug.g_err_stage := 'Log: Before Insert_into_PA procedure for non-scheduled';
2286: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2287: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2288: END IF;
2289: --call insert into PA
2290: INSERT_INTO_PA(
2291: P_RESOURCE_TYPE_ID => l_resource_type_id,

Line 2299: pa_debug.g_err_stage := 'Log: After Insert_into_PA procedure for non-scheduled';

2295: P_PERSON_ID => l_person_id,
2296: P_NAME => l_name,
2297: X_RETURN_STATUS => x_return_status );
2298:
2299: pa_debug.g_err_stage := 'Log: After Insert_into_PA procedure for non-scheduled';
2300: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2301: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2302: END IF;
2303: log_message('** insert into PA for non-scheduled member **');

Line 2301: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

2297: X_RETURN_STATUS => x_return_status );
2298:
2299: pa_debug.g_err_stage := 'Log: After Insert_into_PA procedure for non-scheduled';
2300: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2301: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2302: END IF;
2303: log_message('** insert into PA for non-scheduled member **');
2304:
2305: ELSE

Line 2306: pa_debug.g_err_stage := 'Log: Resource already in PA - retrieve resource_id';

2302: END IF;
2303: log_message('** insert into PA for non-scheduled member **');
2304:
2305: ELSE
2306: pa_debug.g_err_stage := 'Log: Resource already in PA - retrieve resource_id';
2307: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2308: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2309: END IF;
2310:

Line 2308: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

2304:
2305: ELSE
2306: pa_debug.g_err_stage := 'Log: Resource already in PA - retrieve resource_id';
2307: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2308: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2309: END IF;
2310:
2311: log_message('** resource already in PA - retrieve resource_id **');
2312: --Get resource_id from PA for the resource

Line 2357: pa_debug.g_err_stage := 'Log: Scheduled member does not belong to an Exp Hierarhy Org';

2353: l_exp_org := 'NO';
2354: END IF;
2355:
2356: If l_exp_org = 'NO' Then
2357: pa_debug.g_err_stage := 'Log: Scheduled member does not belong to an Exp Hierarhy Org';
2358: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2359: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2360: END IF;
2361: log_message('Scheduled member does not belong to an Exp Hierarhy Org');

Line 2359: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

2355:
2356: If l_exp_org = 'NO' Then
2357: pa_debug.g_err_stage := 'Log: Scheduled member does not belong to an Exp Hierarhy Org';
2358: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2359: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2360: END IF;
2361: log_message('Scheduled member does not belong to an Exp Hierarhy Org');
2362:
2363: PA_UTILS.Add_Message(

Line 2512: pa_debug.g_err_stage := 'Log: Multi Org - OU does not implement Projects';

2508: X_EXP_OU => x_exp_ou,
2509: X_RETURN_STATUS => x_return_status);
2510:
2511: IF(x_exp_ou = 'N') THEN
2512: pa_debug.g_err_stage := 'Log: Multi Org - OU does not implement Projects';
2513: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2514: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2515: END IF;
2516: PA_UTILS.Add_Message(

Line 2514: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

2510:
2511: IF(x_exp_ou = 'N') THEN
2512: pa_debug.g_err_stage := 'Log: Multi Org - OU does not implement Projects';
2513: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2514: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2515: END IF;
2516: PA_UTILS.Add_Message(
2517: p_app_short_name => 'PA'
2518: ,p_msg_name => 'PA_OU_NO_PROJECTS');

Line 2767: pa_debug.g_err_stage := 'Log: Start of Create_Resource';

2763: END IF;
2764: END IF;
2765:
2766: -- hr_utility.trace('after my changes');
2767: pa_debug.g_err_stage := 'Log: Start of Create_Resource';
2768: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2769: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2770: END IF;
2771: log_message('For a batch of people');

Line 2769: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

2765:
2766: -- hr_utility.trace('after my changes');
2767: pa_debug.g_err_stage := 'Log: Start of Create_Resource';
2768: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2769: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2770: END IF;
2771: log_message('For a batch of people');
2772:
2773: --Inside the concurrent process

Line 2774: pa_debug.g_err_stage := 'Log: Before looping through each person record';

2770: END IF;
2771: log_message('For a batch of people');
2772:
2773: --Inside the concurrent process
2774: pa_debug.g_err_stage := 'Log: Before looping through each person record';
2775: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2776: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2777: END IF;
2778: pa_debug.g_err_stage := '*******************************************************';

Line 2776: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

2772:
2773: --Inside the concurrent process
2774: pa_debug.g_err_stage := 'Log: Before looping through each person record';
2775: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2776: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2777: END IF;
2778: pa_debug.g_err_stage := '*******************************************************';
2779: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2780: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

Line 2778: pa_debug.g_err_stage := '*******************************************************';

2774: pa_debug.g_err_stage := 'Log: Before looping through each person record';
2775: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2776: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2777: END IF;
2778: pa_debug.g_err_stage := '*******************************************************';
2779: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2780: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2781: END IF;
2782: log_message('*****************************************');

Line 2780: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

2776: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2777: END IF;
2778: pa_debug.g_err_stage := '*******************************************************';
2779: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2780: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2781: END IF;
2782: log_message('*****************************************');
2783: log_message('Before looping through each person record');
2784:

Line 3015: pa_debug.g_err_stage := 'Log: Resource already in denorm and l_refresh=N: person_id=' || l_person_id;

3011: fetch check_res_denorm into l_denorm_yes;
3012: close check_res_denorm;
3013:
3014: if l_denorm_yes = 'Y' then
3015: pa_debug.g_err_stage := 'Log: Resource already in denorm and l_refresh=N: person_id=' || l_person_id;
3016: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3017: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3018: END IF;
3019: log_message('Resource already in denorm and l_refresh=N: person_id=' || l_person_id);

Line 3017: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

3013:
3014: if l_denorm_yes = 'Y' then
3015: pa_debug.g_err_stage := 'Log: Resource already in denorm and l_refresh=N: person_id=' || l_person_id;
3016: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3017: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3018: END IF;
3019: log_message('Resource already in denorm and l_refresh=N: person_id=' || l_person_id);
3020: raise PERSON_ERROR_EXCEPTION;
3021: end if;

Line 3030: pa_debug.g_err_stage := 'Log: COMMIT for person_id = ' || G_person_id;

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 */
3032: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3033: END IF;
3034: /* Adding the following code to re-establish

Line 3032: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

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 */
3032: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3033: END IF;
3034: /* Adding the following code to re-establish
3035: Savepoint after l_max_count resources are
3036: committed

Line 3047: pa_debug.g_err_stage := 'OLD PERSON_NAME ==> ' ||eRec.NAME;

3043: log_message('G_person_id value = ' || G_person_id);
3044: log_message('l_person_id value = ' || l_person_id);
3045:
3046: --Getting the latest name of person - bug 3273964
3047: pa_debug.g_err_stage := 'OLD PERSON_NAME ==> ' ||eRec.NAME;
3048: IF P_DEBUG_MODE = 'Y' THEN
3049: pa_debug.write_file('start_crm_workflow: ' ||'LOG',pa_debug.g_err_stage);
3050: END IF;
3051:

Line 3049: pa_debug.write_file('start_crm_workflow: ' ||'LOG',pa_debug.g_err_stage);

3045:
3046: --Getting the latest name of person - bug 3273964
3047: pa_debug.g_err_stage := 'OLD PERSON_NAME ==> ' ||eRec.NAME;
3048: IF P_DEBUG_MODE = 'Y' THEN
3049: pa_debug.write_file('start_crm_workflow: ' ||'LOG',pa_debug.g_err_stage);
3050: END IF;
3051:
3052: eRec.NAME := pa_resource_utils.get_person_name_no_date(P_PERSON_ID => eRec.person_id);
3053:

Line 3054: pa_debug.g_err_stage := 'NEW PERSON_NAME ==> ' || eRec.NAME;

3050: END IF;
3051:
3052: eRec.NAME := pa_resource_utils.get_person_name_no_date(P_PERSON_ID => eRec.person_id);
3053:
3054: pa_debug.g_err_stage := 'NEW PERSON_NAME ==> ' || eRec.NAME;
3055: IF P_DEBUG_MODE = 'Y' THEN
3056: pa_debug.write_file('start_crm_workflow: ' ||'LOG',pa_debug.g_err_stage);
3057: END IF;
3058:

Line 3056: pa_debug.write_file('start_crm_workflow: ' ||'LOG',pa_debug.g_err_stage);

3052: eRec.NAME := pa_resource_utils.get_person_name_no_date(P_PERSON_ID => eRec.person_id);
3053:
3054: pa_debug.g_err_stage := 'NEW PERSON_NAME ==> ' || eRec.NAME;
3055: IF P_DEBUG_MODE = 'Y' THEN
3056: pa_debug.write_file('start_crm_workflow: ' ||'LOG',pa_debug.g_err_stage);
3057: END IF;
3058:
3059: log_message('PERSON_NAME ==> '|| eRec.NAME);
3060: -- end bug 3273964

Line 3081: pa_debug.g_err_stage := 'Log: Unable to acquire LOCK for person_id = ' || l_person_id;

3077: -- expected error which stores the error msg in
3078: -- the pa_reporting_exceptions table)
3079: -------------------------------------------------
3080: if(pa_resource_utils.acquire_user_lock(l_person_id, 'Resource Pull') <> 0) then
3081: pa_debug.g_err_stage := 'Log: Unable to acquire LOCK for person_id = ' || l_person_id;
3082: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3083: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3084: END IF;
3085: log_message('Unable to acquire LOCK for person_id = ' || l_person_id);

Line 3083: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

3079: -------------------------------------------------
3080: if(pa_resource_utils.acquire_user_lock(l_person_id, 'Resource Pull') <> 0) then
3081: pa_debug.g_err_stage := 'Log: Unable to acquire LOCK for person_id = ' || l_person_id;
3082: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3083: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3084: END IF;
3085: log_message('Unable to acquire LOCK for person_id = ' || l_person_id);
3086:
3087: -- get the info of this person to be inserted into exception table

Line 3103: pa_debug.g_err_stage := 'Log: Able to acquire LOCK for person_id = ' || l_person_id;

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 */
3105: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3106: END IF;
3107: log_message('Able to acquire LOCK for person_id = ' || l_person_id);

Line 3105: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

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 */
3105: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3106: END IF;
3107: log_message('Able to acquire LOCK for person_id = ' || l_person_id);
3108: end if;
3109:

Line 3144: pa_debug.g_err_stage := '*******************************************************';

3140: raise PERSON_ERROR_EXCEPTION;
3141: END IF;
3142: END IF;
3143:
3144: pa_debug.g_err_stage := '*******************************************************';
3145: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3146: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3147: END IF;
3148: pa_debug.g_err_stage := 'PERSON_ID ==> ' || to_char(l_person_id);

Line 3146: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

3142: END IF;
3143:
3144: pa_debug.g_err_stage := '*******************************************************';
3145: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3146: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3147: END IF;
3148: pa_debug.g_err_stage := 'PERSON_ID ==> ' || to_char(l_person_id);
3149: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3150: pa_debug.write_file('start_crm_workflow: ' || 'LOG', pa_debug.g_err_stage);

Line 3148: pa_debug.g_err_stage := 'PERSON_ID ==> ' || to_char(l_person_id);

3144: pa_debug.g_err_stage := '*******************************************************';
3145: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3146: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3147: END IF;
3148: pa_debug.g_err_stage := 'PERSON_ID ==> ' || to_char(l_person_id);
3149: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3150: pa_debug.write_file('start_crm_workflow: ' || 'LOG', pa_debug.g_err_stage);
3151: END IF;
3152: log_message('*****************************************');

Line 3150: pa_debug.write_file('start_crm_workflow: ' || 'LOG', pa_debug.g_err_stage);

3146: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3147: END IF;
3148: pa_debug.g_err_stage := 'PERSON_ID ==> ' || to_char(l_person_id);
3149: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3150: pa_debug.write_file('start_crm_workflow: ' || 'LOG', pa_debug.g_err_stage);
3151: END IF;
3152: log_message('*****************************************');
3153: log_message('PERSON_ID ==> '|| to_char(l_person_id));
3154:

Line 3190: pa_debug.g_err_stage := 'Log: Calling Create_Internal_Resource procedure';

3186: x_country => l_country,
3187: x_return_status => l_return_status);
3188:
3189:
3190: pa_debug.g_err_stage := 'Log: Calling Create_Internal_Resource procedure';
3191: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3192: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3193: END IF;
3194:

Line 3192: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

3188:
3189:
3190: pa_debug.g_err_stage := 'Log: Calling Create_Internal_Resource procedure';
3191: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3192: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3193: END IF;
3194:
3195: --Call check_res_exists procedure Added for bug 5046096
3196: PA_RESOURCE_UTILS.CHECK_RES_EXISTS(

Line 3248: pa_debug.g_err_stage := 'Log: After Create_Internal_Resource procedure';

3244: P_SOURCE_MIDDLE_NAME => eRec.per_middle_name);
3245:
3246: -- hr_utility.trace('after CREATE_INTERNAL_RESOURCE');
3247: -- hr_utility.trace('x_return_status is : ' || x_return_status);
3248: pa_debug.g_err_stage := 'Log: After Create_Internal_Resource procedure';
3249: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3250: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3251: END IF;
3252:

Line 3250: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

3246: -- hr_utility.trace('after CREATE_INTERNAL_RESOURCE');
3247: -- hr_utility.trace('x_return_status is : ' || x_return_status);
3248: pa_debug.g_err_stage := 'Log: After Create_Internal_Resource procedure';
3249: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
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

Line 3270: pa_debug.g_err_stage := 'Log: Calling Check_OU procedure';

3266: log_message('Return Status after create internal resource ' || l_return_status);
3267:
3268: --Adding call to check if OU is Exp OU only if the org is a Multi-Org
3269: log_message('Calling check_ou');
3270: pa_debug.g_err_stage := 'Log: Calling Check_OU procedure';
3271: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3272: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3273: END IF;
3274: --MOAC Changes : Bug 4363092: Commenting this cursor as now As R12 will have multi org setup only

Line 3272: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

3268: --Adding call to check if OU is Exp OU only if the org is a Multi-Org
3269: log_message('Calling check_ou');
3270: pa_debug.g_err_stage := 'Log: Calling Check_OU procedure';
3271: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3272: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3273: END IF;
3274: --MOAC Changes : Bug 4363092: Commenting this cursor as now As R12 will have multi org setup only
3275: /* OPEN check_org_type;
3276: FETCH check_org_type into l_org_type;

Line 3290: pa_debug.g_err_stage := 'Log: Multi Org - OU does not implement Projects';

3286: -- X_RETURN_STATUS => x_return_status); -- Commenting For bug 4087022
3287: X_RETURN_STATUS => l_return_status);
3288:
3289: IF(x_exp_ou = 'N') THEN
3290: pa_debug.g_err_stage := 'Log: Multi Org - OU does not implement Projects';
3291: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3292: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3293: END IF;
3294: PA_UTILS.Add_Message(

Line 3292: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

3288:
3289: IF(x_exp_ou = 'N') THEN
3290: pa_debug.g_err_stage := 'Log: Multi Org - OU does not implement Projects';
3291: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3292: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3293: END IF;
3294: PA_UTILS.Add_Message(
3295: p_app_short_name => 'PA'
3296: ,p_msg_name => 'PA_OU_NO_PROJECTS');

Line 3316: pa_debug.g_err_stage := 'Log: Calling Populate_Resources_Denorm procedure';

3312:
3313: log_message('l_default_OU =====> '||to_char(l_default_OU));
3314:
3315: --Adding call to populate resource denorm tables
3316: pa_debug.g_err_stage := 'Log: Calling Populate_Resources_Denorm procedure';
3317: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3318: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3319: END IF;
3320:

Line 3318: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

3314:
3315: --Adding call to populate resource denorm tables
3316: pa_debug.g_err_stage := 'Log: Calling Populate_Resources_Denorm procedure';
3317: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3318: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3319: END IF;
3320:
3321: -- hr_utility.trace('before populate_resources_denorm');
3322:

Line 3371: pa_debug.g_err_stage := 'Log: After Populate_Resources_Denorm procedure';

3367:
3368: -- hr_utility.trace('after populate_resources_denorm');
3369: -- hr_utility.trace('x_return_status is : ' || x_return_status);
3370: -- hr_utility.trace('x_msg_data is : ' || x_msg_data);
3371: pa_debug.g_err_stage := 'Log: After Populate_Resources_Denorm procedure';
3372: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3373: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3374: END IF;
3375: -- log_message('After resources denorm '|| x_return_status); -- Commenting For bug 4087022

Line 3373: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

3369: -- hr_utility.trace('x_return_status is : ' || x_return_status);
3370: -- hr_utility.trace('x_msg_data is : ' || x_msg_data);
3371: pa_debug.g_err_stage := 'Log: After Populate_Resources_Denorm procedure';
3372: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3373: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3374: END IF;
3375: -- log_message('After resources denorm '|| x_return_status); -- Commenting For bug 4087022
3376: log_message('After resources denorm '|| l_return_status);
3377: END IF; -- Bug 6411422

Line 3390: pa_debug.g_err_stage := 'Delete Terminate resource denorm data';

3386: IF (trunc(l_end_date) = trunc(l_assignment_end_date))
3387: AND eRec.termination_date IS NOT NULL THEN
3388:
3389: log_message('Delete Terminate resource denorm data');
3390: pa_debug.g_err_stage := 'Delete Terminate resource denorm data';
3391: IF P_DEBUG_MODE = 'Y' THEN
3392: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3393: END IF;
3394:

Line 3392: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

3388:
3389: log_message('Delete Terminate resource denorm data');
3390: pa_debug.g_err_stage := 'Delete Terminate resource denorm data';
3391: IF P_DEBUG_MODE = 'Y' THEN
3392: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3393: END IF;
3394:
3395: DELETE FROM PA_RESOURCES_DENORM
3396: WHERE person_id = l_person_id

Line 3400: pa_debug.g_err_stage := 'Log: after calling deleting denorm data';

3396: WHERE person_id = l_person_id
3397: AND resource_effective_start_date > l_end_date;
3398:
3399: log_message('right after calling deleting denorm data');
3400: pa_debug.g_err_stage := 'Log: after calling deleting denorm data';
3401: IF P_DEBUG_MODE = 'Y' THEN
3402: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3403: END IF;
3404:

Line 3402: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

3398:
3399: log_message('right after calling deleting denorm data');
3400: pa_debug.g_err_stage := 'Log: after calling deleting denorm data';
3401: IF P_DEBUG_MODE = 'Y' THEN
3402: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3403: END IF;
3404:
3405: END IF;
3406: /* Changes end for Bug 5662589 */

Line 3452: pa_debug.g_err_stage := 'Log: Calling pa_resource_utils.init_fte_sync_wf for PersonId =' || to_char(l_person_id) ;

3448: END LOOP ;
3449: /*Code ends for Bug 6943551*/
3450:
3451: /*Call added for bug 5683340*/
3452: pa_debug.g_err_stage := 'Log: Calling pa_resource_utils.init_fte_sync_wf for PersonId =' || to_char(l_person_id) ;
3453: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3454: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3455: END IF;
3456:

Line 3454: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

3450:
3451: /*Call added for bug 5683340*/
3452: pa_debug.g_err_stage := 'Log: Calling pa_resource_utils.init_fte_sync_wf for PersonId =' || to_char(l_person_id) ;
3453: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3454: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3455: END IF;
3456:
3457: log_message('Before Calling pa_resource_utils.init_fte_sync_wf');
3458: pa_resource_utils.init_fte_sync_wf( p_person_id => l_person_id,

Line 3468: pa_debug.g_err_stage := 'Log: After Calling pa_resource_utils.init_fte_sync_wf for PersonId =' || to_char(l_person_id) ;

3464: -- log_message('After Calling pa_resource_utils.init_fte_sync_wf, x_return_status: '||x_return_status); -- bug 5683340 ---- Commenting For bug 4087022
3465: log_message('After Calling pa_resource_utils.init_fte_sync_wf, l_return_status: '||l_return_status); -- bug 5683340
3466:
3467:
3468: pa_debug.g_err_stage := 'Log: After Calling pa_resource_utils.init_fte_sync_wf for PersonId =' || to_char(l_person_id) ;
3469: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3470: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3471: END IF;
3472:

Line 3470: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

3466:
3467:
3468: pa_debug.g_err_stage := 'Log: After Calling pa_resource_utils.init_fte_sync_wf for PersonId =' || to_char(l_person_id) ;
3469: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3470: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3471: END IF;
3472:
3473:
3474: /*IF - ELSIF block added for bug 5683340*/

Line 3477: pa_debug.g_err_stage := 'Log: Calling Create_Timeline procedure for PersonId =' || to_char(l_person_id) ;

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;
3481: log_message('Calling Create_Timeline procedure after the last assignment for PersonId =' || to_char(l_person_id));

Line 3479: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

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;
3481: log_message('Calling Create_Timeline procedure after the last assignment for PersonId =' || to_char(l_person_id));
3482:
3483: -- hr_utility.trace('before Create_Timeline');

Line 3500: pa_debug.g_err_stage := 'Log: After Create_Timeline procedure';

3496: -- hr_utility.trace('x_msg_data is : ' || x_msg_data);
3497:
3498: -- log_message('right after calling create_timeline, x_return_status : '||x_return_status); -- Commenting For bug 4087022
3499: log_message('right after calling create_timeline, l_return_status : '||l_return_status);
3500: pa_debug.g_err_stage := 'Log: After Create_Timeline procedure';
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:

Line 3502: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

3498: -- log_message('right after calling create_timeline, x_return_status : '||x_return_status); -- Commenting For bug 4087022
3499: log_message('right after calling create_timeline, l_return_status : '||l_return_status);
3500: pa_debug.g_err_stage := 'Log: After Create_Timeline procedure';
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

Line 3508: pa_debug.g_err_stage := 'Log: Timeline API returned error';

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);
3511: END IF;
3512: l_per_success := 'N';

Line 3510: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

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);
3511: END IF;
3512: l_per_success := 'N';
3513: RAISE FND_API.G_EXC_ERROR;
3514: END IF;

Line 3521: pa_debug.g_err_stage := 'Log: init_fte_sync_wf API returned error';

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;
3525: l_per_success := 'N';

Line 3523: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

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

Line 3603: pa_debug.g_err_stage := 'Expected error for Person = ' || to_char(l_person_id);

3599: p_msg_index => 1,
3600: p_data => x_msg_data,
3601: p_msg_index_out => x_msg_count );
3602:
3603: pa_debug.g_err_stage := 'Expected error for Person = ' || to_char(l_person_id);
3604: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3605: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3606: END IF;
3607: pa_debug.g_err_stage := 'ERROR: ' || substr(x_msg_data,1,200);

Line 3605: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

3601: p_msg_index_out => x_msg_count );
3602:
3603: pa_debug.g_err_stage := 'Expected error for Person = ' || to_char(l_person_id);
3604: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3605: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3606: END IF;
3607: pa_debug.g_err_stage := 'ERROR: ' || substr(x_msg_data,1,200);
3608: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3609: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

Line 3607: pa_debug.g_err_stage := 'ERROR: ' || substr(x_msg_data,1,200);

3603: pa_debug.g_err_stage := 'Expected error for Person = ' || to_char(l_person_id);
3604: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3605: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3606: END IF;
3607: pa_debug.g_err_stage := 'ERROR: ' || substr(x_msg_data,1,200);
3608: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3609: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3610: END IF;
3611:

Line 3609: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

3605: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3606: END IF;
3607: pa_debug.g_err_stage := 'ERROR: ' || substr(x_msg_data,1,200);
3608: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3609: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3610: END IF;
3611:
3612: log_message('Expected error for Person = ' || to_char(l_person_id));
3613: log_message('ERROR: ' || substr(x_msg_data,1,200));

Line 3702: pa_debug.g_err_stage := 'Log: Calling Populate_Org_Hier_Denorm procedure';

3698: DBMS_SQL.CLOSE_CURSOR(sql_cursor);
3699:
3700: -- End Bug 3086960
3701:
3702: pa_debug.g_err_stage := 'Log: Calling Populate_Org_Hier_Denorm procedure';
3703: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3704: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3705: END IF;
3706: log_message('Calling Populate_Org_Hier_Denorm procedure');

Line 3704: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

3700: -- End Bug 3086960
3701:
3702: pa_debug.g_err_stage := 'Log: Calling Populate_Org_Hier_Denorm procedure';
3703: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3704: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3705: END IF;
3706: log_message('Calling Populate_Org_Hier_Denorm procedure');
3707:
3708: -- Begin Bug 3086960. Commented out for performance. Sachin

Line 3714: pa_debug.g_err_stage := 'Log: After Populate_Org_Hier_Denorm procedure';

3710: PA_ORG_UTILS.Populate_Org_Hier_Denorm(
3711: x_return_status => x_return_status,
3712: x_msg_data => x_msg_data);
3713: */
3714: pa_debug.g_err_stage := 'Log: After Populate_Org_Hier_Denorm procedure';
3715: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3716: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3717: END IF;
3718: log_message('Out of Populate_Org_Hier_Denorm procedure');

Line 3716: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

3712: x_msg_data => x_msg_data);
3713: */
3714: pa_debug.g_err_stage := 'Log: After Populate_Org_Hier_Denorm procedure';
3715: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3716: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3717: END IF;
3718: log_message('Out of Populate_Org_Hier_Denorm procedure');
3719:
3720:

Line 3732: pa_debug.g_err_stage := 'Log: For a single external Resource';

3728: -- PULLING EXTERNAL PEOPLE
3729: ----------------------------------------------------
3730:
3731: IF (l_individual = 'Y') THEN
3732: pa_debug.g_err_stage := 'Log: For a single external Resource';
3733: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3734: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3735: END IF;
3736: log_message('For Ind. External Resource');

Line 3734: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

3730:
3731: IF (l_individual = 'Y') THEN
3732: pa_debug.g_err_stage := 'Log: For a single external Resource';
3733: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3734: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3735: END IF;
3736: log_message('For Ind. External Resource');
3737:
3738: -----------------------------------------------------------------

Line 3765: pa_debug.g_err_stage := 'Log: End of Create_Resource procedure';

3761: END IF;
3762:
3763: END IF; --For Internal
3764:
3765: pa_debug.g_err_stage := 'Log: End of Create_Resource procedure';
3766: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
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');

Line 3767: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);

3763: END IF; --For Internal
3764:
3765: pa_debug.g_err_stage := 'Log: End of Create_Resource procedure';
3766: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
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

Line 3788: PA_DEBUG.Reset_Err_Stack;

3784: G_request_id := NULL;
3785: G_program_id := NULL;
3786: G_application_id := NULL;
3787:
3788: PA_DEBUG.Reset_Err_Stack;
3789:
3790: /*Added for bug 4087022*/
3791: /*to return status as warning when l_excep = Y , i.e., */
3792: /*when some resource raised exception in inner loop */

Line 3822: ,p_procedure_name =>PA_DEBUG.G_Err_Stack );

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'
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;