DBA Data[Home] [Help]

APPS.CZ_MODEL_MIGRATION_PVT dependencies on FND_API

Line 90: x_status := FND_API.G_RET_STS_SUCCESS;

86: IF(x_run_id IS NULL)THEN
87: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;
88: END IF;
89:
90: x_status := FND_API.G_RET_STS_SUCCESS;
91:
92: FOR c_pub IN (SELECT publication_id FROM cz_model_publications
93: WHERE migration_group_id = p_request_id AND deleted_flag = '0' AND server_id <> '0')LOOP
94:

Line 97: IF l_status <> 'OK' THEN x_status := FND_API.G_RET_STS_ERROR; END IF;

93: WHERE migration_group_id = p_request_id AND deleted_flag = '0' AND server_id <> '0')LOOP
94:
95: cz_pb_mgr.publish_model(c_pub.publication_id, x_run_id, l_status);
96:
97: IF l_status <> 'OK' THEN x_status := FND_API.G_RET_STS_ERROR; END IF;
98: END LOOP;
99: EXCEPTION
100: WHEN OTHERS THEN
101: x_status := FND_API.G_RET_STS_ERROR;

Line 101: x_status := FND_API.G_RET_STS_ERROR;

97: IF l_status <> 'OK' THEN x_status := FND_API.G_RET_STS_ERROR; END IF;
98: END LOOP;
99: EXCEPTION
100: WHEN OTHERS THEN
101: x_status := FND_API.G_RET_STS_ERROR;
102: l_errbuf := SQLERRM;
103: cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);
104: END;
105: ---------------------------------------------------------------------------------------

Line 993: x_return_status := FND_API.G_RET_STS_SUCCESS;

989: BEGIN
990:
991:
992: FND_MSG_PUB.initialize;
993: x_return_status := FND_API.G_RET_STS_SUCCESS;
994:
995: --get the instance name(s) that has been converted
996: r_instance_name_tbl := get_target_name_if_converted();
997:

Line 1044: x_return_status := FND_API.G_RET_STS_ERROR;

1040: --if obselete exists
1041:
1042: IF (obselete_exists = '1') THEN
1043:
1044: x_return_status := FND_API.G_RET_STS_ERROR;
1045:
1046: --add message to the error stack
1047: CZ_UTILS.add_error_message_to_stack(p_message_name => 'CZ_OBSELETE_RECORDS_EXISTS',
1048: p_token_name1 => 'INSTANCE_NAME',

Line 1068: IF (p_commit_flag = FND_API.G_TRUE) THEN

1064: END LOOP;
1065:
1066: END IF;
1067:
1068: IF (p_commit_flag = FND_API.G_TRUE) THEN
1069: COMMIT;
1070: END IF;
1071:
1072: EXCEPTION