DBA Data[Home] [Help]

APPS.AMW_LOAD_RC_DATA dependencies on FND_API

Line 452: p_encoded => fnd_api.g_false);

448: p_token_name => 'OBJ_TYPE',
449: p_token_value =>
450: 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 =>

Line 459: p_encoded => fnd_api.g_false);

455: p_token_name => 'OBJ_TYPE',
456: p_token_value =>
457: AMW_UTILITY_PVT.GET_LOOKUP_MEANING('AMW_OBJECT_TYPE','CTRL'));
458: v_control_pending_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_LAST,
459: p_encoded => fnd_api.g_false);
460:
461:
462: ---
463: ---NPANANDI 11.24.2004

Line 598: p_init_msg_list => FND_API.G_TRUE,

594: l_risk_rec.risk_type := 'C';
595:
596: AMW_RISK_PVT.Load_Risk(
597: p_api_version_number => l_api_version_number,
598: p_init_msg_list => FND_API.G_TRUE,
599: p_commit => FND_API.G_FALSE,
600: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
601: p_risk_rec => l_risk_rec,
602: x_return_status => lx_return_status,

Line 599: p_commit => FND_API.G_FALSE,

595:
596: AMW_RISK_PVT.Load_Risk(
597: p_api_version_number => l_api_version_number,
598: p_init_msg_list => FND_API.G_TRUE,
599: p_commit => FND_API.G_FALSE,
600: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
601: p_risk_rec => l_risk_rec,
602: x_return_status => lx_return_status,
603: x_msg_count => lx_msg_count,

Line 600: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

596: AMW_RISK_PVT.Load_Risk(
597: p_api_version_number => l_api_version_number,
598: p_init_msg_list => FND_API.G_TRUE,
599: p_commit => FND_API.G_FALSE,
600: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
601: p_risk_rec => l_risk_rec,
602: x_return_status => lx_return_status,
603: x_msg_count => lx_msg_count,
604: x_msg_data => lx_msg_data,

Line 624: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then

620: fnd_file.put_line (fnd_file.LOG,'lx_return_status: '||lx_return_status);
621: fnd_file.put_line (fnd_file.LOG,'lx_risk_rev_id: '||lx_risk_rev_id);
622: fnd_file.put_line (fnd_file.LOG,'lx_risk_id: '||lx_risk_id);
623:
624: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then
625: v_err_msg := ' ';
626: FOR x IN 1..lx_msg_count LOOP
627: if(length(v_err_msg) < 1800) then
628: v_err_msg := v_err_msg||' '||substr(fnd_msg_pub.get(p_msg_index => x,

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

625: v_err_msg := ' ';
626: FOR x IN 1..lx_msg_count LOOP
627: if(length(v_err_msg) < 1800) then
628: v_err_msg := v_err_msg||' '||substr(fnd_msg_pub.get(p_msg_index => x,
629: p_encoded => fnd_api.g_false), 1,100);
630: end if;
631: END LOOP;
632: update_interface_with_error (v_err_msg
633: ,'AMW_RISKS'

Line 868: p_init_msg_list => FND_API.G_TRUE,

864: l_control_rec.classification := rc_rec.ctrl_classification;
865: l_control_rec.uom_code := rc_rec.uom_code;
866: AMW_CONTROL_PVT.Load_Control(
867: p_api_version_number => l_api_version_number,
868: p_init_msg_list => FND_API.G_TRUE,
869: p_commit => FND_API.G_FALSE,
870: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
871: p_control_rec => l_control_rec,
872: x_return_status => lx_return_status,

Line 869: p_commit => FND_API.G_FALSE,

865: l_control_rec.uom_code := rc_rec.uom_code;
866: AMW_CONTROL_PVT.Load_Control(
867: p_api_version_number => l_api_version_number,
868: p_init_msg_list => FND_API.G_TRUE,
869: p_commit => FND_API.G_FALSE,
870: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
871: p_control_rec => l_control_rec,
872: x_return_status => lx_return_status,
873: x_msg_count => lx_msg_count,

Line 870: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

866: AMW_CONTROL_PVT.Load_Control(
867: p_api_version_number => l_api_version_number,
868: p_init_msg_list => FND_API.G_TRUE,
869: p_commit => FND_API.G_FALSE,
870: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
871: p_control_rec => l_control_rec,
872: x_return_status => lx_return_status,
873: x_msg_count => lx_msg_count,
874: x_msg_data => lx_msg_data,

Line 895: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then

891: fnd_file.put_line (fnd_file.LOG,'lx_return_status: '||lx_return_status);
892: fnd_file.put_line (fnd_file.LOG,'lx_risk_rev_id: '||lx_risk_rev_id);
893: fnd_file.put_line (fnd_file.LOG,'vx_control_rev_id: '||vx_control_rev_id);
894:
895: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then
896: v_err_msg := ' ';
897: FOR x IN 1..lx_msg_count LOOP
898: if(length(v_err_msg) < 1800) then
899: v_err_msg := v_err_msg||' '

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

897: FOR x IN 1..lx_msg_count LOOP
898: if(length(v_err_msg) < 1800) then
899: v_err_msg := v_err_msg||' '
900: ||substr(fnd_msg_pub.get(p_msg_index => x,
901: p_encoded => fnd_api.g_false), 1,100);
902: end if;
903: END LOOP;
904: update_interface_with_error (v_err_msg
905: ,'AMW_CONTROLS'

Line 1160: LX_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1156: --WHEN CTRL TO AP ASSOCIATION IS BEING DONE, POST AMW.D
1157: --AP NEEDS TO BE REVISED
1158: --THIS IS HANDLED IN CREATE_AMW_AP_ASSOC
1159: fnd_file.PUT_LINE(fnd_file.log, 'CREATE_AMW_AP_ASSOC START');
1160: LX_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1161: LX_MSG_COUNT := 0;
1162: LX_MSG_DATA := NULL;
1163: CREATE_AMW_AP_ASSOC(
1164: P_CONTROL_ID => lx_control_id

Line 1172: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then

1168: ,X_RETURN_STATUS => LX_RETURN_STATUS
1169: ,X_MSG_COUNT => LX_MSG_COUNT
1170: ,X_MSG_DATA => LX_MSG_DATA
1171: );
1172: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then
1173: v_err_msg := ' ';
1174: FOR x IN 1..lx_msg_count LOOP
1175: if(length(v_err_msg) < 1800) then
1176: v_err_msg := v_err_msg||' '||substr(

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

1174: FOR x IN 1..lx_msg_count LOOP
1175: if(length(v_err_msg) < 1800) then
1176: v_err_msg := v_err_msg||' '||substr(
1177: fnd_msg_pub.get(p_msg_index => x,
1178: p_encoded => fnd_api.g_false), 1,100);
1179: end if;
1180: END LOOP;
1181: update_interface_with_error (v_err_msg
1182: ,'AMW_AP_ASSOCIATIONS'

Line 1215: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then

1211: ,X_RETURN_STATUS => LX_RETURN_STATUS
1212: ,X_MSG_COUNT => LX_MSG_COUNT
1213: ,X_MSG_DATA => LX_MSG_DATA
1214: );
1215: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then
1216: v_err_msg := ' ';
1217: FOR x IN 1..lx_msg_count LOOP
1218: if(length(v_err_msg) < 1800) then
1219: v_err_msg := v_err_msg||' '||substr(

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

1217: FOR x IN 1..lx_msg_count LOOP
1218: if(length(v_err_msg) < 1800) then
1219: v_err_msg := v_err_msg||' '||substr(
1220: fnd_msg_pub.get(p_msg_index => x,
1221: p_encoded => fnd_api.g_false), 1,100);
1222: end if;
1223: END LOOP;
1224: update_interface_with_error (v_err_msg
1225: ,'AMW_AP_ASSOCIATIONS'

Line 1263: lx_return_status := FND_API.G_RET_STS_SUCCESS;

1259:
1260: --
1261: --create the Process_Objective
1262: --
1263: lx_return_status := FND_API.G_RET_STS_SUCCESS;
1264: vx_process_objective_id := null; ---Process_Objective_Id being reset here
1265: ---because for this loop, it is different
1266: l_process_obj_column := TRUE;
1267: if(rc_rec.process_objective_name is null or (trim(rc_rec.process_objective_name) = ''))then

Line 1284: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then

1280:
1281: fnd_file.put_line(fnd_file.LOG,'########## After Going to Create_Process_Objectives');
1282: fnd_file.put_line(fnd_file.LOG,'vx_process_objective_id: '||vx_process_objective_id);
1283:
1284: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then
1285: v_err_msg := ' ';
1286: FOR x IN 1..lx_msg_count LOOP
1287: if(length(v_err_msg) < 1800) then
1288: v_err_msg := v_err_msg||' '

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

1286: FOR x IN 1..lx_msg_count LOOP
1287: if(length(v_err_msg) < 1800) then
1288: v_err_msg := v_err_msg||' '
1289: ||substr(fnd_msg_pub.get(p_msg_index => x,
1290: p_encoded => fnd_api.g_false), 1,100);
1291: end if;
1292: END LOOP;
1293: update_interface_with_error (v_err_msg
1294: ,'AMW_PROCESS_OBJECTIVES'

Line 1881: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1877: where PROCESS_OBJECTIVE_ID = l_get_objective.process_objective_id
1878: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
1879:
1880: if (sql%notfound) then
1881: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1882: end if;
1883:
1884: end if;
1885:

Line 1889: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1885:
1886: fnd_file.put_line(fnd_file.log,'~~~~~~~~~~~~~~~~~~~~~~ create_process_objectives: END');
1887:
1888: EXCEPTION
1889: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1890: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1891: v_err_msg :=
1892: 'Error working in procedure Create_Process_Objectives: '
1893: || 'Process_Objective_Name: '

Line 1890: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1886: fnd_file.put_line(fnd_file.log,'~~~~~~~~~~~~~~~~~~~~~~ create_process_objectives: END');
1887:
1888: EXCEPTION
1889: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1890: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1891: v_err_msg :=
1892: 'Error working in procedure Create_Process_Objectives: '
1893: || 'Process_Objective_Name: '
1894: || p_process_objective_name

Line 1907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1903: ,v_interface_id
1904: );
1905:
1906: WHEN OTHERS THEN
1907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1908: v_err_msg :=
1909: 'Error working in procedure Create_Process_Objectives: '
1910: || 'Process_Objective_Name: '
1911: || p_process_objective_name

Line 2665: p_init_msg_list => FND_API.G_TRUE,

2661: --NPANANDI 12.09.2004: CALLING REVISE_AP FOR CHANGED DATAMODEL
2662: --
2663: AMW_AUDIT_PROCEDURES_PVT.Revise_Ap_If_Necessary(
2664: p_api_version_number => 1,
2665: p_init_msg_list => FND_API.G_TRUE,
2666: P_audit_procedure_id => P_audit_procedure_id,
2667: x_return_status => x_return_status,
2668: x_msg_count => x_msg_count,
2669: x_msg_data => x_msg_data

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

2668: x_msg_count => x_msg_count,
2669: x_msg_data => x_msg_data
2670: );
2671:
2672: IF(x_return_status = FND_API.G_RET_STS_SUCCESS)THEN
2673: INSERT INTO amw_ap_associations(
2674: ap_association_id
2675: ,last_update_date
2676: ,last_updated_by