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.AMW_PROC_ORG_HIERARCHY_PVT dependencies on FND_FILE

Line 945: fnd_file.put_line(fnd_file.LOG, 'INSIDE PROCESS_AMW_PROCESS_ORG');

941: x_msg_count => x_msg_count,
942: x_msg_data => x_msg_data
943: );
944:
945: fnd_file.put_line(fnd_file.LOG, 'INSIDE PROCESS_AMW_PROCESS_ORG');
946: fnd_file.put_line(fnd_file.LOG, 'p_rcm_assoc: '||p_rcm_assoc);
947: fnd_file.put_line(fnd_file.LOG, 'p_batch_id: '||p_batch_id);
948: fnd_file.put_line(fnd_file.LOG, 'p_risk_id: '||p_risk_id);
949: fnd_file.put_line(fnd_file.LOG, 'p_control_id: '||p_control_id);

Line 946: fnd_file.put_line(fnd_file.LOG, 'p_rcm_assoc: '||p_rcm_assoc);

942: x_msg_data => x_msg_data
943: );
944:
945: fnd_file.put_line(fnd_file.LOG, 'INSIDE PROCESS_AMW_PROCESS_ORG');
946: fnd_file.put_line(fnd_file.LOG, 'p_rcm_assoc: '||p_rcm_assoc);
947: fnd_file.put_line(fnd_file.LOG, 'p_batch_id: '||p_batch_id);
948: fnd_file.put_line(fnd_file.LOG, 'p_risk_id: '||p_risk_id);
949: fnd_file.put_line(fnd_file.LOG, 'p_control_id: '||p_control_id);
950: fnd_file.put_line(fnd_file.LOG, '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%');

Line 947: fnd_file.put_line(fnd_file.LOG, 'p_batch_id: '||p_batch_id);

943: );
944:
945: fnd_file.put_line(fnd_file.LOG, 'INSIDE PROCESS_AMW_PROCESS_ORG');
946: fnd_file.put_line(fnd_file.LOG, 'p_rcm_assoc: '||p_rcm_assoc);
947: fnd_file.put_line(fnd_file.LOG, 'p_batch_id: '||p_batch_id);
948: fnd_file.put_line(fnd_file.LOG, 'p_risk_id: '||p_risk_id);
949: fnd_file.put_line(fnd_file.LOG, 'p_control_id: '||p_control_id);
950: fnd_file.put_line(fnd_file.LOG, '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%');
951:

Line 948: fnd_file.put_line(fnd_file.LOG, 'p_risk_id: '||p_risk_id);

944:
945: fnd_file.put_line(fnd_file.LOG, 'INSIDE PROCESS_AMW_PROCESS_ORG');
946: fnd_file.put_line(fnd_file.LOG, 'p_rcm_assoc: '||p_rcm_assoc);
947: fnd_file.put_line(fnd_file.LOG, 'p_batch_id: '||p_batch_id);
948: fnd_file.put_line(fnd_file.LOG, 'p_risk_id: '||p_risk_id);
949: fnd_file.put_line(fnd_file.LOG, 'p_control_id: '||p_control_id);
950: fnd_file.put_line(fnd_file.LOG, '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%');
951:
952: if(p_rcm_assoc = 'Y')then

Line 949: fnd_file.put_line(fnd_file.LOG, 'p_control_id: '||p_control_id);

945: fnd_file.put_line(fnd_file.LOG, 'INSIDE PROCESS_AMW_PROCESS_ORG');
946: fnd_file.put_line(fnd_file.LOG, 'p_rcm_assoc: '||p_rcm_assoc);
947: fnd_file.put_line(fnd_file.LOG, 'p_batch_id: '||p_batch_id);
948: fnd_file.put_line(fnd_file.LOG, 'p_risk_id: '||p_risk_id);
949: fnd_file.put_line(fnd_file.LOG, 'p_control_id: '||p_control_id);
950: fnd_file.put_line(fnd_file.LOG, '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%');
951:
952: if(p_rcm_assoc = 'Y')then
953: fnd_file.put_line(fnd_file.LOG, 'WILL BE CALLING THE NEW API HERE');

Line 950: fnd_file.put_line(fnd_file.LOG, '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%');

946: fnd_file.put_line(fnd_file.LOG, 'p_rcm_assoc: '||p_rcm_assoc);
947: fnd_file.put_line(fnd_file.LOG, 'p_batch_id: '||p_batch_id);
948: fnd_file.put_line(fnd_file.LOG, 'p_risk_id: '||p_risk_id);
949: fnd_file.put_line(fnd_file.LOG, 'p_control_id: '||p_control_id);
950: fnd_file.put_line(fnd_file.LOG, '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%');
951:
952: if(p_rcm_assoc = 'Y')then
953: fnd_file.put_line(fnd_file.LOG, 'WILL BE CALLING THE NEW API HERE');
954: process_amw_rcm_org(

Line 953: fnd_file.put_line(fnd_file.LOG, 'WILL BE CALLING THE NEW API HERE');

949: fnd_file.put_line(fnd_file.LOG, 'p_control_id: '||p_control_id);
950: fnd_file.put_line(fnd_file.LOG, '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%');
951:
952: if(p_rcm_assoc = 'Y')then
953: fnd_file.put_line(fnd_file.LOG, 'WILL BE CALLING THE NEW API HERE');
954: process_amw_rcm_org(
955: p_batch_id => p_batch_id,
956: p_rcm_org_intf_id => p_rcm_org_intf_id,
957: p_process_organization_id => l_process_organization_id,

Line 968: fnd_file.put_line(fnd_file.LOG, 'PROCESS_AMW_RCM_ORG END: X_RETURN_STATUS: '||X_RETURN_STATUS);

964: x_return_status => x_return_status,
965: x_msg_count => x_msg_count,
966: x_msg_data => x_msg_data);
967:
968: fnd_file.put_line(fnd_file.LOG, 'PROCESS_AMW_RCM_ORG END: X_RETURN_STATUS: '||X_RETURN_STATUS);
969: else
970: fnd_file.put_line(fnd_file.LOG, 'CALLING THE old API HERE');
971: process_amw_risk_assoc(
972: p_assoc_mode => l_assoc_mode,

Line 970: fnd_file.put_line(fnd_file.LOG, 'CALLING THE old API HERE');

966: x_msg_data => x_msg_data);
967:
968: fnd_file.put_line(fnd_file.LOG, 'PROCESS_AMW_RCM_ORG END: X_RETURN_STATUS: '||X_RETURN_STATUS);
969: else
970: fnd_file.put_line(fnd_file.LOG, 'CALLING THE old API HERE');
971: process_amw_risk_assoc(
972: p_assoc_mode => l_assoc_mode,
973: p_process_id => p_apo_type.process_id,
974: p_process_organization_id => l_process_organization_id,

Line 1077: fnd_file.PUT_LINE( fnd_file.LOG, '%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&');

1073: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1074: RAISE FND_API.G_EXC_ERROR;
1075: END IF;
1076:
1077: fnd_file.PUT_LINE( fnd_file.LOG, '%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&');
1078: fnd_file.PUT_LINE( fnd_file.LOG, 'INSIDE PROCESS_AMW_RCM_ORG');
1079: fnd_file.put_line( fnd_file.Log, 'VALUES GOT --> ');
1080: fnd_file.PUT_LINE( fnd_file.LOG, 'p_batch_id: '||p_batch_id );
1081: fnd_file.PUT_LINE( fnd_file.LOG, 'p_rcm_org_intf_id: '||p_rcm_org_intf_id );

Line 1078: fnd_file.PUT_LINE( fnd_file.LOG, 'INSIDE PROCESS_AMW_RCM_ORG');

1074: RAISE FND_API.G_EXC_ERROR;
1075: END IF;
1076:
1077: fnd_file.PUT_LINE( fnd_file.LOG, '%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&');
1078: fnd_file.PUT_LINE( fnd_file.LOG, 'INSIDE PROCESS_AMW_RCM_ORG');
1079: fnd_file.put_line( fnd_file.Log, 'VALUES GOT --> ');
1080: fnd_file.PUT_LINE( fnd_file.LOG, 'p_batch_id: '||p_batch_id );
1081: fnd_file.PUT_LINE( fnd_file.LOG, 'p_rcm_org_intf_id: '||p_rcm_org_intf_id );
1082: fnd_file.PUT_LINE( fnd_file.LOG, 'p_process_organization_id: '||p_process_organization_id );

Line 1079: fnd_file.put_line( fnd_file.Log, 'VALUES GOT --> ');

1075: END IF;
1076:
1077: fnd_file.PUT_LINE( fnd_file.LOG, '%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&');
1078: fnd_file.PUT_LINE( fnd_file.LOG, 'INSIDE PROCESS_AMW_RCM_ORG');
1079: fnd_file.put_line( fnd_file.Log, 'VALUES GOT --> ');
1080: fnd_file.PUT_LINE( fnd_file.LOG, 'p_batch_id: '||p_batch_id );
1081: fnd_file.PUT_LINE( fnd_file.LOG, 'p_rcm_org_intf_id: '||p_rcm_org_intf_id );
1082: fnd_file.PUT_LINE( fnd_file.LOG, 'p_process_organization_id: '||p_process_organization_id );
1083: fnd_file.PUT_LINE( fnd_file.LOG, 'p_organization_id: '||p_organization_id );

Line 1080: fnd_file.PUT_LINE( fnd_file.LOG, 'p_batch_id: '||p_batch_id );

1076:
1077: fnd_file.PUT_LINE( fnd_file.LOG, '%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&');
1078: fnd_file.PUT_LINE( fnd_file.LOG, 'INSIDE PROCESS_AMW_RCM_ORG');
1079: fnd_file.put_line( fnd_file.Log, 'VALUES GOT --> ');
1080: fnd_file.PUT_LINE( fnd_file.LOG, 'p_batch_id: '||p_batch_id );
1081: fnd_file.PUT_LINE( fnd_file.LOG, 'p_rcm_org_intf_id: '||p_rcm_org_intf_id );
1082: fnd_file.PUT_LINE( fnd_file.LOG, 'p_process_organization_id: '||p_process_organization_id );
1083: fnd_file.PUT_LINE( fnd_file.LOG, 'p_organization_id: '||p_organization_id );
1084: fnd_file.PUT_LINE( fnd_file.LOG, 'p_process_id: '||p_process_id );

Line 1081: fnd_file.PUT_LINE( fnd_file.LOG, 'p_rcm_org_intf_id: '||p_rcm_org_intf_id );

1077: fnd_file.PUT_LINE( fnd_file.LOG, '%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&');
1078: fnd_file.PUT_LINE( fnd_file.LOG, 'INSIDE PROCESS_AMW_RCM_ORG');
1079: fnd_file.put_line( fnd_file.Log, 'VALUES GOT --> ');
1080: fnd_file.PUT_LINE( fnd_file.LOG, 'p_batch_id: '||p_batch_id );
1081: fnd_file.PUT_LINE( fnd_file.LOG, 'p_rcm_org_intf_id: '||p_rcm_org_intf_id );
1082: fnd_file.PUT_LINE( fnd_file.LOG, 'p_process_organization_id: '||p_process_organization_id );
1083: fnd_file.PUT_LINE( fnd_file.LOG, 'p_organization_id: '||p_organization_id );
1084: fnd_file.PUT_LINE( fnd_file.LOG, 'p_process_id: '||p_process_id );
1085: fnd_file.PUT_LINE( fnd_file.LOG, 'p_risk_id: '||p_risk_id );

Line 1082: fnd_file.PUT_LINE( fnd_file.LOG, 'p_process_organization_id: '||p_process_organization_id );

1078: fnd_file.PUT_LINE( fnd_file.LOG, 'INSIDE PROCESS_AMW_RCM_ORG');
1079: fnd_file.put_line( fnd_file.Log, 'VALUES GOT --> ');
1080: fnd_file.PUT_LINE( fnd_file.LOG, 'p_batch_id: '||p_batch_id );
1081: fnd_file.PUT_LINE( fnd_file.LOG, 'p_rcm_org_intf_id: '||p_rcm_org_intf_id );
1082: fnd_file.PUT_LINE( fnd_file.LOG, 'p_process_organization_id: '||p_process_organization_id );
1083: fnd_file.PUT_LINE( fnd_file.LOG, 'p_organization_id: '||p_organization_id );
1084: fnd_file.PUT_LINE( fnd_file.LOG, 'p_process_id: '||p_process_id );
1085: fnd_file.PUT_LINE( fnd_file.LOG, 'p_risk_id: '||p_risk_id );
1086: fnd_file.PUT_LINE( fnd_file.LOG, 'p_batch_id: '||p_batch_id );

Line 1083: fnd_file.PUT_LINE( fnd_file.LOG, 'p_organization_id: '||p_organization_id );

1079: fnd_file.put_line( fnd_file.Log, 'VALUES GOT --> ');
1080: fnd_file.PUT_LINE( fnd_file.LOG, 'p_batch_id: '||p_batch_id );
1081: fnd_file.PUT_LINE( fnd_file.LOG, 'p_rcm_org_intf_id: '||p_rcm_org_intf_id );
1082: fnd_file.PUT_LINE( fnd_file.LOG, 'p_process_organization_id: '||p_process_organization_id );
1083: fnd_file.PUT_LINE( fnd_file.LOG, 'p_organization_id: '||p_organization_id );
1084: fnd_file.PUT_LINE( fnd_file.LOG, 'p_process_id: '||p_process_id );
1085: fnd_file.PUT_LINE( fnd_file.LOG, 'p_risk_id: '||p_risk_id );
1086: fnd_file.PUT_LINE( fnd_file.LOG, 'p_batch_id: '||p_batch_id );
1087: fnd_file.PUT_LINE( fnd_file.LOG, 'p_control_id: '||p_control_id );

Line 1084: fnd_file.PUT_LINE( fnd_file.LOG, 'p_process_id: '||p_process_id );

1080: fnd_file.PUT_LINE( fnd_file.LOG, 'p_batch_id: '||p_batch_id );
1081: fnd_file.PUT_LINE( fnd_file.LOG, 'p_rcm_org_intf_id: '||p_rcm_org_intf_id );
1082: fnd_file.PUT_LINE( fnd_file.LOG, 'p_process_organization_id: '||p_process_organization_id );
1083: fnd_file.PUT_LINE( fnd_file.LOG, 'p_organization_id: '||p_organization_id );
1084: fnd_file.PUT_LINE( fnd_file.LOG, 'p_process_id: '||p_process_id );
1085: fnd_file.PUT_LINE( fnd_file.LOG, 'p_risk_id: '||p_risk_id );
1086: fnd_file.PUT_LINE( fnd_file.LOG, 'p_batch_id: '||p_batch_id );
1087: fnd_file.PUT_LINE( fnd_file.LOG, 'p_control_id: '||p_control_id );
1088:

Line 1085: fnd_file.PUT_LINE( fnd_file.LOG, 'p_risk_id: '||p_risk_id );

1081: fnd_file.PUT_LINE( fnd_file.LOG, 'p_rcm_org_intf_id: '||p_rcm_org_intf_id );
1082: fnd_file.PUT_LINE( fnd_file.LOG, 'p_process_organization_id: '||p_process_organization_id );
1083: fnd_file.PUT_LINE( fnd_file.LOG, 'p_organization_id: '||p_organization_id );
1084: fnd_file.PUT_LINE( fnd_file.LOG, 'p_process_id: '||p_process_id );
1085: fnd_file.PUT_LINE( fnd_file.LOG, 'p_risk_id: '||p_risk_id );
1086: fnd_file.PUT_LINE( fnd_file.LOG, 'p_batch_id: '||p_batch_id );
1087: fnd_file.PUT_LINE( fnd_file.LOG, 'p_control_id: '||p_control_id );
1088:
1089: begin

Line 1086: fnd_file.PUT_LINE( fnd_file.LOG, 'p_batch_id: '||p_batch_id );

1082: fnd_file.PUT_LINE( fnd_file.LOG, 'p_process_organization_id: '||p_process_organization_id );
1083: fnd_file.PUT_LINE( fnd_file.LOG, 'p_organization_id: '||p_organization_id );
1084: fnd_file.PUT_LINE( fnd_file.LOG, 'p_process_id: '||p_process_id );
1085: fnd_file.PUT_LINE( fnd_file.LOG, 'p_risk_id: '||p_risk_id );
1086: fnd_file.PUT_LINE( fnd_file.LOG, 'p_batch_id: '||p_batch_id );
1087: fnd_file.PUT_LINE( fnd_file.LOG, 'p_control_id: '||p_control_id );
1088:
1089: begin
1090: select risk_association_id

Line 1087: fnd_file.PUT_LINE( fnd_file.LOG, 'p_control_id: '||p_control_id );

1083: fnd_file.PUT_LINE( fnd_file.LOG, 'p_organization_id: '||p_organization_id );
1084: fnd_file.PUT_LINE( fnd_file.LOG, 'p_process_id: '||p_process_id );
1085: fnd_file.PUT_LINE( fnd_file.LOG, 'p_risk_id: '||p_risk_id );
1086: fnd_file.PUT_LINE( fnd_file.LOG, 'p_batch_id: '||p_batch_id );
1087: fnd_file.PUT_LINE( fnd_file.LOG, 'p_control_id: '||p_control_id );
1088:
1089: begin
1090: select risk_association_id
1091: into l_risk_association_id

Line 1100: fnd_file.put_line(fnd_file.LOG, 'After Select, l_risk_association_id: '||l_risk_association_id);

1096:
1097: open c1(p_batch_id,p_rcm_org_intf_id);
1098: fetch c1 into l_c1_type;
1099: close c1;
1100: fnd_file.put_line(fnd_file.LOG, 'After Select, l_risk_association_id: '||l_risk_association_id);
1101: fnd_file.put_line(fnd_file.LOG, 'UPDATING AMW_RISK_ASSOCIATIONS');
1102: UPDATE AMW_RISK_ASSOCIATIONS
1103: SET OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
1104: ,RISK_LIKELIHOOD_CODE=L_C1_TYPE.RISK_LIKELIHOOD_CODE

Line 1101: fnd_file.put_line(fnd_file.LOG, 'UPDATING AMW_RISK_ASSOCIATIONS');

1097: open c1(p_batch_id,p_rcm_org_intf_id);
1098: fetch c1 into l_c1_type;
1099: close c1;
1100: fnd_file.put_line(fnd_file.LOG, 'After Select, l_risk_association_id: '||l_risk_association_id);
1101: fnd_file.put_line(fnd_file.LOG, 'UPDATING AMW_RISK_ASSOCIATIONS');
1102: UPDATE AMW_RISK_ASSOCIATIONS
1103: SET OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
1104: ,RISK_LIKELIHOOD_CODE=L_C1_TYPE.RISK_LIKELIHOOD_CODE
1105: ,RISK_IMPACT_CODE=L_C1_TYPE.RISK_IMPACT_CODE

Line 1113: fnd_file.put_line(fnd_file.LOG, 'UPDATED AMW_RISK_ASSOCIATIONS');

1109: ,LAST_UPDATED_BY=G_USER_ID
1110: ,LAST_UPDATE_LOGIN=G_LOGIN_ID
1111: WHERE RISK_ASSOCIATION_ID=L_RISK_ASSOCIATION_ID;
1112:
1113: fnd_file.put_line(fnd_file.LOG, 'UPDATED AMW_RISK_ASSOCIATIONS');
1114:
1115: exception
1116: when no_data_found then
1117: fnd_file.put_line(fnd_file.LOG, 'INSIDE NO_DATA_FOUND');

Line 1117: fnd_file.put_line(fnd_file.LOG, 'INSIDE NO_DATA_FOUND');

1113: fnd_file.put_line(fnd_file.LOG, 'UPDATED AMW_RISK_ASSOCIATIONS');
1114:
1115: exception
1116: when no_data_found then
1117: fnd_file.put_line(fnd_file.LOG, 'INSIDE NO_DATA_FOUND');
1118: select amw_risk_associations_s.nextval into l_risk_association_id from dual;
1119:
1120: open c1(p_batch_id,p_rcm_org_intf_id);
1121: fetch c1 into l_c1_type;

Line 1124: fnd_file.put_line(fnd_file.LOG, 'VALUES TO BE INSERTED INTO AMW_RISK_ASSOCIATIONS');

1120: open c1(p_batch_id,p_rcm_org_intf_id);
1121: fetch c1 into l_c1_type;
1122: close c1;
1123:
1124: fnd_file.put_line(fnd_file.LOG, 'VALUES TO BE INSERTED INTO AMW_RISK_ASSOCIATIONS');
1125: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_association_id: '||l_risk_association_id);
1126: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_id: '||p_risk_id);
1127: FND_FILE.PUT_LINE(FND_FILE.LOG, 'pk1: '||p_process_organization_id);
1128: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_likelihood_code: '||l_c1_type.risk_likelihood_code);

Line 1125: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_association_id: '||l_risk_association_id);

1121: fetch c1 into l_c1_type;
1122: close c1;
1123:
1124: fnd_file.put_line(fnd_file.LOG, 'VALUES TO BE INSERTED INTO AMW_RISK_ASSOCIATIONS');
1125: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_association_id: '||l_risk_association_id);
1126: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_id: '||p_risk_id);
1127: FND_FILE.PUT_LINE(FND_FILE.LOG, 'pk1: '||p_process_organization_id);
1128: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_likelihood_code: '||l_c1_type.risk_likelihood_code);
1129: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_IMPACT_code: '||l_c1_type.risk_IMPACT_code);

Line 1126: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_id: '||p_risk_id);

1122: close c1;
1123:
1124: fnd_file.put_line(fnd_file.LOG, 'VALUES TO BE INSERTED INTO AMW_RISK_ASSOCIATIONS');
1125: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_association_id: '||l_risk_association_id);
1126: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_id: '||p_risk_id);
1127: FND_FILE.PUT_LINE(FND_FILE.LOG, 'pk1: '||p_process_organization_id);
1128: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_likelihood_code: '||l_c1_type.risk_likelihood_code);
1129: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_IMPACT_code: '||l_c1_type.risk_IMPACT_code);
1130: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATERIAL: '||l_c1_type.material);

Line 1127: FND_FILE.PUT_LINE(FND_FILE.LOG, 'pk1: '||p_process_organization_id);

1123:
1124: fnd_file.put_line(fnd_file.LOG, 'VALUES TO BE INSERTED INTO AMW_RISK_ASSOCIATIONS');
1125: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_association_id: '||l_risk_association_id);
1126: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_id: '||p_risk_id);
1127: FND_FILE.PUT_LINE(FND_FILE.LOG, 'pk1: '||p_process_organization_id);
1128: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_likelihood_code: '||l_c1_type.risk_likelihood_code);
1129: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_IMPACT_code: '||l_c1_type.risk_IMPACT_code);
1130: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATERIAL: '||l_c1_type.material);
1131: FND_FILE.PUT_LINE(FND_FILE.LOG, 'material_value: '||l_c1_type.material_value);

Line 1128: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_likelihood_code: '||l_c1_type.risk_likelihood_code);

1124: fnd_file.put_line(fnd_file.LOG, 'VALUES TO BE INSERTED INTO AMW_RISK_ASSOCIATIONS');
1125: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_association_id: '||l_risk_association_id);
1126: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_id: '||p_risk_id);
1127: FND_FILE.PUT_LINE(FND_FILE.LOG, 'pk1: '||p_process_organization_id);
1128: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_likelihood_code: '||l_c1_type.risk_likelihood_code);
1129: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_IMPACT_code: '||l_c1_type.risk_IMPACT_code);
1130: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATERIAL: '||l_c1_type.material);
1131: FND_FILE.PUT_LINE(FND_FILE.LOG, 'material_value: '||l_c1_type.material_value);
1132:

Line 1129: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_IMPACT_code: '||l_c1_type.risk_IMPACT_code);

1125: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_association_id: '||l_risk_association_id);
1126: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_id: '||p_risk_id);
1127: FND_FILE.PUT_LINE(FND_FILE.LOG, 'pk1: '||p_process_organization_id);
1128: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_likelihood_code: '||l_c1_type.risk_likelihood_code);
1129: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_IMPACT_code: '||l_c1_type.risk_IMPACT_code);
1130: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATERIAL: '||l_c1_type.material);
1131: FND_FILE.PUT_LINE(FND_FILE.LOG, 'material_value: '||l_c1_type.material_value);
1132:
1133: insert into amw_risk_associations(risk_association_id,

Line 1130: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATERIAL: '||l_c1_type.material);

1126: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_id: '||p_risk_id);
1127: FND_FILE.PUT_LINE(FND_FILE.LOG, 'pk1: '||p_process_organization_id);
1128: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_likelihood_code: '||l_c1_type.risk_likelihood_code);
1129: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_IMPACT_code: '||l_c1_type.risk_IMPACT_code);
1130: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATERIAL: '||l_c1_type.material);
1131: FND_FILE.PUT_LINE(FND_FILE.LOG, 'material_value: '||l_c1_type.material_value);
1132:
1133: insert into amw_risk_associations(risk_association_id,
1134: last_update_date,

Line 1131: FND_FILE.PUT_LINE(FND_FILE.LOG, 'material_value: '||l_c1_type.material_value);

1127: FND_FILE.PUT_LINE(FND_FILE.LOG, 'pk1: '||p_process_organization_id);
1128: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_likelihood_code: '||l_c1_type.risk_likelihood_code);
1129: FND_FILE.PUT_LINE(FND_FILE.LOG, 'risk_IMPACT_code: '||l_c1_type.risk_IMPACT_code);
1130: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MATERIAL: '||l_c1_type.material);
1131: FND_FILE.PUT_LINE(FND_FILE.LOG, 'material_value: '||l_c1_type.material_value);
1132:
1133: insert into amw_risk_associations(risk_association_id,
1134: last_update_date,
1135: last_updated_by,

Line 1165: fnd_file.PUT_LINE( fnd_file.LOG, 'l_risk_association_id: '||l_risk_association_id);

1161: l_c1_type.risk_impact_code,
1162: l_c1_type.material,
1163: l_c1_type.material_value);
1164: end;
1165: fnd_file.PUT_LINE( fnd_file.LOG, 'l_risk_association_id: '||l_risk_association_id);
1166:
1167: if(p_control_id is not null) then
1168: FND_FILE.PUT_LINE( FND_FILE.LOG, '@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@' );
1169: FND_FILE.PUT_LINE( FND_FILE.LOG, 'DOING CONTROL ASSOCIATIONS HERE' );

Line 1168: FND_FILE.PUT_LINE( FND_FILE.LOG, '@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@' );

1164: end;
1165: fnd_file.PUT_LINE( fnd_file.LOG, 'l_risk_association_id: '||l_risk_association_id);
1166:
1167: if(p_control_id is not null) then
1168: FND_FILE.PUT_LINE( FND_FILE.LOG, '@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@' );
1169: FND_FILE.PUT_LINE( FND_FILE.LOG, 'DOING CONTROL ASSOCIATIONS HERE' );
1170: begin
1171: select CONTROL_association_id
1172: into l_CONTROL_association_id

Line 1169: FND_FILE.PUT_LINE( FND_FILE.LOG, 'DOING CONTROL ASSOCIATIONS HERE' );

1165: fnd_file.PUT_LINE( fnd_file.LOG, 'l_risk_association_id: '||l_risk_association_id);
1166:
1167: if(p_control_id is not null) then
1168: FND_FILE.PUT_LINE( FND_FILE.LOG, '@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@' );
1169: FND_FILE.PUT_LINE( FND_FILE.LOG, 'DOING CONTROL ASSOCIATIONS HERE' );
1170: begin
1171: select CONTROL_association_id
1172: into l_CONTROL_association_id
1173: from amw_CONTROL_associations

Line 1178: fnd_file.put_line(fnd_file.LOG, 'After Select, l_CONTROL_association_id: '||l_CONTROL_association_id);

1174: where object_type='RISK_ORG'
1175: and pk1=l_risk_association_id
1176: and CONTROL_id=p_CONTROL_id;
1177:
1178: fnd_file.put_line(fnd_file.LOG, 'After Select, l_CONTROL_association_id: '||l_CONTROL_association_id);
1179:
1180: exception
1181: when no_data_found then
1182: fnd_file.put_line(fnd_file.LOG, 'INSIDE NO_DATA_FOUND');

Line 1182: fnd_file.put_line(fnd_file.LOG, 'INSIDE NO_DATA_FOUND');

1178: fnd_file.put_line(fnd_file.LOG, 'After Select, l_CONTROL_association_id: '||l_CONTROL_association_id);
1179:
1180: exception
1181: when no_data_found then
1182: fnd_file.put_line(fnd_file.LOG, 'INSIDE NO_DATA_FOUND');
1183: select amw_CONTROL_associations_s.nextval into l_CONTROL_association_id from dual;
1184:
1185: fnd_file.put_line(fnd_file.LOG, 'VALUES TO BE INSERTED INTO AMW_CONTROL_ASSOCIATIONS');
1186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CONTROL_association_id: '||l_CONTROL_association_id);

Line 1185: fnd_file.put_line(fnd_file.LOG, 'VALUES TO BE INSERTED INTO AMW_CONTROL_ASSOCIATIONS');

1181: when no_data_found then
1182: fnd_file.put_line(fnd_file.LOG, 'INSIDE NO_DATA_FOUND');
1183: select amw_CONTROL_associations_s.nextval into l_CONTROL_association_id from dual;
1184:
1185: fnd_file.put_line(fnd_file.LOG, 'VALUES TO BE INSERTED INTO AMW_CONTROL_ASSOCIATIONS');
1186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CONTROL_association_id: '||l_CONTROL_association_id);
1187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CONTROL_id: '||p_CONTROL_id);
1188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'pk1: '||l_risk_association_id);
1189:

Line 1186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CONTROL_association_id: '||l_CONTROL_association_id);

1182: fnd_file.put_line(fnd_file.LOG, 'INSIDE NO_DATA_FOUND');
1183: select amw_CONTROL_associations_s.nextval into l_CONTROL_association_id from dual;
1184:
1185: fnd_file.put_line(fnd_file.LOG, 'VALUES TO BE INSERTED INTO AMW_CONTROL_ASSOCIATIONS');
1186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CONTROL_association_id: '||l_CONTROL_association_id);
1187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CONTROL_id: '||p_CONTROL_id);
1188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'pk1: '||l_risk_association_id);
1189:
1190: insert into amw_CONTROL_associations(CONTROL_association_id,

Line 1187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CONTROL_id: '||p_CONTROL_id);

1183: select amw_CONTROL_associations_s.nextval into l_CONTROL_association_id from dual;
1184:
1185: fnd_file.put_line(fnd_file.LOG, 'VALUES TO BE INSERTED INTO AMW_CONTROL_ASSOCIATIONS');
1186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CONTROL_association_id: '||l_CONTROL_association_id);
1187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CONTROL_id: '||p_CONTROL_id);
1188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'pk1: '||l_risk_association_id);
1189:
1190: insert into amw_CONTROL_associations(CONTROL_association_id,
1191: last_update_date,

Line 1188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'pk1: '||l_risk_association_id);

1184:
1185: fnd_file.put_line(fnd_file.LOG, 'VALUES TO BE INSERTED INTO AMW_CONTROL_ASSOCIATIONS');
1186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CONTROL_association_id: '||l_CONTROL_association_id);
1187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CONTROL_id: '||p_CONTROL_id);
1188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'pk1: '||l_risk_association_id);
1189:
1190: insert into amw_CONTROL_associations(CONTROL_association_id,
1191: last_update_date,
1192: last_updated_by,

Line 1215: fnd_file.PUT_LINE( fnd_file.LOG, 'CANNOT DO CONTROL ASSOCIATIONS, BECAUSE CONTROL_ID IS NULL --> CONTROL_ID: '||P_CONTROL_ID);

1211: 1,
1212: sysdate);
1213: end;
1214: else
1215: fnd_file.PUT_LINE( fnd_file.LOG, 'CANNOT DO CONTROL ASSOCIATIONS, BECAUSE CONTROL_ID IS NULL --> CONTROL_ID: '||P_CONTROL_ID);
1216: end if;
1217:
1218: /*
1219: open c2(p_batch_id,p_rcm_org_intf_id);