DBA Data[Home] [Help]

APPS.AMW_RISK_APPROVAL_PVT dependencies on FND_API

Line 1003: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,

999: avalue => l_risk_name
1000: );
1001: resultout := 'COMPLETE:SUCCESS';
1002: ELSE
1003: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
1004: p_count => l_msg_count,
1005: p_data => l_msg_data
1006: );
1007: amw_gen_approval_pvt.handle_err

Line 1023: -- RAISE FND_API.G_EXC_ERROR;

1019: itemkey,
1020: actid,
1021: l_error_msg
1022: );
1023: -- RAISE FND_API.G_EXC_ERROR;
1024: resultout := 'COMPLETE:ERROR';
1025: END IF;
1026: --
1027: -- CANCEL mode

Line 1042: WHEN fnd_api.g_exc_error THEN

1038: RETURN;
1039: END IF;
1040: --
1041: EXCEPTION
1042: WHEN fnd_api.g_exc_error THEN
1043: wf_core.CONTEXT ('amw_riskApproval_pvt',
1044: 'Set_risk_OBJECT_Details',
1045: itemtype,
1046: itemkey,

Line 1053: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,

1049: l_error_msg
1050: );
1051: RAISE;
1052: WHEN OTHERS THEN
1053: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
1054: p_count => l_msg_count,
1055: p_data => l_msg_data
1056: );
1057: RAISE;

Line 1093: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

1089: funcmode IN VARCHAR2,
1090: resultout OUT NOCOPY VARCHAR2
1091: ) IS
1092: l_status_code VARCHAR2 (30);
1093: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
1094: l_msg_count NUMBER;
1095: l_msg_data VARCHAR2 (4000);
1096: l_api_name CONSTANT VARCHAR2 (30) := 'Update_risk_Status';
1097: l_full_name CONSTANT VARCHAR2 (60)

Line 1103: l_validation_level NUMBER := fnd_api.g_valid_level_full;

1099: l_update_status VARCHAR2 (12);
1100: l_error_msg VARCHAR2 (4000);
1101: l_object_version_number NUMBER;
1102: l_risk_rev_id NUMBER;
1103: l_validation_level NUMBER := fnd_api.g_valid_level_full;
1104: l_approver VARCHAR2 (320);
1105: l_requestor_id NUMBER;
1106: l_approver_id NUMBER;
1107: l_old_appr_risk_rev_id NUMBER;

Line 1211: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1207: END IF;
1208: /**************************IS THIS REQUIRED********************/
1209: /*
1210: --amw_risks_pkg.update_RISK (
1211: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1212: IF G_DEBUG THEN
1213: amw_utility_pvt.debug_message(l_full_name || ' failed to update RISK to status ' || l_status_code);
1214: END IF;
1215: amw_gen_approval_pvt.handle_err (

Line 1248: p_encoded=> fnd_api.g_false,

1244: RETURN;
1245: END IF;
1246: /*
1247: fnd_msg_pub.count_and_get (
1248: p_encoded=> fnd_api.g_false,
1249: p_count=> l_msg_count,
1250: p_data=> l_msg_data
1251: );
1252: IF G_DEBUG THEN

Line 1264: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,

1260: EXCEPTION
1261: WHEN OTHERS THEN
1262: ROLLBACK TO update_risk_status;
1263: resultout := 'COMPLETE:ERROR';
1264: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
1265: p_count => l_msg_count,
1266: p_data => l_msg_data
1267: );
1268: amw_gen_approval_pvt.handle_err