DBA Data[Home] [Help]

APPS.AMW_LOAD_RCM_ORG_DATA dependencies on FND_API

Line 452: p_encoded => fnd_api.g_false);

448: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_PENDING_CHANGE_ERROR',
449: p_token_name => 'OBJ_TYPE',
450: p_token_value => AMW_UTILITY_PVT.GET_LOOKUP_MEANING('AMW_OBJECT_TYPE','RISK'));
451: v_risk_pending_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_LAST,
452: p_encoded => fnd_api.g_false);
453:
454: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_PENDING_CHANGE_ERROR',
455: p_token_name => 'OBJ_TYPE',
456: p_token_value => AMW_UTILITY_PVT.GET_LOOKUP_MEANING('AMW_OBJECT_TYPE','CTRL'));

Line 458: p_encoded => fnd_api.g_false);

454: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_PENDING_CHANGE_ERROR',
455: p_token_name => 'OBJ_TYPE',
456: p_token_value => AMW_UTILITY_PVT.GET_LOOKUP_MEANING('AMW_OBJECT_TYPE','CTRL'));
457: v_control_pending_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_LAST,
458: p_encoded => fnd_api.g_false);
459:
460: ---
461: ---NPANANDI 11.23.2004
462: ---CHECK THE DATA VALIDITY BETWEEN ORGANIZATION_ID,PROCESS_CODE,PROCESS_NAME,PROCESS_ID

Line 621: p_init_msg_list => FND_API.G_TRUE,

617: l_risk_rec.classification := rc_rec.risk_classification;
618:
619: AMW_RISK_PVT.Load_Risk(
620: p_api_version_number => l_api_version_number,
621: p_init_msg_list => FND_API.G_TRUE,
622: p_commit => FND_API.G_FALSE,
623: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
624: p_risk_rec => l_risk_rec,
625: x_return_status => lx_return_status,

Line 622: p_commit => FND_API.G_FALSE,

618:
619: AMW_RISK_PVT.Load_Risk(
620: p_api_version_number => l_api_version_number,
621: p_init_msg_list => FND_API.G_TRUE,
622: p_commit => FND_API.G_FALSE,
623: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
624: p_risk_rec => l_risk_rec,
625: x_return_status => lx_return_status,
626: x_msg_count => lx_msg_count,

Line 623: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

619: AMW_RISK_PVT.Load_Risk(
620: p_api_version_number => l_api_version_number,
621: p_init_msg_list => FND_API.G_TRUE,
622: p_commit => FND_API.G_FALSE,
623: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
624: p_risk_rec => l_risk_rec,
625: x_return_status => lx_return_status,
626: x_msg_count => lx_msg_count,
627: x_msg_data => lx_msg_data,

Line 646: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then

642: fnd_file.put_line (fnd_file.LOG,'lx_return_status: '||lx_return_status);
643: fnd_file.put_line (fnd_file.LOG,'lx_risk_rev_id: '||lx_risk_rev_id);
644: fnd_file.put_line (fnd_file.LOG,'lx_risk_id: '||lx_risk_id);
645:
646: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then
647: v_err_msg := ' ';
648: FOR x IN 1..lx_msg_count LOOP
649: if(length(v_err_msg) < 1800) then
650: v_err_msg := v_err_msg||' '||substr(fnd_msg_pub.get(p_msg_index => x,

Line 651: p_encoded => fnd_api.g_false), 1,100);

647: v_err_msg := ' ';
648: FOR x IN 1..lx_msg_count LOOP
649: if(length(v_err_msg) < 1800) then
650: v_err_msg := v_err_msg||' '||substr(fnd_msg_pub.get(p_msg_index => x,
651: p_encoded => fnd_api.g_false), 1,100);
652: end if;
653: END LOOP;
654: update_interface_with_error (v_err_msg
655: ,'AMW_RISKS'

Line 885: p_init_msg_list => FND_API.G_TRUE,

881:
882:
883: AMW_CONTROL_PVT.Load_Control(
884: p_api_version_number => l_api_version_number,
885: p_init_msg_list => FND_API.G_TRUE,
886: p_commit => FND_API.G_FALSE,
887: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
888: p_control_rec => l_control_rec,
889: x_return_status => lx_return_status,

Line 886: p_commit => FND_API.G_FALSE,

882:
883: AMW_CONTROL_PVT.Load_Control(
884: p_api_version_number => l_api_version_number,
885: p_init_msg_list => FND_API.G_TRUE,
886: p_commit => FND_API.G_FALSE,
887: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
888: p_control_rec => l_control_rec,
889: x_return_status => lx_return_status,
890: x_msg_count => lx_msg_count,

Line 887: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

883: AMW_CONTROL_PVT.Load_Control(
884: p_api_version_number => l_api_version_number,
885: p_init_msg_list => FND_API.G_TRUE,
886: p_commit => FND_API.G_FALSE,
887: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
888: p_control_rec => l_control_rec,
889: x_return_status => lx_return_status,
890: x_msg_count => lx_msg_count,
891: x_msg_data => lx_msg_data,

Line 911: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then

907: fnd_file.put_line (fnd_file.LOG,'lx_return_status: '||lx_return_status);
908: fnd_file.put_line (fnd_file.LOG,'lx_risk_rev_id: '||lx_risk_rev_id);
909: fnd_file.put_line (fnd_file.LOG,'vx_control_rev_id: '||vx_control_rev_id);
910:
911: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then
912: v_err_msg := ' ';
913: FOR x IN 1..lx_msg_count LOOP
914: if(length(v_err_msg) < 1800) then
915: v_err_msg := v_err_msg||' '||substr(fnd_msg_pub.get(p_msg_index => x,

Line 916: p_encoded => fnd_api.g_false), 1,100);

912: v_err_msg := ' ';
913: FOR x IN 1..lx_msg_count LOOP
914: if(length(v_err_msg) < 1800) then
915: v_err_msg := v_err_msg||' '||substr(fnd_msg_pub.get(p_msg_index => x,
916: p_encoded => fnd_api.g_false), 1,100);
917: end if;
918: END LOOP;
919: update_interface_with_error (v_err_msg
920: ,'AMW_CONTROLS'

Line 1246: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then

1242: ,X_RETURN_STATUS => LX_RETURN_STATUS
1243: ,X_MSG_COUNT => LX_MSG_COUNT
1244: ,X_MSG_DATA => LX_MSG_DATA
1245: );
1246: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then
1247: v_err_msg := ' ';
1248: FOR x IN 1..lx_msg_count LOOP
1249: if(length(v_err_msg) < 1800) then
1250: v_err_msg := v_err_msg||' '||substr(

Line 1252: p_encoded => fnd_api.g_false), 1,100);

1248: FOR x IN 1..lx_msg_count LOOP
1249: if(length(v_err_msg) < 1800) then
1250: v_err_msg := v_err_msg||' '||substr(
1251: fnd_msg_pub.get(p_msg_index => x,
1252: p_encoded => fnd_api.g_false), 1,100);
1253: end if;
1254: END LOOP;
1255: update_interface_with_error (v_err_msg
1256: ,'AMW_AP_ASSOCIATIONS'

Line 1287: lx_return_status := FND_API.G_RET_STS_SUCCESS;

1283:
1284: --
1285: --CREATE PROCESS OBJECTIVE STARTS HERE
1286: --
1287: lx_return_status := FND_API.G_RET_STS_SUCCESS;
1288: ---Process_Objective_Id being reset here
1289: ---because for this loop, it is different
1290: vx_process_objective_id := null;
1291:

Line 1308: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then

1304:
1305: fnd_file.put_line(fnd_file.LOG,'########## After Going to Create_Process_Objectives');
1306: fnd_file.put_line(fnd_file.LOG,'vx_process_objective_id: '||vx_process_objective_id);
1307:
1308: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then
1309: v_err_msg := ' ';
1310: FOR x IN 1..lx_msg_count LOOP
1311: if(length(v_err_msg) < 1800) then
1312: v_err_msg := v_err_msg||' '||substr(fnd_msg_pub.get(p_msg_index => x,

Line 1313: p_encoded => fnd_api.g_false), 1,100);

1309: v_err_msg := ' ';
1310: FOR x IN 1..lx_msg_count LOOP
1311: if(length(v_err_msg) < 1800) then
1312: v_err_msg := v_err_msg||' '||substr(fnd_msg_pub.get(p_msg_index => x,
1313: p_encoded => fnd_api.g_false), 1,100);
1314: end if;
1315: END LOOP;
1316: update_interface_with_error (v_err_msg
1317: ,'AMW_PROCESS_OBJECTIVES'

Line 2007: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2003: where PROCESS_OBJECTIVE_ID = l_get_objective.process_objective_id
2004: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
2005:
2006: if (sql%notfound) then
2007: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2008: end if;
2009:
2010: end if;
2011:

Line 2015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2011:
2012: fnd_file.put_line(fnd_file.log,'~~~~~~~~~~~~~~~~~~~~~~ create_process_objectives: END');
2013:
2014: EXCEPTION
2015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2017: v_err_msg :=
2018: 'Error working in procedure Create_Process_Objectives: '
2019: || 'Process_Objective_Name: '

Line 2016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2012: fnd_file.put_line(fnd_file.log,'~~~~~~~~~~~~~~~~~~~~~~ create_process_objectives: END');
2013:
2014: EXCEPTION
2015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2017: v_err_msg :=
2018: 'Error working in procedure Create_Process_Objectives: '
2019: || 'Process_Objective_Name: '
2020: || p_process_objective_name

Line 2033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2029: ,v_interface_id
2030: );
2031:
2032: WHEN OTHERS THEN
2033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2034: v_err_msg :=
2035: 'Error working in procedure Create_Process_Objectives: '
2036: || 'Process_Objective_Name: '
2037: || p_process_objective_name

Line 2783: p_init_msg_list => FND_API.G_TRUE,

2779: --NPANANDI 12.09.2004: CALLING REVISE_AP FOR CHANGED DATAMODEL
2780: --
2781: AMW_AUDIT_PROCEDURES_PVT.Revise_Ap_If_Necessary(
2782: p_api_version_number => 1,
2783: p_init_msg_list => FND_API.G_TRUE,
2784: P_audit_procedure_id => P_audit_procedure_id,
2785: x_return_status => x_return_status,
2786: x_msg_count => x_msg_count,
2787: x_msg_data => x_msg_data);

Line 2789: IF(x_return_status = FND_API.G_RET_STS_SUCCESS)THEN

2785: x_return_status => x_return_status,
2786: x_msg_count => x_msg_count,
2787: x_msg_data => x_msg_data);
2788:
2789: IF(x_return_status = FND_API.G_RET_STS_SUCCESS)THEN
2790: CREATE_AMW_AP_ASSOC(
2791: P_PK1 => P_CONTROL_ID
2792: ,P_PK2 => NULL
2793: ,P_PK3 => NULL